62769同城社区 6.6.69+商家优惠券+分销.zip

<?php $sql="CREATE TABLE IF NOT EXISTS `ims_mihua_sq_account` ( `cash_id` int(11) NOT NULL AUTO_INCREMENT, `uniacid` int(11) DEFAULT NULL, `shop_id` int(11) DEFAULT NULL, `admin_id` int(11) DEFAULT NULL, `openid` varchar(100) NOT NULL, `amount` decimal(10,2) DEFAULT '0.00' COMMENT '提现金额', `transfer` decimal(10,2) DEFAULT '0.00' COMMENT '手续费', `addtime` int(11) DEFAULT NULL, `checktime` int(11) DEFAULT NULL COMMENT '处理申请时间', `check_admin` int(11) DEFAULT NULL COMMENT '处理人', `status` tinyint(1) DEFAULT '0' COMMENT '0未审核1通过2拒绝', `reason` text, `account` varchar(64) DEFAULT NULL, `bank_num` varchar(32) DEFAULT NULL COMMENT '银行账号', `bank_branch` varchar(128) DEFAULT NULL COMMENT '开户银行', `bank_realname` varchar(64) DEFAULT NULL COMMENT '开户姓名', `alipay_account` varchar(128) DEFAULT NULL COMMENT '支付宝账号', `alipay_name` varchar(64) DEFAULT NULL COMMENT '支付宝姓名', `ordersn` varchar(20) DEFAULT NULL, `paytype` tinyint(1) DEFAULT NULL COMMENT '1微信2支付宝3银行卡4余额', `type` tinyint(3) DEFAULT NULL COMMENT '1用户提现 2商户提现', PRIMARY KEY (`cash_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_address` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(11) DEFAULT '0', `openid` varchar(50) NOT NULL, `realname` varchar(20) NOT NULL, `mobile` varchar(11) NOT NULL, `province` varchar(30) NOT NULL, `city` varchar(30) NOT NULL, `area` varchar(30) NOT NULL, `address` varchar(300) NOT NULL, `isdefault` tinyint(3) unsigned NOT NULL DEFAULT '0', `inco` varchar(300) DEFAULT NULL COMMENT '标签', `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0', `lat` varchar(255) DEFAULT '', `lng` varchar(255) DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_admin` ( `admin_id` int(11) NOT NULL AUTO_INCREMENT, `uniacid` int(11) DEFAULT NULL, `admin_name` varchar(100) DEFAULT NULL, `nickname` varchar(100) DEFAULT NULL, `passport` varchar(50) DEFAULT NULL, `password` varchar(200) DEFAULT NULL, `avatar` varchar(200) DEFAULT NULL, `openid` varchar(100) NOT NULL, `addtime` int(11) DEFAULT '0', `status` tinyint(1) DEFAULT '0' COMMENT '0开启 1暂停', `msg_flag` tinyint(1) DEFAULT '0' COMMENT '0=>发送通知,1=>不发送通知', `mobile` char(15) DEFAULT NULL, `admin_uid` int(11) DEFAULT NULL, `type` varchar(200) DEFAULT NULL, `salt` char(20) DEFAULT NULL, PRIMARY KEY (`admin_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_adv` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uniacid` int(11) DEFAULT '0', `advname` varchar(50) DEFAULT '', `link` varchar(255) NOT NULL DEFAULT '', `thumb` varchar(255) DEFAULT '', `displayorder` int(11) DEFAULT '0', `enabled` int(11) DEFAULT '0', `type` text COMMENT '1首页，2首页中部，3首页底部，4拼团，5秒杀，6首单，7买单，8同城', `add_time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `indx_uniacid` (`uniacid`), KEY `indx_enabled` (`enabled`), KEY `indx_displayorder` (`displayorder`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_area` ( `area_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(11) DEFAULT NULL, `city_id` smallint(5) DEFAULT '0', `parent_id` int(11) DEFAULT NULL, `area_name` varchar(32) DEFAULT NULL, `orderby` tinyint(3) DEFAULT '100', `is_hot` tinyint(1) DEFAULT '0', PRIMARY KEY (`area_id`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_balance` ( `balance_id` int(11) NOT NULL AUTO_INCREMENT, `uniacid` int(10) unsigned NOT NULL, `money` float(10,2) DEFAULT '0.00', `uid` int(11) DEFAULT '0', `addtime` int(11) DEFAULT '0', `status` tinyint(1) DEFAULT '0' COMMENT '0=>未支付,1=>支付完成', `openid` varchar(100) DEFAULT NULL, PRIMARY KEY (`balance_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1042 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_black` ( `black_id` int(11) NOT NULL AUTO_INCREMENT, `uniacid` int(10) unsigned NOT NULL, `uid` varchar(50) DEFAULT NULL, `createtime` int(11) NOT NULL, PRIMARY KEY (`black_id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_card` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(11) unsigned DEFAULT '0', `shop_id` int(11) unsigned DEFAULT '0', `cardtype` tinyint(3) unsigned DEFAULT '0', `cardname` varchar(100) DEFAULT NULL, `needcredit` int(11) unsigned DEFAULT '0', `cardvalue` decimal(10,2) unsigned DEFAULT '0.00', `fullmoney` decimal(10,2) unsigned DEFAULT '0.00', `totalnum` int(11) unsigned DEFAULT '0', `takednum` int(11) unsigned DEFAULT '0', `lastnum` int(11) unsigned DEFAULT '0', `usednum` int(11) unsigned DEFAULT '0', `limitnum` int(11) unsigned DEFAULT '0', `expire` int(11) unsigned DEFAULT '0', `starttime` int(11) unsigned DEFAULT '0', `endtime` int(11) unsigned DEFAULT '0', `status` tinyint(3) unsigned DEFAULT '0', `time` int(11) unsigned DEFAULT '0', `isrecommand` tinyint(3) unsigned DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_cart` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) unsigned NOT NULL, `goodsid` int(11) NOT NULL, `goodstype` tinyint(1) NOT NULL DEFAULT '1', `from_user` varchar(50) NOT NULL, `total` int(10) unsigned NOT NULL, `optionid` int(10) DEFAULT '0', `marketprice` decimal(10,2) DEFAULT '0.00', `shop_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_openid` (`from_user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_cash` ( `cash_id` int(11) NOT NULL AUTO_INCREMENT, `cash_ordersn` varchar(20) NOT NULL, `cash_type` tinyint(1) DEFAULT '1' COMMENT '操作类别(1抢红包，2打赏圈子，3打赏信息)', `create_time` int(11) NOT NULL COMMENT '该记录创建时间', `openid` varchar(50) NOT NULL DEFAULT '用户openid', `from_openid` varchar(50) NOT NULL DEFAULT '从哪个用户的opneid得到钱', `uniacid` int(11) DEFAULT NULL, `type_id` int(11) DEFAULT NULL COMMENT '对应关联的id', `amount` decimal(10,2) NOT NULL COMMENT '金额', `status` tinyint(1) DEFAULT '1' COMMENT '状态(0.付款中，1:成功)', PRIMARY KEY (`cash_id`), UNIQUE KEY `id` (`cash_id`) ) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_mihua_sq_channel` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(11) NOT NULL, `name` varchar(30) NOT NULL, `thumb` varchar(100) NOT NULL, `sharetitle` varchar(50) NOT NULL, `sharethumb` varchar(100) NOT NULL, `sharedes` varchar(100) NOT NULL, `displayorder` int(11) NOT NULL, `canrelease` tinyint(1) NOT NULL DEFAULT '1', `isshenhe` tinyint(1) NOT NULL DEFAULT '1', `iscang` tinyint(1) NOT NULL, `minscore` smallint(6) NOT NULL, `isneedpay` tinyint(1) NOT NULL, `needpay` decimal(10,2) NOT NULL, `templateid` smallint(6) NOT NULL, `detailtemplateid` smallint(6) NOT NULL, `module` tinyint(4) NOT NULL, `autourl` varchar(200) NOT NULL, `listhtml` longtext NOT NULL, `detailhtml` longtext NOT NULL, `defult_list` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1使用默认列表页 2自定义', `defult_detail` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1使用默认详情页 2自定义', `ison` tinyint(1) NOT NULL DEFAULT '1', `zdprice` decimal(10,2) NOT NULL DEFAULT '0.00', `haibaobg` varchar(100) NOT NULL, `template` varchar(20) NOT NULL, `template2` varchar(20) NOT NULL, `template3` varchar(20) NOT NULL, `fid` smallint(6) NOT NULL, `bgparam` varchar(10240) NOT NULL, `show_location` tinyint(1) DEFAULT '1