基于PHP的二次精简网站管理系统php版源码.zip

 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 `#@__addonimages`; CREATE TABLE `#@__addonimages` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `pagestyle` smallint(6) NOT NULL default '1', `maxwidth` smallint(6) NOT NULL default '600', `imgurls` text, `row` smallint(6) NOT NULL default '0', `col` smallint(6) NOT NULL default '0', `isrm` smallint(6) NOT NULL default '0', `ddmaxwidth` smallint(6) NOT NULL default '200', `pagepicnum` smallint(6) NOT NULL default '12', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `redirecturl` varchar(255) NOT NULL default '', `body` mediumtext, PRIMARY KEY (`aid`), KEY `imagesMain` (`typeid`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `#@__addoninfos`; CREATE TABLE `#@__addoninfos` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `channel` smallint(6) NOT NULL default '0', `arcrank` smallint(6) NOT NULL default '0', `mid` mediumint(8) unsigned NOT NULL default '0', `click` int(10) unsigned NOT NULL default '0', `title` varchar(60) NOT NULL default '', `litpic` varchar(60) NOT NULL default '', `userip` varchar(15) NOT NULL default ' ', `senddate` int(11) NOT NULL default '0', `flag` set('c','h','p','f','s','j','a','b') default NULL, `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', `nativeplace` smallint(5) unsigned NOT NULL default '0', `infotype` char(20) NOT NULL default '0', `body` mediumtext, `endtime` int(11) NOT NULL default '0', `tel` varchar(50) NOT NULL default '', `email` varchar(50) NOT NULL default '', `address` varchar(100) NOT NULL default '', `linkman` varchar(50) NOT NULL default '', PRIMARY KEY (`aid`), KEY `typeid` (`typeid`,`nativeplace`,`infotype`), KEY `channel` (`channel`,`arcrank`,`mid`,`click`,`title`,`litpic`,`senddate`,`flag`,`endtime`) ) 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', `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', `infotype` 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 `#@__addonspec`; CREATE TABLE `#@__addonspec` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `note` text, `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `redirecturl` varchar(255) NOT NULL default '', PRIMARY KEY (`aid`), KEY `typeid` (`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`) ) TY