志汇同城9.7.0 (1).zip_同城_志汇

<?php pdo_query("CREATE TABLE IF NOT EXISTS `ims_zhtc_account` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属帐号', `storeid` varchar(1000) NOT NULL, `uid` int(10) unsigned NOT NULL DEFAULT '0', `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 DEFAULT '0' COMMENT '排序', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '状态', `role` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1:店长,2:店员', `lastvisit` int(10) unsigned NOT NULL DEFAULT '0', `lastip` varchar(15) NOT NULL, `areaid` int(10) NOT NULL DEFAULT '0' COMMENT '区域id', `is_admin_order` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_notice_order` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_notice_queue` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_notice_service` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_notice_boss` tinyint(1) NOT NULL DEFAULT '0', `remark` varchar(1000) NOT NULL COMMENT '备注', `lat` decimal(18,10) NOT NULL DEFAULT '0.0000000000' COMMENT '经度', `lng` decimal(18,10) NOT NULL DEFAULT '0.0000000000' COMMENT '纬度', `cityname` varchar(50) NOT NULL COMMENT '城市名称', `money` decimal(10,2) NOT NULL, `authority` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_acthxlist` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `act_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_activity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL COMMENT '活动标题', `logo` varchar(200) NOT NULL COMMENT '活动logo', `img` text NOT NULL COMMENT '活动轮播图', `details` text NOT NULL COMMENT '活动详情', `number` int(11) NOT NULL COMMENT '限制人数', `sign_num` int(11) NOT NULL COMMENT '限制人数', `time` varchar(20) NOT NULL COMMENT '发布时间', `start_time` varchar(20) NOT NULL COMMENT '开始时间', `end_time` varchar(20) NOT NULL COMMENT '结束时间', `uniacid` int(11) NOT NULL COMMENT '小程序id', `money` decimal(10,2) NOT NULL COMMENT '价格', `type_id` int(11) NOT NULL COMMENT '分类id', `tel` varchar(20) NOT NULL COMMENT '电话', `address` varchar(200) NOT NULL COMMENT '地址', `coordinate` varchar(50) NOT NULL COMMENT '坐标', `num` int(11) NOT NULL COMMENT '排序', `view` int(11) NOT NULL COMMENT '访问量', `is_bm` int(11) NOT NULL DEFAULT '1' COMMENT '1.开启2.关闭', `cityname` varchar(20) NOT NULL COMMENT '城市', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_acttype` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `type_name` varchar(20) NOT NULL, `num` int(11) NOT NULL, `uniacid` int(11) NOT NULL, `state` int(11) NOT NULL COMMENT '1.开启2.关闭', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_ad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL COMMENT '轮播图标题', `logo` varchar(200) NOT NULL COMMENT '图片', `status` int(11) NOT NULL COMMENT '1.开启 2.关闭', `src` varchar(100) NOT NULL COMMENT '链接', `orderby` int(11) NOT NULL COMMENT '排序', `xcx_name` varchar(20) NOT NULL, `appid` varchar(20) NOT NULL, `uniacid` int(11) NOT NULL COMMENT '小程序id', `type` int(11) NOT NULL, `cityname` varchar(50) NOT NULL, `wb_src` varchar(300) NOT NULL, `state` int(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_area` ( `id` int(11) NOT NULL AUTO_INCREMENT, `area_name` varchar(50) NOT NULL COMMENT '区域名称', `num` int(11) NOT NULL COMMENT '排序', `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_car` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户id', `start_place` varchar(100) NOT NULL COMMENT '出发地', `end_place` varchar(100) NOT NULL COMMENT '目的地', `start_time` varchar(30) NOT NULL COMMENT '出发时间', `num` int(4) NOT NULL COMMENT '乘车人数/可乘人数', `link_name` varchar(30) NOT NULL COMMENT '联系人', `link_tel` varchar(20) NOT NULL COMMENT '联系电话', `typename` varchar(30) NOT NULL COMMENT '分类名称', `other` varchar(300) NOT NULL COMMENT '补充', `time` int(11) NOT NULL COMMENT '发布时间', `sh_time` int(11) NOT NULL COMMENT '审核时间', `top_id` int(11) NOT NULL COMMENT '置顶ID', `top` int(4) NOT NULL COMMENT '是否置顶,1,是,2否', `uniacid` varchar(50) NOT NULL, `state` int(4) NOT NULL COMMENT '1待审核,2通过，3拒绝', `tj_place` varchar(300) NOT NULL COMMENT '途经地', `hw_wet` varchar(10) NOT NULL COMMENT '货物重量', `star_lat` varchar(20) NOT NULL COMMENT '出发地维度', `star_lng` varchar(20) NOT NULL COMMENT '出发地经度', `end_lat` varchar(20) NOT NULL COMMENT '目的地维度', `end_lng` varchar(20) NOT NULL COMMENT '目的地经度', `is_open` int(4) NOT NULL, `start_time2` int(11) NOT NULL, `cityname` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_car_my_tag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tag_id` int(11) NOT NULL COMMENT '标签id', `car_id` int(11) NOT NULL COMMENT '拼车ID', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_car_tag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `typename` varchar(30) NOT NULL COMMENT '分类名称', `tagname` varchar(30) NOT NULL COMMENT '标签名称', `uniacid` varchar(11) NOT NULL COMMENT '50', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_car_top` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` int(11) NOT NULL COMMENT '1.一天2.一周3.一个月', `money` decimal(10,2) NOT NULL COMMENT '价格', `uniacid` int(11) NOT NULL, `num` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_carpaylog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `car_id` int(44) NOT NULL COMMENT '拼车id', `money` decimal(10,2) NOT NULL COMMENT '钱', `time` datetime NOT NULL, `uniacid` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `information_id` int(11) NOT NULL COMMENT '帖子id', `details` varchar(200) NOT NULL COMMENT '评论详情', `time` varchar(20) NOT NULL COMMENT '时间', `reply` varchar(200) NOT NULL COMMENT '回复详情', `hf_time` varchar(20) NOT NULL COMMENT '回复时间', `user_id` int(11) NOT NULL, `store_id` int(11) NOT NULL, `score` decimal(10,1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_commission_withdrawal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `type` int(11) NOT NULL COMMENT '1.支付宝2.银行卡', `state` int(11) NOT NULL COMMENT '1.审核中2.通过3.拒绝', `time` int(11) NOT NULL COMMENT '申请时间', `sh_time` int(11) NOT NULL COMMENT '审核时间', `uniacid` int(11) NOT NULL, `user_name` varchar(20) NOT NULL, `account` varchar(100) NOT NULL, `tx_cost` decimal(10,2) NOT NULL COMMENT '提现金额', `sj_cost` decimal(10,2) NOT NULL COMMENT '实际到账金额', `bank` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zhtc_continuous` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `day` int(11) NOT NULL COMMENT '天数', `integral` int(11) NOT NULL COMMENT '积分', `uniacid` int(11) NOT NULL, P