给发短消息：
最近玩过的游戏cxkjq是不是骗子?_百度知道
cxkjq是不是骗子?
我有更好的答案
卡不能刷外币了
为您推荐：
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。本页链接：
第1个回答:
也有人要让他
不能刷外了
猜你感兴趣项目语言:PHP
权限:read-only(如需更高权限请先加入项目)
Index: _bbWkeshw/volume-1.sql
===================================================================
--- _bbWkeshw/volume-1.sql (revision 0)
+++ _bbWkeshw/volume-1.sql (revision 2)
@@ -0,0 +1,2594 @@
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_activity` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(11) unsigned DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`ac_pic` varchar(100) NOT NULL,
`begintime` int(11) unsigned DEFAULT NULL,
`endtime` int(11) unsigned DEFAULT NULL,
`createtime` int(11) unsigned DEFAULT NULL,
`countlimit` int(5) NOT NULL,
`countvirtual` int(5) DEFAULT '0',
`visitsCount` int(11) DEFAULT '0',
`ppt1` varchar(100) DEFAULT NULL,
`ppt2` varchar(100) DEFAULT NULL,
`ppt3` varchar(100) DEFAULT NULL,
`acdes` varchar(500) NOT NULL DEFAULT '',
`address` varchar(200) NOT NULL,
`location_p` varchar(100) NOT NULL COMMENT '所在地区_省',
`location_c` varchar(100) NOT NULL COMMENT '所在地区_市',
`location_a` varchar(100) NOT NULL COMMENT '所在地区_区',
`lng` decimal(18,10) NOT NULL DEFAULT '0.',
`lat` decimal(18,10) NOT NULL DEFAULT '0.',
`tel` varchar(20) DEFAULT NULL,
`email` varchar(20) DEFAULT NULL,
`zb` varchar(50) DEFAULT NULL,
`cb` varchar(50) DEFAULT NULL,
`xb` varchar(50) DEFAULT NULL,
`cjdx` varchar(50) DEFAULT NULL,
`hoteldesc` varchar(500) DEFAULT NULL,
`costdes` varchar(500) DEFAULT NULL,
`isrepeat` int(1) DEFAULT '0',
`istip` int(1) DEFAULT '0',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_activity_
+CREATE TABLE `ims_activity_day` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`aid` int(11) unsigned DEFAULT NULL,
`daytime` int(11) unsigned DEFAULT NULL,
`dname` varchar(20) DEFAULT NULL,
`ddes` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_activity_
+CREATE TABLE `ims_activity_guest` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`aid` int(11) unsigned DEFAULT NULL,
`gname` varchar(20) NOT NULL,
`jobtitle` varchar(20) NOT NULL,
`gdesc` varchar(500) NOT NULL,
`sig` varchar(20) NOT NULL,
`headimage` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='嘉宾';
+DROP TABLE IF EXISTS ims_activity_
+CREATE TABLE `ims_activity_mail` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(100) NOT NULL,
`weid` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_activity_
+CREATE TABLE `ims_activity_note` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`aid` int(11) unsigned DEFAULT NULL,
`title` varchar(50) NOT NULL,
`ndesc` varchar(500) DEFAULT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_activity_
+CREATE TABLE `ims_activity_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rid` int(10) unsigned NOT NULL DEFAULT '0',
`aid` int(10) unsigned NOT NULL,
`new_pic` varchar(200) NOT NULL,
`news_content` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_rid` (`rid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_activity_
+CREATE TABLE `ims_activity_user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`aid` int(11) unsigned DEFAULT NULL,
`createtime` int(11) unsigned DEFAULT NULL,
`uname` varchar(20) DEFAULT NULL,
`sex` varchar(10) NOT NULL,
`tel` varchar(20) NOT NULL,
`email` varchar(20) NOT NULL,
`company` varchar(20) NOT NULL,
`jobtitle` varchar(20) NOT NULL,
`acname` varchar(50) DEFAULT NULL,
`openid` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_album` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`title` varchar(50) NOT NULL DEFAULT '',
`thumb` varchar(100) NOT NULL DEFAULT '',
`content` varchar(1000) NOT NULL DEFAULT '',
`displayorder` int(10) unsigned NOT NULL DEFAULT '0',
`isview` tinyint(1) unsigned NOT NULL DEFAULT '1',
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_album_
+CREATE TABLE `ims_album_photo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`albumid` int(10) unsigned NOT NULL,
`title` varchar(100) NOT NULL DEFAULT '',
`description` varchar(1000) NOT NULL DEFAULT '',
`attachment` varchar(100) NOT NULL DEFAULT '',
`ispreview` tinyint(1) unsigned NOT NULL DEFAULT '0',
`displayorder` int(10) unsigned NOT NULL DEFAULT '0',
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_albumid` (`albumid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_album_
+CREATE TABLE `ims_album_reply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rid` int(11) NOT NULL,
`albumid` int(11) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_app_upgrade_
+CREATE TABLE `ims_app_upgrade_log` (
`logid` int(11) NOT NULL AUTO_INCREMENT,
`id` int(11) NOT NULL,
`url` varchar(10240) NOT NULL,
`createtime` int(11) NOT NULL,
PRIMARY KEY (`logid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_article` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`iscommend` tinyint(1) NOT NULL DEFAULT '0',
`ishot` tinyint(1) unsigned NOT NULL DEFAULT '0',
`pcate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '一级分类',
`ccate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '二级分类',
`template` varchar(300) NOT NULL DEFAULT '' COMMENT '内容模板',
`title` varchar(100) NOT NULL DEFAULT '',
`description` varchar(100) NOT NULL DEFAULT '',
`content` text NOT NULL,
`thumb` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图',
`source` varchar(50) NOT NULL DEFAULT '' COMMENT '来源',
`author` varchar(50) NOT NULL COMMENT '作者',
`displayorder` int(10) unsigned NOT NULL DEFAULT '0',
`linkurl` varchar(500) NOT NULL DEFAULT '',
`createtime` int(10) unsigned NOT NULL DEFAULT '0',
`isreviewed` int(4) NOT NULL COMMENT '是否审核',
PRIMARY KEY (`id`),
KEY `idx_iscommend` (`iscommend`),
KEY `idx_ishot` (`ishot`)
+) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+INSERT INTO ims_article VALUES
+('1','2','0','0','0','0','','图文回复测试','简介','&p&这里是正文&/p&','images/2/2015/06/TxXxGHrkkYH3PyXLr03u3k2EYGc6NJ.jpg','','','0','http://baidu.com ','','0');
+DROP TABLE IF EXISTS ims_article_
+CREATE TABLE `ims_article_badwords` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`word` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+INSERT INTO ims_article_badwords VALUES
+('1','敏感词1'),
+('2','fuck'),
+('4','stupy');
+DROP TABLE IF EXISTS ims_article_
+CREATE TABLE `ims_article_category` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属帐号',
`nid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联导航id',
`name` varchar(50) NOT NULL COMMENT '分类名称',
`parentid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID,0为第一级',
`displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否开启',
`icontype` tinyint(1) unsigned NOT NULL,
`icon` varchar(100) NOT NULL DEFAULT '' COMMENT '分类图标',
`css` varchar(500) NOT NULL,
`description` varchar(100) NOT NULL DEFAULT '' COMMENT '分类描述',
`template` varchar(300) NOT NULL DEFAULT '' COMMENT '分类模板',
`templatefile` varchar(100) NOT NULL DEFAULT '',
`linkurl` varchar(500) NOT NULL DEFAULT '',
`ishomepage` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_article_
+CREATE TABLE `ims_article_reply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rid` int(11) NOT NULL,
`articleid` int(11) NOT NULL,
`isfill` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_attachment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`uid` int(10) unsigned NOT NULL,
`filename` varchar(255) NOT NULL,
`attachment` varchar(255) NOT NULL,
`type` tinyint(3) unsigned NOT NULL COMMENT '1为图片',
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=279 DEFAULT CHARSET=utf8;
+INSERT INTO ims_attachment VALUES
+('278','2','1','qrcode_28.jpg','/images/2/2015/06/TxXxGHrkkYH3PyXLr03u3k2EYGc6NJ.jpg','1','');
+DROP TABLE IF EXISTS ims_award_
+CREATE TABLE `ims_award_list` (
`award_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`title` varchar(50) NOT NULL,
`logo` varchar(255) NOT NULL,
`amount` int(11) NOT NULL DEFAULT '0',
`deadline` datetime NOT NULL,
`credit_cost` int(11) NOT NULL DEFAULT '0',
`price` int(11) NOT NULL DEFAULT '100',
`content` text NOT NULL,
`createtime` int(10) NOT NULL,
PRIMARY KEY (`award_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_basic_
+CREATE TABLE `ims_basic_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rid` int(10) unsigned NOT NULL DEFAULT '0',
`content` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
+INSERT INTO ims_basic_reply VALUES
+('7','82','哇卡卡阿卡卡'),
+('8','84','第四方接口');
+DROP TABLE IF EXISTS ims_bigpan_
+CREATE TABLE `ims_bigpan_award` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rid` int(10) unsigned NOT NULL COMMENT '规则ID',
`level` int(2) NOT NULL COMMENT '奖品等级',
`title` varchar(50) NOT NULL COMMENT '奖品名称',
`total` int(11) NOT NULL COMMENT '数量',
`probalilty` varchar(5) NOT NULL COMMENT '概率单位%',
`description` varchar(100) NOT NULL DEFAULT '' COMMENT '描述',
`inkind` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否是实物',
`activation_code` varchar(2000) NOT NULL COMMENT '激活码',
`activation_url` varchar(200) NOT NULL COMMENT '激活地址',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_bigpan_
+CREATE TABLE `ims_bigpan_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rid` int(10) unsigned NOT NULL COMMENT '规则ID',
`picture` varchar(100) NOT NULL COMMENT '活动图片',
`thumb` varchar(100) NOT NULL,
`zppic` varchar(100) NOT NULL,
`lostdeg` varchar(100) NOT NULL,
`prizedeg` varchar(100) NOT NULL,
`description` varchar(100) NOT NULL COMMENT '活动描述',
`rule` varchar(1000) NOT NULL COMMENT '规则',
`maxlottery` tinyint(3) unsigned NOT NULL COMMENT '最大抽奖数',
`default_tips` varchar(100) NOT NULL COMMENT '默认提示信息',
`hitcredit` int(11) NOT NULL COMMENT '中奖奖励积分',
`misscredit` int(11) NOT NULL COMMENT '未中奖奖励积分',
`end` int(11) NOT NULL DEFAULT '0' COMMENT '结束时间',
`start` int(11) NOT NULL DEFAULT '0' COMMENT '开始时间',
`weid` tinyint(10) NOT NULL DEFAULT '0' COMMENT '公众号ID',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_bigpan_
+CREATE TABLE `ims_bigpan_winner` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rid` int(10) unsigned NOT NULL COMMENT '规则ID',
`aid` int(10) unsigned NOT NULL COMMENT '奖品ID',
`award` varchar(100) NOT NULL DEFAULT '' COMMENT '奖品名称',
`description` varchar(500) NOT NULL DEFAULT '' COMMENT '中奖信息描述',
`from_user` varchar(50) NOT NULL COMMENT '用户唯一身份ID',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未领奖，1不需要领奖，2已领奖',
`createtime` int(10) unsigned NOT NULL COMMENT '获奖日期',
PRIMARY KEY (`id`),
KEY `idx_from_user` (`from_user`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_bigwheel_
+CREATE TABLE `ims_bigwheel_award` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) DEFAULT '0',
`rid` int(11) DEFAULT '0',
`fansID` int(11) DEFAULT '0',
`from_user` varchar(50) DEFAULT '0' COMMENT '用户ID',
`name` varchar(50) DEFAULT '' COMMENT '名称',
`description` varchar(200) DEFAULT '' COMMENT '描述',
`prizetype` varchar(10) DEFAULT '' COMMENT '类型',
`award_sn` varchar(50) DEFAULT '' COMMENT 'SN',
`createtime` int(10) DEFAULT '0',
`consumetime` int(10) DEFAULT '0',
`status` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `indx_rid` (`rid`),
KEY `indx_weid` (`weid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_bigwheel_
+CREATE TABLE `ims_bigwheel_fans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rid` int(11) DEFAULT '0',
`fansID` int(11) DEFAULT '0',
`from_user` varchar(50) DEFAULT '' COMMENT '用户ID',
`tel` varchar(20) DEFAULT '' COMMENT '登记信息(手机等)',
`todaynum` int(11) DEFAULT '0',
`totalnum` int(11) DEFAULT '0',
`awardnum` int(11) DEFAULT '0',
`last_time` int(10) DEFAULT '0',
`createtime` int(10) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `indx_rid` (`rid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_bigwheel_
+CREATE TABLE `ims_bigwheel_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rid` int(10) unsigned DEFAULT '0',
`weid` int(11) DEFAULT '0',
`title` varchar(50) DEFAULT '',
`description` varchar(255) DEFAULT '',
`content` varchar(200) DEFAULT '',
`start_picurl` varchar(200) DEFAULT '',
`isshow` tinyint(1) DEFAULT '0',
`ticket_information` varchar(200) DEFAULT '',
`starttime` int(10) DEFAULT '0',
`endtime` int(10) DEFAULT '0',
`repeat_lottery_reply` varchar(50) DEFAULT '',
`end_theme` varchar(50) DEFAULT '',
`end_instruction` varchar(200) DEFAULT '',
`end_picurl` varchar(200) DEFAULT '',
`c_type_one` varchar(20) DEFAULT '',
`c_name_one` varchar(50) DEFAULT '',
`c_num_one` int(11) DEFAULT '0',
`c_draw_one` int(11) DEFAULT '0',
`c_rate_one` double DEFAULT '0',
`c_type_two` varchar(20) DEFAULT '',
`c_name_two` varchar(50) DEFAULT '',
`c_num_two` int(11) DEFAULT '0',
`c_draw_two` int(11) DEFAULT '0',
`c_rate_two` double DEFAULT '0',
`c_type_three` varchar(20) DEFAULT '',
`c_name_three` varchar(50) DEFAULT '',
`c_num_three` int(11) DEFAULT '0',
`c_draw_three` int(11) DEFAULT '0',
`c_rate_three` double DEFAULT '0',
`c_type_four` varchar(20) DEFAULT '',
`c_name_four` varchar(50) DEFAULT '',
`c_num_four` int(11) DEFAULT '0',
`c_draw_four` int(11) DEFAULT '0',
`c_rate_four` double DEFAULT '0',
`c_type_five` varchar(20) DEFAULT '',
`c_name_five` varchar(50) DEFAULT '',
`c_num_five` int(11) DEFAULT '0',
`c_draw_five` int(11) DEFAULT '0',
`c_rate_five` double DEFAULT '0',
`c_type_six` varchar(20) DEFAULT '',
`c_name_six` varchar(50) DEFAULT '',
`c_num_six` int(11) DEFAULT '0',
`c_draw_six` int(10) DEFAULT '0',
`c_rate_six` double DEFAULT '0',
`total_num` int(11) DEFAULT '0' COMMENT '总获奖人数(自动加)',
`probability` double DEFAULT '0',
`award_times` int(11) DEFAULT '0',
`number_times` int(11) DEFAULT '0',
`most_num_times` int(11) DEFAULT '0',
`sn_code` tinyint(4) DEFAULT '0',
`sn_rename` varchar(20) DEFAULT '',
`tel_rename` varchar(20) DEFAULT '',
`copyright` varchar(20) DEFAULT '',
`show_num` tinyint(2) DEFAULT '0',
`viewnum` int(11) DEFAULT '0',
`fansnum` int(11) DEFAULT '0',
`createtime` int(10) DEFAULT '0',
`share_title` varchar(200) DEFAULT '',
`share_desc` varchar(300) DEFAULT '',
`share_url` varchar(100) DEFAULT '',
`share_txt` text NOT NULL,
PRIMARY KEY (`id`),
KEY `indx_rid` (`rid`),
KEY `indx_weid` (`weid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_bm_marry_
+CREATE TABLE `ims_bm_marry_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`weid` bigint(20) DEFAULT NULL,
`fromuser` varchar(32) DEFAULT NULL,
`sid` bigint(20) DEFAULT NULL COMMENT 'micro_xitie_set id',
`name` varchar(25) DEFAULT NULL,
`tel` varchar(25) DEFAULT NULL,
`rs` smallint(1) DEFAULT NULL COMMENT '赴宴人数',
`zhufu` varchar(255) DEFAULT NULL COMMENT '收到祝福',
`ctime` datetime DEFAULT NULL,
`type` tinyint(1) DEFAULT '1' COMMENT '1:赴宴 2：祝福',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COMMENT='微喜帖信息列表';
+DROP TABLE IF EXISTS ims_bm_marry_
+CREATE TABLE `ims_bm_marry_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) DEFAULT NULL,
`title` varchar(50) DEFAULT NULL,
`art_pic` varchar(255) DEFAULT NULL,
`donghua_pic` varchar(255) DEFAULT NULL,
`suolue_pic` varchar(255) DEFAULT NULL COMMENT '缩略图',
`xl_name` varchar(255) DEFAULT NULL,
`xn_name` varchar(255) DEFAULT NULL,
`is_front` varchar(255) DEFAULT '1' COMMENT '1:新郎名字在前 2:新娘名字在前',
`tel` varchar(25) DEFAULT NULL,
`hy_time` datetime DEFAULT NULL COMMENT '婚宴日期',
`dist` varchar(20) DEFAULT NULL,
`city` varchar(20) DEFAULT NULL,
`province` varchar(20) DEFAULT NULL,
`hy_addr` varchar(255) DEFAULT NULL COMMENT '婚宴地址',
`jw_addr` varchar(255) DEFAULT NULL COMMENT '经纬地址',
`lng` varchar(12) DEFAULT '116.;,
`lat` varchar(12) DEFAULT '39.;,
`video` varchar(255) DEFAULT '/res/weiXiTie/mp4.mp4',
`music` varchar(255) DEFAULT '/res/weiXiTie/youGotMe.mp3',
`hs_pic` text COMMENT '婚纱图片',
`pwd` varchar(255) DEFAULT NULL,
`word` varchar(500) DEFAULT NULL,
`erweima_pic` varchar(255) DEFAULT NULL COMMENT '二维码图片',
`copyright` varchar(60) DEFAULT NULL,
`createtime` int(11) DEFAULT NULL,
`traffic` varchar(255) DEFAULT NULL COMMENT '公共交通',
`first_pic` varchar(255) DEFAULT NULL COMMENT '幻灯片第一张',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='微喜帖设置';
+DROP TABLE IF EXISTS ims_bm_marry_
+CREATE TABLE `ims_bm_marry_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rid` int(10) unsigned NOT NULL DEFAULT '0',
`marryid` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_business` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`title` varchar(50) NOT NULL DEFAULT '',
`thumb` varchar(100) NOT NULL DEFAULT '',
`content` varchar(1000) NOT NULL DEFAULT '',
`phone` varchar(15) NOT NULL DEFAULT '',
`qq` varchar(15) NOT NULL DEFAULT '',
`province` varchar(50) NOT NULL DEFAULT '',
`city` varchar(50) NOT NULL DEFAULT '',
`dist` varchar(50) NOT NULL DEFAULT '',
`address` varchar(500) NOT NULL DEFAULT '',
`lng` varchar(10) NOT NULL DEFAULT '',
`lat` varchar(10) NOT NULL DEFAULT '',
`industry1` varchar(10) NOT NULL DEFAULT '',
`industry2` varchar(10) NOT NULL DEFAULT '',
`createtime` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_lat_lng` (`lng`,`lat`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_card` (
`id` int(10) unsigned NOT NULL,
`weid` int(10) unsigned NOT NULL,
`title` varchar(100) NOT NULL DEFAULT '',
`color` varchar(255) NOT NULL DEFAULT '',
`background` varchar(255) NOT NULL DEFAULT '',
`logo` varchar(255) NOT NULL DEFAULT '',
`format` varchar(50) NOT NULL DEFAULT '',
`fields` varchar(1000) NOT NULL DEFAULT '',
`snpos` int(11) NOT NULL DEFAULT '0'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_card_
+CREATE TABLE `ims_card_coupon` (
`id` int(10) unsigned NOT NULL,
`weid` int(10) unsigned NOT NULL,
`title` varchar(50) NOT NULL,
`starttime` int(10) NOT NULL DEFAULT '0',
`endtime` int(10) NOT NULL DEFAULT '0',
`type` tinyint(1) NOT NULL,
`pretotal` int(11) NOT NULL DEFAULT '1',
`total` int(11) NOT NULL DEFAULT '1',
`content` text NOT NULL,
`displayorder` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL,
`createtime` int(10) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_card_
+CREATE TABLE `ims_card_log` (
`id` int(11) NOT NULL,
`weid` int(10) unsigned NOT NULL,
`from_user` varchar(50) NOT NULL,
`type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1积分，2金额，3优惠券',
`content` varchar(255) NOT NULL DEFAULT '',
`createtime` int(10) unsigned NOT NULL DEFAULT '0'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_card_
+CREATE TABLE `ims_card_members` (
`id` int(10) unsigned NOT NULL,
`weid` int(10) unsigned NOT NULL,
`from_user` varchar(50) NOT NULL DEFAULT '',
`cardsn` varchar(20) NOT NULL DEFAULT '',
`credit1` varchar(15) NOT NULL DEFAULT '0',
`credit2` varchar(15) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL,
`createtime` int(10) unsigned NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_card_members_
+CREATE TABLE `ims_card_members_coupon` (
`id` int(10) unsigned NOT NULL,
`weid` int(10) unsigned NOT NULL,
`couponid` int(10) unsigned NOT NULL,
`from_user` varchar(50) NOT NULL,
`status` tinyint(1) NOT NULL COMMENT '1为正常状态，2为已使用',
`receiver` varchar(50) NOT NULL,
`consumetime` int(10) unsigned NOT NULL,
`createtime` int(10) unsigned NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_card_
+CREATE TABLE `ims_card_password` (
`id` int(10) unsigned NOT NULL,
`weid` int(10) unsigned NOT NULL,
`name` varchar(50) NOT NULL DEFAULT '',
`password` varchar(200) NOT NULL DEFAULT ''
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_admap` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) NOT NULL,
`regionid` int(11) NOT NULL,
`adid` int(11) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_advertisement` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`content` varchar(255) NOT NULL COMMENT '标题',
`url` varchar(255) NOT NULL COMMENT '外链或内链',
`createtime` int(10) unsigned NOT NULL COMMENT '创建时间',
`creator` varchar(50) NOT NULL,
`starttime` int(10) unsigned NOT NULL COMMENT '开始时间',
`endtime` int(10) unsigned NOT NULL COMMENT '截止时间',
`status` int(10) unsigned NOT NULL COMMENT '状态',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='广告';
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_announcement` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL COMMENT '公众号ID',
`regionid` int(10) unsigned NOT NULL COMMENT '小区编号',
`title` varchar(255) NOT NULL COMMENT '标题',
`content` text NOT NULL COMMENT '内容',
`author` varchar(50) NOT NULL COMMENT '作者',
`createtime` int(10) unsigned NOT NULL,
`starttime` int(11) unsigned NOT NULL COMMENT '开始时间',
`endtime` int(11) unsigned NOT NULL COMMENT '结束时间',
`status` tinyint(1) NOT NULL COMMENT '状态',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_express_
+CREATE TABLE `ims_community_express_company` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`code` varchar(50) NOT NULL,
`reg` varchar(255) NOT NULL,
`note` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`code`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='快递公司';
+DROP TABLE IF EXISTS ims_community_express_
+CREATE TABLE `ims_community_express_fee` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(11) NOT NULL,
`code` varchar(50) NOT NULL,
`province` varchar(50) NOT NULL,
`city` varchar(50) NOT NULL,
`district` varchar(50) NOT NULL,
`pricefirst` float NOT NULL COMMENT '首重金额',
`weightfirst` float NOT NULL COMMENT '首重',
`priceaddition` float NOT NULL COMMENT '续重金额',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='快递费用';
+DROP TABLE IF EXISTS ims_community_express_
+CREATE TABLE `ims_community_express_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(11) NOT NULL,
`regionid` int(11) NOT NULL,
`openid` varchar(50) NOT NULL,
`realname` varchar(50) NOT NULL,
`mobile` varchar(50) NOT NULL,
`address` varchar(255) NOT NULL,
`province` varchar(50) NOT NULL,
`city` varchar(50) NOT NULL,
`district` varchar(50) NOT NULL,
`type` int(11) NOT NULL COMMENT '发货类型',
`detail` varchar(255) NOT NULL,
`createtime` int(10) unsigned NOT NULL,
`weight_estimate` float NOT NULL,
`price_estimate` float NOT NULL,
`weight` float NOT NULL,
`price` float NOT NULL,
`express_code` varchar(50) NOT NULL,
`sn` varchar(50) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_manager` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`uid` int(10) unsigned NOT NULL,
`regions` varchar(2000) NOT NULL,
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_member` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(11) unsigned NOT NULL,
`regionid` int(10) unsigned NOT NULL COMMENT '小区编号',
`openid` varchar(50) NOT NULL,
`type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1为业主，2为租户',
`realname` varchar(50) NOT NULL COMMENT '真实姓名',
`mobile` varchar(15) NOT NULL COMMENT '手机号',
`regionname` varchar(50) NOT NULL COMMENT '小区名称',
`address` varchar(100) NOT NULL COMMENT '楼栋门牌',
`remark` varchar(1000) NOT NULL COMMENT '备注',
`status` tinyint(1) unsigned NOT NULL,
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_openid` (`openid`),
KEY `idx_mobile` (`mobile`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_phone` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`regionid` int(10) unsigned NOT NULL COMMENT '小区编号',
`weid` int(11) unsigned NOT NULL COMMENT '公众号',
`title` varchar(50) NOT NULL COMMENT '标题',
`phone` varchar(50) NOT NULL COMMENT '号码',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='常用电话';
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_region` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL COMMENT '公众号ID',
`title` varchar(50) NOT NULL COMMENT '标题',
`linkman` varchar(50) NOT NULL COMMENT '联系人',
`linkway` varchar(50) NOT NULL COMMENT '联系电话',
`content` text NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`openid` varchar(50) NOT NULL,
`reportid` int(10) unsigned NOT NULL COMMENT '报告ID',
`isreply` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是回复',
`content` varchar(5000) NOT NULL,
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_report` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`openid` varchar(50) NOT NULL COMMENT '用户身份',
`weid` int(11) unsigned NOT NULL COMMENT '公众号ID',
`regionid` int(10) unsigned NOT NULL COMMENT '小区编号',
`type` tinyint(1) NOT NULL COMMENT '1为报修，2为投诉',
`category` varchar(50) NOT NULL DEFAULT '' COMMENT '类目',
`content` varchar(255) NOT NULL COMMENT '投诉内容',
`requirement` varchar(1000) NOT NULL,
`createtime` int(11) unsigned NOT NULL COMMENT '投诉日期',
`status` tinyint(1) unsigned NOT NULL COMMENT '状态,1已解决,0未解决,2为用户取消',
`newmsg` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否有新信息',
`rank` tinyint(3) unsigned NOT NULL COMMENT '评级 1满意，2一般，3不满意',
`comment` varchar(1000) NOT NULL,
`resolve` varchar(1000) NOT NULL COMMENT '处理结果',
`resolver` varchar(50) NOT NULL COMMENT '处理人',
`resolvetime` int(10) unsigned NOT NULL COMMENT '处理时间',
PRIMARY KEY (`id`),
KEY `idx_weid_regionid` (`weid`,`regionid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_service` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`openid` varchar(50) NOT NULL,
`regionid` int(10) unsigned NOT NULL,
`servicecategory` int(10) unsigned NOT NULL COMMENT '生活服务大分类',
`servicesmallcategory` int(10) unsigned NOT NULL COMMENT '生活服务小分类',
`requirement` varchar(255) NOT NULL COMMENT '精准要求,如保洁需要填写 平米大小',
`remark` varchar(500) NOT NULL COMMENT '备注',
`contacttype` int(10) unsigned NOT NULL COMMENT '联系类型:1.随时联系;2.白天联系;3:晚上联系;4:自定义',
`contactdesc` varchar(255) NOT NULL COMMENT '联系描述',
`status` int(10) unsigned NOT NULL COMMENT '状态',
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_servicecategory` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属帐号',
`name` varchar(50) NOT NULL COMMENT '分类名称',
`parentid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID,0为第一级',
`displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否开启',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
+INSERT INTO ims_community_servicecategory VALUES
+('1','1','家政服务','0','0','1'),
+('2','1','房屋租赁','0','0','1');
+DROP TABLE IF EXISTS ims_community_
+CREATE TABLE `ims_community_verifycode` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`openid` varchar(50) NOT NULL,
`verifycode` varchar(6) NOT NULL,
`mobile` varchar(11) NOT NULL,
`total` tinyint(3) unsigned NOT NULL,
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `openid` (`openid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_cover_
+CREATE TABLE `ims_cover_reply` (
`id` int(10) unsigned NOT NULL,
`weid` int(10) unsigned NOT NULL,
`rid` int(10) unsigned NOT NULL,
`module` varchar(30) NOT NULL DEFAULT '',
`do` varchar(30) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`thumb` varchar(255) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT ''
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+INSERT INTO ims_cover_reply VALUES
+('0','2','83','wesite','channel','微站入口设置','','','mobile.php?act=channel&name=index&weid=2'),
+('0','2','83','wesite','channel','微站入口设置','','','mobile.php?act=channel&name=index&weid=2'),
+('0','2','83','wesite','channel','微站入口设置','','','mobile.php?act=channel&name=index&weid=2');
+DROP TABLE IF EXISTS ims_credit_
+CREATE TABLE `ims_credit_request` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`from_user` varchar(50) NOT NULL,
`award_id` int(10) unsigned NOT NULL,
`createtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_exchange_
+CREATE TABLE `ims_exchange_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) NOT NULL,
`rid` int(11) NOT NULL,
`openid` text NOT NULL,
`name` text NOT NULL,
`mobile` text NOT NULL,
`nums` int(11) NOT NULL,
`cprice` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_exchange_
+CREATE TABLE `ims_exchange_reply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rid` int(11) NOT NULL,
`title` text NOT NULL,
`product` text NOT NULL,
`price` int(11) NOT NULL,
`amount` int(11) NOT NULL,
`times` int(11) NOT NULL,
`picture` text NOT NULL,
`description` text NOT NULL,
`content` text NOT NULL,
`success` text NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_fans` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL COMMENT '公众号ID',
`from_user` varchar(50) NOT NULL COMMENT '用户的唯一身份ID',
`salt` char(8) NOT NULL DEFAULT '' COMMENT '加密盐',
`follow` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否订阅',
`credit1` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
`credit2` double unsigned NOT NULL DEFAULT '0' COMMENT '余额',
`createtime` int(10) unsigned NOT NULL COMMENT '加入时间',
`realname` varchar(10) NOT NULL DEFAULT '' COMMENT '真实姓名',
`nickname` varchar(20) NOT NULL DEFAULT '' COMMENT '昵称',
`avatar` varchar(255) NOT NULL DEFAULT '',
`qq` varchar(15) NOT NULL DEFAULT '' COMMENT 'QQ号',
`mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号码',
`fakeid` varchar(30) NOT NULL DEFAULT '',
`vip` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'VIP级别,0为普通会员',
`gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别(0:保密 1:男 2:女)',
`birthyear` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '生日年',
`birthmonth` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '生日月',
`birthday` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '生日',
`constellation` varchar(10) NOT NULL DEFAULT '' COMMENT '星座',
`zodiac` varchar(5) NOT NULL DEFAULT '' COMMENT '生肖',
`telephone` varchar(15) NOT NULL DEFAULT '' COMMENT '固定电话',
`idcard` varchar(30) NOT NULL DEFAULT '' COMMENT '证件号码',
`studentid` varchar(50) NOT NULL DEFAULT '' COMMENT '学号',
`grade` varchar(10) NOT NULL DEFAULT '' COMMENT '班级',
`address` varchar(255) NOT NULL DEFAULT '' COMMENT '邮寄地址',
`zipcode` varchar(10) NOT NULL DEFAULT '' COMMENT '邮编',
`nationality` varchar(30) NOT NULL DEFAULT '' COMMENT '国籍',
`resideprovince` varchar(30) NOT NULL DEFAULT '' COMMENT '居住省份',
`residecity` varchar(30) NOT NULL DEFAULT '' COMMENT '居住城市',
`residedist` varchar(30) NOT NULL DEFAULT '' COMMENT '居住行政区/县',
`graduateschool` varchar(50) NOT NULL DEFAULT '' COMMENT '毕业学校',
`company` varchar(50) NOT NULL DEFAULT '' COMMENT '公司',
`education` varchar(10) NOT NULL DEFAULT '' COMMENT '学历',
`occupation` varchar(30) NOT NULL DEFAULT '' COMMENT '职业',
`position` varchar(30) NOT NULL DEFAULT '' COMMENT '职位',
`revenue` varchar(10) NOT NULL DEFAULT '' COMMENT '年收入',
`affectivestatus` varchar(30) NOT NULL DEFAULT '' COMMENT '情感状态',
`lookingfor` varchar(255) NOT NULL DEFAULT '' COMMENT ' 交友目的',
`bloodtype` varchar(5) NOT NULL DEFAULT '' COMMENT '血型',
`height` varchar(5) NOT NULL DEFAULT '' COMMENT '身高',
`weight` varchar(5) NOT NULL DEFAULT '' COMMENT '体重',
`alipay` varchar(30) NOT NULL DEFAULT '' COMMENT '支付宝帐号',
`msn` varchar(30) NOT NULL DEFAULT '' COMMENT 'MSN',
`email` varchar(50) NOT NULL DEFAULT '' COMMENT '电子邮箱',
`taobao` varchar(30) NOT NULL DEFAULT '' COMMENT '阿里旺旺',
`site` varchar(30) NOT NULL DEFAULT '' COMMENT '主页',
`bio` text NOT NULL COMMENT '自我介绍',
`interest` text NOT NULL COMMENT '兴趣爱好',
`groupid` int(20) unsigned NOT NULL,
`groupid_ind` varchar(200) NOT NULL,
`wxusr` varchar(100) NOT NULL COMMENT '微信号',
`age` int(4) NOT NULL DEFAULT '18' COMMENT '年龄',
`x` varchar(200) NOT NULL COMMENT '坐标X',
`y` varchar(200) NOT NULL COMMENT '坐标Y',
`city` varchar(255) NOT NULL COMMENT '地址',
`isblacklist` int(2) NOT NULL COMMENT '黑名单',
`isshow` int(2) NOT NULL COMMENT '审核与否',
`isjoin` int(1) NOT NULL DEFAULT '0' COMMENT '在线状态',
`rid` int(8) NOT NULL COMMENT '规则ID',
`remark` varchar(50) NOT NULL,
`remark_ind` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
KEY `weid` (`weid`)
+) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
+INSERT INTO ims_fans VALUES
+('31','2','o7pUxuM8P9FHOosXuHU2em3GZ7yY','','1','0','0','','','郑跃 NATE','http://wx.qlogo.cn/mmopen/7j1UQofaR9czEfctXxKZNuk1jicFNibHRpFQfFXhicN7wD3aRRoSqrwxT7XkPia7eJNxAicyzZSbtibUxprtF91mibz4YJDe7Ir3paP/0','','','','0','1','0','0','0','','','','','','','','','中国','广东','广州','','','','','','','','','','','','','','','','','','','','0','0','','18','','','','0','0','0','0','',''),
+('32','2','o7pUxuIZ-r8BWgvo1sGV80LrBoNc','','1','0','0','','','','http://wx.qlogo.cn/mmopen/ibZxDaFleHPF35U4mXicets1hMTyV4docGVNjYT43mfNt6SNnR0TiaJwQR2r204dheRx70M1FdGwNZ7xgxYhYsykbXjzkDdkY90/0','','','','0','2','0','0','0','','','','','','','','','中国','广东','广州','','','','','','','','','','','','','','','','','','','','0','||','','18','','','','0','0','0','0','',''),
+('33','2','o7pUxuET9tFnJQN98WiNHJUZLoDA','','1','0','0','','','Suky','http://wx.qlogo.cn/mmopen/ibZxDaFleHPF35U4mXicets13abJTkjgNKPoPb2GSlv8rcaG8KsBYTrmDouqd03rTONbOvRfIlZSPUhVCP2wSrkI1YX6QGJMfJ/0','','','','0','2','0','0','0','','','','','','','','','中国','广东','广州','','','','','','','','','','','','','','','','','','','','0','||','','18','','','','0','0','0','0','','sdlkjf'),
+('34','2','o7pUxuBi0dymQOBoCh6l2aNWa02I','','1','0','0','','','兜兜转转几多个圈','http://wx.qlogo.cn/mmopen/7j1UQofaR9cqvvf4KasS2tcp63iaBy6g3nfYf8MJWd0cEMaGfSNcbzItf6IeARd43TzqM5PVGUjyyiabgbb7l1rEfqAmEb0Xq0/0','','','','0','1','0','0','0','','','','','','','','','中国','广东','广州','','','','','','','','','','','','','','','','','','','','0','0','','18','','','','0','0','0','0','',''),
+('35','2','o7pUxuLJfXB5NPkxwEg6CY5FbM8k','','1','0','0','','','陳小曼','http://wx.qlogo.cn/mmopen/gRgeuKAShTiaibvAfLXxxJInsOIMW9yjGPedEHiaIIvSA5DFgeuHjXdql4SxE9JYKZCpEDPibEsRQlahUjyEnEs9nXRTUUZarvAr/0','','','','0','2','0','0','0','','','','','','','','','中国','广东','广州','','','','','','','','','','','','','','','','','','','','0','||','','18','','','','0','0','0','0','','hah'),
+('36','2','o7pUxuCkS1tqsgoyp2sNQw0p7o10','','1','0','0','','','','http://wx.qlogo.cn/mmopen/ibZxDaFleHPEGgZF52hoAJaEHph8XUvytiaVofheYI6A1qG4cYRatLvdwRKEYjhaf98dWEPN0gdyEwTO0oCBNWsBoiaGkvYEpBe/0','','','','0','2','0','0','0','','','','','','','','','中国','广东','广州','','','','','','','','','','','','','','','','','','','','0','0','','18','','','','0','0','0','0','',''),
+('37','2','o7pUxuIf9DoeTn2xdDDqEXAEDObI','','1','0','0','','','?yuyu(方小煜)?','http://wx.qlogo.cn/mmopen/ibZxDaFleHPGWFIKaNrFBDiabLJoBloXXe6pyfNGj6GH1aRxVOia4dYjthaDRjHj1pcqncNY0teLYWwl6fkofyK0y2E4riaVCohG/0','','','','0','1','0','0','0','','','','','','','','','中国','广东','阳江','','','','','','','','','','','','','','','','','','','','0','0','','18','','','','0','0','0','0','',''),
+('38','2','o7pUxuIVi86Hss6uDnY6bbFgKtPs','xuU4Pipd','1','0','0','','','洪宇','http://wx.qlogo.cn/mmopen/pap2POlp2p0Lt4Z36g13Mx6WqMFPv0YdadaXAL23ibib9E09Mo777IkBUNHibj8YJ8GAxpFM3ZoALxloVX5mpfptyLYAq9XfYTs/0','','','','0','1','0','0','0','','','','','','','','','中国','广东','潮州','','','','','','','','','','','','','','','','','','','','0','|1|','','18','','','','0','0','0','0','',';),
+('39','2','o7pUxuFupd8n-IjdG5JhYd8hHILA','','1','0','0','','','澤龍','http://wx.qlogo.cn/mmopen/gCyVj9tcOvUc1tNKuvbXpTxB8c1kThYpPFwUe3GQmHPKPdFEe4eemto3bfa11588kW20WqKNA7q1nOIXPDYffHKztbGvoIpm/0','','','','0','1','0','0','0','','','','','','','','','中国','广东','广州','','','','','','','','','','','','','','','','','','','','0','0','','18','','','','0','0','0','0','',''),
+('40','2','fromUser','X48X6xZY','1','0','0','','','','','','','','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','0','||','','0','','','','0','0','0','0','',''),
+('41','2','o7pUxuLm9Lbq1xCRcQRuQ5FJINq0','w4SP2Ne6','1','0','0','','','Warm','http://wx.qlogo.cn/mmopen/F0JEiawukrFIScicTrtFSibN7dd4KR3nG1tDFlibnEWW9SoZiagQWPGmNFIeOL6XcKFkVNqfdohOQO84RUvjia5G9P6xYOcr8Zviaqx/0','','','','0','1','0','0','0','','','','','','','','','中国','广东','深圳','','','','','','','','','','','','','','','','','','','','0','||','','0','','','','0','0','0','0','',''),
+('42','2','o7pUxuLc1CQ3wJarJ48hzG5mr9WA','','1','0','0','','','Duang、Duang','http://wx.qlogo.cn/mmopen/gCyVj9tcOvUcdIV4IM0m8r5mdzG5qJ9RS9DruUHFoCY8ANzp8eS6ZHd1FCEA5icuKDIWb08MNGzLss1wF2r1A86vk6KaXkM19/0','','','','0','1','0','0','0','','','','','','','','','中国','四川','遂宁','','','','','','','','','','','','','','','','','','','','0','||','','18','','','','0','0','0','0','',''),
+('43','2','o7pUxuAA9DmDR7Ov-sDsd16_Bres','BTy9HVL9','1','0','0','','','','','','','','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','0','','','0','','','','0','0','0','0','','');
+DROP TABLE IF EXISTS ims_fans_
+CREATE TABLE `ims_fans_group` (
`id` int(3) NOT NULL AUTO_INCREMENT COMMENT '群组id',
`groupname` varchar(100) NOT NULL COMMENT '群组名',
`credit` int(11) NOT NULL DEFAULT '0' COMMENT '等级积分',
`info` varchar(250) NOT NULL COMMENT '说明介绍',
`weid` tinyint(5) NOT NULL DEFAULT '0' COMMENT '公众号ID',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_game2048_
+CREATE TABLE `ims_game2048_reply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rid` int(11) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`cover` varchar(255) DEFAULT NULL,
`description` text,
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_groupon_
+CREATE TABLE `ims_groupon_fans` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`from_user` varchar(50) NOT NULL,
`mobile` varchar(20) NOT NULL,
`totalnum` tinyint(4) NOT NULL,
`totalprice` varchar(10) NOT NULL,
`last_time` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_groupon_
+CREATE TABLE `ims_groupon_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) NOT NULL,
`rid` int(11) NOT NULL,
`title` varchar(50) NOT NULL,
`starttime` int(10) NOT NULL,
`endtime` int(10) NOT NULL,
`listorder` int(11) NOT NULL,
`warning_stock` int(11) NOT NULL,
`price` varchar(10) NOT NULL,
`market_price` varchar(10) NOT NULL,
`stock` int(11) NOT NULL,
`limit_num` int(11) NOT NULL,
`sell_nums` int(11) NOT NULL,
`virtual_sales` int(11) NOT NULL,
`summary` varchar(500) NOT NULL,
`thumb_list` varchar(500) NOT NULL,
`info` text NOT NULL,
`tips` varchar(500) NOT NULL,
`random_refund` tinyint(1) NOT NULL,
`expired_refund` tinyint(1) NOT NULL,
`valid_starttime` int(10) NOT NULL,
`valid_endtime` int(10) NOT NULL,
`is_view` tinyint(1) NOT NULL,
`store_key` varchar(20) NOT NULL,
`status` tinyint(1) NOT NULL,
`hits` int(11) NOT NULL,
`create_time` int(10) NOT NULL,
`notice` varchar(1000) NOT NULL,
`email` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_groupon_
+CREATE TABLE `ims_groupon_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`tid` int(11) NOT NULL,
`from_user` varchar(50) NOT NULL,
`ordersn` varchar(30) NOT NULL COMMENT '订单编号',
`secretsn` varchar(10) NOT NULL,
`totalnum` tinyint(4) NOT NULL,
`totalprice` varchar(10) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '-1取消状态，0普通状态，1为已确认(付款自动确认)，2为成功',
`used` tinyint(1) NOT NULL COMMENT '是否使用',
`ispay` tinyint(1) NOT NULL COMMENT '是否付款',
`sendtype` tinyint(1) unsigned NOT NULL COMMENT '1为快递，2为自提',
`paytype` tinyint(1) unsigned NOT NULL COMMENT '1为余额，2为在线，3为到付',
`remark` varchar(1000) NOT NULL DEFAULT '',
`createtime` int(10) unsigned NOT NULL,
`paytime` int(10) NOT NULL,
`usedtime` int(10) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_groupon_
+CREATE TABLE `ims_groupon_set` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`payset1` tinyint(1) NOT NULL,
`payset2` tinyint(1) NOT NULL,
`payset3` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_ifans_group_
+CREATE TABLE `ims_ifans_group_ind` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`groupid` int(10) unsigned NOT NULL,
`name` varchar(50) NOT NULL,
`count` int(10) unsigned NOT NULL,
`weid` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+INSERT INTO ims_ifans_group_ind VALUES
+('1','1','分组1','0','2'),
+('2','2','分组22','0','2'),
+('3','3','分组3','0','2');
+DROP TABLE IF EXISTS ims_ifans_
+CREATE TABLE `ims_ifans_groupsend` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`from_user` varchar(50) NOT NULL,
`msgtype` varchar(10) NOT NULL,
`msg` varchar(800) NOT NULL,
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`errorcode` int(10) unsigned NOT NULL,
`time` int(10) unsigned NOT NULL,
`starttime` int(10) unsigned NOT NULL,
`send_time` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`type` int(4) NOT NULL,
`createtime` int(11) NOT NULL,
`account_name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
+INSERT INTO ims_logs VALUES
+('1','1','2','',''),
+('2','1','1','',''),
+('3','1','4','','123'),
+('4','1','1','',''),
+('5','1','1','',''),
+('6','1','1','',''),
+('7','1','1','',''),
+('8','1','1','',''),
+('9','1','1','',''),
+('10','1','1','',''),
+('11','1','1','',''),
+('12','1','1','',''),
+('13','1','6','','site'),
+('14','1','5','','site'),
+('15','1','1','',''),
+('16','1','2','',''),
+('17','1','1','',''),
+('18','1','2','',''),
+('19','1','1','',''),
+('20','1','2','',''),
+('21','1','1','',''),
+('22','1','2','',''),
+('23','1','1','',''),
+('24','1','1','',''),
+('25','1','1','',''),
+('26','1','1','',''),
+('27','1','1','',''),
+('28','1','1','',''),
+('29','1','1','',''),
+('30','1','1','',''),
+('31','1','1','',''),
+('32','1','1','','');
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_mechat` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '美洽管理帐户',
`cdata` varchar(300) NOT NULL DEFAULT '' COMMENT '数据',
`access_token` varchar(300) NOT NULL DEFAULT '' COMMENT '票据口令',
`createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_medias` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`title` varchar(50) NOT NULL,
`mediatype` varchar(8) NOT NULL,
`content` varchar(200) NOT NULL,
`mediaurl` varchar(200) NOT NULL,
`media_id` varchar(100) NOT NULL,
`createtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
+INSERT INTO ims_medias VALUES
+('6','2','缩略图1','thumb','','images/2015/06/iVbX4Jpmxc4y4b293Cpv1B9J2Bf41c.jpg','GJpdS028OHdDDlONzWWxOPKpQfSTMDLZauV38mLrM9U',''),
+('7','2','','news','','','kjio4qm-bWOMhUayYyR33hvLds3uvSvYb5UX0j-IZuE',''),
+('8','2','图文test1','news','','','kjio4qm-bWOMhUayYyR33q1z0BsvzxzCXnFikLbNWT8','');
+DROP TABLE IF EXISTS ims_
+CREATE TABLE `ims_members` (
`uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户编号',
`groupid` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(30) NOT NULL COMMENT '用户名',
`password` varchar(200) NOT NULL COMMENT '用户密码',
`salt` varchar(10) NOT NULL COMMENT '加密盐',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '会员状态，0正常，-1禁用',
`joindate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
`joinip` varchar(15) NOT NULL DEFAULT '',
`lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
`lastip` varchar(15) NOT NULL DEFAULT '',
`remark` varchar(500) NOT NULL DEFAULT '',
`parentid` int(10) NOT NULL,
`children_amount` int(10) NOT NULL,
`account_amount` int(10) NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`)
+) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='用户表';
+INSERT INTO ims_members VALUES
+('1','0','admin','de4fa9d77ae1de2595e8f','','0','','','','14.147.93.220','','0','0','0'),
+('2','1','test001','fbc09aacf2ad345aa79db184a1e5eba623aee4d7','cgr53oGH','0','','14.147.84.239','','14.147.84.239','','1','0','1'),
+('5','1','aaa','c42af1defb598b5af4','gbhxks8K','0','','14.147.93.220','','14.147.93.220','2级管理员','1','0','0');
+DROP TABLE IF EXISTS ims_members_
+CREATE TABLE `ims_members_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`modules` varchar(5000) NOT NULL DEFAULT '',
`templates` varchar(5000) NOT NULL DEFAULT '',
`maxaccount` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '0为不限制',
`maxsubaccount` int(10) unsigned NOT NULL COMMENT '子公号最多添加数量，为0为不可以添加',
`level` int(5) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+INSERT INTO ims_members_group VALUES
+('1','1级管理员','N;','N;','0','0','1'),
+('2','2级管理员','a:5:{i:0;s:2:\&93\&;i:1;s:3:\&100\&;i:2;s:3:\&101\&;i:3;s:3:\&102\&;i:4;s:3:\&103\&;}','a:18:{i:0;s:1:\&2\&;i:1;s:1:\&3\&;i:2;s:1:\&4\&;i:3;s:1:\&5\&;i:4;s:1:\&6\&;i:5;s:2:\&23\&;i:6;s:2:\&22\&;i:7;s:2:\&11\&;i:8;s:2:\&12\&;i:9;s:2:\&13\&;i:10;s:2:\&14\&;i:11;s:2:\&15\&;i:12;s:2:\&16\&;i:13;s:2:\&17\&;i:14;s:2:\&18\&;i:15;s:2:\&19\&;i:16;s:2:\&20\&;i:17;s:2:\&21\&;}','0','0','2'),
+('3','3级管理员','N;','N;','0','0','3');
+DROP TABLE IF EXISTS ims_members_
+CREATE TABLE `ims_members_permission` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`resourceid` int(11) NOT NULL DEFAULT '0',
`type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1为模块,2为模板',
PRIMARY KEY (`id`),
KEY `idx_uid` (`uid`)
+) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
+INSERT INTO ims_members_permission VALUES
+('7','5','102','1'),
+('6','5','103','1'),
+('5','5','104','1'),
+('8','5','101','1'),
+('9','5','13','2'),
+('10','5','12','2'),
+('11','5','11','2'),
+('12','5','6','2'),
+('13','5','2','2');
+DROP TABLE IF EXISTS ims_members_
+CREATE TABLE `ims_members_profile` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL,
`createtime` int(10) unsigned NOT NULL COMMENT '加入时间',
`realname` varchar(10) NOT NULL DEFAULT '' COMMENT '真实姓名',
`nickname` varchar(20) NOT NULL DEFAULT '' COMMENT '昵称',
`avatar` varchar(100) NOT NULL DEFAULT '' COMMENT '头像',
`qq` varchar(15) NOT NULL DEFAULT '' COMMENT 'QQ号',
`mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号码',
`fakeid` varchar(30) NOT NULL,
`vip` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'VIP级别,0为普通会员',
`gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别(0:保密 1:男 2:女)',
`birthyear` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '生日年',
`birthmonth` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '生日月',
`birthday` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '生日',
`constellation` varchar(10) NOT NULL DEFAULT '' COMMENT '星座',
`zodiac` varchar(5) NOT NULL DEFAULT '' COMMENT '生肖',
`telephone` varchar(15) NOT NULL DEFAULT '' COMMENT '固定电话',
`idcard` varchar(30) NOT NULL DEFAULT '' COMMENT '证件号码',
`studentid` varchar(50) NOT NULL DEFAULT '' COMMENT '学号',
`grade` varchar(10) NOT NULL DEFAULT '' COMMENT '班级',
`address` varchar(255) NOT NULL DEFAULT '' COMMENT '邮寄地址',
`zipcode` varchar(10) NOT NULL DEFAULT '' COMMENT '邮编',
`nationality` varchar(30) NOT NULL DEFAULT '' COMMENT '国籍',
`resideprovince` varchar(30) NOT NULL DEFAULT '' COMMENT '居住省份',
`residecity` varchar(30) NOT NULL DEFAULT '' COMMENT '居住城市',
`residedist` varchar(30) NOT NULL DEFAULT '' COMMENT '居住行政区/县',
`graduateschool` varchar(50) NOT NULL DEFAULT '' COMMENT '毕业学校',
`company` varchar(50) NOT NULL DEFAULT '' COMMENT '公司',
`education` varchar(10) NOT NULL DEFAULT '' COMMENT '学历',
`occupation` varchar(30) NOT NULL DEFAULT '' COMMENT '职业',
`position` varchar(30) NOT NULL DEFAULT '' COMMENT '职位',
`revenue` varchar(10) NOT NULL DEFAULT '' COMMENT '年收入',
`affectivestatus` varchar(30) NOT NULL DEFAULT '' COMMENT '情感状态',
`lookingfor` varchar(255) NOT NULL DEFAULT '' COMMENT ' 交友目的',
`bloodtype` varchar(5) NOT NULL DEFAULT '' COMMENT '血型',
`height` varchar(5) NOT NULL DEFAULT '' COMMENT '身高',
`weight` varchar(5) NOT NULL DEFAULT '' COMMENT '体重',
`alipay` varchar(30) NOT NULL DEFAULT '' COMMENT '支付宝帐号',
`msn` varchar(30) NOT NULL DEFAU