insert2.php 93 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004
  1. <?php
  2. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_system')."(
  3. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  4. `appid` varchar(100) NOT NULL COMMENT 'appid',
  5. `appsecret` varchar(200) NOT NULL COMMENT 'appsecret',
  6. `mchid` varchar(20) NOT NULL COMMENT '商户号',
  7. `wxkey` varchar(100) NOT NULL COMMENT '商户秘钥',
  8. `uniacid` varchar(50) NOT NULL,
  9. `url_name` varchar(20) NOT NULL COMMENT '网址名称',
  10. `details` text NOT NULL COMMENT '关于我们',
  11. `url_logo` varchar(500) NOT NULL COMMENT '网址logo',
  12. `bq_name` varchar(50) NOT NULL COMMENT '版权名称',
  13. `link_name` varchar(30) NOT NULL COMMENT '网站名称',
  14. `link_logo` varchar(500) NOT NULL COMMENT '网站logo',
  15. `support` varchar(20) NOT NULL COMMENT '技术支持',
  16. `bq_logo` varchar(500) NOT NULL,
  17. `color` varchar(20) NOT NULL,
  18. `tz_appid` varchar(30) NOT NULL,
  19. `tz_name` varchar(30) NOT NULL,
  20. `pt_name` varchar(30) NOT NULL COMMENT '平台名称',
  21. `tz_audit` int(11) NOT NULL COMMENT '帖子审核1.是 2否',
  22. `sj_audit` int(11) NOT NULL COMMENT '商家审核1.是 2否'
  23. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  24. );
  25. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_type')."(
  26. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  27. `type_name` varchar(20) NOT NULL COMMENT '分类名称',
  28. `img` varchar(500) NOT NULL COMMENT '分类图片',
  29. `uniacid` int(11) NOT NULL COMMENT '小程序id',
  30. `num` int(11) NOT NULL,
  31. `money` decimal(10,2) NOT NULL
  32. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  33. );
  34. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_type2')."(
  35. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  36. `name` varchar(20) NOT NULL COMMENT '分类名称',
  37. `type_id` int(11) NOT NULL COMMENT '主分类id',
  38. `num` int(11) NOT NULL,
  39. `uniacid` int(11) NOT NULL
  40. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  41. );
  42. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_user')."(
  43. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  44. `openid` varchar(100) NOT NULL COMMENT 'openid',
  45. `img` varchar(500) NOT NULL COMMENT '头像',
  46. `time` varchar(20) NOT NULL COMMENT '注册时间',
  47. `name` varchar(20) NOT NULL,
  48. `uniacid` int(11) NOT NULL
  49. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  50. );
  51. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_ad')."(
  52. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  53. `title` varchar(50) NOT NULL COMMENT '轮播图标题',
  54. `logo` varchar(500) NOT NULL COMMENT '图片',
  55. `status` int(11) NOT NULL COMMENT '1.开启 2.关闭',
  56. `src` varchar(100) NOT NULL COMMENT '链接',
  57. `orderby` int(11) NOT NULL COMMENT '排序',
  58. `xcx_name` varchar(20) NOT NULL,
  59. `appid` varchar(20) NOT NULL,
  60. `uniacid` int(11) NOT NULL COMMENT '小程序id'
  61. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  62. );
  63. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_area')."(
  64. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  65. `area_name` varchar(50) NOT NULL COMMENT '区域名称',
  66. `num` int(11) NOT NULL COMMENT '排序',
  67. `uniacid` int(11) NOT NULL
  68. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  69. );
  70. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_comments')."(
  71. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  72. `information_id` int(11) NOT NULL COMMENT '帖子id',
  73. `details` varchar(200) NOT NULL COMMENT '评论详情',
  74. `time` varchar(20) NOT NULL COMMENT '时间',
  75. `reply` varchar(200) NOT NULL COMMENT '回复详情',
  76. `hf_time` varchar(20) NOT NULL COMMENT '回复时间',
  77. `user_id` int(11) NOT NULL
  78. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  79. );
  80. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_information')."(
  81. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  82. `details` text NOT NULL COMMENT '内容',
  83. `img` text NOT NULL COMMENT '图片',
  84. `user_id` int(11) NOT NULL COMMENT '用户id',
  85. `user_name` varchar(20) NOT NULL COMMENT '联系人',
  86. `user_tel` varchar(20) NOT NULL COMMENT '电话',
  87. `hot` int(11) NOT NULL COMMENT '1.热门 2.不热门',
  88. `top` int(11) NOT NULL COMMENT '1.置顶 2.不置顶',
  89. `givelike` int(11) NOT NULL COMMENT '点赞数',
  90. `views` int(11) NOT NULL COMMENT '浏览量',
  91. `uniacid` int(11) NOT NULL COMMENT '小程序id',
  92. `type2_id` int(11) NOT NULL COMMENT '分类二id',
  93. `type_id` int(11) NOT NULL,
  94. `state` int(11) NOT NULL COMMENT '1.待审核 2.通过3拒绝',
  95. `money` decimal(10,2) NOT NULL,
  96. `time` int(11) NOT NULL COMMENT '发布时间'
  97. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  98. );
  99. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_like')."(
  100. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  101. `information_id` int(11) NOT NULL COMMENT '帖子id',
  102. `user_id` int(11) NOT NULL COMMENT '用户id'
  103. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  104. );
  105. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_store')."(
  106. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  107. `user_id` int(11) NOT NULL COMMENT '用户id',
  108. `store_name` varchar(50) NOT NULL COMMENT '商家名称',
  109. `address` varchar(200) NOT NULL COMMENT '商家地址',
  110. `announcement` varchar(100) NOT NULL COMMENT '公告',
  111. `storetype_id` int(11) NOT NULL COMMENT '主行业分类id',
  112. `storetype2_id` int(11) NOT NULL COMMENT '商家子分类id',
  113. `area_id` int(11) NOT NULL COMMENT '区域id',
  114. `yy_time` varchar(50) NOT NULL COMMENT '营业时间',
  115. `keyword` varchar(50) NOT NULL COMMENT '关键字',
  116. `skzf` int(11) NOT NULL COMMENT '1.是 2否(刷卡支付)',
  117. `wifi` int(11) NOT NULL COMMENT '1.是 2否',
  118. `mftc` int(11) NOT NULL COMMENT '1.是 2否(免费停车)',
  119. `jzxy` int(11) NOT NULL COMMENT '1.是 2否(禁止吸烟)',
  120. `tgbj` int(11) NOT NULL COMMENT '1.是 2否(提供包间)',
  121. `sfxx` int(11) NOT NULL COMMENT '1.是 2否(沙发休闲)',
  122. `tel` varchar(20) NOT NULL COMMENT '手机号',
  123. `logo` varchar(500) NOT NULL,
  124. `weixin_logo` varchar(500) NOT NULL,
  125. `ad` text NOT NULL COMMENT '轮播图',
  126. `state` int(11) NOT NULL COMMENT '1.待审核2通过3拒绝',
  127. `money` decimal(10,2) NOT NULL COMMENT '金额',
  128. `password` varchar(100) NOT NULL COMMENT '核销密码',
  129. `details` text NOT NULL COMMENT '商家简介',
  130. `uniacid` int(11) NOT NULL
  131. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  132. );
  133. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_share')."(
  134. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  135. `information_id` int(11) NOT NULL COMMENT '帖子id',
  136. `user_id` int(11) NOT NULL COMMENT '用户id'
  137. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  138. );
  139. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_storetype')."(
  140. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  141. `type_name` varchar(20) NOT NULL COMMENT '分类名称',
  142. `img` varchar(500) NOT NULL COMMENT '分类图片',
  143. `uniacid` int(11) NOT NULL,
  144. `num` int(11) NOT NULL COMMENT '排序',
  145. `money` decimal(10,2) NOT NULL
  146. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  147. );
  148. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_storetype2')."(
  149. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  150. `name` varchar(20) NOT NULL,
  151. `type_id` int(11) NOT NULL COMMENT '主分类id',
  152. `num` int(11) NOT NULL COMMENT '排序',
  153. `uniacid` int(11) NOT NULL
  154. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  155. );
  156. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_news')."(
  157. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  158. `title` varchar(50) NOT NULL COMMENT '公告标题',
  159. `details` text NOT NULL COMMENT '公告详情',
  160. `num` int(11) NOT NULL COMMENT '排序',
  161. `uniacid` int(11) NOT NULL,
  162. `time` int(11) NOT NULL
  163. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  164. );
  165. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_top')."(
  166. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  167. `type` int(11) NOT NULL COMMENT '1.一天2.一周3.一个月',
  168. `money` decimal(10,2) NOT NULL COMMENT '价格',
  169. `uniacid` int(11) NOT NULL,
  170. `num` int(11) NOT NULL
  171. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
  172. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_label')."(
  173. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  174. `label_name` varchar(20) NOT NULL,
  175. `type2_id` int(11) NOT NULL
  176. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  177. );
  178. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_mylabel')."(
  179. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  180. `label_id` int(11) NOT NULL,
  181. `information_id` int(11) NOT NULL
  182. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  183. );
  184. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_in')."(
  185. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  186. `type` int(11) NOT NULL COMMENT '1.一天2.半年3.一年',
  187. `money` DECIMAL(10,2) NOT NULL,
  188. `num` int(11) NOT NULL,
  189. `uniacid` int(11) NOT NULL
  190. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  191. );
  192. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_help')."(
  193. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  194. `question` varchar(200) NOT NULL COMMENT '标题',
  195. `answer` text NOT NULL COMMENT '回答',
  196. `sort` int(4) NOT NULL COMMENT '排序',
  197. `uniacid` varchar(50) NOT NULL,
  198. `created_time` datetime NOT NULL
  199. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  200. );
  201. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_sms')."(
  202. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  203. `appkey` varchar(100) NOT NULL,
  204. `tpl_id` int(11) NOT NULL,
  205. `uniacid` int(11) NOT NULL
  206. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  207. );
  208. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fx')."(
  209. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  210. `user_id` int(11) NOT NULL COMMENT '用户ID',
  211. `zf_user_id` int(11) NOT NULL COMMENT '转发人ID',
  212. `money` decimal(10,2) NOT NULL COMMENT '金额',
  213. `time` int(11) NOT NULL COMMENT '时间戳',
  214. `uniacid` varchar(50) NOT NULL
  215. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销表';"
  216. );
  217. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_hblq')."(
  218. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  219. `user_id` int(11) NOT NULL COMMENT '用户ID',
  220. `tz_id` int(11) NOT NULL COMMENT '帖子ID',
  221. `money` decimal(10,2) NOT NULL COMMENT '金额',
  222. `time` int(11) NOT NULL COMMENT '时间戳',
  223. `uniacid` varchar(50) NOT NULL
  224. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销表';"
  225. );
  226. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_withdrawal')."(
  227. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  228. `name` varchar(10) NOT NULL COMMENT '真实姓名',
  229. `username` varchar(100) NOT NULL COMMENT '账号',
  230. `type` int(11) NOT NULL COMMENT '1支付宝 2.微信 3.银行',
  231. `time` int(11) NOT NULL COMMENT '申请时间',
  232. `sh_time` int(11) NOT NULL COMMENT '审核时间',
  233. `state` int(11) NOT NULL COMMENT '1.待审核 2.通过 3.拒绝',
  234. `tx_cost` decimal(10,2) NOT NULL COMMENT '提现金额',
  235. `sj_cost` decimal(10,2) NOT NULL COMMENT '实际金额',
  236. `user_id` int(11) NOT NULL COMMENT '用户id',
  237. `uniacid` int(11) NOT NULL
  238. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  239. );
  240. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_zx')."(
  241. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  242. `type_id` int(11) NOT NULL COMMENT '分类ID',
  243. `user_id` int(11) NOT NULL COMMENT '发布人ID',
  244. `title` varchar(200) NOT NULL COMMENT '标题',
  245. `content` text NOT NULL COMMENT '内容',
  246. `time` datetime NOT NULL COMMENT '时间',
  247. `yd_num` int(11) NOT NULL COMMENT '阅读数量',
  248. `pl_num` int(11) NOT NULL COMMENT '评论数量',
  249. `uniacid` varchar(50) NOT NULL,
  250. `imgs` text NOT NULL COMMENT '图片'
  251. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;"
  252. );
  253. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_zx_type')."(
  254. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  255. `type_name` varchar(100) NOT NULL COMMENT '分类名称',
  256. `icon` varchar(100) NOT NULL COMMENT '图标',
  257. `sort` int(4) NOT NULL COMMENT '排序',
  258. `time` datetime NOT NULL COMMENT '时间',
  259. `uniacid` varchar(50) NOT NULL
  260. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;"
  261. );
  262. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_zx_assess')."(
  263. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  264. `zx_id` int(4) NOT NULL,
  265. `score` int(11) NOT NULL,
  266. `content` text NOT NULL,
  267. `img` varchar(500) NOT NULL,
  268. `cerated_time` datetime NOT NULL,
  269. `user_id` int(11) NOT NULL,
  270. `uniacid` varchar(50) NOT NULL,
  271. `status` int(4) NOT NULL,
  272. `reply` text NOT NULL,
  273. `reply_time` datetime NOT NULL
  274. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;"
  275. );
  276. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_zx_zj')."(
  277. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  278. `zx_id` int(11) NOT NULL COMMENT '资讯ID',
  279. `user_id` int(11) NOT NULL COMMENT '用户ID',
  280. `uniacid` varchar(50) NOT NULL,
  281. `time` int(11) NOT NULL COMMENT '时间'
  282. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='资讯足迹';"
  283. );
  284. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_car')."(
  285. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  286. `user_id` int(11) NOT NULL COMMENT '用户id',
  287. `start_place` varchar(100) NOT NULL COMMENT '出发地',
  288. `end_place` varchar(100) NOT NULL COMMENT '目的地',
  289. `start_time` varchar(30) NOT NULL COMMENT '出发时间',
  290. `num` int(4) NOT NULL COMMENT '乘车人数/可乘人数',
  291. `link_name` varchar(30) NOT NULL COMMENT '联系人',
  292. `link_tel` varchar(20) NOT NULL COMMENT '联系电话',
  293. `typename` varchar(30) NOT NULL COMMENT '分类名称',
  294. `other` varchar(300) NOT NULL COMMENT '补充',
  295. `time` int(11) NOT NULL COMMENT '发布时间',
  296. `sh_time` int(11) NOT NULL COMMENT '审核时间',
  297. `top_id` int(11) NOT NULL COMMENT '置顶ID',
  298. `top` int(4) NOT NULL COMMENT '是否置顶,1,是,2否',
  299. `uniacid` varchar(50) NOT NULL,
  300. `state` int(4) NOT NULL COMMENT '1待审核,2通过,3拒绝',
  301. `tj_place` varchar(300) NOT NULL COMMENT '途经地',
  302. `hw_wet` varchar(10) NOT NULL COMMENT '货物重量',
  303. `star_lat` varchar(20) NOT NULL COMMENT '出发地维度',
  304. `star_lng` varchar(20) NOT NULL COMMENT '出发地经度',
  305. `end_lat` varchar(20) NOT NULL COMMENT '目的地维度',
  306. `end_lng` varchar(20) NOT NULL COMMENT '目的地经度'
  307. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='拼车';"
  308. );
  309. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_car_my_tag')."(
  310. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  311. `tag_id` int(11) NOT NULL COMMENT '标签id',
  312. `car_id` int(11) NOT NULL COMMENT '拼车ID'
  313. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  314. );
  315. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_car_tag')."(
  316. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  317. `typename` varchar(30) NOT NULL COMMENT '分类名称',
  318. `tagname` varchar(30) NOT NULL COMMENT '标签名称',
  319. `uniacid` varchar(11) NOT NULL COMMENT '50'
  320. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  321. );
  322. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_car_top')."(
  323. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  324. `type` int(11) NOT NULL COMMENT '1.一天2.一周3.一个月',
  325. `money` decimal(10,2) NOT NULL COMMENT '价格',
  326. `uniacid` int(11) NOT NULL,
  327. `num` int(11) NOT NULL
  328. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='拼车置顶';"
  329. );
  330. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_goods')."(
  331. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  332. `store_id` int(11) NOT NULL COMMENT '商家ID',
  333. `spec_id` int(11) NOT NULL COMMENT '主规格ID',
  334. `goods_name` varchar(100) NOT NULL COMMENT '商品名称',
  335. `goods_num` int(11) NOT NULL COMMENT '商品数量',
  336. `goods_cost` decimal(10,2) NOT NULL COMMENT '商品价格',
  337. `freight` decimal(10,2) NOT NULL COMMENT '运费',
  338. `delivery` varchar(500) NOT NULL COMMENT '关于发货',
  339. `quality` int(4) NOT NULL COMMENT '正品1是,0否',
  340. `free` int(4) NOT NULL COMMENT '包邮1是,0否',
  341. `all_day` int(4) NOT NULL COMMENT '24小时发货1是,0否',
  342. `service` int(4) NOT NULL COMMENT '售后服务1是,0否',
  343. `refund` int(4) NOT NULL COMMENT '极速退款1是,0否',
  344. `weeks` int(4) NOT NULL COMMENT '7天包邮1是,0否',
  345. `lb_imgs` varchar(500) NOT NULL COMMENT '轮播图',
  346. `imgs` varchar(500) NOT NULL COMMENT '商品介绍图',
  347. `time` int(11) NOT NULL COMMENT '时间',
  348. `uniacid` varchar(50) NOT NULL,
  349. `goods_details` text NOT NULL COMMENT '商品详细',
  350. `state` int(4) NOT NULL COMMENT '1待审核,2通过,3拒绝',
  351. `sy_num` int(11) NOT NULL COMMENT '剩余数量'
  352. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='商品表';"
  353. );
  354. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_goods_spec')."(
  355. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  356. `spec_name` varchar(100) NOT NULL COMMENT '规格名称',
  357. `sort` int(4) NOT NULL COMMENT '排序',
  358. `uniacid` varchar(50) NOT NULL COMMENT '50'
  359. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='商品规格表';"
  360. );
  361. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_spec_value')."(
  362. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  363. `goods_id` int(11) NOT NULL COMMENT '商品ID',
  364. `spec_id` int(11) NOT NULL,
  365. `money` decimal(10,2) NOT NULL COMMENT '价格',
  366. `name` varchar(50) NOT NULL COMMENT '名称',
  367. `num` int(11) NOT NULL COMMENT '数量'
  368. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  369. );
  370. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_order')."(
  371. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  372. `user_id` int(11) NOT NULL,
  373. `store_id` int(11) NOT NULL,
  374. `money` decimal(10,2) NOT NULL COMMENT '金额',
  375. `user_name` varchar(20) NOT NULL COMMENT '联系人',
  376. `address` varchar(200) NOT NULL COMMENT '联系地址',
  377. `tel` varchar(20) NOT NULL COMMENT '电话',
  378. `time` int(11) NOT NULL COMMENT '下单时间',
  379. `pay_time` int(11) NOT NULL,
  380. `complete_time` int(11) NOT NULL,
  381. `fh_time` int(11) NOT NULL COMMENT '发货时间',
  382. `state` int(11) NOT NULL COMMENT '1.待付款 2.待发货3.待确认4.已完成5.退款中6.已退款7.退款拒绝',
  383. `order_num` varchar(20) NOT NULL COMMENT '订单号',
  384. `good_id` int(11) NOT NULL,
  385. `good_name` varchar(100) NOT NULL,
  386. `good_img` varchar(500) NOT NULL,
  387. `good_money` decimal(10,2) NOT NULL,
  388. `out_trade_no` varchar(50) NOT NULL,
  389. `good_spec` varchar(200) NOT NULL COMMENT '商品规格',
  390. `del` int(11) NOT NULL COMMENT '用户删除1是 2否 ',
  391. `del2` int(11) NOT NULL COMMENT '商家删除1.是2.否',
  392. `uniacid` int(11) NOT NULL
  393. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';"
  394. );
  395. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_store_wallet')."(
  396. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  397. `store_id` int(11) NOT NULL,
  398. `money` decimal(10,2) NOT NULL,
  399. `note` varchar(20) NOT NULL,
  400. `type` int(11) NOT NULL COMMENT '1加2减'
  401. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商家钱包明细';"
  402. );
  403. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_commission_withdrawal')."(
  404. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  405. `user_id` int(11) NOT NULL,
  406. `type` int(11) NOT NULL COMMENT '1.支付宝2.银行卡',
  407. `state` int(11) NOT NULL COMMENT '1.审核中2.通过3.拒绝',
  408. `time` int(11) NOT NULL COMMENT '申请时间',
  409. `sh_time` int(11) NOT NULL COMMENT '审核时间',
  410. `uniacid` int(11) NOT NULL,
  411. `user_name` varchar(20) NOT NULL,
  412. `account` varchar(100) NOT NULL,
  413. `tx_cost` decimal(10,2) NOT NULL COMMENT '提现金额',
  414. `sj_cost` decimal(10,2) NOT NULL COMMENT '实际到账金额'
  415. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='佣金提现';"
  416. );
  417. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_distribution')."(
  418. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  419. `user_id` int(11) NOT NULL,
  420. `time` int(11) NOT NULL,
  421. `user_name` varchar(20) NOT NULL,
  422. `user_tel` varchar(20) NOT NULL,
  423. `state` int(11) NOT NULL COMMENT '1.审核中2.通过3.拒绝',
  424. `uniacid` int(11) NOT NULL
  425. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销申请';"
  426. );
  427. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_earnings')."(
  428. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  429. `user_id` int(11) NOT NULL,
  430. `son_id` int(11) NOT NULL COMMENT '下线',
  431. `money` decimal(10,2) NOT NULL,
  432. `time` int(11) NOT NULL,
  433. `uniacid` int(11) NOT NULL
  434. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='佣金收益表';"
  435. );
  436. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fxset')."(
  437. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  438. `fx_details` text NOT NULL COMMENT '分销商申请协议',
  439. `tx_details` text NOT NULL COMMENT '佣金提现协议',
  440. `is_fx` int(11) NOT NULL COMMENT '1.开启分销审核2.不开启',
  441. `is_ej` int(11) NOT NULL COMMENT '是否开启二级分销1.是2.否',
  442. `tx_rate` int(11) NOT NULL COMMENT '提现手续费',
  443. `commission` varchar(10) NOT NULL COMMENT '一级佣金',
  444. `commission2` varchar(10) NOT NULL COMMENT '二级佣金',
  445. `tx_money` int(11) NOT NULL COMMENT '提现门槛',
  446. `img` varchar(500) NOT NULL COMMENT '分销中心图片',
  447. `img2` varchar(500) NOT NULL COMMENT '申请分销图片',
  448. `uniacid` int(11) NOT NULL,
  449. `is_open` int(11) NOT NULL DEFAULT '1' COMMENT '1.开启2关闭',
  450. `instructions` text NOT NULL COMMENT '分销商说明'
  451. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  452. );
  453. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fxuser')."(
  454. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  455. `user_id` int(11) NOT NULL COMMENT '一级分销',
  456. `fx_user` int(11) NOT NULL COMMENT '二级分销',
  457. `time` int(11) NOT NULL
  458. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  459. );
  460. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowset')."(
  461. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  462. `days` int(11) NOT NULL COMMENT '入住天数',
  463. `money` decimal(10,2) NOT NULL,
  464. `num` int(11) NOT NULL,
  465. `uniacid` int(11) NOT NULL
  466. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='黄页设置表';"
  467. );
  468. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowstore')."(
  469. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  470. `user_id` int(11) NOT NULL,
  471. `logo` varchar(500) NOT NULL COMMENT 'logo图片',
  472. `company_name` varchar(100) NOT NULL COMMENT '公司名称',
  473. `company_address` varchar(200) NOT NULL COMMENT '公司地址',
  474. `type_id` int(11) NOT NULL COMMENT '二级分类',
  475. `link_tel` varchar(20) NOT NULL COMMENT '联系电话',
  476. `sort` int(11) NOT NULL COMMENT '排序',
  477. `rz_time` int(11) NOT NULL COMMENT '入住时间',
  478. `sh_time` int(11) NOT NULL COMMENT '审核时间',
  479. `state` int(4) NOT NULL COMMENT '1待,2通过,3拒绝',
  480. `rz_type` int(4) NOT NULL COMMENT '入驻类型',
  481. `time_over` int(4) NOT NULL COMMENT '1到期,2没到期',
  482. `uniacid` varchar(50) NOT NULL,
  483. `coordinates` varchar(50) NOT NULL COMMENT '坐标',
  484. `content` text NOT NULL COMMENT '简介',
  485. `imgs` varchar(500) NOT NULL COMMENT '多图'
  486. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;"
  487. );
  488. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_hotcity')."(
  489. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  490. `cityname` varchar(50) NOT NULL COMMENT '城市名称',
  491. `time` int(11) NOT NULL COMMENT '创建时间',
  492. `uniacid` varchar(50) NOT NULL
  493. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  494. );
  495. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_paylog')."(
  496. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  497. `fid` int(11) NOT NULL COMMENT '外键id(商家,帖子,黄页,拼车)',
  498. `money` decimal(10,2) NOT NULL COMMENT '钱',
  499. `time` datetime NOT NULL COMMENT '时间',
  500. `uniacid` varchar(50) NOT NULL COMMENT '50'
  501. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付记录表';"
  502. );
  503. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_account')."(
  504. `id` int(10) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  505. `weid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属帐号',
  506. `storeid` varchar(1000) NOT NULL,
  507. `uid` int(10) unsigned NOT NULL DEFAULT '0',
  508. `from_user` varchar(100) NOT NULL DEFAULT '',
  509. `accountname` varchar(50) NOT NULL DEFAULT '',
  510. `password` varchar(200) NOT NULL DEFAULT '',
  511. `salt` varchar(10) NOT NULL DEFAULT '',
  512. `pwd` varchar(50) NOT NULL,
  513. `mobile` varchar(20) NOT NULL,
  514. `email` varchar(20) NOT NULL,
  515. `username` varchar(50) NOT NULL,
  516. `pay_account` varchar(200) NOT NULL,
  517. `displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  518. `dateline` int(10) unsigned NOT NULL DEFAULT '0',
  519. `status` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '状态',
  520. `role` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1:店长,2:店员',
  521. `lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
  522. `lastip` varchar(15) NOT NULL,
  523. `areaid` int(10) NOT NULL DEFAULT '0' COMMENT '区域id',
  524. `is_admin_order` tinyint(1) unsigned NOT NULL DEFAULT '1',
  525. `is_notice_order` tinyint(1) unsigned NOT NULL DEFAULT '1',
  526. `is_notice_queue` tinyint(1) unsigned NOT NULL DEFAULT '1',
  527. `is_notice_service` tinyint(1) unsigned NOT NULL DEFAULT '1',
  528. `is_notice_boss` tinyint(1) NOT NULL DEFAULT '0',
  529. `remark` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注',
  530. `lat` decimal(18,10) NOT NULL DEFAULT '0.0000000000' COMMENT '经度',
  531. `lng` decimal(18,10) NOT NULL DEFAULT '0.0000000000' COMMENT '纬度',
  532. `cityname` varchar(50) NOT NULL COMMENT '城市名称'
  533. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  534. );
  535. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_carpaylog')."(
  536. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  537. `car_id` int(44) NOT NULL COMMENT '拼车id',
  538. `money` decimal(10,2) NOT NULL COMMENT '钱',
  539. `time` datetime NOT NULL,
  540. `uniacid` varchar(50) NOT NULL
  541. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='拼车支付记录表';"
  542. );
  543. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_storepaylog')."(
  544. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  545. `store_id` int(11) NOT NULL COMMENT '商家ID',
  546. `money` decimal(10,2) NOT NULL,
  547. `time` datetime NOT NULL,
  548. `uniacid` varchar(50) NOT NULL
  549. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商家入驻支付记录表';"
  550. );
  551. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_tzpaylog')."(
  552. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  553. `tz_id` int(11) NOT NULL,
  554. `money` decimal(10,2) NOT NULL,
  555. `time` datetime NOT NULL,
  556. `uniacid` varchar(50) NOT NULL
  557. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='帖子支付记录表';"
  558. );
  559. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowpaylog')."(
  560. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  561. `hy_id` int(11) NOT NULL,
  562. `money` decimal(10,2) NOT NULL,
  563. `time` datetime NOT NULL,
  564. `uniacid` varchar(50) NOT NULL
  565. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='黄页支付记录表';"
  566. );
  567. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yjset')."(
  568. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  569. `type` int(4) NOT NULL DEFAULT '1' COMMENT '1统一模式,2分开模式',
  570. `typer` varchar(10) NOT NULL COMMENT '统一比例',
  571. `sjper` varchar(10) NOT NULL COMMENT '商家比例',
  572. `hyper` varchar(10) NOT NULL COMMENT '黄页比例',
  573. `pcper` varchar(10) NOT NULL COMMENT '拼车比例',
  574. `tzper` varchar(10) NOT NULL COMMENT '帖子比例',
  575. `uniacid` varchar(50) NOT NULL
  576. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='佣金比例表';"
  577. );
  578. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yjtx')."(
  579. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  580. `account_id` int(11) NOT NULL COMMENT '账号id',
  581. `tx_type` int(4) NOT NULL COMMENT '提现方式 1,支付宝,2微信,3银联',
  582. `tx_cost` decimal(10,2) NOT NULL COMMENT '提现金额',
  583. `status` int(4) NOT NULL COMMENT '状态 1申请,2通过,3拒绝',
  584. `uniacid` varchar(50) NOT NULL,
  585. `cerated_time` datetime NOT NULL COMMENT '日期',
  586. `sj_cost` decimal(10,2) NOT NULL COMMENT '实际金额',
  587. `account` varchar(30) NOT NULL COMMENT '账户',
  588. `name` varchar(30) NOT NULL COMMENT '姓名',
  589. `sx_cost` decimal(10,2) NOT NULL COMMENT '手续费',
  590. `time` datetime NOT NULL COMMENT '审核时间',
  591. `is_del` int(4) NOT NULL DEFAULT '1' COMMENT '1正常,2删除'
  592. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;"
  593. );
  594. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_userformid')."(
  595. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  596. `user_id` int(11) NOT NULL COMMENT '用户id',
  597. `form_id` varchar(50) NOT NULL COMMENT 'form_id',
  598. `time` datetime NOT NULL,
  599. `uniacid` varchar(50) NOT NULL,
  600. `openid` varchar(50) NOT NULL COMMENT 'openid'
  601. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='formid表';"
  602. );
  603. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_nav')."(
  604. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  605. `title` varchar(50) NOT NULL COMMENT '名称',
  606. `logo` varchar(500) NOT NULL COMMENT '图标',
  607. `status` int(11) NOT NULL COMMENT '1.开启 2.关闭',
  608. `src` varchar(100) NOT NULL COMMENT '内部链接',
  609. `orderby` int(11) NOT NULL COMMENT '排序',
  610. `xcx_name` varchar(20) NOT NULL COMMENT '小程序名称',
  611. `appid` varchar(20) NOT NULL COMMENT 'APPID',
  612. `uniacid` int(11) NOT NULL COMMENT '小程序id',
  613. `wb_src` varchar(300) NOT NULL COMMENT '外部链接',
  614. `state` int(4) NOT NULL DEFAULT '1' COMMENT '1内部,2外部,3跳转'
  615. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;"
  616. );
  617. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_video')."(
  618. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  619. `type_id` int(11) NOT NULL COMMENT '分类ID',
  620. `title` varchar(200) NOT NULL COMMENT '标题',
  621. `time` datetime NOT NULL,
  622. `yd_num` int(11) NOT NULL COMMENT '阅读数量',
  623. `pl_num` int(11) NOT NULL COMMENT '评论数量',
  624. `dz_num` int(11) NOT NULL COMMENT '点赞数量',
  625. `uniacid` varchar(50) NOT NULL,
  626. `url` varchar(500) NOT NULL COMMENT '视频链接',
  627. `logo` varchar(500) NOT NULL COMMENT '发布人logo',
  628. `nick_name` varchar(30) NOT NULL COMMENT '昵称',
  629. `cityname` varchar(50) NOT NULL COMMENT '城市名称',
  630. `num` int(11) NOT NULL COMMENT '排序',
  631. `fm_logo` varchar(500) NOT NULL
  632. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  633. );
  634. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_videotype')."(
  635. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  636. `type_name` varchar(20) NOT NULL COMMENT '分类名称',
  637. `img` varchar(500) NOT NULL COMMENT '分类图片',
  638. `uniacid` int(11) NOT NULL COMMENT '小程序id',
  639. `num` int(11) NOT NULL,
  640. `state` int(4) NOT NULL DEFAULT '1'
  641. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  642. );
  643. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_videopl')."(
  644. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  645. `user_id` int(11) NOT NULL,
  646. `content` varchar(500) NOT NULL,
  647. `video_id` int(11) NOT NULL,
  648. `time` varchar(20) NOT NULL
  649. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  650. );
  651. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_videodz')."(
  652. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  653. `user_id` int(11) NOT NULL,
  654. `video_id` int(11) NOT NULL
  655. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  656. );
  657. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_integral')."(
  658. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  659. `user_id` int(11) NOT NULL COMMENT '用户id',
  660. `score` int(11) NOT NULL COMMENT '分数',
  661. `type` int(4) NOT NULL COMMENT '1加,2减',
  662. `order_id` int(11) NOT NULL COMMENT '订单id',
  663. `cerated_time` datetime NOT NULL COMMENT '创建时间',
  664. `uniacid` varchar(50) NOT NULL,
  665. `note` varchar(20) NOT NULL COMMENT '备注'
  666. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  667. );
  668. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_jfgoods')."(
  669. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  670. `name` varchar(50) NOT NULL COMMENT '名称',
  671. `img` varchar(500) NOT NULL,
  672. `money` int(11) NOT NULL COMMENT '价格',
  673. `type_id` int(11) NOT NULL COMMENT '分类id',
  674. `goods_details` text NOT NULL,
  675. `process_details` text NOT NULL,
  676. `attention_details` text NOT NULL,
  677. `number` int(11) NOT NULL COMMENT '数量',
  678. `time` varchar(50) NOT NULL COMMENT '期限',
  679. `is_open` int(11) NOT NULL COMMENT '1.开启2关闭',
  680. `type` int(11) NOT NULL COMMENT '1.余额2.实物',
  681. `num` int(11) NOT NULL COMMENT '排序',
  682. `uniacid` int(11) NOT NULL,
  683. `hb_moeny` decimal(10,2) NOT NULL
  684. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  685. );
  686. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_jfrecord')."(
  687. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  688. `user_id` int(11) NOT NULL COMMENT '用户id',
  689. `good_id` int(11) NOT NULL COMMENT '商品id',
  690. `time` varchar(20) NOT NULL COMMENT '兑换时间',
  691. `user_name` varchar(20) NOT NULL COMMENT '用户地址',
  692. `user_tel` varchar(20) NOT NULL COMMENT '用户电话',
  693. `address` varchar(200) NOT NULL COMMENT '地址',
  694. `note` varchar(20) NOT NULL,
  695. `integral` int(11) NOT NULL COMMENT '积分',
  696. `good_name` varchar(50) NOT NULL COMMENT '商品名称',
  697. `state` INT NULL DEFAULT '1',
  698. `good_img` varchar(500) NOT NULL
  699. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  700. );
  701. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_jftype')."(
  702. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  703. `name` varchar(20) NOT NULL,
  704. `img` varchar(500) NOT NULL,
  705. `num` int(11) NOT NULL,
  706. `uniacid` int(11) NOT NULL
  707. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  708. );
  709. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_signlist')."(
  710. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  711. `user_id` int(11) NOT NULL,
  712. `time` varchar(20) NOT NULL COMMENT '签到时间',
  713. `time2` int(11) NOT NULL,
  714. `integral` int(11) NOT NULL,
  715. `uniacid` int(11) NOT NULL
  716. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  717. );
  718. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_signset')."(
  719. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  720. `one` int(11) NOT NULL COMMENT '首次奖励积分',
  721. `integral` int(11) NOT NULL COMMENT '每天签到积分',
  722. `is_open` int(11) NOT NULL COMMENT '1.开启2.关闭 签到',
  723. `is_bq` int(11) NOT NULL COMMENT '1.开启2.关闭 补签',
  724. `bq_integral` int(11) NOT NULL COMMENT '补签扣除积分',
  725. `details` text NOT NULL COMMENT '签到说明',
  726. `uniacid` int(11) NOT NULL
  727. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  728. );
  729. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_special')."(
  730. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  731. `day` varchar(20) NOT NULL COMMENT '日期',
  732. `integral` int(11) NOT NULL COMMENT '积分',
  733. `title` varchar(20) NOT NULL COMMENT '标题说明',
  734. `color` varchar(20) NOT NULL COMMENT '颜色',
  735. `uniacid` int(11) NOT NULL
  736. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  737. );
  738. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_continuous')."(
  739. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  740. `day` int(11) NOT NULL COMMENT '天数',
  741. `integral` int(11) NOT NULL COMMENT '积分',
  742. `uniacid` int(11) NOT NULL
  743. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  744. );
  745. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_qbmx')."(
  746. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  747. `money` decimal(10,2) NOT NULL,
  748. `type` int(11) NOT NULL,
  749. `note` varchar(20) NOT NULL,
  750. `time` varchar(20) NOT NULL,
  751. `user_id` int(11) NOT NULL
  752. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  753. );
  754. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fxlevel')."(
  755. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  756. `money` decimal(10,2) NOT NULL,
  757. `name` varchar(20) NOT NULL,
  758. `num` int(11) NOT NULL,
  759. `uniacid` int(11) NOT NULL,
  760. `commission` int(11) NOT NULL COMMENT '1级佣金比例',
  761. `commission2` int(11) NOT NULL COMMENT '2级佣金比例'
  762. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  763. );
  764. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowtype')."(
  765. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  766. `type_name` varchar(20) NOT NULL COMMENT '分类名称',
  767. `img` varchar(500) NOT NULL COMMENT '分类图片',
  768. `uniacid` int(11) NOT NULL COMMENT '小程序id',
  769. `num` int(11) NOT NULL,
  770. `money` decimal(10,2) NOT NULL,
  771. `state` int(4) NOT NULL DEFAULT '1' COMMENT '1启用,2禁用'
  772. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  773. );
  774. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_yellowtype2')."(
  775. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  776. `name` varchar(20) NOT NULL COMMENT '分类名称',
  777. `type_id` int(11) NOT NULL COMMENT '主分类id',
  778. `num` int(11) NOT NULL,
  779. `uniacid` int(11) NOT NULL,
  780. `state` int(4) NOT NULL DEFAULT '1' COMMENT '1启用,2禁用'
  781. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  782. );
  783. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_storetypead')."(
  784. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  785. `title` varchar(50) NOT NULL COMMENT '轮播图标题',
  786. `logo` varchar(500) NOT NULL COMMENT '图片',
  787. `status` int(11) NOT NULL COMMENT '1.开启 2.关闭',
  788. `src` varchar(100) NOT NULL COMMENT '链接',
  789. `orderby` int(11) NOT NULL COMMENT '排序',
  790. `xcx_name` varchar(20) NOT NULL,
  791. `appid` varchar(20) NOT NULL,
  792. `type_id` int(11) NOT NULL,
  793. `type_id2` int(11) NOT NULL,
  794. `uniacid` int(11) NOT NULL COMMENT '小程序id',
  795. `cityname` varchar(50) NOT NULL COMMENT '城市名称',
  796. `wb_src` varchar(300) NOT NULL COMMENT '外部链接',
  797. `state` int(4) NOT NULL DEFAULT '1' COMMENT '1内部,2外部,3跳转'
  798. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  799. );
  800. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_joinlist')."(
  801. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  802. `user_id` int(11) NOT NULL,
  803. `act_id` int(11) NOT NULL,
  804. `time` varchar(20) NOT NULL,
  805. `money` decimal(10,2) NOT NULL,
  806. `code` varchar(100) NOT NULL,
  807. `form_id` varchar(100) NOT NULL,
  808. `state` int(11) NOT NULL COMMENT '1.待支付2.已支付3.已通过4.已核销5.已拒绝',
  809. `uniacid` int(11) NOT NULL,
  810. `user_name` varchar(20) NOT NULL,
  811. `user_tel` varchar(20) NOT NULL,
  812. `hx_time` varchar(20) NOT NULL
  813. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  814. );
  815. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_acttype')."(
  816. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  817. `type_name` varchar(20) NOT NULL,
  818. `num` int(11) NOT NULL,
  819. `uniacid` int(11) NOT NULL,
  820. `state` int(11) NOT NULL COMMENT '1.开启2.关闭'
  821. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  822. );
  823. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_activity')."(
  824. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  825. `title` varchar(50) NOT NULL COMMENT '活动标题',
  826. `logo` varchar(500) NOT NULL COMMENT '活动logo',
  827. `img` text NOT NULL COMMENT '活动轮播图',
  828. `details` text NOT NULL COMMENT '活动详情',
  829. `number` int(11) NOT NULL COMMENT '限制人数',
  830. `sign_num` int(11) NOT NULL COMMENT '限制人数',
  831. `time` varchar(20) NOT NULL COMMENT '发布时间',
  832. `start_time` varchar(20) NOT NULL COMMENT '开始时间',
  833. `end_time` varchar(20) NOT NULL COMMENT '结束时间',
  834. `uniacid` int(11) NOT NULL COMMENT '小程序id',
  835. `money` decimal(10,2) NOT NULL COMMENT '价格',
  836. `type_id` int(11) NOT NULL COMMENT '分类id',
  837. `tel` varchar(20) NOT NULL COMMENT '电话',
  838. `address` varchar(200) NOT NULL COMMENT '地址',
  839. `coordinate` varchar(50) NOT NULL COMMENT '坐标',
  840. `num` int(11) NOT NULL COMMENT '排序',
  841. `view` int(11) NOT NULL COMMENT '访问量',
  842. `is_bm` int(11) NOT NULL DEFAULT '1' COMMENT '1.开启2.关闭',
  843. `cityname` varchar(20) NOT NULL COMMENT '城市'
  844. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  845. );
  846. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_acthxlist')."(
  847. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  848. `user_id` int(11) NOT NULL,
  849. `act_id` int(11) NOT NULL
  850. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  851. );
  852. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_dmorder')."(
  853. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  854. `user_id` int(11) NOT NULL,
  855. `money` decimal(10,2) NOT NULL,
  856. `store_id` int(11) NOT NULL,
  857. `code` varchar(100) NOT NULL,
  858. `state` int(11) NOT NULL,
  859. `time` varchar(20) NOT NULL,
  860. `uniacid` int(11) NOT NULL
  861. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  862. );
  863. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_coupons')."(
  864. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  865. `name` varchar(20) NOT NULL,
  866. `number` int(11) NOT NULL,
  867. `full` varchar(20) NOT NULL COMMENT '满',
  868. `reduce` decimal(10,1) NOT NULL COMMENT '减',
  869. `money` decimal(10,2) NOT NULL,
  870. `time` varchar(20) NOT NULL,
  871. `details` text NOT NULL COMMENT '使用说明',
  872. `surplus` int(11) NOT NULL COMMENT '剩余数量',
  873. `store_id` int(11) NOT NULL,
  874. `end_time` varchar(20) NOT NULL,
  875. `img` text NOT NULL,
  876. `is_show` int(11) NOT NULL DEFAULT '1'
  877. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  878. );
  879. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_usercoupons')."(
  880. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  881. `coupons_id` int(11) NOT NULL,
  882. `user_id` int(11) NOT NULL,
  883. `state` int(11) NOT NULL DEFAULT '2' COMMENT '1.使用2.未使用',
  884. `time` varchar(20) NOT NULL,
  885. `pay_type` int(11) NOT NULL,
  886. `code` varchar(100) NOT NULL,
  887. `lq_money` decimal(10,2) NOT NULL,
  888. `del` int(11) NOT NULL DEFAULT '2'
  889. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  890. );
  891. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_fxlog')."(
  892. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  893. `user_id` int(11) NOT NULL,
  894. `money` decimal(10,2) NOT NULL,
  895. `time` varchar(20) NOT NULL,
  896. `code` varchar(100) NOT NULL,
  897. `level` int(11) NOT NULL,
  898. `note` varchar(20) NOT NULL,
  899. `uniacid` int(11) NOT NULL,
  900. `state` int(11) NOT NULL DEFAULT '1' COMMENT '1.待支付2.已支付'
  901. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  902. );
  903. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_llz')."(
  904. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  905. `name` varchar(20) NOT NULL,
  906. `type` int(11) NOT NULL,
  907. `status` int(11) NOT NULL,
  908. `src` varchar(100) NOT NULL,
  909. `cityname` varchar(20) NOT NULL,
  910. `uniacid` int(11) NOT NULL
  911. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  912. );
  913. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_sensitive')."(
  914. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  915. `content` text NOT NULL COMMENT '内容',
  916. `uniacid` int(11) NOT NULL COMMENT '11'
  917. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  918. );
  919. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_message')."(
  920. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  921. `note` varchar(100) NOT NULL,
  922. `source` varchar(100) NOT NULL,
  923. `content` varchar(100) NOT NULL,
  924. `time` varchar(100) NOT NULL,
  925. `fs_time` varchar(20) NOT NULL,
  926. `uniacid` int(11) NOT NULL,
  927. `src` varchar(100) NOT NULL
  928. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  929. );
  930. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_qgtype')."(
  931. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  932. `name` varchar(20) NOT NULL,
  933. `num` int(11) NOT NULL,
  934. `uniacid` int(11) NOT NULL
  935. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  936. );
  937. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_qgorder')."(
  938. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  939. `order_num` varchar(50) NOT NULL,
  940. `user_id` int(11) NOT NULL,
  941. `user_name` varchar(20) NOT NULL,
  942. `user_tel` varchar(20) NOT NULL,
  943. `store_id` int(11) NOT NULL,
  944. `money` decimal(10,2) NOT NULL,
  945. `good_id` int(11) NOT NULL,
  946. `pay_type` int(11) NOT NULL COMMENT '1.微信支付2.余额支付',
  947. `state` int(11) NOT NULL COMMENT '1.待支付2已支付3.已核销',
  948. `dq_time` varchar(20) NOT NULL COMMENT '到期时间',
  949. `uniacid` int(11) NOT NULL,
  950. `code` varchar(100) NOT NULL,
  951. `good_name` varchar(20) NOT NULL,
  952. `good_logo` varchar(500) NOT NULL,
  953. `pay_time` varchar(20) NOT NULL,
  954. `hx_time` varchar(20) NOT NULL,
  955. `del` int(11) NOT NULL DEFAULT '2' COMMENT '1删除2.未删除',
  956. `note` varchar(50) NOT NULL
  957. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  958. );
  959. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_qggoods')."(
  960. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  961. `name` varchar(20) NOT NULL,
  962. `logo` varchar(500) NOT NULL,
  963. `price` decimal(10,1) NOT NULL COMMENT '原价',
  964. `money` decimal(10,1) NOT NULL COMMENT '现价',
  965. `number` int(11) NOT NULL COMMENT '数量',
  966. `surplus` int(11) NOT NULL COMMENT '剩余',
  967. `start_time` varchar(20) NOT NULL COMMENT '开始时间',
  968. `end_time` varchar(20) NOT NULL COMMENT '结束时间',
  969. `consumption_time` int(11) NOT NULL COMMENT '消费截止时间',
  970. `details` text NOT NULL,
  971. `store_id` int(11) NOT NULL,
  972. `uniacid` int(11) NOT NULL,
  973. `state` int(11) NOT NULL DEFAULT '1' COMMENT '1.上架2.下架',
  974. `state2` int(11) NOT NULL DEFAULT '1',
  975. `is_tg` int(11) NOT NULL DEFAULT '1',
  976. `type_id` int(11) NOT NULL,
  977. `img` text NOT NULL,
  978. `num` int(11) NOT NULL,
  979. `hot` int(11) NOT NULL
  980. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  981. );
  982. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_group')."(
  983. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  984. `store_id` int(11) NOT NULL COMMENT '门店id',
  985. `goods_id` int(11) NOT NULL COMMENT '商品ID',
  986. `goods_logo` varchar(500) NOT NULL,
  987. `goods_name` varchar(255) NOT NULL COMMENT '商品名称',
  988. `kt_num` int(11) NOT NULL COMMENT '开团人数',
  989. `yg_num` int(11) NOT NULL COMMENT '已购数量',
  990. `kt_time` int(11) NOT NULL COMMENT '开团时间',
  991. `dq_time` int(11) NOT NULL COMMENT '到期时间',
  992. `state` int(4) NOT NULL COMMENT '1.拼团中2成功,3失败',
  993. `user_id` int(11) NOT NULL COMMENT '团长user_id',
  994. `uniacid` int(11) NOT NULL
  995. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  996. );
  997. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_groupgoods')."(
  998. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  999. `store_id` int(11) NOT NULL COMMENT '门店id',
  1000. `type_id` int(11) NOT NULL COMMENT '分类ID',
  1001. `name` varchar(255) NOT NULL COMMENT '名称',
  1002. `logo` varchar(500) NOT NULL COMMENT 'logo',
  1003. `img` text NOT NULL COMMENT '多图',
  1004. `inventory` int(11) NOT NULL COMMENT '库存',
  1005. `pt_price` decimal(10,2) NOT NULL COMMENT '拼团价格',
  1006. `y_price` decimal(10,2) NOT NULL COMMENT '原价',
  1007. `dd_price` decimal(10,2) NOT NULL COMMENT '单独购买价格',
  1008. `ycd_num` int(11) NOT NULL COMMENT '已成团数量',
  1009. `ysc_num` int(11) NOT NULL COMMENT '已售出数量',
  1010. `people` int(11) NOT NULL COMMENT '成团人数',
  1011. `start_time` int(11) NOT NULL COMMENT '开始时间',
  1012. `end_time` int(11) NOT NULL COMMENT '结束时间',
  1013. `xf_time` int(11) NOT NULL COMMENT '消费截止时间',
  1014. `is_shelves` int(4) NOT NULL DEFAULT '1' COMMENT '1上架,2下架',
  1015. `details` text NOT NULL COMMENT '商品详情',
  1016. `details_img` text NOT NULL COMMENT '详情多图',
  1017. `num` int(11) NOT NULL COMMENT '排序',
  1018. `state` int(4) NOT NULL DEFAULT '1' COMMENT '1待审核,2通过,3拒绝',
  1019. `display` int(4) NOT NULL DEFAULT '1' COMMENT '1显示,2不显示',
  1020. `uniacid` int(11) NOT NULL,
  1021. `introduction` text NOT NULL,
  1022. `time` int(11) NOT NULL COMMENT '发布时间'
  1023. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  1024. );
  1025. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_grouporder')."(
  1026. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  1027. `group_id` int(11) NOT NULL COMMENT '团id',
  1028. `store_id` int(11) NOT NULL COMMENT '门店id',
  1029. `goods_id` int(11) NOT NULL COMMENT '商品ID',
  1030. `user_id` int(11) NOT NULL COMMENT '用户ID',
  1031. `order_num` varchar(30) NOT NULL COMMENT '订单号',
  1032. `logo` varchar(500) NOT NULL COMMENT '商品图片',
  1033. `goods_name` varchar(255) NOT NULL COMMENT '商品名称',
  1034. `goods_type` varchar(50) NOT NULL COMMENT '商品类型',
  1035. `price` decimal(10,2) NOT NULL COMMENT '单价',
  1036. `goods_num` int(11) NOT NULL COMMENT '商品数量',
  1037. `money` decimal(10,2) NOT NULL COMMENT '订单金额',
  1038. `pay_type` int(4) NOT NULL COMMENT '付款方式1微信,2余额',
  1039. `receive_name` varchar(30) NOT NULL COMMENT '收货人',
  1040. `receive_tel` varchar(20) NOT NULL COMMENT '收货人电话',
  1041. `receive_address` varchar(100) NOT NULL COMMENT '收货人地址',
  1042. `note` varchar(100) NOT NULL COMMENT '备注',
  1043. `state` int(4) NOT NULL COMMENT '1未付款,2已付款,3已完成,4已关闭,5已失效',
  1044. `xf_time` int(11) NOT NULL COMMENT '消费截止时间',
  1045. `time` int(11) NOT NULL COMMENT '下单时间',
  1046. `pay_time` int(11) NOT NULL COMMENT '付款时间',
  1047. `cz_time` int(11) NOT NULL COMMENT '完成/关闭/失效时间',
  1048. `code` varchar(30) NOT NULL COMMENT '支付商户号',
  1049. `uniacid` int(11) NOT NULL
  1050. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  1051. );
  1052. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_grouptype')."(
  1053. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  1054. `name` varchar(20) NOT NULL,
  1055. `img` varchar(500) NOT NULL,
  1056. `num` int(11) NOT NULL,
  1057. `uniacid` int(11) NOT NULL
  1058. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='拼团分类';"
  1059. );
  1060. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_coupontype')."(
  1061. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  1062. `type_name` varchar(20) NOT NULL COMMENT '分类名称',
  1063. `img` varchar(500) NOT NULL COMMENT '分类图片',
  1064. `uniacid` int(11) NOT NULL COMMENT '小程序id',
  1065. `num` int(11) NOT NULL,
  1066. `state` int(4) NOT NULL DEFAULT '1'
  1067. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  1068. );
  1069. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_plate')."(
  1070. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  1071. `type` int(4) NOT NULL,
  1072. `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
  1073. `time` int(11) NOT NULL,
  1074. `uniacid` int(11) NOT NULL,
  1075. `sort` int(11) NOT NULL COMMENT '排序'
  1076. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='首页板块导航';"
  1077. );
  1078. pdo_query("CREATE TABLE IF NOT EXISTS".tablename('zhtc_bottom')."(
  1079. `id` int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  1080. `title` varchar(20) NOT NULL COMMENT '标题',
  1081. `title_color` varchar(20) NOT NULL COMMENT '标题选中颜色',
  1082. `title_color2` varchar(20) NOT NULL COMMENT '标题未选中颜色',
  1083. `logo` varchar(200) NOT NULL COMMENT '选中图片',
  1084. `logo2` varchar(200) NOT NULL COMMENT '未选中图片',
  1085. `url` varchar(200) NOT NULL COMMENT '跳转链接',
  1086. `num` int(11) NOT NULL COMMENT '排序',
  1087. `state` int(11) NOT NULL DEFAULT '1' COMMENT '1开启2关闭',
  1088. `uniacid` int(11) NOT NULL,
  1089. `xcx_name` varchar(50) NOT NULL COMMENT '小程序名称',
  1090. `appid` varchar(30) NOT NULL COMMENT '跳转appid',
  1091. `item` int(4) NOT NULL DEFAULT '1',
  1092. `src2` varchar(255) NOT NULL
  1093. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"
  1094. );
  1095. if (!pdo_fieldexists(tablename('zhtc_ad'), 'type')) {
  1096. pdo_query("ALTER TABLE".tablename('zhtc_ad')." ADD `type` INT NOT NULL;");
  1097. }
  1098. if (!pdo_fieldexists(tablename('zhtc_store'), 'coordinates')) {
  1099. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `coordinates` VARCHAR(50) NOT NULL;");
  1100. }
  1101. if (!pdo_fieldexists(tablename('zhtc_store'), 'views')) {
  1102. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `views` INT NOT NULL;");
  1103. }
  1104. if (!pdo_fieldexists(tablename('zhtc_information'), 'sh_time')) {
  1105. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `sh_time` INT NOT NULL;");
  1106. }
  1107. if (!pdo_fieldexists(tablename('zhtc_information'), 'top_type')) {
  1108. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `top_type` INT NOT NULL;");
  1109. }
  1110. if (!pdo_fieldexists(tablename('zhtc_news'), 'img')) {
  1111. pdo_query("ALTER TABLE".tablename('zhtc_news')." ADD `img` VARCHAR(500) NOT NULL;");
  1112. }
  1113. if (!pdo_fieldexists(tablename('zhtc_news'), 'state')) {
  1114. pdo_query("ALTER TABLE".tablename('zhtc_news')." ADD `state` INT NOT NULL;");
  1115. }
  1116. if (!pdo_fieldexists(tablename('zhtc_system'), 'mapkey')) {
  1117. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `mapkey` VARCHAR(200) NOT NULL;");
  1118. }
  1119. if (!pdo_fieldexists(tablename('zhtc_system'), 'tel')) {
  1120. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tel` VARCHAR(20) NOT NULL;");
  1121. }
  1122. if (!pdo_fieldexists(tablename('zhtc_system'), 'gd_key')) {
  1123. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gd_key` VARCHAR(100) NOT NULL;");
  1124. }
  1125. if (!pdo_fieldexists(tablename('zhtc_news'), 'type')) {
  1126. pdo_query("ALTER TABLE".tablename('zhtc_news')." ADD `type` INT NOT NULL;");
  1127. }
  1128. if (!pdo_fieldexists(tablename('zhtc_comments'), 'store_id')) {
  1129. pdo_query("ALTER TABLE".tablename('zhtc_comments')." ADD `store_id` INT NOT NULL;");
  1130. }
  1131. if (!pdo_fieldexists(tablename('zhtc_share'), 'store_id')) {
  1132. pdo_query("ALTER TABLE".tablename('zhtc_share')." ADD `store_id` INT NOT NULL;");
  1133. }
  1134. if (!pdo_fieldexists(tablename('zhtc_store'), 'score')) {
  1135. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `score` DECIMAL(10,1) NOT NULL;");
  1136. }
  1137. if (!pdo_fieldexists(tablename('zhtc_comments'), 'score')) {
  1138. pdo_query("ALTER TABLE".tablename('zhtc_comments')." ADD `score` DECIMAL(10,1) NOT NULL;");
  1139. }
  1140. if (!pdo_fieldexists(tablename('zhtc_store'), 'type')) {
  1141. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `type` INT NOT NULL;");
  1142. }
  1143. if (!pdo_fieldexists(tablename('zhtc_store'), 'sh_time')) {
  1144. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `sh_time` INT NOT NULL;");
  1145. }
  1146. if (!pdo_fieldexists(tablename('zhtc_store'), 'time_over')) {
  1147. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `time_over` INT NOT NULL;");
  1148. }
  1149. if (!pdo_fieldexists(tablename('zhtc_information'), 'address')) {
  1150. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `address` VARCHAR(500) NOT NULL;");
  1151. }
  1152. if (!pdo_fieldexists(tablename('zhtc_store'), 'img')) {
  1153. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `img` TEXT NOT NULL;");
  1154. }
  1155. if (!pdo_fieldexists(tablename('zhtc_system'), 'rz_xuz')) {
  1156. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `rz_xuz` TEXT NOT NULL;");
  1157. }
  1158. if (!pdo_fieldexists(tablename('zhtc_system'), 'ft_xuz')) {
  1159. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `ft_xuz` TEXT NOT NULL;");
  1160. }
  1161. if (!pdo_fieldexists(tablename('zhtc_store'), 'vr_link')) {
  1162. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `vr_link` TEXT NOT NULL;");
  1163. }
  1164. if (!pdo_fieldexists(tablename('zhtc_system'), 'fx_money')) {
  1165. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `fx_money` DECIMAL(10,2) NOT NULL;");
  1166. }
  1167. if (!pdo_fieldexists(tablename('zhtc_user'), 'money')) {
  1168. pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `money` DECIMAL(10,2) NOT NULL;");
  1169. }
  1170. if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_money')) {
  1171. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_money` DECIMAL(10,2) NOT NULL;");
  1172. }
  1173. if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_num')) {
  1174. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_num` INT NOT NULL;");
  1175. }
  1176. if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_type')) {
  1177. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_type` INT NOT NULL;");
  1178. }
  1179. if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_keyword')) {
  1180. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_keyword` VARCHAR(20) NOT NULL;");
  1181. }
  1182. if (!pdo_fieldexists(tablename('zhtc_information'), 'hb_random')) {
  1183. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hb_random` INT NOT NULL;");
  1184. }
  1185. if (!pdo_fieldexists(tablename('zhtc_system'), 'hb_sxf')) {
  1186. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hb_sxf` INT NOT NULL;");
  1187. }
  1188. if (!pdo_fieldexists(tablename('zhtc_information'), 'hong')) {
  1189. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hong` TEXT NOT NULL;");
  1190. }
  1191. if (!pdo_fieldexists(tablename('zhtc_information'), 'store_id')) {
  1192. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `store_id` INT NOT NULL;");
  1193. }
  1194. if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_money')) {
  1195. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_money` DECIMAL(10,2) NOT NULL;");
  1196. }
  1197. if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_sxf')) {
  1198. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_sxf` INT NOT NULL;");
  1199. }
  1200. if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_details')) {
  1201. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_details` TEXT NOT NULL;");
  1202. }
  1203. if (!pdo_fieldexists(tablename('zhtc_information'), 'del')) {
  1204. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `del` INT NOT NULL DEFAULT '2';");
  1205. }
  1206. if (!pdo_fieldexists(tablename('zhtc_sms'), 'is_open')) {
  1207. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `is_open` INT NOT NULL DEFAULT '2';");
  1208. }
  1209. if (!pdo_fieldexists(tablename('zhtc_store'), 'num')) {
  1210. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `num` INT NOT NULL;");
  1211. }
  1212. if (!pdo_fieldexists(tablename('zhtc_store'), 'start_time')) {
  1213. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `start_time` VARCHAR(20) NOT NULL;");
  1214. }
  1215. if (!pdo_fieldexists(tablename('zhtc_store'), 'end_time')) {
  1216. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `end_time` VARCHAR(20) NOT NULL;");
  1217. }
  1218. if (!pdo_fieldexists(tablename('zhtc_like'), 'zx_id')) {
  1219. pdo_query("ALTER TABLE".tablename('zhtc_like')." ADD `zx_id` INT NOT NULL;");
  1220. }
  1221. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hhr')) {
  1222. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hhr` INT(4) NOT NULL DEFAULT '2';");
  1223. }
  1224. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hbfl')) {
  1225. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hbfl` INT(4) NOT NULL DEFAULT '2';");
  1226. }
  1227. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_zx')) {
  1228. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_zx` INT(4) NOT NULL DEFAULT '2';");
  1229. }
  1230. if (!pdo_fieldexists(tablename('zhtc_zx'), 'state')) {
  1231. pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `state` INT(4) NOT NULL ;");
  1232. }
  1233. if (!pdo_fieldexists(tablename('zhtc_zx'), 'sh_time')) {
  1234. pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `sh_time` DATETIME NOT NULL ;");
  1235. }
  1236. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_car')) {
  1237. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_car` INT(4) NOT NULL ;");
  1238. }
  1239. if (!pdo_fieldexists(tablename('zhtc_system'), 'pc_xuz')) {
  1240. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `pc_xuz` TEXT NOT NULL ;");
  1241. }
  1242. if (!pdo_fieldexists(tablename('zhtc_system'), 'pc_money')) {
  1243. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `pc_money` DECIMAL(10,2) NOT NULL ;");
  1244. }
  1245. if (!pdo_fieldexists(tablename('zhtc_car'), 'is_open')) {
  1246. pdo_query("ALTER TABLE".tablename('zhtc_car')." ADD `is_open` INT(4) NOT NULL ;");
  1247. }
  1248. if (!pdo_fieldexists(tablename('zhtc_car'), 'start_time2')) {
  1249. pdo_query("ALTER TABLE".tablename('zhtc_car')." ADD `start_time2` INT NOT NULL ;");
  1250. }
  1251. if (!pdo_fieldexists(tablename('zhtc_information'), 'user_img2')) {
  1252. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `user_img2` VARCHAR(200) NOT NULL;");
  1253. }
  1254. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_sjrz')) {
  1255. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_sjrz` INT(4) NOT NULL;");
  1256. }
  1257. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pcfw')) {
  1258. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pcfw` INT(4) NOT NULL;");
  1259. }
  1260. if (!pdo_fieldexists(tablename('zhtc_system'), 'total_num')) {
  1261. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `total_num` INT(11) NOT NULL;");
  1262. }
  1263. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_goods')) {
  1264. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_goods` INT(4) NOT NULL;");
  1265. }
  1266. if (!pdo_fieldexists(tablename('zhtc_user'), 'user_name')) {
  1267. pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `user_name` VARCHAR(20) NOT NULL;");
  1268. }
  1269. if (!pdo_fieldexists(tablename('zhtc_user'), 'user_tel')) {
  1270. pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `user_tel` VARCHAR(20) NOT NULL;");
  1271. }
  1272. if (!pdo_fieldexists(tablename('zhtc_user'), 'user_address')) {
  1273. pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `user_address` VARCHAR(200) NOT NULL;");
  1274. }
  1275. if (!pdo_fieldexists(tablename('zhtc_store'), 'wallet')) {
  1276. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `wallet` DECIMAL(10,2) NOT NULL;");
  1277. }
  1278. if (!pdo_fieldexists(tablename('zhtc_order'), 'freight')) {
  1279. pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `freight` DECIMAL(10,2) NOT NULL;");
  1280. }
  1281. if (!pdo_fieldexists(tablename('zhtc_order'), 'note')) {
  1282. pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `note` VARCHAR(100) NOT NULL;");
  1283. }
  1284. if (!pdo_fieldexists(tablename('zhtc_system'), 'apiclient_cert')) {
  1285. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `apiclient_cert` TEXT NOT NULL;");
  1286. }
  1287. if (!pdo_fieldexists(tablename('zhtc_system'), 'apiclient_key')) {
  1288. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `apiclient_key` TEXT NOT NULL;");
  1289. }
  1290. if (!pdo_fieldexists(tablename('zhtc_type'), 'state')) {
  1291. pdo_query("ALTER TABLE".tablename('zhtc_type')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
  1292. }
  1293. if (!pdo_fieldexists(tablename('zhtc_storetype'), 'state')) {
  1294. pdo_query("ALTER TABLE".tablename('zhtc_storetype')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
  1295. }
  1296. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_openzx')) {
  1297. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_openzx` INT(4) NOT NULL ;");
  1298. }
  1299. if (!pdo_fieldexists(tablename('zhtc_storetype2'), 'state')) {
  1300. pdo_query("ALTER TABLE".tablename('zhtc_storetype2')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
  1301. }
  1302. if (!pdo_fieldexists(tablename('zhtc_type2'), 'state')) {
  1303. pdo_query("ALTER TABLE".tablename('zhtc_type2')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
  1304. }
  1305. if (!pdo_fieldexists(tablename('zhtc_order'), 'good_num')) {
  1306. pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `good_num` INT NOT NULL ;");
  1307. }
  1308. if (!pdo_fieldexists(tablename('zhtc_goods'), 'is_show')) {
  1309. pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `is_show` INT NOT NULL DEFAULT '1';");
  1310. }
  1311. if (!pdo_fieldexists(tablename('zhtc_goods'), 'sales')) {
  1312. pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `sales` INT NOT NULL ;");
  1313. }
  1314. if (!pdo_fieldexists(tablename('zhtc_zx'), 'type')) {
  1315. pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `type` INT(4) NOT NULL ;");
  1316. }
  1317. if (!pdo_fieldexists(tablename('zhtc_store_wallet'), 'time')) {
  1318. pdo_query("ALTER TABLE".tablename('zhtc_store_wallet')." ADD `time` VARCHAR(20) NOT NULL ;");
  1319. }
  1320. if (!pdo_fieldexists(tablename('zhtc_withdrawal'), 'method')) {
  1321. pdo_query("ALTER TABLE".tablename('zhtc_withdrawal')." ADD `method` INT NOT NULL ;");
  1322. }
  1323. if (!pdo_fieldexists(tablename('zhtc_withdrawal'), 'store_id')) {
  1324. pdo_query("ALTER TABLE".tablename('zhtc_withdrawal')." ADD `store_id` INT NOT NULL ;");
  1325. }
  1326. if (!pdo_fieldexists(tablename('zhtc_user'), 'commission')) {
  1327. pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `commission` DECIMAL(10,2) NOT NULL ;");
  1328. }
  1329. if (!pdo_fieldexists(tablename('zhtc_store'), 'user_name')) {
  1330. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `user_name` VARCHAR(30) NOT NULL ;");
  1331. }
  1332. if (!pdo_fieldexists(tablename('zhtc_store'), 'pwd')) {
  1333. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `pwd` VARCHAR(50) NOT NULL ;");
  1334. }
  1335. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hyset')) {
  1336. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hyset` INT(4) NOT NULL ;");
  1337. }
  1338. if (!pdo_fieldexists(tablename('zhtc_store'), 'dq_time')) {
  1339. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `dq_time` INT(11) NOT NULL ;");
  1340. }
  1341. if (!pdo_fieldexists(tablename('zhtc_information'), 'dq_time')) {
  1342. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `dq_time` INT(11) NOT NULL ;");
  1343. }
  1344. if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'views')) {
  1345. pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `views` INT NOT NULL ;");
  1346. }
  1347. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_tzopen')) {
  1348. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_tzopen` INT(4) NOT NULL ;");
  1349. }
  1350. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pageopen')) {
  1351. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pageopen` INT(4) NOT NULL ;");
  1352. }
  1353. if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'tel2')) {
  1354. pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `tel2` VARCHAR(20) NOT NULL ;");
  1355. }
  1356. if (!pdo_fieldexists(tablename('zhtc_information'), 'cityname')) {
  1357. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `cityname` VARCHAR(50) NOT NULL ;");
  1358. }
  1359. if (!pdo_fieldexists(tablename('zhtc_system'), 'cityname')) {
  1360. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `cityname` VARCHAR(50) NOT NULL ;");
  1361. }
  1362. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_tel')) {
  1363. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_tel` INT(4) NOT NULL DEFAULT '1' ;");
  1364. }
  1365. if (!pdo_fieldexists(tablename('zhtc_store'), 'cityname')) {
  1366. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `cityname` VARCHAR(50) NOT NULL ;");
  1367. }
  1368. if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'cityname')) {
  1369. pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `cityname` VARCHAR(50) NOT NULL ;");
  1370. }
  1371. if (!pdo_fieldexists(tablename('zhtc_sms'), 'tid1')) {
  1372. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tid1` VARCHAR(50) NOT NULL ;");
  1373. }
  1374. if (!pdo_fieldexists(tablename('zhtc_sms'), 'tid2')) {
  1375. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tid2` VARCHAR(50) NOT NULL ;");
  1376. }
  1377. if (!pdo_fieldexists(tablename('zhtc_sms'), 'tid3')) {
  1378. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tid3` VARCHAR(50) NOT NULL ;");
  1379. }
  1380. if (!pdo_fieldexists(tablename('zhtc_car'), 'cityname')) {
  1381. pdo_query("ALTER TABLE".tablename('zhtc_car')." ADD `cityname` VARCHAR(50) NOT NULL ;");
  1382. }
  1383. if (!pdo_fieldexists(tablename('zhtc_store'), 'time')) {
  1384. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `time` DATETIME NOT NULL ;");
  1385. }
  1386. if (!pdo_fieldexists(tablename('zhtc_zx'), 'cityname')) {
  1387. pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `cityname` VARCHAR(50) NOT NULL ;");
  1388. }
  1389. if (!pdo_fieldexists(tablename('zhtc_ad'), 'cityname')) {
  1390. pdo_query("ALTER TABLE".tablename('zhtc_ad')." ADD `cityname` VARCHAR(50) NOT NULL ;");
  1391. }
  1392. if (!pdo_fieldexists(tablename('zhtc_news'), 'cityname')) {
  1393. pdo_query("ALTER TABLE".tablename('zhtc_news')." ADD `cityname` VARCHAR(50) NOT NULL ;");
  1394. }
  1395. if (!pdo_fieldexists(tablename('zhtc_user'), 'state')) {
  1396. pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
  1397. }
  1398. if (!pdo_fieldexists(tablename('zhtc_paylog'), 'note')) {
  1399. pdo_query("ALTER TABLE".tablename('zhtc_paylog')." ADD `note` VARCHAR(100) NOT NULL;");
  1400. }
  1401. if (!pdo_fieldexists(tablename('zhtc_store'), 'fx_num')) {
  1402. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `fx_num` INT(11) NOT NULL;");
  1403. }
  1404. if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_mode')) {
  1405. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_mode` INT(4) NOT NULL DEFAULT '1';");
  1406. }
  1407. if (!pdo_fieldexists(tablename('zhtc_system'), 'many_city')) {
  1408. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `many_city` INT(4) NOT NULL DEFAULT '2';");
  1409. }
  1410. if (!pdo_fieldexists(tablename('zhtc_store'), 'ewm_logo')) {
  1411. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `ewm_logo` VARCHAR(500) NOT NULL;");
  1412. }
  1413. if (!pdo_fieldexists(tablename('zhtc_hotcity'), 'user_id')) {
  1414. pdo_query("ALTER TABLE".tablename('zhtc_hotcity')." ADD `user_id` INT(11) NOT NULL;");
  1415. }
  1416. if (!pdo_fieldexists(tablename('zhtc_ad'), 'wb_src')) {
  1417. pdo_query("ALTER TABLE".tablename('zhtc_ad')." ADD `wb_src` VARCHAR(300) NOT NULL;");
  1418. }
  1419. if (!pdo_fieldexists(tablename('zhtc_ad'), 'state')) {
  1420. pdo_query("ALTER TABLE".tablename('zhtc_ad')." ADD `state` INT(4) NOT NULL DEFAULT '1';");
  1421. }
  1422. if (!pdo_fieldexists(tablename('zhtc_system'), 'tx_type')) {
  1423. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tx_type` INT(4) NOT NULL DEFAULT '2';");
  1424. }
  1425. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hbzf')) {
  1426. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hbzf` INT(4) NOT NULL DEFAULT '1';");
  1427. }
  1428. if (!pdo_fieldexists(tablename('zhtc_system'), 'hb_img')) {
  1429. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hb_img` VARCHAR(500) NOT NULL;");
  1430. }
  1431. if (!pdo_fieldexists(tablename('zhtc_system'), 'tz_num')) {
  1432. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tz_num` INT(11) NOT NULL;");
  1433. }
  1434. if (!pdo_fieldexists(tablename('zhtc_system'), 'client_ip')) {
  1435. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `client_ip` VARCHAR(30) NOT NULL;");
  1436. }
  1437. if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'dq_time')) {
  1438. pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `dq_time` INT(11) NOT NULL;");
  1439. }
  1440. if (!pdo_fieldexists(tablename('zhtc_information'), 'hbfx_num')) {
  1441. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `hbfx_num` INT(11) NOT NULL;");
  1442. }
  1443. if (!pdo_fieldexists(tablename('zhtc_store'), 'is_top')) {
  1444. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `is_top` INT(4) NOT NULL DEFAULT '2';");
  1445. }
  1446. if (!pdo_fieldexists(tablename('zhtc_system'), 'hb_content')) {
  1447. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hb_content` VARCHAR(100) NOT NULL;");
  1448. }
  1449. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_tzhb')) {
  1450. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_tzhb` INT(4) NOT NULL DEFAULT '1';");
  1451. }
  1452. if (!pdo_fieldexists(tablename('zhtc_store_wallet'), 'tx_id')) {
  1453. pdo_query("ALTER TABLE".tablename('zhtc_store_wallet')." ADD `tx_id` INT(11) NOT NULL;");
  1454. }
  1455. if (!pdo_fieldexists(tablename('zhtc_system'), 'sj_max')) {
  1456. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sj_max` VARCHAR(1) NOT NULL;");
  1457. }
  1458. if (!pdo_fieldexists(tablename('zhtc_system'), 'zfwl_max')) {
  1459. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `zfwl_max` VARCHAR(1) NOT NULL;");
  1460. }
  1461. if (!pdo_fieldexists(tablename('zhtc_system'), 'zfwl_open')) {
  1462. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `zfwl_open` INT(4) NOT NULL DEFAULT '1';");
  1463. }
  1464. if (!pdo_fieldexists(tablename('zhtc_system'), 'zx_type')) {
  1465. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `zx_type` INT(4) NOT NULL DEFAULT '1';");
  1466. }
  1467. if (!pdo_fieldexists(tablename('zhtc_type'), 'sx_money')) {
  1468. pdo_query("ALTER TABLE".tablename('zhtc_type')." ADD `sx_money` decimal(10,2) NOT NULL;");
  1469. }
  1470. if (!pdo_fieldexists(tablename('zhtc_system'), 'ft_num')) {
  1471. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `ft_num` INT(11) NOT NULL;");
  1472. }
  1473. if (!pdo_fieldexists(tablename('zhtc_system'), 'ft_num')) {
  1474. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `ft_num` INT(11) NOT NULL;");
  1475. }
  1476. if (!pdo_fieldexists(tablename('zhtc_store'), 'yyzz_img')) {
  1477. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `yyzz_img` VARCHAR(500) NOT NULL;");
  1478. }
  1479. if (!pdo_fieldexists(tablename('zhtc_store'), 'sfz_img')) {
  1480. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `sfz_img` VARCHAR(500) NOT NULL;");
  1481. }
  1482. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_img')) {
  1483. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_img` INT(11) NOT NULL DEFAULT '2';");
  1484. }
  1485. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_sjhb')) {
  1486. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_sjhb` INT(11) NOT NULL DEFAULT '1';");
  1487. }
  1488. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_tzdz')) {
  1489. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_tzdz` INT(11) NOT NULL DEFAULT '1';");
  1490. }
  1491. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_rz')) {
  1492. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_rz` INT(11) NOT NULL DEFAULT '1';");
  1493. }
  1494. if (!pdo_fieldexists(tablename('zhtc_user'), 'total_score')) {
  1495. pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `total_score` INT(11) NOT NULL;");
  1496. }
  1497. if (!pdo_fieldexists(tablename('zhtc_user'), 'day')) {
  1498. pdo_query("ALTER TABLE".tablename('zhtc_user')." ADD `day` INT(11) NOT NULL;");
  1499. }
  1500. if (!pdo_fieldexists(tablename('zhtc_signlist'), 'time3')) {
  1501. pdo_query("ALTER TABLE".tablename('zhtc_signlist')." ADD `time3` INT(11) NOT NULL;");
  1502. }
  1503. if (!pdo_fieldexists(tablename('zhtc_system'), 'integral')) {
  1504. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `integral` INT(11) NOT NULL;");
  1505. }
  1506. if (!pdo_fieldexists(tablename('zhtc_system'), 'integral2')) {
  1507. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `integral2` INT(11) NOT NULL;");
  1508. }
  1509. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_jf')) {
  1510. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_jf` INT(11) NOT NULL DEFAULT '1';");
  1511. }
  1512. // pdo_query("ALTER TABLE".tablename('zhtc_system')." CHANGE `is_tel` `is_tel` INT(4) NOT NULL DEFAULT '1';");
  1513. if (!pdo_fieldexists(tablename('zhtc_account'), 'money')) {
  1514. pdo_query("ALTER TABLE".tablename('zhtc_account')." ADD `money` DECIMAL(10,2) NOT NULL;");
  1515. }
  1516. if (!pdo_fieldexists(tablename('zhtc_distribution'), 'money')) {
  1517. pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `money` DECIMAL(10,2) NOT NULL;");
  1518. }
  1519. if (!pdo_fieldexists(tablename('zhtc_distribution'), 'pay_state')) {
  1520. pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `pay_state` INT(11) NOT NULL;");
  1521. }
  1522. if (!pdo_fieldexists(tablename('zhtc_distribution'), 'code')) {
  1523. pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `code` VARCHAR(50) NOT NULL;");
  1524. }
  1525. if (!pdo_fieldexists(tablename('zhtc_distribution'), 'level')) {
  1526. pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `level` INT(11) NOT NULL;");
  1527. }
  1528. if (!pdo_fieldexists(tablename('zhtc_distribution'), 'cityname')) {
  1529. pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `cityname` VARCHAR(20) NOT NULL;");
  1530. }
  1531. if (!pdo_fieldexists(tablename('zhtc_sms'), 'tpl2_id')) {
  1532. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tpl2_id` INT(11) NOT NULL;");
  1533. }
  1534. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_kf')) {
  1535. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_kf` INT(11) NOT NULL DEFAULT '1';");
  1536. }
  1537. if (!pdo_fieldexists(tablename('zhtc_system'), 'dw_more')) {
  1538. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `dw_more` INT(11) NOT NULL DEFAULT '2';");
  1539. }
  1540. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_zxrz')) {
  1541. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_zxrz` INT(11) NOT NULL DEFAULT '1';");
  1542. }
  1543. if (!pdo_fieldexists(tablename('zhtc_storepaylog'), 'note')) {
  1544. pdo_query("ALTER TABLE".tablename('zhtc_storepaylog')." ADD `note` VARCHAR(20) NOT NULL;");
  1545. }
  1546. if (!pdo_fieldexists(tablename('zhtc_tzpaylog'), 'note')) {
  1547. pdo_query("ALTER TABLE".tablename('zhtc_tzpaylog')." ADD `note` VARCHAR(20) NOT NULL;");
  1548. }
  1549. if (!pdo_fieldexists(tablename('zhtc_order'), 'is_zt')) {
  1550. pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `is_zt` INT(11) NOT NULL DEFAULT '2';");
  1551. }
  1552. if (!pdo_fieldexists(tablename('zhtc_order'), 'zt_time')) {
  1553. pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `zt_time` VARCHAR(20) NOT NULL;");
  1554. }
  1555. if (!pdo_fieldexists(tablename('zhtc_system'), 'tzmc')) {
  1556. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tzmc` VARCHAR(20) NOT NULL;");
  1557. }
  1558. if (!pdo_fieldexists(tablename('zhtc_system'), 'tzmc')) {
  1559. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tzmc` VARCHAR(20) NOT NULL DEFAULT '帖子';");
  1560. }
  1561. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_dnss')) {
  1562. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_dnss` INT(11) NOT NULL DEFAULT '1';");
  1563. }
  1564. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_vr')) {
  1565. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_vr` INT(11) NOT NULL DEFAULT '1';");
  1566. }
  1567. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_yysj')) {
  1568. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_yysj` INT(11) NOT NULL DEFAULT '1';");
  1569. }
  1570. if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'type2_id')) {
  1571. pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `type2_id` INT(11) NOT NULL;");
  1572. }
  1573. if (!pdo_fieldexists(tablename('zhtc_system'), 'tc_img')) {
  1574. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tc_img` VARCHAR(500) NOT NULL;");
  1575. }
  1576. if (!pdo_fieldexists(tablename('zhtc_system'), 'tc_gg')) {
  1577. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `tc_gg` VARCHAR(100) NOT NULL;");
  1578. }
  1579. if (!pdo_fieldexists(tablename('zhtc_system'), 'hbbj_img')) {
  1580. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hbbj_img` VARCHAR(500) NOT NULL;");
  1581. }
  1582. if (!pdo_fieldexists(tablename('zhtc_signset'), 'qd_img')) {
  1583. pdo_query("ALTER TABLE".tablename('zhtc_signset')." ADD `qd_img` VARCHAR(500) NOT NULL;");
  1584. }
  1585. if (!pdo_fieldexists(tablename('zhtc_commission_withdrawal'), 'bank')) {
  1586. pdo_query("ALTER TABLE".tablename('zhtc_commission_withdrawal')." ADD `bank` VARCHAR(20) NOT NULL;");
  1587. }
  1588. if (!pdo_fieldexists(tablename('zhtc_withdrawal'), 'bank')) {
  1589. pdo_query("ALTER TABLE".tablename('zhtc_withdrawal')." ADD `bank` VARCHAR(20) NOT NULL;");
  1590. }
  1591. if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_img')) {
  1592. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_img` text NOT NULL;");
  1593. }
  1594. if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_details')) {
  1595. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_details` text NOT NULL;");
  1596. }
  1597. if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_tel')) {
  1598. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_tel` VARCHAR(20) NOT NULL;");
  1599. }
  1600. if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_time')) {
  1601. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_time` VARCHAR(50) NOT NULL;");
  1602. }
  1603. if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_add')) {
  1604. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_add` VARCHAR(200) NOT NULL;");
  1605. }
  1606. if (!pdo_fieldexists(tablename('zhtc_system'), 'gs_zb')) {
  1607. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `gs_zb` VARCHAR(50) NOT NULL;");
  1608. }
  1609. if (!pdo_fieldexists(tablename('zhtc_system'), 'model')) {
  1610. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `model` INT(11) NOT NULL DEFAULT '1';");
  1611. }
  1612. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_bm')) {
  1613. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_bm` INT(11) NOT NULL DEFAULT '2';");
  1614. }
  1615. if (!pdo_fieldexists(tablename('zhtc_order'), 'kd_num')) {
  1616. pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `kd_num` VARCHAR(100) NOT NULL;");
  1617. }
  1618. if (!pdo_fieldexists(tablename('zhtc_order'), 'kd_name')) {
  1619. pdo_query("ALTER TABLE".tablename('zhtc_order')." ADD `kd_name` VARCHAR(20) NOT NULL;");
  1620. }
  1621. if (!pdo_fieldexists(tablename('zhtc_system'), 'zf_title')) {
  1622. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `zf_title` VARCHAR(50) NOT NULL;");
  1623. }
  1624. if (!pdo_fieldexists(tablename('zhtc_system'), 'sh_time')) {
  1625. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sh_time` int NOT NULL;");
  1626. }
  1627. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_qgb')) {
  1628. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_qgb` int NOT NULL DEFAULT '2';");
  1629. }
  1630. if (!pdo_fieldexists(tablename('zhtc_type'), 'money2')) {
  1631. pdo_query("ALTER TABLE".tablename('zhtc_type')." ADD `money2` decimal(10,2) NOT NULL;");
  1632. }
  1633. if (!pdo_fieldexists(tablename('zhtc_top'), 'money2')) {
  1634. pdo_query("ALTER TABLE".tablename('zhtc_top')." ADD `money2` decimal(10,2) NOT NULL;");
  1635. }
  1636. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_qgb2')) {
  1637. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_qgb2` int NOT NULL DEFAULT '2';");
  1638. }
  1639. if (!pdo_fieldexists(tablename('zhtc_in'), 'money2')) {
  1640. pdo_query("ALTER TABLE".tablename('zhtc_in')." ADD `money2` decimal(10,2) NOT NULL;");
  1641. }
  1642. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_coupon')) {
  1643. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_coupon` INT(11) NOT NULL DEFAULT '2';");
  1644. }
  1645. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_sy')) {
  1646. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_sy` INT(11) NOT NULL DEFAULT '2';");
  1647. }
  1648. if (!pdo_fieldexists(tablename('zhtc_system'), 'coupon_img')) {
  1649. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `coupon_img` VARCHAR(500) NOT NULL;");
  1650. }
  1651. if (!pdo_fieldexists(tablename('zhtc_coupons'), 'state')) {
  1652. pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `state` INT(11) NOT NULL DEFAULT '1';");
  1653. }
  1654. if (!pdo_fieldexists(tablename('zhtc_goods'), 'is_xs')) {
  1655. pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `is_xs` INT(11) NOT NULL DEFAULT '2';");
  1656. }
  1657. if (!pdo_fieldexists(tablename('zhtc_goods'), 'end_time')) {
  1658. pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `end_time` VARCHAR(20) NOT NULL;");
  1659. }
  1660. if (!pdo_fieldexists(tablename('zhtc_usercoupons'), 'hx_time')) {
  1661. pdo_query("ALTER TABLE".tablename('zhtc_usercoupons')." ADD `hx_time` VARCHAR(20) NOT NULL;");
  1662. }
  1663. if (!pdo_fieldexists(tablename('zhtc_coupons'), 'del')) {
  1664. pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `del` INT(11) NOT NULL DEFAULT '2';");
  1665. }
  1666. if (!pdo_fieldexists(tablename('zhtc_system'), 'kp_img')) {
  1667. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `kp_img` VARCHAR(500) NOT NULL;");
  1668. }
  1669. if (!pdo_fieldexists(tablename('zhtc_system'), 'kp_time')) {
  1670. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `kp_time` INT(11) NOT NULL DEFAULT '3';");
  1671. }
  1672. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hd')) {
  1673. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hd` INT(11) NOT NULL DEFAULT '2';");
  1674. }
  1675. if (!pdo_fieldexists(tablename('zhtc_store'), 'is_rm')) {
  1676. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `is_rm` INT(11) NOT NULL DEFAULT '2';");
  1677. }
  1678. if (!pdo_fieldexists(tablename('zhtc_system'), 'sj_max2')) {
  1679. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sj_max2` INT(11) NOT NULL;");
  1680. }
  1681. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pcqx')) {
  1682. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pcqx` INT(11) NOT NULL DEFAULT '1';");
  1683. }
  1684. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hyqx')) {
  1685. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hyqx` INT(11) NOT NULL DEFAULT '1';");
  1686. }
  1687. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_yhqqx')) {
  1688. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_yhqqx` INT(11) NOT NULL DEFAULT '1';");
  1689. }
  1690. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_syqx')) {
  1691. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_syqx` INT(11) NOT NULL DEFAULT '1';");
  1692. }
  1693. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hdqx')) {
  1694. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hdqx` INT(11) NOT NULL DEFAULT '1';");
  1695. }
  1696. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hbqx')) {
  1697. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hbqx` INT(11) NOT NULL DEFAULT '1';");
  1698. }
  1699. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_hhrqx')) {
  1700. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_hhrqx` INT(11) NOT NULL DEFAULT '1';");
  1701. }
  1702. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_dcsqx')) {
  1703. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_dcsqx` INT(11) NOT NULL DEFAULT '1';");
  1704. }
  1705. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_jfqx')) {
  1706. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_jfqx` INT(11) NOT NULL DEFAULT '1';");
  1707. }
  1708. if (!pdo_fieldexists(tablename('zhtc_distribution'), 'is_log')) {
  1709. pdo_query("ALTER TABLE".tablename('zhtc_distribution')." ADD `is_log` INT(11) NOT NULL DEFAULT '1';");
  1710. }
  1711. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_spqx')) {
  1712. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_spqx` INT(11) NOT NULL DEFAULT '1';");
  1713. }
  1714. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_sp')) {
  1715. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_sp` INT(11) NOT NULL DEFAULT '1';");
  1716. }
  1717. if (!pdo_fieldexists(tablename('zhtc_system'), 'sygg_name')) {
  1718. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sygg_name` VARCHAR(20) NOT NULL DEFAULT '同城头条';");
  1719. }
  1720. if (!pdo_fieldexists(tablename('zhtc_system'), 'sjgg_name')) {
  1721. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `sjgg_name` VARCHAR(20) NOT NULL DEFAULT '信息头条';");
  1722. }
  1723. if (!pdo_fieldexists(tablename('zhtc_system'), 'flgg_name')) {
  1724. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `flgg_name` VARCHAR(20) NOT NULL DEFAULT '商家快报';");
  1725. }
  1726. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_zf')) {
  1727. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_zf` INT(11) NOT NULL DEFAULT '1';");
  1728. }
  1729. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_yhqsh')) {
  1730. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_yhqsh` INT(11) NOT NULL DEFAULT '1';");
  1731. }
  1732. if (!pdo_fieldexists(tablename('zhtc_system'), 'hb_name')) {
  1733. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hb_name` VARCHAR(20) NOT NULL DEFAULT '红包';");
  1734. }
  1735. if (!pdo_fieldexists(tablename('zhtc_system'), 'fl_name')) {
  1736. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `fl_name` VARCHAR(20) NOT NULL DEFAULT '福利';");
  1737. }
  1738. if (!pdo_fieldexists(tablename('zhtc_account'), 'authority')) {
  1739. pdo_query("ALTER TABLE".tablename('zhtc_account')." ADD `authority` TEXT NOT NULL;");
  1740. }
  1741. if (!pdo_fieldexists(tablename('zhtc_sms'), 'fh_tid')) {
  1742. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `fh_tid` VARCHAR(200) NOT NULL;");
  1743. }
  1744. if (!pdo_fieldexists(tablename('zhtc_sms'), 'gm_tid')) {
  1745. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `gm_tid` VARCHAR(200) NOT NULL;");
  1746. }
  1747. if (!pdo_fieldexists(tablename('zhtc_sms'), 'hp_tid')) {
  1748. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `hp_tid` VARCHAR(200) NOT NULL;");
  1749. }
  1750. if (!pdo_fieldexists(tablename('zhtc_sms'), 'dz_tid')) {
  1751. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `dz_tid` VARCHAR(200) NOT NULL;");
  1752. }
  1753. if (!pdo_fieldexists(tablename('zhtc_sms'), 'tg_tid')) {
  1754. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `tg_tid` VARCHAR(200) NOT NULL;");
  1755. }
  1756. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pzsj')) {
  1757. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pzsj` INT(11) NOT NULL DEFAULT '1';");
  1758. }
  1759. if (!pdo_fieldexists(tablename('zhtc_sms'), 'qf_tid')) {
  1760. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `qf_tid` VARCHAR(200) NOT NULL;");
  1761. }
  1762. if (!pdo_fieldexists(tablename('zhtc_system'), 'ggoods_set')) {
  1763. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `ggoods_set` INT(4) NOT NULL DEFAULT '1';");
  1764. }
  1765. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_xsqg')) {
  1766. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_xsqg` INT(4) NOT NULL DEFAULT '2';");
  1767. }
  1768. if (!pdo_fieldexists(tablename('zhtc_system'), 'xgsh')) {
  1769. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `xgsh` INT(4) NOT NULL DEFAULT '1';");
  1770. }
  1771. if (!pdo_fieldexists(tablename('zhtc_qggoods'), 'content')) {
  1772. pdo_query("ALTER TABLE".tablename('zhtc_qggoods')." ADD `content` VARCHAR(100) NOT NULL");
  1773. }
  1774. if (!pdo_fieldexists(tablename('zhtc_qggoods'), 'details_img')) {
  1775. pdo_query("ALTER TABLE".tablename('zhtc_qggoods')." ADD `details_img` TEXT NOT NULL");
  1776. }
  1777. if (!pdo_fieldexists(tablename('zhtc_qgtype'), 'state')) {
  1778. pdo_query("ALTER TABLE".tablename('zhtc_qgtype')." ADD `state` INT(4) NOT NULL DEFAULT '1'");
  1779. }
  1780. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_qgqx')) {
  1781. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_qgqx` INT(4) NOT NULL DEFAULT '1'");
  1782. }
  1783. if (!pdo_fieldexists(tablename('zhtc_comments'), 'bid')) {
  1784. pdo_query("ALTER TABLE".tablename('zhtc_comments')." ADD `bid` INT(11) NOT NULL");
  1785. }
  1786. if (!pdo_fieldexists(tablename('zhtc_comments'), 'hf_id')) {
  1787. pdo_query("ALTER TABLE".tablename('zhtc_comments')." ADD `hf_id` INT(11) NOT NULL");
  1788. }
  1789. if (!pdo_fieldexists(tablename('zhtc_qgtype'), 'img')) {
  1790. pdo_query("ALTER TABLE".tablename('zhtc_qgtype')." ADD `img` VARCHAR(500) NOT NULL");
  1791. }
  1792. if (!pdo_fieldexists(tablename('zhtc_system'), 'g_open')) {
  1793. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `g_open` INT(4) NOT NULL DEFAULT '2';");
  1794. }
  1795. if (!pdo_fieldexists(tablename('zhtc_system'), 'g_qx')) {
  1796. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `g_qx` INT(4) NOT NULL DEFAULT '1';");
  1797. }
  1798. if (!pdo_fieldexists(tablename('zhtc_qggoods'), 'time')) {
  1799. pdo_query("ALTER TABLE".tablename('zhtc_qggoods')." ADD `time` VARCHAR(20) NOT NULL");
  1800. }
  1801. if (!pdo_fieldexists(tablename('zhtc_account'), 'city_qx')) {
  1802. pdo_query("ALTER TABLE".tablename('zhtc_account')." ADD `city_qx` text NOT NULL");
  1803. }
  1804. if (!pdo_fieldexists(tablename('zhtc_system'), 'fx_jf')) {
  1805. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `fx_jf` int NOT NULL");
  1806. }
  1807. if (!pdo_fieldexists(tablename('zhtc_integral'), 'tid')) {
  1808. pdo_query("ALTER TABLE".tablename('zhtc_integral')." ADD `tid` int NOT NULL");
  1809. }
  1810. if (!pdo_fieldexists(tablename('zhtc_system'), 'good_jf')) {
  1811. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `good_jf` int NOT NULL");
  1812. }
  1813. if (!pdo_fieldexists(tablename('zhtc_zx'), 'video')) {
  1814. pdo_query("ALTER TABLE".tablename('zhtc_zx')." ADD `video` VARCHAR(300) NOT NULL");
  1815. }
  1816. if (!pdo_fieldexists(tablename('zhtc_acttype'), 'img')) {
  1817. pdo_query("ALTER TABLE".tablename('zhtc_acttype')." ADD `img` VARCHAR(500) NOT NULL");
  1818. }
  1819. if (!pdo_fieldexists(tablename('zhtc_coupons'), 'type_id')) {
  1820. pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `type_id` INT(11) NOT NULL DEFAULT '1'");
  1821. }
  1822. if (!pdo_fieldexists(tablename('zhtc_coupons'), 'is_pt')) {
  1823. pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `is_pt` INT(11) NOT NULL DEFAULT '1'");
  1824. }
  1825. if (!pdo_fieldexists(tablename('zhtc_store'), 'video')) {
  1826. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `video` VARCHAR(300) NOT NULL");
  1827. }
  1828. if (!pdo_fieldexists(tablename('zhtc_qggoods'), 'cityname')) {
  1829. pdo_query("ALTER TABLE".tablename('zhtc_qggoods')." ADD `cityname` VARCHAR(20) NOT NULL");
  1830. }
  1831. if (!pdo_fieldexists(tablename('zhtc_groupgoods'), 'cityname')) {
  1832. pdo_query("ALTER TABLE".tablename('zhtc_groupgoods')." ADD `cityname` VARCHAR(30) NOT NULL");
  1833. }
  1834. if (!pdo_fieldexists(tablename('zhtc_coupons'), 'cityname')) {
  1835. pdo_query("ALTER TABLE".tablename('zhtc_coupons')." ADD `cityname` VARCHAR(30) NOT NULL");
  1836. }
  1837. if (!pdo_fieldexists(tablename('zhtc_sms'), 'qg_tid')) {
  1838. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `qg_tid` VARCHAR(200) NOT NULL");
  1839. }
  1840. if (!pdo_fieldexists(tablename('zhtc_sms'), 'hd_tid')) {
  1841. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `hd_tid` VARCHAR(200) NOT NULL");
  1842. }
  1843. if (!pdo_fieldexists(tablename('zhtc_sms'), 'pt_tid')) {
  1844. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `pt_tid` VARCHAR(200) NOT NULL");
  1845. }
  1846. if (!pdo_fieldexists(tablename('zhtc_sms'), 'kq_tid')) {
  1847. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `kq_tid` VARCHAR(200) NOT NULL");
  1848. }
  1849. if (!pdo_fieldexists(tablename('zhtc_goods'), 'vr')) {
  1850. pdo_query("ALTER TABLE".tablename('zhtc_goods')." ADD `vr` VARCHAR(500) NOT NULL");
  1851. }
  1852. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_city')) {
  1853. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_city` INT(11) NOT NULL DEFAULT '1'");
  1854. }
  1855. if (!pdo_fieldexists(tablename('zhtc_system'), 'hy_title')) {
  1856. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `hy_title` VARCHAR(20) NOT NULL DEFAULT '黄页114'");
  1857. }
  1858. if (!pdo_fieldexists(tablename('zhtc_system'), 'kp_url')) {
  1859. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `kp_url` VARCHAR(300) NOT NULL");
  1860. }
  1861. if (!pdo_fieldexists(tablename('zhtc_information'), 'is_jt')) {
  1862. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `is_jt` INT(4) NOT NULL DEFAULT '2'");
  1863. }
  1864. if (!pdo_fieldexists(tablename('zhtc_yellowstore'), 'is_delete')) {
  1865. pdo_query("ALTER TABLE".tablename('zhtc_yellowstore')." ADD `is_delete` INT(4) NOT NULL DEFAULT '2'");
  1866. }
  1867. if (!pdo_fieldexists(tablename('zhtc_car'), 'is_delete')) {
  1868. pdo_query("ALTER TABLE".tablename('zhtc_car')." ADD `is_delete` INT(4) NOT NULL DEFAULT '2'");
  1869. }
  1870. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_message')) {
  1871. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_message` INT(4) NOT NULL DEFAULT '1'");
  1872. }
  1873. if (!pdo_fieldexists(tablename('zhtc_type'), 'tel_money')) {
  1874. pdo_query("ALTER TABLE".tablename('zhtc_type')." ADD `tel_money` DECIMAL(10,2) NOT NULL");
  1875. }
  1876. if (!pdo_fieldexists(tablename('zhtc_type2'), 'tel_money')) {
  1877. pdo_query("ALTER TABLE".tablename('zhtc_type2')." ADD `tel_money` DECIMAL(10,2) NOT NULL");
  1878. }
  1879. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_bdtel')) {
  1880. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_bdtel` INT(4) NOT NULL DEFAULT '1'");
  1881. }
  1882. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_ff')) {
  1883. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_ff` INT(4) NOT NULL DEFAULT '2'");
  1884. }
  1885. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_pgzf')) {
  1886. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_pgzf` INT(4) NOT NULL DEFAULT '2'");
  1887. }
  1888. if (!pdo_fieldexists(tablename('zhtc_system'), 'is_video')) {
  1889. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `is_video` INT(4) NOT NULL DEFAULT '1'");
  1890. }
  1891. if (!pdo_fieldexists(tablename('zhtc_information'), 'lat')) {
  1892. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `lat` VARCHAR(20) NOT NULL");
  1893. }
  1894. if (!pdo_fieldexists(tablename('zhtc_information'), 'lng')) {
  1895. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `lng` VARCHAR(20) NOT NULL");
  1896. }
  1897. if (!pdo_fieldexists(tablename('zhtc_system'), 'fj_tz')) {
  1898. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `fj_tz` INT(4) NOT NULL DEFAULT '2'");
  1899. }
  1900. if (!pdo_fieldexists(tablename('zhtc_system'), 'cz_password')) {
  1901. pdo_query("ALTER TABLE".tablename('zhtc_system')." ADD `cz_password` VARCHAR(20) NOT NULL");
  1902. }
  1903. if (!pdo_fieldexists(tablename('zhtc_information'), 'code')) {
  1904. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD `code` VARCHAR( 50 ) NOT NULL");
  1905. }
  1906. if (!pdo_fieldexists(tablename('zhtc_sms'), 'aliyun_appkey')) {
  1907. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `aliyun_appkey` VARCHAR( 20 ) NOT NULL");
  1908. }
  1909. if (!pdo_fieldexists(tablename('zhtc_sms'), 'aliyun_appsecret')) {
  1910. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `aliyun_appsecret` VARCHAR( 50 ) NOT NULL");
  1911. }
  1912. if (!pdo_fieldexists(tablename('zhtc_sms'), 'aliyun_sign')) {
  1913. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `aliyun_sign` VARCHAR( 20 ) NOT NULL");
  1914. }
  1915. if (!pdo_fieldexists(tablename('zhtc_sms'), 'item')) {
  1916. pdo_query("ALTER TABLE".tablename('zhtc_sms')." ADD `item` INT(4) NOT NULL DEFAULT '1'");
  1917. }
  1918. if (!pdo_fieldexists(tablename('zhtc_store'), 'is_shop')) {
  1919. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD `is_shop` INT(1) NOT NULL DEFAULT '1'");
  1920. }
  1921. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `uniacid` );");
  1922. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `user_id` );");
  1923. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `type2_id` );");
  1924. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `type_id` );");
  1925. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `state` );");
  1926. pdo_query("ALTER TABLE".tablename('zhtc_information')." ADD INDEX ( `store_id` );");
  1927. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `uniacid` );");
  1928. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `user_id` );");
  1929. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `storetype2_id` );");
  1930. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `storetype_id` );");
  1931. pdo_query("ALTER TABLE".tablename('zhtc_store')." ADD INDEX ( `state` );");
  1932. pdo_query("ALTER TABLE".tablename('zhtc_sms')." CHANGE `tpl_id` `tpl_id` VARCHAR(20) NOT NULL;");
  1933. pdo_query("ALTER TABLE".tablename('zhtc_sms')." CHANGE `tpl2_id` `tpl2_id` VARCHAR(20) NOT NULL;");
  1934. ?>