123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004 |
- <?php
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_system')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `appid` varchar(100) NOT NULL COMMENT 'appid',
- `appsecret` varchar(200) NOT NULL COMMENT 'appsecret',
- `mchid` varchar(20) NOT NULL COMMENT '商户号',
- `wxkey` varchar(100) NOT NULL COMMENT '商户秘钥',
- `uniacid` varchar(50) NOT NULL,
- `url_name` varchar(20) NOT NULL COMMENT '网址名称',
- `details` text NOT NULL COMMENT '关于我们',
- `url_logo` varchar(500) NOT NULL COMMENT '网址logo',
- `bq_name` varchar(50) NOT NULL COMMENT '版权名称',
- `link_name` varchar(30) NOT NULL COMMENT '网站名称',
- `link_logo` varchar(500) NOT NULL COMMENT '网站logo',
- `support` varchar(20) NOT NULL COMMENT '技术支持',
- `bq_logo` varchar(500) NOT NULL,
- `color` varchar(20) NOT NULL,
- `tz_appid` varchar(30) NOT NULL,
- `tz_name` varchar(30) NOT NULL,
- `pt_name` varchar(30) NOT NULL COMMENT '平台名称',
- `tz_audit` int(11) NOT NULL COMMENT '帖子审核1.是 2否',
- `sj_audit` int(11) NOT NULL COMMENT '商家审核1.是 2否'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_type')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type_name` varchar(20) NOT NULL COMMENT '分类名称',
- `img` varchar(500) NOT NULL COMMENT '分类图片',
- `uniacid` int(11) NOT NULL COMMENT '小程序id',
- `num` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_type2')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL COMMENT '分类名称',
- `type_id` int(11) NOT NULL COMMENT '主分类id',
- `num` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_user')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `openid` varchar(100) NOT NULL COMMENT 'openid',
- `img` varchar(500) NOT NULL COMMENT '头像',
- `time` varchar(20) NOT NULL COMMENT '注册时间',
- `name` varchar(20) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_ad')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `title` varchar(50) NOT NULL COMMENT '轮播图标题',
- `logo` varchar(500) 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'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_area')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `area_name` varchar(50) NOT NULL COMMENT '区域名称',
- `num` int(11) NOT NULL COMMENT '排序',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_comments')."(
- `id` int(11) NOT NULL PRIMARY KEY 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
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_information')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `details` text NOT NULL COMMENT '内容',
- `img` text NOT NULL COMMENT '图片',
- `user_id` int(11) NOT NULL COMMENT '用户id',
- `user_name` varchar(20) NOT NULL COMMENT '联系人',
- `user_tel` varchar(20) NOT NULL COMMENT '电话',
- `hot` int(11) NOT NULL COMMENT '1.热门 2.不热门',
- `top` int(11) NOT NULL COMMENT '1.置顶 2.不置顶',
- `givelike` int(11) NOT NULL COMMENT '点赞数',
- `views` int(11) NOT NULL COMMENT '浏览量',
- `uniacid` int(11) NOT NULL COMMENT '小程序id',
- `type2_id` int(11) NOT NULL COMMENT '分类二id',
- `type_id` int(11) NOT NULL,
- `state` int(11) NOT NULL COMMENT '1.待审核 2.通过3拒绝',
- `money` decimal(10,2) NOT NULL,
- `time` int(11) NOT NULL COMMENT '发布时间'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_like')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `information_id` int(11) NOT NULL COMMENT '帖子id',
- `user_id` int(11) NOT NULL COMMENT '用户id'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_store')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL COMMENT '用户id',
- `store_name` varchar(50) NOT NULL COMMENT '商家名称',
- `address` varchar(200) NOT NULL COMMENT '商家地址',
- `announcement` varchar(100) NOT NULL COMMENT '公告',
- `storetype_id` int(11) NOT NULL COMMENT '主行业分类id',
- `storetype2_id` int(11) NOT NULL COMMENT '商家子分类id',
- `area_id` int(11) NOT NULL COMMENT '区域id',
- `yy_time` varchar(50) NOT NULL COMMENT '营业时间',
- `keyword` varchar(50) NOT NULL COMMENT '关键字',
- `skzf` int(11) NOT NULL COMMENT '1.是 2否(刷卡支付)',
- `wifi` int(11) NOT NULL COMMENT '1.是 2否',
- `mftc` int(11) NOT NULL COMMENT '1.是 2否(免费停车)',
- `jzxy` int(11) NOT NULL COMMENT '1.是 2否(禁止吸烟)',
- `tgbj` int(11) NOT NULL COMMENT '1.是 2否(提供包间)',
- `sfxx` int(11) NOT NULL COMMENT '1.是 2否(沙发休闲)',
- `tel` varchar(20) NOT NULL COMMENT '手机号',
- `logo` varchar(500) NOT NULL,
- `weixin_logo` varchar(500) NOT NULL,
- `ad` text NOT NULL COMMENT '轮播图',
- `state` int(11) NOT NULL COMMENT '1.待审核2通过3拒绝',
- `money` decimal(10,2) NOT NULL COMMENT '金额',
- `password` varchar(100) NOT NULL COMMENT '核销密码',
- `details` text NOT NULL COMMENT '商家简介',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_share')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `information_id` int(11) NOT NULL COMMENT '帖子id',
- `user_id` int(11) NOT NULL COMMENT '用户id'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_storetype')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type_name` varchar(20) NOT NULL COMMENT '分类名称',
- `img` varchar(500) NOT NULL COMMENT '分类图片',
- `uniacid` int(11) NOT NULL,
- `num` int(11) NOT NULL COMMENT '排序',
- `money` decimal(10,2) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_storetype2')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `type_id` int(11) NOT NULL COMMENT '主分类id',
- `num` int(11) NOT NULL COMMENT '排序',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_news')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `title` varchar(50) NOT NULL COMMENT '公告标题',
- `details` text NOT NULL COMMENT '公告详情',
- `num` int(11) NOT NULL COMMENT '排序',
- `uniacid` int(11) NOT NULL,
- `time` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_top')."(
- `id` int(11) NOT NULL PRIMARY KEY 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
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_label')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `label_name` varchar(20) NOT NULL,
- `type2_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_mylabel')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `label_id` int(11) NOT NULL,
- `information_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_in')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type` int(11) NOT NULL COMMENT '1.一天2.半年3.一年',
- `money` DECIMAL(10,2) NOT NULL,
- `num` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_help')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `question` varchar(200) NOT NULL COMMENT '标题',
- `answer` text NOT NULL COMMENT '回答',
- `sort` int(4) NOT NULL COMMENT '排序',
- `uniacid` varchar(50) NOT NULL,
- `created_time` datetime NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_sms')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `appkey` varchar(100) NOT NULL,
- `tpl_id` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fx')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL COMMENT '用户ID',
- `zf_user_id` int(11) NOT NULL COMMENT '转发人ID',
- `money` decimal(10,2) NOT NULL COMMENT '金额',
- `time` int(11) NOT NULL COMMENT '时间戳',
- `uniacid` varchar(50) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_hblq')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL COMMENT '用户ID',
- `tz_id` int(11) NOT NULL COMMENT '帖子ID',
- `money` decimal(10,2) NOT NULL COMMENT '金额',
- `time` int(11) NOT NULL COMMENT '时间戳',
- `uniacid` varchar(50) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_withdrawal')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(10) NOT NULL COMMENT '真实姓名',
- `username` varchar(100) NOT NULL COMMENT '账号',
- `type` int(11) NOT NULL COMMENT '1支付宝 2.微信 3.银行',
- `time` int(11) NOT NULL COMMENT '申请时间',
- `sh_time` int(11) NOT NULL COMMENT '审核时间',
- `state` int(11) NOT NULL COMMENT '1.待审核 2.通过 3.拒绝',
- `tx_cost` decimal(10,2) NOT NULL COMMENT '提现金额',
- `sj_cost` decimal(10,2) NOT NULL COMMENT '实际金额',
- `user_id` int(11) NOT NULL COMMENT '用户id',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_zx')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type_id` int(11) NOT NULL COMMENT '分类ID',
- `user_id` int(11) NOT NULL COMMENT '发布人ID',
- `title` varchar(200) NOT NULL COMMENT '标题',
- `content` text NOT NULL COMMENT '内容',
- `time` datetime NOT NULL COMMENT '时间',
- `yd_num` int(11) NOT NULL COMMENT '阅读数量',
- `pl_num` int(11) NOT NULL COMMENT '评论数量',
- `uniacid` varchar(50) NOT NULL,
- `imgs` text NOT NULL COMMENT '图片'
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_zx_type')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type_name` varchar(100) NOT NULL COMMENT '分类名称',
- `icon` varchar(100) NOT NULL COMMENT '图标',
- `sort` int(4) NOT NULL COMMENT '排序',
- `time` datetime NOT NULL COMMENT '时间',
- `uniacid` varchar(50) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_zx_assess')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `zx_id` int(4) NOT NULL,
- `score` int(11) NOT NULL,
- `content` text NOT NULL,
- `img` varchar(500) NOT NULL,
- `cerated_time` datetime NOT NULL,
- `user_id` int(11) NOT NULL,
- `uniacid` varchar(50) NOT NULL,
- `status` int(4) NOT NULL,
- `reply` text NOT NULL,
- `reply_time` datetime NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_zx_zj')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `zx_id` int(11) NOT NULL COMMENT '资讯ID',
- `user_id` int(11) NOT NULL COMMENT '用户ID',
- `uniacid` varchar(50) NOT NULL,
- `time` int(11) NOT NULL COMMENT '时间'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='资讯足迹';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_car')."(
- `id` int(11) NOT NULL PRIMARY KEY 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 '目的地经度'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='拼车';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_car_my_tag')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `tag_id` int(11) NOT NULL COMMENT '标签id',
- `car_id` int(11) NOT NULL COMMENT '拼车ID'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_car_tag')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `typename` varchar(30) NOT NULL COMMENT '分类名称',
- `tagname` varchar(30) NOT NULL COMMENT '标签名称',
- `uniacid` varchar(11) NOT NULL COMMENT '50'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_car_top')."(
- `id` int(11) NOT NULL PRIMARY KEY 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
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='拼车置顶';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_goods')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `store_id` int(11) NOT NULL COMMENT '商家ID',
- `spec_id` int(11) NOT NULL COMMENT '主规格ID',
- `goods_name` varchar(100) NOT NULL COMMENT '商品名称',
- `goods_num` int(11) NOT NULL COMMENT '商品数量',
- `goods_cost` decimal(10,2) NOT NULL COMMENT '商品价格',
- `freight` decimal(10,2) NOT NULL COMMENT '运费',
- `delivery` varchar(500) NOT NULL COMMENT '关于发货',
- `quality` int(4) NOT NULL COMMENT '正品1是,0否',
- `free` int(4) NOT NULL COMMENT '包邮1是,0否',
- `all_day` int(4) NOT NULL COMMENT '24小时发货1是,0否',
- `service` int(4) NOT NULL COMMENT '售后服务1是,0否',
- `refund` int(4) NOT NULL COMMENT '极速退款1是,0否',
- `weeks` int(4) NOT NULL COMMENT '7天包邮1是,0否',
- `lb_imgs` varchar(500) NOT NULL COMMENT '轮播图',
- `imgs` varchar(500) NOT NULL COMMENT '商品介绍图',
- `time` int(11) NOT NULL COMMENT '时间',
- `uniacid` varchar(50) NOT NULL,
- `goods_details` text NOT NULL COMMENT '商品详细',
- `state` int(4) NOT NULL COMMENT '1待审核,2通过,3拒绝',
- `sy_num` int(11) NOT NULL COMMENT '剩余数量'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='商品表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_goods_spec')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `spec_name` varchar(100) NOT NULL COMMENT '规格名称',
- `sort` int(4) NOT NULL COMMENT '排序',
- `uniacid` varchar(50) NOT NULL COMMENT '50'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='商品规格表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_spec_value')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `goods_id` int(11) NOT NULL COMMENT '商品ID',
- `spec_id` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL COMMENT '价格',
- `name` varchar(50) NOT NULL COMMENT '名称',
- `num` int(11) NOT NULL COMMENT '数量'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_order')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `store_id` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL COMMENT '金额',
- `user_name` varchar(20) NOT NULL COMMENT '联系人',
- `address` varchar(200) NOT NULL COMMENT '联系地址',
- `tel` varchar(20) NOT NULL COMMENT '电话',
- `time` int(11) NOT NULL COMMENT '下单时间',
- `pay_time` int(11) NOT NULL,
- `complete_time` int(11) NOT NULL,
- `fh_time` int(11) NOT NULL COMMENT '发货时间',
- `state` int(11) NOT NULL COMMENT '1.待付款 2.待发货3.待确认4.已完成5.退款中6.已退款7.退款拒绝',
- `order_num` varchar(20) NOT NULL COMMENT '订单号',
- `good_id` int(11) NOT NULL,
- `good_name` varchar(100) NOT NULL,
- `good_img` varchar(500) NOT NULL,
- `good_money` decimal(10,2) NOT NULL,
- `out_trade_no` varchar(50) NOT NULL,
- `good_spec` varchar(200) NOT NULL COMMENT '商品规格',
- `del` int(11) NOT NULL COMMENT '用户删除1是 2否 ',
- `del2` int(11) NOT NULL COMMENT '商家删除1.是2.否',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_store_wallet')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `store_id` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL,
- `note` varchar(20) NOT NULL,
- `type` int(11) NOT NULL COMMENT '1加2减'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商家钱包明细';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_commission_withdrawal')."(
- `id` int(11) NOT NULL PRIMARY KEY 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 '实际到账金额'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='佣金提现';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_distribution')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `time` int(11) NOT NULL,
- `user_name` varchar(20) NOT NULL,
- `user_tel` varchar(20) NOT NULL,
- `state` int(11) NOT NULL COMMENT '1.审核中2.通过3.拒绝',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销申请';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_earnings')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `son_id` int(11) NOT NULL COMMENT '下线',
- `money` decimal(10,2) NOT NULL,
- `time` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='佣金收益表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fxset')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `fx_details` text NOT NULL COMMENT '分销商申请协议',
- `tx_details` text NOT NULL COMMENT '佣金提现协议',
- `is_fx` int(11) NOT NULL COMMENT '1.开启分销审核2.不开启',
- `is_ej` int(11) NOT NULL COMMENT '是否开启二级分销1.是2.否',
- `tx_rate` int(11) NOT NULL COMMENT '提现手续费',
- `commission` varchar(10) NOT NULL COMMENT '一级佣金',
- `commission2` varchar(10) NOT NULL COMMENT '二级佣金',
- `tx_money` int(11) NOT NULL COMMENT '提现门槛',
- `img` varchar(500) NOT NULL COMMENT '分销中心图片',
- `img2` varchar(500) NOT NULL COMMENT '申请分销图片',
- `uniacid` int(11) NOT NULL,
- `is_open` int(11) NOT NULL DEFAULT '1' COMMENT '1.开启2关闭',
- `instructions` text NOT NULL COMMENT '分销商说明'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fxuser')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL COMMENT '一级分销',
- `fx_user` int(11) NOT NULL COMMENT '二级分销',
- `time` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowset')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `days` int(11) NOT NULL COMMENT '入住天数',
- `money` decimal(10,2) NOT NULL,
- `num` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='黄页设置表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowstore')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `logo` varchar(500) NOT NULL COMMENT 'logo图片',
- `company_name` varchar(100) NOT NULL COMMENT '公司名称',
- `company_address` varchar(200) NOT NULL COMMENT '公司地址',
- `type_id` int(11) NOT NULL COMMENT '二级分类',
- `link_tel` varchar(20) NOT NULL COMMENT '联系电话',
- `sort` int(11) NOT NULL COMMENT '排序',
- `rz_time` int(11) NOT NULL COMMENT '入住时间',
- `sh_time` int(11) NOT NULL COMMENT '审核时间',
- `state` int(4) NOT NULL COMMENT '1待,2通过,3拒绝',
- `rz_type` int(4) NOT NULL COMMENT '入驻类型',
- `time_over` int(4) NOT NULL COMMENT '1到期,2没到期',
- `uniacid` varchar(50) NOT NULL,
- `coordinates` varchar(50) NOT NULL COMMENT '坐标',
- `content` text NOT NULL COMMENT '简介',
- `imgs` varchar(500) NOT NULL COMMENT '多图'
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_hotcity')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `cityname` varchar(50) NOT NULL COMMENT '城市名称',
- `time` int(11) NOT NULL COMMENT '创建时间',
- `uniacid` varchar(50) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_paylog')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `fid` int(11) NOT NULL COMMENT '外键id(商家,帖子,黄页,拼车)',
- `money` decimal(10,2) NOT NULL COMMENT '钱',
- `time` datetime NOT NULL COMMENT '时间',
- `uniacid` varchar(50) NOT NULL COMMENT '50'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付记录表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_account')."(
- `id` int(10) unsigned NOT NULL PRIMARY KEY 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 '城市名称'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_carpaylog')."(
- `id` int(11) NOT NULL PRIMARY KEY 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
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='拼车支付记录表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_storepaylog')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `store_id` int(11) NOT NULL COMMENT '商家ID',
- `money` decimal(10,2) NOT NULL,
- `time` datetime NOT NULL,
- `uniacid` varchar(50) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商家入驻支付记录表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_tzpaylog')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `tz_id` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL,
- `time` datetime NOT NULL,
- `uniacid` varchar(50) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='帖子支付记录表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowpaylog')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `hy_id` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL,
- `time` datetime NOT NULL,
- `uniacid` varchar(50) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='黄页支付记录表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yjset')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type` int(4) NOT NULL DEFAULT '1' COMMENT '1统一模式,2分开模式',
- `typer` varchar(10) NOT NULL COMMENT '统一比例',
- `sjper` varchar(10) NOT NULL COMMENT '商家比例',
- `hyper` varchar(10) NOT NULL COMMENT '黄页比例',
- `pcper` varchar(10) NOT NULL COMMENT '拼车比例',
- `tzper` varchar(10) NOT NULL COMMENT '帖子比例',
- `uniacid` varchar(50) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='佣金比例表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yjtx')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `account_id` int(11) NOT NULL COMMENT '账号id',
- `tx_type` int(4) NOT NULL COMMENT '提现方式 1,支付宝,2微信,3银联',
- `tx_cost` decimal(10,2) NOT NULL COMMENT '提现金额',
- `status` int(4) NOT NULL COMMENT '状态 1申请,2通过,3拒绝',
- `uniacid` varchar(50) NOT NULL,
- `cerated_time` datetime NOT NULL COMMENT '日期',
- `sj_cost` decimal(10,2) NOT NULL COMMENT '实际金额',
- `account` varchar(30) NOT NULL COMMENT '账户',
- `name` varchar(30) NOT NULL COMMENT '姓名',
- `sx_cost` decimal(10,2) NOT NULL COMMENT '手续费',
- `time` datetime NOT NULL COMMENT '审核时间',
- `is_del` int(4) NOT NULL DEFAULT '1' COMMENT '1正常,2删除'
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_userformid')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL COMMENT '用户id',
- `form_id` varchar(50) NOT NULL COMMENT 'form_id',
- `time` datetime NOT NULL,
- `uniacid` varchar(50) NOT NULL,
- `openid` varchar(50) NOT NULL COMMENT 'openid'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='formid表';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_nav')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `title` varchar(50) NOT NULL COMMENT '名称',
- `logo` varchar(500) 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 COMMENT '小程序名称',
- `appid` varchar(20) NOT NULL COMMENT 'APPID',
- `uniacid` int(11) NOT NULL COMMENT '小程序id',
- `wb_src` varchar(300) NOT NULL COMMENT '外部链接',
- `state` int(4) NOT NULL DEFAULT '1' COMMENT '1内部,2外部,3跳转'
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_video')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type_id` int(11) NOT NULL COMMENT '分类ID',
- `title` varchar(200) NOT NULL COMMENT '标题',
- `time` datetime NOT NULL,
- `yd_num` int(11) NOT NULL COMMENT '阅读数量',
- `pl_num` int(11) NOT NULL COMMENT '评论数量',
- `dz_num` int(11) NOT NULL COMMENT '点赞数量',
- `uniacid` varchar(50) NOT NULL,
- `url` varchar(500) NOT NULL COMMENT '视频链接',
- `logo` varchar(500) NOT NULL COMMENT '发布人logo',
- `nick_name` varchar(30) NOT NULL COMMENT '昵称',
- `cityname` varchar(50) NOT NULL COMMENT '城市名称',
- `num` int(11) NOT NULL COMMENT '排序',
- `fm_logo` varchar(500) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_videotype')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type_name` varchar(20) NOT NULL COMMENT '分类名称',
- `img` varchar(500) NOT NULL COMMENT '分类图片',
- `uniacid` int(11) NOT NULL COMMENT '小程序id',
- `num` int(11) NOT NULL,
- `state` int(4) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_videopl')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `content` varchar(500) NOT NULL,
- `video_id` int(11) NOT NULL,
- `time` varchar(20) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_videodz')."(
- `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `video_id` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_integral')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL COMMENT '用户id',
- `score` int(11) NOT NULL COMMENT '分数',
- `type` int(4) NOT NULL COMMENT '1加,2减',
- `order_id` int(11) NOT NULL COMMENT '订单id',
- `cerated_time` datetime NOT NULL COMMENT '创建时间',
- `uniacid` varchar(50) NOT NULL,
- `note` varchar(20) NOT NULL COMMENT '备注'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_jfgoods')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(50) NOT NULL COMMENT '名称',
- `img` varchar(500) NOT NULL,
- `money` int(11) NOT NULL COMMENT '价格',
- `type_id` int(11) NOT NULL COMMENT '分类id',
- `goods_details` text NOT NULL,
- `process_details` text NOT NULL,
- `attention_details` text NOT NULL,
- `number` int(11) NOT NULL COMMENT '数量',
- `time` varchar(50) NOT NULL COMMENT '期限',
- `is_open` int(11) NOT NULL COMMENT '1.开启2关闭',
- `type` int(11) NOT NULL COMMENT '1.余额2.实物',
- `num` int(11) NOT NULL COMMENT '排序',
- `uniacid` int(11) NOT NULL,
- `hb_moeny` decimal(10,2) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_jfrecord')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL COMMENT '用户id',
- `good_id` int(11) NOT NULL COMMENT '商品id',
- `time` varchar(20) NOT NULL COMMENT '兑换时间',
- `user_name` varchar(20) NOT NULL COMMENT '用户地址',
- `user_tel` varchar(20) NOT NULL COMMENT '用户电话',
- `address` varchar(200) NOT NULL COMMENT '地址',
- `note` varchar(20) NOT NULL,
- `integral` int(11) NOT NULL COMMENT '积分',
- `good_name` varchar(50) NOT NULL COMMENT '商品名称',
- `state` INT NULL DEFAULT '1',
- `good_img` varchar(500) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_jftype')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `img` varchar(500) NOT NULL,
- `num` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_signlist')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `time` varchar(20) NOT NULL COMMENT '签到时间',
- `time2` int(11) NOT NULL,
- `integral` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_signset')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `one` int(11) NOT NULL COMMENT '首次奖励积分',
- `integral` int(11) NOT NULL COMMENT '每天签到积分',
- `is_open` int(11) NOT NULL COMMENT '1.开启2.关闭 签到',
- `is_bq` int(11) NOT NULL COMMENT '1.开启2.关闭 补签',
- `bq_integral` int(11) NOT NULL COMMENT '补签扣除积分',
- `details` text NOT NULL COMMENT '签到说明',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_special')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `day` varchar(20) NOT NULL COMMENT '日期',
- `integral` int(11) NOT NULL COMMENT '积分',
- `title` varchar(20) NOT NULL COMMENT '标题说明',
- `color` varchar(20) NOT NULL COMMENT '颜色',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_continuous')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `day` int(11) NOT NULL COMMENT '天数',
- `integral` int(11) NOT NULL COMMENT '积分',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_qbmx')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `money` decimal(10,2) NOT NULL,
- `type` int(11) NOT NULL,
- `note` varchar(20) NOT NULL,
- `time` varchar(20) NOT NULL,
- `user_id` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fxlevel')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `money` decimal(10,2) NOT NULL,
- `name` varchar(20) NOT NULL,
- `num` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL,
- `commission` int(11) NOT NULL COMMENT '1级佣金比例',
- `commission2` int(11) NOT NULL COMMENT '2级佣金比例'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowtype')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type_name` varchar(20) NOT NULL COMMENT '分类名称',
- `img` varchar(500) NOT NULL COMMENT '分类图片',
- `uniacid` int(11) NOT NULL COMMENT '小程序id',
- `num` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL,
- `state` int(4) NOT NULL DEFAULT '1' COMMENT '1启用,2禁用'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowtype2')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL COMMENT '分类名称',
- `type_id` int(11) NOT NULL COMMENT '主分类id',
- `num` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL,
- `state` int(4) NOT NULL DEFAULT '1' COMMENT '1启用,2禁用'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_storetypead')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `title` varchar(50) NOT NULL COMMENT '轮播图标题',
- `logo` varchar(500) 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,
- `type_id` int(11) NOT NULL,
- `type_id2` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL COMMENT '小程序id',
- `cityname` varchar(50) NOT NULL COMMENT '城市名称',
- `wb_src` varchar(300) NOT NULL COMMENT '外部链接',
- `state` int(4) NOT NULL DEFAULT '1' COMMENT '1内部,2外部,3跳转'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_joinlist')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `act_id` int(11) NOT NULL,
- `time` varchar(20) NOT NULL,
- `money` decimal(10,2) NOT NULL,
- `code` varchar(100) NOT NULL,
- `form_id` varchar(100) NOT NULL,
- `state` int(11) NOT NULL COMMENT '1.待支付2.已支付3.已通过4.已核销5.已拒绝',
- `uniacid` int(11) NOT NULL,
- `user_name` varchar(20) NOT NULL,
- `user_tel` varchar(20) NOT NULL,
- `hx_time` varchar(20) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_acttype')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY 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.关闭'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_activity')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `title` varchar(50) NOT NULL COMMENT '活动标题',
- `logo` varchar(500) 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 '城市'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_acthxlist')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `act_id` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_dmorder')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL,
- `store_id` int(11) NOT NULL,
- `code` varchar(100) NOT NULL,
- `state` int(11) NOT NULL,
- `time` varchar(20) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_coupons')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `number` int(11) NOT NULL,
- `full` varchar(20) NOT NULL COMMENT '满',
- `reduce` decimal(10,1) NOT NULL COMMENT '减',
- `money` decimal(10,2) NOT NULL,
- `time` varchar(20) NOT NULL,
- `details` text NOT NULL COMMENT '使用说明',
- `surplus` int(11) NOT NULL COMMENT '剩余数量',
- `store_id` int(11) NOT NULL,
- `end_time` varchar(20) NOT NULL,
- `img` text NOT NULL,
- `is_show` int(11) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_usercoupons')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `coupons_id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `state` int(11) NOT NULL DEFAULT '2' COMMENT '1.使用2.未使用',
- `time` varchar(20) NOT NULL,
- `pay_type` int(11) NOT NULL,
- `code` varchar(100) NOT NULL,
- `lq_money` decimal(10,2) NOT NULL,
- `del` int(11) NOT NULL DEFAULT '2'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fxlog')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL,
- `time` varchar(20) NOT NULL,
- `code` varchar(100) NOT NULL,
- `level` int(11) NOT NULL,
- `note` varchar(20) NOT NULL,
- `uniacid` int(11) NOT NULL,
- `state` int(11) NOT NULL DEFAULT '1' COMMENT '1.待支付2.已支付'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_llz')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `type` int(11) NOT NULL,
- `status` int(11) NOT NULL,
- `src` varchar(100) NOT NULL,
- `cityname` varchar(20) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_sensitive')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `content` text NOT NULL COMMENT '内容',
- `uniacid` int(11) NOT NULL COMMENT '11'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_message')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `note` varchar(100) NOT NULL,
- `source` varchar(100) NOT NULL,
- `content` varchar(100) NOT NULL,
- `time` varchar(100) NOT NULL,
- `fs_time` varchar(20) NOT NULL,
- `uniacid` int(11) NOT NULL,
- `src` varchar(100) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_qgtype')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `num` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_qgorder')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `order_num` varchar(50) NOT NULL,
- `user_id` int(11) NOT NULL,
- `user_name` varchar(20) NOT NULL,
- `user_tel` varchar(20) NOT NULL,
- `store_id` int(11) NOT NULL,
- `money` decimal(10,2) NOT NULL,
- `good_id` int(11) NOT NULL,
- `pay_type` int(11) NOT NULL COMMENT '1.微信支付2.余额支付',
- `state` int(11) NOT NULL COMMENT '1.待支付2已支付3.已核销',
- `dq_time` varchar(20) NOT NULL COMMENT '到期时间',
- `uniacid` int(11) NOT NULL,
- `code` varchar(100) NOT NULL,
- `good_name` varchar(20) NOT NULL,
- `good_logo` varchar(500) NOT NULL,
- `pay_time` varchar(20) NOT NULL,
- `hx_time` varchar(20) NOT NULL,
- `del` int(11) NOT NULL DEFAULT '2' COMMENT '1删除2.未删除',
- `note` varchar(50) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_qggoods')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `logo` varchar(500) NOT NULL,
- `price` decimal(10,1) NOT NULL COMMENT '原价',
- `money` decimal(10,1) NOT NULL COMMENT '现价',
- `number` int(11) NOT NULL COMMENT '数量',
- `surplus` int(11) NOT NULL COMMENT '剩余',
- `start_time` varchar(20) NOT NULL COMMENT '开始时间',
- `end_time` varchar(20) NOT NULL COMMENT '结束时间',
- `consumption_time` int(11) NOT NULL COMMENT '消费截止时间',
- `details` text NOT NULL,
- `store_id` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL,
- `state` int(11) NOT NULL DEFAULT '1' COMMENT '1.上架2.下架',
- `state2` int(11) NOT NULL DEFAULT '1',
- `is_tg` int(11) NOT NULL DEFAULT '1',
- `type_id` int(11) NOT NULL,
- `img` text NOT NULL,
- `num` int(11) NOT NULL,
- `hot` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_group')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `store_id` int(11) NOT NULL COMMENT '门店id',
- `goods_id` int(11) NOT NULL COMMENT '商品ID',
- `goods_logo` varchar(500) NOT NULL,
- `goods_name` varchar(255) NOT NULL COMMENT '商品名称',
- `kt_num` int(11) NOT NULL COMMENT '开团人数',
- `yg_num` int(11) NOT NULL COMMENT '已购数量',
- `kt_time` int(11) NOT NULL COMMENT '开团时间',
- `dq_time` int(11) NOT NULL COMMENT '到期时间',
- `state` int(4) NOT NULL COMMENT '1.拼团中2成功,3失败',
- `user_id` int(11) NOT NULL COMMENT '团长user_id',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_groupgoods')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `store_id` int(11) NOT NULL COMMENT '门店id',
- `type_id` int(11) NOT NULL COMMENT '分类ID',
- `name` varchar(255) NOT NULL COMMENT '名称',
- `logo` varchar(500) NOT NULL COMMENT 'logo',
- `img` text NOT NULL COMMENT '多图',
- `inventory` int(11) NOT NULL COMMENT '库存',
- `pt_price` decimal(10,2) NOT NULL COMMENT '拼团价格',
- `y_price` decimal(10,2) NOT NULL COMMENT '原价',
- `dd_price` decimal(10,2) NOT NULL COMMENT '单独购买价格',
- `ycd_num` int(11) NOT NULL COMMENT '已成团数量',
- `ysc_num` int(11) NOT NULL COMMENT '已售出数量',
- `people` int(11) NOT NULL COMMENT '成团人数',
- `start_time` int(11) NOT NULL COMMENT '开始时间',
- `end_time` int(11) NOT NULL COMMENT '结束时间',
- `xf_time` int(11) NOT NULL COMMENT '消费截止时间',
- `is_shelves` int(4) NOT NULL DEFAULT '1' COMMENT '1上架,2下架',
- `details` text NOT NULL COMMENT '商品详情',
- `details_img` text NOT NULL COMMENT '详情多图',
- `num` int(11) NOT NULL COMMENT '排序',
- `state` int(4) NOT NULL DEFAULT '1' COMMENT '1待审核,2通过,3拒绝',
- `display` int(4) NOT NULL DEFAULT '1' COMMENT '1显示,2不显示',
- `uniacid` int(11) NOT NULL,
- `introduction` text NOT NULL,
- `time` int(11) NOT NULL COMMENT '发布时间'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_grouporder')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `group_id` int(11) NOT NULL COMMENT '团id',
- `store_id` int(11) NOT NULL COMMENT '门店id',
- `goods_id` int(11) NOT NULL COMMENT '商品ID',
- `user_id` int(11) NOT NULL COMMENT '用户ID',
- `order_num` varchar(30) NOT NULL COMMENT '订单号',
- `logo` varchar(500) NOT NULL COMMENT '商品图片',
- `goods_name` varchar(255) NOT NULL COMMENT '商品名称',
- `goods_type` varchar(50) NOT NULL COMMENT '商品类型',
- `price` decimal(10,2) NOT NULL COMMENT '单价',
- `goods_num` int(11) NOT NULL COMMENT '商品数量',
- `money` decimal(10,2) NOT NULL COMMENT '订单金额',
- `pay_type` int(4) NOT NULL COMMENT '付款方式1微信,2余额',
- `receive_name` varchar(30) NOT NULL COMMENT '收货人',
- `receive_tel` varchar(20) NOT NULL COMMENT '收货人电话',
- `receive_address` varchar(100) NOT NULL COMMENT '收货人地址',
- `note` varchar(100) NOT NULL COMMENT '备注',
- `state` int(4) NOT NULL COMMENT '1未付款,2已付款,3已完成,4已关闭,5已失效',
- `xf_time` int(11) NOT NULL COMMENT '消费截止时间',
- `time` int(11) NOT NULL COMMENT '下单时间',
- `pay_time` int(11) NOT NULL COMMENT '付款时间',
- `cz_time` int(11) NOT NULL COMMENT '完成/关闭/失效时间',
- `code` varchar(30) NOT NULL COMMENT '支付商户号',
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_grouptype')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `img` varchar(500) NOT NULL,
- `num` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='拼团分类';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_coupontype')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type_name` varchar(20) NOT NULL COMMENT '分类名称',
- `img` varchar(500) NOT NULL COMMENT '分类图片',
- `uniacid` int(11) NOT NULL COMMENT '小程序id',
- `num` int(11) NOT NULL,
- `state` int(4) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_plate')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `type` int(4) NOT NULL,
- `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
- `time` int(11) NOT NULL,
- `uniacid` int(11) NOT NULL,
- `sort` int(11) NOT NULL COMMENT '排序'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='首页板块导航';"
- );
- pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_bottom')."(
- `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
- `title` varchar(20) NOT NULL COMMENT '标题',
- `title_color` varchar(20) NOT NULL COMMENT '标题选中颜色',
- `title_color2` varchar(20) NOT NULL COMMENT '标题未选中颜色',
- `logo` varchar(200) NOT NULL COMMENT '选中图片',
- `logo2` varchar(200) NOT NULL COMMENT '未选中图片',
- `url` varchar(200) NOT NULL COMMENT '跳转链接',
- `num` int(11) NOT NULL COMMENT '排序',
- `state` int(11) NOT NULL DEFAULT '1' COMMENT '1开启2关闭',
- `uniacid` int(11) NOT NULL,
- `xcx_name` varchar(50) NOT NULL COMMENT '小程序名称',
- `appid` varchar(30) NOT NULL COMMENT '跳转appid',
- `item` int(4) NOT NULL DEFAULT '1',
- `src2` varchar(255) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
- );
- if (!pdo_fieldexists(tablename('zhtc_ad'), 'type')) {
- pdo_query("ALTER TABLE".tablename('zhtc_ad')." ADD `type` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'coordinates')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `coordinates` VARCHAR(50) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'views')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `views` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'sh_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `sh_time` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'top_type')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `top_type` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_news'), 'img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_news')." ADD `img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_news'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_news')." ADD `state` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'mapkey')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `mapkey` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tel')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tel` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'gd_key')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gd_key` VARCHAR(100) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_news'), 'type')) {
- pdo_query("ALTER TABLE".tablename('zhtc_news')." ADD `type` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_comments'), 'store_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_comments')." ADD `store_id` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_share'), 'store_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_share')." ADD `store_id` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'score')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `score` DECIMAL(10,1) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_comments'), 'score')) {
- pdo_query("ALTER TABLE".tablename('zhtc_comments')." ADD `score` DECIMAL(10,1) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'type')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `type` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'sh_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `sh_time` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'time_over')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `time_over` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'address')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `address` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `img` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'rz_xuz')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `rz_xuz` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'ft_xuz')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `ft_xuz` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'vr_link')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `vr_link` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'fx_money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `fx_money` DECIMAL(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_user'), 'money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `money` DECIMAL(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_money` DECIMAL(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_num` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_type')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_type` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_keyword')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_keyword` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_random')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_random` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'hb_sxf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hb_sxf` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'hong')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hong` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'store_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `store_id` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_money` DECIMAL(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_sxf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_sxf` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_details')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_details` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'del')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `del` INT NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'is_open')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `is_open` INT NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `num` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'start_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `start_time` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'end_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `end_time` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_like'), 'zx_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_like')." ADD `zx_id` INT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hhr')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hhr` INT(4) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hbfl')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hbfl` INT(4) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_zx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_zx` INT(4) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_zx'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `state` INT(4) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_zx'), 'sh_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `sh_time` DATETIME NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_car')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_car` INT(4) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'pc_xuz')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `pc_xuz` TEXT NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'pc_money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `pc_money` DECIMAL(10,2) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_car'), 'is_open')) {
- pdo_query("ALTER TABLE".tablename('zhtc_car')." ADD `is_open` INT(4) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_car'), 'start_time2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_car')." ADD `start_time2` INT NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'user_img2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `user_img2` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_sjrz')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_sjrz` INT(4) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pcfw')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pcfw` INT(4) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'total_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `total_num` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_goods')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_goods` INT(4) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_user'), 'user_name')) {
- pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `user_name` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_user'), 'user_tel')) {
- pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `user_tel` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_user'), 'user_address')) {
- pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `user_address` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'wallet')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `wallet` DECIMAL(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_order'), 'freight')) {
- pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `freight` DECIMAL(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_order'), 'note')) {
- pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `note` VARCHAR(100) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'apiclient_cert')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `apiclient_cert` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'apiclient_key')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `apiclient_key` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_type'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_type')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_storetype'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_storetype')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_openzx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_openzx` INT(4) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_storetype2'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_storetype2')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_type2'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_type2')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_order'), 'good_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `good_num` INT NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_goods'), 'is_show')) {
- pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `is_show` INT NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_goods'), 'sales')) {
- pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `sales` INT NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_zx'), 'type')) {
- pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `type` INT(4) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store_wallet'), 'time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store_wallet')." ADD `time` VARCHAR(20) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_withdrawal'), 'method')) {
- pdo_query("ALTER TABLE".tablename('zhtc_withdrawal')." ADD `method` INT NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_withdrawal'), 'store_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_withdrawal')." ADD `store_id` INT NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_user'), 'commission')) {
- pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `commission` DECIMAL(10,2) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'user_name')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `user_name` VARCHAR(30) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'pwd')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `pwd` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hyset')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hyset` INT(4) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'dq_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `dq_time` INT(11) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'dq_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `dq_time` INT(11) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'views')) {
- pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `views` INT NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_tzopen')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_tzopen` INT(4) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pageopen')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pageopen` INT(4) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'tel2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `tel2` VARCHAR(20) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `cityname` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `cityname` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_tel')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_tel` INT(4) NOT NULL DEFAULT '1' ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `cityname` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `cityname` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'tid1')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tid1` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'tid2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tid2` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'tid3')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tid3` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_car'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_car')." ADD `cityname` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `time` DATETIME NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_zx'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `cityname` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_ad'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_ad')." ADD `cityname` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_news'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_news')." ADD `cityname` VARCHAR(50) NOT NULL ;");
- }
- if (!pdo_fieldexists(tablename('zhtc_user'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_paylog'), 'note')) {
- pdo_query("ALTER TABLE".tablename('zhtc_paylog')." ADD `note` VARCHAR(100) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'fx_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `fx_num` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_mode')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_mode` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'many_city')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `many_city` INT(4) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'ewm_logo')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `ewm_logo` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_hotcity'), 'user_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_hotcity')." ADD `user_id` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_ad'), 'wb_src')) {
- pdo_query("ALTER TABLE".tablename('zhtc_ad')." ADD `wb_src` VARCHAR(300) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_ad'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_ad')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_type')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_type` INT(4) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hbzf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hbzf` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'hb_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hb_img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tz_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tz_num` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'client_ip')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `client_ip` VARCHAR(30) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'dq_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `dq_time` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'hbfx_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hbfx_num` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'is_top')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `is_top` INT(4) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'hb_content')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hb_content` VARCHAR(100) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_tzhb')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_tzhb` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_store_wallet'), 'tx_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store_wallet')." ADD `tx_id` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'sj_max')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sj_max` VARCHAR(1) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'zfwl_max')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `zfwl_max` VARCHAR(1) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'zfwl_open')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `zfwl_open` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'zx_type')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `zx_type` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_type'), 'sx_money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_type')." ADD `sx_money` decimal(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'ft_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `ft_num` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'ft_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `ft_num` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'yyzz_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `yyzz_img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'sfz_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `sfz_img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_img` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_sjhb')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_sjhb` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_tzdz')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_tzdz` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_rz')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_rz` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_user'), 'total_score')) {
- pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `total_score` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_user'), 'day')) {
- pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `day` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_signlist'), 'time3')) {
- pdo_query("ALTER TABLE".tablename('zhtc_signlist')." ADD `time3` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'integral')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `integral` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'integral2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `integral2` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_jf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_jf` INT(11) NOT NULL DEFAULT '1';");
- }
- // pdo_query("ALTER TABLE".tablename('zhtc_system')." CHANGE `is_tel` `is_tel` INT(4) NOT NULL DEFAULT '1';");
- if (!pdo_fieldexists(tablename('zhtc_account'), 'money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_account')." ADD `money` DECIMAL(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_distribution'), 'money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `money` DECIMAL(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_distribution'), 'pay_state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `pay_state` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_distribution'), 'code')) {
- pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `code` VARCHAR(50) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_distribution'), 'level')) {
- pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `level` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_distribution'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `cityname` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'tpl2_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tpl2_id` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_kf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_kf` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'dw_more')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `dw_more` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_zxrz')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_zxrz` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_storepaylog'), 'note')) {
- pdo_query("ALTER TABLE".tablename('zhtc_storepaylog')." ADD `note` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_tzpaylog'), 'note')) {
- pdo_query("ALTER TABLE".tablename('zhtc_tzpaylog')." ADD `note` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_order'), 'is_zt')) {
- pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `is_zt` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_order'), 'zt_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `zt_time` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tzmc')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tzmc` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tzmc')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tzmc` VARCHAR(20) NOT NULL DEFAULT '帖子';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_dnss')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_dnss` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_vr')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_vr` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_yysj')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_yysj` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'type2_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `type2_id` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tc_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tc_img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'tc_gg')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tc_gg` VARCHAR(100) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'hbbj_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hbbj_img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_signset'), 'qd_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_signset')." ADD `qd_img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_commission_withdrawal'), 'bank')) {
- pdo_query("ALTER TABLE".tablename('zhtc_commission_withdrawal')." ADD `bank` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_withdrawal'), 'bank')) {
- pdo_query("ALTER TABLE".tablename('zhtc_withdrawal')." ADD `bank` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_img` text NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_details')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_details` text NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_tel')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_tel` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_time` VARCHAR(50) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_add')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_add` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_zb')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_zb` VARCHAR(50) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'model')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `model` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_bm')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_bm` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_order'), 'kd_num')) {
- pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `kd_num` VARCHAR(100) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_order'), 'kd_name')) {
- pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `kd_name` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'zf_title')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `zf_title` VARCHAR(50) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'sh_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sh_time` int NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_qgb')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_qgb` int NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_type'), 'money2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_type')." ADD `money2` decimal(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_top'), 'money2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_top')." ADD `money2` decimal(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_qgb2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_qgb2` int NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_in'), 'money2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_in')." ADD `money2` decimal(10,2) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_coupon')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_coupon` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_sy')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_sy` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'coupon_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `coupon_img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_coupons'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `state` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_goods'), 'is_xs')) {
- pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `is_xs` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_goods'), 'end_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `end_time` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_usercoupons'), 'hx_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_usercoupons')." ADD `hx_time` VARCHAR(20) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_coupons'), 'del')) {
- pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `del` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'kp_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `kp_img` VARCHAR(500) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'kp_time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `kp_time` INT(11) NOT NULL DEFAULT '3';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hd')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hd` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'is_rm')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `is_rm` INT(11) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'sj_max2')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sj_max2` INT(11) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pcqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pcqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hyqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hyqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_yhqqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_yhqqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_syqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_syqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hdqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hdqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hbqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hbqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hhrqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hhrqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_dcsqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_dcsqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_jfqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_jfqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_distribution'), 'is_log')) {
- pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `is_log` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_spqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_spqx` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_sp')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_sp` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'sygg_name')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sygg_name` VARCHAR(20) NOT NULL DEFAULT '同城头条';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'sjgg_name')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sjgg_name` VARCHAR(20) NOT NULL DEFAULT '信息头条';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'flgg_name')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `flgg_name` VARCHAR(20) NOT NULL DEFAULT '商家快报';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_zf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_zf` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_yhqsh')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_yhqsh` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'hb_name')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hb_name` VARCHAR(20) NOT NULL DEFAULT '红包';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'fl_name')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `fl_name` VARCHAR(20) NOT NULL DEFAULT '福利';");
- }
- if (!pdo_fieldexists(tablename('zhtc_account'), 'authority')) {
- pdo_query("ALTER TABLE".tablename('zhtc_account')." ADD `authority` TEXT NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'fh_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `fh_tid` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'gm_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `gm_tid` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'hp_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `hp_tid` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'dz_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `dz_tid` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'tg_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tg_tid` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pzsj')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pzsj` INT(11) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'qf_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `qf_tid` VARCHAR(200) NOT NULL;");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'ggoods_set')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `ggoods_set` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_xsqg')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_xsqg` INT(4) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'xgsh')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `xgsh` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_qggoods'), 'content')) {
- pdo_query("ALTER TABLE".tablename('zhtc_qggoods')." ADD `content` VARCHAR(100) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_qggoods'), 'details_img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_qggoods')." ADD `details_img` TEXT NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_qgtype'), 'state')) {
- pdo_query("ALTER TABLE".tablename('zhtc_qgtype')." ADD `state` INT(4) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_qgqx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_qgqx` INT(4) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_comments'), 'bid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_comments')." ADD `bid` INT(11) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_comments'), 'hf_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_comments')." ADD `hf_id` INT(11) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_qgtype'), 'img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_qgtype')." ADD `img` VARCHAR(500) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'g_open')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `g_open` INT(4) NOT NULL DEFAULT '2';");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'g_qx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `g_qx` INT(4) NOT NULL DEFAULT '1';");
- }
- if (!pdo_fieldexists(tablename('zhtc_qggoods'), 'time')) {
- pdo_query("ALTER TABLE".tablename('zhtc_qggoods')." ADD `time` VARCHAR(20) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_account'), 'city_qx')) {
- pdo_query("ALTER TABLE".tablename('zhtc_account')." ADD `city_qx` text NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'fx_jf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `fx_jf` int NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_integral'), 'tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_integral')." ADD `tid` int NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'good_jf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `good_jf` int NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_zx'), 'video')) {
- pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `video` VARCHAR(300) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_acttype'), 'img')) {
- pdo_query("ALTER TABLE".tablename('zhtc_acttype')." ADD `img` VARCHAR(500) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_coupons'), 'type_id')) {
- pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `type_id` INT(11) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_coupons'), 'is_pt')) {
- pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `is_pt` INT(11) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'video')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `video` VARCHAR(300) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_qggoods'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_qggoods')." ADD `cityname` VARCHAR(20) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_groupgoods'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_groupgoods')." ADD `cityname` VARCHAR(30) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_coupons'), 'cityname')) {
- pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `cityname` VARCHAR(30) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'qg_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `qg_tid` VARCHAR(200) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'hd_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `hd_tid` VARCHAR(200) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'pt_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `pt_tid` VARCHAR(200) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'kq_tid')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `kq_tid` VARCHAR(200) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_goods'), 'vr')) {
- pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `vr` VARCHAR(500) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_city')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_city` INT(11) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'hy_title')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hy_title` VARCHAR(20) NOT NULL DEFAULT '黄页114'");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'kp_url')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `kp_url` VARCHAR(300) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'is_jt')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `is_jt` INT(4) NOT NULL DEFAULT '2'");
- }
- if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'is_delete')) {
- pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `is_delete` INT(4) NOT NULL DEFAULT '2'");
- }
- if (!pdo_fieldexists(tablename('zhtc_car'), 'is_delete')) {
- pdo_query("ALTER TABLE".tablename('zhtc_car')." ADD `is_delete` INT(4) NOT NULL DEFAULT '2'");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_message')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_message` INT(4) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_type'), 'tel_money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_type')." ADD `tel_money` DECIMAL(10,2) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_type2'), 'tel_money')) {
- pdo_query("ALTER TABLE".tablename('zhtc_type2')." ADD `tel_money` DECIMAL(10,2) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_bdtel')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_bdtel` INT(4) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_ff')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_ff` INT(4) NOT NULL DEFAULT '2'");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pgzf')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pgzf` INT(4) NOT NULL DEFAULT '2'");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'is_video')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_video` INT(4) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'lat')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `lat` VARCHAR(20) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'lng')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `lng` VARCHAR(20) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'fj_tz')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `fj_tz` INT(4) NOT NULL DEFAULT '2'");
- }
- if (!pdo_fieldexists(tablename('zhtc_system'), 'cz_password')) {
- pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `cz_password` VARCHAR(20) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_information'), 'code')) {
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `code` VARCHAR( 50 ) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'aliyun_appkey')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `aliyun_appkey` VARCHAR( 20 ) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'aliyun_appsecret')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `aliyun_appsecret` VARCHAR( 50 ) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'aliyun_sign')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `aliyun_sign` VARCHAR( 20 ) NOT NULL");
- }
- if (!pdo_fieldexists(tablename('zhtc_sms'), 'item')) {
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `item` INT(4) NOT NULL DEFAULT '1'");
- }
- if (!pdo_fieldexists(tablename('zhtc_store'), 'is_shop')) {
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `is_shop` INT(1) NOT NULL DEFAULT '1'");
- }
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `uniacid` );");
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `user_id` );");
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `type2_id` );");
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `type_id` );");
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `state` );");
- pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `store_id` );");
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `uniacid` );");
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `user_id` );");
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `storetype2_id` );");
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `storetype_id` );");
- pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `state` );");
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." CHANGE `tpl_id` `tpl_id` VARCHAR(20) NOT NULL;");
- pdo_query("ALTER TABLE".tablename('zhtc_sms')." CHANGE `tpl2_id` `tpl2_id` VARCHAR(20) NOT NULL;");
- ?>
|