# 主機: localhost# 數據庫: myOA# 表: 'category'# CREATE TABLE `category` (  `CategoryId` int(11) NOT NULL default '0',  `CategoryName` varchar(100) NOT NULL default '',  PRIMARY KEY  (`CategoryId`)) TYPE=MyISAM; # 主機: localhost# 數據庫: myOA# 表: 'file'# CREATE TABLE `file` (  `FileId` int(11) NOT NULL auto_increment,  `FromUserId` int(11) NOT NULL default '0',  `CreateTime` date NOT NULL default '0000-00-00',  `ToUserIdArray` varchar(100) NOT NULL default '',  `Title` varchar(100) NOT NULL default '',  `KeyWords` varchar(100) NOT NULL default '',  `Content` text NOT NULL,  `StatusId` int(11) NOT NULL default '0',  `CategoryId` int(11) NOT NULL default '0',  PRIMARY KEY  (`FileId`)) TYPE=MyISAM; # 主機: localhost# 數據庫: myOA# 表: 'log'# CREATE TABLE `log` (  `LogId` int(11) NOT NULL auto_increment,  `CreateTime` date NOT NULL default '0000-00-00',  `LogContent` text NOT NULL,  PRIMARY KEY  (`LogId`)) TYPE=MyISAM; # 主機: localhost# 數據庫: myOA# 表: 'privilege'# CREATE TABLE `privilege` (  `PrivilegeId` int(11) NOT NULL default '0',  `FileAdd` char(1) NOT NULL default '',  `FileUpdate` char(1) NOT NULL default '',  `FileDelete` char(1) NOT NULL default '',  `FileSearch` char(1) NOT NULL default '',  `FileDispose` char(1) NOT NULL default '',  `PublicMessageAdd` char(1) NOT NULL default '',  `PublicMessageUpdate` char(1) NOT NULL default '',  `PublicMessageDelete` char(1) NOT NULL default '',  `PublicMessageSearch` char(1) NOT NULL default '',  `UserAdd` char(1) NOT NULL default '',  `UserUpdate` char(1) NOT NULL default '',  `UserDelete` char(1) NOT NULL default '',  `LogSearch` char(1) NOT NULL default '',  PRIMARY KEY  (`PrivilegeId`)) TYPE=MyISAM; # 主機: localhost# 數據庫: myOA# 表: 'publicmessage'# CREATE TABLE `publicmessage` (  `PublicMessageId` int(11) NOT NULL auto_increment,  `FromUserId` int(11) NOT NULL default '0',  `CreateTime` date NOT NULL default '0000-00-00',  `Title` varchar(100) NOT NULL default '',  `KeyWords` varchar(100) NOT NULL default '',  `Content` varchar(100) NOT NULL default '',  `CategoryId` varchar(100) NOT NULL default '',  PRIMARY KEY  (`PublicMessageId`)) TYPE=MyISAM; # 主機: localhost# 數據庫: myOA# 表: 'role'# CREATE TABLE `role` (  `RoleId` int(11) NOT NULL default '0',  `RoleName` varchar(100) NOT NULL default '',  `PrivilegeId` int(11) NOT NULL default '0',  PRIMARY KEY  (`RoleId`)) TYPE=MyISAM; # 主機: localhost# 數據庫: myOA# 表: 'status'# CREATE TABLE `status` (  `StatusId` int(11) NOT NULL default '0',  `StatusDesc` varchar(100) NOT NULL default '',  PRIMARY KEY  (`StatusId`)) TYPE=MyISAM; # 主機: localhost# 數據庫: myOA# 表: 'user'# CREATE TABLE `user` (  `UserId` int(11) NOT NULL auto_increment,  `LoginName` varchar(100) NOT NULL default '',  `Password` varchar(100) NOT NULL default '',  `RealName` varchar(100) NOT NULL default '',  `Department` varchar(100) NOT NULL default '',  `Email` varchar(100) NOT NULL default '',  `RoleId` varchar(100) NOT NULL default '',  PRIMARY KEY  (`UserId`)) TYPE=MyISAM; # 初始化數據insert into `category` values(1,'工作報告');insert into `category` values(2,'紅頭文件');insert into `category` values(3,'任務下達');insert into `role` values(0,'未授權角色',0);insert into `role` values(1,'普通員工',1);insert into `role` values(2,'管理者',2);insert into `role` values(3,'系統管理員',3);insert into `status` values(1,'未上報');insert into `status` values(2,'已上報');insert into `status` values(3,'已審批');insert into `privilege` values(0,'N','N','N','N','N','N','N','N','N','N','N','N','N');insert into `privilege` values(1,'Y','Y','Y','N','N','Y','Y','N','Y','N','N','N','N');insert into `privilege` values(2,'Y','Y','Y','Y','Y','Y','Y','Y','Y','N','N','N','N');insert into `privilege` values(3,'N','N','Y','N','N','N','N','N','N','N','N','N','N');