智云物业 4.8.5 公众号+小程序 以物业管理为核心 打造智慧社区云管理平台

<?php $sql=" CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_activity` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `pid` int(10) NOT NULL, `rid` int(10) NOT NULL, `title` varchar(60) DEFAULT NULL, `category` tinyint(1) NOT NULL DEFAULT '0', `startdate` int(11) NOT NULL, `enddate` int(11) NOT NULL, `image` varchar(255) DEFAULT NULL, `content` text, `replydesc` varchar(200) DEFAULT NULL, `style` tinyint(1) NOT NULL DEFAULT '0', `checkmethod` tinyint(1) NOT NULL DEFAULT '0', `votetype` tinyint(1) NOT NULL DEFAULT '0', `votemethod` tinyint(1) NOT NULL DEFAULT '0', `votetext` varchar(1000) DEFAULT NULL, `singleimage` varchar(255) DEFAULT NULL, `singledesc` varchar(200) DEFAULT NULL, `multimages` text, `isvotesign` tinyint(1) NOT NULL DEFAULT '0', `signstart` int(11) NOT NULL, `signend` int(11) NOT NULL, `signmoney` int(11) NOT NULL, `signnum` int(6) NOT NULL, `signmeas` tinyint(1) NOT NULL DEFAULT '0', `signextend` varchar(1000) DEFAULT NULL, `question` text, `remark` varchar(200) DEFAULT NULL, `issignature` tinyint(1) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0', `cuid` int(10) NOT NULL, `ctime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `pid` (`pid`), KEY `rid` (`rid`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_activity_sign` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `actid` int(10) NOT NULL, `uid` int(10) NOT NULL, `realname` varchar(50) NOT NULL, `mobile` varchar(20) NOT NULL, `extend_1` varchar(100) DEFAULT NULL, `extend_2` varchar(100) DEFAULT NULL, `extend_3` varchar(100) DEFAULT NULL, `extend_4` varchar(100) DEFAULT NULL, `extend_5` varchar(100) DEFAULT NULL, `extend_6` varchar(100) DEFAULT NULL, `extend_7` varchar(100) DEFAULT NULL, `extend_8` varchar(100) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `ctime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `actid` (`actid`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_activity_vote` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `actid` int(10) NOT NULL, `voteid` int(4) NOT NULL, `votenum` int(10) NOT NULL, `uid` int(10) NOT NULL, `signature` varchar(255) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `ctime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `actid` (`actid`), KEY `voteid` (`voteid`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_area` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键 省市区ID', `parent_id` int(10) DEFAULT NULL COMMENT '父ID', `level` smallint(1) DEFAULT NULL COMMENT '层级', `code` varchar(20) DEFAULT NULL COMMENT '行政代码', `name` varchar(20) DEFAULT NULL COMMENT '行政名称', `longitude` varchar(30) DEFAULT NULL COMMENT '经度', `latitude` varchar(30) DEFAULT NULL COMMENT '纬度', `pinyin` varchar(255) DEFAULT NULL COMMENT '拼音', PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), KEY `idx_level` (`level`), KEY `idx_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_article` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `weid` int(11) DEFAULT '0', `pid` int(10) NOT NULL, `rid` int(10) NOT NULL, `cid` int(11) DEFAULT '0', `title` varchar(50) DEFAULT NULL, `desc` varchar(255) DEFAULT NULL, `first` varchar(255) DEFAULT NULL, `remark` varchar(255) DEFAULT NULL, `thumb` varchar(255) DEFAULT NULL, `images` text, `content` mediumtext, `url` varchar(255) DEFAULT NULL, `displayorder` tinyint(3) unsigned DEFAULT '0', `status` tinyint(1) DEFAULT '0', `isrecommand` tinyint(3) DEFAULT '0', `cuid` int(10) NOT NULL, `ctime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `pid` (`pid`), KEY `rid` (`rid`), KEY `cid` (`cid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_article_category` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `weid` int(11) DEFAULT '0', `pid` int(10) NOT NULL, `rid` int(10) NOT NULL, `title` varchar(50) DEFAULT NULL, `thumb` varchar(255) DEFAULT NULL, `displayorder` tinyint(3) unsigned DEFAULT '0', `enabled` tinyint(1) DEFAULT '1', `isrecommand` tinyint(3) DEFAULT '0', PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `pid` (`pid`), KEY `rid` (`rid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_article_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `aid` int(10) NOT NULL, `uid` int(10) NOT NULL, `openid` varchar(60) NOT NULL DEFAULT '0', `ctime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `aid` (`aid`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_banner` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `title` varchar(60) NOT NULL, `desc` varchar(60) DEFAULT NULL, `btype` tinyint(3) NOT NULL, `link` varchar(255) DEFAULT NULL, `wxappid` varchar(30) DEFAULT NULL, `wxapppage` varchar(255) DEFAULT NULL, `bgimage` varchar(255) DEFAULT NULL, `thumb` varchar(255) DEFAULT NULL, `displayorder` int(5) DEFAULT '0', `enabled` tinyint(1) DEFAULT '0', `startdate` int(11) NOT NULL, `enddate` int(11) NOT NULL, `isnew` tinyint(1) DEFAULT '0', `cuid` int(10) NOT NULL, `ctime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `btype` (`btype`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_banner_statistics` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `pid` int(10) NOT NULL, `rid` int(10) NOT NULL, `bannerid` int(10) NOT NULL, `uid` int(10) NOT NULL, `openid` varchar(50) DEFAULT NULL, `clicktime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `pid` (`pid`), KEY `rid` (`rid`), KEY `bannerid` (`bannerid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_building` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `pid` int(10) NOT NULL, `rid` int(10) NOT NULL, `lid` int(10) NOT NULL, `flid` int(10) NOT NULL, `title` varchar(60) NOT NULL, `units` int(4) NOT NULL, `floors` int(4) NOT NULL, `rooms` int(4) NOT NULL, `isbarn` tinyint(1) NOT NULL, `isunit` tinyint(1) NOT NULL, `unitname` varchar(60) NOT NULL, `aurine_bid` varchar(30) DEFAULT NULL, `bl_bid` varchar(30) DEFAULT NULL, `zzwtec_bid` varchar(60) DEFAULT '0', `building_no` varchar(30) DEFAULT NULL, `zhzj_buildid` varchar(60) DEFAULT NULL, `ymdoor_bid` varchar(60) DEFAULT NULL, `cuid` int(10) NOT NULL, `ctime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `pid` (`pid`), KEY `rid` (`rid`), KEY `building_no` (`building_no`), KEY `zhzj_buildid` (`zhzj_buildid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_rhinfo_zyxq_car` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `pid` int(10) NOT NULL, `rid` int(10) NOT NULL, `uid` int(10) NOT NULL DEFAULT '0', `openid` varchar(50) DEFAULT NULL, `title` varchar(60) NOT NULL, `carno` varchar(20) DEFAULT NULL, `ownername` varchar(30) DEFAULT NULL, `mobile` varchar(20) DEFAULT NULL, `startdate` int(11) DEFAULT NULL, `enddate` int(11) DEFAULT NULL, `remark` varchar(100) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `cuid` int(10) NOT NULL, `ctime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`), KEY `pid` (`pid`), KEY `rid` (`rid`),