mysql_powfe.sql

来自「日常的办公系统 应用工作流框架等增加员工的基本信息、培训信息、奖罚信息、薪资信息」· SQL 代码 · 共 74 行

--
-- mysql db schema for SQLPasswd
--

--
-- $Id: mysql_powfe.sql,v 1.1 2004/06/26 13:45:50 jmettraux Exp $
--

-- 
-- creates a database only for this 'passwd'
-- it's adisable not to use the same db that Xdbc uses (expressions and 
-- workitems storage), nor the one that SqlHistory uses for its 
-- logging and tracing purposes.
--

drop database powfe;
create database powfe;


-- this user will have access to this db

-- use mysql;
-- 
-- insert into user 
--     (user, host, password) 
-- values 
--     ('powfe', '%', password('powfe'));
-- flush privileges;
--     
-- grant select, insert, update, delete on powfe.* to powfe;
-- flush privileges;



--
-- creates the necessary tables
--

use powfe;

-- create table puser
-- (
--     name varchar(100) not null,
--     
--     primary key (name)
-- );

create table pgranted
(
    username varchar(100) not null,
    grantname varchar(100) not null,

    primary key (username, grantname)
);

create table pgrant
(
    name varchar(100) not null,
    codebase varchar(255) not null,

    primary key (name)
);

create table pparameter
(
    pid int not null,
    pgroup varchar(100) not null,
    pkey varchar(100) not null,
    pval varchar(255) not null,

    primary key (pid, pgroup, pkey)
);