数据库语言.txt

个人办公、客户管理、通讯中心、学习园地、论坛交流、资源下载、个人工具、邮箱等功能

#--数据表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`)
) ;