DEDECMS database Structure table name: dede_archives

DEDECMS database Structure table name: Dede_archives field description is as follows:

table name: Dede_archives


(ENGINE=MYISAM/CHARSET=GBK) Description: Document Main Table field name description describes specific parameters TYPEID2 deputy column ID varchar () not NULL DEFAULT ' 0 ', dutyadmin responsible for audit Admin ID Mediumint (8) unsigned NOT NULL default ' 0 ', lastpost last reply int (a) unsigned NOT null default ' 0 ', pubdate http:// www.aliyun.com/zixun/aggregation/17437.html "> Release date int (a) unsigned NOT null DEFAULT ' 0 ', color title color char (7) NOT NULL DEFAULT ', money needs to consume gold smallint (6) NOT null default ' 0 ', weight weight int (a) NOT null default ' 0 ', ismake generate HTML smallint (6) NO T null default ' 0 ', flag property set (' C ', ' H ', ' P ', ' f ', ' s ', ' j ', ' A ', ' B ') default NULL, litpic thumbnail char not null default ', Scores consumption integral Mediumint (8) NOT null default ' 0 ', keywords document keyword char (a) NOT null default ', Mtype Custom category Mediumint (8) unsigned Not null default ' 0 ', filename custom filename varchar () NOT NULL default ', click Count Mediumint (8) unsigned NOT NULL default ' 0 ', Sor Trank document sort int (a) unsigned NOT null default ' 0 ', Goodpost praise Mediumint (8) unsigned NOT NULL default ' 0 ', typeid column ID smallint(5) unsigned NOT null default ' 0 ', Shorttitle short title char (+) NOT null default ', tackid   Int (TEN) NOT null default ' 0 ', title Document title char NOT NULL default ', description description varchar (255) NOT null default ', writer author char (not null default '), mid Member ID mediumint (8) unsigned NOT NULL default ' 0 ', id Content ID mediumint (8) unsigned NOT NULL default ' 0 ', Badpost difference rating Mediumint (8) unsigned NOT NULL default ' 0 ', source char (a) NOT null default ', senddate submission date int (a) unsigned NOT null default ' 0 ', NOTPO St does not allow reply tinyint (1) unsigned NOT null default ' 0 ', Arcrank browsing permissions smallint (6) NOT null default ' 0 ', channel Channel model smallint (6) Not NU LL DEFAULT ' 1 ', index:


PRIMARY KEY (' id '),


KEY ' Sortrank ' (' Sortrank '),


KEY ' Mainindex ' (' Arcrank ', ' typeid ', ' channel ', ' Flag ', ' mid '),


KEY ' lastpost ' (' lastpost ', ' scores ', ' goodpost ', ' badpost ', ' notpost ')