create table articles(
ID bigint(20) primary key auto_increment,
title varchar(200) default null,
summary text,
filename varchar(100) default NULL,
author varchar(100) default NULL,
issuer bigint(100) default NULL,
workgroup bigint(100) unsigned default ‘0’ ,
reviewer1 bigint(20) unsigner default ‘0’,
reviewer2 bigint(20) unsigned default ‘0’,
createDatetime datetime,
tag int(10) default ‘0’,
allowmodify int(10) default ‘0’,
accept int(10) default ’0’
);
评论0