DB_C PHP代码示例 - HotExamples

示例#1

0

显示文件

文件： pre_forum_forumfield_1.php 项目： hutao1004/yintt

DB_C("CREATE TABLE `pre_forum_forumfield` (
  `fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `password` varchar(12) NOT NULL DEFAULT '',
  `icon` varchar(255) NOT NULL DEFAULT '',
  `redirect` varchar(255) NOT NULL DEFAULT '',
  `attachextensions` varchar(255) NOT NULL DEFAULT '',
  `creditspolicy` mediumtext NOT NULL,
  `formulaperm` text NOT NULL,
  `moderators` text NOT NULL,
  `rules` text NOT NULL,
  `threadtypes` text NOT NULL,
  `threadsorts` text NOT NULL,
  `viewperm` text NOT NULL,
  `postperm` text NOT NULL,
  `replyperm` text NOT NULL,
  `getattachperm` text NOT NULL,
  `postattachperm` text NOT NULL,
  `postimageperm` text NOT NULL,
  `spviewperm` text NOT NULL,
  `seotitle` text NOT NULL,
  `keywords` text NOT NULL,
  `seodescription` text NOT NULL,
  `supe_pushsetting` text NOT NULL,
  `modrecommend` text NOT NULL,
  `threadplugin` text NOT NULL,
  `extra` text NOT NULL,
  `jointype` tinyint(1) NOT NULL DEFAULT '0',
  `gviewperm` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `membernum` smallint(6) unsigned NOT NULL DEFAULT '0',
  `dateline` int(10) unsigned NOT NULL DEFAULT '0',
  `lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
  `activity` int(10) unsigned NOT NULL DEFAULT '0',
  `founderuid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `foundername` varchar(255) NOT NULL DEFAULT '',
  `banner` varchar(255) NOT NULL DEFAULT '',
  `groupnum` smallint(6) unsigned NOT NULL DEFAULT '0',
  `commentitem` text NOT NULL,
  `relatedgroup` text NOT NULL,
  `picstyle` tinyint(1) NOT NULL DEFAULT '0',
  `widthauto` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`),
  KEY `membernum` (`membernum`),
  KEY `dateline` (`dateline`),
  KEY `lastupdate` (`lastupdate`),
  KEY `activity` (`activity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");

示例#2

0

显示文件

文件： pre_forum_forumrecommend_1.php 项目： hutao1004/yintt

<?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");

?>

示例#3

0

显示文件

文件： pre_portal_topic_pic_1.php 项目： hutao1004/yintt

<?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");

?>

示例#4

0

显示文件

文件： pre_common_tagitem_1.php 项目： hutao1004/yintt

<?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');");

示例#5

0

显示文件

文件： pre_forum_attachment_exif_1.php 项目： hutao1004/yintt

<?php

/*
		SoftName : JingPai2010 Version 2012
		Author   : lzhhand
		Copyright: Powered by www.jingpai2010.com
*/

DB_D("DROP TABLE IF EXISTS `pre_forum_attachment_exif`;");
DB_C("CREATE TABLE `pre_forum_attachment_exif` (
  `aid` mediumint(8) unsigned NOT NULL,
  `exif` text NOT NULL,
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");

?>

示例#6

0

显示文件

文件： lzh_jubao_1.php 项目： hutao1004/yintt

<?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');");

?>

示例#7

0

显示文件

文件： lzh_comment_1.php 项目： hutao1004/yintt

<?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','','顶顶顶顶,好标');");
DB_I("replace  into `lzh_comment` values('51','3019','test123','168','1','阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈阿斯钢感到骄傲是感觉哈','1357873063','0','','顶顶顶顶,好标');");

示例#8

0

显示文件

文件： pre_home_pokearchive_1.php 项目： hutao1004/yintt

<?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");

?>

示例#9

0

显示文件

文件： pre_common_myinvite_1.php 项目： hutao1004/yintt

<?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");

?>

示例#10

0

显示文件

文件： lzh_member_login_1.php 项目： hutao1004/yintt

<?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');");

示例#11

0

显示文件

文件： lzh_friend_1.php 项目： hutao1004/yintt

<?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','');");

?>

示例#12

0

显示文件

文件： pre_portal_comment_moderate_1.php 项目： hutao1004/yintt

<?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");

?>

示例#13

0

显示文件

文件： pre_home_visitor_1.php 项目： hutao1004/yintt

<?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");

?>

示例#14

0

显示文件

文件： pre_common_mailqueue_1.php 项目： hutao1004/yintt

<?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");

?>

示例#15

0

显示文件

文件： pre_connect_memberbindlog_1.php 项目： hutao1004/yintt

<?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");

?>

示例#16

0

显示文件

文件： pre_common_stylevar_1.php 项目： hutao1004/yintt

<?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');");

示例#17

0

显示文件

文件： pre_home_album_category_1.php 项目： hutao1004/yintt

<?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");

?>

示例#18

0

显示文件

文件： pre_common_myapp_1.php 项目： hutao1004/yintt

<?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");

?>

示例#19

0

显示文件

文件： lzh_feedback_1.php 项目： hutao1004/yintt

<?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");

?>

示例#20

0

显示文件

文件： pre_common_card_type_1.php 项目： hutao1004/yintt

<?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");

?>

示例#21

0

显示文件

文件： pre_ucenter_members_1.php 项目： hutao1004/yintt

/*
		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','');");
DB_I("replace  into `pre_ucenter_members` values('6','ggggwfn11','f444ae69d7d0f97f1048d268f98a0cd5','*****@*****.**','','','110.194.24.205','1348543863','0','0','745d74','');");
DB_I("replace  into `pre_ucenter_members` values('7','邮政银行李行长','d2c1f6e60f4ea2cd1b48ef6a11211f8e','*****@*****.**','','','119.96.255.184','1348644662','0','0','6adb61','');");

示例#22

0

显示文件

文件： lzh_member_limitlog_1.php 项目： hutao1004/yintt

<?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');");

示例#23

0

显示文件

文件： pre_common_template_1.php 项目： hutao1004/yintt

<?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','北京康盛新创科技有限责任公司');");

?>

示例#24

0

显示文件

文件： lzh_ad_1.php 项目： hutao1004/yintt

<?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');");

?>

示例#25

0

显示文件

文件： pre_forum_attachment_5_1.php 项目： hutao1004/yintt

/*
		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");

?>

示例#26

0

显示文件

文件： pre_common_mailcron_1.php 项目： hutao1004/yintt

<?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");

?>

示例#27

0

显示文件

文件： lzh_member_address_1.php 项目： hutao1004/yintt

<?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");

?>

示例#28

0

显示文件

文件： pre_forum_forum_1.php 项目： hutao1004/yintt

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',
  `alloweditrules` tinyint(1) NOT NULL DEFAULT '0',
  `allowfeed` tinyint(1) NOT NULL DEFAULT '1',
  `allowside` tinyint(1) NOT NULL DEFAULT '0',
  `recyclebin` tinyint(1) NOT NULL DEFAULT '0',
  `modnewposts` tinyint(1) NOT NULL DEFAULT '0',
  `jammer` tinyint(1) NOT NULL DEFAULT '0',
  `disablewatermark` tinyint(1) NOT NULL DEFAULT '0',
  `inheritedmod` tinyint(1) NOT NULL DEFAULT '0',
  `autoclose` smallint(6) NOT NULL DEFAULT '0',
  `forumcolumns` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `catforumcolumns` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `threadcaches` tinyint(1) NOT NULL DEFAULT '0',
  `alloweditpost` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `simple` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `modworks` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `allowglobalstick` tinyint(1) NOT NULL DEFAULT '1',
  `level` smallint(6) NOT NULL DEFAULT '0',
  `commoncredits` int(10) unsigned NOT NULL DEFAULT '0',
  `archive` tinyint(1) NOT NULL DEFAULT '0',
  `recommend` smallint(6) unsigned NOT NULL DEFAULT '0',
  `favtimes` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `sharetimes` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `disablethumb` tinyint(1) NOT NULL DEFAULT '0',
  `disablecollect` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`),
  KEY `forum` (`status`,`type`,`displayorder`),
  KEY `fup_type` (`fup`,`type`,`displayorder`),
  KEY `fup` (`fup`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8");

示例#29

0

显示文件

文件： pre_forum_warning_1.php 项目： hutao1004/yintt

<?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");

?>

示例#30

0

显示文件

文件： pre_forum_threadtype_1.php 项目： hutao1004/yintt

<?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 DB_C示例