ym_article.sql

来自「某自制区政府网站源代码.数据库为Access,包含完整的数据库.」· SQL 代码 · 共 17 行

CREATE TABLE ym_article (
   id int(10) unsigned NOT NULL auto_increment,
   title varchar(100) NOT NULL,
   author varchar(20) NOT NULL,
   fromsite varchar(100) NOT NULL,
   text mediumtext,
   img varchar(100),
   download varchar(100),
   date varchar(20) NOT NULL,
   sortid int(6) NOT NULL,
   today_view int(10) DEFAULT '0' NOT NULL,
   view int(10) DEFAULT '0' NOT NULL,
   isshow int(6) DEFAULT '0' NOT NULL,
   ishtml int(6) DEFAULT '0' NOT NULL,
   daynum int(10) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);