折翼天使资源社区

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 289|回复: 3

[功能模块] 微小区 10.0.0 解密开源版功能模块源码分享,收费系统优化,周边商家优化,修复BUG等

[复制链接]

8390

主题

8796

帖子

152

积分

网站编辑

Rank: 8Rank: 8

天使之心
0
注册时间
2013-8-22
发表于 2019-4-10 00:01:08 | 显示全部楼层 |阅读模式
版本号:10.0.0 - 运营版
1.门禁优化
2.收费系统优化
3.周边商家优化
4.报修优化
5.问卷调查优化
6.停车系统优化

演示截图:

微小区 10.0.0模块界面演示截图

微小区 10.0.0模块界面演示截图


请点击此处下载

请先注册会员后在进行下载

已注册会员,请先登录后下载

售价: 50 天使之羽    微小区 10.0.0 解密开源版功能模块源码下载   
下载权限: 一翼天使 以上用户组 [顶级代理免羽毛下载] [充值羽毛] [记录] 下载次数: 33

5

主题

201

帖子

75

积分

二翼大天使

Rank: 2

天使之心
20
注册时间
2015-10-20
发表于 2019-4-10 09:34:02 | 显示全部楼层
缺少数据库安装脚本~~~~~~~~~~

8390

主题

8796

帖子

152

积分

网站编辑

Rank: 8Rank: 8

天使之心
0
注册时间
2013-8-22
 楼主| 发表于 2019-4-10 16:29:44 | 显示全部楼层



疏忽了,呵呵,后台sql执行即可!
  1. CREATE TABLE IF NOT EXISTS `ims_xcommunity_activity` (
  2.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3.   `weid` int(10) unsigned NOT NULL,
  4.   `title` varchar(50) NOT NULL,
  5.   `regionid` text NOT NULL,
  6.   `starttime` int(11) NOT NULL,
  7.   `endtime` int(11) NOT NULL,
  8.   `enddate` varchar(30) NOT NULL,
  9.   `picurl` varchar(1000) NOT NULL,
  10.   `number` int(11) NOT NULL DEFAULT '1',
  11.   `content` text NOT NULL,
  12.   `status` int(1) NOT NULL,
  13.   `price` decimal(12,2) NOT NULL,
  14.   `createtime` int(11) unsigned NOT NULL,
  15.   `resnumber` int(11) unsigned NOT NULL,
  16.   `uid` int(10) unsigned NOT NULL,
  17.   `province` varchar(50) NOT NULL,
  18.   `city` varchar(50) NOT NULL,
  19.   `dist` varchar(50) NOT NULL,
  20.   `uniacid` int(10) DEFAULT NULL,
  21.   `num` int(11) DEFAULT '0',
  22.   `allregion` int(1) DEFAULT NULL,
  23.   `recommand` tinyint(1) DEFAULT '0',
  24.   PRIMARY KEY (`id`)
  25. ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='小区活动表';
  26. CREATE TABLE IF NOT EXISTS `ims_xcommunity_activity_region` (
  27.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  28.   `activityid` int(10) unsigned NOT NULL,
  29.   `regionid` int(11) NOT NULL,
  30.   PRIMARY KEY (`id`)
  31. ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
  32. CREATE TABLE IF NOT EXISTS `ims_xcommunity_alipayment` (
  33.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  34.   `uniacid` int(10) NOT NULL,
  35.   `pid` int(11) NOT NULL,
  36.   `account` varchar(50) NOT NULL,
  37.   `partner` varchar(50) NOT NULL,
  38.   `secret` varchar(50) NOT NULL,
  39.   `type` int(1) DEFAULT NULL,
  40.   `uid` int(11) DEFAULT NULL,
  41.   `userid` int(11) DEFAULT NULL,
  42.   PRIMARY KEY (`id`)
  43. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  44. CREATE TABLE IF NOT EXISTS `ims_xcommunity_announcement` (
  45.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  46.   `weid` int(10) unsigned NOT NULL,
  47.   `regionid` text NOT NULL,
  48.   `pid` int(10) unsigned NOT NULL,
  49.   `title` varchar(255) NOT NULL,
  50.   `content` text NOT NULL,
  51.   `author` varchar(50) NOT NULL,
  52.   `createtime` int(10) unsigned NOT NULL,
  53.   `starttime` int(11) unsigned NOT NULL,
  54.   `endtime` int(11) unsigned NOT NULL,
  55.   `status` tinyint(1) NOT NULL,
  56.   `enable` tinyint(1) NOT NULL,
  57.   `datetime` varchar(100) NOT NULL,
  58.   `location` varchar(100) NOT NULL,
  59.   `reason` text NOT NULL,
  60.   `remark` varchar(100) NOT NULL,
  61.   `uid` int(11) NOT NULL,
  62.   `province` varchar(50) NOT NULL,
  63.   `city` varchar(50) NOT NULL,
  64.   `dist` varchar(50) NOT NULL,
  65.   `uniacid` int(10) DEFAULT NULL,
  66.   `type` int(1) DEFAULT NULL,
  67.   `allregion` int(1) DEFAULT NULL,
  68.   PRIMARY KEY (`id`)
  69. ) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
  70. CREATE TABLE IF NOT EXISTS `ims_xcommunity_announcement_build` (
  71.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  72.   `aid` int(11) unsigned NOT NULL COMMENT '公告id',
  73.   `buildid` int(11) NOT NULL COMMENT '楼宇id',
  74.   PRIMARY KEY (`id`)
  75. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  76. CREATE TABLE IF NOT EXISTS `ims_xcommunity_announcement_region` (
  77.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  78.   `aid` int(11) unsigned NOT NULL COMMENT '公告id',
  79.   `regionid` int(11) NOT NULL COMMENT '小区id',
  80.   PRIMARY KEY (`id`)
  81. ) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;
  82. CREATE TABLE IF NOT EXISTS `ims_xcommunity_app_user` (
  83.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  84.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  85.   `realname` varchar(50) NOT NULL,
  86.   `tel` varchar(13) NOT NULL,
  87.   `address` varchar(255) NOT NULL COMMENT '地址',
  88.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  89.   `createtime` int(11) NOT NULL,
  90.   `category` int(1) NOT NULL,
  91.   `status` int(1) NOT NULL,
  92.   `remark` text NOT NULL,
  93.   `license` varchar(255) DEFAULT NULL,
  94.   `company` varchar(255) DEFAULT NULL,
  95.   PRIMARY KEY (`id`)
  96. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  97. CREATE TABLE IF NOT EXISTS `ims_xcommunity_appmenu` (
  98.   `id` int(11) NOT NULL AUTO_INCREMENT,
  99.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  100.   `displayorder` int(10) NOT NULL COMMENT '排序',
  101.   `pcate` int(10) NOT NULL COMMENT '一级分类id',
  102.   `title` varchar(30) NOT NULL COMMENT '标题',
  103.   `url` varchar(255) NOT NULL COMMENT '链接',
  104.   `status` int(1) NOT NULL COMMENT '展示',
  105.   `icon` varchar(255) NOT NULL COMMENT '图标',
  106.   `thumb` varchar(255) NOT NULL COMMENT '图片',
  107.   `cate` int(11) DEFAULT '0',
  108.   PRIMARY KEY (`id`)
  109. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  110. CREATE TABLE IF NOT EXISTS `ims_xcommunity_area` (
  111.   `id` int(11) NOT NULL AUTO_INCREMENT,
  112.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  113.   `regionid` int(11) NOT NULL,
  114.   `title` varchar(50) NOT NULL,
  115.   `uid` int(11) DEFAULT NULL,
  116.   PRIMARY KEY (`id`)
  117. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  118. CREATE TABLE IF NOT EXISTS `ims_xcommunity_balance` (
  119.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  120.   `uniacid` int(11) NOT NULL,
  121.   `uid` int(11) NOT NULL,
  122.   `regionid` int(11) NOT NULL,
  123.   `build` varchar(30) NOT NULL,
  124.   `unit` varchar(30) NOT NULL,
  125.   `room` varchar(30) NOT NULL,
  126.   `price` varchar(30) NOT NULL,
  127.   `category` int(11) NOT NULL,
  128.   `username` varchar(30) NOT NULL,
  129.   `usertime` int(11) NOT NULL,
  130.   `remark` text NOT NULL,
  131.   `status` int(1) DEFAULT NULL,
  132.   `area` int(11) DEFAULT NULL,
  133.   PRIMARY KEY (`id`)
  134. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收支项目';
  135. CREATE TABLE IF NOT EXISTS `ims_xcommunity_balance_category` (
  136.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  137.   `uniacid` int(11) NOT NULL,
  138.   `uid` int(11) NOT NULL,
  139.   `regionid` int(11) NOT NULL,
  140.   `category` varchar(50) NOT NULL,
  141.   `remark` text NOT NULL,
  142.   `status` int(1) NOT NULL,
  143.   `type` int(1) NOT NULL,
  144.   PRIMARY KEY (`id`)
  145. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收支项目';
  146. CREATE TABLE IF NOT EXISTS `ims_xcommunity_bind_door` (
  147.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  148.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  149.   `regionid` int(11) NOT NULL COMMENT '小区id',
  150.   `deviceid` text NOT NULL COMMENT '开门绑定',
  151.   `openid` varchar(50) NOT NULL,
  152.   `uid` int(11) DEFAULT NULL,
  153.   PRIMARY KEY (`id`)
  154. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='开门绑定';
  155. CREATE TABLE IF NOT EXISTS `ims_xcommunity_bind_door_device` (
  156.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  157.   `doorid` int(10) unsigned NOT NULL,
  158.   `deviceid` int(11) NOT NULL COMMENT '设备id',
  159.   `groupid` int(11) DEFAULT NULL,
  160.   PRIMARY KEY (`id`)
  161. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  162. CREATE TABLE IF NOT EXISTS `ims_xcommunity_build` (
  163.   `id` int(11) NOT NULL AUTO_INCREMENT,
  164.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  165.   `regionid` int(11) NOT NULL,
  166.   `buildtitle` varchar(50) NOT NULL,
  167.   `unit_num` int(11) DEFAULT NULL,
  168.   `floor_num` int(11) DEFAULT NULL,
  169.   `build_type` varchar(50) DEFAULT NULL,
  170.   `room_num` int(11) DEFAULT NULL,
  171.   `uid` int(11) DEFAULT NULL,
  172.   `areaid` int(11) DEFAULT '0',
  173.   `action` tinyint(1) DEFAULT NULL,
  174.   `yybstatus` tinyint(1) DEFAULT NULL,
  175.   `yybbuildid` int(11) DEFAULT NULL,
  176.   `buildingId` int(11) DEFAULT NULL,
  177.   PRIMARY KEY (`id`)
  178. ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
  179. CREATE TABLE IF NOT EXISTS `ims_xcommunity_building` (
  180.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  181.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  182.   `regionid` int(11) NOT NULL,
  183.   `title` varchar(50) NOT NULL,
  184.   `num` int(3) NOT NULL,
  185.   PRIMARY KEY (`id`)
  186. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  187. CREATE TABLE IF NOT EXISTS `ims_xcommunity_building_device` (
  188.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  189.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  190.   `regionid` int(11) NOT NULL,
  191.   `title` varchar(50) NOT NULL,
  192.   `unit` varchar(30) NOT NULL,
  193.   `api_key` varchar(100) NOT NULL,
  194.   `device_code` int(11) NOT NULL,
  195.   `lock_code` varchar(11) NOT NULL,
  196.   `type` int(1) NOT NULL,
  197.   `openurl` varchar(1000) DEFAULT NULL,
  198.   `uid` int(11) DEFAULT NULL,
  199.   `displayorder` int(11) DEFAULT NULL,
  200.   `device_gprs` varchar(50) DEFAULT NULL,
  201.   `lng` varchar(30) DEFAULT NULL,
  202.   `lat` varchar(30) DEFAULT NULL,
  203.   `createtime` int(11) DEFAULT NULL,
  204.   `thumb` text,
  205.   `category` int(1) DEFAULT NULL,
  206.   `status` tinyint(1) DEFAULT '1',
  207.   `areaid` int(11) DEFAULT '0',
  208.   `buildid` int(11) DEFAULT '0',
  209.   `unitid` int(11) DEFAULT '0',
  210.   `doorstatus` tinyint(1) DEFAULT '0',
  211.   `appid` varchar(50) DEFAULT NULL,
  212.   `appkey` varchar(50) DEFAULT NULL,
  213.   `appsecret` varchar(50) DEFAULT NULL,
  214.   `photos` text,
  215.   `username` varchar(50) DEFAULT NULL,
  216.   `password` varchar(50) DEFAULT NULL,
  217.   `deviceid` int(10) DEFAULT NULL,
  218.   `apikey` varchar(50) DEFAULT NULL,
  219.   `secretkey` varchar(50) DEFAULT NULL,
  220.   `accountid` int(11) DEFAULT NULL,
  221.   `setting` text,
  222.   PRIMARY KEY (`id`)
  223. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  224. CREATE TABLE IF NOT EXISTS `ims_xcommunity_building_device_cards` (
  225.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  226.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  227.   `deviceid` int(11) NOT NULL,
  228.   `regionid` int(11) NOT NULL,
  229.   `cardno` varchar(10) NOT NULL,
  230.   `type` int(1) NOT NULL COMMENT '1白名单,2黑名单',
  231.   `oper` int(1) NOT NULL COMMENT '1添加,2覆盖,3删除',
  232.   `uid` int(11) NOT NULL COMMENT '操作员uid',
  233.   `createtime` int(11) NOT NULL,
  234.   `status` int(1) DEFAULT NULL,
  235.   `roomid` int(11) DEFAULT NULL,
  236.   `mobile` varchar(13) DEFAULT NULL,
  237.   `address` varchar(255) DEFAULT NULL,
  238.   `device_code` text,
  239.   `enddate` int(11) DEFAULT '0',
  240.   `cardids` text,
  241.   PRIMARY KEY (`id`),
  242.   KEY `regionid` (`regionid`)
  243. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  244. CREATE TABLE IF NOT EXISTS `ims_xcommunity_building_device_cards_category` (
  245.   `id` int(11) NOT NULL AUTO_INCREMENT,
  246.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  247.   `cardid` int(11) NOT NULL,
  248.   `categoryid` int(11) NOT NULL,
  249.   PRIMARY KEY (`id`)
  250. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='发卡管理-绑定门禁';
  251. CREATE TABLE IF NOT EXISTS `ims_xcommunity_building_device_log` (
  252.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  253.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  254.   `device_code` varchar(30) NOT NULL,
  255.   `cardno` varchar(10) NOT NULL,
  256.   `type` int(1) NOT NULL COMMENT '1白名单,2黑名单',
  257.   `sktime` int(11) NOT NULL,
  258.   `uid` int(11) NOT NULL COMMENT '操作员uid',
  259.   `createtime` int(11) NOT NULL,
  260.   PRIMARY KEY (`id`)
  261. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  262. CREATE TABLE IF NOT EXISTS `ims_xcommunity_business_print` (
  263.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  264.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  265.   `dpid` int(11) NOT NULL,
  266.   `api_key` varchar(150) NOT NULL COMMENT 'API密钥',
  267.   `deviceNo` varchar(150) NOT NULL COMMENT '终端编号',
  268.   `type` int(1) NOT NULL,
  269.   `uid` int(11) DEFAULT NULL,
  270.   PRIMARY KEY (`id`)
  271. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  272. CREATE TABLE IF NOT EXISTS `ims_xcommunity_business_wechat` (
  273.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  274.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  275.   `dpid` int(11) NOT NULL,
  276.   `openid` varchar(50) NOT NULL COMMENT '粉丝openid',
  277.   `realname` varchar(150) NOT NULL COMMENT '姓名',
  278.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  279.   `enable` int(1) NOT NULL COMMENT '是否开启',
  280.   `type` int(1) NOT NULL COMMENT '1微信2短信3全部',
  281.   `uid` int(11) DEFAULT NULL,
  282.   PRIMARY KEY (`id`)
  283. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  284. CREATE TABLE IF NOT EXISTS `ims_xcommunity_car_images` (
  285.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  286.   `carid` int(11) NOT NULL COMMENT '二手id',
  287.   `thumbid` int(11) NOT NULL COMMENT '图片id',
  288.   PRIMARY KEY (`id`)
  289. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='图片关联表';
  290. CREATE TABLE IF NOT EXISTS `ims_xcommunity_carpool` (
  291.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  292.   `weid` int(10) unsigned NOT NULL,
  293.   `title` varchar(50) NOT NULL,
  294.   `seat` int(2) unsigned NOT NULL,
  295.   `sprice` int(10) unsigned NOT NULL,
  296.   `contact` varchar(50) NOT NULL,
  297.   `mobile` varchar(13) NOT NULL,
  298.   `openid` varchar(50) NOT NULL,
  299.   `start_position` varchar(100) NOT NULL,
  300.   `end_position` varchar(100) NOT NULL,
  301.   `gotime` varchar(10) NOT NULL,
  302.   `backtime` varchar(10) NOT NULL,
  303.   `createtime` int(10) unsigned NOT NULL,
  304.   `regionid` int(10) unsigned NOT NULL,
  305.   `type` int(11) NOT NULL,
  306.   `thumb` varchar(2000) NOT NULL,
  307.   `black` int(1) NOT NULL,
  308.   `enable` tinyint(1) unsigned NOT NULL,
  309.   `uniacid` int(10) DEFAULT NULL,
  310.   `uid` int(11) DEFAULT NULL,
  311.   `tj_position` varchar(100) DEFAULT NULL,
  312.   `status` tinyint(1) DEFAULT '0',
  313.   PRIMARY KEY (`id`)
  314. ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
  315. CREATE TABLE IF NOT EXISTS `ims_xcommunity_cart` (
  316.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  317.   `weid` int(10) unsigned NOT NULL,
  318.   `goodsid` int(11) NOT NULL,
  319.   `from_user` varchar(50) NOT NULL,
  320.   `total` int(10) unsigned NOT NULL,
  321.   `marketprice` decimal(10,2) DEFAULT '0.00',
  322.   `uniacid` int(10) DEFAULT NULL,
  323.   `regionid` int(11) DEFAULT NULL,
  324.   `uid` int(11) DEFAULT NULL,
  325.   `type` int(1) DEFAULT '1',
  326.   PRIMARY KEY (`id`)
  327. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  328. CREATE TABLE IF NOT EXISTS `ims_xcommunity_category` (
  329.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  330.   `weid` int(10) unsigned DEFAULT NULL,
  331.   `parentid` int(10) unsigned DEFAULT NULL,
  332.   `name` varchar(5000) NOT NULL,
  333.   `price` decimal(12,2) NOT NULL,
  334.   `description` text NOT NULL,
  335.   `gtime` varchar(50) NOT NULL,
  336.   `thumb` varchar(100) NOT NULL,
  337.   `displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
  338.   `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  339.   `type` int(10) unsigned NOT NULL,
  340.   `regionid` int(10) unsigned DEFAULT NULL,
  341.   `isshow` int(1) NOT NULL,
  342.   `url` varchar(100) NOT NULL,
  343.   `uniacid` int(10) DEFAULT NULL,
  344.   `province` varchar(50) DEFAULT NULL,
  345.   `city` varchar(50) DEFAULT NULL,
  346.   `dist` varchar(50) DEFAULT NULL,
  347.   `allregion` int(1) DEFAULT NULL,
  348.   PRIMARY KEY (`id`)
  349. ) ENGINE=MyISAM AUTO_INCREMENT=124 DEFAULT CHARSET=utf8;
  350. CREATE TABLE IF NOT EXISTS `ims_xcommunity_category_region` (
  351.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  352.   `cid` int(10) unsigned NOT NULL,
  353.   `regionid` int(11) NOT NULL,
  354.   PRIMARY KEY (`id`)
  355. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小区分类副表';
  356. CREATE TABLE IF NOT EXISTS `ims_xcommunity_charging_fault` (
  357.   `id` int(11) NOT NULL AUTO_INCREMENT,
  358.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  359.   `uid` int(11) NOT NULL,
  360.   `stationid` int(11) NOT NULL COMMENT '充电桩id',
  361.   `socketid` int(11) NOT NULL COMMENT '插座id',
  362.   `fault` char(50) NOT NULL,
  363.   `content` text NOT NULL,
  364.   `pics` text NOT NULL,
  365.   `createtime` int(11) NOT NULL COMMENT '生成时间',
  366.   `status` tinyint(1) NOT NULL,
  367.   PRIMARY KEY (`id`)
  368. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  369. CREATE TABLE IF NOT EXISTS `ims_xcommunity_charging_notice` (
  370.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  371.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  372.   `regionid` int(11) NOT NULL COMMENT '小区id',
  373.   `openid` varchar(50) NOT NULL COMMENT '粉丝openid',
  374.   `realname` varchar(150) NOT NULL COMMENT '姓名',
  375.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  376.   `enable` int(1) NOT NULL COMMENT '是否开启',
  377.   `chargingid` text NOT NULL COMMENT '充电桩的id',
  378.   PRIMARY KEY (`id`)
  379. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='充电桩接收员';
  380. CREATE TABLE IF NOT EXISTS `ims_xcommunity_charging_order` (
  381.   `id` int(11) NOT NULL AUTO_INCREMENT,
  382.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  383.   `regionid` int(11) NOT NULL COMMENT '小区id',
  384.   `orderid` int(11) NOT NULL COMMENT '订单id',
  385.   `openid` varchar(50) NOT NULL,
  386.   `code` varchar(50) DEFAULT NULL,
  387.   `socket` int(11) NOT NULL COMMENT '插座号',
  388.   `cdtime` decimal(10,1) DEFAULT NULL,
  389.   `price` decimal(10,2) NOT NULL COMMENT '费用',
  390.   `status` int(1) NOT NULL COMMENT '订单状态,',
  391.   `cuid` varchar(50) NOT NULL COMMENT '充电id',
  392.   `createtime` int(11) NOT NULL COMMENT '下单时间',
  393.   `endtime` int(11) DEFAULT NULL,
  394.   `stime` decimal(10,2) DEFAULT NULL,
  395.   `power` int(11) DEFAULT NULL,
  396.   `type` tinyint(1) DEFAULT NULL,
  397.   `uid` int(11) DEFAULT NULL,
  398.   `isedit` tinyint(1) DEFAULT '0',
  399.   `cardno` varchar(50) DEFAULT NULL,
  400.   PRIMARY KEY (`id`)
  401. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';
  402. CREATE TABLE IF NOT EXISTS `ims_xcommunity_charging_price` (
  403.   `id` int(11) NOT NULL AUTO_INCREMENT,
  404.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  405.   `regionid` int(11) NOT NULL COMMENT '小区id',
  406.   `price` decimal(10,2) NOT NULL COMMENT '价格',
  407.   `cdtime` decimal(2,2) DEFAULT NULL,
  408.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  409.   `tid` int(11) NOT NULL COMMENT '投放id',
  410.   `type` int(1) DEFAULT '1',
  411.   `power` int(11) DEFAULT NULL,
  412.   PRIMARY KEY (`id`)
  413. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='价格表';
  414. CREATE TABLE IF NOT EXISTS `ims_xcommunity_charging_socket` (
  415.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  416.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  417.   `stationid` int(11) NOT NULL COMMENT '充电桩id',
  418.   `lock` int(3) NOT NULL COMMENT '插座的ID从0开始',
  419.   `enable` int(1) NOT NULL COMMENT '0空置',
  420.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间',
  421.   PRIMARY KEY (`id`)
  422. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='充电桩插座';
  423. CREATE TABLE IF NOT EXISTS `ims_xcommunity_charging_throw` (
  424.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  425.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  426.   `title` varchar(150) NOT NULL COMMENT '名称',
  427.   `realname` varchar(150) NOT NULL COMMENT '联系人',
  428.   `mobile` varchar(14) NOT NULL COMMENT '联系电话',
  429.   `address` varchar(250) NOT NULL COMMENT '地址',
  430.   `uid` int(11) NOT NULL,
  431.   `createtime` int(10) unsigned NOT NULL,
  432.   `quanbill` tinyint(1) DEFAULT NULL,
  433.   `quanrule` text,
  434.   `timebill` tinyint(1) DEFAULT NULL,
  435.   `status` tinyint(1) DEFAULT '0',
  436.   `timerule` varchar(255) DEFAULT NULL,
  437.   `credit` decimal(10,2) NOT NULL DEFAULT '0.00',
  438.   `desc` varchar(255) DEFAULT NULL,
  439.   PRIMARY KEY (`id`)
  440. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='充电桩-投放管理';
  441. CREATE TABLE IF NOT EXISTS `ims_xcommunity_chinaums` (
  442.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  443.   `uniacid` int(10) NOT NULL,
  444.   `type` int(1) NOT NULL COMMENT '新增类型1小区3商家4超市7充电桩8城乡直通车',
  445.   `userid` int(11) NOT NULL COMMENT '存小区id或者操作员id',
  446.   `uid` int(11) NOT NULL,
  447.   `mid` varchar(50) NOT NULL COMMENT '商户号',
  448.   `tid` varchar(50) NOT NULL COMMENT '终端号',
  449.   `instmid` varchar(50) NOT NULL COMMENT '机构商户号',
  450.   `msgsrc` varchar(50) NOT NULL COMMENT '消息来源',
  451.   `msgsrcid` varchar(50) NOT NULL COMMENT '来源编号',
  452.   `secret` varchar(50) NOT NULL COMMENT '测试环境md5密钥',
  453.   PRIMARY KEY (`id`)
  454. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='银联微信支付配置';
  455. CREATE TABLE IF NOT EXISTS `ims_xcommunity_commission_log` (
  456.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  457.   `uniacid` int(10) unsigned NOT NULL,
  458.   `realname` varchar(50) NOT NULL,
  459.   `uid` int(11) NOT NULL COMMENT '会员uid',
  460.   `type` int(1) NOT NULL COMMENT '1超市,2商家',
  461.   `cid` int(1) NOT NULL COMMENT '1小区,2平台',
  462.   `regionid` int(1) NOT NULL COMMENT '小区id',
  463.   `createtime` int(11) NOT NULL,
  464.   `orderid` int(11) NOT NULL,
  465.   `price` varchar(30) NOT NULL,
  466.   `good` varchar(100) NOT NULL,
  467.   `creditstatus` tinyint(1) DEFAULT '1',
  468.   `category` tinyint(1) DEFAULT '2',
  469.   PRIMARY KEY (`id`)
  470. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='提成记录';
  471. CREATE TABLE IF NOT EXISTS `ims_xcommunity_company` (
  472.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  473.   `uniacid` int(11) NOT NULL,
  474.   `title` varchar(50) NOT NULL,
  475.   `telephone` varchar(15) NOT NULL,
  476.   `uid` int(11) DEFAULT NULL,
  477.   PRIMARY KEY (`id`)
  478. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  479. CREATE TABLE IF NOT EXISTS `ims_xcommunity_cost` (
  480.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  481.   `weid` int(10) unsigned NOT NULL,
  482.   `createtime` int(10) unsigned NOT NULL,
  483.   `regionid` int(10) unsigned NOT NULL,
  484.   `costtime` varchar(30) NOT NULL,
  485.   `enable` int(1) NOT NULL,
  486.   `status` int(1) NOT NULL,
  487.   `uniacid` int(10) DEFAULT NULL,
  488.   `authtime` int(11) DEFAULT '0',
  489.   `auth` int(1) DEFAULT NULL,
  490.   `title` varchar(255) DEFAULT NULL,
  491.   `remark` text,
  492.   `pay_enable` tinyint(1) DEFAULT '0',
  493.   PRIMARY KEY (`id`)
  494. ) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
  495. CREATE TABLE IF NOT EXISTS `ims_xcommunity_cost_list` (
  496.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  497.   `weid` int(10) unsigned NOT NULL,
  498.   `regionid` int(10) unsigned NOT NULL,
  499.   `cid` int(10) unsigned NOT NULL,
  500.   `mobile` varchar(13) NOT NULL,
  501.   `username` varchar(30) NOT NULL,
  502.   `homenumber` varchar(255) DEFAULT NULL,
  503.   `costtime` varchar(30) NOT NULL,
  504.   `propertyfee` varchar(50) NOT NULL,
  505.   `otherfee` varchar(5000) NOT NULL,
  506.   `total` varchar(10) NOT NULL,
  507.   `createtime` int(10) unsigned NOT NULL,
  508.   `status` varchar(3) NOT NULL,
  509.   `paytype` tinyint(1) unsigned NOT NULL,
  510.   `transid` varchar(30) NOT NULL DEFAULT '0',
  511.   `fee` text,
  512.   `area` varchar(500) NOT NULL,
  513.   `remark` varchar(500) DEFAULT NULL,
  514.   `uniacid` int(10) DEFAULT NULL,
  515.   `address` varchar(50) DEFAULT NULL,
  516.   `credit1` int(11) DEFAULT NULL,
  517.   `paytime` int(10) DEFAULT NULL,
  518.   `displayorder` int(10) DEFAULT '0',
  519.   PRIMARY KEY (`id`)
  520. ) ENGINE=MyISAM AUTO_INCREMENT=992 DEFAULT CHARSET=utf8;
  521. CREATE TABLE IF NOT EXISTS `ims_xcommunity_cost_wechat` (
  522.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  523.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  524.   `openid` varchar(50) NOT NULL COMMENT '粉丝openid',
  525.   `realname` varchar(150) NOT NULL COMMENT '姓名',
  526.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  527.   `enable` int(1) NOT NULL COMMENT '是否开启',
  528.   `type` int(1) NOT NULL COMMENT '1微信2短信3全部',
  529.   `uid` int(11) NOT NULL,
  530.   `province` varchar(50) NOT NULL,
  531.   `city` varchar(50) NOT NULL,
  532.   `dist` varchar(50) NOT NULL,
  533.   PRIMARY KEY (`id`)
  534. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='费用接收员';
  535. CREATE TABLE IF NOT EXISTS `ims_xcommunity_cost_wechat_region` (
  536.   `id` int(11) NOT NULL AUTO_INCREMENT,
  537.   `cid` int(11) NOT NULL COMMENT '接收员id',
  538.   `regionid` int(11) NOT NULL COMMENT '小区id',
  539.   PRIMARY KEY (`id`)
  540. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  541. CREATE TABLE IF NOT EXISTS `ims_xcommunity_counter_code` (
  542.   `id` int(11) NOT NULL AUTO_INCREMENT,
  543.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  544.   `deviceid` int(11) NOT NULL COMMENT '主柜子id',
  545.   `orderid` int(11) NOT NULL COMMENT '订单id',
  546.   `code` int(4) NOT NULL COMMENT '开柜码',
  547.   `status` int(1) NOT NULL COMMENT '状态0未使用1管理员使用过2用户使用',
  548.   `createtime` int(11) NOT NULL COMMENT '时间',
  549.   PRIMARY KEY (`id`)
  550. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='智能货柜开柜码表';
  551. CREATE TABLE IF NOT EXISTS `ims_xcommunity_counter_little` (
  552.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  553.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  554.   `deviceid` int(11) NOT NULL COMMENT '主柜id',
  555.   `lock` int(1) NOT NULL COMMENT '锁的ID0-5',
  556.   `enable` int(1) NOT NULL COMMENT '货柜状态',
  557.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间',
  558.   `title` varchar(50) DEFAULT NULL,
  559.   `online` tinyint(1) DEFAULT '0',
  560.   PRIMARY KEY (`id`)
  561. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='智能货柜小柜';
  562. CREATE TABLE IF NOT EXISTS `ims_xcommunity_counter_littleid` (
  563.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  564.   `nid` int(11) NOT NULL COMMENT '管理员id',
  565.   `littleid` int(11) NOT NULL COMMENT '小柜子id',
  566.   PRIMARY KEY (`id`)
  567. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='智能货柜管理员附表';
  568. CREATE TABLE IF NOT EXISTS `ims_xcommunity_counter_log` (
  569.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  570.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  571.   `orderid` int(11) NOT NULL COMMENT '订单id',
  572.   `deviceid` int(11) NOT NULL COMMENT '主柜id',
  573.   `littleid` int(11) NOT NULL COMMENT '锁id',
  574.   `uid` int(11) NOT NULL COMMENT 'uid',
  575.   `openid` varchar(50) DEFAULT NULL,
  576.   `type` int(1) NOT NULL COMMENT '开启状态',
  577.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间',
  578.   `status` int(2) DEFAULT NULL,
  579.   PRIMARY KEY (`id`)
  580. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='智能货柜开柜记录';
  581. CREATE TABLE IF NOT EXISTS `ims_xcommunity_counter_main` (
  582.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  583.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  584.   `regionid` int(11) NOT NULL COMMENT '小区id',
  585.   `title` varchar(100) NOT NULL COMMENT '主柜子名称',
  586.   `buildid` int(11) NOT NULL COMMENT '楼栋id',
  587.   `device` varchar(100) NOT NULL COMMENT '设备id',
  588.   `uid` int(11) NOT NULL COMMENT 'uid',
  589.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间',
  590.   `type` tinyint(1) DEFAULT NULL,
  591.   `status` tinyint(1) DEFAULT NULL,
  592.   `appid` varchar(50) DEFAULT NULL,
  593.   `secret` varchar(50) DEFAULT NULL,
  594.   `amount` tinyint(2) DEFAULT NULL,
  595.   `stat` tinyint(1) DEFAULT NULL,
  596.   `rule` tinyint(1) DEFAULT NULL,
  597.   `price` decimal(10,2) DEFAULT NULL,
  598.   PRIMARY KEY (`id`)
  599. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='智能货柜主柜';
  600. CREATE TABLE IF NOT EXISTS `ims_xcommunity_counter_notice` (
  601.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  602.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  603.   `regionid` int(11) NOT NULL COMMENT '小区id',
  604.   `openid` varchar(50) NOT NULL COMMENT '粉丝openid',
  605.   `realname` varchar(150) NOT NULL COMMENT '姓名',
  606.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  607.   `enable` int(1) NOT NULL COMMENT '是否开启',
  608.   `type` int(1) NOT NULL COMMENT '1微信2短信3全部',
  609.   `littleid` text,
  610.   PRIMARY KEY (`id`)
  611. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='智能货柜接收员';
  612. CREATE TABLE IF NOT EXISTS `ims_xcommunity_coupon_order` (
  613.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  614.   `orderid` int(11) NOT NULL,
  615.   `couponsn` int(11) NOT NULL,
  616.   `status` int(1) NOT NULL,
  617.   `createtime` int(11) NOT NULL,
  618.   `usetime` int(11) NOT NULL,
  619.   `user` varchar(50) DEFAULT NULL,
  620.   `ip` varchar(50) DEFAULT NULL,
  621.   PRIMARY KEY (`id`)
  622. ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
  623. CREATE TABLE IF NOT EXISTS `ims_xcommunity_credit` (
  624.   `id` int(11) NOT NULL AUTO_INCREMENT,
  625.   `uniacid` int(11) NOT NULL,
  626.   `uid` int(11) NOT NULL,
  627.   `realname` varchar(150) NOT NULL,
  628.   `mobile` varchar(14) NOT NULL,
  629.   `content` varchar(255) NOT NULL COMMENT '积分用途',
  630.   `credit` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '积分数量',
  631.   `type` tinyint(1) NOT NULL COMMENT '1物业2商家3超市4活动5账单6报修7充电桩8云柜',
  632.   `typeid` int(11) NOT NULL,
  633.   `creditstatus` tinyint(1) NOT NULL COMMENT '1增加2减少',
  634.   `createtime` int(11) NOT NULL,
  635.   `category` tinyint(1) NOT NULL COMMENT '1积分2余额3商家积分4商家余额',
  636.   `usename` varchar(150) NOT NULL COMMENT '操作人',
  637.   PRIMARY KEY (`id`)
  638. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='积分余额操作明细';
  639. CREATE TABLE IF NOT EXISTS `ims_xcommunity_department` (
  640.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  641.   `uniacid` int(11) NOT NULL,
  642.   `pid` int(11) NOT NULL,
  643.   `title` varchar(255) NOT NULL,
  644.   `createtime` int(11) NOT NULL,
  645.   `uid` int(11) DEFAULT NULL,
  646.   PRIMARY KEY (`id`)
  647. ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  648. CREATE TABLE IF NOT EXISTS `ims_xcommunity_dp` (
  649.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  650.   `weid` int(10) unsigned NOT NULL,
  651.   `uid` int(11) NOT NULL,
  652.   `regionid` text NOT NULL,
  653.   `sjname` varchar(30) NOT NULL,
  654.   `picurl` varchar(1000) NOT NULL,
  655.   `contactname` varchar(30) NOT NULL,
  656.   `mobile` varchar(12) NOT NULL,
  657.   `phone` varchar(15) NOT NULL,
  658.   `qq` int(11) NOT NULL,
  659.   `province` varchar(50) NOT NULL,
  660.   `city` varchar(50) NOT NULL,
  661.   `dist` varchar(50) NOT NULL,
  662.   `address` varchar(150) NOT NULL,
  663.   `shopdesc` varchar(500) NOT NULL,
  664.   `businesstime` varchar(50) NOT NULL,
  665.   `businessurl` text,
  666.   `createtime` int(10) unsigned NOT NULL,
  667.   `lat` varchar(20) NOT NULL,
  668.   `lng` varchar(20) NOT NULL,
  669.   `parent` int(11) NOT NULL,
  670.   `child` int(11) NOT NULL,
  671.   `rid` int(11) NOT NULL,
  672.   `displayorder` int(11) NOT NULL,
  673.   `price` int(11) NOT NULL,
  674.   `area` varchar(50) NOT NULL,
  675.   `instruction` varchar(50) NOT NULL,
  676.   `uniacid` int(10) DEFAULT NULL,
  677.   `cid` int(1) DEFAULT NULL,
  678.   `tag` varchar(255) DEFAULT NULL,
  679.   `creditpay` int(1) DEFAULT NULL,
  680.   `setting` text,
  681.   `commission` varchar(50) DEFAULT '0,0',
  682.   `status` tinyint(1) DEFAULT NULL,
  683.   `serviceurl` text,
  684.   `cardurl` text,
  685.   `activityurl` text,
  686.   PRIMARY KEY (`id`)
  687. ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
  688. CREATE TABLE IF NOT EXISTS `ims_xcommunity_dp_fee` (
  689.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  690.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  691.   `uid` int(11) NOT NULL,
  692.   `dpid` int(11) NOT NULL,
  693.   `openid` varchar(50) NOT NULL,
  694.   `total` decimal(10,2) NOT NULL,
  695.   `price` decimal(10,2) NOT NULL,
  696.   `createtime` int(11) NOT NULL,
  697.   `orderid` varchar(50) NOT NULL,
  698.   `credit` decimal(10,2) NOT NULL COMMENT '积分',
  699.   `status` int(1) DEFAULT NULL,
  700.   PRIMARY KEY (`id`)
  701. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='消费记录';
  702. CREATE TABLE IF NOT EXISTS `ims_xcommunity_entery` (
  703.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  704.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  705.   `regionid` int(11) NOT NULL,
  706.   `uid` int(11) NOT NULL,
  707.   `realname` varchar(50) NOT NULL COMMENT '姓名',
  708.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  709.   `address` varchar(250) NOT NULL COMMENT '地址',
  710.   `type` int(2) NOT NULL COMMENT '1为水表2为气表3为电表',
  711.   `old_num` decimal(10,2) NOT NULL COMMENT '上期度数',
  712.   `number` decimal(10,2) NOT NULL COMMENT '本期度数',
  713.   `fee` decimal(10,2) NOT NULL,
  714.   `createtime` int(11) NOT NULL,
  715.   `category` int(11) NOT NULL,
  716.   `status` int(1) DEFAULT NULL,
  717.   `paytype` int(1) DEFAULT NULL,
  718.   `paytime` int(11) DEFAULT NULL,
  719.   PRIMARY KEY (`id`)
  720. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='抄表';
  721. CREATE TABLE IF NOT EXISTS `ims_xcommunity_entery_log` (
  722.   `id` int(11) NOT NULL AUTO_INCREMENT,
  723.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  724.   `uid` int(11) NOT NULL,
  725.   `createtime` int(11) NOT NULL COMMENT '生成时间',
  726.   `regionid` int(11) NOT NULL,
  727.   `category` varchar(50) DEFAULT NULL,
  728.   `num` int(11) NOT NULL COMMENT '数量',
  729.   `region` varchar(50) DEFAULT NULL,
  730.   PRIMARY KEY (`id`)
  731. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='抄表生成记录';
  732. CREATE TABLE IF NOT EXISTS `ims_xcommunity_express_collecting` (
  733.   `id` int(11) NOT NULL AUTO_INCREMENT,
  734.   `uniacid` int(11) NOT NULL,
  735.   `name` varchar(50) NOT NULL COMMENT '名称',
  736.   `mobile` varchar(50) NOT NULL COMMENT '手机号',
  737.   `openid` varchar(255) NOT NULL,
  738.   `companyid` int(11) NOT NULL COMMENT '物流公司',
  739.   `createtime` int(10) NOT NULL COMMENT '创建时间',
  740.   PRIMARY KEY (`id`)
  741. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='代收点';
  742. CREATE TABLE IF NOT EXISTS `ims_xcommunity_express_company` (
  743.   `id` int(11) NOT NULL AUTO_INCREMENT,
  744.   `uniacid` int(10) NOT NULL,
  745.   `company` varchar(50) NOT NULL COMMENT '物流公司',
  746.   `phone` varchar(50) NOT NULL COMMENT '物流电话(站点电话)',
  747.   `createtime` int(10) NOT NULL COMMENT '创建时间',
  748.   `logo` varchar(255) NOT NULL,
  749.   PRIMARY KEY (`id`)
  750. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='物流公司表';
  751. CREATE TABLE IF NOT EXISTS `ims_xcommunity_express_linkman` (
  752.   `id` int(11) NOT NULL AUTO_INCREMENT,
  753.   `uniacid` int(11) NOT NULL,
  754.   `realname` varchar(50) NOT NULL COMMENT '姓名',
  755.   `phone` varchar(50) NOT NULL COMMENT '手机号',
  756.   `openid` varchar(255) NOT NULL,
  757.   `address` varchar(100) NOT NULL COMMENT '地址',
  758.   `address_detail` varchar(100) NOT NULL COMMENT '详细地址',
  759.   `createtime` int(10) NOT NULL COMMENT '创建时间',
  760.   `status` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '身份:1寄件人/收件人',
  761.   `uid` int(11) DEFAULT NULL,
  762.   `area` varchar(255) DEFAULT NULL,
  763.   PRIMARY KEY (`id`)
  764. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='寄件人表';
  765. CREATE TABLE IF NOT EXISTS `ims_xcommunity_express_parcel` (
  766.   `id` int(11) NOT NULL AUTO_INCREMENT,
  767.   `uniacid` int(11) NOT NULL,
  768.   `sender` varchar(50) NOT NULL COMMENT '寄件人(关联联系人表)',
  769.   `recipients` varchar(50) NOT NULL COMMENT '收件人(关联联系人表)',
  770.   `name` varchar(50) NOT NULL COMMENT '收件人姓名',
  771.   `phone` varchar(50) NOT NULL COMMENT '收件人手机号',
  772.   `openid` varchar(100) NOT NULL COMMENT '寄件人openid',
  773.   `address` varchar(255) NOT NULL COMMENT '收件人地址',
  774.   `address_detail` varchar(255) NOT NULL COMMENT '收件人详细地址',
  775.   `company` varchar(50) NOT NULL COMMENT '物流公司',
  776.   `waybillcode` varchar(50) NOT NULL COMMENT '运单号',
  777.   `cargocode` varchar(50) NOT NULL COMMENT '编号',
  778.   `pick_code` varchar(50) NOT NULL COMMENT '取货码',
  779.   `goodstatus` varchar(50) NOT NULL COMMENT '寄件类型',
  780.   `price` varchar(30) NOT NULL COMMENT '预估价格',
  781.   `arrivetime` int(10) unsigned NOT NULL COMMENT '到站时间',
  782.   `overtime` int(10) unsigned NOT NULL COMMENT '取货时间',
  783.   `remark` varchar(255) NOT NULL COMMENT '备注',
  784.   `status` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '物流状态:1未发货/2已发货/3已代收/4已取件',
  785.   `weight` varchar(50) DEFAULT NULL COMMENT '物品重量',
  786.   `collecter` varchar(100) NOT NULL COMMENT '代收人openid',
  787.   `createtime` int(10) NOT NULL COMMENT '创建时间',
  788.   `uid` int(11) DEFAULT NULL,
  789.   PRIMARY KEY (`id`)
  790. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='快递表';
  791. CREATE TABLE IF NOT EXISTS `ims_xcommunity_express_piecework` (
  792.   `id` int(11) NOT NULL AUTO_INCREMENT,
  793.   `uniacid` int(11) NOT NULL,
  794.   `price` varchar(30) NOT NULL COMMENT '基础价格',
  795.   `overprice` varchar(30) NOT NULL COMMENT '超重价格',
  796.   `mailaddress` varchar(100) NOT NULL COMMENT '寄件地址',
  797.   `receiveaddress` varchar(100) NOT NULL COMMENT '收件地址',
  798.   `companyid` int(11) NOT NULL COMMENT '物流公司',
  799.   `typeid` int(11) NOT NULL COMMENT '类型',
  800.   PRIMARY KEY (`id`)
  801. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='快递价格表';
  802. CREATE TABLE IF NOT EXISTS `ims_xcommunity_express_save` (
  803.   `id` int(11) NOT NULL AUTO_INCREMENT,
  804.   `uniacid` int(11) NOT NULL,
  805.   `waybillcode` varchar(50) NOT NULL COMMENT '运单号',
  806.   `name` varchar(50) NOT NULL COMMENT '收件人姓名',
  807.   `mobile` varchar(50) NOT NULL COMMENT '手机号',
  808.   `company` varchar(50) NOT NULL COMMENT '物流公司',
  809.   `pick_code` varchar(50) NOT NULL COMMENT '取货码',
  810.   `status` int(1) unsigned NOT NULL COMMENT '物流状态:3已代收(未取件)/4已取件',
  811.   `openid` varchar(255) NOT NULL COMMENT '代收人openid',
  812.   `createtime` int(10) NOT NULL COMMENT '入库时间',
  813.   `overtime` int(10) unsigned NOT NULL COMMENT '取货时间',
  814.   PRIMARY KEY (`id`)
  815. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='入库管理';
  816. CREATE TABLE IF NOT EXISTS `ims_xcommunity_express_save_log` (
  817.   `id` int(11) NOT NULL AUTO_INCREMENT,
  818.   `uniacid` int(11) NOT NULL,
  819.   `waybillcode` varchar(50) NOT NULL COMMENT '运单号',
  820.   `saveid` int(11) NOT NULL COMMENT '入库出库id',
  821.   `type` int(1) unsigned NOT NULL COMMENT '1入库/2出库',
  822.   `createtime` int(10) NOT NULL COMMENT '入库/出库时间',
  823.   PRIMARY KEY (`id`)
  824. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='入库出库记录';
  825. CREATE TABLE IF NOT EXISTS `ims_xcommunity_express_type` (
  826.   `id` int(11) NOT NULL AUTO_INCREMENT,
  827.   `uniacid` int(11) NOT NULL,
  828.   `type` varchar(50) NOT NULL COMMENT '类型',
  829.   `content` varchar(255) NOT NULL COMMENT '备注',
  830.   `createtime` int(10) NOT NULL COMMENT '创建时间',
  831.   PRIMARY KEY (`id`)
  832. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='寄件类型';
  833. CREATE TABLE IF NOT EXISTS `ims_xcommunity_face_logs` (
  834.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  835.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  836.   `personguid` varchar(50) NOT NULL COMMENT '人员guid,陌生人为STRANGERBABY,人证比对为IDCARDBABY',
  837.   `devicekey` varchar(50) NOT NULL COMMENT '设备序列号',
  838.   `photourl` varchar(255) NOT NULL,
  839.   `type` tinyint(1) NOT NULL COMMENT '识别出的人员类型,0:时间段内,1:时间段外,2:陌生人',
  840.   `recmode` tinyint(1) NOT NULL COMMENT '//识别模式,1:刷脸,2:刷卡,3:双重认证, 4:人证比对',
  841.   `idcardinfo` text NOT NULL COMMENT '人证比对详细',
  842.   `createtime` int(11) NOT NULL,
  843.   `subdata` text NOT NULL COMMENT '人员附属信息',
  844.   PRIMARY KEY (`id`)
  845. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='人脸门禁人员识别记录';
  846. CREATE TABLE IF NOT EXISTS `ims_xcommunity_face_uploadlogs` (
  847.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  848.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  849.   `uid` int(11) NOT NULL COMMENT '会员的uid',
  850.   `realname` varchar(50) NOT NULL COMMENT '姓名',
  851.   `createtime` int(11) NOT NULL,
  852.   `images` text NOT NULL COMMENT '人脸图片',
  853.   `deviceids` varchar(255) NOT NULL COMMENT '设备的id 多个',
  854.   PRIMARY KEY (`id`)
  855. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='人脸门禁人员上传记录';
  856. CREATE TABLE IF NOT EXISTS `ims_xcommunity_face_users` (
  857.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  858.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  859.   `uid` int(11) NOT NULL COMMENT '会员的uid',
  860.   `guid` varchar(50) NOT NULL COMMENT '人脸授权的guid',
  861.   `realname` varchar(50) NOT NULL COMMENT '姓名',
  862.   `mobile` varchar(14) NOT NULL COMMENT '手机号',
  863.   `idcard` varchar(50) NOT NULL COMMENT '卡号',
  864.   `createtime` int(11) NOT NULL,
  865.   `images` text NOT NULL COMMENT '人脸图片',
  866.   `status` tinyint(1) NOT NULL COMMENT '授权状态',
  867.   `deviceids` varchar(255) NOT NULL COMMENT '设备的id 多个',
  868.   `type` tinyint(1) DEFAULT '2',
  869.   `userid` int(11) DEFAULT NULL,
  870.   PRIMARY KEY (`id`)
  871. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='人脸门禁人员授权';
  872. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee` (
  873.   `id` int(11) NOT NULL AUTO_INCREMENT,
  874.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  875.   `categoryid` int(11) NOT NULL,
  876.   `roomid` int(11) NOT NULL,
  877.   `starttime` int(11) NOT NULL,
  878.   `endtime` int(11) NOT NULL,
  879.   `status` int(1) NOT NULL,
  880.   `price` decimal(12,2) NOT NULL,
  881.   `pay_price` decimal(12,2) NOT NULL,
  882.   `rate` decimal(12,2) DEFAULT NULL,
  883.   `paytype` int(1) DEFAULT NULL,
  884.   `createtime` int(11) DEFAULT NULL,
  885.   `uid` int(11) DEFAULT NULL,
  886.   `type` int(1) DEFAULT '1',
  887.   `old_num` decimal(10,2) DEFAULT NULL,
  888.   `new_num` decimal(10,2) DEFAULT NULL,
  889.   `paytime` int(11) DEFAULT NULL,
  890.   `username` varchar(50) DEFAULT NULL,
  891.   `logid` int(11) DEFAULT NULL,
  892.   `regionid` int(11) DEFAULT NULL,
  893.   `displayorder` int(10) DEFAULT '0',
  894.   `readername` varchar(50) DEFAULT NULL,
  895.   `remark` text,
  896.   `pay_status` tinyint(1) DEFAULT '1',
  897.   PRIMARY KEY (`id`)
  898. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  899. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_category` (
  900.   `id` int(11) NOT NULL AUTO_INCREMENT,
  901.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  902.   `pid` int(11) NOT NULL,
  903.   `uid` int(11) NOT NULL,
  904.   `regionid` int(11) NOT NULL,
  905.   `title` varchar(50) DEFAULT NULL,
  906.   `way` int(2) NOT NULL,
  907.   `unit` varchar(50) NOT NULL,
  908.   `price` varchar(30) NOT NULL,
  909.   `cycle` int(1) NOT NULL,
  910.   `rate` varchar(30) NOT NULL,
  911.   `start_day` int(11) NOT NULL,
  912.   `discount` varchar(11) DEFAULT NULL,
  913.   `remark` varchar(255) NOT NULL,
  914.   `status` int(1) NOT NULL,
  915.   `square` int(11) DEFAULT NULL,
  916.   `type` int(1) DEFAULT NULL,
  917.   PRIMARY KEY (`id`)
  918. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  919. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_category_build` (
  920.   `id` int(11) NOT NULL AUTO_INCREMENT,
  921.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  922.   `caetgoryid` int(11) NOT NULL,
  923.   `buildid` int(11) NOT NULL,
  924.   PRIMARY KEY (`id`)
  925. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  926. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_group` (
  927.   `id` int(11) NOT NULL AUTO_INCREMENT,
  928.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  929.   `pid` int(11) NOT NULL,
  930.   `uid` int(11) NOT NULL,
  931.   `regionid` int(11) NOT NULL,
  932.   `title` varchar(50) DEFAULT NULL,
  933.   `remark` varchar(255) NOT NULL,
  934.   `status` int(1) NOT NULL,
  935.   PRIMARY KEY (`id`)
  936. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  937. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_group_build` (
  938.   `id` int(11) NOT NULL AUTO_INCREMENT,
  939.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  940.   `groupid` int(11) NOT NULL,
  941.   `buildid` int(11) NOT NULL,
  942.   PRIMARY KEY (`id`)
  943. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  944. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_group_category` (
  945.   `id` int(11) NOT NULL AUTO_INCREMENT,
  946.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  947.   `groupid` int(11) NOT NULL,
  948.   `categoryid` int(11) NOT NULL,
  949.   PRIMARY KEY (`id`)
  950. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  951. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_log` (
  952.   `id` int(11) NOT NULL AUTO_INCREMENT,
  953.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  954.   `regionid` int(11) NOT NULL,
  955.   `title` varchar(50) NOT NULL,
  956.   `remark` varchar(255) NOT NULL,
  957.   `status` int(1) NOT NULL,
  958.   `endtime` int(11) DEFAULT NULL,
  959.   `starttime` int(11) DEFAULT NULL,
  960.   PRIMARY KEY (`id`)
  961. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  962. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_log_category` (
  963.   `id` int(11) NOT NULL AUTO_INCREMENT,
  964.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  965.   `logid` int(11) NOT NULL,
  966.   `categoryid` int(11) NOT NULL,
  967.   PRIMARY KEY (`id`)
  968. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  969. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_order` (
  970.   `id` int(11) NOT NULL AUTO_INCREMENT,
  971.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  972.   `feeid` int(11) NOT NULL,
  973.   `paytype` int(1) NOT NULL COMMENT '支付方式',
  974.   `rate` varchar(30) NOT NULL,
  975.   `rate_price` decimal(12,2) NOT NULL,
  976.   `rate_day` int(11) NOT NULL,
  977.   `price` decimal(12,2) NOT NULL,
  978.   `status` int(1) NOT NULL,
  979.   `remark` text NOT NULL,
  980.   `createtime` int(11) NOT NULL,
  981.   PRIMARY KEY (`id`)
  982. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  983. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_wechat` (
  984.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  985.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  986.   `openid` varchar(50) NOT NULL COMMENT '粉丝openid',
  987.   `realname` varchar(150) NOT NULL COMMENT '姓名',
  988.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  989.   `uid` int(11) NOT NULL,
  990.   `regionid` int(11) NOT NULL COMMENT '小区id',
  991.   PRIMARY KEY (`id`)
  992. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='抄表处理员';
  993. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fee_wechat_category` (
  994.   `id` int(11) NOT NULL AUTO_INCREMENT,
  995.   `fid` int(11) NOT NULL COMMENT '接收员id',
  996.   `categoryid` int(11) NOT NULL COMMENT '收费项目id',
  997.   PRIMARY KEY (`id`)
  998. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  999. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fled` (
  1000.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1001.   `weid` int(10) unsigned NOT NULL,
  1002.   `openid` varchar(50) NOT NULL,
  1003.   `title` varchar(20) NOT NULL,
  1004.   `rolex` varchar(30) NOT NULL,
  1005.   `category` int(11) NOT NULL,
  1006.   `zprice` int(10) NOT NULL,
  1007.   `yprice` int(10) NOT NULL,
  1008.   `realname` varchar(18) NOT NULL,
  1009.   `mobile` varchar(12) NOT NULL,
  1010.   `description` varchar(100) NOT NULL,
  1011.   `regionid` int(10) NOT NULL,
  1012.   `createtime` int(11) NOT NULL,
  1013.   `status` int(11) NOT NULL,
  1014.   `images` text,
  1015.   `black` int(1) NOT NULL,
  1016.   `enable` tinyint(1) unsigned NOT NULL,
  1017.   `cate` tinyint(1) unsigned NOT NULL,
  1018.   `uniacid` int(10) DEFAULT NULL,
  1019.   `uid` int(11) DEFAULT NULL,
  1020.   `addressid` int(11) DEFAULT NULL,
  1021.   `type` int(1) DEFAULT '0',
  1022.   `recommand` tinyint(1) DEFAULT '0',
  1023.   PRIMARY KEY (`id`)
  1024. ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
  1025. CREATE TABLE IF NOT EXISTS `ims_xcommunity_fled_images` (
  1026.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  1027.   `fledid` int(11) NOT NULL COMMENT '二手id',
  1028.   `thumbid` int(11) NOT NULL COMMENT '图片id',
  1029.   PRIMARY KEY (`id`)
  1030. ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='图片关联表';
  1031. CREATE TABLE IF NOT EXISTS `ims_xcommunity_footmenu` (
  1032.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1033.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1034.   `displayorder` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  1035.   `icon` varchar(250) NOT NULL COMMENT '显示的图片',
  1036.   `click_icon` varchar(250) NOT NULL COMMENT '点击后的图片',
  1037.   `url` varchar(250) NOT NULL COMMENT '外链',
  1038.   `title` varchar(50) NOT NULL COMMENT '名称',
  1039.   `type` tinyint(1) NOT NULL COMMENT '菜单动作1默认微信开门2外链3默认公告',
  1040.   `enable` tinyint(1) NOT NULL COMMENT '是否开启',
  1041.   PRIMARY KEY (`id`)
  1042. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='底部菜单表';
  1043. CREATE TABLE IF NOT EXISTS `ims_xcommunity_footmenu_region` (
  1044.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1045.   `fid` int(11) NOT NULL COMMENT '菜单id',
  1046.   `regionid` int(11) NOT NULL COMMENT '小区id',
  1047.   PRIMARY KEY (`id`)
  1048. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1049. CREATE TABLE IF NOT EXISTS `ims_xcommunity_goods` (
  1050.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1051.   `weid` int(10) unsigned NOT NULL,
  1052.   `pcate` int(10) unsigned NOT NULL DEFAULT '0',
  1053.   `child` int(11) NOT NULL,
  1054.   `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  1055.   `displayorder` int(10) unsigned NOT NULL DEFAULT '0',
  1056.   `title` varchar(100) NOT NULL DEFAULT '',
  1057.   `thumb` varchar(255) DEFAULT '',
  1058.   `thumb_url` text,
  1059.   `unit` varchar(5) NOT NULL DEFAULT '',
  1060.   `content` text NOT NULL,
  1061.   `description` text NOT NULL,
  1062.   `instruction` varchar(50) NOT NULL,
  1063.   `marketprice` decimal(10,2) NOT NULL DEFAULT '0.00',
  1064.   `productprice` decimal(10,2) NOT NULL DEFAULT '0.00',
  1065.   `total` int(10) NOT NULL DEFAULT '0',
  1066.   `createtime` int(10) unsigned NOT NULL,
  1067.   `credit` int(11) DEFAULT '0',
  1068.   `isrecommand` int(11) DEFAULT '0',
  1069.   `type` int(11) DEFAULT '0',
  1070.   `dpid` int(11) DEFAULT '0',
  1071.   `sold` int(11) DEFAULT '0',
  1072.   `uid` int(11) NOT NULL,
  1073.   `regionid` text,
  1074.   `starttime` int(11) NOT NULL,
  1075.   `endtime` int(11) NOT NULL,
  1076.   `province` varchar(50) NOT NULL,
  1077.   `city` varchar(50) NOT NULL,
  1078.   `dist` varchar(50) NOT NULL,
  1079.   `uniacid` int(10) DEFAULT NULL,
  1080.   `sort` int(10) DEFAULT NULL,
  1081.   `thumbs` text,
  1082.   `recommand` int(1) DEFAULT '0',
  1083.   `wlinks` varchar(255) DEFAULT NULL,
  1084.   `littleid` int(11) DEFAULT NULL,
  1085.   `shopid` int(11) DEFAULT NULL,
  1086.   `allregion` int(1) DEFAULT NULL,
  1087.   `counterid` int(11) DEFAULT NULL,
  1088.   `isshow` int(1) DEFAULT '0',
  1089.   `limitnum` int(11) DEFAULT NULL,
  1090.   `startdate` int(11) DEFAULT NULL,
  1091.   `enddate` int(11) DEFAULT NULL,
  1092.   `rules` text,
  1093.   `combo` text,
  1094.   `common` text,
  1095.   PRIMARY KEY (`id`)
  1096. ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  1097. CREATE TABLE IF NOT EXISTS `ims_xcommunity_goods_region` (
  1098.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1099.   `gid` int(10) unsigned NOT NULL,
  1100.   `regionid` int(10) unsigned NOT NULL,
  1101.   PRIMARY KEY (`id`)
  1102. ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
  1103. CREATE TABLE IF NOT EXISTS `ims_xcommunity_guard_group` (
  1104.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1105.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1106.   `pid` int(11) NOT NULL,
  1107.   `uid` int(11) NOT NULL,
  1108.   `regionid` int(11) NOT NULL,
  1109.   `title` varchar(50) DEFAULT NULL,
  1110.   `remark` varchar(255) NOT NULL,
  1111.   `status` int(1) NOT NULL,
  1112.   PRIMARY KEY (`id`)
  1113. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1114. CREATE TABLE IF NOT EXISTS `ims_xcommunity_guard_group_build` (
  1115.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1116.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1117.   `groupid` int(11) NOT NULL,
  1118.   `buildid` int(11) NOT NULL,
  1119.   PRIMARY KEY (`id`)
  1120. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1121. CREATE TABLE IF NOT EXISTS `ims_xcommunity_guard_group_category` (
  1122.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1123.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1124.   `groupid` int(11) NOT NULL,
  1125.   `categoryid` int(11) NOT NULL,
  1126.   PRIMARY KEY (`id`)
  1127. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1128. CREATE TABLE IF NOT EXISTS `ims_xcommunity_home` (
  1129.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1130.   `uniacid` int(11) NOT NULL,
  1131.   `sort` varchar(30) NOT NULL,
  1132.   `status` int(1) NOT NULL,
  1133.   `displayorder` int(11) NOT NULL,
  1134.   `enable` int(1) DEFAULT NULL,
  1135.   PRIMARY KEY (`id`)
  1136. ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
  1137. CREATE TABLE IF NOT EXISTS `ims_xcommunity_homefee_pact_save` (
  1138.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1139.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1140.   `uid` int(11) NOT NULL,
  1141.   `thumb` varchar(250) NOT NULL COMMENT '图片',
  1142.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  1143.   PRIMARY KEY (`id`)
  1144. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='合同存档';
  1145. CREATE TABLE IF NOT EXISTS `ims_xcommunity_homemaking` (
  1146.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1147.   `weid` int(10) unsigned NOT NULL,
  1148.   `openid` varchar(50) NOT NULL,
  1149.   `regionid` int(10) unsigned NOT NULL,
  1150.   `category` int(11) NOT NULL,
  1151.   `servicetime` varchar(30) NOT NULL,
  1152.   `realname` varchar(30) NOT NULL,
  1153.   `mobile` varchar(15) NOT NULL,
  1154.   `address` varchar(100) NOT NULL,
  1155.   `content` varchar(500) NOT NULL,
  1156.   `status` int(10) unsigned NOT NULL,
  1157.   `createtime` int(10) unsigned NOT NULL,
  1158.   `uniacid` int(10) DEFAULT NULL,
  1159.   `addressid` int(11) DEFAULT NULL,
  1160.   `uid` int(11) DEFAULT NULL,
  1161.   `remark` text,
  1162.   PRIMARY KEY (`id`)
  1163. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  1164. CREATE TABLE IF NOT EXISTS `ims_xcommunity_homemaking_list` (
  1165.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1166.   `uniacid` int(11) NOT NULL,
  1167.   `uid` int(11) NOT NULL,
  1168.   `cid` varchar(30) NOT NULL,
  1169.   `service` text NOT NULL,
  1170.   `price` text NOT NULL,
  1171.   `content` text NOT NULL,
  1172.   PRIMARY KEY (`id`)
  1173. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='家政详情';
  1174. CREATE TABLE IF NOT EXISTS `ims_xcommunity_housecenter` (
  1175.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1176.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1177.   `displayorder` int(10) NOT NULL COMMENT '排序',
  1178.   `pcate` int(10) NOT NULL COMMENT '一级分类id',
  1179.   `title` varchar(30) NOT NULL COMMENT '标题',
  1180.   `url` varchar(255) NOT NULL COMMENT '链接',
  1181.   `status` int(1) NOT NULL COMMENT '展示',
  1182.   `icon` varchar(50) NOT NULL COMMENT '图标',
  1183.   `thumb` varchar(255) NOT NULL COMMENT '图片',
  1184.   `enable` int(1) DEFAULT NULL,
  1185.   PRIMARY KEY (`id`)
  1186. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1187. CREATE TABLE IF NOT EXISTS `ims_xcommunity_housecenter_region` (
  1188.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1189.   `nid` int(11) NOT NULL COMMENT '菜单id',
  1190.   `regionid` int(11) NOT NULL COMMENT '小区id',
  1191.   PRIMARY KEY (`id`)
  1192. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1193. CREATE TABLE IF NOT EXISTS `ims_xcommunity_houselease` (
  1194.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1195.   `weid` int(10) unsigned NOT NULL,
  1196.   `openid` varchar(50) NOT NULL,
  1197.   `regionid` int(10) unsigned NOT NULL,
  1198.   `category` int(11) NOT NULL,
  1199.   `way` varchar(20) NOT NULL,
  1200.   `model_room` int(11) NOT NULL,
  1201.   `model_hall` int(11) NOT NULL,
  1202.   `model_toilet` int(11) NOT NULL,
  1203.   `model_area` varchar(15) NOT NULL,
  1204.   `floor_layer` int(11) NOT NULL,
  1205.   `floor_number` int(11) NOT NULL,
  1206.   `fitment` varchar(40) NOT NULL,
  1207.   `house` varchar(40) NOT NULL,
  1208.   `allocation` varchar(500) NOT NULL,
  1209.   `price_way` varchar(30) NOT NULL,
  1210.   `price` int(10) unsigned NOT NULL,
  1211.   `checktime` varchar(30) NOT NULL,
  1212.   `title` varchar(30) NOT NULL,
  1213.   `realname` varchar(30) NOT NULL,
  1214.   `mobile` varchar(15) NOT NULL,
  1215.   `content` varchar(500) NOT NULL,
  1216.   `status` int(10) unsigned NOT NULL,
  1217.   `createtime` int(10) unsigned NOT NULL,
  1218.   `enable` tinyint(1) unsigned NOT NULL,
  1219.   `images` text,
  1220.   `uniacid` int(10) DEFAULT NULL,
  1221.   `uid` int(11) DEFAULT NULL,
  1222.   `displayorder` int(11) DEFAULT NULL,
  1223.   `xqtitle` varchar(50) DEFAULT NULL,
  1224.   `house_aspect` varchar(30) DEFAULT NULL,
  1225.   `house_model` varchar(50) DEFAULT NULL,
  1226.   `house_floor` varchar(50) DEFAULT NULL,
  1227.   `recommand` tinyint(1) DEFAULT '0',
  1228.   PRIMARY KEY (`id`)
  1229. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
  1230. CREATE TABLE IF NOT EXISTS `ims_xcommunity_houselease_images` (
  1231.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  1232.   `houseid` int(11) NOT NULL COMMENT '房屋租赁id',
  1233.   `thumbid` int(11) NOT NULL COMMENT '图片id',
  1234.   PRIMARY KEY (`id`)
  1235. ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='图片关联表';
  1236. CREATE TABLE IF NOT EXISTS `ims_xcommunity_hsyunfu` (
  1237.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1238.   `uniacid` int(10) NOT NULL,
  1239.   `type` int(1) NOT NULL COMMENT '新增类型',
  1240.   `userid` int(11) NOT NULL COMMENT '存小区id或者操作员id',
  1241.   `account` varchar(50) NOT NULL,
  1242.   `secret` varchar(50) NOT NULL,
  1243.   `uid` int(11) NOT NULL,
  1244.   `appid` varchar(50) NOT NULL,
  1245.   `appsecret` varchar(50) NOT NULL,
  1246.   PRIMARY KEY (`id`)
  1247. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='华商云付微信支付配置';
  1248. CREATE TABLE IF NOT EXISTS `ims_xcommunity_images` (
  1249.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1250.   `src` varchar(255) DEFAULT NULL,
  1251.   `file` longtext,
  1252.   PRIMARY KEY (`id`)
  1253. ) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
  1254. CREATE TABLE IF NOT EXISTS `ims_xcommunity_member` (
  1255.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1256.   `weid` int(11) unsigned NOT NULL,
  1257.   `regionid` int(10) unsigned NOT NULL,
  1258.   `memberid` int(10) NOT NULL,
  1259.   `openid` varchar(50) NOT NULL,
  1260.   `realname` varchar(50) NOT NULL,
  1261.   `mobile` varchar(15) NOT NULL,
  1262.   `regionname` varchar(50) NOT NULL,
  1263.   `build` varchar(50) NOT NULL,
  1264.   `unit` int(10) NOT NULL,
  1265.   `room` varchar(50) NOT NULL,
  1266.   `address` varchar(100) NOT NULL,
  1267.   `remark` varchar(1000) NOT NULL,
  1268.   `status` tinyint(1) unsigned NOT NULL,
  1269.   `type` tinyint(1) unsigned NOT NULL,
  1270.   `enable` tinyint(1) unsigned NOT NULL,
  1271.   `open_status` tinyint(1) unsigned NOT NULL,
  1272.   `createtime` int(10) unsigned NOT NULL,
  1273.   `open_openid` varchar(50) DEFAULT NULL,
  1274.   `uniacid` int(11) DEFAULT NULL,
  1275.   `uid` int(11) DEFAULT NULL,
  1276.   `visit` int(1) DEFAULT '0',
  1277.   `license` varchar(20) DEFAULT NULL,
  1278.   `idcard` varchar(30) DEFAULT NULL,
  1279.   `contract` varchar(30) DEFAULT NULL,
  1280.   `opentime` int(11) DEFAULT '0',
  1281.   `groupid` int(11) DEFAULT NULL,
  1282.   `open_door` tinyint(1) DEFAULT NULL,
  1283.   `voicestatus` tinyint(1) DEFAULT '0',
  1284.   PRIMARY KEY (`id`)
  1285. ) ENGINE=MyISAM AUTO_INCREMENT=1027 DEFAULT CHARSET=utf8;
  1286. CREATE TABLE IF NOT EXISTS `ims_xcommunity_member_address` (
  1287.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1288.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  1289.   `uid` int(10) unsigned NOT NULL DEFAULT '0',
  1290.   `mid` int(10) unsigned NOT NULL DEFAULT '0',
  1291.   `regionid` int(10) unsigned NOT NULL DEFAULT '0',
  1292.   `openid` varchar(50) NOT NULL,
  1293.   `build` varchar(50) NOT NULL,
  1294.   `unit` varchar(50) DEFAULT NULL,
  1295.   `room` varchar(50) NOT NULL,
  1296.   `address` varchar(100) NOT NULL,
  1297.   `telephone` varchar(15) NOT NULL,
  1298.   `realname` varchar(15) NOT NULL,
  1299.   `enable` int(10) unsigned NOT NULL DEFAULT '0',
  1300.   `memberid` int(11) DEFAULT NULL,
  1301.   `createtime` int(11) DEFAULT NULL,
  1302.   `area` varchar(50) DEFAULT NULL,
  1303.   `license` varchar(50) DEFAULT NULL,
  1304.   `code` int(11) DEFAULT NULL,
  1305.   `status` int(1) DEFAULT NULL,
  1306.   `mobile` varchar(13) DEFAULT NULL,
  1307.   `city` varchar(100) DEFAULT NULL,
  1308.   PRIMARY KEY (`id`)
  1309. ) ENGINE=MyISAM AUTO_INCREMENT=1576 DEFAULT CHARSET=utf8;
  1310. CREATE TABLE IF NOT EXISTS `ims_xcommunity_member_bind` (
  1311.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1312.   `memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1313.   `createtime` int(10) unsigned NOT NULL COMMENT '时间',
  1314.   `status` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '身份,房主,家属,租户',
  1315.   `enable` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1默认,0未在线',
  1316.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  1317.   `addressid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '房号ID',
  1318.   PRIMARY KEY (`id`),
  1319.   KEY `addressid` (`addressid`)
  1320. ) ENGINE=MyISAM AUTO_INCREMENT=150 DEFAULT CHARSET=utf8 COMMENT='新增';
  1321. CREATE TABLE IF NOT EXISTS `ims_xcommunity_member_family` (
  1322.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1323.   `from_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '邀请人id',
  1324.   `to_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '被邀请人id',
  1325.   `addressid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '邀请地址id',
  1326.   `logid` int(11) DEFAULT NULL,
  1327.   PRIMARY KEY (`id`)
  1328. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='地址表';
  1329. CREATE TABLE IF NOT EXISTS `ims_xcommunity_member_log` (
  1330.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1331.   `uniacid` int(10) unsigned NOT NULL,
  1332.   `regionid` int(10) unsigned NOT NULL,
  1333.   `realname` varchar(50) NOT NULL DEFAULT '0' COMMENT '姓名',
  1334.   `mobile` varchar(14) NOT NULL DEFAULT '0',
  1335.   `addressid` int(10) unsigned NOT NULL COMMENT '地址id',
  1336.   `status` int(1) DEFAULT '0',
  1337.   PRIMARY KEY (`id`),
  1338.   KEY `addressid` (`addressid`),
  1339.   KEY `addressid_2` (`addressid`)
  1340. ) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COMMENT='临时存放';
  1341. CREATE TABLE IF NOT EXISTS `ims_xcommunity_member_room` (
  1342.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1343.   `regionid` int(10) unsigned NOT NULL COMMENT '新增小区id',
  1344.   `createtime` int(10) unsigned NOT NULL COMMENT '时间',
  1345.   `area` varchar(50) NOT NULL COMMENT '区',
  1346.   `build` varchar(255) NOT NULL COMMENT '楼栋',
  1347.   `unit` varchar(255) NOT NULL COMMENT '单元',
  1348.   `room` varchar(255) NOT NULL COMMENT '房号',
  1349.   `address` varchar(255) NOT NULL COMMENT '地址',
  1350.   `code` int(10) unsigned NOT NULL,
  1351.   `square` varchar(20) NOT NULL,
  1352.   `enable` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1已绑定,0未绑定',
  1353.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  1354.   `memberid` int(11) DEFAULT NULL,
  1355.   `license` varchar(50) DEFAULT NULL,
  1356.   `status` int(1) DEFAULT NULL,
  1357.   `buildid` int(11) DEFAULT NULL,
  1358.   `areaid` int(11) DEFAULT NULL,
  1359.   `unitid` int(11) DEFAULT NULL,
  1360.   `yybstatus` tinyint(1) DEFAULT NULL,
  1361.   `yybroomid` int(11) DEFAULT NULL,
  1362.   `action` tinyint(1) DEFAULT NULL,
  1363.   `floor_num` int(11) DEFAULT '0',
  1364.   `roomid` int(11) DEFAULT NULL,
  1365.   `householdId` int(11) DEFAULT NULL,
  1366.   PRIMARY KEY (`id`)
  1367. ) ENGINE=MyISAM AUTO_INCREMENT=1623 DEFAULT CHARSET=utf8 COMMENT='房号表';
  1368. CREATE TABLE IF NOT EXISTS `ims_xcommunity_member_users` (
  1369.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1370.   `uid` int(10) unsigned NOT NULL,
  1371.   `uniacid` smallint(6) unsigned NOT NULL,
  1372.   `realname` varchar(50) NOT NULL COMMENT '姓名',
  1373.   `nickname` varchar(50) NOT NULL COMMENT '昵称',
  1374.   `mobile` varchar(14) NOT NULL COMMENT '手机',
  1375.   `chargecredit` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '充电桩余额',
  1376.   `cardno` varchar(50) NOT NULL COMMENT '卡号',
  1377.   `createtime` int(10) NOT NULL COMMENT '创建时间',
  1378.   `gender` tinyint(1) NOT NULL COMMENT '性别',
  1379.   `idcard` varchar(30) NOT NULL COMMENT '身份证号',
  1380.   PRIMARY KEY (`id`)
  1381. ) ENGINE=InnoDB AUTO_INCREMENT=311 DEFAULT CHARSET=utf8 COMMENT='小区用户会员表';
  1382. CREATE TABLE IF NOT EXISTS `ims_xcommunity_member_visit_log` (
  1383.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1384.   `uniacid` int(10) unsigned NOT NULL,
  1385.   `uid` int(11) NOT NULL COMMENT '会员uid',
  1386.   `regionid` int(11) NOT NULL,
  1387.   `createtime` int(11) NOT NULL,
  1388.   PRIMARY KEY (`id`)
  1389. ) ENGINE=MyISAM AUTO_INCREMENT=1538 DEFAULT CHARSET=utf8 COMMENT='访客';
  1390. CREATE TABLE IF NOT EXISTS `ims_xcommunity_memo` (
  1391.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1392.   `uniacid` int(10) unsigned NOT NULL COMMENT '公众号id',
  1393.   `title` varchar(255) NOT NULL COMMENT '通知标题',
  1394.   `reason` text NOT NULL COMMENT '通知内容',
  1395.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间',
  1396.   `xqtype` tinyint(1) NOT NULL COMMENT '1物业通知,2外部通知',
  1397.   `uid` int(11) NOT NULL COMMENT '操作员id',
  1398.   PRIMARY KEY (`id`)
  1399. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1400. CREATE TABLE IF NOT EXISTS `ims_xcommunity_memo_company` (
  1401.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1402.   `memoid` int(11) unsigned NOT NULL COMMENT '公告id',
  1403.   `companyid` int(11) NOT NULL,
  1404.   PRIMARY KEY (`id`)
  1405. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1406. CREATE TABLE IF NOT EXISTS `ims_xcommunity_menu` (
  1407.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1408.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1409.   `pcate` int(10) NOT NULL COMMENT '上一级分类',
  1410.   `cate` int(10) DEFAULT '0',
  1411.   `title` varchar(30) NOT NULL COMMENT '菜单名称',
  1412.   `url` varchar(255) NOT NULL COMMENT '菜单链接',
  1413.   `do` varchar(20) NOT NULL COMMENT '菜单动作',
  1414.   `method` varchar(20) NOT NULL COMMENT '菜单方法',
  1415.   `status` int(1) NOT NULL COMMENT '1显示,2不显示',
  1416.   `displayorder` int(11) NOT NULL COMMENT '菜单排序',
  1417.   `icon` varchar(50) NOT NULL COMMENT '小图标',
  1418.   PRIMARY KEY (`id`)
  1419. ) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8 COMMENT='后台菜单表';
  1420. CREATE TABLE IF NOT EXISTS `ims_xcommunity_menu_operation` (
  1421.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1422.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1423.   `pcate` int(10) DEFAULT '0' COMMENT '上一级分类',
  1424.   `cate` int(10) DEFAULT '0',
  1425.   `title` varchar(30) NOT NULL COMMENT '名称',
  1426.   `do` varchar(20) NOT NULL COMMENT '方法do',
  1427.   `method` varchar(50) NOT NULL COMMENT '操作方法',
  1428.   PRIMARY KEY (`id`)
  1429. ) ENGINE=MyISAM AUTO_INCREMENT=616 DEFAULT CHARSET=utf8 COMMENT='后台菜单操作权限表';
  1430. CREATE TABLE IF NOT EXISTS `ims_xcommunity_menu_role` (
  1431.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1432.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1433.   `uid` int(11) NOT NULL,
  1434.   `title` varchar(30) NOT NULL COMMENT '名称',
  1435.   `menus` text NOT NULL COMMENT '操作菜单',
  1436.   `menu_ops` text NOT NULL COMMENT '操作权限',
  1437.   `createtime` int(11) NOT NULL,
  1438.   PRIMARY KEY (`id`)
  1439. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='角色权限表';
  1440. CREATE TABLE IF NOT EXISTS `ims_xcommunity_mien` (
  1441.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1442.   `uniacid` int(10) unsigned NOT NULL,
  1443.   `realname` varchar(50) NOT NULL,
  1444.   `mobile` varchar(13) NOT NULL,
  1445.   `position` varchar(50) NOT NULL,
  1446.   `image` varchar(150) NOT NULL,
  1447.   `createtime` int(11) unsigned NOT NULL,
  1448.   `uid` int(10) unsigned NOT NULL,
  1449.   `province` varchar(50) NOT NULL,
  1450.   `city` varchar(50) NOT NULL,
  1451.   `dist` varchar(50) NOT NULL,
  1452.   `allregion` int(1) DEFAULT NULL,
  1453.   PRIMARY KEY (`id`)
  1454. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小区风采表';
  1455. CREATE TABLE IF NOT EXISTS `ims_xcommunity_mien_region` (
  1456.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1457.   `mienid` int(10) unsigned NOT NULL,
  1458.   `regionid` int(11) NOT NULL,
  1459.   PRIMARY KEY (`id`)
  1460. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小区风采副表';
  1461. CREATE TABLE IF NOT EXISTS `ims_xcommunity_nav` (
  1462.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1463.   `uniacid` int(11) NOT NULL,
  1464.   `enable` int(11) NOT NULL,
  1465.   `displayorder` int(10) NOT NULL,
  1466.   `pcate` int(10) NOT NULL,
  1467.   `title` varchar(30) NOT NULL,
  1468.   `url` varchar(1000) NOT NULL,
  1469.   `styleid` int(10) NOT NULL,
  1470.   `status` int(1) NOT NULL,
  1471.   `isshow` int(1) NOT NULL,
  1472.   `icon` varchar(50) NOT NULL,
  1473.   `bgcolor` varchar(20) NOT NULL,
  1474.   `regionid` text NOT NULL,
  1475.   `do` varchar(20) NOT NULL,
  1476.   `thumb` varchar(500) NOT NULL,
  1477.   `view` int(1) NOT NULL,
  1478.   `add` int(1) NOT NULL,
  1479.   `show` int(1) DEFAULT '1',
  1480.   PRIMARY KEY (`id`)
  1481. ) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8;
  1482. CREATE TABLE IF NOT EXISTS `ims_xcommunity_nav_region` (
  1483.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1484.   `nid` int(11) NOT NULL COMMENT '菜单id',
  1485.   `regionid` int(11) NOT NULL COMMENT '小区id',
  1486.   PRIMARY KEY (`id`)
  1487. ) ENGINE=InnoDB AUTO_INCREMENT=1112 DEFAULT CHARSET=utf8;
  1488. CREATE TABLE IF NOT EXISTS `ims_xcommunity_notice` (
  1489.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1490.   `uniacid` int(10) unsigned NOT NULL,
  1491.   `regionid` text NOT NULL,
  1492.   `fansopenid` varchar(50) NOT NULL,
  1493.   `type` int(1) NOT NULL,
  1494.   `enable` int(1) NOT NULL,
  1495.   `cid` varchar(200) NOT NULL,
  1496.   `uid` int(11) NOT NULL,
  1497.   `province` varchar(50) NOT NULL,
  1498.   `city` varchar(50) NOT NULL,
  1499.   `dist` varchar(50) NOT NULL,
  1500.   `staffid` int(11) DEFAULT NULL,
  1501.   `xqtype` tinyint(1) DEFAULT '1',
  1502.   `grab_num` int(11) DEFAULT NULL,
  1503.   `grab_ids` text,
  1504.   PRIMARY KEY (`id`)
  1505. ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  1506. CREATE TABLE IF NOT EXISTS `ims_xcommunity_notice_category` (
  1507.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1508.   `nid` int(10) unsigned NOT NULL,
  1509.   `cid` int(11) NOT NULL,
  1510.   PRIMARY KEY (`id`)
  1511. ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='通知关联分类';
  1512. CREATE TABLE IF NOT EXISTS `ims_xcommunity_notice_region` (
  1513.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1514.   `nid` int(10) unsigned NOT NULL,
  1515.   `regionid` int(11) NOT NULL,
  1516.   PRIMARY KEY (`id`)
  1517. ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='通知关联小区';
  1518. CREATE TABLE IF NOT EXISTS `ims_xcommunity_open_log` (
  1519.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1520.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  1521.   `regionid` int(11) NOT NULL,
  1522.   `type` varchar(50) NOT NULL,
  1523.   `openid` varchar(50) NOT NULL,
  1524.   `realname` varchar(50) NOT NULL,
  1525.   `createtime` int(11) NOT NULL,
  1526.   `uid` int(10) DEFAULT NULL,
  1527.   `addressid` int(11) DEFAULT NULL,
  1528.   `isopen` int(1) DEFAULT NULL,
  1529.   PRIMARY KEY (`id`)
  1530. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='开门记录';
  1531. CREATE TABLE IF NOT EXISTS `ims_xcommunity_opendoor_data` (
  1532.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1533.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  1534.   `regionid` int(11) NOT NULL,
  1535.   `build` varchar(50) NOT NULL,
  1536.   `unit` varchar(30) NOT NULL,
  1537.   `room` varchar(100) NOT NULL,
  1538.   `address` varchar(100) NOT NULL,
  1539.   `createtime` int(11) NOT NULL,
  1540.   `opentime` int(11) NOT NULL,
  1541.   `type` int(1) NOT NULL,
  1542.   `uid` int(11) DEFAULT NULL,
  1543.   PRIMARY KEY (`id`)
  1544. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  1545. CREATE TABLE IF NOT EXISTS `ims_xcommunity_order` (
  1546.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1547.   `weid` int(10) unsigned NOT NULL,
  1548.   `from_user` varchar(50) NOT NULL,
  1549.   `ordersn` varchar(20) NOT NULL,
  1550.   `couponsn` varchar(20) NOT NULL,
  1551.   `price` decimal(10,2) NOT NULL,
  1552.   `status` tinyint(4) NOT NULL DEFAULT '0',
  1553.   `enable` tinyint(4) NOT NULL DEFAULT '0',
  1554.   `paytype` tinyint(1) unsigned NOT NULL,
  1555.   `transid` varchar(30) NOT NULL DEFAULT '0',
  1556.   `goodstype` tinyint(1) unsigned NOT NULL DEFAULT '1',
  1557.   `remark` varchar(1000) NOT NULL DEFAULT '',
  1558.   `goodsprice` decimal(10,2) DEFAULT '0.00',
  1559.   `createtime` int(10) unsigned NOT NULL,
  1560.   `usetime` int(10) unsigned NOT NULL,
  1561.   `regionid` int(11) unsigned NOT NULL,
  1562.   `gid` int(11) unsigned NOT NULL,
  1563.   `type` char(30) DEFAULT NULL,
  1564.   `uid` int(11) unsigned NOT NULL,
  1565.   `pid` int(11) unsigned NOT NULL,
  1566.   `aid` int(11) unsigned NOT NULL,
  1567.   `num` int(11) unsigned NOT NULL,
  1568.   `companyid` int(11) unsigned NOT NULL,
  1569.   `province` varchar(50) NOT NULL,
  1570.   `city` varchar(50) NOT NULL,
  1571.   `dist` varchar(50) NOT NULL,
  1572.   `pay` varchar(100) DEFAULT NULL,
  1573.   `uniacid` int(10) DEFAULT NULL,
  1574.   `addressid` int(10) DEFAULT NULL,
  1575.   `delivery` varchar(50) DEFAULT NULL,
  1576.   `credit` int(11) DEFAULT NULL,
  1577.   `send_way` varchar(50) DEFAULT NULL,
  1578.   `dpid` int(11) DEFAULT NULL,
  1579.   `realname` varchar(50) DEFAULT NULL,
  1580.   `company` varchar(50) DEFAULT NULL,
  1581.   `express` varchar(50) DEFAULT NULL,
  1582.   `littleid` int(11) DEFAULT NULL,
  1583.   `randprice` decimal(10,2) DEFAULT NULL,
  1584.   `openid` varchar(50) DEFAULT NULL,
  1585.   `total` decimal(10,2) DEFAULT NULL,
  1586.   `category` int(11) DEFAULT NULL,
  1587.   `offsetprice` decimal(10,2) DEFAULT '0.00',
  1588.   `code` int(10) DEFAULT '0',
  1589.   `rank_status` tinyint(1) DEFAULT '0',
  1590.   `grabuid` int(10) DEFAULT NULL,
  1591.   PRIMARY KEY (`id`)
  1592. ) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;
  1593. CREATE TABLE IF NOT EXISTS `ims_xcommunity_order_goods` (
  1594.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1595.   `weid` int(10) unsigned NOT NULL,
  1596.   `orderid` int(10) unsigned NOT NULL,
  1597.   `goodsid` int(10) unsigned NOT NULL,
  1598.   `price` decimal(10,2) DEFAULT '0.00',
  1599.   `total` int(10) unsigned NOT NULL DEFAULT '1',
  1600.   `createtime` int(10) unsigned NOT NULL,
  1601.   `uniacid` int(10) DEFAULT NULL,
  1602.   PRIMARY KEY (`id`)
  1603. ) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
  1604. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parking` (
  1605.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1606.   `uniacid` int(10) unsigned NOT NULL,
  1607.   `regionid` int(11) NOT NULL,
  1608.   `place_num` varchar(30) NOT NULL,
  1609.   `area` varchar(20) NOT NULL,
  1610.   `status` char(30) DEFAULT NULL,
  1611.   `remark` text NOT NULL,
  1612.   `createtime` int(11) NOT NULL,
  1613.   `uid` int(11) NOT NULL,
  1614.   PRIMARY KEY (`id`)
  1615. ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='车位';
  1616. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parking_record` (
  1617.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1618.   `uniacid` int(11) NOT NULL,
  1619.   `parkingid` int(11) NOT NULL,
  1620.   `realname` varchar(50) NOT NULL,
  1621.   `mobile` varchar(13) NOT NULL,
  1622.   `xqcarid` int(11) NOT NULL,
  1623.   `starttime` int(11) NOT NULL,
  1624.   `endtime` int(11) NOT NULL,
  1625.   `price` varchar(13) NOT NULL,
  1626.   `cycle` int(2) NOT NULL,
  1627.   `createtime` int(11) NOT NULL,
  1628.   `remark` text NOT NULL,
  1629.   PRIMARY KEY (`id`)
  1630. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1631. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks` (
  1632.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1633.   `uniacid` int(11) NOT NULL,
  1634.   `title` varchar(50) NOT NULL,
  1635.   `regionid` int(11) NOT NULL,
  1636.   `rule` text,
  1637.   `createtime` int(11) NOT NULL,
  1638.   `bills` text NOT NULL,
  1639.   `uid` int(11) DEFAULT NULL,
  1640.   `type` tinyint(1) DEFAULT '0',
  1641.   `setting` text,
  1642.   `management` varchar(50) DEFAULT NULL,
  1643.   `exitus` tinyint(1) DEFAULT NULL,
  1644.   `cars_num` int(11) DEFAULT NULL,
  1645.   `password` varchar(200) DEFAULT NULL,
  1646.   `month_type` tinyint(1) DEFAULT NULL,
  1647.   `month_num` int(11) DEFAULT NULL,
  1648.   `short_num` int(11) DEFAULT NULL,
  1649.   `rule_id` int(11) DEFAULT NULL,
  1650.   `leave_space` int(11) DEFAULT NULL,
  1651.   `temrule_id` int(11) DEFAULT NULL,
  1652.   `over_month_num` int(11) DEFAULT NULL,
  1653.   `over_short_num` int(11) DEFAULT NULL,
  1654.   `qr_status` tinyint(1) DEFAULT NULL,
  1655.   PRIMARY KEY (`id`)
  1656. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1657. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_camera` (
  1658.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1659.   `uniacid` smallint(6) NOT NULL,
  1660.   `deviceid` int(10) NOT NULL,
  1661.   `title` varchar(50) NOT NULL COMMENT '摄像机名称',
  1662.   `content` text NOT NULL COMMENT '摄像机参数',
  1663.   `installtime` int(10) DEFAULT NULL COMMENT '安装时间',
  1664.   `service_life` int(10) NOT NULL COMMENT '使用年限',
  1665.   `service_num` int(10) NOT NULL COMMENT '维护次数',
  1666.   `createtime` int(11) NOT NULL,
  1667.   `type` tinyint(1) NOT NULL COMMENT '1进口 2出口',
  1668.   `pid` int(10) NOT NULL,
  1669.   PRIMARY KEY (`id`)
  1670. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='车道表';
  1671. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_cars` (
  1672.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1673.   `uniacid` int(11) NOT NULL,
  1674.   `carno` varchar(10) NOT NULL,
  1675.   `parkid` int(11) NOT NULL,
  1676.   `starttime` int(11) NOT NULL,
  1677.   `endtime` int(11) NOT NULL,
  1678.   `type` tinyint(1) NOT NULL,
  1679.   `createtime` int(11) NOT NULL,
  1680.   `enable` tinyint(1) NOT NULL,
  1681.   `use` tinyint(1) NOT NULL,
  1682.   `status` tinyint(1) DEFAULT NULL,
  1683.   `remark` varchar(255) DEFAULT NULL,
  1684.   `rule_id` int(11) DEFAULT NULL,
  1685.   `businessid` int(11) DEFAULT NULL,
  1686.   `realname` varchar(30) DEFAULT NULL,
  1687.   `mobile` varchar(30) DEFAULT NULL,
  1688.   `verity` tinyint(1) DEFAULT NULL,
  1689.   `parking_id` int(11) DEFAULT NULL,
  1690.   PRIMARY KEY (`id`)
  1691. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1692. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_device` (
  1693.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1694.   `uniacid` int(11) NOT NULL,
  1695.   `parkid` int(11) NOT NULL,
  1696.   `category` tinyint(1) NOT NULL,
  1697.   `appid` varchar(50) NOT NULL,
  1698.   `appsecret` varchar(50) NOT NULL,
  1699.   `identity` varchar(50) NOT NULL,
  1700.   `enable` tinyint(1) NOT NULL,
  1701.   `uid` int(11) DEFAULT NULL,
  1702.   `createtime` int(11) DEFAULT NULL,
  1703.   `title` varchar(50) DEFAULT NULL,
  1704.   `setting` text,
  1705.   `cardid` varchar(50) DEFAULT NULL,
  1706.   `exit_type` tinyint(1) DEFAULT NULL,
  1707.   `type` tinyint(1) DEFAULT NULL,
  1708.   PRIMARY KEY (`id`)
  1709. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1710. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_log` (
  1711.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1712.   `uniacid` smallint(6) NOT NULL,
  1713.   `carno` varchar(10) NOT NULL,
  1714.   `identity` varchar(50) NOT NULL COMMENT '设备号',
  1715.   `type` tinyint(1) NOT NULL COMMENT '类型 1 ,2临时车 ,3储值车',
  1716.   `idx` tinyint(1) NOT NULL COMMENT '第几路 从1开始',
  1717.   `open` tinyint(1) NOT NULL COMMENT '0未抬杆',
  1718.   `starttime` int(11) NOT NULL COMMENT '进场时间',
  1719.   `endtime` int(11) NOT NULL COMMENT '出场时间',
  1720.   `pid` int(11) NOT NULL,
  1721.   `status` int(11) NOT NULL COMMENT '是否出场',
  1722.   `plate_type` tinyint(1) NOT NULL COMMENT '车辆类型',
  1723.   `pic` text NOT NULL COMMENT '图片url',
  1724.   `entery_title` varchar(50) NOT NULL COMMENT '入口名称',
  1725.   `out_title` varchar(50) NOT NULL COMMENT '出口名称',
  1726.   `userid` int(11) NOT NULL COMMENT '用户id',
  1727.   `open_status` tinyint(1) NOT NULL COMMENT '1代表是已支付过的,0代表是未支付的',
  1728.   `total_price` decimal(10,2) NOT NULL COMMENT '应付金额',
  1729.   `price` decimal(10,2) NOT NULL COMMENT '实付金额',
  1730.   `paytime` int(11) NOT NULL COMMENT '支付时间',
  1731.   `paytype` int(11) NOT NULL COMMENT '1免费,2余额,3微信支付',
  1732.   PRIMARY KEY (`id`)
  1733. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='通行记录表';
  1734. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_openlog` (
  1735.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1736.   `uniacid` smallint(6) unsigned NOT NULL,
  1737.   `uid` int(11) NOT NULL,
  1738.   `username` varchar(30) NOT NULL,
  1739.   `identity` varchar(50) NOT NULL COMMENT '设备号',
  1740.   `idx` tinyint(1) NOT NULL COMMENT '第几路 从1开始',
  1741.   `cameraid` int(11) NOT NULL COMMENT '车道id',
  1742.   `createtime` int(11) NOT NULL,
  1743.   `pid` int(11) NOT NULL,
  1744.   `ip` varchar(20) NOT NULL,
  1745.   `carno` varchar(10) NOT NULL,
  1746.   PRIMARY KEY (`id`)
  1747. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='手动开闸记录';
  1748. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_order` (
  1749.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1750.   `uniacid` int(11) NOT NULL,
  1751.   `ordersn` varchar(30) NOT NULL,
  1752.   `carno` varchar(10) NOT NULL,
  1753.   `num` int(11) NOT NULL,
  1754.   `price` decimal(10,2) NOT NULL,
  1755.   `type` tinyint(1) NOT NULL,
  1756.   `status` tinyint(1) NOT NULL,
  1757.   `enable` tinyint(1) NOT NULL,
  1758.   `createtime` int(11) NOT NULL,
  1759.   `intotime` int(11) NOT NULL,
  1760.   `outtime` int(11) NOT NULL,
  1761.   `paytype` tinyint(1) NOT NULL,
  1762.   `category` tinyint(1) NOT NULL,
  1763.   `parkid` int(11) DEFAULT NULL,
  1764.   `uid` int(11) DEFAULT NULL,
  1765.   `transid` varchar(50) DEFAULT NULL,
  1766.   `rodtype` tinyint(1) DEFAULT NULL,
  1767.   `identity` varchar(50) DEFAULT NULL,
  1768.   `paytime` int(11) DEFAULT NULL,
  1769.   `logid` int(11) DEFAULT NULL,
  1770.   `pay_status` tinyint(1) DEFAULT NULL,
  1771.   `endtime` int(11) DEFAULT NULL,
  1772.   `display` tinyint(1) DEFAULT '1',
  1773.   `orderid` int(11) DEFAULT NULL,
  1774.   PRIMARY KEY (`id`)
  1775. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1776. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_passlog` (
  1777.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1778.   `uniacid` int(11) NOT NULL,
  1779.   `carno` varchar(10) NOT NULL,
  1780.   `identity` varchar(50) NOT NULL,
  1781.   `type` tinyint(1) NOT NULL,
  1782.   `idx` tinyint(1) NOT NULL,
  1783.   `logid` int(11) NOT NULL,
  1784.   `createtime` int(11) NOT NULL,
  1785.   `parkid` int(11) NOT NULL,
  1786.   PRIMARY KEY (`id`)
  1787. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1788. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_rules` (
  1789.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1790.   `uniacid` smallint(6) NOT NULL,
  1791.   `uid` int(11) NOT NULL COMMENT '操作员uid',
  1792.   `title` varchar(50) NOT NULL COMMENT '计费规则名称',
  1793.   `category` tinyint(1) NOT NULL COMMENT '1月租车 2临时车',
  1794.   `type` tinyint(1) NOT NULL COMMENT '临时车计费标准1二段式 2二十四小时 3记次收费',
  1795.   `rules` text NOT NULL,
  1796.   `createtime` int(11) NOT NULL,
  1797.   `price` varchar(20) NOT NULL COMMENT '月租车价格',
  1798.   PRIMARY KEY (`id`)
  1799. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='停车收费标准';
  1800. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_setting` (
  1801.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1802.   `uniacid` int(11) NOT NULL,
  1803.   `parkid` int(11) NOT NULL,
  1804.   `content` text NOT NULL,
  1805.   PRIMARY KEY (`id`)
  1806. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1807. CREATE TABLE IF NOT EXISTS `ims_xcommunity_parks_usercars` (
  1808.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1809.   `uniacid` smallint(6) unsigned NOT NULL,
  1810.   `uid` int(11) NOT NULL,
  1811.   `carid` int(11) NOT NULL COMMENT '绑定的车辆id',
  1812.   `enable` tinyint(1) NOT NULL COMMENT '是否默认车辆',
  1813.   `type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否为月租车辆1月租车2临时车',
  1814.   `createtime` int(11) NOT NULL,
  1815.   `thumb` varchar(255) NOT NULL COMMENT '车牌号认证的图片',
  1816.   `auth_status` tinyint(1) NOT NULL COMMENT '认证的状态',
  1817.   `parkid` int(11) NOT NULL COMMENT '车场id',
  1818.   PRIMARY KEY (`id`)
  1819. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户绑定的车辆';
  1820. CREATE TABLE IF NOT EXISTS `ims_xcommunity_pay` (
  1821.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1822.   `uniacid` int(10) unsigned NOT NULL,
  1823.   `pay` varchar(200) NOT NULL,
  1824.   `type` int(1) NOT NULL,
  1825.   `wechat` int(1) DEFAULT NULL,
  1826.   `alipay` int(1) DEFAULT NULL,
  1827.   `balance` int(1) DEFAULT NULL,
  1828.   `delivery` int(1) DEFAULT NULL,
  1829.   `sub` int(1) DEFAULT NULL,
  1830.   `swiftpass` int(1) DEFAULT NULL,
  1831.   `hsyunfu` int(1) DEFAULT NULL,
  1832.   `chinaums` int(1) DEFAULT NULL,
  1833.   PRIMARY KEY (`id`)
  1834. ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
  1835. CREATE TABLE IF NOT EXISTS `ims_xcommunity_pay_api` (
  1836.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1837.   `uniacid` int(10) unsigned NOT NULL,
  1838.   `cid` int(10) unsigned NOT NULL,
  1839.   `pay` text NOT NULL,
  1840.   `type` int(1) NOT NULL,
  1841.   `paytype` int(1) NOT NULL,
  1842.   `uid` int(11) DEFAULT NULL,
  1843.   `userid` int(11) DEFAULT NULL,
  1844.   PRIMARY KEY (`id`)
  1845. ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
  1846. CREATE TABLE IF NOT EXISTS `ims_xcommunity_phone` (
  1847.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  1848.   `weid` int(11) unsigned NOT NULL,
  1849.   `phone` varchar(50) NOT NULL,
  1850.   `content` varchar(50) NOT NULL,
  1851.   `regionid` text NOT NULL,
  1852.   `thumb` varchar(1000) NOT NULL,
  1853.   `displayorder` int(10) NOT NULL,
  1854.   `uid` int(10) NOT NULL,
  1855.   `province` varchar(50) NOT NULL,
  1856.   `city` varchar(50) NOT NULL,
  1857.   `dist` varchar(50) NOT NULL,
  1858.   `uniacid` int(11) DEFAULT NULL,
  1859.   `address` varchar(100) DEFAULT '0',
  1860.   `introduction` varchar(255) DEFAULT '0',
  1861.   `cid` int(11) DEFAULT '0',
  1862.   `status` int(1) DEFAULT '1',
  1863.   `allregion` int(1) DEFAULT NULL,
  1864.   PRIMARY KEY (`id`)
  1865. ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
  1866. CREATE TABLE IF NOT EXISTS `ims_xcommunity_phone_region` (
  1867.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  1868.   `phoneid` int(11) unsigned NOT NULL COMMENT '便民号码id',
  1869.   `regionid` int(11) NOT NULL COMMENT '小区id',
  1870.   PRIMARY KEY (`id`)
  1871. ) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 COMMENT='便民号码附表';
  1872. CREATE TABLE IF NOT EXISTS `ims_xcommunity_plugin` (
  1873.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1874.   `uniacid` int(10) unsigned NOT NULL,
  1875.   `title` varchar(50) NOT NULL COMMENT '插件名称',
  1876.   `module` varchar(50) NOT NULL,
  1877.   `do` text NOT NULL,
  1878.   PRIMARY KEY (`id`)
  1879. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='插件';
  1880. CREATE TABLE IF NOT EXISTS `ims_xcommunity_plugin_adv` (
  1881.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1882.   `uniacid` int(11) NOT NULL,
  1883.   `uid` int(11) NOT NULL,
  1884.   `advtitle` varchar(100) NOT NULL COMMENT '广告名称',
  1885.   `advtime` int(11) NOT NULL COMMENT '投放日期',
  1886.   `advday` int(11) NOT NULL COMMENT '投放天数',
  1887.   `area` int(1) NOT NULL COMMENT '1微信开门',
  1888.   `price` int(11) NOT NULL COMMENT '广告出价',
  1889.   `advprice` int(11) NOT NULL COMMENT '投放金额',
  1890.   `regionid` int(11) NOT NULL COMMENT '投放小区',
  1891.   `opentime` int(11) NOT NULL COMMENT '间隔时间',
  1892.   `num` int(11) NOT NULL,
  1893.   `guardid` text NOT NULL COMMENT '门禁id',
  1894.   `link` varchar(100) NOT NULL COMMENT '链接',
  1895.   `image` varchar(100) NOT NULL COMMENT '图片',
  1896.   `status` int(1) NOT NULL COMMENT '1通过',
  1897.   `content` text NOT NULL COMMENT '拒绝原因',
  1898.   `clicknum` int(11) NOT NULL COMMENT '点击量',
  1899.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  1900.   PRIMARY KEY (`id`)
  1901. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告主';
  1902. CREATE TABLE IF NOT EXISTS `ims_xcommunity_plugin_adv_data` (
  1903.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1904.   `uniacid` int(11) NOT NULL,
  1905.   `uid` int(11) NOT NULL,
  1906.   `aid` int(11) NOT NULL COMMENT '广告id',
  1907.   `price` decimal(10,2) NOT NULL COMMENT '发放金额',
  1908.   `openid` varchar(50) NOT NULL COMMENT '领取人',
  1909.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  1910.   PRIMARY KEY (`id`)
  1911. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告主数据';
  1912. CREATE TABLE IF NOT EXISTS `ims_xcommunity_plugin_adv_guard` (
  1913.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1914.   `uniacid` int(11) NOT NULL,
  1915.   `advid` int(11) NOT NULL,
  1916.   `guardid` int(11) NOT NULL,
  1917.   `regionid` int(11) NOT NULL,
  1918.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  1919.   PRIMARY KEY (`id`)
  1920. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告绑定门禁';
  1921. CREATE TABLE IF NOT EXISTS `ims_xcommunity_plugin_adv_order` (
  1922.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1923.   `uniacid` int(11) NOT NULL,
  1924.   `uid` int(11) NOT NULL,
  1925.   `ordersn` varchar(30) NOT NULL,
  1926.   `price` decimal(10,2) NOT NULL,
  1927.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  1928.   PRIMARY KEY (`id`)
  1929. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商家充值订单';
  1930. CREATE TABLE IF NOT EXISTS `ims_xcommunity_plugin_article_class` (
  1931.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1932.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1933.   `name` varchar(100) NOT NULL COMMENT '分类名称',
  1934.   `pic` varchar(255) DEFAULT NULL,
  1935.   PRIMARY KEY (`id`)
  1936. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分类表';
  1937. CREATE TABLE IF NOT EXISTS `ims_xcommunity_plugin_article_message` (
  1938.   `id` int(11) NOT NULL AUTO_INCREMENT,
  1939.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  1940.   `title` varchar(100) NOT NULL COMMENT '标题',
  1941.   `content` text NOT NULL COMMENT '内容',
  1942.   `pic` text NOT NULL COMMENT '图片',
  1943.   `cid` int(11) NOT NULL COMMENT '分类id',
  1944.   `province` varchar(50) NOT NULL,
  1945.   `city` varchar(50) NOT NULL,
  1946.   `dist` varchar(50) NOT NULL,
  1947.   `createtime` int(11) NOT NULL COMMENT '创建时间时间',
  1948.   `allregion` int(1) DEFAULT NULL,
  1949.   PRIMARY KEY (`id`)
  1950. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='信息表';
  1951. CREATE TABLE IF NOT EXISTS `ims_xcommunity_plugin_article_region` (
  1952.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1953.   `articleid` int(10) unsigned NOT NULL,
  1954.   `regionid` int(11) NOT NULL,
  1955.   PRIMARY KEY (`id`)
  1956. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='图文推送副表';
  1957. CREATE TABLE IF NOT EXISTS `ims_xcommunity_print` (
  1958.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1959.   `uniacid` int(10) unsigned NOT NULL,
  1960.   `print_status` int(10) unsigned NOT NULL,
  1961.   `print_type` int(10) unsigned NOT NULL,
  1962.   `member_code` varchar(80) NOT NULL,
  1963.   `api_key` varchar(50) NOT NULL,
  1964.   `deviceNo` varchar(50) NOT NULL,
  1965.   `regionid` text NOT NULL,
  1966.   `uid` int(10) unsigned NOT NULL,
  1967.   `province` varchar(50) NOT NULL,
  1968.   `city` varchar(50) NOT NULL,
  1969.   `dist` varchar(50) NOT NULL,
  1970.   `userid` int(11) DEFAULT NULL,
  1971.   PRIMARY KEY (`id`)
  1972. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1973. CREATE TABLE IF NOT EXISTS `ims_xcommunity_property` (
  1974.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1975.   `weid` int(10) unsigned NOT NULL,
  1976.   `uid` int(10) unsigned NOT NULL,
  1977.   `title` varchar(255) NOT NULL,
  1978.   `topPicture` varchar(255) NOT NULL,
  1979.   `content` varchar(2000) NOT NULL,
  1980.   `createtime` int(10) unsigned NOT NULL,
  1981.   `regionid` text NOT NULL,
  1982.   `telphone` varchar(13) NOT NULL,
  1983.   `province` varchar(50) NOT NULL,
  1984.   `city` varchar(50) NOT NULL,
  1985.   `dist` varchar(50) NOT NULL,
  1986.   `uniacid` int(10) DEFAULT NULL,
  1987.   `thumb` varchar(255) DEFAULT NULL,
  1988.   `mark` int(11) DEFAULT NULL,
  1989.   `license` varchar(255) DEFAULT NULL,
  1990.   `realname` varchar(100) DEFAULT NULL,
  1991.   `address` varchar(255) DEFAULT NULL,
  1992.   `reg_content` varchar(255) DEFAULT NULL,
  1993.   `mobile` varchar(13) DEFAULT NULL,
  1994.   `reg_address` varchar(255) DEFAULT NULL,
  1995.   `qq` varchar(20) DEFAULT NULL,
  1996.   `code` varchar(100) DEFAULT NULL,
  1997.   `manager` varchar(50) DEFAULT NULL,
  1998.   `manager_mobile` varchar(13) DEFAULT NULL,
  1999.   `staff` varchar(255) DEFAULT NULL,
  2000.   `type` int(1) DEFAULT NULL,
  2001.   `company` varchar(255) DEFAULT NULL,
  2002.   `total` int(11) DEFAULT NULL,
  2003.   `yybpropertyid` int(11) DEFAULT NULL,
  2004.   `action` tinyint(1) DEFAULT NULL,
  2005.   `yybstatus` tinyint(1) DEFAULT NULL,
  2006.   PRIMARY KEY (`id`)
  2007. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  2008. CREATE TABLE IF NOT EXISTS `ims_xcommunity_rank` (
  2009.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2010.   `weid` int(10) unsigned NOT NULL,
  2011.   `type` int(1) unsigned NOT NULL,
  2012.   `content` varchar(2000) NOT NULL,
  2013.   `dpid` int(11) DEFAULT '0',
  2014.   `openid` varchar(100) NOT NULL,
  2015.   `createtime` int(10) unsigned NOT NULL,
  2016.   `uniacid` int(10) DEFAULT NULL,
  2017.   `rankid` int(11) DEFAULT NULL,
  2018.   `rank` int(11) DEFAULT NULL,
  2019.   `uid` int(11) DEFAULT NULL,
  2020.   `images` text,
  2021.   `status` int(1) DEFAULT NULL,
  2022.   PRIMARY KEY (`id`)
  2023. ) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;
  2024. CREATE TABLE IF NOT EXISTS `ims_xcommunity_rank_category` (
  2025.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2026.   `uniacid` int(10) unsigned NOT NULL COMMENT '公众号id',
  2027.   `title` varchar(255) NOT NULL COMMENT '名称',
  2028.   `content` text NOT NULL COMMENT '内容',
  2029.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间',
  2030.   PRIMARY KEY (`id`)
  2031. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='评分项目';
  2032. CREATE TABLE IF NOT EXISTS `ims_xcommunity_rank_notice` (
  2033.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2034.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2035.   `pid` int(11) NOT NULL COMMENT '物业id',
  2036.   `openid` varchar(50) NOT NULL COMMENT '粉丝openid',
  2037.   `realname` varchar(150) NOT NULL COMMENT '姓名',
  2038.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  2039.   `enable` int(1) NOT NULL COMMENT '是否开启',
  2040.   `type` int(1) NOT NULL COMMENT '1微信2短信3全部',
  2041.   PRIMARY KEY (`id`)
  2042. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='物业接收员';
  2043. CREATE TABLE IF NOT EXISTS `ims_xcommunity_rank_property` (
  2044.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2045.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2046.   `pid` int(11) NOT NULL COMMENT '物业id',
  2047.   `title` varchar(100) NOT NULL COMMENT '打分标题',
  2048.   `mark` int(11) NOT NULL COMMENT '评分',
  2049.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间',
  2050.   PRIMARY KEY (`id`)
  2051. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='打分录入';
  2052. CREATE TABLE IF NOT EXISTS `ims_xcommunity_rank_report_log` (
  2053.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  2054.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2055.   `reportid` int(11) NOT NULL COMMENT '报修建议id',
  2056.   `categoryid` int(11) NOT NULL,
  2057.   `content` text NOT NULL COMMENT '回复信息',
  2058.   `uid` int(11) NOT NULL COMMENT '处理人uid',
  2059.   `createtime` int(11) unsigned NOT NULL COMMENT '时间',
  2060.   `images` text NOT NULL,
  2061.   `status` int(1) NOT NULL,
  2062.   PRIMARY KEY (`id`),
  2063.   KEY `reportid` (`reportid`),
  2064.   KEY `uid` (`uid`)
  2065. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='评分投诉处理表';
  2066. CREATE TABLE IF NOT EXISTS `ims_xcommunity_rank_report_notice` (
  2067.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2068.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2069.   `pid` int(11) NOT NULL COMMENT '物业id',
  2070.   `openid` varchar(50) NOT NULL COMMENT '粉丝openid',
  2071.   `realname` varchar(150) NOT NULL COMMENT '姓名',
  2072.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  2073.   `enable` int(1) NOT NULL COMMENT '是否开启',
  2074.   `type` int(1) NOT NULL COMMENT '1微信2短信3全部',
  2075.   PRIMARY KEY (`id`)
  2076. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='房管接收员';
  2077. CREATE TABLE IF NOT EXISTS `ims_xcommunity_reading_member` (
  2078.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2079.   `uniacid` int(10) unsigned NOT NULL,
  2080.   `aid` int(10) unsigned NOT NULL,
  2081.   `openid` varchar(50) NOT NULL,
  2082.   `status` varchar(1000) NOT NULL,
  2083.   `regionid` int(10) DEFAULT NULL,
  2084.   `uid` int(11) DEFAULT NULL,
  2085.   PRIMARY KEY (`id`)
  2086. ) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=utf8;
  2087. CREATE TABLE IF NOT EXISTS `ims_xcommunity_recharge` (
  2088.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2089.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2090.   `uid` int(11) NOT NULL,
  2091.   `status` int(1) NOT NULL,
  2092.   `fee` decimal(10,2) NOT NULL,
  2093.   `createtime` int(11) NOT NULL,
  2094.   `orderid` varchar(50) NOT NULL,
  2095.   `credit` decimal(10,2) NOT NULL,
  2096.   PRIMARY KEY (`id`)
  2097. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='充值记录';
  2098. CREATE TABLE IF NOT EXISTS `ims_xcommunity_region` (
  2099.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2100.   `weid` int(10) unsigned NOT NULL,
  2101.   `title` varchar(50) NOT NULL,
  2102.   `linkmen` varchar(50) NOT NULL,
  2103.   `linkway` varchar(50) NOT NULL,
  2104.   `lng` varchar(10) NOT NULL,
  2105.   `lat` varchar(10) NOT NULL,
  2106.   `address` varchar(50) NOT NULL,
  2107.   `pid` int(11) NOT NULL,
  2108.   `url` varchar(100) NOT NULL,
  2109.   `thumb` varchar(1000) NOT NULL,
  2110.   `pic` varchar(1000) NOT NULL,
  2111.   `province` varchar(50) NOT NULL,
  2112.   `city` varchar(50) NOT NULL,
  2113.   `dist` varchar(50) NOT NULL,
  2114.   `qq` varchar(15) NOT NULL,
  2115.   `rid` int(11) NOT NULL,
  2116.   `uid` int(11) NOT NULL,
  2117.   `keyword` varchar(100) DEFAULT NULL,
  2118.   `commission` float DEFAULT '0',
  2119.   `uniacid` int(10) DEFAULT NULL,
  2120.   `status` int(1) DEFAULT NULL,
  2121.   `area` varchar(100) DEFAULT NULL,
  2122.   `stamp` varchar(255) DEFAULT NULL,
  2123.   `credit` decimal(10,2) DEFAULT '0.00',
  2124.   `action` tinyint(1) DEFAULT NULL,
  2125.   `yybstatus` tinyint(1) DEFAULT NULL,
  2126.   `yybcommunityid` int(11) DEFAULT NULL,
  2127.   `accountid` int(11) DEFAULT NULL,
  2128.   `villageid` int(11) DEFAULT NULL,
  2129.   `zoneId` int(11) DEFAULT NULL,
  2130.   `parent_accountid` int(11) DEFAULT NULL,
  2131.   PRIMARY KEY (`id`)
  2132. ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
  2133. CREATE TABLE IF NOT EXISTS `ims_xcommunity_region_data` (
  2134.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2135.   `uniacid` int(11) NOT NULL,
  2136.   `regionid` int(11) NOT NULL,
  2137.   `project_city` varchar(150) NOT NULL COMMENT '项目所属地',
  2138.   `project` varchar(50) NOT NULL COMMENT '项目名称',
  2139.   `pact` int(1) NOT NULL COMMENT '合同类型:前期物业/后期物业',
  2140.   `manager` varchar(50) NOT NULL COMMENT '项目经理姓名',
  2141.   `manager_mobile` varchar(13) NOT NULL COMMENT '项目经理电话',
  2142.   `project_square` varchar(20) NOT NULL COMMENT '项目总建筑面积',
  2143.   `house_total` int(10) NOT NULL COMMENT '总户数',
  2144.   `build_total` int(10) NOT NULL COMMENT '总栋数',
  2145.   `other_time` int(10) NOT NULL COMMENT '首次交付日期',
  2146.   `income` decimal(10,2) NOT NULL COMMENT '上年度营业收入',
  2147.   `house_square` varchar(20) NOT NULL COMMENT '住宅面积',
  2148.   `house_pfee` decimal(10,2) NOT NULL COMMENT '住宅物业费收费标准',
  2149.   `house_nsquare` varchar(20) NOT NULL COMMENT '非住宅面积',
  2150.   `house_npfee` decimal(10,2) NOT NULL COMMENT '非住宅物业费收费标准',
  2151.   `park_price` decimal(10,2) NOT NULL COMMENT '车位场地租金',
  2152.   `park_fee` decimal(10,2) NOT NULL COMMENT '停车服务费',
  2153.   `lift_total` int(10) NOT NULL COMMENT '电梯总数量',
  2154.   `lift_ttotal` int(10) NOT NULL COMMENT '电梯使用超过十年数量',
  2155.   `psquare` varchar(20) NOT NULL COMMENT '物业用房面积',
  2156.   `park_total` int(10) NOT NULL COMMENT '总停车位',
  2157.   `park_common` int(10) NOT NULL COMMENT '公共停车位',
  2158.   `camera_total` int(10) NOT NULL COMMENT '可视监控镜头数量',
  2159.   `alarm` varchar(100) NOT NULL COMMENT '周界报警系统',
  2160.   `plug` int(10) NOT NULL COMMENT '消防栓数量',
  2161.   `pname` varchar(255) NOT NULL COMMENT '项目服务人员',
  2162.   `owner_total` int(10) NOT NULL COMMENT '业主委员会人数',
  2163.   `owner_name` varchar(50) NOT NULL COMMENT '业主委员会主任姓名',
  2164.   `owner_mobile` varchar(13) NOT NULL COMMENT 'owner_mobile',
  2165.   `water` varchar(100) NOT NULL COMMENT '自管二次供水系统',
  2166.   `electric` varchar(100) NOT NULL COMMENT '自管供电系统',
  2167.   `type` int(1) NOT NULL COMMENT '是否加入物业管理电子信息平台',
  2168.   PRIMARY KEY (`id`)
  2169. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='小区资料副表';
  2170. CREATE TABLE IF NOT EXISTS `ims_xcommunity_report` (
  2171.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  2172.   `openid` varchar(50) NOT NULL,
  2173.   `weid` int(11) unsigned NOT NULL,
  2174.   `regionid` int(10) unsigned NOT NULL,
  2175.   `type` tinyint(1) NOT NULL,
  2176.   `category` varchar(50) NOT NULL DEFAULT '',
  2177.   `cid` int(11) NOT NULL COMMENT '类目',
  2178.   `content` varchar(255) NOT NULL,
  2179.   `requirement` varchar(1000) NOT NULL,
  2180.   `createtime` int(11) unsigned NOT NULL,
  2181.   `status` tinyint(1) unsigned NOT NULL,
  2182.   `newmsg` tinyint(1) NOT NULL DEFAULT '0',
  2183.   `rank` tinyint(3) unsigned NOT NULL,
  2184.   `comment` varchar(1000) NOT NULL,
  2185.   `resolve` varchar(1000) NOT NULL,
  2186.   `resolver` varchar(50) NOT NULL,
  2187.   `resolvetime` int(10) NOT NULL,
  2188.   `address` varchar(80) NOT NULL,
  2189.   `ropenid` varchar(50) NOT NULL,
  2190.   `dealing` varchar(50) NOT NULL,
  2191.   `images` text,
  2192.   `enable` tinyint(1) unsigned NOT NULL,
  2193.   `grabimages` varchar(1000) DEFAULT NULL,
  2194.   `uid` int(11) DEFAULT NULL,
  2195.   `addressid` int(11) DEFAULT NULL,
  2196.   `uniacid` int(11) DEFAULT NULL,
  2197.   `remark` varchar(255) DEFAULT '0',
  2198.   `categoryid` int(1) DEFAULT '0',
  2199.   `realname` varchar(50) DEFAULT NULL,
  2200.   `mobile` varchar(13) DEFAULT NULL,
  2201.   `state` int(1) DEFAULT NULL,
  2202.   `price` decimal(12,2) DEFAULT NULL,
  2203.   `visit` int(1) DEFAULT NULL,
  2204.   `delaytime` int(11) DEFAULT NULL,
  2205.   `code` int(10) DEFAULT '0',
  2206.   PRIMARY KEY (`id`)
  2207. ) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
  2208. CREATE TABLE IF NOT EXISTS `ims_xcommunity_report_images` (
  2209.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  2210.   `reportid` int(11) NOT NULL COMMENT '报修建议id',
  2211.   `thumbid` int(11) NOT NULL COMMENT '图片id',
  2212.   PRIMARY KEY (`id`)
  2213. ) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8;
  2214. CREATE TABLE IF NOT EXISTS `ims_xcommunity_report_log` (
  2215.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  2216.   `reportid` int(11) NOT NULL COMMENT '报修建议id',
  2217.   `content` text NOT NULL COMMENT '回复信息',
  2218.   `uid` int(11) NOT NULL COMMENT '处理人uid',
  2219.   `createtime` int(11) unsigned NOT NULL COMMENT '时间',
  2220.   `dealing` varchar(20) NOT NULL COMMENT '后台处理人',
  2221.   `mobile` varchar(20) NOT NULL,
  2222.   `images` text NOT NULL,
  2223.   `categoryid` int(11) DEFAULT '0',
  2224.   `remark` varchar(255) DEFAULT '0',
  2225.   `price` decimal(12,2) DEFAULT NULL,
  2226.   `status` int(1) DEFAULT NULL,
  2227.   `cause` text,
  2228.   `measure` text,
  2229.   `rank` varchar(255) DEFAULT NULL,
  2230.   PRIMARY KEY (`id`)
  2231. ) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8 COMMENT='报修建议处理表';
  2232. CREATE TABLE IF NOT EXISTS `ims_xcommunity_report_num` (
  2233.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2234.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2235.   `uid` int(11) NOT NULL,
  2236.   `cid` int(11) NOT NULL COMMENT '分类id',
  2237.   `num` int(11) NOT NULL COMMENT '投诉次数',
  2238.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  2239.   PRIMARY KEY (`id`)
  2240. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='投诉次数记录';
  2241. CREATE TABLE IF NOT EXISTS `ims_xcommunity_report_order` (
  2242.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2243.   `uniacid` int(11) NOT NULL,
  2244.   `ordersn` varchar(30) NOT NULL COMMENT '订单编号',
  2245.   `price` varchar(15) NOT NULL COMMENT '价格',
  2246.   `goods` text NOT NULL COMMENT '订单名称',
  2247.   `status` int(1) NOT NULL COMMENT '状态',
  2248.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  2249.   `openid` varchar(50) NOT NULL COMMENT '提交人openid',
  2250.   `uid` int(11) NOT NULL COMMENT '提交人uid',
  2251.   `reportid` varchar(30) NOT NULL COMMENT '报修id',
  2252.   `orderid` int(11) DEFAULT NULL,
  2253.   PRIMARY KEY (`id`)
  2254. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='维修费订单';
  2255. CREATE TABLE IF NOT EXISTS `ims_xcommunity_report_send_log` (
  2256.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2257.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2258.   `uid` int(11) NOT NULL,
  2259.   `reportid` int(11) NOT NULL COMMENT '报修id',
  2260.   `sendtime` int(11) NOT NULL COMMENT '推送时间',
  2261.   `grabtime` int(11) NOT NULL COMMENT '处理时间',
  2262.   `type` int(2) NOT NULL COMMENT '1报修',
  2263.   PRIMARY KEY (`id`)
  2264. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='投诉次数记录';
  2265. CREATE TABLE IF NOT EXISTS `ims_xcommunity_res` (
  2266.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2267.   `weid` int(10) unsigned NOT NULL,
  2268.   `openid` varchar(100) NOT NULL,
  2269.   `truename` varchar(30) NOT NULL,
  2270.   `mobile` varchar(12) NOT NULL,
  2271.   `num` int(2) unsigned NOT NULL,
  2272.   `aid` int(11) unsigned NOT NULL,
  2273.   `createtime` int(11) NOT NULL,
  2274.   `status` int(1) NOT NULL,
  2275.   `uniacid` int(10) DEFAULT NULL,
  2276.   `uid` int(10) DEFAULT NULL,
  2277.   `orderid` int(11) DEFAULT '0',
  2278.   `address` varchar(255) DEFAULT NULL,
  2279.   PRIMARY KEY (`id`)
  2280. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='报名表';
  2281. CREATE TABLE IF NOT EXISTS `ims_xcommunity_room` (
  2282.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2283.   `uniacid` int(10) unsigned NOT NULL,
  2284.   `mobile` varchar(13) NOT NULL,
  2285.   `build` varchar(50) NOT NULL,
  2286.   `unit` int(10) NOT NULL,
  2287.   `house` varchar(50) NOT NULL,
  2288.   `room` varchar(50) NOT NULL,
  2289.   `code` varchar(10) NOT NULL,
  2290.   `realname` varchar(30) NOT NULL,
  2291.   `regionid` int(10) unsigned NOT NULL,
  2292.   `pid` int(10) unsigned NOT NULL,
  2293.   `status` int(1) unsigned NOT NULL,
  2294.   PRIMARY KEY (`id`)
  2295. ) ENGINE=MyISAM AUTO_INCREMENT=1028 DEFAULT CHARSET=utf8;
  2296. CREATE TABLE IF NOT EXISTS `ims_xcommunity_safety` (
  2297.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2298.   `uniacid` int(10) unsigned NOT NULL COMMENT '公众号id',
  2299.   `title` varchar(50) NOT NULL COMMENT '巡更点名称',
  2300.   `lng` varchar(10) NOT NULL COMMENT '坐标',
  2301.   `lat` varchar(10) NOT NULL COMMENT '坐标',
  2302.   `device_code` varchar(50) NOT NULL COMMENT '设备编号',
  2303.   `distance` int(11) NOT NULL COMMENT '定位距离',
  2304.   `enable` int(1) NOT NULL COMMENT '状态',
  2305.   `remark` varchar(100) NOT NULL COMMENT '备注',
  2306.   `regionid` int(11) NOT NULL COMMENT '小区id',
  2307.   `areaid` int(11) NOT NULL COMMENT '区域',
  2308.   `buildid` int(11) NOT NULL COMMENT '楼栋',
  2309.   `unitid` int(11) NOT NULL COMMENT '单元',
  2310.   `createtime` int(11) NOT NULL,
  2311.   `sort` int(11) NOT NULL COMMENT 'F排序',
  2312.   `card_num` varchar(50) DEFAULT NULL,
  2313.   PRIMARY KEY (`id`)
  2314. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='巡更点表';
  2315. CREATE TABLE IF NOT EXISTS `ims_xcommunity_safety_device_log` (
  2316.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2317.   `uniacid` int(10) unsigned NOT NULL COMMENT '公众号id',
  2318.   `safetyid` int(11) NOT NULL COMMENT '巡更点id',
  2319.   `lng` varchar(10) NOT NULL COMMENT '坐标',
  2320.   `lat` varchar(10) NOT NULL COMMENT '坐标',
  2321.   `acq_date` int(11) NOT NULL,
  2322.   `card_num` varchar(50) NOT NULL,
  2323.   `createtime` int(11) NOT NULL COMMENT '时间',
  2324.   `uid` int(11) NOT NULL,
  2325.   `logid` int(11) DEFAULT NULL,
  2326.   `device_code` varchar(50) DEFAULT NULL,
  2327.   PRIMARY KEY (`id`)
  2328. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='巡更设备记录表';
  2329. CREATE TABLE IF NOT EXISTS `ims_xcommunity_safety_line` (
  2330.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2331.   `uniacid` int(10) unsigned NOT NULL COMMENT '公众号id',
  2332.   `title` varchar(50) NOT NULL COMMENT '巡更路线名称',
  2333.   `status` int(1) NOT NULL COMMENT '1必须拍照2不需拍照',
  2334.   `enable` int(1) NOT NULL COMMENT '状态',
  2335.   `remark` varchar(100) NOT NULL COMMENT '备注',
  2336.   `regionid` int(11) NOT NULL COMMENT '小区id',
  2337.   `starttime` int(11) NOT NULL COMMENT '巡更开始时间',
  2338.   `endtime` int(11) NOT NULL COMMENT '巡更结束时间',
  2339.   `createtime` int(11) NOT NULL,
  2340.   PRIMARY KEY (`id`)
  2341. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='巡更路线表';
  2342. CREATE TABLE IF NOT EXISTS `ims_xcommunity_safety_line_category` (
  2343.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2344.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2345.   `lineid` int(11) NOT NULL,
  2346.   `cid` int(11) NOT NULL,
  2347.   PRIMARY KEY (`id`)
  2348. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='巡更路线点表';
  2349. CREATE TABLE IF NOT EXISTS `ims_xcommunity_search` (
  2350.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2351.   `weid` int(10) unsigned NOT NULL,
  2352.   `sname` varchar(30) NOT NULL,
  2353.   `surl` varchar(100) NOT NULL,
  2354.   `status` int(1) NOT NULL,
  2355.   `icon` varchar(1000) NOT NULL,
  2356.   `regionid` text NOT NULL,
  2357.   `uid` int(10) NOT NULL,
  2358.   `province` varchar(50) NOT NULL,
  2359.   `city` varchar(50) NOT NULL,
  2360.   `dist` varchar(50) NOT NULL,
  2361.   `uniacid` int(10) DEFAULT NULL,
  2362.   `allregion` int(1) DEFAULT NULL,
  2363.   PRIMARY KEY (`id`)
  2364. ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
  2365. CREATE TABLE IF NOT EXISTS `ims_xcommunity_search_region` (
  2366.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2367.   `sid` int(10) unsigned NOT NULL COMMENT '便民查询id',
  2368.   `regionid` int(11) NOT NULL COMMENT '小区id',
  2369.   PRIMARY KEY (`id`)
  2370. ) ENGINE=MyISAM AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='便民查询副表';
  2371. CREATE TABLE IF NOT EXISTS `ims_xcommunity_send_log` (
  2372.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2373.   `uniacid` int(10) unsigned NOT NULL,
  2374.   `sendid` int(1) NOT NULL,
  2375.   `status` int(1) NOT NULL,
  2376.   `uid` int(11) NOT NULL,
  2377.   `type` int(1) NOT NULL COMMENT '1公告,2房号',
  2378.   `cid` int(1) NOT NULL COMMENT '1微信2短信',
  2379.   `createtime` int(11) DEFAULT NULL,
  2380.   PRIMARY KEY (`id`)
  2381. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='发送记录';
  2382. CREATE TABLE IF NOT EXISTS `ims_xcommunity_service_data` (
  2383.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2384.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  2385.   `type` int(1) NOT NULL,
  2386.   `sub_mch_id` varchar(50) NOT NULL,
  2387.   `tid` int(11) NOT NULL,
  2388.   `userid` int(11) DEFAULT NULL,
  2389.   `uid` int(11) DEFAULT NULL,
  2390.   `sub_id` varchar(50) DEFAULT NULL,
  2391.   `apikey` varchar(50) DEFAULT NULL,
  2392.   `appid` varchar(50) DEFAULT NULL,
  2393.   `appsecret` varchar(50) DEFAULT NULL,
  2394.   PRIMARY KEY (`id`)
  2395. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  2396. CREATE TABLE IF NOT EXISTS `ims_xcommunity_service_set` (
  2397.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2398.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  2399.   `switch` int(1) NOT NULL,
  2400.   `mchid` varchar(50) NOT NULL,
  2401.   `signkey` varchar(50) NOT NULL,
  2402.   PRIMARY KEY (`id`)
  2403. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  2404. CREATE TABLE IF NOT EXISTS `ims_xcommunity_set` (
  2405.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2406.   `uniacid` int(10) unsigned NOT NULL,
  2407.   `code_status` int(10) unsigned NOT NULL,
  2408.   `room_status` int(10) unsigned NOT NULL,
  2409.   `room_enable` int(10) unsigned NOT NULL,
  2410.   `h_status` int(10) unsigned NOT NULL,
  2411.   `s_status` int(10) unsigned NOT NULL,
  2412.   `c_status` int(10) unsigned NOT NULL COMMENT ' ',
  2413.   `r_status` int(10) unsigned NOT NULL COMMENT ' ',
  2414.   `r_enable` int(10) unsigned NOT NULL,
  2415.   `region_status` int(10) unsigned NOT NULL,
  2416.   `business_status` int(10) unsigned NOT NULL,
  2417.   `visitor_status` int(10) unsigned NOT NULL,
  2418.   `range` int(10) unsigned NOT NULL,
  2419.   `tel` varchar(30) NOT NULL,
  2420.   `shop_credit` float NOT NULL,
  2421.   `business_credit` float NOT NULL,
  2422.   `cost_credit` float NOT NULL,
  2423.   `fled_status` int(1) unsigned NOT NULL,
  2424.   `house_status` int(1) unsigned NOT NULL,
  2425.   `car_status` int(1) unsigned NOT NULL,
  2426.   `open_status` int(1) unsigned NOT NULL,
  2427.   `repair_status` int(1) unsigned NOT NULL,
  2428.   `report_status` int(1) unsigned NOT NULL,
  2429.   `fleds_status` int(1) unsigned NOT NULL,
  2430.   `houselease_status` int(1) unsigned NOT NULL,
  2431.   `cars_status` int(1) unsigned NOT NULL,
  2432.   `door_status` int(11) DEFAULT NULL,
  2433.   `verify` int(11) DEFAULT NULL,
  2434.   PRIMARY KEY (`id`)
  2435. ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  2436. CREATE TABLE IF NOT EXISTS `ims_xcommunity_setting` (
  2437.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2438.   `uniacid` int(11) NOT NULL,
  2439.   `regionid` int(11) NOT NULL,
  2440.   `value` text NOT NULL,
  2441.   `key` varchar(100) NOT NULL,
  2442.   `xqkey` varchar(50) DEFAULT NULL,
  2443.   PRIMARY KEY (`id`)
  2444. ) ENGINE=MyISAM AUTO_INCREMENT=206 DEFAULT CHARSET=utf8;
  2445. CREATE TABLE IF NOT EXISTS `ims_xcommunity_shop` (
  2446.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2447.   `uniacid` int(10) unsigned NOT NULL,
  2448.   `uid` int(11) NOT NULL,
  2449.   `title` varchar(30) NOT NULL COMMENT '名称',
  2450.   `contactname` varchar(30) NOT NULL COMMENT '联系人',
  2451.   `mobile` varchar(12) NOT NULL COMMENT '电话',
  2452.   `createtime` int(10) unsigned NOT NULL,
  2453.   `type` int(1) DEFAULT '1',
  2454.   `commission` varchar(50) DEFAULT '0,0',
  2455.   `status` tinyint(1) DEFAULT NULL,
  2456.   PRIMARY KEY (`id`)
  2457. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='超市表';
  2458. CREATE TABLE IF NOT EXISTS `ims_xcommunity_shop_print` (
  2459.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2460.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2461.   `shopid` int(11) NOT NULL,
  2462.   `api_key` varchar(150) NOT NULL COMMENT 'API密钥',
  2463.   `deviceNo` varchar(150) NOT NULL COMMENT '终端编号',
  2464.   `type` int(1) NOT NULL,
  2465.   `uid` int(11) NOT NULL,
  2466.   `shoptype` int(1) DEFAULT '1',
  2467.   PRIMARY KEY (`id`)
  2468. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='超市打印机';
  2469. CREATE TABLE IF NOT EXISTS `ims_xcommunity_shop_wechat` (
  2470.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2471.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2472.   `shopid` int(11) NOT NULL,
  2473.   `openid` varchar(50) NOT NULL COMMENT '粉丝openid',
  2474.   `realname` varchar(150) NOT NULL COMMENT '姓名',
  2475.   `mobile` varchar(14) NOT NULL COMMENT '电话',
  2476.   `enable` int(1) NOT NULL COMMENT '是否开启',
  2477.   `type` int(1) NOT NULL COMMENT '1微信2短信3全部',
  2478.   `uid` int(11) NOT NULL,
  2479.   `shoptype` int(1) DEFAULT '1',
  2480.   `province` varchar(50) DEFAULT NULL,
  2481.   `city` varchar(50) DEFAULT NULL,
  2482.   `dist` varchar(50) DEFAULT NULL,
  2483.   `allregion` tinyint(1) DEFAULT '0',
  2484.   PRIMARY KEY (`id`)
  2485. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='超市接收员';
  2486. CREATE TABLE IF NOT EXISTS `ims_xcommunity_shop_wechatregion` (
  2487.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2488.   `wechatid` int(10) unsigned NOT NULL,
  2489.   `regionid` int(10) unsigned NOT NULL,
  2490.   PRIMARY KEY (`id`)
  2491. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  2492. CREATE TABLE IF NOT EXISTS `ims_xcommunity_slide` (
  2493.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2494.   `weid` int(11) NOT NULL,
  2495.   `displayorder` int(10) NOT NULL,
  2496.   `title` varchar(30) NOT NULL,
  2497.   `thumb` varchar(200) NOT NULL,
  2498.   `url` text,
  2499.   `regionid` text NOT NULL,
  2500.   `type` int(11) NOT NULL,
  2501.   `province` varchar(50) NOT NULL,
  2502.   `city` varchar(50) NOT NULL,
  2503.   `dist` varchar(50) NOT NULL,
  2504.   `uid` int(11) DEFAULT NULL,
  2505.   `status` int(1) DEFAULT '1',
  2506.   `uniacid` int(11) DEFAULT NULL,
  2507.   `createtime` int(10) DEFAULT NULL,
  2508.   `allregion` int(1) DEFAULT NULL,
  2509.   `starttime` int(10) unsigned DEFAULT '1508666301',
  2510.   `endtime` int(10) unsigned DEFAULT '1571738301',
  2511.   PRIMARY KEY (`id`)
  2512. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
  2513. CREATE TABLE IF NOT EXISTS `ims_xcommunity_slide_region` (
  2514.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2515.   `sid` int(11) NOT NULL COMMENT '幻灯id',
  2516.   `regionid` int(11) NOT NULL COMMENT '小区id',
  2517.   PRIMARY KEY (`id`)
  2518. ) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8;
  2519. CREATE TABLE IF NOT EXISTS `ims_xcommunity_staff` (
  2520.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2521.   `uniacid` int(11) NOT NULL,
  2522.   `realname` varchar(50) NOT NULL,
  2523.   `mobile` varchar(15) NOT NULL,
  2524.   `nickname` varchar(50) NOT NULL,
  2525.   `wechat` varchar(50) NOT NULL,
  2526.   `openid` varchar(50) NOT NULL,
  2527.   `mail` varchar(50) NOT NULL,
  2528.   `departmentid` int(11) NOT NULL,
  2529.   `position` varchar(50) NOT NULL,
  2530.   `remark` text NOT NULL,
  2531.   `type` int(1) NOT NULL,
  2532.   `uid` int(11) DEFAULT NULL,
  2533.   `pid` int(11) DEFAULT NULL,
  2534.   PRIMARY KEY (`id`)
  2535. ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  2536. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park` (
  2537.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2538.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2539.   `park_id` varchar(32) NOT NULL,
  2540.   `park_name` varchar(50) NOT NULL,
  2541.   `city` varchar(50) NOT NULL,
  2542.   `total_spaces` int(32) NOT NULL,
  2543.   `remain_spaces` int(32) NOT NULL,
  2544.   `createtime` int(11) NOT NULL,
  2545.   `parkid` int(11) NOT NULL,
  2546.   `last_time` varchar(20) DEFAULT NULL,
  2547.   `company_id` varchar(32) DEFAULT NULL,
  2548.   `type_code` varchar(50) DEFAULT NULL,
  2549.   `type_name` varchar(50) DEFAULT NULL,
  2550.   `year_price` decimal(9,2) DEFAULT NULL,
  2551.   `month_price` decimal(9,2) DEFAULT NULL,
  2552.   `day_price` decimal(9,2) DEFAULT NULL,
  2553.   `power_id` int(11) DEFAULT NULL,
  2554.   `power_name` varchar(50) DEFAULT NULL,
  2555.   PRIMARY KEY (`id`)
  2556. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2557. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park_car_record` (
  2558.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2559.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2560.   `createtime` int(11) NOT NULL,
  2561.   `time` int(11) NOT NULL,
  2562.   `car_no` varchar(50) DEFAULT NULL,
  2563.   PRIMARY KEY (`id`)
  2564. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2565. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park_cardtypes` (
  2566.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2567.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2568.   `park_id` varchar(32) NOT NULL,
  2569.   `type_code` varchar(50) DEFAULT NULL,
  2570.   `type_name` varchar(50) DEFAULT NULL,
  2571.   `year_price` decimal(9,2) DEFAULT NULL,
  2572.   `month_price` decimal(9,2) DEFAULT NULL,
  2573.   `day_price` decimal(9,2) DEFAULT NULL,
  2574.   `parkid` int(11) NOT NULL,
  2575.   PRIMARY KEY (`id`)
  2576. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2577. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park_cars` (
  2578.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2579.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2580.   `id_card` varchar(50) NOT NULL,
  2581.   `card_no` varchar(50) NOT NULL,
  2582.   `card_name` varchar(50) NOT NULL,
  2583.   `issued_by` varchar(50) NOT NULL,
  2584.   `issued_date` int(11) NOT NULL,
  2585.   `renew_date` int(11) DEFAULT NULL,
  2586.   `start_date` int(11) DEFAULT NULL,
  2587.   `valid_date` int(11) DEFAULT NULL,
  2588.   `createtime` int(11) DEFAULT NULL,
  2589.   `deposit` int(11) DEFAULT NULL,
  2590.   `month_fee` decimal(9,2) DEFAULT NULL,
  2591.   `car_no` varchar(50) DEFAULT NULL,
  2592.   `car_type` varchar(50) DEFAULT NULL,
  2593.   `car_pos` varchar(50) DEFAULT NULL,
  2594.   `realname` varchar(50) DEFAULT NULL,
  2595.   `address` varchar(100) DEFAULT NULL,
  2596.   `uid` int(11) DEFAULT NULL,
  2597.   `phone` varchar(50) DEFAULT NULL,
  2598.   `mobile` varchar(50) DEFAULT NULL,
  2599.   `remark` varchar(200) DEFAULT NULL,
  2600.   `card_status` varchar(10) DEFAULT NULL,
  2601.   `park_id` int(11) NOT NULL,
  2602.   `openid` varchar(50) DEFAULT NULL,
  2603.   `status` int(1) DEFAULT NULL,
  2604.   PRIMARY KEY (`id`)
  2605. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2606. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park_order` (
  2607.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2608.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2609.   `uid` int(11) NOT NULL,
  2610.   `parkid` int(11) NOT NULL,
  2611.   `carid` int(11) NOT NULL,
  2612.   `park_id` varchar(32) NOT NULL,
  2613.   `park_serial` varchar(50) NOT NULL,
  2614.   `car_no` varchar(50) NOT NULL,
  2615.   `begin_date` int(11) NOT NULL,
  2616.   `end_date` int(11) NOT NULL,
  2617.   `pay_fee` decimal(9,2) NOT NULL,
  2618.   `toll_date` int(10) NOT NULL,
  2619.   `toll_by` varchar(50) NOT NULL,
  2620.   `remark` varchar(200) NOT NULL,
  2621.   `status` int(1) NOT NULL,
  2622.   `code` int(1) NOT NULL,
  2623.   `enable` int(1) DEFAULT NULL,
  2624.   `num` int(11) DEFAULT NULL,
  2625.   PRIMARY KEY (`id`)
  2626. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2627. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park_powers` (
  2628.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2629.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2630.   `park_id` varchar(32) NOT NULL,
  2631.   `power_id` int(11) DEFAULT NULL,
  2632.   `power_name` varchar(50) DEFAULT NULL,
  2633.   `parkid` int(11) NOT NULL,
  2634.   PRIMARY KEY (`id`)
  2635. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2636. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park_set` (
  2637.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2638.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2639.   `status` int(11) NOT NULL,
  2640.   `expire_num` int(11) NOT NULL,
  2641.   `arrears_num` int(11) DEFAULT NULL,
  2642.   `remind_num` int(11) DEFAULT NULL,
  2643.   `tjtime` int(11) DEFAULT NULL,
  2644.   `car_tpl` varchar(50) DEFAULT NULL,
  2645.   PRIMARY KEY (`id`)
  2646. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2647. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park_setting` (
  2648.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2649.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2650.   `title` varchar(100) NOT NULL COMMENT '链接',
  2651.   `company_id` varchar(32) NOT NULL,
  2652.   `sign_key` varchar(32) NOT NULL,
  2653.   `access_secret` varchar(32) NOT NULL,
  2654.   `createtime` int(11) DEFAULT NULL,
  2655.   PRIMARY KEY (`id`)
  2656. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2657. CREATE TABLE IF NOT EXISTS `ims_xcommunity_stop_park_temp` (
  2658.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2659.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2660.   `park_id` varchar(32) NOT NULL COMMENT '车场ID',
  2661.   `park_serial` varchar(50) NOT NULL COMMENT '记录流水号,车场惟一',
  2662.   `car_no` varchar(10) NOT NULL COMMENT '车牌号',
  2663.   `car_owner` varchar(50) NOT NULL COMMENT '车主',
  2664.   `in_time` int(11) NOT NULL COMMENT '入场时间',
  2665.   `out_time` int(11) NOT NULL COMMENT '出场时间',
  2666.   `should_charge` decimal(9,2) NOT NULL COMMENT '应收金额',
  2667.   `charge_fee` decimal(9,2) NOT NULL COMMENT '实收现金',
  2668.   `online_charge` decimal(9,2) NOT NULL COMMENT '手机支付',
  2669.   `free_charge` decimal(9,2) NOT NULL COMMENT '免费金额',
  2670.   `charged_by` varchar(50) NOT NULL COMMENT '收费员',
  2671.   `toll_date` int(11) NOT NULL COMMENT '收费时间',
  2672.   `parkid` int(10) NOT NULL,
  2673.   PRIMARY KEY (`id`)
  2674. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  2675. CREATE TABLE IF NOT EXISTS `ims_xcommunity_supermark` (
  2676.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2677.   `uniacid` int(11) NOT NULL,
  2678.   `title` varchar(30) NOT NULL,
  2679.   `tel` varchar(15) NOT NULL,
  2680.   `copy` varchar(100) NOT NULL,
  2681.   `code` int(11) NOT NULL,
  2682.   `device_code` varchar(30) NOT NULL,
  2683.   `uid` int(11) NOT NULL,
  2684.   `lat` varchar(30) NOT NULL,
  2685.   `lng` varchar(30) NOT NULL,
  2686.   `range` int(11) NOT NULL,
  2687.   `address` varchar(255) NOT NULL,
  2688.   PRIMARY KEY (`id`)
  2689. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  2690. CREATE TABLE IF NOT EXISTS `ims_xcommunity_supermark_order` (
  2691.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2692.   `uniacid` int(11) NOT NULL,
  2693.   `ordersn` varchar(30) NOT NULL,
  2694.   `price` varchar(15) NOT NULL,
  2695.   `goods` text NOT NULL,
  2696.   `status` int(1) NOT NULL,
  2697.   `createtime` int(11) NOT NULL,
  2698.   `openid` varchar(50) NOT NULL,
  2699.   `uid` int(11) NOT NULL,
  2700.   `code` varchar(30) DEFAULT NULL,
  2701.   PRIMARY KEY (`id`)
  2702. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  2703. CREATE TABLE IF NOT EXISTS `ims_xcommunity_swiftpass` (
  2704.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2705.   `uniacid` int(10) NOT NULL,
  2706.   `type` int(1) NOT NULL COMMENT '新增类型',
  2707.   `userid` int(11) NOT NULL COMMENT '存小区id或者操作员id',
  2708.   `account` varchar(50) NOT NULL,
  2709.   `secret` varchar(50) NOT NULL,
  2710.   `uid` int(11) NOT NULL,
  2711.   `appid` varchar(50) DEFAULT NULL,
  2712.   `appsecret` varchar(50) DEFAULT NULL,
  2713.   `banktype` tinyint(1) DEFAULT NULL,
  2714.   `private_key` text,
  2715.   PRIMARY KEY (`id`)
  2716. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='威富通微信支付配置';
  2717. CREATE TABLE IF NOT EXISTS `ims_xcommunity_template` (
  2718.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2719.   `uniacid` int(10) unsigned NOT NULL,
  2720.   `styleid` int(10) unsigned NOT NULL,
  2721.   PRIMARY KEY (`id`)
  2722. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  2723. CREATE TABLE IF NOT EXISTS `ims_xcommunity_unit` (
  2724.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2725.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2726.   `buildid` int(11) NOT NULL,
  2727.   `unit` varchar(50) NOT NULL,
  2728.   `uid` int(11) DEFAULT NULL,
  2729.   `buildtitle` varchar(30) DEFAULT NULL,
  2730.   `regionid` int(11) DEFAULT NULL,
  2731.   `action` tinyint(1) DEFAULT NULL,
  2732.   `yybstatus` tinyint(1) DEFAULT NULL,
  2733.   `yybunitid` int(11) DEFAULT NULL,
  2734.   `unitId` int(11) DEFAULT NULL,
  2735.   PRIMARY KEY (`id`)
  2736. ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
  2737. CREATE TABLE IF NOT EXISTS `ims_xcommunity_user_news` (
  2738.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2739.   `uniacid` int(11) NOT NULL,
  2740.   `regionid` int(11) NOT NULL,
  2741.   `uid` int(11) NOT NULL,
  2742.   `title` varchar(100) NOT NULL,
  2743.   `content` varchar(255) NOT NULL,
  2744.   `createtime` int(11) NOT NULL,
  2745.   PRIMARY KEY (`id`)
  2746. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  2747. CREATE TABLE IF NOT EXISTS `ims_xcommunity_user_open_log` (
  2748.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2749.   `uniacid` int(11) NOT NULL,
  2750.   `uid` int(11) NOT NULL,
  2751.   `num` int(1) NOT NULL,
  2752.   PRIMARY KEY (`id`)
  2753. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  2754. CREATE TABLE IF NOT EXISTS `ims_xcommunity_users` (
  2755.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2756.   `uniacid` int(10) unsigned NOT NULL,
  2757.   `uid` int(10) unsigned NOT NULL,
  2758.   `uuid` int(10) unsigned NOT NULL,
  2759.   `companyid` int(11) NOT NULL,
  2760.   `regionid` int(11) NOT NULL,
  2761.   `menus` text,
  2762.   `balance` decimal(10,2) NOT NULL,
  2763.   `commission` float NOT NULL,
  2764.   `groupid` int(11) NOT NULL,
  2765.   `type` int(1) DEFAULT NULL,
  2766.   `province` varchar(100) DEFAULT NULL,
  2767.   `city` varchar(100) DEFAULT NULL,
  2768.   `dist` varchar(100) DEFAULT NULL,
  2769.   `xqcommission` float DEFAULT NULL,
  2770.   `xqmenus` varchar(255) DEFAULT NULL,
  2771.   `createtime` int(10) DEFAULT NULL,
  2772.   `perms` text,
  2773.   `staffid` int(11) DEFAULT NULL,
  2774.   `pid` int(11) DEFAULT NULL,
  2775.   `departmentid` int(11) DEFAULT NULL,
  2776.   `xqtype` int(1) DEFAULT NULL,
  2777.   `account` decimal(10,2) DEFAULT NULL,
  2778.   `plugin` text,
  2779.   `credit` decimal(10,2) DEFAULT NULL,
  2780.   `creditstatus` int(1) DEFAULT NULL,
  2781.   `integral` int(3) DEFAULT NULL,
  2782.   `txpay` varchar(100) DEFAULT NULL,
  2783.   `txcid` varchar(100) DEFAULT NULL,
  2784.   `store` text,
  2785.   `roleid` int(11) DEFAULT NULL,
  2786.   PRIMARY KEY (`id`)
  2787. ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  2788. CREATE TABLE IF NOT EXISTS `ims_xcommunity_users_group` (
  2789.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2790.   `uniacid` int(10) unsigned NOT NULL DEFAULT '0',
  2791.   `title` varchar(50) NOT NULL,
  2792.   `maxaccount` int(11) NOT NULL,
  2793.   PRIMARY KEY (`id`)
  2794. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  2795. CREATE TABLE IF NOT EXISTS `ims_xcommunity_users_log` (
  2796.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2797.   `uniacid` int(11) NOT NULL,
  2798.   `uid` int(11) NOT NULL,
  2799.   `name` varchar(255) NOT NULL,
  2800.   `type` varchar(255) NOT NULL,
  2801.   `op` text,
  2802.   `createtime` int(11) NOT NULL,
  2803.   `ip` varchar(30) NOT NULL,
  2804.   PRIMARY KEY (`id`)
  2805. ) ENGINE=MyISAM AUTO_INCREMENT=239 DEFAULT CHARSET=utf8;
  2806. CREATE TABLE IF NOT EXISTS `ims_xcommunity_users_region` (
  2807.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2808.   `regionid` int(10) unsigned NOT NULL,
  2809.   `usersid` int(10) unsigned NOT NULL,
  2810.   PRIMARY KEY (`id`)
  2811. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  2812. CREATE TABLE IF NOT EXISTS `ims_xcommunity_visitor_admin` (
  2813.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2814.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2815.   `regionids` text NOT NULL COMMENT '小区id',
  2816.   `nickname` varchar(50) NOT NULL COMMENT '管理员姓名',
  2817.   `openid` varchar(50) NOT NULL COMMENT '管理员粉丝编号',
  2818.   `status` int(1) NOT NULL COMMENT '是否启用',
  2819.   PRIMARY KEY (`id`)
  2820. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='访客管理员';
  2821. CREATE TABLE IF NOT EXISTS `ims_xcommunity_visitor_log` (
  2822.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2823.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2824.   `regionid` int(11) NOT NULL COMMENT '小区id',
  2825.   `visitor_name` varchar(50) NOT NULL COMMENT '访客姓名',
  2826.   `visitor_num` int(1) NOT NULL COMMENT '访客人数',
  2827.   `carno` varchar(14) NOT NULL COMMENT '车牌号',
  2828.   `visiting_time` int(11) NOT NULL COMMENT '到访日期',
  2829.   `visiting_status` tinyint(1) NOT NULL COMMENT '访客状态,已到访,未到访',
  2830.   `uid` int(11) NOT NULL COMMENT '邀请人',
  2831.   `appli_name` varchar(50) NOT NULL COMMENT '申请人姓名',
  2832.   `appli_mobile` varchar(13) NOT NULL COMMENT '申请人电话',
  2833.   `appli_room` varchar(50) NOT NULL COMMENT '申请人房号',
  2834.   PRIMARY KEY (`id`)
  2835. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='邀请访客';
  2836. CREATE TABLE IF NOT EXISTS `ims_xcommunity_vote` (
  2837.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2838.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2839.   `title` varchar(30) NOT NULL COMMENT '名称',
  2840.   `thumb` varchar(200) NOT NULL COMMENT '图片',
  2841.   `uid` int(11) NOT NULL COMMENT '操作员id',
  2842.   `content` text NOT NULL COMMENT '描述',
  2843.   `confirm` varchar(200) NOT NULL COMMENT '确认说明',
  2844.   `starttime` int(10) unsigned NOT NULL COMMENT '投票开始时间',
  2845.   `endtime` int(10) unsigned NOT NULL COMMENT '投票结束时间',
  2846.   `enable` int(1) NOT NULL COMMENT '1未发布2发布',
  2847.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间,新增',
  2848.   `province` varchar(50) DEFAULT NULL,
  2849.   `city` varchar(50) DEFAULT NULL,
  2850.   `dist` varchar(50) DEFAULT NULL,
  2851.   `allregion` int(1) DEFAULT NULL,
  2852.   `num` int(11) DEFAULT '0',
  2853.   PRIMARY KEY (`id`),
  2854.   KEY `index` (`id`,`uid`,`uniacid`)
  2855. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='问卷表';
  2856. CREATE TABLE IF NOT EXISTS `ims_xcommunity_vote_options` (
  2857.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2858.   `questionid` int(11) NOT NULL COMMENT '问题id',
  2859.   `title` varchar(250) NOT NULL COMMENT '选项内容',
  2860.   `remark` varchar(250) NOT NULL COMMENT '备注',
  2861.   `sort` int(11) NOT NULL COMMENT '问题选项排序',
  2862.   `isother` int(1) NOT NULL COMMENT '是否有其他',
  2863.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间,新增',
  2864.   PRIMARY KEY (`id`),
  2865.   KEY `index` (`id`,`questionid`)
  2866. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='选项表';
  2867. CREATE TABLE IF NOT EXISTS `ims_xcommunity_vote_question` (
  2868.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2869.   `voteid` int(11) NOT NULL COMMENT '问卷id',
  2870.   `title` varchar(250) NOT NULL COMMENT '名称',
  2871.   `remark` text NOT NULL COMMENT '描述',
  2872.   `type` int(1) NOT NULL COMMENT '问题类型1单选2多选3填空',
  2873.   `sort` int(11) NOT NULL COMMENT '问题排序',
  2874.   `isrequired` int(1) NOT NULL COMMENT '是否必填',
  2875.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间,新增',
  2876.   `maxnum` int(2) DEFAULT NULL,
  2877.   PRIMARY KEY (`id`),
  2878.   KEY `index` (`id`,`voteid`)
  2879. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='问题表';
  2880. CREATE TABLE IF NOT EXISTS `ims_xcommunity_vote_user` (
  2881.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2882.   `uid` int(11) NOT NULL COMMENT 'uid',
  2883.   `voteid` int(11) NOT NULL COMMENT '问卷id',
  2884.   `openid` varchar(50) NOT NULL COMMENT '粉丝id',
  2885.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间,新增',
  2886.   `addressid` int(11) DEFAULT NULL,
  2887.   `enable` tinyint(1) DEFAULT '0',
  2888.   PRIMARY KEY (`id`),
  2889.   KEY `index` (`id`,`uid`,`voteid`)
  2890. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户表';
  2891. CREATE TABLE IF NOT EXISTS `ims_xcommunity_vote_user_answer` (
  2892.   `id` int(11) NOT NULL AUTO_INCREMENT,
  2893.   `userid` int(11) NOT NULL COMMENT '用户id',
  2894.   `questionid` int(11) NOT NULL COMMENT '问题id',
  2895.   `optionsid` int(11) NOT NULL COMMENT '选项id',
  2896.   `content` text NOT NULL COMMENT '为填空的内容',
  2897.   `createtime` int(10) unsigned NOT NULL COMMENT '创建时间,新增',
  2898.   `type` int(1) DEFAULT NULL,
  2899.   PRIMARY KEY (`id`),
  2900.   KEY `index` (`id`,`userid`,`questionid`,`optionsid`)
  2901. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户答案表';
  2902. CREATE TABLE IF NOT EXISTS `ims_xcommunity_wechat` (
  2903.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2904.   `uniacid` int(10) NOT NULL,
  2905.   `type` int(1) NOT NULL COMMENT '新增类型',
  2906.   `userid` int(11) NOT NULL COMMENT '存小区id或者操作员id',
  2907.   `appid` varchar(50) NOT NULL,
  2908.   `appsecret` varchar(50) NOT NULL,
  2909.   `mchid` varchar(50) NOT NULL,
  2910.   `apikey` varchar(50) NOT NULL,
  2911.   `uid` int(11) NOT NULL,
  2912.   PRIMARY KEY (`id`)
  2913. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信配置';
  2914. CREATE TABLE IF NOT EXISTS `ims_xcommunity_wechat_notice` (
  2915.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2916.   `uniacid` int(10) unsigned NOT NULL,
  2917.   `regionid` text NOT NULL,
  2918.   `fansopenid` varchar(50) NOT NULL,
  2919.   `repair_status` int(1) NOT NULL,
  2920.   `report_status` int(1) NOT NULL,
  2921.   `shopping_status` int(1) NOT NULL,
  2922.   `business_status` int(1) NOT NULL,
  2923.   `homemaking_status` int(1) NOT NULL,
  2924.   `cost_status` int(1) NOT NULL,
  2925.   `change_status` int(1) NOT NULL,
  2926.   `type` int(1) NOT NULL,
  2927.   `uid` int(11) NOT NULL,
  2928.   `province` varchar(50) NOT NULL,
  2929.   `city` varchar(50) NOT NULL,
  2930.   `dist` varchar(50) NOT NULL,
  2931.   `notice_status` int(11) DEFAULT NULL,
  2932.   `repair` int(1) DEFAULT NULL,
  2933.   `report` int(1) DEFAULT NULL,
  2934.   `shopping` int(1) DEFAULT NULL,
  2935.   `business` int(1) DEFAULT NULL,
  2936.   `homemaking` int(1) DEFAULT NULL,
  2937.   `cost` int(1) DEFAULT NULL,
  2938.   `notice` int(1) DEFAULT NULL,
  2939.   `staffid` int(11) DEFAULT NULL,
  2940.   PRIMARY KEY (`id`)
  2941. ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  2942. CREATE TABLE IF NOT EXISTS `ims_xcommunity_wechat_notice_region` (
  2943.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2944.   `nid` int(10) unsigned NOT NULL,
  2945.   `regionid` int(11) NOT NULL,
  2946.   PRIMARY KEY (`id`)
  2947. ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='通知副表';
  2948. CREATE TABLE IF NOT EXISTS `ims_xcommunity_wechat_smsid` (
  2949.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2950.   `uniacid` int(10) unsigned NOT NULL,
  2951.   `shopping_id` int(11) NOT NULL,
  2952.   `property_id` int(11) NOT NULL,
  2953.   `room_id` int(11) NOT NULL,
  2954.   `sms_account` varchar(80) NOT NULL,
  2955.   `verify` int(1) NOT NULL,
  2956.   `businesscode` int(1) NOT NULL,
  2957.   `verifycode` int(1) NOT NULL,
  2958.   `report_type` int(1) NOT NULL,
  2959.   `shopping_status` int(1) NOT NULL,
  2960.   `property_status` int(1) NOT NULL,
  2961.   `room_status` int(1) NOT NULL,
  2962.   `reportid` int(11) NOT NULL,
  2963.   `resgisterid` int(11) NOT NULL,
  2964.   PRIMARY KEY (`id`)
  2965. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  2966. CREATE TABLE IF NOT EXISTS `ims_xcommunity_wechat_tplid` (
  2967.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2968.   `uniacid` int(10) unsigned NOT NULL,
  2969.   `property_tplid` varchar(80) NOT NULL,
  2970.   `water_tplid` varchar(80) NOT NULL,
  2971.   `gas_tplid` varchar(80) NOT NULL,
  2972.   `power_tplid` varchar(80) NOT NULL,
  2973.   `guard_tplid` varchar(80) NOT NULL,
  2974.   `lift_tplid` varchar(80) NOT NULL,
  2975.   `car_tplid` varchar(80) NOT NULL,
  2976.   `shopping_tplid` varchar(80) NOT NULL,
  2977.   `repair_tplid` varchar(80) NOT NULL,
  2978.   `report_tplid` varchar(80) NOT NULL,
  2979.   `other_tplid` varchar(80) NOT NULL,
  2980.   `good_tplid` varchar(80) NOT NULL,
  2981.   `grab_wc_tplid` varchar(80) NOT NULL,
  2982.   `report_wc_tplid` varchar(80) NOT NULL,
  2983.   `homemaking_tplid` varchar(80) NOT NULL,
  2984.   `business_status` varchar(80) NOT NULL,
  2985.   PRIMARY KEY (`id`)
  2986. ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  2987. CREATE TABLE IF NOT EXISTS `ims_xcommunity_wxapp_setting` (
  2988.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  2989.   `uniacid` int(11) NOT NULL COMMENT '公众号id',
  2990.   `appid` varchar(50) NOT NULL,
  2991.   `appsecret` varchar(50) NOT NULL,
  2992.   `mchid` int(11) NOT NULL,
  2993.   `apikey` varchar(50) NOT NULL,
  2994.   `title` varchar(50) NOT NULL,
  2995.   `url` text NOT NULL,
  2996.   `packtitle` varchar(50) DEFAULT NULL,
  2997.   `packname` varchar(50) DEFAULT NULL,
  2998.   `createtime` int(11) DEFAULT NULL,
  2999.   PRIMARY KEY (`id`)
  3000. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  3001. CREATE TABLE IF NOT EXISTS `ims_xcommunity_xqcars` (
  3002.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3003.   `uniacid` int(10) unsigned NOT NULL,
  3004.   `regionid` int(11) NOT NULL,
  3005.   `parkingid` int(11) NOT NULL,
  3006.   `realname` varchar(20) NOT NULL,
  3007.   `mobile` varchar(13) NOT NULL,
  3008.   `card_num` varchar(30) NOT NULL,
  3009.   `car_num` varchar(30) NOT NULL,
  3010.   `createtime` int(11) NOT NULL,
  3011.   `uid` int(11) NOT NULL,
  3012.   `addressid` int(11) DEFAULT '0',
  3013.   PRIMARY KEY (`id`)
  3014. ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='车辆管理';
  3015. CREATE TABLE IF NOT EXISTS `ims_xcommunity_xqnotice` (
  3016.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3017.   `uniacid` int(11) NOT NULL,
  3018.   `status` int(1) NOT NULL,
  3019.   `uid` int(11) NOT NULL COMMENT '当前操作员uid',
  3020.   `userid` int(11) NOT NULL COMMENT '绑定用户uid',
  3021.   `enable` int(11) NOT NULL COMMENT '1短信 2微信',
  3022.   `type` int(1) NOT NULL COMMENT '1超市/商家 2物业 3全部',
  3023.   `username` varchar(50) NOT NULL COMMENT '手机号码/openid',
  3024.   `api` varchar(50) NOT NULL COMMENT '打印机api',
  3025.   `device` varchar(50) NOT NULL COMMENT '打印机终端编号',
  3026.   `createtime` int(11) NOT NULL COMMENT '创建时间',
  3027.   `province` varchar(50) NOT NULL,
  3028.   `city` varchar(50) NOT NULL,
  3029.   `dist` varchar(50) NOT NULL,
  3030.   `regionid` text NOT NULL,
  3031.   PRIMARY KEY (`id`)
  3032. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='通知';
复制代码


0

主题

216

帖子

10

积分

一翼天使

Rank: 1

天使之心
0
注册时间
2019-2-23
发表于 2019-4-10 16:43:41 | 显示全部楼层
感谢一楼  还在想啥问题怎么回事呢

QQ|手机版|小黑屋|折翼天使资源社区 ( 鄂ICP备14011314号 鄂公网安备42050202000052号 )

GMT+8, 2019-8-24 17:37 , Processed in 0.097735 second(s), 30 queries .

Powered by 折翼天使

© 2001-2013 Www.ZheYiTianShi.Com

快速回复 返回顶部 返回列表