PHP实例开发源码—PHP多用户网络日记(青春日记).zip

/* MySQL Data Transfer Source Host: localhost Source Database: dmy_qcrj Target Host: localhost Target Database: dmy_qcrj Date: 2018/9/29 14:48:05 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for dede_addonarticle -- ---------------------------- DROP TABLE IF EXISTS `dede_addonarticle`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_addonimages -- ---------------------------- DROP TABLE IF EXISTS `dede_addonimages`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_addoninfos -- ---------------------------- DROP TABLE IF EXISTS `dede_addoninfos`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_addonshop -- ---------------------------- DROP TABLE IF EXISTS `dede_addonshop`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_addonsoft -- ---------------------------- DROP TABLE IF EXISTS `dede_addonsoft`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_addonspec -- ---------------------------- DROP TABLE IF EXISTS `dede_addonspec`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_admin -- ---------------------------- DROP TABLE IF EXISTS `dede_admin`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_admintype -- ---------------------------- DROP TABLE IF EXISTS `dede_admintype`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_advancedsearch -- ---------------------------- DROP TABLE IF EXISTS `dede_advancedsearch`; CREATE TABLE `dede_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_arcatt -- ---------------------------- DROP TABLE IF EXISTS `dede_arcatt`; CREATE TABLE `dede_arcatt` ( `sortid` smallint(6) NOT NULL DEFAULT '0', `att` char(10) NOT NULL DEFAULT '', `attname` char(30) NOT NULL DEFAULT '', PRIMARY KEY (`att`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_arccache -- ---------------------------- DROP TABLE IF EXISTS `dede_arccache`; CREATE TABLE `dede_arccache` ( `md5hash` char(32) NOT NULL DEFAULT '', `uptime` int(11) NOT NULL DEFAULT '0', `cachedata` mediumtext, PRIMARY KEY (`md5hash`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for dede_archives -- ---------------------------- DROP TABLE IF EXISTS `dede_archives`; CREATE TABLE `dede_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 N