虚拟农场茶叶种植系统+在线商城+带系统交易

-- Adminer 4.6.3 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF EXISTS `hs_account`; CREATE TABLE `hs_account` ( `acid` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) unsigned NOT NULL, `hash` varchar(8) NOT NULL, `type` tinyint(3) unsigned NOT NULL, `isconnect` tinyint(4) NOT NULL, `isdeleted` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`acid`), KEY `idx_uniacid` (`uniacid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `hs_account` (`acid`, `uniacid`, `hash`, `type`, `isconnect`, `isdeleted`) VALUES (1, 1, 'c8R8n9kl', 1, 0, 0); DROP TABLE IF EXISTS `hs_account_wechats`; CREATE TABLE `hs_account_wechats` ( `acid` int(10) unsigned NOT NULL, `uniacid` int(10) unsigned NOT NULL, `token` varchar(32) NOT NULL, `access_token` varchar(1000) NOT NULL, `encodingaeskey` varchar(255) NOT NULL, `level` tinyint(4) unsigned NOT NULL, `name` varchar(30) NOT NULL, `account` varchar(30) NOT NULL, `original` varchar(50) NOT NULL, `signature` varchar(100) NOT NULL, `country` varchar(10) NOT NULL, `province` varchar(3) NOT NULL, `city` varchar(15) NOT NULL, `username` varchar(30) NOT NULL, `password` varchar(32) NOT NULL, `lastupdate` int(10) unsigned NOT NULL, `key` varchar(50) NOT NULL, `secret` varchar(50) NOT NULL, `styleid` int(10) unsigned NOT NULL, `subscribeurl` varchar(120) NOT NULL, `auth_refresh_token` varchar(255) NOT NULL, `jsapi_ticket` text NOT NULL, PRIMARY KEY (`acid`), KEY `idx_key` (`key`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `hs_account_wechats` (`acid`, `uniacid`, `token`, `access_token`, `encodingaeskey`, `level`, `name`, `account`, `original`, `signature`, `country`, `province`, `city`, `username`, `password`, `lastupdate`, `key`, `secret`, `styleid`, `subscribeurl`, `auth_refresh_token`, `jsapi_ticket`) VALUES (1, 1, 'G6M3814KOytm0Utei4szcYiuTmE8YsUJ', '', 'pFt6MNdakiI7vHKVhaK6iXd6i5Fx2T6VIrafidI5r75', 4, '区块茶场', '', '', '', '', '', '', '', '', 0, '', '', 0, '', '', ''); DROP TABLE IF EXISTS `hs_activity`; CREATE TABLE `hs_activity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `weid` int(11) unsigned DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `ac_pic` varchar(100) NOT NULL, `begintime` int(11) unsigned DEFAULT NULL, `endtime` int(11) unsigned DEFAULT NULL, `createtime` int(11) unsigned DEFAULT NULL, `countlimit` int(5) NOT NULL, `countvirtual` int(5) DEFAULT '0', `visitsCount` int(11) DEFAULT '0', `ppt1` varchar(100) DEFAULT NULL, `ppt2` varchar(100) DEFAULT NULL, `ppt3` varchar(100) DEFAULT NULL, `acdes` varchar(500) NOT NULL DEFAULT '', `address` varchar(200) NOT NULL, `location_p` varchar(100) NOT NULL COMMENT '所在地区_省', `location_c` varchar(100) NOT NULL COMMENT '所在地区_市', `location_a` varchar(100) NOT NULL COMMENT '所在地区_区', `lng` decimal(18,10) NOT NULL DEFAULT '0.0000000000', `lat` decimal(18,10) NOT NULL DEFAULT '0.0000000000', `tel` varchar(20) DEFAULT NULL, `email` varchar(20) DEFAULT NULL, `zb` varchar(50) DEFAULT NULL, `cb` varchar(50) DEFAULT NULL, `xb` varchar(50) DEFAULT NULL, `cjdx` varchar(50) DEFAULT NULL, `hoteldesc` varchar(500) DEFAULT NULL, `costdes` varchar(500) DEFAULT NULL, `isrepeat` int(1) DEFAULT '0', `istip` int(1) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `hs_activity_clerks`; CREATE TABLE `hs_activity_clerks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) unsigned NOT NULL, `uid` int(10) unsigned NOT NULL, `storeid` int(10) unsigned NOT NULL, `name` varchar(50) NOT NULL, `password` varchar(200) NOT NULL, `mobile` varchar(20) NOT NULL, `openid` varchar(50) NOT NULL, `nickname` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `hs_activity_clerk_menu`; CREATE TABLE `hs_activity_clerk_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uniacid` int(11) NOT NULL, `displayorder` int(4) NOT NULL, `pid` int(6) NOT NULL, `group_name` varchar(20) NOT NULL, `title` varchar(20) NOT NULL, `icon` varchar(50) NOT NULL, `url` varchar(60) NOT NULL, `type` varchar(20) NOT NULL, `permission` varchar(50) NOT NULL, `system` int(2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `hs_activity_clerk_menu` (`id`, `uniacid`, `displayorder`, `pid`, `group_name`, `title`, `icon`, `url`, `type`, `permission`, `system`) VALUES (1, 0, 0, 0, 'mc', '快捷交易', '', '', '', 'mc_manage', 1), (2, 0, 0, 1, '', '会员积分修改', 'fa fa-money', 'credit1', 'modal', 'mc_credit1', 1), (3, 0, 0, 1, '', '会员余额修改', 'fa fa-cny', 'credit2', 'modal', 'mc_credit2', 1), (4, 0, 0, 1, '', '消费', 'fa fa-usd', 'consume', 'modal', 'mc_consume', 1), (5, 0, 0, 1, '', '发放会员卡', 'fa fa-credit-card', 'card', 'modal', 'mc_card', 1), (6, 0, 0, 0, 'stat', '数据统计', '', '', '', 'stat_manage', 1), (7, 0, 0, 6, '', '会员积分统计', 'fa fa-bar-chart', './index.php?c=stat&a=credit1', 'url', 'stat_credit1', 1), (8, 0, 0, 6, '', '会员余额统计', 'fa fa-bar-chart', './index.php?c=stat&a=credit2', 'url', 'stat_credit2', 1), (9, 0, 0, 6, '', '现金消费统计', 'fa fa-bar-chart', './index.php?c=stat&a=cash', 'url', 'stat_cash', 1), (10, 0, 0, 6, '', '会员卡领卡统计', 'fa fa-bar-chart', './index.php?c=stat&a=card', 'url', 'stat_card', 1), (11, 0, 0, 0, 'activity', '系统优惠券核销', '', '', '', 'activity_card_manage', 1), (12, 0, 0, 11, '', '折扣券核销', 'fa fa-money', './index.php?c=activity&a=consume&do=display&type=1', 'url', 'activity_consume_coupon', 1), (13, 0, 0, 11, '', '代金券核销', 'fa fa-money', './index.php?c=activity&a=consume&do=display&type=2', 'url', 'activity_consume_token', 1), (14, 0, 0, 0, 'wechat', '微信卡券核销', '', '', '', 'wechat_card_manage', 1), (15, 0, 0, 14, '', '卡券核销', 'fa fa-money', './index.php?c=wechat&a=consume', 'url', 'wechat_consume', 1), (16, 0, 0, 6, '', '收银台收款统计', 'fa fa-bar-chart', './index.php?c=stat&a=paycenter', 'url', 'stat_paycenter', 1); DROP TABLE IF EXISTS `hs_activity_coupon`; CREATE TABLE `hs_activity_coupon` ( `couponid` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) unsigned NOT NULL, `type` tinyint(4) NOT NULL, `title` varchar(30) NOT NULL, `couponsn` varchar(50) NOT NULL, `description` text, `discount` decimal(10,2) NOT NULL, `condition` decimal(10,2) NOT NULL, `starttime` int(10) unsigned NOT NULL, `endtime` int(10) unsigned NOT NULL, `limit` int(11) NOT NULL, `dosage` int(11) unsigned NOT NULL, `amount` int(11) unsigned NOT NULL, `thumb` varchar(500) NOT NULL, `credit` int(10) unsigned NOT NULL, `use_module` tinyint(3) unsigned NOT NULL, `credittype` varchar(20) NOT NULL, PRIMARY KEY (`couponid`), KEY `uniacid` (`uniacid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `hs_activity_coupon_allocation`; CREATE TABLE `hs_activity_coupon_allocation` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) unsigned NOT NULL, `couponid` int(10) unsigned NOT NULL, `groupid` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`,`couponid`,`groupid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `hs_activity_coupon_modules`; CREATE TABLE `hs_activity_coupon_modules` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) unsigned NOT NULL, `couponid` int(10) unsigned NOT NULL, `module` varchar(30) NOT NULL, PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`) USING BTREE, KEY `couponid` (`couponid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `hs_activity_coupon_record`; CREATE TABLE `hs_activity_coupon_record` ( `recid` int(10) unsigned NOT NULL AUTO