该项目是一个简单的用来测试数据库连接的系统

CREATE TABLE oa.member (
id int NOT NULL  ,
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 DEFAULT '0'  NOT NULL,  
systemop int DEFAULT '0'  NOT NULL,  
regtime VARCHAR(100) , 
lastlogintime VARCHAR(100) ,  
PRIMARY KEY  (id)
);




CREATE TABLE oa.memmi (
  id int NOT NULL ,
  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)

) ;






CREATE TABLE oa.bumen (
id int NOT NULL  ,
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,'财务部','负责对公司会计核算管理、财务核算管理、公司经营过程实施财务监督、稽核、审计、检查、协调和指导，','未定');




CREATE TABLE oa.news (
id int NOT NULL  ,
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)
);




CREATE TABLE oa.bbs (
  id int NOT NULL ,
  status varchar(100) NOT NULL DEFAULT '0' ,
  title varchar(100) NOT NULL ,
  content text NOT NULL ,
  fbren varchar(100) NOT NULL ,
  readnum int  NOT NULL  DEFAULT '0' ,
  replynum int  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)

) ;



CREATE TABLE oa.daily (
  id int NOT NULL ,
  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)

) ;


CREATE TABLE oa.message (
  id int NOT NULL ,
  sendmem varchar(100) NOT NULL DEFAULT '',
  recemem varchar(100) NOT NULL DEFAULT '',
  flag varchar(100) NOT NULL DEFAULT '0',
  ssave varchar(100) NOT NULL DEFAULT '0',
  sendtime varchar(100) NOT NULL DEFAULT '',
  topic varchar(100) DEFAULT NULL,
  content text,
  PRIMARY KEY  (id)
) ;



CREATE TABLE oa.affair (
  id int NOT NULL ,
  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)
) ;




CREATE TABLE oa.down (
id int NOT NULL  ,
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)
);





CREATE TABLE oa.myfriend (
id int NOT NULL  ,
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)
);







CREATE TABLE oa.mail (
id int NOT NULL  ,
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)
);






CREATE TABLE oa.mailserver (
id int NOT NULL  ,
username VARCHAR(100) NOT NULL, 
password VARCHAR(100) NOT NULL, 
myname VARCHAR(100) NOT NULL, 
PRIMARY KEY  (id)
);





CREATE TABLE oa.kehu (
id int NOT NULL  ,
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 oa.work (
  id int NOT NULL ,
  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)
) ;