# Identify: MTU2ODYxMDQwMiw1LjlFIFVURi04LG15bXBzLCwx # # Mymps Multi-Volume Data Dump Vol.1 # Version: Mymps 5.9E UTF-8 # Time: 2019-09-16 13:06:42 # Type: mymps # Table Prefix: my_ # # Mymps Home: http://www.mymps.com.cn # Please visit our website for newest infomation about Mymps # -------------------------------------------------------- SET NAMES 'utf8'; DROP TABLE IF EXISTS my_about; CREATE TABLE my_about ( id int(5) NOT NULL AUTO_INCREMENT, typename char(25) NOT NULL, content mediumtext NOT NULL, displayorder smallint(3) NOT NULL, pubdate int(10) NOT NULL, dir_type tinyint(1) NOT NULL, dir_typename varchar(100) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4; INSERT INTO my_about VALUES ('1','网站简介','

\r\n mymps（蚂蚁分类信息/地方门户系统）是一款基于php mysql的建站系统.为在各种服务器上架设分类信息以及地方门户网站提供完美的解决方案。 mymps,整站生成静态，拥有世界一流的用户体验，卓越的访问速度和负载能力。\r\n

\r\n

\r\n mymps(php分类信息系统/php地方门户系统)能让你在最短的时间架设一个专业的分类信息/地方门户网站，是一款专注分类信息领域的CMS内容管理系统，能以最低的成本，最少的人力投入，在最短的时间内架设一个功能齐全，性能优异规模庞大并且易于维护的网站平台。\r\n

\r\n

\r\n 客户指导技术、技术服从于客户需要
\r\n 做客户切身需要的网站系统是我们所倡导和坚持的一贯原则
\r\n 我们在系统开发上遵循人性化设计、实用、创新、力求完美\r\n

','1','0','2','wangzhanjianjie'); INSERT INTO my_about VALUES ('2','广告服务','在这里填写广告服务，填写完成后保存提交即可','2','1263483208','4','advertisement'); INSERT INTO my_about VALUES ('3','联系我们','在这里填写联系方式，填写完成后保存提交即可','3','1259399384','4','contactus'); DROP TABLE IF EXISTS my_admin; CREATE TABLE my_admin ( id int(10) unsigned NOT NULL AUTO_INCREMENT, 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 smallint(5) unsigned NOT NULL DEFAULT '0', logintime int(10) unsigned NOT NULL DEFAULT '0', loginip varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2; INSERT INTO my_admin VALUES ('1','admin','790371d08a8155bf9800400222898ece','admin','','28762@163.com','1','1568610342','27.18.31.81'); DROP TABLE IF EXISTS my_admin_record_action; CREATE TABLE my_admin_record_action ( id int(11) NOT NULL AUTO_INCREMENT, adminid char(30) NOT NULL, pubdate int(10) NOT NULL, ip varchar(20) NOT NULL, `action` varchar(100) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3; INSERT INTO my_admin_record_action VALUES ('1','admin','1568216930','106.112.67.215','模板设置更新成功！'); INSERT INTO my_admin_record_action VALUES ('2','admin','1568217010','123.180.83.128','导航链接设置更新成功！'); DROP TABLE IF EXISTS my_admin_record_login; CREATE TABLE my_admin_record_login ( id int(11) unsigned NOT NULL AUTO_INCREMENT, adminid char(32) NOT NULL, adminpwd char(30) NOT NULL, pubdate int(10) NOT NULL, ip varchar(20) NOT NULL, result tinyint(1) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4; INSERT INTO my_admin_record_login VALUES ('1','admin','790371d08a8155bf9800400222898e','1568216812','106.112.66.163','1'); INSERT INTO my_admin_record_login VALUES ('2','admin','790371d08a8155bf9800400222898e','1568468048','218.11.245.160','1'); INSERT INTO my_admin_record_login VALUES ('3','admin','790371d08a8155bf9800400222898e','1568610342','27.18.31.81','1'); DROP TABLE IF EXISTS my_admin_type; CREATE TABLE my_admin_type ( id smallint(5) NOT NULL AUTO_INCREMENT, typename varchar(30) NOT NULL, ifsystem tinyint(1) NOT NULL, purviews mediumtext NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2; INSERT INTO my_admin_type VALUES ('1','超级管理员','1','purview_幻灯片列表,purview_上传幻灯片,purview_栏目设置,purview_已发布公告,purview_发布公告,purview_问题帮助,purview_发布帮助主题,purview_友情链接,purview_增加链接,purview_链接导航,purview_生活百宝箱,purview_便民电话,purview_分类信息,purview_删除重复,purview_批量管理,purview_信息评论,purview_信息举报,purview_模型管理,purview_字段管理,purview_网站会员,purview_审核会员,purview_增加会员,purview_会员组,purview_实名认证,purview_会员文章,purview_站内短消息,purview_模板点评,purview_会员登录记录,purview_会员支付记录,purview_会员消费记录,purview_信息分类,purview_添加分类,purview_地区分类,purview_增加地区,purview_商家分类,purview_增加分类,purview_用户列表,purview_用户组,purview_管理记录,purview_数据库备份,purview_数据库还原,purview_数据库维护,purview_系统配置,purview_模板管理,purview_SEO伪静态,purview_验证过滤点评,purview_积分信用等级,purview_缓存设置,purview_系统优化,purview_文字内链设置,purview_附件管理,purview_手机访问设置,purview_已安装插件,purview_新闻管理,purview_新闻类别,purview_新闻评论,purview_商品分类,purview_商品管理,purview_订单管理,purview_邮件服务器,purview_邮件模板,purview_邮件发送记录,purview_短信接口,purview_短信发送记录,purview_管理支付接口,purview_管理广告位,purview_数据调用,purview_第三方账号整合'); DROP TABLE IF EXISTS my_advertisement; CREATE TABLE my_advertisement ( advid mediumint(8) unsigned NOT NULL AUTO_INCREMENT, available tinyint(1) NOT NULL DEFAULT '0', `type` varchar(50) NOT NULL DEFAULT '0', displayorder tinyint(3) NOT NULL DEFAULT '0', title varchar(50) NOT NULL DEFAULT '', targets mediumtext NOT NULL, parameters mediumtext NOT NULL, `code` mediumtext NOT NULL, starttime int(10) unsigned NOT NULL DEFAULT '0', endtime int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (advid) ) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 AUTO_INCREMENT=59; INSERT INTO my_advertisement VALUES ('9','0','couplead','6','对联广告','index','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:31:\"/attachment/ggg/couplefloat.jpg\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:0:\"\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:787:\"theFloaters.addItem(\'coupleAdL\',6,0,\'

关闭
\');theFloaters.addItem(\'coupleAdR\',\'document.body.clientWidth-6\',0,\'

关闭
\');\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','theFloaters.addItem(\'coupleAdL\',6,0,\'

关闭
\');theFloaters.addItem(\'coupleAdR\',\'document.body.clientWidth-6\',0,\'

关闭
\');','1159632000','0'); INSERT INTO my_advertisement VALUES ('12','1','footerbanner','31','尾部通栏广告','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:29:\"/attachment/ggg/topbanner.png\";s:4:\"link\";s:31:\"https://www.mayicms.com/buy.htm\";s:5:\"width\";s:4:\"1200\";s:6:\"height\";s:2:\"40\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:139:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('14','1','infoad','41','信息页内广告','41 42 43 45 46 47 48 49 50 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:24:\"/attachment/ggg/ggad.gif\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:0:\"\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:79:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('55','1','infoad','0','信息页内广告2','3 41 42 43 45 46 47 48 49 50 1 11 148 149 150 151 152 153 154 155 156 157 158 159 12 13 14 169 170 171 172 173 15 16 160 161 162 163 164 165 166 167 168 17 18 19 20 21 22 23 24 25 26 27 2 28 29 30 31 32 33 34 35 36 37 38 39 40 4 51 52 53 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 54 55 56 57 58 59 60 61 62 63 64 65 66 67 5 68 69 70 71 72 73 74 6 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 7 90 91 92 93 94 8 95 96 97 98 99 9 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 10 137 138 139 140 141 142 143 144 145 146 147','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:27:\"/attachment/ggg/acenter.jpg\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:0:\"\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:82:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('57','1','indexcatad','0','首页分类间广告4','4','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:30:\"/attachment/ggg/topbanner1.png\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:4:\"1200\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:98:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('16','0','normalad','61','自定义广告','','a:4:{s:5:\"style\";s:4:\"code\";s:4:\"html\";s:28:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','1263312000','1263484800'); INSERT INTO my_advertisement VALUES ('21','1','indexcatad','81','求职首页分类间','6','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:30:\"/attachment/ggg/topbanner2.gif\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:4:\"1200\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:98:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('22','1','intercatad','11','栏目侧边页广告','all','a:4:{s:5:\"style\";s:4:\"code\";s:4:\"html\";s:82:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('25','0','normalad','5','自定义广告','','a:4:{s:5:\"style\";s:4:\"code\";s:4:\"html\";s:10:\"自定义广告\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','自定义广告','0','0'); INSERT INTO my_advertisement VALUES ('23','1','indexcatad','82','商务首页分类间','189','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:29:\"/attachment/ggg/topbanner.png\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:4:\"1200\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:97:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('24','1','intercatad','15','栏目侧边广告3','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:31:\"/attachment/ggg/intercatad2.jpg\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:3:\"160\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:98:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('56','0','topbanner','0','顶部横幅广告2','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:29:\"/attachment/ggg/topbanner.gif\";s:4:\"link\";s:31:\"https://www.mayicms.com/buy.htm\";s:5:\"width\";s:4:\"1200\";s:6:\"height\";s:2:\"40\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:139:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('28','0','headerbanner','11','页头通栏广告1','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:33:\"/attachment/ggg/headerbanner6.gif\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:3:\"152\";s:6:\"height\";s:2:\"70\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:112:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('29','0','headerbanner','12','页头通栏广告2','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:33:\"/attachment/ggg/headerbanner3.gif\";s:4:\"link\";s:31:\"https://www.mayicms.com/buy.htm\";s:5:\"width\";s:3:\"152\";s:6:\"height\";s:2:\"70\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:142:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('30','0','headerbanner','13','页头通栏广告3','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:33:\"/attachment/ggg/headerbanner5.gif\";s:4:\"link\";s:31:\"https://www.mayicms.com/buy.htm\";s:5:\"width\";s:3:\"152\";s:6:\"height\";s:2:\"70\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:142:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('31','0','headerbanner','14','页头通栏广告4','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:33:\"/attachment/ggg/headerbanner1.gif\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:3:\"140\";s:6:\"height\";s:2:\"70\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:112:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('32','0','headerbanner','15','页头通栏广告5','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:33:\"/attachment/ggg/headerbanner2.gif\";s:4:\"link\";s:31:\"https://www.mayicms.com/buy.htm\";s:5:\"width\";s:3:\"150\";s:6:\"height\";s:2:\"70\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:142:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('33','0','headerbanner','16','页头通栏广告6','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:33:\"/attachment/ggg/headerbanner4.gif\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:3:\"140\";s:6:\"height\";s:2:\"70\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:112:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('34','0','headerbanner','17','页头通栏广告7','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:33:\"/attachment/ggg/headerbanner7.gif\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:3:\"140\";s:6:\"height\";s:2:\"70\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:112:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('36','1','intercatad','10','栏目侧边广告2','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:31:\"/attachment/ggg/intercatad2.gif\";s:4:\"link\";s:1:\"#\";s:5:\"width\";s:0:\"\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:86:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('38','1','indexcatad','2','首页分类间广告3','1','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:27:\"/attachment/ggg/pagetop.gif\";s:4:\"link\";s:31:\"https://www.mayicms.com/buy.htm\";s:5:\"width\";s:4:\"1200\";s:6:\"height\";s:0:\"\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:125:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); INSERT INTO my_advertisement VALUES ('41','1','interlistad','0','栏目列表广告（二手市场）','all','a:4:{s:5:\"style\";s:4:\"code\";s:4:\"html\";s:114:\"我是栏目列表间广告，显示在列表最上端
\r\n我可以以文字，图片，联盟广告代码，flash各种形式存在 ^_^\";s:8:\"position\";s:3:\"top\";s:12:\"displayorder\";s:0:\"\";}','我是栏目列表间广告，显示在列表最上端
\r\n我可以以文字，图片，联盟广告代码，flash各种形式存在 ^_^','0','0'); INSERT INTO my_advertisement VALUES ('45','1','interlistad','0','栏目列表广告（跳蚤市场2）','all','a:4:{s:5:\"style\";s:4:\"code\";s:4:\"html\";s:182:\"我也是栏目列表间广告，我也可以显示在列表尾部
我也可以被添加多次，和其它广告位一样可以添加百度以及阿里妈妈等联盟广告\";s:8:\"position\";s:6:\"bottom\";s:12:\"displayorder\";s:0:\"\";}','我也是栏目列表间广告，我也可以显示在列表尾部
我也可以被添加多次，和其它广告位一样可以添加百度以及阿里妈妈等联盟广告','0','0'); INSERT INTO my_advertisement VALUES ('46','1','interlistad','0','栏目列表广告（车辆）','all','a:4:{s:5:\"style\";s:4:\"code\";s:4:\"html\";s:195:\"2011款Jeep牧马人现41.89万起www.Jeep.com.cn
\r\nJeep牧马人,终极四驱利器,强大的四驱动力.Sahara两门款41.89万;Rubicon两门款47.89万....\";s:8:\"position\";s:3:\"top\";s:12:\"displayorder\";s:0:\"\";}','2011款Jeep牧马人现41.89万起www.Jeep.com.cn
\r\nJeep牧马人,终极四驱利器,强大的四驱动力.Sahara两门款41.89万;Rubicon两门款47.89万....','0','0'); INSERT INTO my_advertisement VALUES ('49','1','interlistad','0','栏目列表广告（交友）','all','a:4:{s:5:\"style\";s:4:\"code\";s:4:\"html\";s:213:\"找对象 上某某佳缘网
中国最受网民信赖、第一家在美上市的交友网站。提供丰富多彩的交友活动，数百万会员在这里成功找到对象。现有四千多万真实交友会员，让缘分千万里挑一！\";s:8:\"position\";s:3:\"top\";s:12:\"displayorder\";s:0:\"\";}','找对象 上某某佳缘网
中国最受网民信赖、第一家在美上市的交友网站。提供丰富多彩的交友活动，数百万会员在这里成功找到对象。现有四千多万真实交友会员，让缘分千万里挑一！','0','0'); INSERT INTO my_advertisement VALUES ('50','1','interlistad','0','栏目列表广告（商务）','all','a:4:{s:5:\"style\";s:4:\"code\";s:4:\"html\";s:177:\"北京某某圆财务咨询有限公司 https://www.mayicms.com/buy.htm
北京公司注册 北京代理记账 大额增资 审计环评卫生许可证 18888888888\";s:8:\"position\";s:6:\"bottom\";s:12:\"displayorder\";s:0:\"\";}','北京某某圆财务咨询有限公司 https://www.mayicms.com/buy.htm
北京公司注册 北京代理记账 大额增资 审计环评卫生许可证 18888888888','0','0'); INSERT INTO my_advertisement VALUES ('58','0','headerbanner','0','页头通栏广告8','all','a:9:{s:5:\"style\";s:5:\"image\";s:3:\"url\";s:33:\"/attachment/ggg/headerbanner5.gif\";s:4:\"link\";s:31:\"https://www.mayicms.com/buy.htm\";s:5:\"width\";s:3:\"152\";s:6:\"height\";s:2:\"70\";s:3:\"alt\";s:0:\"\";s:4:\"html\";s:142:\"\";s:8:\"position\";N;s:12:\"displayorder\";s:0:\"\";}','','0','0'); DROP TABLE IF EXISTS my_announce; CREATE TABLE my_announce ( id int(10) NOT NULL AUTO_INCREMENT, title varchar(100) NOT NULL, redirecturl varchar(250) NOT NULL, titlecolor char(10) NOT NULL, content mediumtext NOT NULL, author varchar(20) NOT NULL, pubdate int(10) NOT NULL, begintime int(10) NOT NULL, endtime int(10) NOT NULL, hits int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_area; CREATE TABLE my_area ( areaid mediumint(6) NOT NULL AUTO_INCREMENT, areaname varchar(32) NOT NULL, parentid int(11) unsigned NOT NULL, areaorder smallint(6) NOT NULL, PRIMARY KEY (areaid) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2; INSERT INTO my_area VALUES ('1','地区1','0','1'); DROP TABLE IF EXISTS my_badwords; CREATE TABLE my_badwords ( words mediumtext NOT NULL, `view` varchar(100) NOT NULL, ifcheck tinyint(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO my_badwords VALUES ('轮功','**','1'); DROP TABLE IF EXISTS my_cache; CREATE TABLE my_cache ( id smallint(3) NOT NULL AUTO_INCREMENT, `page` varchar(20) NOT NULL, `time` int(10) NOT NULL, `open` tinyint(1) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=327 DEFAULT CHARSET=utf8 AUTO_INCREMENT=327; INSERT INTO my_cache VALUES ('318','site','0','0'); INSERT INTO my_cache VALUES ('319','list','0','0'); INSERT INTO my_cache VALUES ('320','info','0','0'); INSERT INTO my_cache VALUES ('321','aboutus','0','0'); INSERT INTO my_cache VALUES ('322','announce','0','0'); INSERT INTO my_cache VALUES ('323','faq','0','0'); INSERT INTO my_cache VALUES ('324','friendlink','0','0'); INSERT INTO my_cache VALUES ('325','sitemap','0','0'); INSERT INTO my_cache VALUES ('326','changecity','0','0'); DROP TABLE IF EXISTS my_category; CREATE TABLE my_category ( catid mediumint(6) NOT NULL AUTO_INCREMENT, if_view tinyint(1) NOT NULL DEFAULT '1', color char(10) NOT NULL, catname varchar(32) NOT NULL, icon varchar(100) NOT NULL, usecoin mediumint(8) NOT NULL DEFAULT '0', title varchar(250) NOT NULL, keywords varchar(255) DEFAULT NULL, description varchar(255) DEFAULT NULL, parentid int(11) DEFAULT NULL, gid smallint(5) NOT NULL, modid smallint(5) NOT NULL, catorder smallint(6) NOT NULL, if_upimg tinyint(1) NOT NULL DEFAULT '1', if_mappoint tinyint(1) NOT NULL DEFAULT '0', dir_type tinyint(1) NOT NULL, dir_typename varchar(100) NOT NULL, template varchar(20) NOT NULL DEFAULT 'list', template_info varchar(20) NOT NULL DEFAULT 'info', html_dir varchar(200) NOT NULL, htmlpath varchar(200) NOT NULL, PRIMARY KEY (catid), KEY parentid (parentid), KEY catname (catname), KEY catorder (catorder) ) ENGINE=MyISAM AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 AUTO_INCREMENT=190; INSERT INTO my_category VALUES ('1','2','','二手转让','/template/default/images/index/icon_ershou.gif','0','','','','0','1','2','2','1','0','4','ershou','list','info','/ershou/',''); INSERT INTO my_category VALUES ('2','2','','车辆买卖','/template/default/images/index/icon_che.gif','0','','','','0','2','1','3','1','0','4','che','list','info','/che/',''); INSERT INTO my_category VALUES ('3','2','','房屋租售','/template/default/images/index/icon_fang.gif','0','','','','0','3','1','1','1','1','4','fang','list','info','/fang/',''); INSERT INTO my_category VALUES ('4','2','','全职招聘','/template/default/images/index/icon_zhaopin.gif','-1','','','','0','4','7','5','1','1','4','zhaopin','list_zhaopin','info_zp','/zhaopin/',''); INSERT INTO my_category VALUES ('5','2','','兼职招聘','/template/default/images/index/icon_jzzhaopin.gif','-1','','','','0','5','8','6','1','1','4','jianzhi','list_zhaopin','info_zp','/jianzhi/',''); INSERT INTO my_category VALUES ('6','2','','求职简历','/template/default/images/index/icon_jianli.gif','1','','','','0','6','9','7','1','0','4','qiuzhi','list_qiuzhi','info_resume','/qiuzhi/',''); INSERT INTO my_category VALUES ('7','2','','交友活动','/template/default/images/index/icon_love.gif','0','','','','0','7','1','8','1','0','4','jiaoyou','list','info','/jiaoyou/',''); INSERT INTO my_category VALUES ('8','2','','宠物','/template/default/images/index/icon_pet.gif','0','','','','0','8','1','9','1','0','4','chongwu','list','info','/chongwu/',''); INSERT INTO my_category VALUES ('9','2','','生活服务','/template/default/images/index/icon_life.gif','0','','','','0','9','1','10','1','1','4','shenghuo','list_box','info','/shenghuo/',''); INSERT INTO my_category VALUES ('10','2','','教育培训','/template/default/images/index/icon_edu.gif','0','','','','0','10','10','12','1','0','4','jiaoyu','list_simple','info','/jiaoyu/',''); INSERT INTO my_category VALUES ('11','2','#ff0000','手机转让','','0','','','','1','1','28','13','1','0','4','shouji','list_ershou','info','/ershou/shouji/',''); INSERT INTO my_category VALUES ('12','2','','台式机/笔记本','','0','','','','1','1','6','14','1','0','4','diannao','list_ershou','info','/ershou/diannao/',''); INSERT INTO my_category VALUES ('13','2','','平板电脑','','0','','','','1','1','6','15','1','0','4','pingban','list_ershou','info','/ershou/pingban/',''); INSERT INTO my_category VALUES ('14','2','#46a200','数码产品转让','','0','','','','1','1','2','16','1','0','4','shuma','list_ershou','info','/ershou/shuma/',''); INSERT INTO my_category VALUES ('15','2','','家具/办公家具','','0','','','','1','1','2','17','1','0','4','jiaju','list_ershou','info','/ershou/jiaju/',''); INSERT INTO my_category VALUES ('16','2','#ff9900','家用电器','','0','','','','1','1','2','18','1','0','4','jiadian','list_ershou','info','/ershou/jiadian/',''); INSERT INTO my_category VALUES ('17','2','','日常用品','','0','','','','1','1','2','19','1','0','4','riyongpin','list_ershou','info','/ershou/riyongpin/',''); INSERT INTO my_category VALUES ('18','2','','办公经营设备','','0','','','','1','1','2','20','1','0','4','bangong','list_ershou','info','/ershou/bangong/',''); INSERT INTO my_category VALUES ('19','2','','收藏品/工艺品','','0','','','','1','1','2','21','1','0','4','shoucang','list_ershou','info','/ershou/shoucang/',''); INSERT INTO my_category VALUES ('20','2','','服装/配饰/鞋包','','0','','','','1','1','2','22','1','0','4','fushi','list_ershou','info','/ershou/fushi/',''); INSERT INTO my_category VALUES ('21','2','','母婴/玩具','','0','','','','1','1','2','23','1','0','4','yingyou','list_ershou','info','/ershou/yingyou/',''); INSERT INTO my_category VALUES ('22','2','','运动/图书/乐器','','0','','','','1','1','2','24','1','0','4','wenti','list_ershou','info','/ershou/wenti/',''); INSERT INTO my_category VALUES ('23','2','','门票卡券','','0','','','','1','1','2','25','1','0','4','piao','list_ershou','info','/ershou/piao/',''); INSERT INTO my_category VALUES ('24','2','','工业设备','','0','','','','1','1','2','26','1','0','4','gongyeshebei','list_ershou','info','/wupinjiaoyi/gongyeshebei/',''); INSERT INTO my_category VALUES ('25','2','','物品回收','','0','','','','1','1','2','27','1','0','4','huishou','list_ershou','info','/ershou/huishou/',''); INSERT INTO my_category VALUES ('26','2','','设备租赁','','0','','','','1','1','2','28','1','0','4','zulin','list_ershou','info','/ershou/zulin/',''); INSERT INTO my_category VALUES ('27','2','','其他物品','','0','','','','1','1','2','29','1','0','4','qitaershou','list_ershou','info','/ershou/qitaershou/',''); INSERT INTO my_category VALUES ('28','2','','二手轿车','','0','','','','2','2','12','31','1','0','4','jiaoche','list','info','/che/jiaoche/',''); INSERT INTO my_category VALUES ('29','2','','货车/工程车','','0','','','','2','2','16','32','1','0','4','huoche','list','info','/che/huoche/',''); INSERT INTO my_category VALUES ('30','2','','面包车/客车','','0','','','','2','2','15','33','1','0','4','keche','list','info','/che/keche/',''); INSERT INTO my_category VALUES ('31','2','','拖拉机/收割机','','0','','','','2','2','16','34','1','0','4','tuolaji','list','info','/che/tuolaji/',''); INSERT INTO my_category VALUES ('32','2','','拼车/顺风车','','0','','','','2','2','14','35','1','0','4','pinche','list','info','/che/pinche/',''); INSERT INTO my_category VALUES ('33','2','','新车优惠/4S店','','0','','','','2','2','12','36','1','0','4','xincheyouhui','list','info','/che/xincheyouhui/',''); INSERT INTO my_category VALUES ('34','2','','汽车用品/配件','','0','','','','2','2','2','37','1','0','4','peijian','list','info','/che/peijian/',''); INSERT INTO my_category VALUES ('35','2','','汽修保养','','0','','','','2','2','1','38','1','0','4','qixiu','list','info','/che/qixiu/',''); INSERT INTO my_category VALUES ('36','2','','车辆收购服务','','0','','','','2','2','1','39','1','0','4','cheliangsg','list','info','/che/cheliangsg/',''); INSERT INTO my_category VALUES ('37','2','','摩托车/燃气车','','0','','','','2','2','27','40','1','0','4','motuoche','list','info','/che/motuoche/',''); INSERT INTO my_category VALUES ('38','2','','电动车','','0','','','','2','2','11','41','1','0','4','diandongche','list','info','/che/diandongche/',''); INSERT INTO my_category VALUES ('39','2','','自行车','','0','','','','2','2','13','42','1','0','4','zixingche','list','info','/che/zixingche/',''); INSERT INTO my_category VALUES ('40','2','','本地下线车','','0','','','','2','2','16','43','1','0','4','xiaxianche','list','info','/che/xiaxianche/',''); INSERT INTO my_category VALUES ('41','2','','房屋出租','','0','','','','3','3','23','45','1','1','4','chuzu','list_zufang','info','/fang/chuzu/',''); INSERT INTO my_category VALUES ('42','2','','日租/短租','','0','','','','3','3','1','46','1','1','4','duanzu','list','info','/fang/duanzu/',''); INSERT INTO my_category VALUES ('43','2','','二手房出售','','0','','','','3','3','22','47','1','1','4','ershoufang','list_house','info','/fang/ershoufang/',''); INSERT INTO my_category VALUES ('45','2','','店铺转让/出租','','0','','','','3','3','1','49','1','1','4','zhuanrang','list','info','/fang/zhuanrang/',''); INSERT INTO my_category VALUES ('46','2','','商铺出售','','0','','','','3','3','1','50','1','1','4','shangpu','list','info','/fang/shangpu/',''); INSERT INTO my_category VALUES ('47','2','','写字楼出租','','0','','','','3','3','24','51','1','1','4','xieziloucz','list','info','/fang/xieziloucz/',''); INSERT INTO my_category VALUES ('48','2','','写字楼出售','','0','','','','3','3','25','52','1','1','4','xieziloucs','list','info','/fang/xieziloucs/',''); INSERT INTO my_category VALUES ('49','2','','厂房/仓库/土地','','0','','','','3','3','24','53','1','1','4','changfang','list','info','/fang/changfang/',''); INSERT INTO my_category VALUES ('50','2','','求租/求购','','0','','','','3','3','1','54','1','1','4','qiufang','list','info','/fang/qiufang/',''); INSERT INTO my_category VALUES ('51','2','','营业员/促销/零售','','-1','','','','4','4','7','56','1','1','4','lingshou','list_zhaopin','info_zp','/zhaopin/lingshou/',''); INSERT INTO my_category VALUES ('52','2','','服务员/收银员','','-1','','','','4','4','7','57','1','1','4','fuwuyuan','list_zhaopin','info_zp','/zhaopin/fuwuyuan/',''); INSERT INTO my_category VALUES ('53','2','#ff0000','销售/市场/业务员','','-1','','','','4','4','7','58','1','1','4','yewu','list_zhaopin','info_zp','/zhaopin/yewu/',''); INSERT INTO my_category VALUES ('54','2','','文员/客服/助理','','-1','','','','4','4','7','59','1','1','4','wenyuan','list_zhaopin','info_zp','/zhaopin/wenyuan/',''); INSERT INTO my_category VALUES ('55','2','','保姆/家政','','-1','','','','4','4','7','60','1','1','4','baomu','list_zhaopin','info_zp','/zhaopin/baomu/',''); INSERT INTO my_category VALUES ('56','2','','司机/驾驶员','','-1','','','','4','4','7','61','1','1','4','jiashi','list_zhaopin','info_zp','/zhaopin/jiashi/',''); INSERT INTO my_category VALUES ('57','2','','保安/保洁','','-1','','','','4','4','7','62','1','1','4','baoan','list_zhaopin','info_zp','/zhaopin/baoan/',''); INSERT INTO my_category VALUES ('58','2','','厨师/切配','','-1','','','','4','4','7','63','1','1','4','chushi','list_zhaopin','info_zp','/zhaopin/chushi/',''); INSERT INTO my_category VALUES ('59','2','','送货/快递/仓管','','-1','','','','4','4','7','64','1','1','4','kuaidi','list_zhaopin','info_zp','/zhaopin/kuaidi/',''); INSERT INTO my_category VALUES ('60','2','','工人/技工','','-1','','','','4','4','7','65','1','1','4','gongren','list_zhaopin','info_zp','/zhaopin/gongren/',''); INSERT INTO my_category VALUES ('61','2','','财务/会计','','-1','','','','4','4','7','66','1','1','4','caiwu','list_zhaopin','info_zp','/zhaopin/caiwu/',''); INSERT INTO my_category VALUES ('62','2','','老师/培训师','','-1','','','','4','4','7','67','1','1','4','laoshi','list_zhaopin','info_zp','/zhaopin/laoshi/',''); INSERT INTO my_category VALUES ('63','2','','美工/设计/程序员','','-1','','','','4','4','7','68','1','1','4','meigong','list_zhaopin','info_zp','/zhaopin/meigong/',''); INSERT INTO my_category VALUES ('64','2','','保健师/美容师','','-1','','','','4','4','7','69','1','1','4','baojianshi','list_zhaopin','info_zp','/zhaopin/baojianshi/',''); INSERT INTO my_category VALUES ('65','2','','人才招聘会','','-1','','','','4','4','7','70','1','1','4','zhaopinhui','list_zhaopin','info_zp','/zhaopin/zhaopinhui/',''); INSERT INTO my_category VALUES ('66','2','','KTV/酒吧','','-1','','','','4','4','7','71','1','1','4','ktv','list_zhaopin','info_zp','/zhaopin/ktv/',''); INSERT INTO my_category VALUES ('67','2','','其他招聘','','-1','','','','4','4','7','72','1','1','4','qitazhaopin','list_zhaopin','info_zp','/quanzhizhaopin/qitazhaopin/',''); INSERT INTO my_category VALUES ('68','2','','派发/促销','','-1','','','','5','5','8','74','1','1','4','jzcuxiao','list_zhaopin','info_zp','/jianzhi/jzcuxiao/',''); INSERT INTO my_category VALUES ('69','2','','家教/老师','','-1','','','','5','5','8','75','1','1','4','jzjiajiao','list_zhaopin','info_zp','/jianzhi/jzjiajiao/',''); INSERT INTO my_category VALUES ('70','2','','餐厅/服务员','','-1','','','','5','5','8','76','1','1','4','jzfuwuyuan','list_zhaopin','info_zp','/jianzhi/jzfuwuyuan/',''); INSERT INTO my_category VALUES ('71','2','','模特/礼仪','','-1','','','','5','5','8','77','1','1','4','jzmote','list_zhaopin','info_zp','/jianzhi/jzmote/',''); INSERT INTO my_category VALUES ('72','2','','网站/设计','','-1','','','','5','5','8','78','1','1','4','jzwangzhan','list_zhaopin','info_zp','/jianzhi/jzwangzhan/',''); INSERT INTO my_category VALUES ('73','2','','会计/财务','','-1','','','','5','5','8','79','1','1','4','jzcaiwu','list_zhaopin','info_zp','/jianzhi/jzcaiwu/',''); INSERT INTO my_category VALUES ('74','2','','其他兼职','','-1','','','','5','5','8','80','1','1','4','qitajianzhi','list_zhaopin','info_zp','/jianzhizhaopin/qitajianzhi/',''); INSERT INTO my_category VALUES ('75','2','','销售','','1','','','','6','6','9','82','1','0','4','qzxiaoshou','list_qiuzhi','info_resume','/qiuzhi/qzxiaoshou/',''); INSERT INTO my_category VALUES ('76','2','','客服','','1','','','','6','6','9','83','1','0','4','qzkefu','list_qiuzhi','info_resume','/qiuzhi/qzkefu/',''); INSERT INTO my_category VALUES ('77','2','','人事/行政/后勤','','1','','','','6','6','9','84','1','0','4','qzhouqin','list_qiuzhi','info_resume','/qiuzhi/qzhouqin/',''); INSERT INTO my_category VALUES ('78','2','','酒店/餐饮/旅游','','1','','','','6','6','9','85','1','0','4','qzcanyin','list_qiuzhi','info_resume','/qiuzhi/qzcanyin/',''); INSERT INTO my_category VALUES ('79','2','','美容/美发/保健/健身','','1','','','','6','6','9','86','1','0','4','qzmeirong','list_qiuzhi','info_resume','/qiuzhi/qzmeirong/',''); INSERT INTO my_category VALUES ('80','2','','计算机/网络/通信','','1','','','','6','6','9','87','1','0','4','qzcomputer','list_qiuzhi','info_resume','/qiuzhi/qzcomputer/',''); INSERT INTO my_category VALUES ('81','2','','建筑/房产/装修/物业','','1','','','','6','6','9','88','1','0','4','qzfangdichan','list_qiuzhi','info_resume','/qiuzhi/qzfangdichan/',''); INSERT INTO my_category VALUES ('82','2','','普工/技工/生产','','1','','','','6','6','9','89','1','0','4','qzjigong','list_qiuzhi','info_resume','/qiuzhi/qzjigong/',''); INSERT INTO my_category VALUES ('83','2','','司机','','1','','','','6','6','9','90','1','0','4','qzsiji','list_qiuzhi','info_resume','/qiuzhi/qzsiji/',''); INSERT INTO my_category VALUES ('84','2','','家政保洁/安保','','1','','','','6','6','9','91','1','0','4','qzjiazheng','list_qiuzhi','info_resume','/qiuzhi/qzjiazheng/',''); INSERT INTO my_category VALUES ('85','2','','影视/娱乐/KTV','','1','','','','6','6','9','92','1','0','4','qzktv','list_qiuzhi','info_resume','/qiuzhi/qzktv/',''); INSERT INTO my_category VALUES ('86','2','','编辑/出版/印刷','','1','','','','6','6','9','93','1','0','4','qzyinshua','list_qiuzhi','info_resume','/qiuzhi/qzyinshua/',''); INSERT INTO my_category VALUES ('87','2','','教育培训/翻译','','1','','','','6','6','9','94','1','0','4','qzjiaoyu','list_qiuzhi','info_resume','/qiuzhi/qzjiaoyu/',''); INSERT INTO my_category VALUES ('88','2','','财务/审计/统计','','1','','','','6','6','9','95','1','0','4','qzshenji','list_qiuzhi','info_resume','/qiuzhi/qzshenji/',''); INSERT INTO my_category VALUES ('89','2','','其他职位','','1','','','','6','6','9','96','1','0','4','qitazhiwei','list_qiuzhi','info_resume','/qiuzhijianli/qitazhiwei/',''); INSERT INTO my_category VALUES ('90','2','','找女友/找男友','','0','','','','7','7','19','98','1','0','4','zhaoduixiang','list','info','/jiaoyou/zhaoduixiang/',''); INSERT INTO my_category VALUES ('91','2','','征婚','','0','','','','7','7','19','99','1','0','4','zhenghun','list','info','/jiaoyou/zhenghun/',''); INSERT INTO my_category VALUES ('92','2','','结伴活动','','0','','','','7','7','1','100','1','0','4','huodong','list','info','/jiaoyou/huodong/',''); INSERT INTO my_category VALUES ('93','2','','技能交换','','0','','','','7','7','18','101','1','0','4','jineng','list','info','/jiaoyou/jineng/',''); INSERT INTO my_category VALUES ('94','2','','找人/寻物','','0','','','','7','7','1','102','1','0','4','zhaoren','list','info','/jiaoyou/zhaoren/',''); INSERT INTO my_category VALUES ('95','2','','狗狗','','0','','','','8','8','20','104','1','0','4','gou','list_pet','info','/chongwu/gou/',''); INSERT INTO my_category VALUES ('96','2','','猫猫/其他宠物','','0','','','','8','8','21','105','1','0','4','mao','list','info','/chongwu/mao/',''); INSERT INTO my_category VALUES ('97','2','','宠物免费赠送','','0','','','','8','8','1','106','1','0','4','songchongwu','list','info','/chongwu/songchongwu/',''); INSERT INTO my_category VALUES ('98','2','','宠物用品/食品','','0','','','','8','8','1','107','1','0','4','shipin','list','info','/chongwu/shipin/',''); INSERT INTO my_category VALUES ('99','2','','宠物服务/配种','','0','','','','8','8','1','108','1','0','4','peizhong','list','info','/chongwu/peizhong/',''); INSERT INTO my_category VALUES ('100','2','','驾校服务','','0','','','','9','9','1','110','1','1','4','jiaxiao','list_box','info','/fuwu/jiaxiao/',''); INSERT INTO my_category VALUES ('101','2','','陪驾/代驾','','0','','','','9','9','1','111','1','1','4','daijia','list_box','info','/fuwu/daijia/',''); INSERT INTO my_category VALUES ('102','2','','婚庆/化妆','','0','','','','9','9','1','112','1','1','4','hunqing','list_box','info','/fuwu/hunqing/',''); INSERT INTO my_category VALUES ('103','2','','摄影摄像','','0','','','','9','9','1','113','1','1','4','sheying','list_box','info','/fuwu/sheying/',''); INSERT INTO my_category VALUES ('104','2','','美容纤体','','0','','','','9','9','1','114','1','1','4','meirong','list_box','info','/fuwu/meirong/',''); INSERT INTO my_category VALUES ('105','2','','房屋装修','','0','','','','9','9','1','115','1','1','4','zhuangxiu','list_box','info','/fuwu/zhuangxiu/',''); INSERT INTO my_category VALUES ('106','2','','建材装饰','','0','','','','9','9','1','116','1','1','4','jiancai','list_box','info','/fuwu/jiancai/',''); INSERT INTO my_category VALUES ('107','2','','投资理财','','0','','','','9','9','1','117','1','1','4','licai','list_box','info','/fuwu/licai/',''); INSERT INTO my_category VALUES ('108','2','','保姆/月嫂','','0','','','','9','9','1','118','1','1','4','yuesao','list_box','info','/fuwu/yuesao/',''); INSERT INTO my_category VALUES ('109','2','#FF0000','保洁/家政','','0','','','','9','9','1','119','1','1','4','baojie','list_box','info','/shenghuo/baojie/',''); INSERT INTO my_category VALUES ('110','2','','搬家服务','','0','','','','9','9','1','120','1','1','4','banjia','list_box','info','/shenghuo/banjia/',''); INSERT INTO my_category VALUES ('111','2','','家电维修','','0','','','','9','9','1','121','1','1','4','xiujiandian','list_box','info','/fuwu/xiujiandian/',''); INSERT INTO my_category VALUES ('112','2','','电脑维修','','0','','','','9','9','1','122','1','1','4','xiudiannao','list_box','info','/fuwu/xiudiannao/',''); INSERT INTO my_category VALUES ('113','2','','家居维修','','0','','','','9','9','1','123','1','1','4','jiajuweixiu','list_box','info','/fuwu/jiajuweixiu/',''); INSERT INTO my_category VALUES ('114','2','','管道疏通','','0','','','','9','9','1','124','1','1','4','tongguandao','list_box','info','/fuwu/tongguandao/',''); INSERT INTO my_category VALUES ('115','2','','外卖/送水','','0','','','','9','9','1','125','1','1','4','waimai','list_box','info','/fuwu/waimai/',''); INSERT INTO my_category VALUES ('116','2','','开锁/修锁','','0','','','','9','9','1','126','1','1','4','kaisuo','list_box','info','/fuwu/kaisuo/',''); INSERT INTO my_category VALUES ('117','2','','租车服务','','0','','','','9','9','1','127','1','1','4','zuche','list_box','info','/fuwu/zuche/',''); INSERT INTO my_category VALUES ('118','2','','旅游度假','','0','','','','9','9','1','128','1','1','4','lvyou','list_box','info','/fuwu/lvyou/',''); INSERT INTO my_category VALUES ('119','2','','休闲娱乐','','0','','','','9','9','1','129','1','1','4','yule','list_box','info','/fuwu/yule/',''); INSERT INTO my_category VALUES ('120','2','','酒店/宾馆','','0','','','','9','9','1','130','1','1','4','jiudian','list_box','info','/fuwu/jiudian/',''); INSERT INTO my_category VALUES ('121','2','','签证服务','','0','','','','9','9','1','131','1','1','4','qianzheng','list_box','info','/shenghuo/qianzheng/',''); INSERT INTO my_category VALUES ('122','2','','招商加盟','','0','','','','189','189','1','132','1','1','4','zhaoshang','list_simple','info','/fuwu/zhaoshang/',''); INSERT INTO my_category VALUES ('123','2','','担保/贷款','','0','','','','189','189','1','133','1','1','4','daikuan','list_simple','info','/fuwu/daikuan/',''); INSERT INTO my_category VALUES ('124','2','#FF0000','公司注册','','0','','','','189','189','1','134','1','1','4','gongsizhuce','list_simple','info','/shangwufuwu/gongsizhuce/',''); INSERT INTO my_category VALUES ('125','2','','会计/审计','','0','','','','189','189','1','135','1','1','4','kuaiji','list_simple','info','/shenghuo/kuaiji/',''); INSERT INTO my_category VALUES ('126','2','','网站建设','','0','','','','189','189','1','136','1','1','4','wangzhan','list_simple','info','/fuwu/wangzhan/',''); INSERT INTO my_category VALUES ('127','2','','快递/物流','','0','','','','189','189','1','137','1','1','4','wuliu','list_simple','info','/fuwu/wuliu/',''); INSERT INTO my_category VALUES ('128','2','','庆典/演出','','0','','','','189','189','1','138','1','1','4','yanchu','list_simple','info','/fuwu/yanchu/',''); INSERT INTO my_category VALUES ('129','2','','印刷/喷绘','','0','','','','189','189','1','139','1','1','4','yinshua','list_simple','info','/fuwu/yinshua/',''); INSERT INTO my_category VALUES ('130','2','','设计策划','','0','','','','189','189','1','140','1','1','4','cehua','list_simple','info','/fuwu/cehua/',''); INSERT INTO my_category VALUES ('131','2','','律师服务','','0','','','','189','189','1','141','1','1','4','lvshi','list_simple','info','/fuwu/lvshi/',''); INSERT INTO my_category VALUES ('132','2','','翻译/速记','','0','','','','189','189','1','142','1','1','4','fanyi','list_simple','info','/fuwu/fanyi/',''); INSERT INTO my_category VALUES ('133','2','','鲜花/盆景','','0','','','','189','189','1','143','1','1','4','xianhua','list_simple','info','/fuwu/xianhua/',''); INSERT INTO my_category VALUES ('134','2','','礼品定制','','0','','','','189','189','1','144','1','1','4','lipin','list_simple','info','/fuwu/lipin/',''); INSERT INTO my_category VALUES ('135','2','','本地名站','','0','','','','189','189','1','145','1','1','4','mingzhan','list_simple','info','/fuwu/mingzhan/',''); INSERT INTO my_category VALUES ('136','2','','其他服务','','0','','','','189','189','1','146','1','1','4','qitafuwu','list_simple','info','/shenghuofuwu/qitafuwu/',''); INSERT INTO my_category VALUES ('137','2','','职业培训','','0','','','','10','10','10','148','1','0','4','zhiyepeixun','list_simple','info','/jiaoyu/zhiyepeixun/',''); INSERT INTO my_category VALUES ('138','2','','外语培训','','0','','','','10','10','10','149','1','0','4','waiyu','list_simple','info','/jiaoyu/waiyu/',''); INSERT INTO my_category VALUES ('139','2','','学历教育','','0','','','','10','10','10','150','1','0','4','xueli','list_simple','info','/jiaoyu/xueli/',''); INSERT INTO my_category VALUES ('140','2','','家教','','0','','','','10','10','10','151','1','0','4','jiajiao','list_simple','info','/jiaoyoupeixun/jiajiao/',''); INSERT INTO my_category VALUES ('141','2','','IT培训','','0','','','','10','10','10','152','1','0','4','jisuanji','list_simple','info','/jiaoyu/jisuanji/',''); INSERT INTO my_category VALUES ('142','2','','留学签证','','0','','','','10','10','10','153','1','0','4','liuxue','list_simple','info','/jiaoyu/liuxue/',''); INSERT INTO my_category VALUES ('143','2','','高等教育','','0','','','','10','10','10','154','1','0','4','gaodengjiaoyu','list_simple','info','/jiaoyoupeixun/gaodengjiaoyu/',''); INSERT INTO my_category VALUES ('144','2','','文体培训','','0','','','','10','10','10','155','1','0','4','techang','list_simple','info','/jiaoyu/techang/',''); INSERT INTO my_category VALUES ('145','2','','婴幼儿教育','','0','','','','10','10','10','156','1','0','4','youjiao','list_simple','info','/jiaoyu/youjiao/',''); INSERT INTO my_category VALUES ('146','2','','中小学教育','','0','','','','10','10','10','157','1','0','4','zhongxiaoxue','list_simple','info','/jiaoyu/zhongxiaoxue/',''); INSERT INTO my_category VALUES ('147','2','','其他培训','','0','','','','10','10','10','158','1','0','4','qitapeixun','list_simple','info','/jiaoyoupeixun/qitapeixun/',''); INSERT INTO my_category VALUES ('189','2','','商务服务','/template/default/images/index/icon_business.gif','0','','','','0','189','1','11','1','1','2','shangwu','list_simple','info','/shangwufuwu/',''); DROP TABLE IF EXISTS my_certification; CREATE TABLE my_certification ( id int(11) unsigned NOT NULL AUTO_INCREMENT, typeid tinyint(1) NOT NULL, userid varchar(30) NOT NULL, img_path varchar(250) NOT NULL, pubtime int(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_channel; CREATE TABLE my_channel ( catid mediumint(6) NOT NULL AUTO_INCREMENT, if_view tinyint(1) NOT NULL DEFAULT '1', color char(10) NOT NULL, catname varchar(32) NOT NULL, title varchar(250) NOT NULL, keywords varchar(255) DEFAULT NULL, description varchar(255) DEFAULT NULL, parentid int(11) DEFAULT NULL, catorder smallint(6) NOT NULL, dir_type tinyint(1) NOT NULL, dir_typename varchar(100) NOT NULL, html_dir varchar(200) NOT NULL, htmlpath varchar(200) NOT NULL, PRIMARY KEY (catid), KEY parentid (parentid), KEY catname (catname), KEY catorder (catorder) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_checkanswer; CREATE TABLE my_checkanswer ( id smallint(3) NOT NULL AUTO_INCREMENT, question varchar(250) NOT NULL, answer varchar(250) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AUTO_INCREMENT=7; INSERT INTO my_checkanswer VALUES ('1','2+3=?','5'); INSERT INTO my_checkanswer VALUES ('2','本站名称[答案:蚂蚁分类信息]','蚂蚁分类信息'); INSERT INTO my_checkanswer VALUES ('6','5+8=?','13'); INSERT INTO my_checkanswer VALUES ('5','2+5=?','7'); DROP TABLE IF EXISTS my_comment; CREATE TABLE my_comment ( id int(8) NOT NULL AUTO_INCREMENT, userid varchar(20) NOT NULL, content varchar(255) NOT NULL, pubtime int(10) NOT NULL, ip char(16) NOT NULL, comment_level tinyint(1) NOT NULL, typeid int(8) NOT NULL, `type` varchar(50) NOT NULL DEFAULT 'information', PRIMARY KEY (id), KEY userid (userid), KEY typeid (typeid,comment_level,`type`), KEY comment_level (comment_level) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_config; CREATE TABLE my_config ( description varchar(100) NOT NULL, `value` mediumtext NOT NULL, `type` varchar(10) NOT NULL DEFAULT 'config', KEY `type` (`type`), KEY description (description) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO my_config VALUES ('latestbackup','','database'); INSERT INTO my_config VALUES ('whenpost','','checkanswe'); INSERT INTO my_config VALUES ('whenregister','','checkanswe'); INSERT INTO my_config VALUES ('jsrefdomains','','jswizard'); INSERT INTO my_config VALUES ('jsdateformat','Y/m/d','jswizard'); INSERT INTO my_config VALUES ('levelup_notice','升级至黄金会员，您将能管理上传店铺背景banner图片，可切换使用更多的店铺模板风格，并拥有更多受限栏目的操作权限。','levelup'); INSERT INTO my_config VALUES ('credit_set','a:1:{s:4:\"rank\";a:15:{i:1;i:10;i:2;i:20;i:3;i:40;i:4;i:70;i:5;i:120;i:6;i:200;i:7;i:400;i:8;i:700;i:9;i:1200;i:10;i:1800;i:11;i:2600;i:12;i:4000;i:13;i:10000;i:14;i:30000;i:15;i:60000;}}','credit_sco'); INSERT INTO my_config VALUES ('score','a:1:{s:4:\"rank\";a:8:{s:8:\"register\";s:3:\"+10\";s:5:\"login\";s:2:\"+2\";s:11:\"information\";s:2:\"+2\";s:6:\"coupon\";s:2:\"+2\";s:5:\"group\";s:2:\"+2\";s:5:\"goods\";s:2:\"+2\";s:11:\"com_certify\";s:3:\"+10\";s:11:\"per_certify\";s:3:\"+10\";}}','credit_sco'); INSERT INTO my_config VALUES ('credit','a:1:{s:4:\"rank\";a:3:{s:11:\"com_certify\";s:3:\"+50\";s:11:\"per_certify\";s:3:\"+50\";s:11:\"coin_credit\";s:3:\"+10\";}}','credit_sco'); INSERT INTO my_config VALUES ('distort','5','authcode'); INSERT INTO my_config VALUES ('insidelink','a:1:{s:7:\"forward\";a:5:{s:11:\"information\";s:1:\"1\";s:4:\"news\";s:1:\"1\";s:5:\"goods\";s:1:\"1\";s:5:\"group\";s:1:\"1\";s:6:\"coupon\";s:1:\"1\";}}','insidelink'); INSERT INTO my_config VALUES ('comment','a:3:{s:11:\"information\";s:1:\"2\";s:4:\"news\";s:1:\"2\";s:5:\"store\";s:1:\"2\";}','comment'); INSERT INTO my_config VALUES ('snow','','authcode'); INSERT INTO my_config VALUES ('jscachelife','0','jswizard'); INSERT INTO my_config VALUES ('jsstatus','1','jswizard'); INSERT INTO my_config VALUES ('custombackup','a:1:{i:0;s:11:\"my_category\";}','database'); INSERT INTO my_config VALUES ('seo_force_store','active','seo'); INSERT INTO my_config VALUES ('seo_force_space','active','seo'); INSERT INTO my_config VALUES ('seo_force_yp','active','seo'); INSERT INTO my_config VALUES ('seo_force_news','active','seo'); INSERT INTO my_config VALUES ('tpl_set','a:15:{s:7:\"banmian\";s:7:\"classic\";s:8:\"smp_cats\";a:4:{s:5:\"first\";a:3:{i:0;s:1:\"3\";i:1;s:1:\"1\";i:2;s:1:\"7\";}s:6:\"second\";a:3:{i:0;s:1:\"2\";i:1;s:1:\"5\";i:2;s:2:\"10\";}s:5:\"third\";a:2:{i:0;s:1:\"4\";i:1;s:1:\"6\";}s:6:\"fourth\";a:3:{i:0;s:1:\"8\";i:1;s:1:\"9\";i:2;s:3:\"189\";}}s:9:\"showstyle\";a:11:{i:3;s:1:\"2\";i:1;s:1:\"2\";i:2;s:1:\"2\";i:4;s:1:\"2\";i:5;s:1:\"2\";i:6;s:1:\"2\";i:7;s:1:\"2\";i:8;s:1:\"2\";i:9;s:1:\"3\";i:189;s:1:\"3\";i:10;s:1:\"2\";}s:7:\"classic\";a:1:{s:4:\"cats\";s:2:\"10\";}s:6:\"portal\";a:10:{s:6:\"ershou\";s:1:\"1\";s:9:\"ershoumod\";s:1:\"2\";s:6:\"zufang\";s:2:\"41\";s:9:\"zufangmod\";s:2:\"23\";s:10:\"ershoufang\";s:2:\"43\";s:13:\"ershoufangmod\";s:2:\"22\";s:7:\"zhaopin\";s:1:\"4\";s:10:\"zhaopinmod\";s:1:\"7\";s:6:\"jianli\";s:1:\"6\";s:9:\"jianlimod\";s:1:\"9\";}s:7:\"portali\";a:3:{s:7:\"acreage\";s:7:\"acreage\";s:6:\"prices\";s:6:\"prices\";s:7:\"company\";s:7:\"company\";}s:12:\"indextopinfo\";s:2:\"12\";s:7:\"newinfo\";s:1:\"0\";s:8:\"announce\";s:1:\"8\";s:3:\"faq\";s:1:\"0\";s:4:\"news\";s:1:\"7\";s:11:\"foreachinfo\";s:1:\"6\";s:5:\"goods\";s:1:\"8\";s:9:\"telephone\";s:2:\"12\";s:7:\"lifebox\";s:2:\"24\";}','tpl'); INSERT INTO my_config VALUES ('seo_force_info','active','seo'); INSERT INTO my_config VALUES ('seo_force_about','active','seo'); INSERT INTO my_config VALUES ('seo_force_category','active','seo'); INSERT INTO my_config VALUES ('seo_description','','seo'); INSERT INTO my_config VALUES ('mobile','a:8:{s:11:\"allowmobile\";s:1:\"1\";s:11:\"autorefresh\";s:1:\"1\";s:8:\"register\";s:1:\"1\";s:4:\"post\";s:1:\"1\";s:8:\"authcode\";s:1:\"1\";s:18:\"mobiletopicperpage\";s:2:\"10\";s:12:\"mobiledomain\";s:0:\"\";s:10:\"mobilelogo\";s:0:\"\";}','mobile'); INSERT INTO my_config VALUES ('line','1','authcode'); INSERT INTO my_config VALUES ('mail_user','','mail'); INSERT INTO my_config VALUES ('smtp_mail','','mail'); INSERT INTO my_config VALUES ('smtp_serverport','','mail'); INSERT INTO my_config VALUES ('smtp_server','','mail'); INSERT INTO my_config VALUES ('noise','12','authcode'); INSERT INTO my_config VALUES ('bodybg','0','config'); INSERT INTO my_config VALUES ('cfg_upimg_number','4','config'); INSERT INTO my_config VALUES ('callback','','qqlogin'); INSERT INTO my_config VALUES ('appkey','','qqlogin'); INSERT INTO my_config VALUES ('callback','','wxlogin'); INSERT INTO my_config VALUES ('appsecret','','wxlogin'); INSERT INTO my_config VALUES ('appid','','wxlogin'); INSERT INTO my_config VALUES ('open','','wxlogin'); INSERT INTO my_config VALUES ('appid','','qqlogin'); INSERT INTO my_config VALUES ('open','','qqlogin'); INSERT INTO my_config VALUES ('seo_keywords','网站关键词','seo'); INSERT INTO my_config VALUES ('sms_pwdtpl','','sms'); INSERT INTO my_config VALUES ('mail_service','smtp','mail'); INSERT INTO my_config VALUES ('sms_regtpl','','sms'); INSERT INTO my_config VALUES ('sms_service','no','sms'); INSERT INTO my_config VALUES ('sms_pwd','','sms'); INSERT INTO my_config VALUES ('sms_user','','sms'); INSERT INTO my_config VALUES ('type','english','authcode'); INSERT INTO my_config VALUES ('post','1','authcode'); INSERT INTO my_config VALUES ('forgetpass','1','authcode'); INSERT INTO my_config VALUES ('cfg_if_nonmember_info','1','config'); INSERT INTO my_config VALUES ('cfg_forbidden_post_ip','','config'); INSERT INTO my_config VALUES ('cfg_allow_post_area','','config'); INSERT INTO my_config VALUES ('cfg_disallow_post_tel','','config'); INSERT INTO my_config VALUES ('cfg_info_if_img','0','config'); INSERT INTO my_config VALUES ('screen_index','full','config'); INSERT INTO my_config VALUES ('cfg_info_if_gq','0','config'); INSERT INTO my_config VALUES ('cfg_post_editor','0','config'); INSERT INTO my_config VALUES ('cfg_if_info_verify','0','config'); INSERT INTO my_config VALUES ('cfg_postfile','mayi-post.php','config'); INSERT INTO my_config VALUES ('cfg_upimg_watermark_position','9','config'); INSERT INTO my_config VALUES ('register','1','authcode'); INSERT INTO my_config VALUES ('login','1','authcode'); INSERT INTO my_config VALUES ('cfg_upimg_watermark_diaphaneity','60','config'); INSERT INTO my_config VALUES ('cfg_upimg_watermark_size','12','config'); INSERT INTO my_config VALUES ('cfg_upimg_watermark_color','#FFFFFF','config'); INSERT INTO my_config VALUES ('cfg_upimg_watermark_text','www.mayicms.com','config'); INSERT INTO my_config VALUES ('cfg_upimg_watermark_img','','config'); INSERT INTO my_config VALUES ('cfg_upimg_watermark_height','50','config'); INSERT INTO my_config VALUES ('cfg_upimg_watermark_width','180','config'); INSERT INTO my_config VALUES ('cfg_upimg_watermark','1','config'); INSERT INTO my_config VALUES ('cfg_member_info_bold','1','config'); INSERT INTO my_config VALUES ('cfg_member_info_refresh','0','config'); INSERT INTO my_config VALUES ('cfg_upimg_type','png,jpg,gif,jpeg','config'); INSERT INTO my_config VALUES ('cfg_upimg_size','1024','config'); INSERT INTO my_config VALUES ('cfg_member_upgrade_list_top','1','config'); INSERT INTO my_config VALUES ('incline','5','authcode'); INSERT INTO my_config VALUES ('close','3','authcode'); INSERT INTO my_config VALUES ('number','4','authcode'); INSERT INTO my_config VALUES ('cfg_member_info_red','1','config'); INSERT INTO my_config VALUES ('cfg_member_upgrade_top','2','config'); INSERT INTO my_config VALUES ('cfg_member_upgrade_index_top','3','config'); INSERT INTO my_config VALUES ('cfg_score_fee','10','config'); INSERT INTO my_config VALUES ('cfg_coin_fee','1','config'); INSERT INTO my_config VALUES ('cfg_member_perpost_consume','0','config'); INSERT INTO my_config VALUES ('cfg_if_affiliate','1','config'); INSERT INTO my_config VALUES ('cfg_affiliate_score','5','config'); INSERT INTO my_config VALUES ('cfg_pay_min','10','config'); INSERT INTO my_config VALUES ('screen_cat','full','config'); INSERT INTO my_config VALUES ('cfg_member_reg_content','尊敬的{username},您已经注册成为{sitename}的会员,请您在发表言论时,遵守当地法律法规。\r\n如果您有什么疑问可以联系管理员。\r\n\r\n\r\n{sitename}\r\n{time}','config'); INSERT INTO my_config VALUES ('cfg_member_reg_title','{username},您好,感谢您的注册,请阅读以下内容。','config'); INSERT INTO my_config VALUES ('cfg_forbidden_reg_ip','','config'); INSERT INTO my_config VALUES ('cfg_member_regplace','','config'); INSERT INTO my_config VALUES ('cfg_if_corp','1','config'); INSERT INTO my_config VALUES ('cfg_if_member_log_in','1','config'); INSERT INTO my_config VALUES ('cfg_if_member_register','1','config'); INSERT INTO my_config VALUES ('cfg_member_verify','2','config'); INSERT INTO my_config VALUES ('cfg_member_logfile','mayi-member.php','config'); INSERT INTO my_config VALUES ('screen_info','full','config'); INSERT INTO my_config VALUES ('seo_sitename','分类信息网','seo'); INSERT INTO my_config VALUES ('cfg_raquo','>','config'); INSERT INTO my_config VALUES ('cfg_backup_dir','/backup','config'); INSERT INTO my_config VALUES ('cfg_page_line','15','config'); INSERT INTO my_config VALUES ('cfg_list_page_line','16','config'); INSERT INTO my_config VALUES ('cfg_site_open_reason','','config'); INSERT INTO my_config VALUES ('mail_pass','','mail'); INSERT INTO my_config VALUES ('seo_force_goods','active','seo'); INSERT INTO my_config VALUES ('seo_html_make','','seo'); INSERT INTO my_config VALUES ('cfg_authcodefile','mayi-auth.php','config'); INSERT INTO my_config VALUES ('cfg_if_site_open','1','config'); INSERT INTO my_config VALUES ('SiteStat','','config'); INSERT INTO my_config VALUES ('SiteCity','北京','config'); INSERT INTO my_config VALUES ('SiteLogo','/logo.gif','config'); INSERT INTO my_config VALUES ('SiteBeian','','config'); INSERT INTO my_config VALUES ('SiteTel','010-00000000','config'); INSERT INTO my_config VALUES ('SiteEmail','','config'); INSERT INTO my_config VALUES ('SiteQQ','','config'); INSERT INTO my_config VALUES ('SiteUrl','http://7891000.com','config'); INSERT INTO my_config VALUES ('SiteName','我的网站','config'); INSERT INTO my_config VALUES ('cfg_nonmember_perday_post','','config'); INSERT INTO my_config VALUES ('mapapi','','config'); INSERT INTO my_config VALUES ('mapflag','','config'); INSERT INTO my_config VALUES ('mapapi_charset','','config'); INSERT INTO my_config VALUES ('mapview_level','14','config'); INSERT INTO my_config VALUES ('cfg_mappoint','','config'); INSERT INTO my_config VALUES ('cfg_tpl_dir','orange','config'); INSERT INTO my_config VALUES ('screen_search','full','config'); INSERT INTO my_config VALUES ('head_style','new','config'); DROP TABLE IF EXISTS my_corp; CREATE TABLE my_corp ( corpid mediumint(6) NOT NULL AUTO_INCREMENT, corpname varchar(32) NOT NULL, parentid int(11) unsigned NOT NULL, corporder smallint(6) NOT NULL, PRIMARY KEY (corpid), KEY areaname (corpname), KEY parentid (parentid) ) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 AUTO_INCREMENT=67; INSERT INTO my_corp VALUES ('10','购物天地','0','6'); INSERT INTO my_corp VALUES ('9','旅游出行','0','5'); INSERT INTO my_corp VALUES ('8','生活便利','0','4'); INSERT INTO my_corp VALUES ('7','餐饮美食','0','3'); INSERT INTO my_corp VALUES ('6','休闲娱乐','0','2'); INSERT INTO my_corp VALUES ('11','教育培训','0','7'); INSERT INTO my_corp VALUES ('12','装饰装修','0','8'); INSERT INTO my_corp VALUES ('14','酒吧','6','11'); INSERT INTO my_corp VALUES ('15','茶楼','6','12'); INSERT INTO my_corp VALUES ('16','咖啡厅','6','13'); INSERT INTO my_corp VALUES ('17','俱乐部','6','14'); INSERT INTO my_corp VALUES ('18','KTV','6','15'); INSERT INTO my_corp VALUES ('19','洗浴足疗','6','16'); INSERT INTO my_corp VALUES ('20','美容','6','17'); INSERT INTO my_corp VALUES ('21','健身','6','18'); INSERT INTO my_corp VALUES ('22','运动','6','19'); INSERT INTO my_corp VALUES ('23','票务','6','20'); INSERT INTO my_corp VALUES ('24','快餐','7','22'); INSERT INTO my_corp VALUES ('25','火锅','7','24'); INSERT INTO my_corp VALUES ('26','海鲜','7','25'); INSERT INTO my_corp VALUES ('27','川菜','7','26'); INSERT INTO my_corp VALUES ('28','京菜','7','27'); INSERT INTO my_corp VALUES ('29','粤菜','7','28'); INSERT INTO my_corp VALUES ('30','湘菜','7','29'); INSERT INTO my_corp VALUES ('31','家常','7','30'); INSERT INTO my_corp VALUES ('32','西餐','7','31'); INSERT INTO my_corp VALUES ('33','风味','7','32'); INSERT INTO my_corp VALUES ('34','家政保洁','8','34'); INSERT INTO my_corp VALUES ('35','搬家','8','35'); INSERT INTO my_corp VALUES ('36','房产中介','8','36'); INSERT INTO my_corp VALUES ('37','快递','8','37'); INSERT INTO my_corp VALUES ('38','婚纱影楼','8','38'); INSERT INTO my_corp VALUES ('39','婚庆礼仪','8','39'); INSERT INTO my_corp VALUES ('40','婚介交友','8','40'); INSERT INTO my_corp VALUES ('41','旅行社','9','42'); INSERT INTO my_corp VALUES ('42','度假村','9','43'); INSERT INTO my_corp VALUES ('43','景点','9','44'); INSERT INTO my_corp VALUES ('44','酒店宾馆','9','45'); INSERT INTO my_corp VALUES ('45','交通票务','9','46'); INSERT INTO my_corp VALUES ('46','商场超市','10','48'); INSERT INTO my_corp VALUES ('47','家电数码','10','49'); INSERT INTO my_corp VALUES ('48','休闲运动','10','50'); INSERT INTO my_corp VALUES ('49','文化艺术','10','51'); INSERT INTO my_corp VALUES ('50','保健美容','10','52'); INSERT INTO my_corp VALUES ('51','服装皮具','10','53'); INSERT INTO my_corp VALUES ('52','眼镜钟表','10','54'); INSERT INTO my_corp VALUES ('53','珠宝首饰','10','55'); INSERT INTO my_corp VALUES ('54','外语','11','57'); INSERT INTO my_corp VALUES ('55','IT','11','58'); INSERT INTO my_corp VALUES ('56','家教','11','59'); INSERT INTO my_corp VALUES ('57','管理财务','11','60'); INSERT INTO my_corp VALUES ('58','艺术影视','11','61'); INSERT INTO my_corp VALUES ('59','远程教育','11','62'); INSERT INTO my_corp VALUES ('60','技能认证','11','63'); INSERT INTO my_corp VALUES ('61','留学移民','11','64'); INSERT INTO my_corp VALUES ('62','装饰装修','12','66'); INSERT INTO my_corp VALUES ('63','设计装修','12','67'); INSERT INTO my_corp VALUES ('64','家居广场','12','68'); INSERT INTO my_corp VALUES ('65','建材市场','12','69'); INSERT INTO my_corp VALUES ('66','门窗','12','70'); DROP TABLE IF EXISTS my_coupon; CREATE TABLE my_coupon ( id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, cate_id smallint(5) unsigned NOT NULL DEFAULT '0', areaid smallint(5) NOT NULL DEFAULT '0', userid varchar(30) NOT NULL, pre_picture varchar(255) NOT NULL, picture varchar(255) NOT NULL DEFAULT '', begindate int(10) NOT NULL DEFAULT '0', enddate int(10) NOT NULL DEFAULT '0', title varchar(100) NOT NULL, des varchar(50) NOT NULL DEFAULT '', content mediumtext NOT NULL, ctype enum('折扣券','抵价券') NOT NULL DEFAULT '折扣券', sup varchar(3) NOT NULL, prints mediumint(8) unsigned NOT NULL DEFAULT '0', comments mediumint(8) unsigned NOT NULL DEFAULT '0', grade smallint(5) unsigned NOT NULL DEFAULT '1', flag tinyint(1) unsigned NOT NULL DEFAULT '1', dateline int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '1', hit int(10) NOT NULL DEFAULT '0', qq int(8) NOT NULL, web_address char(100) NOT NULL, qq_qun int(8) NOT NULL, PRIMARY KEY (id), KEY cate_id (cate_id), KEY areaid (areaid), KEY userid (userid), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_coupon_category; CREATE TABLE my_coupon_category ( cate_id smallint(3) NOT NULL AUTO_INCREMENT, cate_name varchar(100) NOT NULL, cate_view tinyint(1) NOT NULL DEFAULT '1', cate_order smallint(3) NOT NULL DEFAULT '0', PRIMARY KEY (cate_id) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 AUTO_INCREMENT=15; INSERT INTO my_coupon_category VALUES ('9','美食','1','1'); INSERT INTO my_coupon_category VALUES ('10','休闲','1','2'); INSERT INTO my_coupon_category VALUES ('11','女性','1','3'); INSERT INTO my_coupon_category VALUES ('12','出行','1','4'); INSERT INTO my_coupon_category VALUES ('13','摄影','1','5'); INSERT INTO my_coupon_category VALUES ('14','其它','1','6'); DROP TABLE IF EXISTS my_crons; CREATE TABLE my_crons ( cronid smallint(6) unsigned NOT NULL AUTO_INCREMENT, `name` char(50) NOT NULL DEFAULT '', lastrun int(10) unsigned NOT NULL DEFAULT '0', nextrun int(10) unsigned NOT NULL DEFAULT '0', `day` tinyint(2) NOT NULL DEFAULT '0', PRIMARY KEY (cronid), KEY nextrun (nextrun) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 AUTO_INCREMENT=18; INSERT INTO my_crons VALUES ('1','information','1568566921','1568649600','1'); INSERT INTO my_crons VALUES ('16','advertisement','1568566921','1568649600','1'); INSERT INTO my_crons VALUES ('17','levelup','1568566921','1568649600','1'); DROP TABLE IF EXISTS my_faq; CREATE TABLE my_faq ( id tinyint(5) NOT NULL AUTO_INCREMENT, typeid tinyint(5) NOT NULL, title char(100) NOT NULL, content mediumtext NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 AUTO_INCREMENT=35; INSERT INTO my_faq VALUES ('2','5','如何成为本站的注册用户？','注册其实很简单，只要按照如下提示操作便可。
\r\n
\r\n1、进入网站首页，点击右上角“注册”按钮；
\r\n
\r\n2、进入到“注册”页面，根据提示信息，填写您的昵称、密码、邮箱之后，点击“注册”即可。
\r\n
\r\n3、如果需要发布信息，在会员中心中，可以直接点击“立即免费发布信息”按钮或点击由上角的“免费发布信息”图标。
\r\n
'); INSERT INTO my_faq VALUES ('3','5','昵称有什么用？可以更改吗？','1、昵称是你登陆本网的通行证，每个人都会有一个唯一标识的昵称，您所发布的每一条信息中也会显示出来，它是您在本网站身份的标志。目前本网站上的昵称(账号)是不允许修改的。建议用户注册时请选择您喜欢并能牢记的账号。
\r\n
\r\n2、昵称是不能够修改的，就好像现实生活里的人名一样。
\r\n
\r\n3、昵称将伴随你度过在本网站的快乐每一天。
'); INSERT INTO my_faq VALUES ('4','5','怎么登录会员管理中心？','在注册成为本网站用户后，你就可以使用账号(即昵称)登录会员管理中心了，跟着我们来看看详细操作步骤吧：
\r\n
\r\n1、进入本网首页－＞点击右上角“登录”
\r\n
\r\n2、输入您的昵称与密码，点击“登录”。
\r\n
\r\n3、恭喜您登陆成功，你可以发布信息或浏览信息，随你开心。
\r\n
'); INSERT INTO my_faq VALUES ('6','5','我的密码忘记了怎么办？','如果您忘记了账号密码，别担心，您可以通过点击“登录”进入快速登录页面,点击该页面左小角中的“忘记密码 我要找回”按钮获得。
\r\n
\r\n1、进入到找回密码页面后,如果您曾设置了密保，那么直接在页面中输入密保问题与答案便可找回。
\r\n
\r\n2、如果您没有设置密保，您也可以联系客服帮您重设密码。'); INSERT INTO my_faq VALUES ('7','2','在本站发布信息要收费吗？','1、本站是一个免费的生活信息交流平台。

2、我们为广大普通用户提供永久免费发布生活信息的服务。'); INSERT INTO my_faq VALUES ('22','4','诚信认证流程','一、认证目的

诚信认证包括个人身份认证和商家营业执照认证，本网站推出诚信认证是为规范网站诚信秩序，解决部分垃圾、虚假、违法等不良信息，提高信息真实性与可信度，也在一定程度上保证验证用户的信息质量高于非验证用户的信息质量，让用户查询使用信息更放心，给用户一个良好的诚信网络交流环境；同时，对处理不良、违法信息也会有很大帮助，有资料依据，每位认证后的用户应对所发布的信息负有诚信和法律责任。

二、认证规则

用户自愿、免费认证的原则。
1. 个人身份认证中一个身份证只能认证一个用户名，用户须上传真实的个人身份资料；
2. 商家营业执照认证中公司姓名须与营业执照上完全一致，如果申请人不是公司法定代表人，请下载委托书，填写后再上传身份证彩色原件扫描件。

三、认证方式

1. 传真申请，须传真身份证或者营业执照复印件
2. 在线申请，须填写相关认证信息，同时上传彩色原件扫描件。
所有本网站用户都可以免费使用认证服务，认证流程简单，通过认证增加真实性和诚信度，可免费获得象征更值得信赖的认证用户身份标识 ，同时所发布的信息将获得免费更多展示与反馈，信息可免费展示在列表页“诚信用户专区”。


四、认证审核标准

1.个人身份认证中一个身份证只能认证一个用户名，商家营业执照认证中公司姓名须与营业执照上完全一致，如果申请人不是公司法定代表人，请下载委托书，填写后再上传身份证彩色原件扫描件。

2. 认证时账号被他人使用
须提交本人身份证原件复印件和户口复印件，审核通过后将使用账号封锁，并且该身份证不能申请认证，确保账号安全。


3. 对实名资料的保密承诺
通过认证后的实名资料将不能取消与更改，本网站将对您的真实姓名、身份证号码等信息资料，采取严格的保密措施，绝不会公开或者提供给除公安局以外的任何其他第三方。


五、认证用户守则

1. 认证后的商家用户须保证信息的真实性，不得有虚假、违法、不良信息，要遵守版规发布信息。对于被用户投诉的商家，管理员将视情况处理，采取警告、取消商家资格、待审核或封锁其账号等处罚方式，后果严重者将配合用户追究相关商家法律责任。

2. 各商家之间要和睦相处，不得有诋毁、谩骂、人身攻击等行为。如果对别的商家有意见，可以通过站内短信息提出，并且尽可能地提出改善建议。对于恶意攻击行为（包括用马甲攻击），管理员将视情节采取书面警告、取消商家资格、待审核或封锁其账号等处罚方式。'); INSERT INTO my_faq VALUES ('23','2','为什么我的信息是“待审核”？','
为了保证本站的信息质量，我们对部分信息设置了“待审核”状态，“待审核”的信息有以下几种情况，不管您是哪种情况，我们编辑都会及时处理。
\r\n
\r\n1、为了保证本站上的绝大多数信息合法、规范，我们会在后台设置关键字的屏蔽的功能，当您的信息含有违法、严重违规或者语言粗俗不雅、侮辱他人、产生歧义等内容，系统将会把这条信息自动列入“待审核”当中。
\r\n
\r\n2、如果您的信息重复发表两条以上、联系方式为外地、信息缺少关键内容等情况下，也许会被本站列入“待审核”当中。
\r\n
\r\n3、您的联系方式若之前有其他账号使用发布过信息，那么您的信息也会自动进入“待审核”状态中，遇到这样的情况，您可以联系我们进行确认，以避免他人使用您的联系方式。
\r\n
\r\n4、当然，汉字语义丰富，也许您的某些非上述有争议性的内容发布时同样遇到这样的问题未能解决，建议您与本站客服取得联系。
\r\n
\r\n5、 “待审核”的信息24小时内会审核完，通过审核后的信息会公布出来，没通过审核的信息将被移入“回收站”中
'); INSERT INTO my_faq VALUES ('24','1','置顶有哪几种形式？','

\r\n 置顶有3种形式，大类置顶，小类置顶和首页置顶。\r\n

\r\n

\r\n 大类置顶：可在小分类下置顶信息，可以采用分类信息的页面样式；\r\n

\r\n

\r\n 小类置顶：可在小分类下置顶信息，可以采用分类信息的页面样式；\r\n

\r\n

\r\n 首页置顶：可在首页置顶信息，可以采用分类信息的页面样式；\r\n

'); INSERT INTO my_faq VALUES ('25','1','置顶有什么好处？','

\r\n 信息置顶后，就能够很容易被更多的人关注到。因为网友在浏览信息时都会先浏览靠前的内容，这样您发布信息的有效性就得到了保障。置顶信息获得的关注是普通信息的20倍。\r\n

'); INSERT INTO my_faq VALUES ('26','1','置顶是什么？','

\r\n 信息置顶是本站为用户提供的增值服务，对自己已经发布成功的信息，您可以联系本站工作人员咨询置顶业务。置顶后该信息就会在该类别的列表页中长时间处在靠前的固定位置，并带醒目图标 \r\n。置顶信息会引起用户更多关注，不会因为有新的帖子发布，而使您的帖子被挤到后边，以至于无法被关注到。\r\n

'); INSERT INTO my_faq VALUES ('27','1','刷新是什么？','刷新信息相当于您把这个信息重新发布一次，信息会再次排到该类别列表页面的靠前位置。 
'); INSERT INTO my_faq VALUES ('28','2','为什么我发布不了信息？','

\r\n 为了营造良好的网络氛围，您的账号发布不了信息或者登录不了，可能有以下原因：
\r\n
\r\n \r\n

\r\n1、我们根据每个分类版块限制了发布数量，你已经在该分类下达到了发布数量上限；
\r\n

\r\n
\r\n

\r\n2、为什么我发布信息时提示我“信息内包含非法词”？
\r\n非法词是指由司法机关、主管部门、网监提供的词汇表，请大家不要发布违法信息，填写完后检查一下发布内容避免无意行为。
\r\n

\r\n
\r\n

\r\n3、为什么信息发布成功后显示“审核中”？
\r\n所有发布的信息，都会先进审核区，等工作人员审核通过后才会开放出来，我站审核人员在24小时内会提供给您审核结果。
\r\n

\r\n
\r\n

\r\n4、为什么发布信息时提示我“发布信息太过频繁”？
\r\n为了防止部分用户的恶意发帖行为，我们对发帖速度进行了限制，这时建议大家稍微休息一下再发布。
\r\n

\r\n
\r\n

\r\n5、为什么发布信息时提示我 “信息重复”？
\r\n相同的信息不允许重复发布，建议您在发布时对信息进行修改。您还可以选择在用户中心中的“刷新”来代替发布。
\r\n

\r\n
\r\n

\r\n6、为什么我发布不了帖子（怎么清除浏览器缓存）？
\r\n当您遇到以下问题时，可以尝试清除浏览器IE临时文件或重置浏览器选项后重试:
\r\n1. 点击“发布”按钮无反应；
\r\n2. 点击“发布”按钮后，按钮为灰色，页面不跳转；
\r\n3. 提示可以发布0条信息；
\r\n4. 无法上传图片，导致发布不了信息
'); INSERT INTO my_faq VALUES ('29','6','警惕钓鱼网站','

\r\n 什么是钓鱼网站？
\r\n钓鱼网站通常伪装成为银行网站、淘宝店铺等这些可以利用网上交易并引导激发用户的消费行 \r\n为的网站，窃取访问者提交的账号和密码信息。它一般通过电子邮件传播，此类邮件中一个经过伪装的链接将收件人联到钓鱼网站，或者通 \r\n过信息内容里带有网站链接的行为来诱惑用户进到该网站中。\r\n

\r\n

\r\n 钓鱼网站的常见的类型
\r\n钓鱼网站的页面与真实网站界面完全一致，要求访问者提交账号和密码。一般来说钓鱼网 \r\n站结构很简单，只有一个或几个页面，URL和真实网站有细微差别，钓鱼最常见的，一般来说还是针对淘宝的比较多。
\r\n如真实的工行网站 \r\n为www.icbc.com.cn，针对工行的钓鱼网站则有可能为www.1cbc.com.cn。
\r\n真实的淘宝店铺的网址为http://www.taobao.com/，针对淘宝 \r\n的钓鱼网站则有可能是 \r\nhttp://list.taobao.com/
\r\nhttp://ship.36165279taobao.com/
\r\nhttp://taobao.gegecn.com.cn
\r\nhttp://taobao0.com
\r\nhttp://w \r\nww.taobaoxaq.com.cn/
\r\nhttp://www.Taobaveng.cn
\r\nhttp://www.paokn.com/taobao
\r\nhttp://www.teobao.com
\r\nhttp://www.taoob \r\nao.com
\r\nhttp://taobaoa.w31.100dns.com/
\r\nhttp://www.taobaoy.com
\r\nhttp://taobao-hb.cn/
\r\n应该特别小心由不规范的字母数 \r\n字组成的CN类网址，最好禁止浏览器运行JavaScript和ActiveX代码，不要上一些不太了解的网站。\r\n

\r\n

\r\n 如何防止被骗
\r\n以上这些都是直接链接到淘宝的真网址的，除了登录和支付的两个页面是他们做的，其他都链接到 \r\n真的淘宝网址，不良商家就是利用了顾客对淘宝官网的信任，通过在官方上注册正式的网店，再以QQ引导顾客登录内容相同的假淘宝网店网 \r\n址，窃取顾客的支付宝账号与密码并从中敛财获利。类似这样的事情很多，在这里想提醒大家的是，淘宝交易的变换形式多种多样，但还是 \r\n会有规律的，前缀都是“taobao”，只在后缀上有小小区别，或者相反，顾客如不认真比对很难看出破绽，大家如果不懂淘宝，就请切记淘 \r\n宝的真实网站。如果碰到类似的需要淘宝交易的网站，请让卖方提供淘宝的店铺名称，然后进http://www.taobao.com/这个真实的淘宝店铺里，用“阿里旺旺”在淘宝里和卖方交易，因为阿里旺旺有识别真假淘宝的功能，真网址会显示安全，假的会有提示告诫。\r\n

'); INSERT INTO my_faq VALUES ('30','6','常见骗子手法揭秘','
\r\n

\r\n 骗子的基本手段\r\n

\r\n

\r\n 一直以来，网络骗子层出不穷，但万变不离其宗，都是换汤不换药的方法，化龙巷分类信息通过对骗子的仔细研究，为广大用户总结一些规律性 的东西：\r\n

\r\n

\r\n 1、出售商品均以“出售XXXX,价格XXX，有意的加Q详聊”这些贴子大家都要小心留意一下，而且这些贴子出所售的商 \r\n品价格都会比市面上便宜许多，这就得留意了，不要贪图小便宜，贪多必 失！\r\n

\r\n

\r\n 2、骗子通常都不会支持第三方，只会先打款或者先商品，提到支付宝或者财会通什么的第三方软件就说不会用，这时 \r\n候就要注意了，宁可另寻觅一台，也不要兵行险着！认真想一下到底是人
\r\n家的商品好重要还是自己的辛苦钱重要！\r\n

\r\n

\r\n 3、某些骗子的手法有一点点高（其实也一眼就能看穿的），他们手上确实是有商品，但并不是真的想卖，只是用作诱饵，先把商品的照片拍了上来，然后静等大鱼上钓，交易的时候要求先款一半，然后说会把商品邮给你，没有问题再把另外一半的钱给 \r\n的打过来，这样就正中下怀了，不要以为自己的权益有了保障，想一下自己有什么利益可言吧，不是被骗了全部，而是被骗了一半！\r\n

\r\n

\r\n 4、换商品或者求商品的这种骗子也会采用以上的方法，然后说交易方式的时候当然也不会采用第三方支付，而是要求 \r\n先商品后款，先款不行就会说可以大家同时把商品邮寄出去，这就要用正
\r\n规的邮寄公司交易了，不过这种方法确实是有，只是上当的人 应该不会很多吧~\r\n

\r\n

\r\n 5、还有一种就是骗子说快递公司代收的业务，这也是不可信的，正规的快递公司几乎没有这种业务。\r\n

\r\n

\r\n 最实用的防骗方法\r\n

\r\n

\r\n 1、最好一定要当面交易，这是最好的交易方式，骗子其实明知道你和他不是一个地方的，所以骗子一般会先提出要当成交易，这样先让你心里放松一下，让你觉得他是真诚的，其实他根本就 \r\n知道你不可能跟他当成交易，然后还会问你有没有亲戚朋友什么的 在那边，切记，遇到这样的，直接拉黑吧。\r\n

\r\n

\r\n 2、交易一定要用第三方支付平台，这样大家都有保障，不支持第三方的或者不能见面交易的就根本不要理会，另外再 \r\n找吧，这肯定是骗子。\r\n

\r\n

\r\n 3、在交易前最好先百度一下对方的QQ号码或者手机号码，网络上一般都留有骗子的信息的。\r\n

\r\n

\r\n 4、不要和对方聊的开心就称兄道弟而忘记了自己的利益，有的骗子就会运用心理战术，从语言上先让你觉得他很真诚 \r\n能让你相信他，一定要记住，我是在交易，而不是在交朋友，时刻要把利 益摆在第一位，安全交易才是硬道理。\r\n

\r\n

\r\n 5、不要以为在校学生就不会是骗子，现在很多骗子都是大学生呢，更得小心谨慎。\r\n

\r\n

\r\n 5、邮递方式一定要用正规的邮递公司，例如EMS、顺丰、申通等等。\r\n

\r\n

\r\n 6、第三方交换商品虽然麻烦，但这是除了面交之外的最安全的交易方法，因为要走法律程序，所以一定会有时间上的 \r\n耽误，但一定切记，这样才不会被骗。\r\n

\r\n
'); INSERT INTO my_faq VALUES ('31','6','互联网防骗指南','
\r\n 邮件短信假链接
\r\n
\r\n1.短信诈骗耍花样 \r\n验证手机偷密码
\r\n突然收到条“系统”短信说验证手机长期未验证需要验证，要回复账户密码的用户更要注意了，化龙巷分类信息是不会发送任何要求用户回复账户和密码的短信的。
\r\n
\r\n2.特价机票满天飞 \r\n转账套钱现原形
\r\n随着春运大幕的拉开，“特价机票”悄然成为搜索热门词汇，“假机票网”也迎来了 \r\n自己的“旺季”。不法分子常以超低折扣引诱消费者订票，骗取钱财，甚至直接套取用户的银行账户和密码。不要为贪图一点小便宜导致即 \r\n损失了钱财，也买不到回家过年的那张“通行证”。为了大家可以快快乐乐的过一个欢庆的新年，请大家多加注意了。
\r\n
\r\n3.谁说账号有异常 \r\n原是骗子想钓鱼
\r\n随着现在骗子对互联网越来越熟悉，各种新招式层出不穷，冒充化龙巷分类信息给客户发送钓鱼邮件就是一 \r\n个新例子，请大家不要相信要求你填写化龙巷账户密码的那些邮件，化龙巷分类信息是不会要求您在邮件中填写这些信息的，那些都是骗子的邮件，只要 \r\n您填写下去就会被那个发这个邮件的人修改您的密码的，账户有余额的客户尤其要注意了。
\r\n
\r\n4.周年庆典被炒作 \r\n中奖欺诈要提防
\r\n化龙巷分类信息不会给用户发送邮件让用户去参加所谓 的“狂欢”。所以大家要注意这种邮件了哦。\r\n
'); INSERT INTO my_faq VALUES ('32','2','电话被冒用','
\r\n 请提供被冒用的（信息编号、冒用号码），联系我站工作人员。\r\n
'); INSERT INTO my_faq VALUES ('33','2','我要删除信息','

\r\n 1，在顶部点击“修改/删除信息”。\r\n

\r\n

\r\n 2，登录用户中心，我发布的信息内，您可以选择修改、删除、刷新等操作。\r\n

'); INSERT INTO my_faq VALUES ('34','2','信息为什么不显示？','
\r\n 1、如果信息含有敏感词汇、特殊字符或版规限制的内容，就需要工作人员审核通过后才能公开显示（审核时间为24小时之内）。\r\n
\r\n
\r\n
\r\n
\r\n 2、信息状态待完善，您的信息需要您修改完善后才能公开展示。根据要求修改完善信息，并通过本站工作人员审核成功后，才能公开展示（审核时间为24小时之内）。\r\n
\r\n
\r\n
\r\n
\r\n 3、修改过的信息时间会更新但在列表中的位置不会变。如果想信息再次排到该类别列表页面的靠前位置，您可以点击“刷新”。\r\n
'); DROP TABLE IF EXISTS my_faq_type; CREATE TABLE my_faq_type ( id tinyint(5) NOT NULL AUTO_INCREMENT, typename char(50) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AUTO_INCREMENT=7; INSERT INTO my_faq_type VALUES ('1','置顶与刷新'); INSERT INTO my_faq_type VALUES ('2','信息发布与删除'); INSERT INTO my_faq_type VALUES ('4','认证服务'); INSERT INTO my_faq_type VALUES ('5','用户注册与登录'); INSERT INTO my_faq_type VALUES ('6','防骗常识'); DROP TABLE IF EXISTS my_flink; CREATE TABLE my_flink ( id smallint(5) unsigned NOT NULL AUTO_INCREMENT, ifindex tinyint(1) NOT NULL DEFAULT '1', catid mediumint(6) NOT NULL DEFAULT '0', url varchar(200) NOT NULL, webname char(30) NOT NULL DEFAULT '', weblogo char(250) NOT NULL DEFAULT '', dayip char(20) NOT NULL, pr smallint(1) NOT NULL, msg char(200) NOT NULL DEFAULT '', `name` varchar(10) NOT NULL, qq varchar(11) NOT NULL, email char(50) NOT NULL DEFAULT '', typeid smallint(5) unsigned NOT NULL DEFAULT '0', ischeck smallint(1) NOT NULL DEFAULT '1', ordernumber int(8) NOT NULL, createtime int(10) NOT NULL, PRIMARY KEY (id), KEY ordernumber (ordernumber), KEY ischeck (ischeck), KEY weblogo (weblogo), KEY ifindex (ifindex), KEY catid (catid) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3; INSERT INTO my_flink VALUES ('1','2','0','https://www.mayicms.com','蚂蚁分类信息系统','','1000以下','0','合作伙伴','村长','3388888888','mymps@qq.com','1','2','2','1267535588'); INSERT INTO my_flink VALUES ('2','2','0','https://123.mayicms.com','分类信息网站之家','','1000以下','0','合作伙伴','村长','3388888888','mymps@qq.com','1','2','2','1267535588'); DROP TABLE IF EXISTS my_flink_type; CREATE TABLE my_flink_type ( id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, typename varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 AUTO_INCREMENT=9; INSERT INTO my_flink_type VALUES ('1','门户网站'); INSERT INTO my_flink_type VALUES ('2','分类信息'); INSERT INTO my_flink_type VALUES ('4','论坛博客'); INSERT INTO my_flink_type VALUES ('8','其它类别'); DROP TABLE IF EXISTS my_focus; CREATE TABLE my_focus ( id smallint(5) unsigned NOT NULL AUTO_INCREMENT, image varchar(100) NOT NULL, pre_image varchar(100) NOT NULL, url varchar(100) NOT NULL, words varchar(50) NOT NULL, pubdate int(11) NOT NULL, focusorder smallint(5) unsigned NOT NULL, typename enum('网站首页','新闻首页') NOT NULL DEFAULT '网站首页', PRIMARY KEY (id), KEY image (image), KEY url (url) ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 AUTO_INCREMENT=32; INSERT INTO my_focus VALUES ('27','/attachment/focus/1264154161u7bxl.jpg','/attachment/focus/1264154161u7bxl.jpg','#','蚂蚁分类信息系统重磅升级','1264154161','2','新闻首页'); INSERT INTO my_focus VALUES ('24','/attachment/focus/1264065647ohvmy.jpg','/attachment/focus/1264065647ohvmy.jpg','#','蚂蚁分类信息系统(mayicms.com)','1264065647','4','网站首页'); INSERT INTO my_focus VALUES ('26','/attachment/focus/1264154115lz6zz.jpg','/attachment/focus/1264154115lz6zz.jpg','#','巴基斯坦汽车炸弹袭击致92平民死亡','1264154115','3','新闻首页'); INSERT INTO my_focus VALUES ('23','/attachment/focus/12640655906csju.jpg','/attachment/focus/12640655906csju.jpg','#','学易网校','1264065590','3','网站首页'); INSERT INTO my_focus VALUES ('25','/attachment/focus/126406568947c7a.jpg','/attachment/focus/126406568947c7a.jpg','#','MayiCMS','1264065689','5','网站首页'); INSERT INTO my_focus VALUES ('28','/attachment/news/201107/1310443658ynfcu.jpg','/attachment/news/201107/1310443658ynfcu.jpg','#','高清组图：合肥突降暴雨 市区内涝严重','1310443667','1','新闻首页'); INSERT INTO my_focus VALUES ('29','/attachment/focus/1314769962qhgmv.gif','/attachment/focus/pre_1314769962qhgmv.gif','https://www.mayicms.com','蚂蚁分类信息网站系统(mayicms.com)','1314769962','2','网站首页'); INSERT INTO my_focus VALUES ('30','/attachment/focus/1314770242auudu.gif','/attachment/focus/pre_1314770242auudu.gif','https://www.mayicms.com','赶集找房节','1314770242','1','网站首页'); INSERT INTO my_focus VALUES ('31','/attachment/focus/1314770413ldwaj.jpg','/attachment/focus/pre_1314770413ldwaj.jpg','https://www.mayicms.com','地方门户系统','1314770413','4','新闻首页'); DROP TABLE IF EXISTS my_goods; CREATE TABLE my_goods ( goodsid int(10) NOT NULL AUTO_INCREMENT, goodsbh varchar(11) NOT NULL, userid varchar(30) NOT NULL, goodsname varchar(100) NOT NULL, catid smallint(3) NOT NULL, oldprice varchar(8) NOT NULL, nowprice varchar(8) NOT NULL, huoyuan tinyint(1) NOT NULL, gift varchar(100) NOT NULL, oicq varchar(11) NOT NULL, content mediumtext NOT NULL, picture varchar(255) NOT NULL, pre_picture varchar(255) NOT NULL, rushi tinyint(1) NOT NULL, tuihuan tinyint(1) NOT NULL, jiayi tinyint(1) NOT NULL, weixiu tinyint(1) NOT NULL, fahuo tinyint(1) NOT NULL, zhengpin tinyint(1) NOT NULL, tuijian tinyint(1) NOT NULL, cuxiao tinyint(1) NOT NULL, remai tinyint(1) NOT NULL, baozhang tinyint(1) NOT NULL, onsale tinyint(1) NOT NULL DEFAULT '1', hit int(10) NOT NULL, dateline int(10) NOT NULL, PRIMARY KEY (goodsid), KEY userid (userid,catid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_goods_category; CREATE TABLE my_goods_category ( catid mediumint(6) NOT NULL AUTO_INCREMENT, if_view tinyint(1) NOT NULL DEFAULT '1', color char(10) NOT NULL, catname varchar(32) NOT NULL, title varchar(250) NOT NULL, keywords varchar(255) DEFAULT NULL, description varchar(255) DEFAULT NULL, parentid int(11) DEFAULT NULL, catorder smallint(6) NOT NULL, PRIMARY KEY (catid), KEY parentid (parentid), KEY catname (catname), KEY catorder (catorder) ) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8 AUTO_INCREMENT=75; INSERT INTO my_goods_category VALUES ('1','2','','运动/户外/休闲','运动/户外/休闲','运动/户外/休闲','运动/户外/休闲','0','1'); INSERT INTO my_goods_category VALUES ('2','2','','女士服装/内衣','女士服装/内衣','女士服装/内衣','女士服装/内衣','0','2'); INSERT INTO my_goods_category VALUES ('3','2','','男士服装与配件','男士服装与配件','男士服装与配件','男士服装与配件','0','3'); INSERT INTO my_goods_category VALUES ('4','2','','装潢/居家/家具','装潢/居家/家具','装潢/居家/家具','装潢/居家/家具','0','4'); INSERT INTO my_goods_category VALUES ('5','2','','电器/厨房用品/保健','电器/厨房用品/保健','电器/厨房用品/保健','电器/厨房用品/保健','0','5'); INSERT INTO my_goods_category VALUES ('6','2','','汽车/摩托车/自行车','汽车/摩托车/自行车','汽车/摩托车/自行车','汽车/摩托车/自行车','0','6'); INSERT INTO my_goods_category VALUES ('7','2','','珠宝/饰品/手表/眼镜','珠宝/饰品/手表/眼镜','珠宝/饰品/手表/眼镜','珠宝/饰品/手表/眼镜','0','7'); INSERT INTO my_goods_category VALUES ('8','2','','电脑/网络/办公','电脑/网络/办公','电脑/网络/办公','电脑/网络/办公','0','8'); INSERT INTO my_goods_category VALUES ('9','2','','特价机票/门票旅游/酒店','特价机票/门票旅游/酒店','特价机票/门票旅游/酒店','特价机票/门票旅游/酒店','0','9'); INSERT INTO my_goods_category VALUES ('10','2','','运动服','运动服','运动服','运动服','1','11'); INSERT INTO my_goods_category VALUES ('11','2','','野营','野营','野营','野营','1','12'); INSERT INTO my_goods_category VALUES ('12','2','','游泳用品','游泳用品','游泳用品','游泳用品','1','13'); INSERT INTO my_goods_category VALUES ('13','2','','运动包','运动包','运动包','运动包','1','14'); INSERT INTO my_goods_category VALUES ('14','2','','户外军品','户外军品','户外军品','户外军品','1','15'); INSERT INTO my_goods_category VALUES ('15','2','','健美健身','健美健身','健美健身','健美健身','1','16'); INSERT INTO my_goods_category VALUES ('16','2','','瑜珈用品','瑜珈用品','瑜珈用品','瑜珈用品','1','17'); INSERT INTO my_goods_category VALUES ('17','2','','羽毛球','羽毛球','羽毛球','羽毛球','1','18'); INSERT INTO my_goods_category VALUES ('18','2','','其它','其它','其它','其它','1','19'); INSERT INTO my_goods_category VALUES ('19','2','','衬衫','衬衫','衬衫','衬衫','2','21'); INSERT INTO my_goods_category VALUES ('20','2','','小吊带','小吊带','小吊带','小吊带','2','22'); INSERT INTO my_goods_category VALUES ('21','2','','韩版','韩版','韩版','韩版','2','23'); INSERT INTO my_goods_category VALUES ('22','2','','牛仔裤','牛仔裤','牛仔裤','牛仔裤','2','24'); INSERT INTO my_goods_category VALUES ('23','2','','蕾丝雪纺','蕾丝雪纺','蕾丝雪纺','蕾丝雪纺','2','25'); INSERT INTO my_goods_category VALUES ('24','2','','小外套','小外套','小外套','小外套','2','26'); INSERT INTO my_goods_category VALUES ('25','2','','其它','其它','其它','其它','2','27'); INSERT INTO my_goods_category VALUES ('26','2','','外套','外套','外套','外套','3','29'); INSERT INTO my_goods_category VALUES ('27','2','','西服','西服','西服','西服','3','30'); INSERT INTO my_goods_category VALUES ('28','2','','男鞋','男鞋','男鞋','男鞋','3','31'); INSERT INTO my_goods_category VALUES ('29','2','','衬衫','衬衫','衬衫','衬衫','3','32'); INSERT INTO my_goods_category VALUES ('30','2','','凉鞋','凉鞋','凉鞋','凉鞋','3','33'); INSERT INTO my_goods_category VALUES ('31','2','','休闲包','休闲包','休闲包','休闲包','3','34'); INSERT INTO my_goods_category VALUES ('32','2','','皮带','皮带','皮带','皮带','3','35'); INSERT INTO my_goods_category VALUES ('33','2','','男士内衣','男士内衣','男士内衣','男士内衣','3','36'); INSERT INTO my_goods_category VALUES ('34','2','','男裤','男裤','男裤','男裤','3','37'); INSERT INTO my_goods_category VALUES ('35','2','','其它','其它','其它','其它','3','38'); INSERT INTO my_goods_category VALUES ('36','2','','时尚家饰','时尚家饰','时尚家饰','时尚家饰','4','40'); INSERT INTO my_goods_category VALUES ('37','2','','居家日用','居家日用','居家日用','居家日用','4','41'); INSERT INTO my_goods_category VALUES ('38','2','','家具','家具','家具','家具','4','42'); INSERT INTO my_goods_category VALUES ('39','2','','灯具','灯具','灯具','灯具','4','43'); INSERT INTO my_goods_category VALUES ('40','2','','厨具','厨具','厨具','厨具','4','44'); INSERT INTO my_goods_category VALUES ('41','2','','装潢卫浴','装潢卫浴','装潢卫浴','装潢卫浴','4','45'); INSERT INTO my_goods_category VALUES ('42','2','','文具天文','文具天文','文具天文','文具天文','4','46'); INSERT INTO my_goods_category VALUES ('43','2','','其它','其它','其它','其它','4','47'); INSERT INTO my_goods_category VALUES ('44','2','','厨房用品','厨房用品','厨房用品','厨房用品','5','49'); INSERT INTO my_goods_category VALUES ('45','2','','卫生保健','卫生保健','卫生保健','卫生保健','5','50'); INSERT INTO my_goods_category VALUES ('46','2','','个人护理','个人护理','个人护理','个人护理','5','51'); INSERT INTO my_goods_category VALUES ('47','2','','卫浴电器','卫浴电器','卫浴电器','卫浴电器','5','52'); INSERT INTO my_goods_category VALUES ('48','2','','其它','其它','其它','其它','5','53'); INSERT INTO my_goods_category VALUES ('49','2','','摩托车','摩托车','摩托车','摩托车','6','55'); INSERT INTO my_goods_category VALUES ('50','2','','自行车','自行车','自行车','自行车','6','56'); INSERT INTO my_goods_category VALUES ('51','2','','汽车','汽车','汽车','汽车','6','57'); INSERT INTO my_goods_category VALUES ('52','2','','GPS定位','GPS定位','GPS定位','GPS定位','6','58'); INSERT INTO my_goods_category VALUES ('53','2','','车内饰','车内饰','车内饰','车内饰','6','59'); INSERT INTO my_goods_category VALUES ('54','2','','其它','其它','其它','其它','6','60'); INSERT INTO my_goods_category VALUES ('55','2','','手表','手表','手表','手表','7','62'); INSERT INTO my_goods_category VALUES ('56','2','','太阳眼镜','太阳眼镜','太阳眼镜','太阳眼镜','7','63'); INSERT INTO my_goods_category VALUES ('57','2','','流行饰品','流行饰品','流行饰品','流行饰品','7','64'); INSERT INTO my_goods_category VALUES ('58','2','','纯银','纯银','纯银','纯银','7','65'); INSERT INTO my_goods_category VALUES ('59','2','','钻石水晶','钻石水晶','钻石水晶','钻石水晶','7','66'); INSERT INTO my_goods_category VALUES ('60','2','','黄金','黄金','黄金','黄金','7','67'); INSERT INTO my_goods_category VALUES ('61','2','','珍珠翡翠','珍珠翡翠','珍珠翡翠','珍珠翡翠','7','68'); INSERT INTO my_goods_category VALUES ('62','2','','其它','其它','其它','其它','7','69'); INSERT INTO my_goods_category VALUES ('63','2','','整机','整机','整机','整机','8','71'); INSERT INTO my_goods_category VALUES ('64','2','','笔记本','笔记本','笔记本','笔记本','8','72'); INSERT INTO my_goods_category VALUES ('65','2','','显示器','显示器','显示器','显示器','8','73'); INSERT INTO my_goods_category VALUES ('66','2','','软件','软件','软件','软件','8','74'); INSERT INTO my_goods_category VALUES ('67','2','','硬盘/移动硬盘','硬盘/移动硬盘','硬盘/移动硬盘','硬盘/移动硬盘','8','75'); INSERT INTO my_goods_category VALUES ('68','2','','键盘/鼠标','键盘/鼠标','键盘/鼠标','键盘/鼠标','8','76'); INSERT INTO my_goods_category VALUES ('69','2','','其它','其它','其它','其它','8','77'); INSERT INTO my_goods_category VALUES ('70','2','','特惠酒店','特惠酒店','特惠酒店','特惠酒店','9','79'); INSERT INTO my_goods_category VALUES ('72','2','','旅游卡券','旅游卡券','旅游卡券','旅游卡券','9','81'); INSERT INTO my_goods_category VALUES ('73','2','','酒店客栈','酒店客栈','酒店客栈','酒店客栈','9','82'); INSERT INTO my_goods_category VALUES ('74','2','','其它','其它','其它','其它','9','83'); DROP TABLE IF EXISTS my_goods_order; CREATE TABLE my_goods_order ( id int(10) NOT NULL AUTO_INCREMENT, goodsid int(10) NOT NULL, ordernum smallint(5) NOT NULL, oname varchar(100) NOT NULL, tel varchar(50) NOT NULL, mobile varchar(50) NOT NULL, address varchar(200) NOT NULL, ip varchar(20) NOT NULL, qq varchar(11) NOT NULL, msg varchar(255) NOT NULL, dateline int(10) NOT NULL, PRIMARY KEY (id), KEY goodsid (goodsid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_group; CREATE TABLE my_group ( groupid int(10) NOT NULL AUTO_INCREMENT, userid varchar(50) NOT NULL, gname varchar(250) NOT NULL, cate_id smallint(3) NOT NULL, areaid smallint(5) NOT NULL, dateline int(10) NOT NULL, displayorder int(10) NOT NULL, signintotal smallint(5) NOT NULL DEFAULT '0', glevel tinyint(1) NOT NULL DEFAULT '0', message varchar(250) NOT NULL, gaddress varchar(250) NOT NULL, meetdate int(10) NOT NULL, enddate int(10) NOT NULL, mastername varchar(100) NOT NULL, masterqq int(11) NOT NULL, des varchar(250) NOT NULL, content mediumtext NOT NULL, picture varchar(255) NOT NULL, pre_picture varchar(255) NOT NULL, commenturl varchar(100) NOT NULL, biztype varchar(100) NOT NULL, othercontent mediumtext NOT NULL, web_address char(100) NOT NULL, PRIMARY KEY (groupid), KEY areaid (areaid), KEY cate_id (cate_id), KEY userid (userid), KEY glevel (glevel) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_group_category; CREATE TABLE my_group_category ( cate_id smallint(3) NOT NULL AUTO_INCREMENT, cate_name varchar(100) NOT NULL, cate_view tinyint(1) NOT NULL DEFAULT '1', cate_order smallint(3) NOT NULL DEFAULT '0', PRIMARY KEY (cate_id) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 AUTO_INCREMENT=10; INSERT INTO my_group_category VALUES ('1','家居团','1','1'); INSERT INTO my_group_category VALUES ('2','婚庆团','1','2'); INSERT INTO my_group_category VALUES ('3','买车团','1','3'); INSERT INTO my_group_category VALUES ('4','建材团','1','4'); INSERT INTO my_group_category VALUES ('5','找驴友','1','5'); INSERT INTO my_group_category VALUES ('6','母婴团','1','6'); INSERT INTO my_group_category VALUES ('9','其它','1','7'); DROP TABLE IF EXISTS my_group_signin; CREATE TABLE my_group_signin ( signid int(10) NOT NULL AUTO_INCREMENT, sname varchar(100) NOT NULL, sex enum('男','女') NOT NULL, age varchar(50) NOT NULL, groupid int(10) NOT NULL, qqmsn varchar(50) NOT NULL, tel varchar(50) NOT NULL, dateline int(10) NOT NULL, totalnumber smallint(5) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', signinip varchar(20) NOT NULL, message varchar(250) NOT NULL, PRIMARY KEY (signid), KEY groupid (groupid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_info_img; CREATE TABLE my_info_img ( id int(10) NOT NULL AUTO_INCREMENT, image_id tinyint(1) NOT NULL, path varchar(250) NOT NULL, prepath varchar(250) NOT NULL, infoid int(11) NOT NULL, uptime int(11) NOT NULL, PRIMARY KEY (id), KEY infoid (infoid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_info_report; CREATE TABLE my_info_report ( id int(8) NOT NULL AUTO_INCREMENT, infoid int(8) NOT NULL, userid varchar(30) NOT NULL, infotitle char(50) NOT NULL, report_type smallint(3) NOT NULL, content varchar(255) NOT NULL, ip varchar(20) NOT NULL, pubtime int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_info_typemodels; CREATE TABLE my_info_typemodels ( id smallint(6) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, displayorder int(8) NOT NULL DEFAULT '0', `type` tinyint(1) NOT NULL DEFAULT '0', `options` mediumtext NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 AUTO_INCREMENT=29; INSERT INTO my_info_typemodels VALUES ('1','空模型','0','1',''); INSERT INTO my_info_typemodels VALUES ('2','二手物品交易模型','2','0','39,9,58'); INSERT INTO my_info_typemodels VALUES ('6','电脑转让模型','6','0','54,58,9,39'); INSERT INTO my_info_typemodels VALUES ('7','全职招聘模型','7','0','43,40,44,42,47,49,61,62'); INSERT INTO my_info_typemodels VALUES ('8','兼职招聘模型','8','0','41,42'); INSERT INTO my_info_typemodels VALUES ('9','简历模型','9','0','45,46,47,48,49'); INSERT INTO my_info_typemodels VALUES ('10','教育培训模型','10','0','50'); INSERT INTO my_info_typemodels VALUES ('11','电动车交易模型','11','0','11,9,58,39'); INSERT INTO my_info_typemodels VALUES ('12','二手轿车模型','12','0','14,16,17,13,58,39'); INSERT INTO my_info_typemodels VALUES ('13','自行车交易模型','13','0','22,9,39,58'); INSERT INTO my_info_typemodels VALUES ('14','拼车顺风车模型','14','0','20,9,21'); INSERT INTO my_info_typemodels VALUES ('15','面包车客车模型','15','0','17,16,13,58,39'); INSERT INTO my_info_typemodels VALUES ('16','大件物品交易模型','16','0','13,58,39'); INSERT INTO my_info_typemodels VALUES ('18','技能交换模型','18','0','51'); INSERT INTO my_info_typemodels VALUES ('19','征婚交友模型','19','0','45,46,52'); INSERT INTO my_info_typemodels VALUES ('20','狗狗模型','20','0','25,26,9,39'); INSERT INTO my_info_typemodels VALUES ('21','猫猫等宠物模型','21','0','27,9'); INSERT INTO my_info_typemodels VALUES ('22','二手房模型','22','0','33,34,35,36,13,30'); INSERT INTO my_info_typemodels VALUES ('23','出租房模型','23','0','33,37,35,38,64'); INSERT INTO my_info_typemodels VALUES ('24','厂房/写字楼出租模型','24','0','33,30,29'); INSERT INTO my_info_typemodels VALUES ('25','商铺/写字楼出售模型','25','0','30,13'); INSERT INTO my_info_typemodels VALUES ('26','店铺转让出租模型','26','0','31,30,32'); INSERT INTO my_info_typemodels VALUES ('27','摩托车模型','0','0','60,9,39'); INSERT INTO my_info_typemodels VALUES ('28','手机转让模型','0','0','65,9,58,39'); DROP TABLE IF EXISTS my_info_typeoptions; CREATE TABLE my_info_typeoptions ( optionid smallint(6) unsigned NOT NULL AUTO_INCREMENT, classid smallint(6) unsigned NOT NULL DEFAULT '0', displayorder tinyint(3) NOT NULL DEFAULT '0', title varchar(100) NOT NULL DEFAULT '', description varchar(255) NOT NULL DEFAULT '', identifier varchar(40) NOT NULL DEFAULT '', `type` varchar(20) NOT NULL DEFAULT '', rules mediumtext NOT NULL, available char(2) NOT NULL, required char(2) NOT NULL, search char(2) NOT NULL, PRIMARY KEY (optionid), KEY classid (classid), KEY available (available), KEY search (search), KEY displayorder (displayorder) ) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 AUTO_INCREMENT=66; INSERT INTO my_info_typeoptions VALUES ('1','0','0','通用类','','','','','0','0','0'); INSERT INTO my_info_typeoptions VALUES ('2','0','0','房产类','','','','','0','0','0'); INSERT INTO my_info_typeoptions VALUES ('3','0','0','交友类','','','','','0','0','0'); INSERT INTO my_info_typeoptions VALUES ('4','0','0','求职招聘类','','','','','0','0','0'); INSERT INTO my_info_typeoptions VALUES ('5','0','0','交易类','','','','','0','0','0'); INSERT INTO my_info_typeoptions VALUES ('6','0','0','教育培训类','','','','','0','0','0'); INSERT INTO my_info_typeoptions VALUES ('7','0','0','宠物类','','','','','0','0','0'); INSERT INTO my_info_typeoptions VALUES ('8','0','0','车辆类','','','','','0','0','0'); INSERT INTO my_info_typeoptions VALUES ('9','5','1','价格','小额价格','price','number','a:2:{s:5:\"units\";s:2:\"元\";s:7:\"choices\";s:98:\"1~1000=1000以内\r\n1000~3000=1000~3000\r\n3000~5000=3000~5000\r\n5000~10000=5000~10000\r\n10000~=10000以上\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('11','8','3','电动车品牌','电动车品牌','ebike_brand','select','a:1:{s:7:\"choices\";s:46:\"1=新日\r\n2=立马\r\n3=绿源\r\n4=爱玛\r\n5=雅迪\r\n6=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('13','5','0','价格','万元级别的价格','prices','number','a:2:{s:5:\"units\";s:4:\"万元\";s:7:\"choices\";s:99:\"1~5=5万以内\r\n5~10=5万~10万\r\n10~50=10万~50万\r\n50~100=50万~100万\r\n100~300=100万~300万\r\n300~=300万以上\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('14','8','5','轿车品牌','轿车品牌','car_brand','select','a:1:{s:7:\"choices\";s:148:\"1=大众\r\n2=本田\r\n3=丰田\r\n4=别克\r\n5=奥迪\r\n6=奔驰\r\n7=宝马\r\n8=比亚迪\r\n9=现代\r\n10=雪佛兰\r\n11=奇瑞\r\n12=福特\r\n13=日产\r\n14=马自达\r\n15=金杯\r\n16=路虎\r\n17=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('16','8','7','上牌年份','上牌年份','car_year','select','a:1:{s:7:\"choices\";s:62:\"1=2012年以前\r\n2=2012年\r\n3=2013年\r\n4=2014年\r\n5=2015年\r\n6=2016年\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('17','8','8','行驶里程','行驶里程','mileage','number','a:2:{s:5:\"units\";s:6:\"万公里\";s:7:\"choices\";s:61:\"0~1=1万公里以内\r\n1~3=1~3万公里\r\n3~5=3~5万公里\r\n5~=5万公里以上\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('18','8','9','面包车类型','面包车类型','minibus_type','select','a:1:{s:7:\"choices\";s:28:\"1=大客车\r\n2=中巴车\r\n3=面包车\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('19','8','10','摩托车品牌','摩托车品牌','moto_brand','select','a:1:{s:7:\"choices\";s:74:\"1=雅马哈\r\n2=本田\r\n3=建设\r\n4=铃木\r\n5=宗申\r\n6=力帆\r\n7=豪爵\r\n8=新大洲\r\n9=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('20','8','11','拼车类型','拼车类型','carpool_type','select','a:1:{s:7:\"choices\";s:52:\"1=长途车拼车\r\n2=上下班拼车\r\n3=上下学拼车\r\n4=其它拼车\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('21','8','12','目的地','目的地','destination','text','a:1:{s:9:\"maxlength\";s:0:\"\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('22','8','13','自行车品牌','自行车品牌','bike_brand','select','a:1:{s:7:\"choices\";s:32:\"1=永久\r\n2=凤凰\r\n3=捷安特\r\n4=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('24','7','24','宠物类型','宠物类型','pet_type','select','a:1:{s:7:\"choices\";s:36:\"1=狗\r\n2=猫\r\n3=鸟\r\n4=鼠\r\n5=兔\r\n6=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('25','7','25','狗狗品种','狗狗品种','dog_breeds','select','a:1:{s:7:\"choices\";s:80:\"1=泰迪\r\n2=萨摩耶\r\n3=金毛\r\n4=藏獒\r\n5=雪橇犬\r\n6=哈士奇\r\n7=拉布拉多\r\n8=贵宾\r\n9=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('26','7','0','公母','动物公母','animal_sex','radio','a:1:{s:7:\"choices\";s:10:\"1=公\r\n2=母\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('27','7','26','宠物类别','猫猫等其它宠物类别','pet_class','select','a:1:{s:7:\"choices\";s:30:\"1=猫猫\r\n2=水族\r\n3=花鸟\r\n4=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('28','2','30','厂房租售类型','厂房/仓库/土地租售类型','factory_type','select','a:1:{s:7:\"choices\";s:94:\"1=厂房出租\r\n2=厂房出售\r\n3=仓库出租\r\n4=仓库出售\r\n5=土地出租\r\n6=土地出售\r\n7=其它出租\r\n8=其它出售\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('29','2','31','租金','厂房/写字楼出租价格','min_rent','number','a:2:{s:5:\"units\";s:10:\"元/平米/天\";s:7:\"choices\";s:56:\"1~2=1~2元/平米/天\r\n2~4=2~4元/平米/天\r\n4~=4元以上/平米/天\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('30','2','32','面积','房屋面积','acreage','number','a:2:{s:5:\"units\";s:4:\"平米\";s:7:\"choices\";s:107:\"1~30=30平米以内\r\n30~50=30~50平米\r\n50~90=50~90平米\r\n90~150=90~150平米\r\n150~300=100~300平米\r\n300~=300平米以上\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('31','2','0','店铺分类','店铺分类','store_type','select','a:1:{s:7:\"choices\";s:115:\"1=餐饮美食\r\n2=服饰鞋包\r\n3=酒店宾馆\r\n4=超市零售\r\n5=空铺转让\r\n6=美容美发\r\n7=家居建材\r\n8=汽修美容\r\n9=电子通讯\r\n10=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('32','2','33','租金','店铺/房屋租金','rent','number','a:1:{s:5:\"units\";s:2:\"元\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('33','2','34','身份','个人/中介','position','radio','a:1:{s:7:\"choices\";s:16:\"1=个人\r\n2=经纪人\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('34','2','35','装修','装修情况','renovation','select','a:1:{s:7:\"choices\";s:42:\"1=毛坯房\r\n2=简单装修\r\n3=中等装修\r\n4=精装修\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('35','2','36','房型','房型','room_type','select','a:1:{s:7:\"choices\";s:71:\"1=4室及以上\r\n2=3室2厅\r\n3=3室1厅\r\n4=2室2厅\r\n5=2室1厅\r\n6=1室1厅\r\n7=1室0厅\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('36','2','37','楼层','','floor','number','a:1:{s:5:\"units\";s:2:\"楼\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('37','2','38','出租形式','出租形式','rent_type','select','a:1:{s:7:\"choices\";s:22:\"1=整套\r\n2=单间\r\n3=床位\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('38','2','39','租金','','mini_rent','number','a:2:{s:5:\"units\";s:2:\"元\";s:7:\"choices\";s:98:\"1~1000=1000以内\r\n1000~3000=1000~3000\r\n3000~5000=3000~5000\r\n5000~10000=5000~10000\r\n10000~=10000以上\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('39','1','0','来源','服务者身份','from','radio','a:1:{s:7:\"choices\";s:14:\"1=个人\r\n2=商家\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('40','4','39','月薪','月薪','salary','select','a:1:{s:7:\"choices\";s:112:\"1=面议\r\n2=1000以下\r\n3=1000~2000\r\n3=2000~3000\r\n4=3000~6000\r\n5=6000~8000\r\n6=8000~12000\r\n7=12000~30000\r\n8=30000以上\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('41','4','41','日薪','日薪','day_salary','number','a:2:{s:5:\"units\";s:5:\"元/天\";s:7:\"choices\";s:117:\"1~20=20元以内/天\r\n20~50=20~50元/天\r\n50~100=50~100元/天\r\n100~300=100~300元/天\r\n300~500=300~500元/天\r\n500~=500元以上/天\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('42','4','42','公司名称','公司名称','company','text','a:1:{s:9:\"maxlength\";s:0:\"\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('43','4','43','性别要求','性别要求','sex_demand','checkbox','a:1:{s:7:\"choices\";s:10:\"1=男\r\n2=女\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('44','4','44','职位','职位','job','text','a:1:{s:9:\"maxlength\";s:0:\"\";}','on','',''); INSERT INTO my_info_typeoptions VALUES ('45','4','45','性别','性别','sex','radio','a:1:{s:7:\"choices\";s:10:\"1=男\r\n2=女\";}','on','','on'); INSERT INTO my_info_typeoptions VALUES ('46','4','46','年龄','年龄','age','number','a:2:{s:5:\"units\";s:2:\"岁\";s:7:\"choices\";s:0:\"\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('47','4','47','学历','学历','education','select','a:1:{s:7:\"choices\";s:68:\"1=初中及以下\r\n2=高中/中专/技校\r\n3=大专\r\n4=本科\r\n5=硕士\r\n6=博士及以上\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('48','4','48','是否应届','是否应届','graduate','radio','a:1:{s:7:\"choices\";s:16:\"1=应届\r\n2=非应届\";}','on','','on'); INSERT INTO my_info_typeoptions VALUES ('49','4','49','工作年限','工作年限','work_life','number','a:2:{s:5:\"units\";s:2:\"年\";s:7:\"choices\";s:60:\"1~1=1年以下\r\n1~2=1~2年\r\n3~5=3~5年\r\n6~10=6~10年\r\n10~=10年以上\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('50','6','50','学费','课程学费','tuition','number','a:2:{s:5:\"units\";s:2:\"元\";s:7:\"choices\";s:98:\"1~1000=1000以内\r\n1000~3000=1000~3000\r\n3000~5000=3000~5000\r\n5000~10000=5000~10000\r\n10000~=10000以上\";}','on','','on'); INSERT INTO my_info_typeoptions VALUES ('51','3','51','我会','我的技能','ican','checkbox','a:1:{s:7:\"choices\";s:125:\"1=魔术\r\n2=古玩鉴赏\r\n3=电器维修\r\n4=唱歌\r\n5=方言\r\n6=理财/金融\r\n7=数理化\r\n8=武术\r\n9=象棋/围棋\r\n10=中医\r\n11=平面设计\r\n12=服装设计\";}','on','',''); INSERT INTO my_info_typeoptions VALUES ('52','3','52','职业','','jobs','text','a:1:{s:9:\"maxlength\";s:0:\"\";}','on','',''); INSERT INTO my_info_typeoptions VALUES ('54','5','54','电脑品牌','电脑品牌','pc_brand','select','a:1:{s:7:\"choices\";s:109:\"1=戴尔\r\n2=华硕\r\n3=惠普\r\n4=联想\r\n5=IBM\r\n6=苹果\r\n7=三星\r\n8=东芝\r\n9=神舟\r\n10=方正\r\n11=清华同方\r\n12=索尼\r\n13=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('55','5','55','电器类型','电器类型','appliances','select','a:1:{s:7:\"choices\";s:100:\"1=空调\r\n2=厨房电器\r\n3=居家电器\r\n4=影音电器\r\n5=冰箱/冷柜\r\n6=电视机\r\n7=卫浴/护理电器\r\n8=洗衣机\r\n9=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('58','5','58','新旧程度','新旧程度','new_old','select','a:1:{s:7:\"choices\";s:33:\"1=全新\r\n2=9成新\r\n3=7成新\r\n4=5成新\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('60','8','0','摩托车品牌','','motobrand','select','a:1:{s:7:\"choices\";s:74:\"1=雅马哈\r\n2=本田\r\n3=建设\r\n4=铃木\r\n5=宗申\r\n6=力帆\r\n7=豪爵\r\n8=新大洲\r\n9=其它\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('61','4','0','福利','','fuli','checkbox','a:1:{s:7:\"choices\";s:99:\"1=五险一金\r\n2=包住\r\n3=包吃\r\n4=年底双薪\r\n5=周末双休\r\n6=交通补助\r\n7=加班补助\r\n8=餐补\r\n9=话补\r\n10=房补\";}','on','on','on'); INSERT INTO my_info_typeoptions VALUES ('62','4','0','公司性质','','property','radio','a:1:{s:7:\"choices\";s:95:\"1=私营\r\n2=国有\r\n3=股份制\r\n4=外商独资办事处\r\n5=中外合资/合作\r\n6=上市公司\r\n7=事业单位\r\n8=政府机关\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('64','2','0','房屋配置','','house_pro','checkbox','a:1:{s:7:\"choices\";s:81:\"1=床\r\n2=衣柜\r\n3=沙发\r\n4=电视\r\n5=冰箱\r\n6=洗衣机\r\n7=空调\r\n8=热水器\r\n9=宽带\r\n10=暖气\";}','on','on',''); INSERT INTO my_info_typeoptions VALUES ('65','5','0','手机品牌','','mbrand','radio','a:1:{s:7:\"choices\";s:125:\"1=iphone\r\n2=三星\r\n3=小米\r\n4=乐视\r\n5=华为\r\n6=联想\r\n7=锤子\r\n8=诺基亚\r\n9=HTC\r\n10=山寨/高仿机\r\n11=MOTO\r\n12=中兴\r\n13=索尼\r\n14=其他\";}','on','on','on'); DROP TABLE IF EXISTS my_information; CREATE TABLE my_information ( id int(10) NOT NULL AUTO_INCREMENT, title varchar(30) NOT NULL, gid smallint(5) NOT NULL, catid int(8) NOT NULL, catname varchar(32) NOT NULL, areaid int(8) NOT NULL, begintime int(11) NOT NULL, activetime smallint(3) NOT NULL, endtime int(11) NOT NULL, content mediumtext NOT NULL, userid varchar(30) NOT NULL, contact_who char(10) NOT NULL, qq char(12) NOT NULL, email varchar(50) NOT NULL, tel varchar(30) NOT NULL, updatetime int(11) NOT NULL, hit int(10) NOT NULL DEFAULT '0', ismember tinyint(1) NOT NULL, manage_pwd char(32) NOT NULL, ip varchar(20) NOT NULL, ip2area varchar(32) NOT NULL, info_level tinyint(1) NOT NULL, img_path varchar(200) NOT NULL, img_count smallint(3) NOT NULL DEFAULT '0', upgrade_type tinyint(1) NOT NULL DEFAULT '1', upgrade_time int(10) NOT NULL, upgrade_type_list tinyint(1) NOT NULL DEFAULT '1', upgrade_time_list int(10) NOT NULL, ifred tinyint(1) NOT NULL DEFAULT '0', ifbold tinyint(1) NOT NULL DEFAULT '0', certify tinyint(1) NOT NULL DEFAULT '0', dir_typename varchar(100) NOT NULL, html_path varchar(100) NOT NULL, upgrade_type_index tinyint(1) NOT NULL, upgrade_time_index int(10) NOT NULL, mappoint varchar(100) NOT NULL, web_address char(100) NOT NULL, latitude decimal(20,17) NOT NULL, longitude decimal(20,17) NOT NULL, zan int(10) NOT NULL DEFAULT '0', face varchar(250) NOT NULL, PRIMARY KEY (id), KEY userid (userid), KEY ifred (ifred), KEY ifbold (ifbold), KEY tel (tel), KEY upgrade_type_index (upgrade_type_index), KEY begintime (begintime,info_level,id), KEY catid (catid,info_level,areaid), KEY upgrade_type_list (upgrade_type_list,begintime,id), KEY upgrade_type (upgrade_type,begintime,id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_10; CREATE TABLE my_information_10 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', tuition mediumint(7) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_11; CREATE TABLE my_information_11 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', ebike_class tinyint(1) NOT NULL DEFAULT '0', ebike_brand tinyint(1) NOT NULL DEFAULT '0', price mediumint(7) NOT NULL DEFAULT '0', content mediumtext, new_old tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_12; CREATE TABLE my_information_12 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', car_brand tinyint(1) NOT NULL DEFAULT '0', car_year tinyint(1) NOT NULL DEFAULT '0', mileage decimal(10,2) NOT NULL DEFAULT '0.00', prices decimal(10,2) NOT NULL DEFAULT '0.00', content mediumtext, new_old tinyint(1) NOT NULL DEFAULT '0', `from` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_13; CREATE TABLE my_information_13 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', bike_type tinyint(1) NOT NULL DEFAULT '0', bike_brand tinyint(1) NOT NULL DEFAULT '0', price mediumint(7) NOT NULL DEFAULT '0', content mediumtext, new_old tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_14; CREATE TABLE my_information_14 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', carpool_type tinyint(1) NOT NULL DEFAULT '0', price mediumint(7) NOT NULL DEFAULT '0', destination varchar(250) NOT NULL, content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_15; CREATE TABLE my_information_15 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', mileage decimal(10,2) NOT NULL DEFAULT '0.00', car_year tinyint(1) NOT NULL DEFAULT '0', content mediumtext, prices decimal(10,2) NOT NULL DEFAULT '0.00', new_old tinyint(1) NOT NULL DEFAULT '0', `from` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_16; CREATE TABLE my_information_16 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', content mediumtext, new_old tinyint(1) NOT NULL DEFAULT '0', prices decimal(10,2) NOT NULL DEFAULT '0.00', `from` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_17; CREATE TABLE my_information_17 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', truke_type tinyint(1) NOT NULL DEFAULT '0', prices mediumint(7) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_18; CREATE TABLE my_information_18 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', ican tinyint(1) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_19; CREATE TABLE my_information_19 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', sex tinyint(1) NOT NULL DEFAULT '0', age decimal(10,2) NOT NULL DEFAULT '0.00', jobs varchar(250) NOT NULL, content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_2; CREATE TABLE my_information_2 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', `from` tinyint(1) NOT NULL DEFAULT '0', price mediumint(7) NOT NULL DEFAULT '0', new_old tinyint(1) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_20; CREATE TABLE my_information_20 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', dog_breeds tinyint(1) NOT NULL DEFAULT '0', animal_sex tinyint(1) NOT NULL DEFAULT '0', price mediumint(7) NOT NULL DEFAULT '0', content mediumtext, `from` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_21; CREATE TABLE my_information_21 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', pet_class tinyint(1) NOT NULL DEFAULT '0', price mediumint(7) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_22; CREATE TABLE my_information_22 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', position tinyint(1) NOT NULL DEFAULT '0', renovation tinyint(1) NOT NULL DEFAULT '0', room_type tinyint(1) NOT NULL DEFAULT '0', floor mediumint(7) NOT NULL DEFAULT '0', prices decimal(10,2) NOT NULL DEFAULT '0.00', acreage mediumint(7) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_23; CREATE TABLE my_information_23 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', position tinyint(1) NOT NULL DEFAULT '0', rent_type tinyint(1) NOT NULL DEFAULT '0', room_type tinyint(1) NOT NULL DEFAULT '0', mini_rent decimal(10,2) NOT NULL DEFAULT '0.00', content mediumtext, house_pro varchar(100) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_24; CREATE TABLE my_information_24 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', position tinyint(1) NOT NULL DEFAULT '0', acreage mediumint(7) NOT NULL DEFAULT '0', min_rent mediumint(7) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_25; CREATE TABLE my_information_25 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', acreage mediumint(7) NOT NULL DEFAULT '0', prices decimal(10,2) NOT NULL DEFAULT '0.00', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_26; CREATE TABLE my_information_26 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', store_type tinyint(1) NOT NULL DEFAULT '0', acreage mediumint(7) NOT NULL DEFAULT '0', rent mediumint(7) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_27; CREATE TABLE my_information_27 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', motobrand tinyint(1) NOT NULL DEFAULT '0', price mediumint(7) NOT NULL DEFAULT '0', `from` tinyint(1) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_28; CREATE TABLE my_information_28 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', mbrand tinyint(1) NOT NULL DEFAULT '0', price decimal(10,2) NOT NULL DEFAULT '0.00', new_old tinyint(1) NOT NULL DEFAULT '0', `from` tinyint(1) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_5; CREATE TABLE my_information_5 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', operator tinyint(1) NOT NULL DEFAULT '0', price mediumint(7) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_6; CREATE TABLE my_information_6 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', pc_brand tinyint(1) NOT NULL DEFAULT '0', new_old tinyint(1) NOT NULL DEFAULT '0', price decimal(10,2) NOT NULL DEFAULT '0.00', content mediumtext, `from` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_7; CREATE TABLE my_information_7 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', sex_demand varchar(100) NOT NULL DEFAULT '0', salary tinyint(1) NOT NULL DEFAULT '0', job varchar(250) NOT NULL, company varchar(250) NOT NULL, content mediumtext, education tinyint(1) NOT NULL DEFAULT '0', work_life mediumint(7) NOT NULL DEFAULT '0', fuli varchar(100) NOT NULL DEFAULT '0', property tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_8; CREATE TABLE my_information_8 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', day_salary mediumint(7) NOT NULL DEFAULT '0', company varchar(250) NOT NULL, content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_information_9; CREATE TABLE my_information_9 ( iid mediumint(7) NOT NULL AUTO_INCREMENT, id int(10) NOT NULL DEFAULT '0', sex tinyint(1) NOT NULL DEFAULT '0', age decimal(10,2) NOT NULL DEFAULT '0.00', education tinyint(1) NOT NULL DEFAULT '0', graduate tinyint(1) NOT NULL DEFAULT '0', work_life mediumint(7) NOT NULL DEFAULT '0', content mediumtext, PRIMARY KEY (iid), KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_insidelink; CREATE TABLE my_insidelink ( id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, word char(16) NOT NULL, url char(60) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_jswizard; CREATE TABLE my_jswizard ( id smallint(5) NOT NULL AUTO_INCREMENT, flag varchar(50) NOT NULL, parameter mediumtext NOT NULL, edittime int(10) NOT NULL, customtype char(8) NOT NULL, PRIMARY KEY (id), KEY flag (flag) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 AUTO_INCREMENT=6; INSERT INTO my_jswizard VALUES ('5','5umb','a:8:{s:10:\"jstemplate\";s:25:\"
  • {title} - {link}
    • \";s:5:\"items\";s:0:\"\";s:9:\"maxlength\";s:0:\"\";s:3:\"ids\";s:0:\"\";s:7:\"keyword\";s:0:\"\";s:9:\"newwindow\";s:1:\"0\";s:7:\"orderby\";s:8:\"dateline\";s:9:\"jscharset\";s:1:\"0\";}','1441594018','info'); INSERT INTO my_jswizard VALUES ('2','asdqwe','a:7:{s:10:\"jstemplate\";s:22:\"
  • {title}{link}
    • \";s:5:\"catid\";s:0:\"\";s:5:\"items\";s:0:\"\";s:9:\"maxlength\";s:0:\"\";s:9:\"newwindow\";s:1:\"0\";s:7:\"orderby\";s:8:\"dateline\";s:9:\"jscharset\";s:1:\"0\";}','1441596141','news'); INSERT INTO my_jswizard VALUES ('3','329e','a:8:{s:10:\"jstemplate\";s:22:\"
  • {tname}{link}
    • \";s:5:\"catid\";s:0:\"\";s:7:\"levelid\";s:0:\"\";s:5:\"items\";s:0:\"\";s:9:\"maxlength\";s:0:\"\";s:9:\"newwindow\";s:1:\"0\";s:7:\"orderby\";s:8:\"dateline\";s:9:\"jscharset\";s:1:\"0\";}','1441595310','store'); INSERT INTO my_jswizard VALUES ('4','4nmv','a:8:{s:10:\"jstemplate\";s:26:\"
  • {goodsname}{link}
    • \";s:5:\"catid\";s:0:\"\";s:5:\"items\";s:0:\"\";s:9:\"maxlength\";s:0:\"\";s:7:\"special\";a:1:{i:0;s:0:\"\";}s:9:\"newwindow\";s:1:\"0\";s:7:\"orderby\";s:8:\"dateline\";s:9:\"jscharset\";s:1:\"0\";}','1441595242','goods'); DROP TABLE IF EXISTS my_lifebox; CREATE TABLE my_lifebox ( id smallint(3) NOT NULL AUTO_INCREMENT, typeid tinyint(1) NOT NULL DEFAULT '2', lifename varchar(50) NOT NULL, lifeurl varchar(200) NOT NULL, if_view tinyint(1) NOT NULL, displayorder smallint(3) NOT NULL, PRIMARY KEY (id), KEY displayorder (displayorder) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_mail_sendlist; CREATE TABLE my_mail_sendlist ( id mediumint(8) NOT NULL AUTO_INCREMENT, email varchar(100) NOT NULL, template_id varchar(50) NOT NULL, email_content mediumtext NOT NULL, `error` tinyint(1) NOT NULL DEFAULT '0', email_subject varchar(200) NOT NULL, last_send int(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_mail_template; CREATE TABLE my_mail_template ( template_id tinyint(1) unsigned NOT NULL AUTO_INCREMENT, is_sys tinyint(1) NOT NULL DEFAULT '1', template_code varchar(30) NOT NULL DEFAULT '', is_html tinyint(1) unsigned NOT NULL DEFAULT '0', template_subject varchar(200) NOT NULL DEFAULT '', template_content mediumtext NOT NULL, last_modify int(10) unsigned NOT NULL DEFAULT '0', last_send int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (template_id), UNIQUE KEY template_code (template_code) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3; INSERT INTO my_mail_template VALUES ('1','1','findpwd','1','找回密码邮件','亲爱的用户 {$user_name} 您好！\r\n\r\n您已经进行了密码重置的操作，请点击以下链接（如无法打开请把此链接复制粘贴到浏览器打开）:\r\n\r\n{$reset_email}\r\n\r\n以确认您的新密码重置操作！此邮件为系统发出，请勿回复邮件。\r\n\r\n{$site_name}\r\n{$send_date}','1407235479','0'); INSERT INTO my_mail_template VALUES ('2','1','validate','1','新用户邮件验证','{$user_name}您好！\r\n\r\n这封邮件是 {$site_name} 发送的。你收到这封邮件是为了验证你注册邮件地址是否有效。如果您已经通过验证了，请忽略这封邮件。\r\n\r\n请点击以下链接(或者复制到您的浏览器)来验证你的邮件地址:\r\n{$validate_email}\r\n\r\n{$site_name}\r\n{$send_date}','1429947607','0'); DROP TABLE IF EXISTS my_member; CREATE TABLE my_member ( id mediumint(8) NOT NULL AUTO_INCREMENT, userid varchar(20) NOT NULL, openid varchar(50) NOT NULL, openid_wx varchar(50) NOT NULL, userpwd char(36) NOT NULL, catid varchar(250) NOT NULL, areaid char(8) NOT NULL, cname varchar(40) NOT NULL, tname varchar(100) NOT NULL, hourstime varchar(100) NOT NULL, introduce mediumtext NOT NULL, sex enum('男','女') NOT NULL DEFAULT '男', tel varchar(30) NOT NULL DEFAULT '', address varchar(50) NOT NULL DEFAULT '', busway mediumtext NOT NULL, mappoint varchar(100) NOT NULL, qq char(12) NOT NULL, msn char(50) NOT NULL DEFAULT '', email varchar(50) NOT NULL DEFAULT '', template char(250) NOT NULL, keywords varchar(250) NOT NULL, logo varchar(250) NOT NULL, prelogo varchar(250) NOT NULL, banner varchar(250) NOT NULL, safequestion char(25) NOT NULL, safeanswer char(25) NOT NULL, levelid smallint(3) NOT NULL DEFAULT '1', money_own mediumint(8) NOT NULL DEFAULT '0', credit int(10) NOT NULL DEFAULT '0', credits smallint(2) NOT NULL DEFAULT '1', score int(10) NOT NULL DEFAULT '0', joinip char(16) NOT NULL, loginip char(16) NOT NULL, jointime int(10) unsigned NOT NULL, logintime int(10) unsigned NOT NULL, web char(50) NOT NULL, per_certify tinyint(1) NOT NULL DEFAULT '0', com_certify tinyint(1) NOT NULL DEFAULT '0', if_corp tinyint(1) NOT NULL DEFAULT '0', ifindex tinyint(1) NOT NULL DEFAULT '1', iflist tinyint(1) NOT NULL DEFAULT '1', mobile varchar(20) NOT NULL, levelup_time int(10) NOT NULL, hit int(10) NOT NULL, `status` tinyint(1) NOT NULL, qdtime int(10) NOT NULL, sj_certify tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY userid (userid), KEY areaid (areaid), KEY catid (catid), KEY levelid (levelid), KEY if_corp (if_corp,`status`), KEY jointime (jointime), KEY ifindex (ifindex), KEY iflist (iflist), KEY openid (openid), KEY `status` (`status`), KEY openid_wx (openid_wx) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_member_album; CREATE TABLE my_member_album ( id int(11) NOT NULL AUTO_INCREMENT, title varchar(50) NOT NULL, path varchar(250) NOT NULL, prepath varchar(250) NOT NULL, userid varchar(20) NOT NULL, pubtime int(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_member_category; CREATE TABLE my_member_category ( id int(11) NOT NULL AUTO_INCREMENT, userid varchar(20) NOT NULL, catid mediumint(6) NOT NULL, PRIMARY KEY (id), KEY userid (userid), KEY catid (catid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_member_comment; CREATE TABLE my_member_comment ( id int(10) unsigned NOT NULL AUTO_INCREMENT, userid varchar(20) NOT NULL, fromuser varchar(20) NOT NULL, face varchar(250) NOT NULL, pubtime int(10) unsigned NOT NULL DEFAULT '0', quality tinyint(1) NOT NULL, service tinyint(1) NOT NULL, environment tinyint(1) NOT NULL, price tinyint(1) NOT NULL, avgprice varchar(20) NOT NULL, enjoy tinyint(1) NOT NULL, content mediumtext, reply mediumtext NOT NULL, retime int(10) NOT NULL, commentlevel tinyint(1) NOT NULL DEFAULT '1', flower int(5) NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY userid (userid), KEY enjoy (enjoy), KEY fromuser (fromuser), KEY commentlevel (commentlevel) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_member_docu; CREATE TABLE my_member_docu ( id int(11) NOT NULL AUTO_INCREMENT, typeid int(11) NOT NULL, userid varchar(20) NOT NULL, title varchar(250) NOT NULL, author varchar(50) NOT NULL, `source` varchar(50) NOT NULL, content mediumtext NOT NULL, hit int(10) NOT NULL DEFAULT '0', imgpath varchar(250) NOT NULL, pre_imgpath varchar(250) NOT NULL, pubtime int(10) NOT NULL, if_check tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (id), KEY userid (userid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_member_docutype; CREATE TABLE my_member_docutype ( typeid int(11) NOT NULL AUTO_INCREMENT, typename varchar(100) NOT NULL, arrid tinyint(1) NOT NULL DEFAULT '1', ifview tinyint(1) NOT NULL DEFAULT '1', displayorder int(5) NOT NULL, PRIMARY KEY (typeid) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3; INSERT INTO my_member_docutype VALUES ('1','商家资讯','1','2','1'); INSERT INTO my_member_docutype VALUES ('2','优惠促销','2','2','2'); DROP TABLE IF EXISTS my_member_level; CREATE TABLE my_member_level ( id tinyint(5) NOT NULL AUTO_INCREMENT, levelname varchar(30) NOT NULL, ifsystem tinyint(1) NOT NULL, purviews varchar(250) NOT NULL, money_own mediumint(8) NOT NULL, perday_maxpost smallint(5) NOT NULL, info_maxpost smallint(5) NOT NULL, article_maxpost int(10) NOT NULL, album_maxpost int(10) NOT NULL, allow_tpl mediumtext NOT NULL, member_contact tinyint(1) NOT NULL DEFAULT '1', signin_notice tinyint(1) NOT NULL DEFAULT '0', signin_del tinyint(1) NOT NULL DEFAULT '1', signin_view tinyint(1) NOT NULL DEFAULT '1', moneysettings varchar(250) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4; INSERT INTO my_member_level VALUES ('1','新手上路','1','purview_info,purview_pay,purview_avatar,purview_shoucang,purview_base,purview_certify,purview_pm,purview_levelup,purview_password,purview_shop,purview_comment,purview_album,purview_document,purview_banner','5','5','0','0','0','blue,orange,green,purple,pink','1','0','0','0','N;'); INSERT INTO my_member_level VALUES ('2','普通会员','1','purview_info,purview_pay,purview_avatar,purview_shoucang,purview_base,purview_certify,purview_pm,purview_levelup,purview_password,purview_shop,purview_comment,purview_album,purview_document,purview_goods,purview_banner','0','100','0','0','0','blue,orange,green,purple,pink','1','0','0','0','a:2:{s:6:\"ifopen\";a:3:{s:5:\"month\";s:1:\"1\";s:8:\"halfyear\";s:1:\"1\";s:7:\"forever\";s:1:\"1\";}s:5:\"money\";a:4:{s:5:\"month\";s:5:\"20000\";s:8:\"halfyear\";s:6:\"300000\";s:4:\"year\";s:7:\"1000000\";s:7:\"forever\";s:7:\"2000000\";}}'); INSERT INTO my_member_level VALUES ('3','黄金会员','0','purview_info,purview_pay,purview_avatar,purview_shoucang,purview_base,purview_certify,purview_pm,purview_levelup,purview_password,purview_shop,purview_comment,purview_album,purview_document,purview_coupon,purview_group,purview_goods,purview_banner','0','100','0','0','0','blue,orange,green,purple,pink','1','0','0','0','a:2:{s:6:\"ifopen\";a:4:{s:5:\"month\";s:1:\"1\";s:8:\"halfyear\";s:1:\"1\";s:4:\"year\";s:1:\"1\";s:7:\"forever\";s:1:\"1\";}s:5:\"money\";a:4:{s:5:\"month\";s:1:\"1\";s:8:\"halfyear\";s:1:\"2\";s:4:\"year\";s:1:\"3\";s:7:\"forever\";s:1:\"4\";}}'); DROP TABLE IF EXISTS my_member_pm; CREATE TABLE my_member_pm ( id smallint(5) unsigned NOT NULL AUTO_INCREMENT, fromuser varchar(50) NOT NULL, touser varchar(50) NOT NULL, pubtime int(10) unsigned NOT NULL DEFAULT '0', retime int(10) NOT NULL, title varchar(250) NOT NULL, retitle varchar(250) NOT NULL, content mediumtext, recontent mediumtext NOT NULL, if_read tinyint(1) NOT NULL DEFAULT '0', if_sys tinyint(1) NOT NULL, if_del tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY fromuser (fromuser), KEY touser (touser) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_member_record_login; CREATE TABLE my_member_record_login ( id int(11) unsigned NOT NULL AUTO_INCREMENT, userid char(32) NOT NULL, userpwd char(30) NOT NULL, pubdate int(10) NOT NULL, ip varchar(20) NOT NULL, ip2area varchar(32) NOT NULL, browser varchar(20) NOT NULL, `port` varchar(20) NOT NULL, os varchar(20) NOT NULL, outdate int(10) NOT NULL, result tinyint(1) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_member_record_use; CREATE TABLE my_member_record_use ( id int(8) NOT NULL AUTO_INCREMENT, userid char(50) NOT NULL, paycost char(50) NOT NULL, `subject` varchar(255) NOT NULL, pubtime int(10) NOT NULL, PRIMARY KEY (id), KEY userid (userid), KEY pubtime (pubtime) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_member_tpl; CREATE TABLE my_member_tpl ( id smallint(3) NOT NULL AUTO_INCREMENT, if_view tinyint(1) NOT NULL DEFAULT '2', tpl_name varchar(250) NOT NULL, tpl_path varchar(250) NOT NULL, displayorder int(5) NOT NULL, edittime int(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 AUTO_INCREMENT=8; INSERT INTO my_member_tpl VALUES ('1','2','蓝色主题','blue','1','1273410326'); INSERT INTO my_member_tpl VALUES ('2','2','橙红主题','orange','2','1273410338'); INSERT INTO my_member_tpl VALUES ('4','2','绿色主题','green','4','1273410646'); INSERT INTO my_member_tpl VALUES ('6','2','紫色主题','purple','6','1466692165'); INSERT INTO my_member_tpl VALUES ('7','2','粉色主题','pink','7','1466692175'); DROP TABLE IF EXISTS my_member_wx; CREATE TABLE my_member_wx ( id int(10) NOT NULL AUTO_INCREMENT, actionkey varchar(50) NOT NULL, openid varchar(50) NOT NULL, userid varchar(20) NOT NULL, userpwd char(36) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_mobile_gg; CREATE TABLE my_mobile_gg ( id smallint(5) NOT NULL AUTO_INCREMENT, typeid tinyint(1) NOT NULL, image varchar(100) NOT NULL, url varchar(100) NOT NULL, words varchar(50) NOT NULL, pubdate int(11) NOT NULL, displayorder smallint(5) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AUTO_INCREMENT=7; INSERT INTO my_mobile_gg VALUES ('1','1','/attachment/mobile_gg/2.gif','#','智慧门店','1469676806','4'); INSERT INTO my_mobile_gg VALUES ('2','3','/attachment/mobile_gg/14696777801tuyl.jpg','index.php','加入我们','1469677780','2'); INSERT INTO my_mobile_gg VALUES ('3','1','/attachment/mobile_gg/1.gif','#','便民服务电话','1469677858','3'); INSERT INTO my_mobile_gg VALUES ('4','2','/attachment/mobile_gg/1469677887yuini.png','index.php','7天退换','1469677887','4'); INSERT INTO my_mobile_gg VALUES ('5','1','/attachment/mobile_gg/15522948106ma99.jpg','#','招募合伙人','1552294810','2'); INSERT INTO my_mobile_gg VALUES ('6','1','/attachment/mobile_gg/1552294827vaanv.jpg','#','梦想合伙人','1552294827','1'); DROP TABLE IF EXISTS my_mobile_nav; CREATE TABLE my_mobile_nav ( id smallint(5) NOT NULL AUTO_INCREMENT, title char(50) NOT NULL, url char(250) NOT NULL, color varchar(7) NOT NULL, ico varchar(200) NOT NULL, flag varchar(50) NOT NULL, target varchar(10) NOT NULL, isview tinyint(1) NOT NULL, displayorder int(5) NOT NULL, createtime int(10) NOT NULL, typeid tinyint(1) NOT NULL, PRIMARY KEY (id), KEY typeid (typeid,isview) ) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 AUTO_INCREMENT=56; INSERT INTO my_mobile_nav VALUES ('1','信息分类','index.php?mod=category','','','category','_self','2','2','1469520429','1'); INSERT INTO my_mobile_nav VALUES ('2','热点资讯','index.php?mod=news','','','news','_self','2','3','1469520458','1'); INSERT INTO my_mobile_nav VALUES ('3','商家店铺','index.php?mod=corp','','','corp','_self','2','4','1469520485','1'); INSERT INTO my_mobile_nav VALUES ('4','MayiCMS首页','index.php?mod=index','','','index','_self','2','1','1469521176','1'); INSERT INTO my_mobile_nav VALUES ('49','商务服务','index.php?mod=category&catid=189','','/template/default/images/index/icon_business.gif','','_self','2','11','0','2'); INSERT INTO my_mobile_nav VALUES ('48','教育培训','index.php?mod=category&catid=10','','/template/default/images/index/icon_edu.gif','','_self','2','10','0','2'); INSERT INTO my_mobile_nav VALUES ('47','生活服务','index.php?mod=category&catid=9','','/template/default/images/index/icon_life.gif','','_self','2','9','0','2'); INSERT INTO my_mobile_nav VALUES ('46','宠物','index.php?mod=category&catid=8','','/template/default/images/index/icon_pet.gif','','_self','2','8','0','2'); INSERT INTO my_mobile_nav VALUES ('45','交友活动','index.php?mod=category&catid=7','','/template/default/images/index/icon_love.gif','','_self','2','7','0','2'); INSERT INTO my_mobile_nav VALUES ('43','兼职招聘','index.php?mod=category&catid=5','','/template/default/images/index/icon_jzzhaopin.gif','','_self','2','5','0','2'); INSERT INTO my_mobile_nav VALUES ('44','求职简历','index.php?mod=category&catid=6','','/template/default/images/index/icon_jianli.gif','','_self','2','6','0','2'); INSERT INTO my_mobile_nav VALUES ('42','全职招聘','index.php?mod=category&catid=4','','/template/default/images/index/icon_zhaopin.gif','','_self','2','4','0','2'); INSERT INTO my_mobile_nav VALUES ('41','房屋租售','index.php?mod=category&catid=3','','/template/default/images/index/icon_fang.gif','','_self','2','3','0','2'); INSERT INTO my_mobile_nav VALUES ('40','车辆买卖','index.php?mod=category&catid=2','','/template/default/images/index/icon_che.gif','','_self','2','2','0','2'); INSERT INTO my_mobile_nav VALUES ('39','二手转让','index.php?mod=category&catid=1','','/template/default/images/index/icon_ershou.gif','','_self','2','1','0','2'); INSERT INTO my_mobile_nav VALUES ('54','商品展示','index.php?mod=goods','','/template/default/images/index/icon_goods.gif','','_self','2','14','1469545508','2'); INSERT INTO my_mobile_nav VALUES ('53','热点资讯','index.php?mod=news','','/template/default/images/index/icon_news.gif','','_self','2','13','1469545240','2'); INSERT INTO my_mobile_nav VALUES ('52','商家机构','index.php?mod=corp','','/template/default/images/index/icon_corp.gif','','_self','2','12','1469545077','2'); INSERT INTO my_mobile_nav VALUES ('55','商品展示','index.php?mod=goods','','','goods','_','2','5','1470070591','1'); DROP TABLE IF EXISTS my_navurl; CREATE TABLE my_navurl ( id smallint(5) unsigned NOT NULL AUTO_INCREMENT, url char(250) NOT NULL, color varchar(7) NOT NULL, flag varchar(50) NOT NULL, ico varchar(20) NOT NULL, target varchar(10) NOT NULL, title char(250) NOT NULL, typeid smallint(5) unsigned NOT NULL DEFAULT '0', isview smallint(1) NOT NULL DEFAULT '1', displayorder int(5) NOT NULL, createtime int(10) NOT NULL, PRIMARY KEY (id), KEY typeid (typeid) ) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 AUTO_INCREMENT=62; INSERT INTO my_navurl VALUES ('58','http://7891000.com/group.php','','group','','_self','团购','3','2','13','0'); INSERT INTO my_navurl VALUES ('57','http://7891000.com/coupon.php','','coupon','','_self','优惠券','3','2','12','0'); INSERT INTO my_navurl VALUES ('56','http://7891000.com/category.php?catid=189','','189','','_self','商务服务','3','2','11','0'); INSERT INTO my_navurl VALUES ('55','http://7891000.com/category.php?catid=10','','10','','_self','教育培训','3','2','10','0'); INSERT INTO my_navurl VALUES ('53','http://7891000.com/category.php?catid=8','','8','','_self','宠物','3','2','8','0'); INSERT INTO my_navurl VALUES ('54','http://7891000.com/category.php?catid=9','','9','','_self','生活服务','3','2','9','0'); INSERT INTO my_navurl VALUES ('52','http://7891000.com/category.php?catid=7','','7','','_self','交友活动','3','2','7','0'); INSERT INTO my_navurl VALUES ('51','http://7891000.com/category.php?catid=6','','6','','_self','求职简历','3','2','6','0'); INSERT INTO my_navurl VALUES ('43','/about.php?part=friendlink','','friendlink','','_blank','友情链接','2','2','5','1568216835'); INSERT INTO my_navurl VALUES ('42','/about.php?part=faq','','faq','','_blank','网站帮助','2','2','4','1568216835'); INSERT INTO my_navurl VALUES ('41','/about.php?part=aboutus&id=3','','2','','_blank','联系我们','2','2','3','1568216835'); INSERT INTO my_navurl VALUES ('40','/about.php?part=aboutus&id=2','','1','','_blank','广告服务','2','2','2','1568216835'); INSERT INTO my_navurl VALUES ('39','/about.php?part=aboutus&id=1','','0','','_blank','网站简介','2','2','1','1568216835'); INSERT INTO my_navurl VALUES ('59','/news.php','','news','','_self','资讯','3','2','14','0'); INSERT INTO my_navurl VALUES ('50','http://7891000.com/category.php?catid=5','','5','','_self','兼职招聘','3','2','5','0'); INSERT INTO my_navurl VALUES ('49','http://7891000.com/category.php?catid=4','','4','','_self','全职招聘','3','2','4','0'); INSERT INTO my_navurl VALUES ('48','http://7891000.com/category.php?catid=3','','3','','_self','房屋租售','3','2','3','0'); INSERT INTO my_navurl VALUES ('47','http://7891000.com/category.php?catid=2','','2','','_self','车辆买卖','3','2','2','0'); INSERT INTO my_navurl VALUES ('46','http://7891000.com/category.php?catid=1','','1','','_self','二手转让','3','2','1','0'); INSERT INTO my_navurl VALUES ('44','/about.php?part=announce','','annnounce','','_blank','网站公告','2','2','6','1568216835'); INSERT INTO my_navurl VALUES ('45','/about.php?part=sitemap','','sitemap','','_blank','网站地图','2','2','7','1568216835'); INSERT INTO my_navurl VALUES ('60','http://7891000.com/goods.php','','goods','','_self','商品','3','2','15','0'); INSERT INTO my_navurl VALUES ('61','/corporation.php','','corp','','_self','店铺','3','2','16','0'); DROP TABLE IF EXISTS my_news; CREATE TABLE my_news ( id int(10) NOT NULL AUTO_INCREMENT, iscommend tinyint(1) NOT NULL DEFAULT '1', isfocus varchar(10) NOT NULL, isbold tinyint(1) NOT NULL DEFAULT '0', isjump tinyint(1) NOT NULL DEFAULT '0', redirect_url varchar(250) NOT NULL, title varchar(30) NOT NULL, keywords varchar(250) NOT NULL, catid int(8) NOT NULL, begintime int(11) NOT NULL, introduction mediumtext NOT NULL, content mediumtext NOT NULL, author varchar(30) NOT NULL, `source` varchar(100) NOT NULL, hit int(10) NOT NULL DEFAULT '0', perhit int(10) NOT NULL DEFAULT '1', imgpath varchar(100) NOT NULL DEFAULT '0', html_path varchar(100) NOT NULL, PRIMARY KEY (id), KEY catid (catid), KEY imgpath (imgpath), KEY begintime (begintime), KEY hit (hit) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_payapi; CREATE TABLE my_payapi ( payid smallint(6) NOT NULL AUTO_INCREMENT, paytype varchar(20) NOT NULL DEFAULT '', buytype tinyint(1) NOT NULL DEFAULT '1', myorder tinyint(4) NOT NULL DEFAULT '0', payfee varchar(10) NOT NULL DEFAULT '', payuser varchar(60) NOT NULL DEFAULT '', partner varchar(60) NOT NULL DEFAULT '', paykey varchar(120) NOT NULL DEFAULT '', appid varchar(60) NOT NULL, appkey varchar(60) NOT NULL, paylogo varchar(200) NOT NULL DEFAULT '', paysay mediumtext NOT NULL, payname varchar(120) NOT NULL DEFAULT '', isclose tinyint(1) NOT NULL DEFAULT '0', payemail varchar(120) NOT NULL DEFAULT '', PRIMARY KEY (payid), UNIQUE KEY paytype (paytype) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 AUTO_INCREMENT=8; INSERT INTO my_payapi VALUES ('1','tenpay','0','0','','','','','','','',' 财付通（www.tenpay.com）-腾讯旗下在线支付平台，通过国家权威安全认证，支持各大银行网上支付。 ','财付通','1',''); INSERT INTO my_payapi VALUES ('2','chinabank','0','1','','','','','','','',' 网银在线与中国工商银行、招商银行、中国建设银行、农业银行、民生银行等数十家金融机构达成协议。全面支持全国19家银行的信用卡及借记卡实现网上支付。（网址：http://www.chinabank.com.cn） ','网银在线','1',''); INSERT INTO my_payapi VALUES ('3','alipay','1','0','','','','','','','','支付宝网站(www.alipay.com) 是国内先进的网上支付平台。','支付宝接口','0',''); INSERT INTO my_payapi VALUES ('4','alipay_h5','0','0','','','','','','','',' 支付宝手机网站支付 ','支付宝手机接口','0',''); INSERT INTO my_payapi VALUES ('5','wxpay','0','0','','','','','','','',' 微信端手机支付 ','微信公众号支付','0',''); INSERT INTO my_payapi VALUES ('6','wxnative','0','0','','','','','','','','微信电脑端扫码支付 ','微信扫码支付','0',''); INSERT INTO my_payapi VALUES ('7','wxh5','0','0','','','','','','','','手机普通浏览器H5端 - 微信支付','微信H5手机支付','0',''); DROP TABLE IF EXISTS my_payrecord; CREATE TABLE my_payrecord ( id int(11) NOT NULL AUTO_INCREMENT, uid int(11) NOT NULL DEFAULT '0', userid varchar(30) NOT NULL, orderid varchar(50) NOT NULL DEFAULT '', money varchar(20) NOT NULL DEFAULT '', ifadd tinyint(1) NOT NULL DEFAULT '0', paybz varchar(10) NOT NULL, `type` varchar(100) NOT NULL DEFAULT '', payip varchar(20) NOT NULL DEFAULT '', posttime int(10) NOT NULL, PRIMARY KEY (id), KEY userid (uid,orderid), KEY posttime (posttime), KEY orderid (orderid), KEY ifadd (ifadd), KEY ifadd_2 (ifadd), KEY orderid_2 (orderid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_plugin; CREATE TABLE my_plugin ( id smallint(5) unsigned NOT NULL AUTO_INCREMENT, flag varchar(30) NOT NULL DEFAULT '', iscore tinyint(1) NOT NULL DEFAULT '0', `name` varchar(60) NOT NULL DEFAULT '', `directory` varchar(100) NOT NULL DEFAULT '', `disable` tinyint(1) unsigned NOT NULL DEFAULT '0', config mediumtext NOT NULL, version varchar(60) NOT NULL DEFAULT '', releasetime int(10) NOT NULL, author varchar(255) NOT NULL DEFAULT '', introduce mediumtext NOT NULL, siteurl varchar(255) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', copyright varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 AUTO_INCREMENT=14; INSERT INTO my_plugin VALUES ('1','coupon','0','优惠券','coupon','1','a:4:{s:8:\"seotitle\";s:10:\"优惠券标题\";s:11:\"seokeywords\";s:12:\"优惠券关键词\";s:14:\"seodescription\";s:10:\"优惠券描述\";s:9:\"adminmenu\";s:60:\"优惠券分类=coupon_category.php\r\n已上传优惠券=coupon_list.php\";}','1.0','1278232105','steven','商铺优惠券插件','https://www.mayicms.com','business@live.it','Mymps Dev.'); INSERT INTO my_plugin VALUES ('3','news','0','资讯','-','0','a:4:{s:8:\"seotitle\";s:0:\"\";s:11:\"seokeywords\";s:8:\"热点资讯\";s:14:\"seodescription\";s:8:\"热点资讯\";s:9:\"adminmenu\";s:66:\"新闻管理=news.php\r\n新闻类别=channel.php\r\n新闻评论=news_comment.php\";}','2.0','1278232105','steven','网站新闻插件','https://www.mayicms.com','business@live.it','MyDev.'); INSERT INTO my_plugin VALUES ('4','goods','0','商品','goods','0','a:7:{s:8:\"seotitle\";s:0:\"\";s:11:\"seokeywords\";s:8:\"网上商城\";s:14:\"seodescription\";s:8:\"网上商城\";s:9:\"adminmenu\";s:78:\"商品分类=goods_category.php\r\n商品管理=goods_list.php\r\n订单管理=goods_order.php\";s:5:\"quhuo\";s:555:\"1.普通快递送货上门 \r\n 覆盖全国800多个城市，运费5元/包裹\r\n2.加急快递送货上门 \r\n 支持北京、天津、上海、广州、深圳、廊坊，限当地发货订单，运费10元/包裹 \r\n3.圆通快递 \r\n 北京地区：运费10元/单 \r\n4.普通邮递 \r\n 大陆地区：运费5元/包裹，购物满29元免运费 \r\n 港澳地区：运费为商品原价总金额的30%，最低20元 \r\n 海外地区：运费为商品原价总金额的50%，最低50元 \r\n5.邮政特快专递(EMS) \r\n 北京地区：运费为订单总金额的20%，最低16元 \r\n 大陆其它地区：运费为订单总金额的40%，最低20元 \r\n 港澳台地区：运费为订单总金额的50%，最低45元 \r\n6.自提 \r\n 支持用户上门自提，免收运费。\";s:6:\"fukuan\";s:150:\"当面付款\r\n店内交易、送货上门、预约交易均可当面付款\r\n\r\n银行转账\r\n可通银行转账方式将款汇款到指定账号中\r\n\r\n网上汇款\r\n可通网上转账方式将款汇款到指定账号中\";s:7:\"service\";s:1240:\"售后服务参考条文：\r\n1、如果您购买的是数码类、手机及配件、笔记本、台式机、家电类商品，为了保证您能充分享有生产厂家提供的售后保修服务，不管您是否需要开具发票，我们都将随单为您开具，发票内容默认为您订购的商品全称，同时不支持修改发票内容。如果因为所开具的发票内容和所购商品名称不符，导致无法保修，本站概不负责。\r\n \r\n2、退货时提供发票原件，超1000元现金支付的订单办理退货将不退现金。\r\n \r\n3、数码类、手机及配件、笔记本、台式机、家电、打印机、扫描仪、一体机、车载GPS类商品，如果商品出现质量问题，请您自行到生产厂家售后服务中心进行检测，并开据检测报告（对于有些生产厂家售后服务中心无法提供检测报告的，需提供维修检验单据），如果检测报告确认属于质量问题，然后将检测报告、问题商品及完整包装附件，一并返回我司办理退换货手续。如有破损或丢失，我们将无法为您办理。\r\n \r\n4、对于钻石、黄金、手表、珠宝首饰及个人配饰类产品，如果附带国家级宝玉石鉴定中心出具的鉴定证书的、非质量问题不予以退换货。客户在收到商品之日起（以发票日期为准）3个月内，如果出现质量问题，请自行到当地的质量监督部门-珠宝玉石质量检验中心进行检测，如果检测报告确认属于质量问题，请与本站售后服务部联系办理退换货事宜。退换货时，请您务必将检测报告、商品的外包装、内带附件、鉴定证书、说明书等随同商品一起退回。如有包装破损或缺失，扣除该商品5%的折价费；如有附件破损或缺失扣除该商品10-15%的折价费。\";}','1.0','1309753960','steven','商品插件','https://www.mayicms.com','business@live.it','MyDev.'); INSERT INTO my_plugin VALUES ('13','group','0','团购','group','0','a:4:{s:8:\"seotitle\";s:12:\"团购活动标题\";s:11:\"seokeywords\";s:14:\"团购活动关键词\";s:14:\"seodescription\";s:12:\"团购活动描述\";s:9:\"adminmenu\";s:81:\"团购分类=group_category.php\r\n已发起团购=group_list.php\r\n报名管理=group_signin.php\";}','1.0','1278232105','steven','团购活动插件','https://www.mayicms.com','business@live.it','MyDev.'); DROP TABLE IF EXISTS my_shoucang; CREATE TABLE my_shoucang ( id int(10) NOT NULL AUTO_INCREMENT, infoid int(10) NOT NULL, title varchar(30) NOT NULL, url varchar(100) NOT NULL, userid varchar(30) NOT NULL, intime int(11) NOT NULL, PRIMARY KEY (id), KEY userid (userid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_sms_sendlist; CREATE TABLE my_sms_sendlist ( id int(10) NOT NULL AUTO_INCREMENT, mobile varchar(20) NOT NULL, `status` varchar(100) NOT NULL, sendtime int(10) NOT NULL, sms_service char(30) NOT NULL, sms_content varchar(250) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_telephone; CREATE TABLE my_telephone ( id smallint(3) NOT NULL AUTO_INCREMENT, telname varchar(50) NOT NULL, telnumber varchar(50) NOT NULL, color char(10) NOT NULL, if_bold tinyint(1) NOT NULL DEFAULT '0', displayorder smallint(5) NOT NULL, if_view tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (id), KEY displayorder (displayorder) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS my_template; CREATE TABLE my_template ( filepath varchar(250) NOT NULL, content longtext NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS my_upload; CREATE TABLE my_upload ( id int(11) NOT NULL AUTO_INCREMENT, title varchar(100) NOT NULL DEFAULT '', url varchar(100) NOT NULL DEFAULT '', width varchar(10) NOT NULL DEFAULT '', height varchar(10) NOT NULL DEFAULT '', playtime varchar(10) NOT NULL DEFAULT '', filesize int(11) NOT NULL DEFAULT '0', newsid int(11) NOT NULL DEFAULT '0', uptime int(11) NOT NULL DEFAULT '0', adminid int(11) NOT NULL DEFAULT '0', memberid int(11) NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY memberid (memberid,filesize,newsid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;