<?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 DEFAULT '',
`accountname` varchar(50) NOT NULL DEFAULT '',
`password` varchar(200) NOT NULL DEFAULT '',
`salt` varchar(10) NOT NULL DEFAULT '',
`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 DEFAULT '' 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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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 '积分',
`
志汇同城微圈小程序V8.9开源商业模块 前端+后台.zip （1139个子文件） 
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
fenlei.html 30KB storeinfo.html 24KB storeinfo2.html 23KB yellowtype.html 21KB instoreinfo2.html 19KB dlinstoreinfo2.html 19KB information.html 19KB store.html 19KB integral.html 18KB storetype.html 17KB dlinstoreinfo.html 17KB instoreinfo.html 17KB settings.html 15KB goods.html 14KB start.html 13KB inindex.html 13KB addinquiry.html 13KB header.html 13KB activity.html 13KB carinfo.html 12KB yellowstore.html 12KB dlininformation.html 12KB dlinaddad.html 12KB inaddad.html 12KB ininformation.html 12KB type.html 12KB dlinstore.html 12KB fxlist.html 12KB instore.html 12KB dlincarinfo.html 12KB incarinfo.html 12KB user2.html 11KB orderinfo.html 11KB zxcheckmanager.html 11KB header.html 11KB dlinyellowstore.html 11KB xsdata.html 11KB inyellowstore.html 11KB ad.html 11KB index.html 11KB addactivity.html 10KB jfgoods.html 10KB addyellowstore.html 10KB addad.html 10KB informationinfo.html 10KB storetypead.html 10KB ininformationinfo.html 10KB dlininformationinfo.html 10KB inquiry.html 10KB inad.html 10KB nav.html 10KB dlinad.html 10KB dlinzxcheckmanager.html 10KB zxtype.html 10KB inzxcheckmanager.html 10KB addnav.html 9KB yellowstoreinfo.html 9KB dlinaddyellowstore.html 9KB inaddyellowstore.html 9KB videotype.html 9KB inyellowstoreinfo.html 9KB dlinyellowstoreinfo.html 9KB ddgl.html 9KB addstoretypead.html 9KB dlinzxpinglun.html 9KB addinformation.html 9KB inzxpinglun.html 9KB type2.html 8KB zx.html 8KB video.html 8KB dlinaddinformation.html 8KB inaddinformation.html 8KB countadd.html 8KB login.html 8KB storecheck.html 8KB zxpinglun.html 8KB xsdatalist.html 8KB hbopen.html 8KB news.html 8KB header-cms.html 7KB inzx.html 7KB tzcheck.html 7KB dlinzx.html 7KB dlingoods.html 7KB innews.html 7KB ingoods.html 7KB dlinnews.html 7KB header-gw.html 7KB fxset.html 7KB intzpinglun.html 7KB dlintzpinglun.html 7KB共 1139 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
