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 `#@__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