<?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_同城_志汇 （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 dlinstoreinfo2.html 19KB instoreinfo2.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 ininformationinfo.html 10KB inquiry.html 10KB dlininformationinfo.html 10KB inad.html 10KB grouporder.html 10KB inaddactivity.html 10KB nav.html 10KB dlinad.html 10KB dlinzxcheckmanager.html 10KB tzcheck.html 10KB zxtype.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
刘良运
- 粉丝: 77
- 资源: 1万+
最新资源
- 数据库课程设计-仓库管理系统中文最新版本
- 技术资料分享TF卡资料很好的技术资料.zip
- 技术资料分享TF介绍很好的技术资料.zip
- 10、安徽省大学生学科和技能竞赛A、B类项目列表(2019年版).xlsx
- 9、教育主管部门公布学科竞赛(2015版)-方喻飞
- C语言-leetcode题解之83-remove-duplicates-from-sorted-list.c
- C语言-leetcode题解之79-word-search.c
- C语言-leetcode题解之78-subsets.c
- C语言-leetcode题解之75-sort-colors.c
- C语言-leetcode题解之74-search-a-2d-matrix.c
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
评论0