CMS.zip_cms_项目管理

USE db_CMS GO CREATE TABLE tb_permission( id int IDENTITY(1,1) not null, sysuser varchar(20) not null, password varchar(20) not null, cip varchar(20), cport int default'0', sip varchar(20), sport int default'0', state int default'0', advanced bit default'0', curuser bit default'0', remuser bit default'0', rempwd bit default'0', CONSTRAINT PK_tb_permission PRIMARY KEY CLUSTERED ( id ASC ) ) CREATE TABLE tb_employee( e_code varchar(5) not null, e_name nvarchar(4) not null, e_sex nchar(1), e_place nvarchar(20), e_birth datetime, e_dept nvarchar(10), e_duty nvarchar(5), e_identity nvarchar(5), e_college nvarchar(10), e_profession nvarchar(10), e_tel varchar(20), e_info nvarchar(40), CONSTRAINT PK_tb_employee PRIMARY KEY CLUSTERED ( e_code ASC ) )