能飞网络办公OA系统 v1.0

#--数据表member CREATE TABLE `member` ( id int(10) NOT NULL auto_increment, `username` VARCHAR(100) NOT NULL, `sex` VARCHAR(100) NOT NULL, `password` VARCHAR(100) NOT NULL, `question` VARCHAR(100) NOT NULL, `answer` VARCHAR(100) NOT NULL, `bumen` VARCHAR(100) NOT NULL, `email` VARCHAR(100) NOT NULL, `flag` int(10) DEFAULT '0' NOT NULL, `systemop` int(10) DEFAULT '0' NOT NULL, `regtime` VARCHAR(100) , `lastlogintime` VARCHAR(100) , PRIMARY KEY (`id`) ); CREATE TABLE `memmi` ( `id` int(100) NOT NULL auto_increment, `username` varchar(100), `email` varchar(100), `oicq` varchar(100), `icq` varchar(100), `msn` varchar(100), `aim` varchar(100), `yahoo` varchar(100), `uc` varchar(100), `web` varchar(100), `guojia` varchar(100), `tel` varchar(100), `address` varchar(100), `shengfen` varchar(100), `city` varchar(100), `shengxiao` varchar(100), `xuexing` varchar(100), `xinyang` varchar(100), `aihao` varchar(100), `hunyin` varchar(100), `xueli` varchar(100), `school` varchar(100), `photo` varchar(100), `content` TEXT, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ; #--数据表bumen CREATE TABLE `bumen` ( id int(10) NOT NULL auto_increment, `bumenname` VARCHAR(100) NOT NULL, `bumentext` VARCHAR(100) NOT NULL, `bumenleader` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) ); insert into bumen values(1,'副总经理','对各部门的监督工作','未定'); insert into bumen values(2,'人事部','负责组织、人事、机构编制、劳动和社会保障、统战、老干部管理等工作。','未定'); insert into bumen values(3,'财务部','负责对公司会计核算管理、财务核算管理、公司经营过程实施财务监督、稽核、审计、检查、协调和指导，','未定'); #--数据表news CREATE TABLE `news` ( id int(10) NOT NULL auto_increment, `title` VARCHAR(100) NOT NULL, `content` TEXT NOT NULL, `fbtime` VARCHAR(100) NOT NULL, `fbren` VARCHAR(100) NOT NULL, `lei` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) ); #--数据表bbs CREATE TABLE `bbs` ( `id` int(100) NOT NULL auto_increment, `status` varchar(100) NOT NULL DEFAULT '0' , `title` varchar(100) NOT NULL , `content` text NOT NULL , `fbren` varchar(100) NOT NULL , `readnum` int(100) NOT NULL DEFAULT '0' , `replynum` int(100) NOT NULL DEFAULT '0' , `fbtime` varchar(100) NOT NULL , `pxtime` varchar(100) NOT NULL , `replymem` varchar(100) NOT NULL , `ForR` varchar(100) NOT NULL DEFAULT '0' , `topicid` varchar(100) NOT NULL DEFAULT '0' , PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ; #--数据表daily CREATE TABLE `daily` ( `id` int(100) NOT NULL auto_increment, `title` varchar(100) NOT NULL , `content` text NOT NULL , `day` varchar(100) NOT NULL DEFAULT '0' , `mem` varchar(100) NOT NULL DEFAULT '0' , PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ; CREATE TABLE `message` ( `id` int(100) NOT NULL auto_increment, `sendmem` varchar(100) NOT NULL default '', `recemem` varchar(100) NOT NULL default '', `flag` varchar(100) NOT NULL default '0', `save` varchar(100) NOT NULL default '0', `sendtime` varchar(100) NOT NULL default '', `topic` varchar(100) default NULL, `content` text, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ; CREATE TABLE `affair` ( `id` int(100) NOT NULL auto_increment, `fbmem` varchar(100) NOT NULL default '', `finishmem` varchar(100) NOT NULL default '', `bumen` varchar(100) NOT NULL default '', `flag` varchar(100) NOT NULL default '', `fbtime` varchar(100) NOT NULL default '', `donetime` varchar(100) NOT NULL default '', `topic` varchar(100) default NULL, `done` varchar(100) NOT NULL DEFAULT '0' , `content` TEXT NOT NULL, `content2` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ; #--数据表down CREATE TABLE `down` ( id int(10) NOT NULL auto_increment, `softname` VARCHAR(100) NOT NULL, `softtext` VARCHAR(100) NOT NULL, `softurl` VARCHAR(100) NOT NULL, `softhit` VARCHAR(100) DEFAULT '0' NOT NULL, `softtime` VARCHAR(100) NOT NULL, `lei` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) ); #--数据表myfriend CREATE TABLE `myfriend` ( id int(10) NOT NULL auto_increment, `friendname` VARCHAR(100) NOT NULL, `friendtel` VARCHAR(100) NOT NULL, `friendadd` VARCHAR(100) NOT NULL, `friendemail` VARCHAR(100) NOT NULL, `myname` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) ); #--数据表mail CREATE TABLE `mail` ( id int(10) NOT NULL auto_increment, `sendmail` VARCHAR(100) NOT NULL, `sendtime` VARCHAR(100) NOT NULL, `mailSubject` VARCHAR(100) NOT NULL, `mailcontent` TEXT NOT NULL, `myname` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) ); #--数据表mailserver CREATE TABLE `mailserver` ( id int(10) NOT NULL auto_increment, `username` VARCHAR(100) NOT NULL, `password` VARCHAR(100) NOT NULL, `myname` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) ); #--数据表kehu CREATE TABLE `kehu` ( id int(10) NOT NULL auto_increment, `company` VARCHAR(100) NOT NULL, `mem` VARCHAR(100) NOT NULL, `tel` VARCHAR(100) NOT NULL, `fax` VARCHAR(100) NOT NULL, `email` VARCHAR(100) NOT NULL, `address` VARCHAR(100) NOT NULL, `comtext` TEXT NOT NULL, `post` VARCHAR(100) NOT NULL, `lei` VARCHAR(100) NOT NULL, `yvyue` VARCHAR(100) NOT NULL, `done` varchar(100) NOT NULL DEFAULT '0' , `who` VARCHAR(100) NOT NULL, `addtime` VARCHAR(100) NOT NULL, `donetime` VARCHAR(100) NOT NULL, `donemem` VARCHAR(100) NOT NULL, `text` TEXT NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `work` ( `id` int(100) NOT NULL auto_increment, `fbmem` varchar(100) NOT NULL default '', `recemem` varchar(100) NOT NULL default '', `fbtime` varchar(100) NOT NULL default '', `readtime` varchar(100) NOT NULL default '', `topic` varchar(100) default NULL, `flag` varchar(100) NOT NULL DEFAULT '0' , `readok` varchar(100) NOT NULL DEFAULT '0' , `content` TEXT NOT NULL, `content2` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ;