同城信息商业盈利版 hulu_info 4.7.3全开源版安装更新一体包.zip小程序源码打包下载适合研究学习技术

<?php $sql="CREATE TABLE IF NOT EXISTS `ims_hulu_info_admin` ( `admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `admin_pid` int(10) unsigned NOT NULL DEFAULT '1', `admin_type` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '1为分站管理员/5为总管理员', `openid` varchar(100) NOT NULL, `city_id` int(10) NOT NULL, `admin_username` varchar(100) NOT NULL, `admin_pwd` varchar(100) NOT NULL, `tixian_name` varchar(100) NOT NULL, `tixian_tel` varchar(100) NOT NULL, `tixian_wechat` varchar(100) NOT NULL, `tixian_wechat_qrcode` text NOT NULL, `tixian_alipay` varchar(100) NOT NULL, `tixian_alipay_qrcode` text NOT NULL, `admin_time` varchar(100) NOT NULL, `admin_ip` varchar(100) NOT NULL, `admin_container` varchar(100) NOT NULL, `admin_os` varchar(100) NOT NULL, PRIMARY KEY (`admin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_ads` ( `ads_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `ads_pid` int(10) unsigned NOT NULL DEFAULT '1', `ads_did` int(10) NOT NULL, `ads_type` int(10) unsigned NOT NULL DEFAULT '1', `city_id` int(10) NOT NULL, `ads_pic` text NOT NULL, `ads_title` varchar(100) NOT NULL, `ads_link` text NOT NULL, `ads_time` varchar(100) NOT NULL, `ads_ip` varchar(100) NOT NULL, PRIMARY KEY (`ads_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_buy` ( `buy_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `buy_pid` int(10) unsigned NOT NULL DEFAULT '2', `openid` varchar(100) NOT NULL, `buy_money` decimal(10,4) NOT NULL, `product_id` int(10) NOT NULL, `buy_time` varchar(100) NOT NULL, `buy_ip` varchar(100) NOT NULL, `buy_container` varchar(100) NOT NULL, `buy_os` varchar(100) NOT NULL, PRIMARY KEY (`buy_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_city` ( `city_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `city_pid` int(10) unsigned NOT NULL DEFAULT '1', `city_did` int(10) NOT NULL, `city_name` varchar(100) NOT NULL, `city_province` varchar(100) NOT NULL, `city_city` varchar(100) NOT NULL, `city_type` int(10) NOT NULL, `city_value` int(10) NOT NULL, `city_title` text NOT NULL, `city_kefu_qrcode` text NOT NULL, `city_guanzhu_qrcode` text NOT NULL, `city_time` varchar(100) NOT NULL, `city_ip` varchar(100) NOT NULL, PRIMARY KEY (`city_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_collect` ( `collect_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `openid` varchar(100) NOT NULL, `collect_type` varchar(100) NOT NULL, `collect_vid` int(10) NOT NULL, `collect_time` varchar(100) NOT NULL, `collect_ip` varchar(100) NOT NULL, `collect_container` varchar(100) NOT NULL, `collect_os` varchar(100) NOT NULL, PRIMARY KEY (`collect_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_contact` ( `contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `openid` varchar(100) NOT NULL, `contact_type` varchar(100) NOT NULL, `contact_vid` int(10) NOT NULL, `order_id` varchar(32) NOT NULL, `contact_time` varchar(100) NOT NULL, `contact_ip` varchar(100) NOT NULL, `contact_container` varchar(100) NOT NULL, `contact_os` varchar(100) NOT NULL, PRIMARY KEY (`contact_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_cost` ( `cost_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `cost_pid` int(10) unsigned NOT NULL DEFAULT '2' COMMENT '1为拒绝/2为未审核/3为已通过', `cost_type` int(10) NOT NULL COMMENT '1为收入/2为支出', `openid` varchar(100) NOT NULL, `cost_money` decimal(10,4) NOT NULL, `cost_content` varchar(100) NOT NULL, `cost_time` varchar(100) NOT NULL, `cost_ip` varchar(100) NOT NULL, `cost_container` varchar(100) NOT NULL, `cost_os` varchar(100) NOT NULL, PRIMARY KEY (`cost_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_hangye` ( `hangye_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `hangye_pid` int(10) unsigned NOT NULL DEFAULT '1', `hangye_value` int(10) NOT NULL, `hangye_type` int(10) NOT NULL, `hangye_did` int(10) NOT NULL, `hangye_top_money` decimal(10,4) NOT NULL, `hangye_name` varchar(100) NOT NULL, `hangye_pic` text NOT NULL, `hangye_time` varchar(100) NOT NULL, `hangye_ip` varchar(100) NOT NULL, PRIMARY KEY (`hangye_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_home_view` ( `home_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `openid` varchar(100) NOT NULL, `home_openid` varchar(100) NOT NULL, `home_time` varchar(100) NOT NULL, `home_ip` varchar(100) NOT NULL, `home_container` varchar(100) NOT NULL, `home_os` varchar(100) NOT NULL, PRIMARY KEY (`home_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_index_shortcut_nav` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL, `title` varchar(100) NOT NULL, `name` varchar(100) NOT NULL, `pic` varchar(100) NOT NULL, `color` varchar(20) NOT NULL, `link` varchar(200) NOT NULL, `link_dft` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `weid` (`weid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_info` ( `info_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `info_pid` int(10) unsigned NOT NULL DEFAULT '3', `info_list` int(10) NOT NULL, `city_id` int(10) NOT NULL, `info_addtype` int(10) NOT NULL COMMENT '1为免费/2为付费', `info_type` int(10) unsigned NOT NULL DEFAULT '1', `info_top` int(10) NOT NULL COMMENT '1为不置顶/2为置顶', `openid` varchar(100) NOT NULL, `info_title` varchar(100) NOT NULL, `info_name` varchar(100) NOT NULL, `info_price` varchar(100) NOT NULL, `info_address` text NOT NULL, `info_tel` varchar(100) NOT NULL, `info_validity` varchar(100) NOT NULL, `info_content` text NOT NULL, `info_photos1` text NOT NULL, `info_photos2` text NOT NULL, `info_photos3` text NOT NULL, `info_photos4` text NOT NULL, `info_photos5` text NOT NULL, `info_top_time` varchar(100) NOT NULL, `info_view` int(10) unsigned NOT NULL DEFAULT '0', `info_time` varchar(100) NOT NULL, `info_ip` varchar(100) NOT NULL, `info_container` varchar(100) NOT NULL, `info_os` varchar(100) NOT NULL, PRIMARY KEY (`info_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_info_picture` ( `pic_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `openid` varchar(100) NOT NULL, `info_id` int(10) NOT NULL, `pic_pid` int(10) unsigned NOT NULL DEFAULT '2', `pic_url` text NOT NULL, `pic_time` varchar(100) NOT NULL, `pic_ip` varchar(100) NOT NULL, `pic_container` varchar(100) NOT NULL, `pic_os` varchar(100) NOT NULL, PRIMARY KEY (`pic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_ip` ( `ip_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `openid` varchar(100) NOT NULL, `nickname` varchar(100) NOT NULL, `sex` int(10) NOT NULL, `avatar` text NOT NULL, `info_id` int(10) NOT NULL, `ip_time` varchar(100) NOT NULL, `ip_ip` varchar(100) NOT NULL, `ip_container` varchar(100) NOT NULL, `ip_os` varchar(100) NOT NULL, PRIMARY KEY (`ip_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_hulu_info_jubao` ( `jubao_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uniacid` int(10) NOT NULL, `jubao_type` varchar(100) NOT NULL, `jubao_vid` int(10) NOT NULL, `openid` varchar(100) NOT NULL, `jubao_content` text NOT NULL, `ju