<?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
志汇同城9.7.0 (1).zip_同城_志汇
版权申诉
186 浏览量
2022-07-15
08:41:58
上传
评论
收藏 5.52MB ZIP 举报
志汇同城9.7.0 (1).zip_同城_志汇 （1377个子文件） 
developer.cer 50B ygcss.css 4KB ygcsslist.css 4KB
hongbao.gif 20KB red_animation_two.gif 9KB stick.gif 6KB red_animation_one.gif 5KB loading.gif 4KB gif.gif 2KB phone1.gif 2KB
groupgoods.html 32KB fenlei.html 30KB storeinfo.html 25KB storeinfo2.html 24KB yellowtype.html 21KB instoreinfo2.html 19KB dlinstoreinfo2.html 19KB information.html 19KB store.html 19KB integral.html 18KB storetype.html 17KB instoreinfo.html 17KB dlinstoreinfo.html 17KB qggoodall.html 17KB settings.html 16KB goods.html 14KB user2.html 14KB start.html 13KB coupon.html 13KB inindex.html 13KB addinquiry.html 13KB header.html 13KB dlinactivity.html 13KB inactivity.html 13KB activity.html 13KB dlininformation.html 13KB ininformation.html 13KB carinfo.html 12KB yellowstore.html 12KB dlinaddad.html 12KB type.html 12KB dlinstore.html 12KB fxlist.html 12KB instore.html 12KB dlincarinfo.html 12KB incarinfo.html 12KB orderinfo.html 11KB powers.html 11KB zxcheckmanager.html 11KB xsdata.html 11KB header.html 11KB dlinyellowstore.html 11KB inyellowstore.html 11KB ad.html 11KB addactivity.html 10KB storecheck.html 10KB jfgoods.html 10KB dlinaddactivity.html 10KB addad.html 10KB addyellowstore.html 10KB informationinfo.html 10KB index.html 10KB storetypead.html 10KB inquiry.html 10KB ininformationinfo.html 10KB dlininformationinfo.html 10KB inad.html 10KB grouporder.html 10KB inaddactivity.html 10KB nav.html 10KB dlinad.html 10KB dlinzxcheckmanager.html 10KB zxtype.html 10KB tzcheck.html 10KB inzxcheckmanager.html 10KB addnav.html 9KB addzhanghao.html 9KB inaddad.html 9KB yellowstoreinfo.html 9KB dlinaddyellowstore.html 9KB inaddyellowstore.html 9KB videotype.html 9KB inyellowstoreinfo.html 9KB dlinyellowstoreinfo.html 9KB addinformation.html 9KB ddgl.html 9KB grouporderinfo.html 9KB addstoretypead.html 9KB dlinzxpinglun.html 9KB inzxpinglun.html 9KB type2.html 8KB zx.html 8KB dlinvideo.html 8KB invideo.html 8KB video.html 8KB dlinaddinformation.html 8KB inaddinformation.html 8KB countadd.html 8KB xsdatalist.html 8KB groupgoodsInfo.html 8KB共 1377 条
- 1
- 2
- 3
- 4
- 5
- 6
- 14
刘良运
- 粉丝: 66
- 资源: 1万+
最新资源
- 计算机毕业设计-基于JAVA班主任管理系统(源代码+论文)
- [97世界编程大赛4K组]ts代码运行展示.mp4
- 【目标检测数据集】昆虫检测数据集VOC+YOLO格式18900张97类别.zip
- 基于I.MX6的嵌入式平台飞行器监控系统硬件总体设计方案
- 8个维度100次采样的Sobol序列程序
- 计算机毕业设计-文章发布系统的设计与实现（包含论文+源码）
- 计算机毕业设计-ASP.NET信息安全研究所设备管理系统的设计与实现(源代码+)-毕设源码实例.zip
- 8个维度100次采样的拉丁超立方序列采样程序
- 8个维度100次采样的Hammersley序列程序
- 水质检测.rar水质检测.rar水质检测.rar水质检测.rar水质检测.rar
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
评论0