作者：hutao100
项目：yint
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");
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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');");
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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','lzsrth@yahoo.com.cn','93','jiedai','此用户在其他网站有借款','附加信息附加信息附加信息附加信息','1342970429','113.247.35.168');");
DB_I("replace into `lzh_jubao` values('2','108','342556015@qq.com','1','test','此用户在其他网站有借款','枯仍枯仍fsd wefwef','1344795356','127.0.0.1');");
DB_I("replace into `lzh_jubao` values('3','2975','1037525011@qq.com','2975','邮政银行李行长','此用户冒用他人身份','qe akdv sk;sajf','1348839540','221.235.71.40');");
?>
作者：hutao100
项目：yint
<?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','','顶顶顶顶,好标');");
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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');");
作者：hutao100
项目：yint
<?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','');");
?>
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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');");
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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");
?>
作者：hutao100
项目：yint
<?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");
?>
