<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_sphinxcounter`;"); DB_C("CREATE TABLE `pre_common_sphinxcounter` ( `indexid` tinyint(1) NOT NULL, `maxid` int(10) NOT NULL, PRIMARY KEY (`indexid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_forum_forumrecommend`;"); DB_C("CREATE TABLE `pre_forum_forumrecommend` ( `fid` mediumint(8) unsigned NOT NULL DEFAULT '0', `tid` mediumint(8) unsigned NOT NULL, `typeid` smallint(6) NOT NULL, `displayorder` tinyint(1) NOT NULL, `subject` char(80) NOT NULL, `author` char(15) NOT NULL, `authorid` mediumint(8) NOT NULL, `moderatorid` mediumint(8) NOT NULL, `expiration` int(10) unsigned NOT NULL, `position` tinyint(1) NOT NULL DEFAULT '0', `highlight` tinyint(1) NOT NULL DEFAULT '0', `aid` mediumint(8) unsigned NOT NULL DEFAULT '0', `filename` char(100) NOT NULL DEFAULT '', PRIMARY KEY (`tid`), KEY `displayorder` (`fid`,`displayorder`), KEY `position` (`position`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_portal_topic_pic`;"); DB_C("CREATE TABLE `pre_portal_topic_pic` ( `picid` mediumint(8) NOT NULL AUTO_INCREMENT, `topicid` mediumint(8) unsigned NOT NULL DEFAULT '0', `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `username` varchar(15) NOT NULL DEFAULT '', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `filename` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `size` int(10) unsigned NOT NULL DEFAULT '0', `filepath` varchar(255) NOT NULL DEFAULT '', `thumb` tinyint(1) NOT NULL DEFAULT '0', `remote` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`picid`), KEY `topicid` (`topicid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_ucenter_members`;"); DB_C("CREATE TABLE `pre_ucenter_members` ( `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `username` char(15) NOT NULL DEFAULT '', `password` char(32) NOT NULL DEFAULT '', `email` char(32) NOT NULL DEFAULT '', `myid` char(30) NOT NULL DEFAULT '', `myidkey` char(16) NOT NULL DEFAULT '', `regip` char(15) NOT NULL DEFAULT '', `regdate` int(10) unsigned NOT NULL DEFAULT '0', `lastloginip` int(10) NOT NULL DEFAULT '0', `lastlogintime` int(10) unsigned NOT NULL DEFAULT '0', `salt` char(6) NOT NULL, `secques` char(8) NOT NULL DEFAULT '', PRIMARY KEY (`uid`), UNIQUE KEY `username` (`username`), KEY `email` (`email`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8"); DB_I("replace into `pre_ucenter_members` values('1','admin','bb219edf5e101c6b3e382221a761c516','*****@*****.**','','','hidden','1348342328','0','0','171195','');"); DB_I("replace into `pre_ucenter_members` values('2','音乐精灵520','e635e12ea8280edbedd49333632d760a','*****@*****.**','','','111.173.199.33','1348363243','0','0','bddb06','');"); DB_I("replace into `pre_ucenter_members` values('3','zhouge85901101','7e3e7ebc88034351c10a79c036c20b58','*****@*****.**','','','119.96.117.95','1348366504','0','0','860657','');"); DB_I("replace into `pre_ucenter_members` values('4','coco78721','e3fb235cd830dcaf18c999e0c75154c6','*****@*****.**','','','123.93.2.98','1348388383','0','0','f4e56b','');"); DB_I("replace into `pre_ucenter_members` values('5','mindie','bc637c0070028ad3a75ecbb56d12047b','*****@*****.**','','','123.93.2.98','1348388573','0','0','d3f27a','');");
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_template`;"); DB_C("CREATE TABLE `pre_common_template` ( `templateid` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `directory` varchar(100) NOT NULL DEFAULT '', `copyright` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`templateid`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8"); DB_I("replace into `pre_common_template` values('1','默认模板套系','./template/default','北京康盛新创科技有限责任公司');"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_home_album_category`;"); DB_C("CREATE TABLE `pre_home_album_category` ( `catid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `upid` mediumint(8) unsigned NOT NULL DEFAULT '0', `catname` varchar(255) NOT NULL DEFAULT '', `num` mediumint(8) unsigned NOT NULL DEFAULT '0', `displayorder` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`catid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `lzh_feedback`;"); DB_C("CREATE TABLE `lzh_feedback` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` tinyint(3) unsigned NOT NULL, `name` varchar(30) NOT NULL, `contact` varchar(50) NOT NULL, `msg` varchar(500) NOT NULL, `ip` varchar(16) NOT NULL, `add_time` int(10) unsigned NOT NULL, `status` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `lzh_friend`;"); DB_C("CREATE TABLE `lzh_friend` ( `id` int(11) NOT NULL AUTO_INCREMENT, `link_txt` varchar(50) NOT NULL, `link_href` varchar(50) NOT NULL, `link_img` varchar(100) NOT NULL DEFAULT ' ', `link_order` int(1) NOT NULL DEFAULT '0', `link_type` int(1) NOT NULL DEFAULT '0', `is_show` int(1) NOT NULL DEFAULT '1', `game_id` int(11) NOT NULL DEFAULT '0', `game_name` char(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `game_id` (`game_id`) ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8"); DB_I("replace into `lzh_friend` values('26','网贷点评网','http://www.wangdaidp.com','./UF/Uploads/Friends/wangdaidp4.gif','20','1','1','0','');"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_home_pokearchive`;"); DB_C("CREATE TABLE `pre_home_pokearchive` ( `pid` mediumint(8) NOT NULL AUTO_INCREMENT, `pokeuid` int(10) unsigned NOT NULL DEFAULT '0', `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `fromuid` mediumint(8) unsigned NOT NULL DEFAULT '0', `note` varchar(255) NOT NULL DEFAULT '', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `iconid` smallint(6) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`pid`), KEY `pokeuid` (`pokeuid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_portal_comment_moderate`;"); DB_C("CREATE TABLE `pre_portal_comment_moderate` ( `id` int(10) unsigned NOT NULL DEFAULT '0', `idtype` varchar(15) NOT NULL DEFAULT '', `status` tinyint(3) NOT NULL DEFAULT '0', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idtype` (`idtype`,`status`,`dateline`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `lzh_member_login`;"); DB_C("CREATE TABLE `lzh_member_login` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, `ip` varchar(15) NOT NULL, `add_time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`,`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9430 DEFAULT CHARSET=utf8"); DB_I("replace into `lzh_member_login` values('1','1','222.244.2.23','1338898110');"); DB_I("replace into `lzh_member_login` values('2','1','222.244.2.23','1338899110');"); DB_I("replace into `lzh_member_login` values('3','1','127.0.0.1','1338898927');"); DB_I("replace into `lzh_member_login` values('4','1','127.0.0.1','1338950597');"); DB_I("replace into `lzh_member_login` values('5','1','127.0.0.1','1338958832');"); DB_I("replace into `lzh_member_login` values('6','1','127.0.0.1','1338963100');"); DB_I("replace into `lzh_member_login` values('7','1','127.0.0.1','1338965020');"); DB_I("replace into `lzh_member_login` values('8','1','127.0.0.1','1338972184');"); DB_I("replace into `lzh_member_login` values('9','1','127.0.0.1','1338986696');"); DB_I("replace into `lzh_member_login` values('10','1','127.0.0.1','1339038026');"); DB_I("replace into `lzh_member_login` values('11','1','127.0.0.1','1339121112');"); DB_I("replace into `lzh_member_login` values('12','1','127.0.0.1','1339123713');"); DB_I("replace into `lzh_member_login` values('13','1','127.0.0.1','1339131321');"); DB_I("replace into `lzh_member_login` values('14','1','127.0.0.1','1339148449');");
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_home_visitor`;"); DB_C("CREATE TABLE `pre_home_visitor` ( `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `vuid` mediumint(8) unsigned NOT NULL DEFAULT '0', `vusername` char(15) NOT NULL DEFAULT '', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`,`vuid`), KEY `vuid` (`vuid`), KEY `dateline` (`dateline`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_mailqueue`;"); DB_C("CREATE TABLE `pre_common_mailqueue` ( `qid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `cid` mediumint(8) unsigned NOT NULL DEFAULT '0', `subject` text NOT NULL, `message` text NOT NULL, `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`qid`), KEY `mcid` (`cid`,`dateline`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_forum_threadtype`;"); DB_C("CREATE TABLE `pre_forum_threadtype` ( `typeid` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `fid` mediumint(8) unsigned NOT NULL DEFAULT '0', `displayorder` smallint(6) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `icon` varchar(255) NOT NULL DEFAULT '', `special` smallint(6) NOT NULL DEFAULT '0', `modelid` smallint(6) unsigned NOT NULL DEFAULT '0', `expiration` tinyint(1) NOT NULL DEFAULT '0', `template` text NOT NULL, `stemplate` text NOT NULL, `ptemplate` text NOT NULL, `btemplate` text NOT NULL, PRIMARY KEY (`typeid`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_forum_forum`;"); DB_C("CREATE TABLE `pre_forum_forum` ( `fid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `fup` mediumint(8) unsigned NOT NULL DEFAULT '0', `type` enum('group','forum','sub') NOT NULL DEFAULT 'forum', `name` char(50) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '0', `displayorder` smallint(6) NOT NULL DEFAULT '0', `styleid` smallint(6) unsigned NOT NULL DEFAULT '0', `threads` mediumint(8) unsigned NOT NULL DEFAULT '0', `posts` mediumint(8) unsigned NOT NULL DEFAULT '0', `todayposts` mediumint(8) unsigned NOT NULL DEFAULT '0', `lastpost` char(110) NOT NULL DEFAULT '', `domain` char(15) NOT NULL DEFAULT '', `allowsmilies` tinyint(1) NOT NULL DEFAULT '0', `allowhtml` tinyint(1) NOT NULL DEFAULT '0', `allowbbcode` tinyint(1) NOT NULL DEFAULT '0', `allowimgcode` tinyint(1) NOT NULL DEFAULT '0', `allowmediacode` tinyint(1) NOT NULL DEFAULT '0', `allowanonymous` tinyint(1) NOT NULL DEFAULT '0', `allowpostspecial` smallint(6) unsigned NOT NULL DEFAULT '0', `allowspecialonly` tinyint(1) unsigned NOT NULL DEFAULT '0', `allowappend` tinyint(1) unsigned NOT NULL DEFAULT '0',
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_myinvite`;"); DB_C("CREATE TABLE `pre_common_myinvite` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `typename` varchar(100) NOT NULL DEFAULT '', `appid` mediumint(8) NOT NULL DEFAULT '0', `type` tinyint(1) NOT NULL DEFAULT '0', `fromuid` mediumint(8) unsigned NOT NULL DEFAULT '0', `touid` mediumint(8) unsigned NOT NULL DEFAULT '0', `myml` text NOT NULL, `dateline` int(10) unsigned NOT NULL DEFAULT '0', `hash` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `hash` (`hash`), KEY `uid` (`touid`,`dateline`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_connect_memberbindlog`;"); DB_C("CREATE TABLE `pre_connect_memberbindlog` ( `mblid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `uin` char(40) NOT NULL, `type` tinyint(1) NOT NULL DEFAULT '0', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`mblid`), KEY `uid` (`uid`), KEY `uin` (`uin`), KEY `dateline` (`dateline`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_stylevar`;"); DB_C("CREATE TABLE `pre_common_stylevar` ( `stylevarid` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `styleid` smallint(6) unsigned NOT NULL DEFAULT '0', `variable` text NOT NULL, `substitute` text NOT NULL, PRIMARY KEY (`stylevarid`), KEY `styleid` (`styleid`) ) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8"); DB_I("replace into `pre_common_stylevar` values('1','1','menuhoverbgcolor','#005AB4 nv_a.png no-repeat 50% -33px');"); DB_I("replace into `pre_common_stylevar` values('2','1','lightlink','#FFF');"); DB_I("replace into `pre_common_stylevar` values('3','1','floatbgcolor','#FFF');"); DB_I("replace into `pre_common_stylevar` values('4','1','dropmenubgcolor','#FEFEFE');"); DB_I("replace into `pre_common_stylevar` values('5','1','floatmaskbgcolor','#000');"); DB_I("replace into `pre_common_stylevar` values('6','1','dropmenuborder','#DDD');"); DB_I("replace into `pre_common_stylevar` values('7','1','specialbg','#E5EDF2');"); DB_I("replace into `pre_common_stylevar` values('8','1','specialborder','#C2D5E3');"); DB_I("replace into `pre_common_stylevar` values('9','1','commonbg','#F2F2F2');"); DB_I("replace into `pre_common_stylevar` values('10','1','commonborder','#CDCDCD');"); DB_I("replace into `pre_common_stylevar` values('11','1','inputbg','#FFF');"); DB_I("replace into `pre_common_stylevar` values('12','1','stypeid','1');"); DB_I("replace into `pre_common_stylevar` values('13','1','inputborderdarkcolor','#848484');"); DB_I("replace into `pre_common_stylevar` values('14','1','headerbgcolor','#FFFFFF');");
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `lzh_jubao`;"); DB_C("CREATE TABLE `lzh_jubao` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `uemail` varchar(60) NOT NULL, `b_uid` int(11) NOT NULL, `b_uname` varchar(50) NOT NULL, `reason` varchar(100) NOT NULL, `text` varchar(500) NOT NULL, `add_time` int(10) unsigned NOT NULL, `add_ip` varchar(16) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8"); DB_I("replace into `lzh_jubao` values('1','1','*****@*****.**','93','jiedai','此用户在其他网站有借款','附加信息附加信息附加信息附加信息','1342970429','113.247.35.168');"); DB_I("replace into `lzh_jubao` values('2','108','*****@*****.**','1','test','此用户在其他网站有借款','枯仍枯仍fsd wefwef','1344795356','127.0.0.1');"); DB_I("replace into `lzh_jubao` values('3','2975','*****@*****.**','2975','邮政银行李行长','此用户冒用他人身份','qe akdv sk;sajf','1348839540','221.235.71.40');"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_myapp`;"); DB_C("CREATE TABLE `pre_common_myapp` ( `appid` mediumint(8) unsigned NOT NULL DEFAULT '0', `appname` varchar(60) NOT NULL DEFAULT '', `narrow` tinyint(1) NOT NULL DEFAULT '0', `flag` tinyint(1) NOT NULL DEFAULT '0', `version` mediumint(8) unsigned NOT NULL DEFAULT '0', `userpanelarea` tinyint(1) NOT NULL DEFAULT '0', `canvastitle` varchar(60) NOT NULL DEFAULT '', `fullscreen` tinyint(1) NOT NULL DEFAULT '0', `displayuserpanel` tinyint(1) NOT NULL DEFAULT '0', `displaymethod` tinyint(1) NOT NULL DEFAULT '0', `displayorder` smallint(6) unsigned NOT NULL DEFAULT '0', `appstatus` tinyint(2) NOT NULL DEFAULT '0', `iconstatus` tinyint(2) NOT NULL DEFAULT '0', `icondowntime` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`appid`), KEY `flag` (`flag`,`displayorder`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `lzh_comment`;"); DB_C("CREATE TABLE `lzh_comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, `uname` varchar(20) NOT NULL, `tid` int(10) unsigned NOT NULL, `type` tinyint(4) NOT NULL, `comment` varchar(500) NOT NULL, `add_time` int(10) unsigned NOT NULL, `deal_time` int(10) unsigned NOT NULL, `deal_info` varchar(500) NOT NULL, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `type` (`type`,`tid`,`id`) ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8"); DB_I("replace into `lzh_comment` values('43','2873','phxzsgg','34','1','dfsdfsdf','1347083412','0','','进货周转');"); DB_I("replace into `lzh_comment` values('44','2971','coco78721','148','1','vb','1348840693','0','','开店借款');"); DB_I("replace into `lzh_comment` values('45','3019','test123','168','1','啊啊啊','1357872840','0','','顶顶顶顶,好标');"); DB_I("replace into `lzh_comment` values('46','3019','test123','168','1','未完全','1357872845','0','','顶顶顶顶,好标');"); DB_I("replace into `lzh_comment` values('47','3019','test123','168','1','为全文','1357872849','0','','顶顶顶顶,好标');"); DB_I("replace into `lzh_comment` values('48','3019','test123','168','1','企鹅王企鹅','1357872854','0','','顶顶顶顶,好标');"); DB_I("replace into `lzh_comment` values('49','3019','test123','168','1','为全文','1357872858','0','','顶顶顶顶,好标');"); DB_I("replace into `lzh_comment` values('50','3019','test123','168','1','啊实打实的','1357872863','0','','顶顶顶顶,好标');");
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_card_type`;"); DB_C("CREATE TABLE `pre_common_card_type` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `typename` char(20) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_tagitem`;"); DB_C("CREATE TABLE `pre_common_tagitem` ( `tagid` smallint(6) unsigned NOT NULL DEFAULT '0', `itemid` mediumint(8) unsigned NOT NULL DEFAULT '0', `idtype` char(10) NOT NULL DEFAULT '', UNIQUE KEY `item` (`tagid`,`itemid`,`idtype`), KEY `idtype` (`idtype`,`itemid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); DB_I("replace into `pre_common_tagitem` values('1','6','tid');"); DB_I("replace into `pre_common_tagitem` values('1','9','tid');"); DB_I("replace into `pre_common_tagitem` values('1','12','tid');"); DB_I("replace into `pre_common_tagitem` values('1','25','tid');"); DB_I("replace into `pre_common_tagitem` values('2','6','tid');"); DB_I("replace into `pre_common_tagitem` values('3','6','tid');"); DB_I("replace into `pre_common_tagitem` values('4','6','tid');"); DB_I("replace into `pre_common_tagitem` values('5','9','tid');"); DB_I("replace into `pre_common_tagitem` values('6','12','tid');"); DB_I("replace into `pre_common_tagitem` values('7','12','tid');"); DB_I("replace into `pre_common_tagitem` values('8','25','tid');"); DB_I("replace into `pre_common_tagitem` values('8','33','tid');"); DB_I("replace into `pre_common_tagitem` values('8','37','tid');"); DB_I("replace into `pre_common_tagitem` values('9','25','tid');"); DB_I("replace into `pre_common_tagitem` values('9','30','tid');");
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `lzh_member_limitlog`;"); DB_C("CREATE TABLE `lzh_member_limitlog` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, `type` tinyint(3) unsigned NOT NULL, `credit_limit` float(15,2) NOT NULL, `borrow_vouch_limit` float(15,2) NOT NULL, `invest_vouch_limit` float(15,2) NOT NULL, `info` varchar(50) NOT NULL, `add_time` int(10) unsigned NOT NULL, `add_ip` varchar(16) NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`,`type`,`id`) ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8"); DB_I("replace into `lzh_member_limitlog` values('17','2873','7','-500.00','0.00','0.00','31号标还款完成','1347040295','222.244.2.131');"); DB_I("replace into `lzh_member_limitlog` values('18','2862','7','-10000.00','0.00','0.00','13号标还款完成','1347066047','112.233.59.202');"); DB_I("replace into `lzh_member_limitlog` values('19','2873','7','-500.00','0.00','0.00','30号标还款完成','1347072634','112.233.59.202');"); DB_I("replace into `lzh_member_limitlog` values('20','2873','1','-6300.00','0.00','0.00','43号标初审通过','1347073897','112.233.59.202');"); DB_I("replace into `lzh_member_limitlog` values('21','2872','1','-21000.00','0.00','0.00','49号标初审通过','1347241894','112.233.57.157');"); DB_I("replace into `lzh_member_limitlog` values('22','2872','7','-21000.00','0.00','0.00','49号标还款完成','1347242607','112.233.57.157');"); DB_I("replace into `lzh_member_limitlog` values('23','2876','11','5000.00','0.00','0.00','VIP审核通过','1347267819','112.233.57.157');"); DB_I("replace into `lzh_member_limitlog` values('24','1178','11','5000.00','0.00','0.00','VIP审核通过','1347329167','112.233.59.211');"); DB_I("replace into `lzh_member_limitlog` values('25','2436','11','5000.00','0.00','0.00','VIP审核通过','1347329849','112.233.59.211');");
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_forum_attachment_5`;"); DB_C("CREATE TABLE `pre_forum_attachment_5` ( `aid` mediumint(8) unsigned NOT NULL, `tid` mediumint(8) unsigned NOT NULL DEFAULT '0', `pid` int(10) unsigned NOT NULL DEFAULT '0', `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `filename` varchar(255) NOT NULL DEFAULT '', `filesize` int(10) unsigned NOT NULL DEFAULT '0', `attachment` varchar(255) NOT NULL DEFAULT '', `remote` tinyint(1) unsigned NOT NULL DEFAULT '0', `description` varchar(255) NOT NULL, `readperm` tinyint(3) unsigned NOT NULL DEFAULT '0', `price` smallint(6) unsigned NOT NULL DEFAULT '0', `isimage` tinyint(1) NOT NULL DEFAULT '0', `width` smallint(6) unsigned NOT NULL DEFAULT '0', `thumb` tinyint(1) unsigned NOT NULL DEFAULT '0', `picid` mediumint(8) NOT NULL DEFAULT '0', PRIMARY KEY (`aid`), KEY `tid` (`tid`), KEY `pid` (`pid`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `lzh_ad`;"); DB_C("CREATE TABLE `lzh_ad` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `content` varchar(500) NOT NULL, `start_time` int(10) NOT NULL, `end_time` int(10) NOT NULL, `add_time` int(10) NOT NULL DEFAULT '0', `title` varchar(100) NOT NULL, `ad_type` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8"); DB_I("replace into `lzh_ad` values('1','<img style=\"margin: 0px; float: none\" alt=\"\" src=\"/UF/Uploads/Article/20130109150454.jpg\" />','1357660800','1391097600','1357715233','首页LOGO图片(推荐LOGO图片大小:220*65像素)','0');"); DB_I("replace into `lzh_ad` values('2','<img style=\"margin: 0px; width: 171px; float: none; height: 60px\" alt=\"\" src=\"/UF/Uploads/Article/20130109150958.jpg\" />','1357660800','1391097600','1357715437','首页顶部中间广告条(尺寸大小:485*65像素)','0');"); DB_I("replace into `lzh_ad` values('3','<img style=\"margin: 0px; float: none\" alt=\"\" src=\"/UF/Uploads/Article/20130109151144.jpg\" />','1357660800','1391011200','1357715509','首页顶部联系电话图片(推荐尺寸大小:225*65像素)','0');"); DB_I("replace into `lzh_ad` values('4','a:3:{i:0;a:3:{s:3:\"img\";s:34:\"UF/Uploads/Ad/2013021609333381.jpg\";s:4:\"info\";s:0:\"\";s:3:\"url\";s:0:\"\";}i:1;a:3:{s:3:\"img\";s:35:\"UF/Uploads/Ad/20130216093333367.jpg\";s:4:\"info\";s:0:\"\";s:3:\"url\";s:0:\"\";}i:2;a:3:{s:3:\"img\";s:35:\"UF/Uploads/Ad/20130216093334839.jpg\";s:4:\"info\";s:0:\"\";s:3:\"url\";s:0:\"\";}}','1357660800','1391097600','1357715551','首页幻灯片展示','1');"); DB_I("replace into `lzh_ad` values('5','<img style=\"margin: 0px; width: 980px; float: none\" alt=\"\" src=\"/UF/Uploads/Article/20130109152815.jpg\" />','1357660800','1393516800','1357716501','内页中上部大广告位','0');"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `lzh_member_address`;"); DB_C("CREATE TABLE `lzh_member_address` ( `id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, `name` varchar(10) NOT NULL, `main_phone` varchar(20) NOT NULL, `secondary_phone` varchar(20) NOT NULL, `address` varchar(100) NOT NULL, `post_code` varchar(10) NOT NULL, `address_type` tinyint(4) NOT NULL DEFAULT '0', `province` smallint(5) unsigned NOT NULL, `city` smallint(5) unsigned NOT NULL, `district` smallint(5) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`,`address_type`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_mailcron`;"); DB_C("CREATE TABLE `pre_common_mailcron` ( `cid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `touid` mediumint(8) unsigned NOT NULL DEFAULT '0', `email` varchar(100) NOT NULL DEFAULT '', `sendtime` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`cid`), KEY `sendtime` (`sendtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_forum_warning`;"); DB_C("CREATE TABLE `pre_forum_warning` ( `wid` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL, `operatorid` mediumint(8) unsigned NOT NULL, `operator` char(15) NOT NULL, `authorid` mediumint(8) unsigned NOT NULL, `author` char(15) NOT NULL, `dateline` int(10) unsigned NOT NULL, `reason` char(40) NOT NULL, PRIMARY KEY (`wid`), UNIQUE KEY `pid` (`pid`), KEY `authorid` (`authorid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"); ?>
<?php /* SoftName : JingPai2010 Version 2012 Author : lzhhand Copyright: Powered by www.jingpai2010.com */ DB_D("DROP TABLE IF EXISTS `pre_common_member`;"); DB_C("CREATE TABLE `pre_common_member` ( `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `email` char(40) NOT NULL DEFAULT '', `username` char(15) NOT NULL DEFAULT '', `password` char(32) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '0', `emailstatus` tinyint(1) NOT NULL DEFAULT '0', `avatarstatus` tinyint(1) NOT NULL DEFAULT '0', `videophotostatus` tinyint(1) NOT NULL DEFAULT '0', `adminid` tinyint(1) NOT NULL DEFAULT '0', `groupid` smallint(6) unsigned NOT NULL DEFAULT '0', `groupexpiry` int(10) unsigned NOT NULL DEFAULT '0', `extgroupids` char(20) NOT NULL DEFAULT '', `regdate` int(10) unsigned NOT NULL DEFAULT '0', `credits` int(10) NOT NULL DEFAULT '0', `notifysound` tinyint(1) NOT NULL DEFAULT '0', `timeoffset` char(4) NOT NULL DEFAULT '', `newpm` smallint(6) unsigned NOT NULL DEFAULT '0', `newprompt` smallint(6) unsigned NOT NULL DEFAULT '0', `accessmasks` tinyint(1) NOT NULL DEFAULT '0', `allowadmincp` tinyint(1) NOT NULL DEFAULT '0', `onlyacceptfriendpm` tinyint(1) NOT NULL DEFAULT '0',