志汇酒店营销版小程序zh_jdgjb 6.6.0 安装更新一体包.rar

<?php pdo_query("CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL, `storeid` varchar(1000) NOT NULL, `uid` int(10) unsigned NOT NULL, `from_user` varchar(100) NOT NULL, `accountname` varchar(50) NOT NULL, `password` varchar(200) NOT NULL, `salt` varchar(10) NOT NULL, `pwd` varchar(50) NOT NULL, `mobile` varchar(20) NOT NULL, `email` varchar(20) NOT NULL, `username` varchar(50) NOT NULL, `pay_account` varchar(200) NOT NULL, `displayorder` tinyint(3) unsigned NOT NULL, `dateline` int(10) unsigned NOT NULL, `status` tinyint(1) unsigned NOT NULL, `role` tinyint(1) unsigned NOT NULL, `lastvisit` int(10) unsigned NOT NULL, `lastip` varchar(15) NOT NULL, `areaid` int(10) NOT NULL, `is_admin_order` tinyint(1) unsigned NOT NULL, `is_notice_order` tinyint(1) unsigned NOT NULL, `is_notice_queue` tinyint(1) unsigned NOT NULL, `is_notice_service` tinyint(1) unsigned NOT NULL, `is_notice_boss` tinyint(1) NOT NULL, `remark` varchar(1000) NOT NULL, `lat` decimal(18,10) NOT NULL, `lng` decimal(18,10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_ad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `logo` varchar(200) NOT NULL, `status` int(11) NOT NULL, `src` varchar(100) NOT NULL, `orderby` int(11) NOT NULL, `xcx_name` varchar(20) NOT NULL, `appid` varchar(20) NOT NULL, `uniacid` int(11) NOT NULL, `type` int(11) NOT NULL, `wb_src` varchar(300) NOT NULL, `state` int(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_assess` ( `id` int(11) NOT NULL AUTO_INCREMENT, `seller_id` int(11) NOT NULL, `score` int(11) NOT NULL, `content` text NOT NULL, `img` varchar(1000) NOT NULL, `time` int(11) NOT NULL, `user_id` int(11) NOT NULL, `uniacid` varchar(50) NOT NULL, `reply` varchar(1000) NOT NULL, `status` int(4) NOT NULL, `reply_time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_commission_withdrawal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `state` int(11) NOT NULL, `time` int(11) NOT NULL, `sh_time` int(11) NOT NULL, `uniacid` int(11) NOT NULL, `user_name` varchar(20) NOT NULL, `account` varchar(100) NOT NULL, `tx_cost` decimal(10,2) NOT NULL, `sj_cost` decimal(10,2) NOT NULL, `note` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_coupons` ( `id` int(11) NOT NULL AUTO_INCREMENT, `seller_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `start_time` varchar(20) NOT NULL, `end_time` varchar(20) NOT NULL, `conditions` varchar(100) NOT NULL, `number` int(11) NOT NULL, `cost` decimal(10,2) NOT NULL, `type` int(4) NOT NULL, `introduce` varchar(100) NOT NULL, `lq_num` int(11) NOT NULL, `klqzs` int(11) NOT NULL, `time` int(11) NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_czhd` ( `id` int(11) NOT NULL AUTO_INCREMENT, `full` int(11) NOT NULL, `reduction` int(11) NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_distribution` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `time` int(11) NOT NULL, `user_name` varchar(20) NOT NULL, `user_tel` varchar(20) NOT NULL, `state` int(11) NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_dyj` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dyj_title` varchar(50) NOT NULL, `dyj_id` varchar(50) NOT NULL, `dyj_key` varchar(50) NOT NULL, `uniacid` varchar(50) NOT NULL, `type` int(11) NOT NULL, `name` varchar(20) NOT NULL, `mid` varchar(100) NOT NULL, `api` varchar(100) NOT NULL, `seller_id` int(11) NOT NULL, `state` int(11) NOT NULL, `yy_id` varchar(20) NOT NULL, `token` varchar(50) NOT NULL, `dyj_title2` varchar(50) NOT NULL, `dyj_id2` varchar(50) NOT NULL, `dyj_key2` varchar(50) NOT NULL, `fezh` varchar(40) NOT NULL, `fe_ukey` varchar(50) NOT NULL, `fe_dycode` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_earnings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `son_id` int(11) NOT NULL, `money` decimal(10,2) NOT NULL, `time` int(11) NOT NULL, `note` varchar(50) NOT NULL, `state` int(4) NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_fxset` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fx_details` text NOT NULL, `tx_details` text NOT NULL, `is_fx` int(11) NOT NULL, `is_ej` int(11) NOT NULL, `tx_rate` int(11) NOT NULL, `commission` varchar(10) NOT NULL, `commission2` varchar(10) NOT NULL, `tx_money` int(11) NOT NULL, `img` varchar(100) NOT NULL, `img2` varchar(100) NOT NULL, `uniacid` int(11) NOT NULL, `is_open` int(11) NOT NULL, `instructions` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_fxuser` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `fx_user` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_jfgoods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `img` varchar(100) NOT NULL, `score` int(11) NOT NULL, `type_id` int(11) NOT NULL, `goods_details` text NOT NULL, `process_details` text NOT NULL, `attention_details` text NOT NULL, `number` int(11) NOT NULL, `time` varchar(50) NOT NULL, `is_open` int(11) NOT NULL, `type` int(11) NOT NULL, `num` int(11) NOT NULL, `end_time` int(11) NOT NULL, `uniacid` int(11) NOT NULL, `hb_moeny` decimal(10,2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_jfhb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `goods_id` int(11) NOT NULL, `money` decimal(10,2) NOT NULL, `state` int(4) NOT NULL, `time` int(11) NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_jfrecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `good_id` int(11) NOT NULL, `time` varchar(20) NOT NULL, `user_name` varchar(20) NOT NULL, `user_tel` varchar(20) NOT NULL, `address` varchar(200) NOT NULL, `note` varchar(20) NOT NULL, `integral` int(11) NOT NULL, `good_name` varchar(50) NOT NULL, `good_img` varchar(100) NOT NULL, `state` int(11) NOT NULL, `kd_name` varchar(30) NOT NULL, `kd_num` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_jftype` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `img` varchar(100) NOT NULL, `num` int(11) NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_level` ( `id` int(11) NOT NULL AUTO_INCREMENT, `seller_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `value` decimal(10,2) NOT NULL, `icon` varchar(100) NOT NULL, `discount` varchar(10) NOT NULL, `orderby` int(4) NOT NULL, `uniacid` varchar(50) NOT NULL, `content` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_nav` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `logo` varchar(200) NOT NULL, `status` int(11) NOT NULL, `src` varchar(100) NOT NULL, `orderby` int(11) NOT NULL, `xcx_name` varchar(20) NOT NULL, `appid` varchar(20) NOT NULL, `uniacid` int(11) NOT NULL, `wb_src` varchar(300) NOT NULL, `state` int(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_not