DROP TABLE IF EXISTS `#@__addonarticle`;
CREATE TABLE `#@__addonarticle` (
`aid` mediumint(8) unsigned NOT NULL default '0',
`typeid` smallint(5) unsigned NOT NULL default '0',
`body` mediumtext,
`redirecturl` varchar(255) NOT NULL default '',
`templet` varchar(30) NOT NULL default '',
`userip` char(15) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `typeid` (`typeid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__addonshop`;
CREATE TABLE `#@__addonshop` (
`aid` mediumint(8) unsigned NOT NULL default '0',
`typeid` smallint(5) unsigned NOT NULL default '0',
`body` mediumtext,
`price` float NOT NULL default '0',
`trueprice` float NOT NULL default '0',
`lianxiqq` float NOT NULL default '503827438',
`brand` varchar(250) NOT NULL default '',
`units` varchar(250) NOT NULL default '',
`templet` varchar(30) NOT NULL,
`userip` char(15) NOT NULL,
`redirecturl` varchar(255) NOT NULL,
`vocation` char(20) NOT NULL default '0',
`uptime` int(11) NOT NULL default '0',
PRIMARY KEY (`aid`),
KEY `typeid` (`typeid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__addonsoft`;
CREATE TABLE `#@__addonsoft` (
`aid` mediumint(8) unsigned NOT NULL default '0',
`typeid` smallint(5) unsigned NOT NULL default '0',
`filetype` varchar(10) NOT NULL default '',
`language` varchar(10) NOT NULL default '',
`softtype` varchar(10) NOT NULL default '',
`accredit` varchar(10) NOT NULL default '',
`os` varchar(30) NOT NULL default '',
`softrank` mediumint(8) unsigned NOT NULL default '0',
`officialUrl` varchar(30) NOT NULL default '',
`officialDemo` varchar(50) NOT NULL default '',
`softsize` varchar(10) NOT NULL default '',
`softlinks` text,
`introduce` text,
`daccess` smallint(5) NOT NULL default '0',
`needmoney` smallint(5) NOT NULL default '0',
`templet` varchar(30) NOT NULL default '',
`userip` char(15) NOT NULL default '',
`redirecturl` varchar(255) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `softMain` (`typeid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__admin`;
CREATE TABLE `#@__admin` (
`id` int(10) unsigned NOT NULL,
`usertype` float unsigned default '0',
`userid` char(30) NOT NULL default '',
`pwd` char(32) NOT NULL default '',
`uname` char(20) NOT NULL default '',
`tname` char(30) NOT NULL default '',
`email` char(30) NOT NULL default '',
`typeid` text,
`logintime` int(10) unsigned NOT NULL default '0',
`loginip` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__admintype`;
CREATE TABLE `#@__admintype` (
`rank` float NOT NULL default '1',
`typename` varchar(30) NOT NULL default '',
`system` smallint(6) NOT NULL default '0',
`purviews` text,
PRIMARY KEY (`rank`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__advancedsearch`;
CREATE TABLE `#@__advancedsearch` (
`mid` int(11) NOT NULL,
`maintable` varchar(256) NOT NULL default '',
`mainfields` text,
`addontable` varchar(256) default NULL,
`addonfields` text,
`forms` text,
`template` varchar(256) NOT NULL default '',
UNIQUE KEY `mid` (`mid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__arcatt`;
CREATE TABLE `#@__arcatt` (
`sortid` smallint(6) NOT NULL default '0',
`att` char(10) NOT NULL default '',
`attname` char(30) NOT NULL default '',
PRIMARY KEY (`att`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__arccache`;
CREATE TABLE `#@__arccache` (
`md5hash` char(32) NOT NULL default '',
`uptime` int(11) NOT NULL default '0',
`cachedata` mediumtext,
PRIMARY KEY (`md5hash`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__archives`;
CREATE TABLE `#@__archives` (
`id` mediumint(8) unsigned NOT NULL default '0',
`typeid` smallint(5) unsigned NOT NULL default '0',
`typeid2` varchar(90) NOT NULL default '0',
`sortrank` int(10) unsigned NOT NULL default '0',
`flag` set('c','h','p','f','s','j','a','b') default NULL,
`ismake` smallint(6) NOT NULL default '0',
`channel` smallint(6) NOT NULL default '1',
`arcrank` smallint(6) NOT NULL default '0',
`click` mediumint(8) unsigned NOT NULL default '0',
`money` smallint(6) NOT NULL default '0',
`title` char(60) NOT NULL default '',
`shorttitle` char(36) NOT NULL default '',
`color` char(7) NOT NULL default '',
`writer` char(20) NOT NULL default '',
`source` char(30) NOT NULL default '',
`litpic` char(100) NOT NULL default '',
`pubdate` int(10) unsigned NOT NULL default '0',
`senddate` int(10) unsigned NOT NULL default '0',
`mid` mediumint(8) unsigned NOT NULL default '0',
`keywords` char(30) NOT NULL default '',
`lastpost` int(10) unsigned NOT NULL default '0',
`scores` mediumint(8) NOT NULL default '0',
`goodpost` mediumint(8) unsigned NOT NULL default '0',
`badpost` mediumint(8) unsigned NOT NULL default '0',
`voteid` mediumint(8) NOT NULL,
`notpost` tinyint(1) unsigned NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`filename` varchar(40) NOT NULL default '',
`dutyadmin` mediumint(8) unsigned NOT NULL default '0',
`tackid` int(10) NOT NULL default '0',
`mtype` mediumint(8) unsigned NOT NULL default '0',
`weight` int(10) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `sortrank` (`sortrank`),
KEY `mainindex` (`arcrank`,`typeid`,`channel`,`flag`,`mid`),
KEY `lastpost` (`lastpost`,`scores`,`goodpost`,`badpost`,`notpost`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__arcmulti`;
CREATE TABLE `#@__arcmulti` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`tagid` char(60) NOT NULL default '',
`uptime` int(11) NOT NULL default '0',
`innertext` varchar(255) NOT NULL default '',
`pagesize` int(11) NOT NULL default '0',
`arcids` text NOT NULL,
`ordersql` varchar(255) default NULL,
`addfieldsSql` varchar(255) default NULL,
`addfieldsSqlJoin` varchar(255) default NULL,
`attstr` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__arcrank`;
CREATE TABLE `#@__arcrank` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`rank` smallint(6) NOT NULL default '0',
`membername` char(20) NOT NULL default '',
`adminrank` smallint(6) NOT NULL default '0',
`money` smallint(8) unsigned NOT NULL default '500',
`scores` mediumint(8) NOT NULL default '0',
`purviews` mediumtext,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__arctiny`;
CREATE TABLE `#@__arctiny` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`typeid` smallint(5) unsigned NOT NULL default '0',
`typeid2` varchar(90) NOT NULL default '0',
`arcrank` smallint(6) NOT NULL default '0',
`channel` smallint(5) NOT NULL default '1',
`senddate` int(10) unsigned NOT NULL default '0',
`sortrank` int(10) unsigned NOT NULL default '0',
`mid` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `sortrank` (`sortrank`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `#@__arctype`;
CREATE TABLE `#@__arctype` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`reid` smallint(5) unsigned NOT NULL default '0',
`topid` smallint(5) unsigned NOT NULL default '0',
`sortrank` smallint(5) unsigned NOT NULL default '50',
`typename` char(30) NOT NULL default '',
`typedir` char(60) NOT NULL default '',
`hyslistimg` varchar(200) NOT NULL default '',
`hyslisturl` varchar(200) NOT NULL default '',
`isdefault` smallint(6) NOT NULL default '0',
`defaultname` char(15) NOT NULL default 'index.html',
`issend` smallint(6) NOT NULL default '0',
`channeltype` smallint(6) default '1',
`maxpage` smallint(6) NOT NULL default '-1',
`ispart` smallint(6) NOT NULL default '0',
`corank` smallint(6) NOT NULL default '0',
`tempindex` char(50) NOT NULL default '',
`templist` char(50) NOT NULL default '',
`temparticle` char(50) NOT NULL default '',
`namerule` char(50) NOT NULL default '',
`namerule2` char(50) NOT NULL