install/install.json
（完整代码） 124KB
{"sky_ad":"CREATE TABLE `sky_ad` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `tag_id` int(11) NOT NULL DEFAULT '0',\n `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `info` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7b80\u4ecb',\n `link1` varchar(400) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94fe\u63a51',\n `link2` varchar(400) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94fe\u63a52',\n `starttime` int(11) NOT NULL DEFAULT '0' COMMENT '\u5f00\u59cb\u65f6\u95f4',\n `endtime` int(11) NOT NULL DEFAULT '0' COMMENT '\u7ed3\u675f\u65f6\u95f4',\n `imgurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u56fe\u7247\u5730\u5740',\n `imgurl2` varchar(225) CHARACTER SET utf8 DEFAULT NULL COMMENT '\u56fe\u50cf2',\n `orderindex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u6392\u5e8f',\n `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001',\n `dateline` int(11) NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `price` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '\u4ef7\u683c',\n `object_id` int(11) NOT NULL DEFAULT '0' COMMENT '\u5177\u4f53\u5bf9\u8c61id',\n `tag_id_2nd` int(11) NOT NULL DEFAULT '0',\n `checkbox_attr` varchar(225) CHARACTER SET utf8 NOT NULL,\n PRIMARY KEY (`id`),\n KEY `tag_id` (`tag_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4","sky_ad_tags":"CREATE TABLE `sky_ad_tags` (\n `tag_id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `orderindex` tinyint(4) NOT NULL DEFAULT '0',\n `pid` int(11) NOT NULL DEFAULT '0',\n `status` tinyint(4) NOT NULL DEFAULT '1',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `m` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT 'index',\n `a` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT 'default',\n `width` smallint(6) NOT NULL DEFAULT '0',\n `height` smallint(6) NOT NULL DEFAULT '0',\n `tagno` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n PRIMARY KEY (`tag_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4","sky_admin":"CREATE TABLE `sky_admin` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `username` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7528\u6237\u540d',\n `password` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5bc6\u7801',\n `salt` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '\u968f\u673a\u5bc6\u7801\u4e32',\n `group_id` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u7528\u6237\u7ec4',\n `isfounder` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u521b\u5efa\u4eba',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='\u7ba1\u7406\u5458'","sky_admin_group":"CREATE TABLE `sky_admin_group` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `orderindex` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '\u6392\u5e8f',\n `content` text CHARACTER SET utf8 NOT NULL COMMENT '\u6743\u9650\u5185\u5bb9',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4","sky_apppush":"CREATE TABLE `sky_apppush` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `token` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `clientid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `appname` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `appkey` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `userid` int(11) NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `shopadmin` int(11) NOT NULL,\n `openid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='app\u63a8\u9001'","sky_apppush_plan":"CREATE TABLE `sky_apppush_plan` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `pid` int(11) NOT NULL DEFAULT '0',\n `typeid` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u63a8\u9001\u65b9\u5f0f',\n `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 0\u672a\u63a8\u9001 1\u5df2\u63a8\u9001',\n `content` text CHARACTER SET utf8 COMMENT '\u5185\u5bb9',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `issuccess` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u6210\u529f',\n `errmsg` varchar(255) CHARACTER SET utf8 DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `dateline` (`dateline`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u63a8\u9001\u8ba1\u5212'","sky_article":"CREATE TABLE `sky_article` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6807\u9898',\n `catid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5206\u7c7b',\n `catid_top` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e00\u7ea7\u5206\u7c7b',\n `catid_2nd` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e8c\u7ea7\u5206\u7c7b',\n `love_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '\u559c\u6b22\u6570',\n `fav_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '\u6536\u85cf\u6570',\n `description` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001 2\u663e\u793a \u5176\u4ed6\u9690\u85cf',\n `is_recommend` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u63a8\u8350 1\u63a8\u8350 ',\n `imgurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u56fe\u7247',\n `createtime` datetime NOT NULL DEFAULT '2018-09-10 09:01:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `comment_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u8bc4\u8bba\u6570',\n `tpl` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `author` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `isnew` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u65b0',\n `ishot` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u70ed',\n `view_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u8bbf\u95ee\u6570',\n `price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u4ea7\u54c1\u4ef7\u683c',\n `market_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u5e02\u573a\u4ef7\u683c',\n `total_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5e93\u5b58\u6570',\n `sold_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u9500\u552e\u6570',\n `grade` int(10) unsigned NOT NULL DEFAULT '0',\n `downurl` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u4e0b\u8f7d\u5730\u5740',\n `downsize` decimal(9,2) unsigned NOT NULL DEFAULT '0.00',\n `orderindex` int(10) unsigned NOT NULL DEFAULT '999',\n `videourl` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `isindex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u9996\u9875',\n `tags` varchar(128) CHARACTER SET utf8 NOT NULL DEFAULT '\u6807\u7b7e',\n `imgsdata` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u56fe\u96c6',\n PRIMARY KEY (`id`),\n KEY `catid` (`catid`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_article_comment":"CREATE TABLE `sky_article_comment` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `objectid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u6587\u7ae0',\n `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7\u8bc4\u8bba',\n `createtime` datetime NOT NULL DEFAULT '2018-07-02 18:52:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `content` text CHARACTER SET utf8 COMMENT '\u5185\u5bb9',\n `ip` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ip',\n `ip_city` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6240\u5728\u57ce\u5e02',\n `love_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u70b9\u8d5e\u6570',\n `imgsdata` text CHARACTER SET utf8 COMMENT '\u56fe\u96c6',\n PRIMARY KEY (`id`),\n KEY `objectid` (`objectid`,`status`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_article_data":"CREATE TABLE `sky_article_data` (\n `id` bigint(20) NOT NULL,\n `content` mediumtext CHARACTER SET utf8 NOT NULL,\n `createtime` datetime NOT NULL DEFAULT '2018-09-10 09:01:01',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_attach":"CREATE TABLE `sky_attach` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u4f20\u7528\u6237',\n `file_name` varchar(64) NOT NULL DEFAULT '' COMMENT '\u6587\u4ef6\u540d\u79f0',\n `file_url` varchar(225) NOT NULL DEFAULT '' COMMENT '\u6587\u4ef6\u5730\u5740',\n `file_size` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '\u6587\u4ef6\u5927\u5c0f',\n `file_type` varchar(12) NOT NULL DEFAULT '' COMMENT '\u6587\u4ef6\u540e\u7f00\u7c7b\u578b',\n `file_group` varchar(12) NOT NULL DEFAULT '' COMMENT '\u6587\u4ef6\u5f52\u7c7b\u540d\u79f0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC","sky_badip":"CREATE TABLE `sky_badip` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `ip` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ip',\n `createtime` datetime NOT NULL DEFAULT '2018-11-18 18:56:01',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='ip\u9ed1\u540d\u5355'","sky_badphone":"CREATE TABLE `sky_badphone` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `telephone` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u624b\u673a\u53f7',\n `createtime` datetime NOT NULL DEFAULT '2018-11-18 18:56:01',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u624b\u673a\u9ed1\u540d\u5355'","sky_bankcard":"CREATE TABLE `sky_bankcard` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `yhk_name` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u540d\u79f0',\n `yhk_haoma` varchar(24) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u5361\u53f7\u7801',\n `yhk_huming` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u5361\u6237\u540d',\n `telephone` varchar(18) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7535\u8bdd',\n `yhk_address` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5f00\u6237\u5730\u5740',\n `paytype` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u65b9\u5f0f \u652f\u4ed8\u5b9d \u94f6\u884c\u5361 \u5fae\u4fe1 ',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='\u94f6\u884c\u8d26\u53f7'","sky_blacklist":"CREATE TABLE `sky_blacklist` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `dateline` int(11) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='\u9ed1\u540d\u5355'","sky_blacklist_post":"CREATE TABLE `sky_blacklist_post` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `siteid` int(11) unsigned NOT NULL DEFAULT '0',\n `dateline` int(11) unsigned NOT NULL DEFAULT '0',\n `etime` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='\u7981\u8a00'","sky_category":"CREATE TABLE `sky_category` (\n `catid` int(11) NOT NULL AUTO_INCREMENT,\n `tablename` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8868\u540d',\n `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7\u5206\u7c7b',\n `cname` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `orderindex` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '\u6392\u5e8f',\n `type_id` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u7c7b\u578b',\n `cat_tpl` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u680f\u76ee\u6a21\u677f',\n `list_tpl` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5217\u8868\u6a21\u677f',\n `show_tpl` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8be6\u60c5\u6a21\u677f',\n `title` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6807\u9898',\n `keywords` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5173\u952e\u5b57',\n `description` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001 ',\n `level` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u5c42\u7ea7',\n `topic_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e3b\u9898\u6570',\n `comment_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u8bc4\u8bba\u6570',\n `last_post` text CHARACTER SET utf8 NOT NULL COMMENT '\u6700\u540e\u53d1\u5e03',\n `logo` varchar(225) CHARACTER SET utf8 DEFAULT '\/static\/images\/category_logo.jpg' COMMENT 'logo',\n PRIMARY KEY (`catid`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='\u5206\u7c7b'","sky_checkin":"CREATE TABLE `sky_checkin` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `siteid` int(11) NOT NULL DEFAULT '1',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `day` int(11) NOT NULL DEFAULT '0',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `mood` tinyint(4) NOT NULL DEFAULT '1',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `type_id` int(11) NOT NULL DEFAULT '0',\n `ip` varchar(32) CHARACTER SET utf8 NOT NULL,\n PRIMARY KEY (`id`),\n KEY `t_u_day` (`type_id`,`userid`,`day`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_checkin_index":"CREATE TABLE `sky_checkin_index` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `type_id` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '\u7b7e\u5230\u7c7b\u578b 1\u5708\u5b50\u7b7e\u5230',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237id',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u65f6\u95f4',\n `grade` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u79ef\u5206 \u8fde\u7eed\u7b7e\u5230\u51e0\u6b21',\n `last_day` int(11) NOT NULL DEFAULT '0',\n `last_ip` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7b7e\u5230ip',\n `all_times` mediumint(8) unsigned NOT NULL DEFAULT '1' COMMENT '\u7b7e\u5230\u603b\u6b21\u6570',\n `is_valid` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1\u6709\u6548 2\u65e0\u6548',\n `gold` int(11) NOT NULL DEFAULT '1' COMMENT '\u91d1\u5e01',\n `days` int(11) NOT NULL DEFAULT '1' COMMENT '\u8fde\u7eed\u7b7e\u5230\u6b21\u6570',\n `siteid` int(11) NOT NULL DEFAULT '1' COMMENT '\u5206\u7ad9id',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`,`type_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_city":"CREATE TABLE `sky_city` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `name` varchar(32) NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `lat` decimal(9,6) NOT NULL DEFAULT '0.000000' COMMENT '\u7eac\u5ea6',\n `lng` decimal(9,6) NOT NULL DEFAULT '0.000000' COMMENT '\u7ecf\u5ea6',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `isrecommend` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_config":"CREATE TABLE `sky_config` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `siteid` int(11) NOT NULL DEFAULT '1',\n `phone_on` tinyint(4) NOT NULL DEFAULT '0',\n `phone_reg` tinyint(4) NOT NULL DEFAULT '0',\n `phone_user` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `phone_pwd` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `phone_num` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `smtphost` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `smtpport` smallint(6) NOT NULL DEFAULT '0',\n `smtpemail` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `smtpuser` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `smtppwd` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `water_on` tinyint(4) NOT NULL DEFAULT '0',\n `water_type` tinyint(4) NOT NULL DEFAULT '0',\n `water_pos` tinyint(4) NOT NULL DEFAULT '0',\n `water_str` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `water_img` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `water_size` tinyint(4) NOT NULL DEFAULT '0',\n `rewrite_on` tinyint(4) NOT NULL DEFAULT '0',\n `spread_on` tinyint(4) NOT NULL DEFAULT '0',\n `spread_discount` tinyint(4) NOT NULL DEFAULT '0',\n `spread_money` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `spread_type` tinyint(4) unsigned NOT NULL DEFAULT '0',\n `grade_on` tinyint(4) NOT NULL DEFAULT '0',\n `opentime` tinyint(4) NOT NULL DEFAULT '0',\n `starthour` tinyint(4) NOT NULL DEFAULT '0',\n `endhour` tinyint(4) NOT NULL DEFAULT '0',\n `startminute` tinyint(4) NOT NULL DEFAULT '0',\n `endminute` tinyint(4) NOT NULL DEFAULT '0',\n `showweek` tinyint(4) NOT NULL DEFAULT '0',\n `minprice` decimal(8,1) NOT NULL DEFAULT '0.0',\n `alipay` tinyint(4) NOT NULL DEFAULT '0',\n `wxpay` tinyint(4) NOT NULL DEFAULT '0',\n `tenpay` tinyint(4) NOT NULL DEFAULT '0',\n `rewrite_type` varchar(25) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `bdmapkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `comment_status_check` tinyint(4) NOT NULL DEFAULT '0',\n `activity_topic_status_check` tinyint(4) NOT NULL DEFAULT '0',\n `ob_gzip` tinyint(4) NOT NULL DEFAULT '0',\n `express_fee` smallint(6) NOT NULL DEFAULT '0',\n `express_fee_add` smallint(6) NOT NULL DEFAULT '0',\n `order_unpay` tinyint(4) NOT NULL DEFAULT '0',\n `hotsearch` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `kf_qq` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `kf_ww` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `order_first_discount` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT '\u9996\u6b21\u6298\u6263',\n `order_first_money` decimal(7,2) NOT NULL DEFAULT '10000.00' COMMENT '\u9996\u6b21\u6ee1\u591a\u5c11\u51cf\u591a\u5c11',\n `moneypay` tinyint(4) NOT NULL DEFAULT '0',\n `fenqi` tinyint(1) NOT NULL DEFAULT '0',\n `fenqi_lilv` decimal(7,2) NOT NULL DEFAULT '0.01' COMMENT '\u5206\u671f\u5229\u7387',\n `shoplistshow` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u5e97\u94fa\u5217\u8868\u5c55\u793a',\n `has_printer` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u5f00\u542f\u6253\u5370\u673a',\n `rurl301` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '301\u8df3\u8f6c',\n `bdmapkey_php` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u767e\u5ea6\u5730\u56fe\u670d\u52a1\u7aef',\n `sms_qianming` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u77ed\u4fe1\u7b7e\u540d',\n `sms_type` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u77ed\u4fe1\u7c7b\u578b',\n `reg_invitecode` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u9080\u8bf7\u7801',\n `s_bank_name` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `s_bank_user` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `s_bank_num` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `skinscolor` varchar(8) NOT NULL DEFAULT '',\n `skins_fttype` varchar(12) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4","sky_coupon":"CREATE TABLE `sky_coupon` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `money` decimal(9,1) NOT NULL DEFAULT '0.0' COMMENT '\u4ef7\u683c',\n `amount` int(11) NOT NULL DEFAULT '0' COMMENT '\u6570\u91cf',\n `etime` datetime NOT NULL DEFAULT '2019-12-13 01:02:03' COMMENT '\u622a\u6b62\u65e5\u671f',\n `dateline` int(11) NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `get_num` smallint(6) DEFAULT '0' COMMENT '\u9886\u53d6\u4eba\u6570',\n `use_num` smallint(6) DEFAULT '0' COMMENT '\u4f7f\u7528\u4eba\u6570',\n `lower_money` decimal(9,1) DEFAULT '0.0' COMMENT '\u6700\u4f4e\u4f7f\u7528\u4ef7\u683c',\n `imgurl` varchar(255) CHARACTER SET utf8 DEFAULT NULL,\n `limit_num` int(11) NOT NULL DEFAULT '0' COMMENT '\u9650\u5236\u9886\u53d6\u6570',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_coupon_user":"CREATE TABLE `sky_coupon_user` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `coupon_id` int(11) NOT NULL DEFAULT '0' COMMENT '\u4f18\u60e0\u5238',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `dateline` int(11) NOT NULL DEFAULT '0' COMMENT '\u9886\u53d6\u65f6\u95f4',\n `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u4f7f\u7528\u72b6\u6001',\n `notice_time` int(11) NOT NULL DEFAULT '0' COMMENT '\u4e0a\u6b21\u901a\u77e5',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_crontab":"CREATE TABLE `sky_crontab` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `url` varchar(225) NOT NULL DEFAULT '' COMMENT '\u4efb\u52a1\u5730\u5740',\n `crontime` varchar(64) NOT NULL DEFAULT '' COMMENT '\u6267\u884c\u65f6\u95f4',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_dataapi":"CREATE TABLE `sky_dataapi` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(40) CHARACTER SET utf8 NOT NULL,\n `word` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `type_id` tinyint(4) NOT NULL DEFAULT '0',\n `equation` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `info` text CHARACTER SET utf8 NOT NULL,\n `content` mediumtext CHARACTER SET utf8 NOT NULL,\n `status` tinyint(4) NOT NULL DEFAULT '1',\n PRIMARY KEY (`id`),\n KEY `word` (`word`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_daysn":"CREATE TABLE `sky_daysn` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `bday` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `tablename` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `daySn` int(10) unsigned NOT NULL DEFAULT '1',\n PRIMARY KEY (`id`),\n KEY `shopid_bday` (`shopid`,`bday`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4","sky_dbcache":"CREATE TABLE `sky_dbcache` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `k` varchar(225) CHARACTER SET utf8 NOT NULL,\n `v` mediumtext CHARACTER SET utf8 NOT NULL,\n `expire` int(11) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `k` (`k`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_dbsession":"CREATE TABLE `sky_dbsession` (\n `id` char(100) CHARACTER SET utf8 NOT NULL,\n `data` text CHARACTER SET utf8 NOT NULL,\n `dateline` int(10) unsigned NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_district":"CREATE TABLE `sky_district` (\n `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `level` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u5c42\u7ea7',\n `usetype` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `upid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7',\n `displayorder` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '\u6392\u5e8f',\n PRIMARY KEY (`id`),\n KEY `upid` (`upid`,`displayorder`)\n) ENGINE=InnoDB AUTO_INCREMENT=45052 DEFAULT CHARSET=utf8mb4","sky_express_fee":"CREATE TABLE `sky_express_fee` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '0',\n `fmoney` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u9996\u91cd',\n `amoney` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u52a0\u91cd',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u5feb\u9012\u8d39\u8bbe\u7f6e'","sky_express_fee_city":"CREATE TABLE `sky_express_fee_city` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7',\n `areaid` int(11) NOT NULL DEFAULT '0' COMMENT '\u533a\u57df',\n PRIMARY KEY (`id`),\n KEY `areaid` (`areaid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u5feb\u9012\u8d39\u8bbe\u7f6e\u533a\u57df'","sky_fav":"CREATE TABLE `sky_fav` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `tablename` varchar(24) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8868\u540d',\n `objectid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6536\u85cf\u5bf9\u8c61',\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6536\u85cf\u7528\u6237',\n PRIMARY KEY (`id`),\n KEY `t_o` (`tablename`,`objectid`,`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_follow":"CREATE TABLE `sky_follow` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `t_userid` int(11) NOT NULL DEFAULT '0' COMMENT '\u88ab\u5173\u6ce8\u7684\u7528\u6237',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001',\n `dateline` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n PRIMARY KEY (`id`),\n KEY `uid` (`userid`,`t_userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_followed":"CREATE TABLE `sky_followed` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237\u8868',\n `t_userid` int(11) NOT NULL DEFAULT '0' COMMENT '\u88ab\u5173\u6ce8\u7528\u6237\u8868',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001',\n `dateline` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n PRIMARY KEY (`id`),\n KEY `uid` (`userid`,`t_userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_friend":"CREATE TABLE `sky_friend` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `touserid` int(10) unsigned NOT NULL DEFAULT '0',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `uu` (`userid`,`touserid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u670b\u53cb'","sky_friend_apply":"CREATE TABLE `sky_friend_apply` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `touserid` int(11) NOT NULL DEFAULT '0',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `description` varchar(64) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `uu` (`userid`,`touserid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u7533\u8bf7\u4ea4\u670b\u53cb'","sky_gold_log":"CREATE TABLE `sky_gold_log` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `dateline` int(11) NOT NULL DEFAULT '0',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `type_id` int(11) NOT NULL DEFAULT '0',\n `ispay` tinyint(4) NOT NULL DEFAULT '1',\n `content` text CHARACTER SET utf8 COMMENT '\u63cf\u8ff0',\n `isdelete` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u5220\u9664',\n `money` decimal(9,1) NOT NULL DEFAULT '0.0' COMMENT '\u91d1\u5e01',\n PRIMARY KEY (`id`),\n KEY `u_d` (`userid`,`dateline`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4","sky_grade_log":"CREATE TABLE `sky_grade_log` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `dateline` int(11) NOT NULL DEFAULT '0',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `type_id` int(11) unsigned NOT NULL DEFAULT '0',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `isdelete` tinyint(4) unsigned NOT NULL DEFAULT '0',\n `grade` int(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_guest":"CREATE TABLE `sky_guest` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `type_id` int(11) NOT NULL DEFAULT '0',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `nickname` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `email` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `telephone` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `gender` tinyint(4) NOT NULL DEFAULT '1',\n `reply` varchar(225) CHARACTER SET utf8 NOT NULL,\n `isreply` tinyint(4) NOT NULL DEFAULT '0',\n `reply_time` int(11) NOT NULL DEFAULT '0',\n `money` decimal(9,1) NOT NULL DEFAULT '0.0',\n `address` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `qq` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `num` int(11) NOT NULL DEFAULT '0',\n `status` tinyint(4) NOT NULL DEFAULT '0',\n `content` mediumtext CHARACTER SET utf8 NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_imgs":"CREATE TABLE `sky_imgs` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `tablename` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8868\u540d',\n `object_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u5bf9\u8c61id',\n `imgurl` varchar(225) CHARACTER SET utf8 DEFAULT NULL COMMENT '\u56fe\u7247',\n `title` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6807\u9898',\n `orderindex` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u6392\u5e8f',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n PRIMARY KEY (`id`),\n KEY `tablename` (`tablename`,`object_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_invite":"CREATE TABLE `sky_invite` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u9080\u8bf7\u4eba',\n `in_userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u88ab\u9080\u8bf7\u4eba',\n `dateline` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u65f6\u95f4',\n `ispay` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u5956\u8d4f',\n `bstatus` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4","sky_invite_account":"CREATE TABLE `sky_invite_account` (\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `money` decimal(9,2) unsigned NOT NULL DEFAULT '0.00',\n `income` decimal(9,2) unsigned NOT NULL DEFAULT '0.00',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='\u9080\u8bf7\u6536\u5165'","sky_invite_account_log":"CREATE TABLE `sky_invite_account_log` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `cuserid` int(10) unsigned NOT NULL DEFAULT '0',\n `money` decimal(9,2) unsigned NOT NULL DEFAULT '0.00',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `content` varchar(225) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='\u9080\u8bf7\u6536\u5165'","sky_kefu_msg":"CREATE TABLE `sky_kefu_msg` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `createtime` datetime NOT NULL DEFAULT '2019-02-23 05:31:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `tablename` varchar(12) CHARACTER SET utf8 NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u54a8\u8be2\u7d22\u5f15'","sky_kefu_msgindex":"CREATE TABLE `sky_kefu_msgindex` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `createtime` datetime NOT NULL DEFAULT '2019-02-23 05:31:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `isreply` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `isread` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u54a8\u8be2\u7d22\u5f15'","sky_love":"CREATE TABLE `sky_love` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `tablename` varchar(24) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8868\u540d\u79f0',\n `objectid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6536\u85cf\u5bf9\u8c61',\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6536\u85cf\u7528\u6237',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`,`id`),\n KEY `t_o` (`tablename`,`objectid`,`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_maxid":"CREATE TABLE `sky_maxid` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `t` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4","sky_mod_flk_account":"CREATE TABLE `sky_mod_flk_account` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `money` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '\u53ef\u7528',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='\u8d26\u6237'","sky_mod_flk_account_log":"CREATE TABLE `sky_mod_flk_account_log` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `money` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `content` varchar(225) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='\u8d26\u6237\u65e5\u5fd7'","sky_mod_flk_admin":"CREATE TABLE `sky_mod_flk_admin` (\n `adminid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5e97\u94faid',\n `adminname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '\u7ba1\u7406\u5458',\n `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '\u5bc6\u7801',\n `salt` char(4) CHARACTER SET utf8 NOT NULL,\n `lasttime` datetime NOT NULL DEFAULT '2018-08-03 16:20:01' COMMENT '\u4e0a\u6b21\u767b\u5f55',\n `xlasttime` datetime NOT NULL DEFAULT '2018-08-03 16:20:01' COMMENT '\u4e0a\u4e0a\u6b21\u767b\u5f55',\n PRIMARY KEY (`adminid`),\n KEY `adminname` (`adminname`) \n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_article":"CREATE TABLE `sky_mod_flk_article` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6807\u9898',\n `shopid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u5546\u5bb6',\n `catid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5927\u7c7b',\n `shop_catid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u5546\u5bb6\u5206\u7c7b',\n `love_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '\u559c\u6b22\u6570',\n `fav_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '\u6536\u85cf\u6570',\n `forward_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '\u8f6c\u53d1\u6570',\n `description` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `createtime` datetime NOT NULL DEFAULT '2019-01-30 08:01:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `updatetime` datetime NOT NULL DEFAULT '2019-01-30 08:01:01' COMMENT '\u66f4\u65b0\u65f6\u95f4',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `comment_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u8bc4\u8bba\u6570\u91cf',\n `imgurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u56fe\u7247',\n `grade` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u79ef\u5206',\n `isrecommend` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u63a8\u8350',\n `view_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u67e5\u770b\u6570',\n `isnew` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u65b0 1\u662f 0\u5426',\n `ishot` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u70ed\u95e8 1\u662f 0\u5426',\n `author` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u4f5c\u8005',\n `videourl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u89c6\u9891\u5730\u5740',\n `price` decimal(10,0) unsigned NOT NULL DEFAULT '0' COMMENT '\u8d4f\u91d1',\n `site_isrecommend` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u7ad9\u70b9\u63a8\u8350',\n `site_isnew` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u7ad9\u70b9\u6700\u65b0',\n `imgsdata` text CHARACTER SET utf8,\n PRIMARY KEY (`id`),\n KEY `catid` (`catid`),\n KEY `shopid` (`shopid`,`shop_catid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5546\u5bb6\u6587\u7ae0'","sky_mod_flk_article_comment":"CREATE TABLE `sky_mod_flk_article_comment` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `objectid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u6587\u7ae0',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5546\u5bb6',\n `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7\u8bc4\u8bba',\n `createtime` datetime NOT NULL DEFAULT '2018-07-02 18:52:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `content` text CHARACTER SET utf8 COMMENT '\u5185\u5bb9',\n `ip` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ip',\n `ip_city` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6240\u5728\u57ce\u5e02',\n `love_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u70b9\u8d5e\u6570',\n `imgsdata` text CHARACTER SET utf8 COMMENT '\u56fe\u96c6',\n PRIMARY KEY (`id`),\n KEY `objectid` (`objectid`,`status`) ,\n KEY `userid` (`userid`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_article_data":"CREATE TABLE `sky_mod_flk_article_data` (\n `id` int(10) unsigned NOT NULL,\n `content` mediumtext CHARACTER SET utf8,\n `shopid` int(10) unsigned DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u4ea7\u54c1'","sky_mod_flk_bankcard":"CREATE TABLE `sky_mod_flk_bankcard` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `yhk_name` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u540d\u79f0',\n `yhk_haoma` varchar(24) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u5361\u53f7\u7801',\n `yhk_huming` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u5361\u6237\u540d',\n `telephone` varchar(18) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7535\u8bdd',\n `yhk_address` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5f00\u6237\u5730\u5740',\n `paytype` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u65b9\u5f0f \u652f\u4ed8\u5b9d \u94f6\u884c\u5361 \u5fae\u4fe1 ',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u94f6\u884c\u8d26\u53f7'","sky_mod_flk_cart":"CREATE TABLE `sky_mod_flk_cart` (\n `id` bigint(11) NOT NULL AUTO_INCREMENT,\n `productid` int(11) NOT NULL DEFAULT '0' COMMENT '\u5546\u54c1id',\n `createtime` datetime NOT NULL DEFAULT '2019-01-30 08:01:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237id',\n `amount` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u8ba2\u5355\u6570\u91cf',\n `ksid` int(11) NOT NULL DEFAULT '0' COMMENT '\u6b3e\u5f0f',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`) ,\n KEY `createtime` (`createtime`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_category":"CREATE TABLE `sky_mod_flk_category` (\n `catid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `pid` int(10) unsigned NOT NULL DEFAULT '0',\n `orderindex` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `imgurl` varchar(225) CHARACTER SET utf8 DEFAULT '',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `ex_table_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u6269\u5c55\u8868',\n PRIMARY KEY (`catid`)\n) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5206\u7c7b'","sky_mod_flk_cbd":"CREATE TABLE `sky_mod_flk_cbd` (\n `cbdid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7b80\u4ecb',\n `imgurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u56fe\u7247',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `orderindex` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`cbdid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5546\u5708'","sky_mod_flk_cbd_shop":"CREATE TABLE `sky_mod_flk_cbd_shop` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `cbdid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5546\u5708',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5e97\u94fa',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `orderindex` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `cbdid` (`cbdid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5546\u5708\u5546\u5bb6'","sky_mod_flk_coupon":"CREATE TABLE `sky_mod_flk_coupon` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `siteid` int(11) unsigned NOT NULL DEFAULT '1',\n `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `money` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '\u4ef7\u683c',\n `amount` int(11) NOT NULL DEFAULT '0' COMMENT '\u6570\u91cf',\n `end_time` datetime NOT NULL DEFAULT '2099-02-01 03:01:02' COMMENT '\u622a\u6b62\u65e5\u671f',\n `dateline` int(11) NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `shopid` int(11) NOT NULL DEFAULT '0' COMMENT '\u5e97\u94faId',\n `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `get_num` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '\u9886\u53d6\u4eba\u6570',\n `use_num` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '\u4f7f\u7528\u4eba\u6570',\n `lower_money` decimal(9,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '\u6700\u4f4e\u4f7f\u7528\u4ef7\u683c',\n `limit_num` int(11) NOT NULL DEFAULT '0' COMMENT '\u9650\u5236\u9886\u53d6\u6570',\n `typeid` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '\u7c7b\u578b 1\u65e0\u9700\u53d6\u5238 2\u9700\u8981\u53d6\u5238',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_coupon_user":"CREATE TABLE `sky_mod_flk_coupon_user` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `siteid` int(11) NOT NULL DEFAULT '1',\n `coupon_id` int(11) NOT NULL DEFAULT '0' COMMENT '\u4f18\u60e0\u5238',\n `shopid` int(11) NOT NULL DEFAULT '0' COMMENT '\u6240\u5c5e\u5e97\u94fa',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `dateline` int(11) NOT NULL DEFAULT '0' COMMENT '\u9886\u53d6\u65f6\u95f4',\n `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u4f7f\u7528\u72b6\u6001',\n `notice_time` int(11) NOT NULL DEFAULT '0' COMMENT '\u4e0a\u6b21\u901a\u77e5',\n `money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '\u4ef7\u683c',\n `lower_money` decimal(9,2) DEFAULT '0.00' COMMENT '\u6700\u4f4e\u4f7f\u7528\u4ef7\u683c',\n `end_time` int(11) NOT NULL DEFAULT '0' COMMENT '\u622a\u6b62\u65e5\u671f',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_daxin":"CREATE TABLE `sky_mod_flk_daxin` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `money` decimal(9,2) NOT NULL DEFAULT '0.00',\n `orderid` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `usm` (`userid`,`status`,`money`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='\u6253\u65b0'","sky_mod_flk_daxin_log":"CREATE TABLE `sky_mod_flk_daxin_log` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `money` decimal(9,2) NOT NULL DEFAULT '0.00',\n `content` varchar(225) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `usm` (`userid`,`money`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='\u6253\u65b0\u65e5\u5fd7'","sky_mod_flk_express_fee":"CREATE TABLE `sky_mod_flk_express_fee` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '0',\n `fmoney` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u9996\u91cd',\n `amoney` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u52a0\u91cd',\n `shopid` int(11) NOT NULL DEFAULT '0' COMMENT '\u5e97\u94fa',\n `fweight` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u9996\u91cd',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_express_fee_city":"CREATE TABLE `sky_mod_flk_express_fee_city` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7',\n `areaid` int(11) NOT NULL DEFAULT '0' COMMENT '\u533a\u57df',\n `shopid` int(11) NOT NULL DEFAULT '0' COMMENT '\u5e97\u94fa',\n PRIMARY KEY (`id`),\n KEY `areaid` (`areaid`,`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_group":"CREATE TABLE `sky_mod_flk_group` (\n `gid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `gkey` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6807\u7b7e',\n `gnum` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '\u8bb0\u5f55\u6570',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`gid`),\n KEY `gkey` (`gkey`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u4ea7\u54c1\u805a\u5408'","sky_mod_flk_group_product":"CREATE TABLE `sky_mod_flk_group_product` (\n `gpid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `gid` int(10) unsigned NOT NULL DEFAULT '0',\n `productid` int(10) unsigned NOT NULL DEFAULT '0',\n `orderindex` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`gpid`),\n KEY `gid` (`gid`),\n KEY `productid` (`productid`)\n) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u4ea7\u54c1\u805a\u5408'","sky_mod_flk_guest":"CREATE TABLE `sky_mod_flk_guest` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `createtime` datetime NOT NULL DEFAULT '2019-02-23 05:31:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u62372',\n `productid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5206\u7c7b\u4fe1\u606f',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `author` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `isread` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `ukey` varchar(255) NOT NULL DEFAULT '' COMMENT '\u7c7b\u578b',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`),\n KEY `objectid_userid` (`productid`,`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u54a8\u8be2\u7d22\u5f15'","sky_mod_flk_guestindex":"CREATE TABLE `sky_mod_flk_guestindex` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `createtime` datetime NOT NULL DEFAULT '2019-02-23 05:31:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u62372',\n `productid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5206\u7c7b\u4fe1\u606f',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `author` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `ukey` varchar(16) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`),\n KEY `objectid_userid` (`productid`,`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u54a8\u8be2\u7d22\u5f15'","sky_mod_flk_order":"CREATE TABLE `sky_mod_flk_order` (\n `orderid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '\u8ba2\u5355',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `orderno` varchar(36) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8ba2\u5355\u53f7',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `israty` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u8bc4\u8bba 0\u5426 1\u662f',\n `ispay` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u652f\u4ed8 1\u662f ',\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `isreceived` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u63a5\u6536 0 \u5426 1\u662f',\n `shop_money` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u5546\u5bb6\u91d1\u989d',\n `money` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u8ba2\u5355\u4ef7\u683c',\n `user_address_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6536\u8d27\u5730\u5740',\n `express_no` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7269\u6d41\u53f7',\n `goods_money` decimal(15,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u4ea7\u54c1\u4ef7\u683c',\n `express_money` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u5feb\u9012\u4ef7\u683c',\n `discount_money` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u6298\u6263\u4ef7\u683c',\n `account_money` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u5e93\u652f\u4ed8',\n `pay_money` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u5728\u7ebf\u652f\u4ed8\u7684\u94b1',\n `coupon_id` int(11) NOT NULL DEFAULT '0' COMMENT '\u4f18\u60e0\u5238',\n `coupon_money` decimal(13,2) NOT NULL DEFAULT '0.00' COMMENT '\u4f18\u60e0\u5238\u4ef7\u683c',\n `comment` varchar(225) CHARACTER SET utf8 NOT NULL COMMENT '\u8bc4\u8bba\u5185\u5bb9',\n `paytype` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u65b9\u5f0f',\n `whocancel` varchar(16) CHARACTER SET utf8 NOT NULL COMMENT '\u8c01\u53d6\u6d88\u7684',\n `daySn` smallint(6) NOT NULL DEFAULT '0' COMMENT '\u6bcf\u65e5\u8ba2\u5355\u6392\u5e8f',\n `total_num` smallint(5) unsigned NOT NULL DEFAULT '0',\n `createtime` datetime NOT NULL DEFAULT '2017-07-02 12:43:01',\n `recharge_id` int(10) unsigned NOT NULL,\n `weight` decimal(9,2) unsigned NOT NULL DEFAULT '0.00',\n `fromsite` varchar(12) CHARACTER SET utf8 NOT NULL DEFAULT 'flk' COMMENT '\u6765\u6e90\u7ad9\u70b9 b2c \u72ec\u7acb\u5efa\u7ad9 flk\u5e73\u53f0\u8ba2\u5355',\n `flkid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u8fd4\u5229\u5361',\n `flk_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u8fd4\u5229\u5238\u989d\u5ea6',\n `pin_orderid` int(10) unsigned NOT NULL DEFAULT '0',\n `sendtype` varchar(255) NOT NULL DEFAULT '' COMMENT '\u914d\u9001\u65b9\u5f0f \u5230\u5bb6 \u5230\u5e97',\n `ordertype` varchar(255) NOT NULL DEFAULT '' COMMENT '\u8ba2\u5355\u7c7b\u578b',\n `productid` int(11) NOT NULL DEFAULT '0' COMMENT '\u4ea7\u54c1',\n PRIMARY KEY (`orderid`),\n KEY `userid` (`userid`) ,\n KEY `orderno` (`orderno`) \n) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u8ba2\u5355'","sky_mod_flk_order_address":"CREATE TABLE `sky_mod_flk_order_address` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `orderid` int(11) NOT NULL DEFAULT '0',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `truename` char(8) CHARACTER SET utf8 DEFAULT NULL,\n `telephone` char(12) CHARACTER SET utf8 DEFAULT NULL,\n `address` varchar(64) CHARACTER SET utf8 DEFAULT NULL,\n `createtime` datetime NOT NULL DEFAULT '2017-07-02 12:43:01',\n `province_id` int(11) NOT NULL DEFAULT '0',\n `city_id` int(11) NOT NULL DEFAULT '0',\n `town_id` int(11) NOT NULL DEFAULT '0',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `orderid` (`orderid`) \n) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_order_code":"CREATE TABLE `sky_mod_flk_order_code` (\n `orderid` int(10) unsigned NOT NULL DEFAULT '0',\n `ordercode` varchar(32) NOT NULL DEFAULT '',\n `isuse` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`orderid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u8ba2\u5355\u9a8c\u8bc1\u7801'","sky_mod_flk_order_data":"CREATE TABLE `sky_mod_flk_order_data` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `orderid` int(10) unsigned NOT NULL DEFAULT '0',\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `createtime` datetime NOT NULL DEFAULT '2018-07-17 09:01:01',\n `updatetime` datetime NOT NULL DEFAULT '2018-07-17 09:01:01',\n `content` mediumtext CHARACTER SET utf8,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `orderid` (`orderid`) \n) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_order_log":"CREATE TABLE `sky_mod_flk_order_log` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `createtime` datetime NOT NULL DEFAULT '2019-02-28 06:01:01',\n `orderid` bigint(20) NOT NULL DEFAULT '0',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `adminid` int(11) unsigned NOT NULL DEFAULT '0',\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `orderid` (`orderid`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_order_product":"CREATE TABLE `sky_mod_flk_order_product` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `orderid` int(11) NOT NULL DEFAULT '0',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `productid` int(11) NOT NULL DEFAULT '0',\n `price` decimal(13,2) NOT NULL DEFAULT '0.00',\n `amount` int(11) NOT NULL DEFAULT '1',\n `createtime` datetime NOT NULL DEFAULT '2017-07-02 12:44:41',\n `ksid` int(11) NOT NULL DEFAULT '0' COMMENT '\u6b3e\u5f0fid',\n `iscomment` tinyint(4) NOT NULL DEFAULT '0',\n `raty_grade` tinyint(4) NOT NULL DEFAULT '0',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `orderid` (`orderid`) ,\n KEY `productid` (`productid`)\n) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_order_raty":"CREATE TABLE `sky_mod_flk_order_raty` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `orderid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '\u8ba2\u5355',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `createtime` datetime NOT NULL DEFAULT '2019-02-28 10:01:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `raty_express` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u5feb\u9012',\n `raty_service` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u670d\u52a1',\n `raty_quality` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u8d28\u91cf',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5185\u5bb9',\n PRIMARY KEY (`id`),\n KEY `orderid` (`orderid`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u8ba2\u5355\u8bc4\u4ef7'","sky_mod_flk_product":"CREATE TABLE `sky_mod_flk_product` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `shop_catid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5e97\u94fa\u5206\u7c7b',\n `catid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5206\u7c7b',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `imgurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u56fe\u7247',\n `price` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u4ef7\u683c',\n `iswindow` tinyint(3) unsigned DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u4e0a\u67b6',\n `weight` decimal(9,2) unsigned NOT NULL DEFAULT '0.00',\n `createtime` datetime NOT NULL DEFAULT '2019-01-30 08:01:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `updatetime` datetime NOT NULL DEFAULT '2019-01-30 08:01:01' COMMENT '\u66f4\u65b0\u65f6\u95f4',\n `ks_label_name` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '\u989c\u8272' COMMENT '\u6b3e\u5f0f\u540d\u79f0',\n `ks_label_size` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '\u5c3a\u5bf8' COMMENT '\u6b3e\u5f0f\u5c3a\u5bf8',\n `month_buy_num` int(10) unsigned NOT NULL DEFAULT '0',\n `isnew` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u65b0',\n `ishot` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u70ed',\n `isrecommend` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u63a8\u8350',\n `total_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u5e93\u5b58',\n `buy_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u9500\u91cf',\n `lower_price` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u4fc3\u9500\u4ef7',\n `market_price` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u5e02\u573a\u4ef7',\n `isksid` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u6709\u6b3e\u5f0f',\n `view_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u8bbf\u95ee\u6570',\n `fav_num` int(10) unsigned NOT NULL DEFAULT '0',\n `ex_table_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u6269\u5c55\u8868',\n `ex_table_data_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '\u6269\u5c55\u8868id',\n `videourl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `videobg` varchar(255) NOT NULL DEFAULT '',\n `videoid` int(10) unsigned NOT NULL DEFAULT '0',\n `one_on` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `one_price` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `one_status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `one_discount` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '\u5546\u5bb6\u63d0\u6210',\n `one_flk_discount` tinyint(4) unsigned NOT NULL DEFAULT '10' COMMENT '\u8fd4\u5229\u6298\u6263',\n `one_stime` datetime NOT NULL DEFAULT '2020-07-01 00:01:01',\n `one_etime` datetime NOT NULL DEFAULT '2020-07-01 00:01:01',\n `imgsdata` text CHARACTER SET utf8,\n PRIMARY KEY (`id`),\n KEY `catid_status` (`catid`,`status`)\n) ENGINE=InnoDB AUTO_INCREMENT=2682 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u4ea7\u54c1'","sky_mod_flk_product_data":"CREATE TABLE `sky_mod_flk_product_data` (\n `id` int(10) unsigned NOT NULL,\n `content` mediumtext CHARACTER SET utf8,\n `shopid` int(10) unsigned DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u4ea7\u54c1'","sky_mod_flk_product_ks":"CREATE TABLE `sky_mod_flk_product_ks` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned DEFAULT '0',\n `productid` int(11) unsigned NOT NULL COMMENT '\u4ea7\u54c1',\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `size` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5c3a\u5bf8',\n `price` decimal(13,2) unsigned NOT NULL DEFAULT '0.00',\n `createtime` datetime NOT NULL DEFAULT '2019-01-30 08:01:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `total_num` int(11) NOT NULL DEFAULT '0',\n `buy_num` int(11) NOT NULL DEFAULT '0',\n `imgurl` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `productid` (`productid`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_queue":"CREATE TABLE `sky_mod_flk_queue` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `total_money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00',\n `flk_money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00',\n `back_money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00',\n `money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00',\n `orderid` int(10) unsigned NOT NULL DEFAULT '0',\n `isfinish` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `ischeck` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u751f\u6548',\n `isback` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u8fd4\u5229',\n `isnew` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u6253\u65b0\u4e86',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `ordertype` varchar(255) NOT NULL DEFAULT '' COMMENT '\u8ba2\u5355\u7c7b\u578b',\n `productid` int(11) NOT NULL DEFAULT '0' COMMENT '\u4ea7\u54c1',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='\u6392\u961f\u961f\u5217'","sky_mod_flk_queue_log":"CREATE TABLE `sky_mod_flk_queue_log` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `money` decimal(9,2) NOT NULL DEFAULT '0.00',\n `xfrom` varchar(12) NOT NULL DEFAULT '',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='\u8fd4\u5229\u65e5\u5fd7'","sky_mod_flk_report":"CREATE TABLE `sky_mod_flk_report` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `typeid` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `reply` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `content` varchar(225) CHARACTER SET utf8 DEFAULT NULL,\n `imgsdata` text CHARACTER SET utf8,\n `createtime` datetime NOT NULL DEFAULT '2019-03-22 03:02:03',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u4e3e\u62a5'","sky_mod_flk_shop":"CREATE TABLE `sky_mod_flk_shop` (\n `shopid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopname` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5546\u5bb6\u540d\u79f0',\n `catid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5206\u7c7b',\n `title` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6807\u9898',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `createtime` datetime NOT NULL DEFAULT '2018-12-07 11:32:01',\n `imgurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '\/static\/images\/no_image.jpg' COMMENT '\u56fe\u7247',\n `view_num` int(10) unsigned NOT NULL DEFAULT '0',\n `comment_num` int(10) unsigned NOT NULL DEFAULT '0',\n `love_num` int(10) unsigned NOT NULL DEFAULT '0',\n `sc_id` int(10) unsigned NOT NULL DEFAULT '0',\n `lat` decimal(9,6) NOT NULL DEFAULT '0.000000' COMMENT '\u7eac\u5ea6',\n `lng` decimal(9,6) NOT NULL DEFAULT '0.000000' COMMENT '\u7ecf\u5ea6',\n `nickname` varchar(12) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `telephone` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8054\u7cfb\u7535\u8bdd',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `isrecommend` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u662f\u5426\u63a8\u8350',\n `address` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5730\u5740',\n `fav_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6536\u85cf\u6570',\n `banner` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'banner',\n `buy_num` int(10) unsigned NOT NULL DEFAULT '0',\n `month_buy_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u6708\u552e',\n `window_products` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6a71\u7a97\u5546\u54c1',\n `sendtype` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u53d1\u8d27\u65b9\u5f0f',\n `money` decimal(13,2) unsigned NOT NULL DEFAULT '0.00',\n `balance` decimal(13,2) unsigned NOT NULL DEFAULT '0.00',\n `earnest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4fdd\u8bc1\u91d1 ',\n `gonggao` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `raty_grade` decimal(9,1) unsigned NOT NULL DEFAULT '10.0' COMMENT '\u8bc4\u5206',\n `raty_grade_product` decimal(9,1) unsigned NOT NULL DEFAULT '10.0' COMMENT '\u4ea7\u54c1\u8bc4\u5206',\n `raty_grade_express` decimal(3,1) unsigned NOT NULL DEFAULT '10.0' COMMENT '\u7269\u6d41\u8bc4\u5206',\n `yystart` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '00:01' COMMENT '\u8425\u4e1a\u5f00\u59cb',\n `yyend` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '23:59' COMMENT '\u8425\u4e1a\u7ed3\u675f',\n `express_money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u5feb\u9012\u8d39',\n `cspf` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u8d85\u65f6\u8d54\u4ed8',\n `chainshop` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u8fde\u9501\u5e97',\n `avg_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u5747\u4ef7',\n `content` mediumtext CHARACTER SET utf8,\n `send_time` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u9001\u8d27\u901f\u5ea6',\n `send_startprice` decimal(9,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '\u8d77\u9001\u4ef7',\n `isnew` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u65b0\u5e97',\n `discount_new` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u65b0\u4eba\u7279\u60e0',\n `discount_goods` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u5355\u54c1\u6298\u6263',\n `flk_discount` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '\u8fd4\u5229\u6298\u6263',\n `flk_new` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u65b0',\n `flk_maxmoney` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u5927\u53ef\u8fd4\u5229\u989d\u5ea6',\n `discount_coupon` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u6ee1\u51cf\u6d3b\u52a8',\n `zzdata` text CHARACTER SET utf8 COMMENT '\u8d44\u8d28\u6587\u4ef6',\n PRIMARY KEY (`shopid`)\n) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5546\u5bb6'","sky_mod_flk_shop_apply":"CREATE TABLE `sky_mod_flk_shop_apply` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `nickname` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8054\u7cfb\u4eba',\n `telephone` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7535\u8bdd',\n `address` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5730\u5740',\n `yyzz` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8425\u4e1a\u6267\u7167',\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u4e1a\u52a1\u4ecb\u7ecd',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u4f9b\u5e94\u5546\u7533\u8bf7'","sky_mod_flk_shop_category":"CREATE TABLE `sky_mod_flk_shop_category` (\n `catid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `pid` int(10) unsigned NOT NULL DEFAULT '0',\n `orderindex` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `imgurl` varchar(225) CHARACTER SET utf8 DEFAULT '',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n PRIMARY KEY (`catid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5206\u7c7b'","sky_mod_flk_shop_commission":"CREATE TABLE `sky_mod_flk_shop_commission` (\n `shopid` int(10) unsigned NOT NULL,\n `per` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `stime` int(10) unsigned NOT NULL DEFAULT '0',\n `etime` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='\u4f63\u91d1'","sky_mod_flk_shop_earnest":"CREATE TABLE `sky_mod_flk_shop_earnest` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL COMMENT '\u5546\u5bb6',\n `createtime` datetime NOT NULL DEFAULT '2018-08-24 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `lasttime` datetime NOT NULL DEFAULT '2018-08-24 00:00:00' COMMENT '\u66f4\u65b0\u65f6\u95f4',\n `endtime` datetime NOT NULL DEFAULT '2018-08-24 00:00:00' COMMENT '\u622a\u6b62\u65f6\u95f4',\n `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u91d1\u989d',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_shop_earnest_log":"CREATE TABLE `sky_mod_flk_shop_earnest_log` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL COMMENT '\u5546\u5bb6',\n `createtime` datetime NOT NULL DEFAULT '2018-08-24 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `money` int(10) NOT NULL DEFAULT '0' COMMENT '\u91d1\u989d',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5185\u5bb9',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_shop_earnest_refund":"CREATE TABLE `sky_mod_flk_shop_earnest_refund` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL COMMENT '\u5546\u5bb6',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `createtime` datetime NOT NULL DEFAULT '2018-08-24 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `finishtime` datetime NOT NULL DEFAULT '2018-08-24 00:00:00' COMMENT '\u5904\u7406\u65f6\u95f4',\n `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u91d1\u989d',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5185\u5bb9',\n `bankid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u94f6\u884c\u5361',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_shop_money":"CREATE TABLE `sky_mod_flk_shop_money` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `income` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u603b\u6536\u5165',\n `balance` decimal(13,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u53ef\u7528\u4f59\u989d',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5546\u5bb6\u8d44\u91d1'","sky_mod_flk_shop_money_log":"CREATE TABLE `sky_mod_flk_shop_money_log` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL COMMENT '\u5546\u5bb6',\n `createtime` datetime NOT NULL DEFAULT '2018-08-24 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `money` decimal(13,2) NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5185\u5bb9',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_shop_notice":"CREATE TABLE `sky_mod_flk_shop_notice` (\n `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `siteid` int(11) unsigned NOT NULL DEFAULT '1',\n `dateline` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `type_id` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u6d88\u606f\u7c7b\u578b',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 0\u672a\u8bfb',\n `adminid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7ba1\u7406\u5458',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5546\u5bb6',\n `content` text CHARACTER SET utf8 NOT NULL COMMENT '\u6d88\u606f\u5185\u5bb9',\n `linkurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94fe\u63a5',\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '\u901a\u77e5' COMMENT '\u5c0f\u6807\u9898',\n PRIMARY KEY (`id`),\n KEY `userid` (`adminid`,`dateline`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_shop_openbind":"CREATE TABLE `sky_mod_flk_shop_openbind` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `k` varchar(32) NOT NULL DEFAULT '',\n `content` text,\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='\u5546\u5bb6\u5f00\u653e\u5e73\u53f0'","sky_mod_flk_shop_paypwd":"CREATE TABLE `sky_mod_flk_shop_paypwd` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `paypwd` varchar(32) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='\u652f\u4ed8\u5bc6\u7801'","sky_mod_flk_shop_product_category":"CREATE TABLE `sky_mod_flk_shop_product_category` (\n `catid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `title` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `pid` int(10) unsigned NOT NULL DEFAULT '0',\n `orderindex` int(10) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `imgurl` varchar(225) CHARACTER SET utf8 DEFAULT '',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n PRIMARY KEY (`catid`)\n) ENGINE=InnoDB AUTO_INCREMENT=563 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5206\u7c7b'","sky_mod_flk_shop_safephone":"CREATE TABLE `sky_mod_flk_shop_safephone` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `telephone` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5b89\u5168\u624b\u673a'","sky_mod_flk_video":"CREATE TABLE `sky_mod_flk_video` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `shopid` int(10) unsigned NOT NULL DEFAULT '0',\n `title` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6807\u9898',\n `url` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u89c6\u9891\u5730\u5740',\n `size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5927\u5c0f',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 2\u663e\u793a',\n `shop_cid` int(11) NOT NULL DEFAULT '0' COMMENT '\u5546\u5bb6\u5206\u7c7b',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `imgurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u89c6\u9891\u622a\u56fe',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_mod_flk_view_user":"CREATE TABLE `sky_mod_flk_view_user` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `shopid` int(11) NOT NULL DEFAULT '0',\n `userid` int(11) NOT NULL DEFAULT '0',\n `lasttime` datetime NOT NULL DEFAULT '2018-07-09 10:49:01',\n `createtime` datetime NOT NULL DEFAULT '2018-02-03 15:09:01',\n `money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00',\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`,`lasttime`) ,\n KEY `userid_shopid` (`userid`,`shopid`)\n) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='\u5e97\u94fa\u8bbf\u95ee\u5ba2\u6237'","sky_model":"CREATE TABLE `sky_model` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `tablename` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8868\u540d',\n `cat_tpl` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u680f\u76ee\u6a21\u677f',\n `list_tpl` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5217\u8868\u6a21\u677f',\n `show_tpl` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8be6\u7ec6\u6a21\u677f',\n `module` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u662f\u5426\u6a21\u5757 1\u662f ',\n `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001 \u663e\u793a\u4e0e\u5426',\n `data` text CHARACTER SET utf8 COMMENT '\u8be6\u7ec6\u5185\u5bb9',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4","sky_model_index":"CREATE TABLE `sky_model_index` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `tablename` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_module":"CREATE TABLE `sky_module` (\n `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(20) CHARACTER SET utf8 NOT NULL,\n `tablename` varchar(20) CHARACTER SET utf8 NOT NULL,\n `data` text CHARACTER SET utf8 NOT NULL,\n `cat_tpl` varchar(50) CHARACTER SET utf8 NOT NULL,\n `list_tpl` varchar(50) CHARACTER SET utf8 NOT NULL,\n `show_tpl` varchar(50) CHARACTER SET utf8 NOT NULL,\n `module` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4","sky_navbar":"CREATE TABLE `sky_navbar` (\n `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `orderindex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '\u6392\u5e8f',\n `link_url` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94fe\u63a5\u5730\u5740',\n `target` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8df3\u8f6c\u76ee\u6807',\n `pid` mediumint(9) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7',\n `group_id` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u5206\u7ec4',\n `m` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `a` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `logo` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'logo',\n `icon` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u56fe\u6807',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=322 DEFAULT CHARSET=utf8mb4 COMMENT='\u5bfc\u822a\u8868'","sky_notice":"CREATE TABLE `sky_notice` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `dateline` int(11) NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `type_id` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u7c7b\u522b ',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 0\u672a\u8bfb',\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `content` text CHARACTER SET utf8 COMMENT '\u5185\u5bb9',\n `linkurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94fe\u63a5',\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '\u901a\u77e5' COMMENT '\u5c0f\u6807\u9898',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`,`dateline`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4","sky_open_alioss":"CREATE TABLE `sky_open_alioss` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `apptype` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT 'oss' COMMENT '\u7c7b\u578b oss\u4e91\u5b58\u50a8',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ACCESS_ID',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ACCESS_KEY',\n `endpoint` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ENDPOINT',\n `bucket` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'TEST_BUCKET',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_open_alipay":"CREATE TABLE `sky_open_alipay` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appid',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appkey',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `appcert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `alicert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `rootcert_path` varchar(225) NOT NULL,\n `notify_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `return_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'openlogin',\n `merchant_private_key` text,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='\u652f\u4ed8\u5b9d'","sky_open_alipay_app":"CREATE TABLE `sky_open_alipay_app` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appid',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appkey',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `appcert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `alicert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `rootcert_path` varchar(225) NOT NULL,\n `notify_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `return_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'openlogin',\n `merchant_private_key` text,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_open_alipay_mini":"CREATE TABLE `sky_open_alipay_mini` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appid',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appkey',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `appcert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `alicert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `rootcert_path` varchar(225) NOT NULL,\n `notify_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `return_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'openlogin',\n `merchant_private_key` text,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_open_baidu":"CREATE TABLE `sky_open_baidu` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appid',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appkey',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `merchant_private_key` text CHARACTER SET utf8 NOT NULL,\n `alipay_public_key` text CHARACTER SET utf8 NOT NULL,\n `notify_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `return_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'openlogin',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_open_map":"CREATE TABLE `sky_open_map` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(16) NOT NULL DEFAULT '',\n `map_com` varchar(16) NOT NULL DEFAULT 'amap' COMMENT '\u5730\u56fe\u5e73\u53f0',\n `map_app` varchar(16) NOT NULL DEFAULT '' COMMENT '\u7c7b\u578b web server',\n `mkey` varchar(64) NOT NULL DEFAULT '' COMMENT 'key',\n `msecret` varchar(64) NOT NULL DEFAULT '' COMMENT '\u5bc6\u7801',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC","sky_open_qq":"CREATE TABLE `sky_open_qq` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `apptype` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7c7b\u578b web app',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appid',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appkey',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'openlogin',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u5fae\u4fe1App'","sky_open_toutiao":"CREATE TABLE `sky_open_toutiao` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appid',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appkey',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `merchant_private_key` text CHARACTER SET utf8 NOT NULL,\n `alipay_public_key` text CHARACTER SET utf8 NOT NULL,\n `notify_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `return_url` varchar(225) CHARACTER SET utf8 NOT NULL,\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'openlogin',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_open_wxapp":"CREATE TABLE `sky_open_wxapp` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appid',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appkey',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `sslcert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8cer\u8bc1\u4e66',\n `sslkey_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8key\u8bc1\u4e66',\n `mchid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5546\u6237\u53f7',\n `mchkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5546\u6237\u652f\u4ed8\u5bc6\u94a5',\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'openlogin',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='\u5fae\u4fe1\u5c0f\u7a0b\u5e8f'","sky_open_wxnative":"CREATE TABLE `sky_open_wxnative` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `createtime` datetime NOT NULL DEFAULT '2018-11-09 00:00:00' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appid',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'appkey',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `sslcert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8cer\u8bc1\u4e66',\n `sslkey_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8key\u8bc1\u4e66',\n `mchid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5546\u6237\u53f7',\n `mchkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5546\u6237\u652f\u4ed8\u5bc6\u94a5',\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'openlogin',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u5fae\u4fe1App'","sky_openlogin":"CREATE TABLE `sky_openlogin` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `xfrom` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5e73\u53f0\u7c7b\u578b weixin weibo',\n `openid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u4e09\u65b9\u7528\u6237',\n `accesstoken` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u4e09\u65b9\u6388\u6743',\n `createtime` datetime NOT NULL DEFAULT '2018-01-24 08:54:01',\n `nickname` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6635\u79f0',\n `user_head` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5934\u50cf',\n `gender` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u6027\u522b',\n `unionid` varchar(32) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_pagetpl":"CREATE TABLE `sky_pagetpl` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `m` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `a` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `tpl` varchar(128) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `diydata` varchar(520) NOT NULL DEFAULT '' COMMENT 'diy\u5185\u5bb9',\n PRIMARY KEY (`id`),\n KEY `m_a` (`m`,`a`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='\u6a21\u677f'","sky_pay_log":"CREATE TABLE `sky_pay_log` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `dateline` int(11) NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `type_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7c7b\u578b',\n `content` text CHARACTER SET utf8 COMMENT '\u5185\u5bb9',\n `isdelete` tinyint(4) unsigned DEFAULT '0' COMMENT '\u662f\u5426\u5220\u9664',\n `money` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `ispay` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u662f\u5426\u652f\u4ed8',\n PRIMARY KEY (`id`),\n KEY `u_d` (`userid`,`dateline`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4","sky_permission":"CREATE TABLE `sky_permission` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `m` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `access` text CHARACTER SET utf8 NOT NULL COMMENT '\u6743\u9650\u5185\u5bb9',\n `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4","sky_pm":"CREATE TABLE `sky_pm` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `type_id` int(11) NOT NULL DEFAULT '0',\n `t_userid` int(11) NOT NULL DEFAULT '0',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `status` tinyint(4) NOT NULL DEFAULT '0',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL,\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_pm_index":"CREATE TABLE `sky_pm_index` (\n `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `t_userid` int(11) NOT NULL,\n `pm_num` int(11) NOT NULL,\n `type_id` tinyint(4) NOT NULL,\n `dateline` int(11) NOT NULL DEFAULT '0',\n `status` tinyint(4) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `id` (`id`,`t_userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_pv":"CREATE TABLE `sky_pv` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `ssid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `url` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `m` varchar(32) NOT NULL,\n `a` varchar(32) NOT NULL,\n `createtime` datetime NOT NULL DEFAULT '2018-01-18 12:25:01',\n `createhour` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `createweek` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `ip` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `isphone` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `user_agent` varchar(225) CHARACTER SET utf8 NOT NULL,\n PRIMARY KEY (`id`),\n KEY `url` (`url`,`createtime`),\n KEY `createtime` (`createtime`,`url`)\n) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4 COMMENT='\u9875\u9762\u7edf\u8ba1'","sky_pv_day":"CREATE TABLE `sky_pv_day` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `ssid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `createtime` datetime NOT NULL DEFAULT '2018-01-18 12:25:01',\n `url` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `m` varchar(32) NOT NULL,\n `a` varchar(32) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `ssid_url` (`ssid`,`url`,`createtime`)\n) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4 COMMENT='\u9875\u9762\u6bcf\u65e5\u7edf\u8ba1'","sky_pv_ip":"CREATE TABLE `sky_pv_ip` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `ip` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `createtime` datetime NOT NULL DEFAULT '2018-01-18 12:25:01',\n PRIMARY KEY (`id`),\n KEY `ip` (`ip`,`createtime`) ,\n KEY `createtime` (`createtime`) \n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_pv_uv":"CREATE TABLE `sky_pv_uv` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `ssid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `createtime` datetime NOT NULL DEFAULT '2018-01-18 12:25:01',\n PRIMARY KEY (`id`),\n KEY `ssid` (`ssid`,`createtime`) ,\n KEY `createtime` (`createtime`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_queue":"CREATE TABLE `sky_queue` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `orderindex` int(10) unsigned NOT NULL DEFAULT '0',\n `k` varchar(32) NOT NULL DEFAULT '',\n `content` text,\n PRIMARY KEY (`id`),\n KEY `k_dateline` (`k`,`orderindex`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_recharge":"CREATE TABLE `sky_recharge` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `siteid` int(11) NOT NULL DEFAULT '1',\n `userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `money` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `pay_type` char(12) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u65b9\u5f0f',\n `openid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7528\u6237\u6807\u8bc6',\n `pay_orderno` varchar(42) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u7684\u8ba2\u5355\u7684\u8ba2\u5355\u53f7',\n `type_id` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '\u7c7b\u578b',\n `dateline` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '1\u652f\u4ed8\u6210\u529f ',\n `orderno` varchar(44) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8ba2\u5355\u53f7',\n `orderinfo` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8ba2\u5355\u4fe1\u606f',\n `tablename` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8868\u540d\u79f0',\n `orderdata` text CHARACTER SET utf8 NOT NULL COMMENT '\u8ba2\u5355\u5904\u7406\u5185\u5bb9',\n `objectid` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `u_d` (`userid`,`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4","sky_refund":"CREATE TABLE `sky_refund` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5546\u5bb6',\n `paytype` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u65b9\u5f0f',\n `createtime` datetime NOT NULL DEFAULT '2018-07-13 01:01:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `recharge_orderno` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u539f\u8ba2\u5355',\n `recharge_pay_orderno` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u539f\u8ba2\u5355',\n `recharge_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u652f\u4ed8\u7684ID',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `odata` text CHARACTER SET utf8 NOT NULL COMMENT '\u5904\u7406\u6570\u636e',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_refund_apply":"CREATE TABLE `sky_refund_apply` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `shopid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5546\u5bb6',\n `paytype` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u65b9\u5f0f',\n `createtime` datetime NOT NULL DEFAULT '2018-07-13 01:01:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `recharge_orderno` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u539f\u8ba2\u5355',\n `recharge_pay_orderno` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u539f\u8ba2\u5355',\n `recharge_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u652f\u4ed8ID',\n `content` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `odata` text CHARACTER SET utf8 NOT NULL COMMENT '\u6570\u636e\u5904\u7406',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 0 \u7533\u8bf7 1\u5904\u7406\u4e2d 2\u5904\u7406\u6210\u529f 4\u53d6\u6d88',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`),\n KEY `shopid` (`shopid`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT","sky_seo":"CREATE TABLE `sky_seo` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `m` char(20) CHARACTER SET utf8 NOT NULL,\n `a` char(20) CHARACTER SET utf8 NOT NULL,\n `cname` varchar(20) CHARACTER SET utf8 NOT NULL,\n `title` varchar(225) CHARACTER SET utf8 NOT NULL,\n `description` varchar(225) CHARACTER SET utf8 NOT NULL,\n `keywords` varchar(225) CHARACTER SET utf8 NOT NULL,\n `object_id` int(11) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `s_m_a` (`m`,`a`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_sgpay":"CREATE TABLE `sky_sgpay` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `yhk_name` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u5361\u540d\u79f0',\n `yhk_num` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5361\u53f7',\n `yhk_user` varchar(32) CHARACTER SET utf8 NOT NULL,\n `money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `createtime` datetime NOT NULL DEFAULT '2019-10-21 03:21:01' COMMENT '\u65f6\u95f4',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='\u7ebf\u4e0b\u5145\u503c'","sky_site":"CREATE TABLE `sky_site` (\n `siteid` int(11) NOT NULL AUTO_INCREMENT,\n `sitename` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `domain` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u57df\u540d',\n `is_open` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u662f\u5426\u5f00\u542f',\n `title` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6807\u9898',\n `keywords` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5173\u952e\u5b57',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `close_why` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5173\u95ed\u539f\u56e0',\n `logo` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'Logo',\n `icp` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5907\u6848\u53f7',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `template` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT 'index' COMMENT '\u6a21\u677f',\n `statjs` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7edf\u8ba1\u4ee3\u7801',\n `index_template` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'pc\u6a21\u677f',\n `wap_template` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'wap',\n `wapbg` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n PRIMARY KEY (`siteid`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4","sky_site_city":"CREATE TABLE `sky_site_city` (\n `sc_id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '\u533a\u57df\u540d\u79f0',\n `cityid` int(11) NOT NULL DEFAULT '0' COMMENT '\u533a\u57df\u5173\u8054id',\n `lat` decimal(9,6) NOT NULL DEFAULT '0.000000' COMMENT '\u7eac\u5ea6',\n `lng` decimal(9,6) NOT NULL DEFAULT '0.000000' COMMENT '\u7cbe\u5ea6',\n `orderindex` smallint(6) NOT NULL DEFAULT '0' COMMENT '\u6392\u5e8f \u8d8a\u5c0f\u8d8a\u524d\u9762',\n `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 0\u9690\u85cf 1\u663e\u793a',\n `pid` int(11) NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7\u5206\u7c7b',\n `siteid` int(11) NOT NULL DEFAULT '1' COMMENT '\u7ad9\u70b9',\n PRIMARY KEY (`sc_id`),\n KEY `cityid` (`cityid`)\n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4","sky_site_msg":"CREATE TABLE `sky_site_msg` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `content` varchar(32) NOT NULL DEFAULT '' COMMENT '\u5185\u5bb9',\n `createtime` datetime NOT NULL DEFAULT '2021-08-16 01:02:03' COMMENT '\u65f6\u95f4',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `tablename` varchar(32) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `tablename` (`tablename`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC","sky_sms_log":"CREATE TABLE `sky_sms_log` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `telephone` varchar(15) NOT NULL DEFAULT '',\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n `content` varchar(225) NOT NULL DEFAULT '',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `telephone` (`telephone`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC","sky_sysmsg":"CREATE TABLE `sky_sysmsg` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(255) CHARACTER SET utf8 NOT NULL,\n `status` tinyint(4) NOT NULL DEFAULT '0',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `content` mediumtext CHARACTER SET utf8 NOT NULL,\n `type_id` tinyint(4) NOT NULL,\n `start_time` int(11) NOT NULL,\n `end_time` int(11) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_sysmsg_user":"CREATE TABLE `sky_sysmsg_user` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `msgid` int(11) NOT NULL DEFAULT '0',\n `status` tinyint(4) NOT NULL DEFAULT '0',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `type_id` tinyint(4) NOT NULL DEFAULT '1',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC","sky_table":"CREATE TABLE `sky_table` (\n `tableid` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `title` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `tablename` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8868\u540d\u79f0',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `isLogin` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `isList` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u5217\u8868\u663e\u793a',\n `showTpl` varchar(64) NOT NULL DEFAULT '',\n `listTpl` varchar(64) NOT NULL DEFAULT '',\n `addTpl` varchar(64) NOT NULL DEFAULT '',\n PRIMARY KEY (`tableid`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='\u81ea\u5b9a\u4e49\u6269\u5c55\u8868'","sky_table_data":"CREATE TABLE `sky_table_data` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `tableid` int(10) unsigned NOT NULL DEFAULT '0',\n `catid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u5206\u7c7b',\n `objectid` int(10) unsigned NOT NULL DEFAULT '0',\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `createtime` datetime NOT NULL DEFAULT '2019-04-10 09:26:03',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `comment_num` int(10) unsigned NOT NULL DEFAULT '0',\n `view_num` int(10) unsigned NOT NULL DEFAULT '0',\n `content` mediumtext CHARACTER SET utf8,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='\u81ea\u5b9a\u4e49\u6269\u5c55\u8868-\u6570\u636e'","sky_table_data_comment":"CREATE TABLE `sky_table_data_comment` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001',\n `objectid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u6587\u7ae0',\n `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u4e0a\u7ea7\u8bc4\u8bba',\n `createtime` datetime NOT NULL DEFAULT '2018-07-02 18:52:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `content` text CHARACTER SET utf8 COMMENT '\u5185\u5bb9',\n `ip` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ip',\n `ip_city` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6240\u5728\u57ce\u5e02',\n `love_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u70b9\u8d5e\u6570',\n `imgsdata` text CHARACTER SET utf8 COMMENT '\u56fe\u96c6',\n PRIMARY KEY (`id`),\n KEY `objectid` (`objectid`,`status`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_table_fields":"CREATE TABLE `sky_table_fields` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `tableid` int(10) unsigned NOT NULL DEFAULT '0',\n `title` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `fieldname` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5217\u540d\u79f0',\n `fieldtype` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5217\u7c7b\u578b',\n `description` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u63cf\u8ff0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `orderindex` smallint(5) unsigned NOT NULL DEFAULT '0',\n `islist` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `optionlist` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '1024',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COMMENT='\u81ea\u5b9a\u4e49\u6269\u5c55\u8868'","sky_tixian":"CREATE TABLE `sky_tixian` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `objectid` int(10) unsigned NOT NULL,\n `k` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7c7b\u522b',\n `money` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 0\u7533\u8bf7 3\u5b8c\u6210 ',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `info` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5907\u6ce8',\n `reply` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u56de\u590d',\n `redateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u56de\u590d\u65f6\u95f4',\n `siteid` int(11) NOT NULL DEFAULT '1',\n `yhk_name` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u540d\u79f0',\n `yhk_haoma` varchar(24) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u5361\u53f7\u7801',\n `yhk_huming` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u94f6\u884c\u5361\u6237\u540d',\n `telephone` varchar(18) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7535\u8bdd',\n `yhk_address` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5f00\u6237\u5730\u5740',\n `adminid` int(11) NOT NULL DEFAULT '0' COMMENT '\u7ba1\u7406\u5458',\n `paytype` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u65b9\u5f0f \u652f\u4ed8\u5b9d \u94f6\u884c\u5361 \u5fae\u4fe1 ',\n `bankid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u94f6\u884c\u5361',\n PRIMARY KEY (`id`),\n KEY `money` (`money`),\n KEY `k_shopid_status` (`k`,`objectid`,`status`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4","sky_tixian_log":"CREATE TABLE `sky_tixian_log` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `siteid` int(11) NOT NULL DEFAULT '1',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `order_id` bigint(20) NOT NULL DEFAULT '0',\n `content` varchar(225) CHARACTER SET utf8 DEFAULT NULL,\n `admin_id` int(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `order_id` (`order_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_user":"CREATE TABLE `sky_user` (\n `userid` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `username` varchar(25) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '\u7528\u6237\u540d',\n `telephone` varchar(18) NOT NULL DEFAULT '' COMMENT '\u624b\u673a',\n `nickname` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '\u6635\u79f0',\n `money` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '\u91d1\u989d',\n `gold` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u91d1\u5e01',\n `grade` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u79ef\u5206',\n `createtime` datetime NOT NULL DEFAULT '2018-01-24 08:54:01' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `lasttime` datetime NOT NULL DEFAULT '2018-07-12 13:50:01' COMMENT '\u66f4\u65b0\u65f6\u95f4',\n `user_type` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '\u7528\u6237\u7c7b\u578b',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u6b63\u5e38',\n `is_auth` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u5b9e\u540d\u8ba4\u8bc1 1\u662f',\n `user_head` varchar(225) NOT NULL DEFAULT '\/static\/images\/user_head.jpg' COMMENT '\u7528\u6237\u5934\u50cf',\n `follow_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u5173\u6ce8\u6570',\n `followed_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7c89\u4e1d\u6570',\n `gender` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u6027\u522b 1\u7537 2\u5973',\n `invite_userid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u9080\u8bf7\u4eba',\n `birthday` date NOT NULL DEFAULT '2018-11-03' COMMENT '\u51fa\u751f\u65e5\u671f',\n `description` varchar(225) NOT NULL DEFAULT '',\n PRIMARY KEY (`userid`),\n KEY `telephone` (`telephone`),\n KEY `username` (`username`),\n KEY `nickname` (`nickname`) \n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8","sky_user_address":"CREATE TABLE `sky_user_address` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `address` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6536\u8d27\u5730\u5740',\n `telephone` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7535\u8bdd',\n `truename` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u6536\u8d27\u4eba',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 2\u4e0a\u7ebf',\n `zip_code` char(8) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u90ae\u7f16',\n `lastid` int(11) unsigned NOT NULL DEFAULT '0',\n `province_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7701',\n `city_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u5e02',\n `town_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u53bf',\n `isdefault` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u9ed8\u8ba4',\n `dateline` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa',\n `pct_address` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7701\u5e02\u5730\u5740',\n `lat` decimal(9,6) NOT NULL DEFAULT '0.000000' COMMENT '\u7eac\u5ea6',\n `lng` decimal(9,6) NOT NULL DEFAULT '0.000000' COMMENT '\u7ecf\u5ea6',\n PRIMARY KEY (`id`),\n KEY `s_u_id` (`status`,`userid`,`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_user_auth":"CREATE TABLE `sky_user_auth` (\n `userid` int(11) NOT NULL DEFAULT '0',\n `truename` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u771f\u5b9e\u59d3\u540d',\n `user_card` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8eab\u4efd\u8bc1\u53f7\u7801',\n `true_user_head` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5168\u8eab\u7167',\n `income` int(11) NOT NULL DEFAULT '0' COMMENT '\u6536\u5165',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `lasttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u66f4\u65b0\u65f6\u95f4',\n `telephone` char(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u624b\u673a\u53f7\u7801',\n `is_auth` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `content` mediumtext CHARACTER SET utf8 COMMENT '\u8be6\u7ec6\u4fe1\u606f',\n `info` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7b80\u4ecb',\n `sky_info` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7b80\u4ecb',\n PRIMARY KEY (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_user_auth_new":"CREATE TABLE `sky_user_auth_new` (\n `userid` int(11) NOT NULL DEFAULT '0',\n `truename` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u771f\u5b9e\u59d3\u540d',\n `user_card` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8eab\u4efd\u8bc1\u53f7\u7801',\n `income` int(11) NOT NULL DEFAULT '0' COMMENT '\u6536\u5165',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u521b\u5efa\u65f6\u95f4',\n `lasttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u66f4\u65b0\u65f6\u95f4',\n `telephone` char(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u624b\u673a\u53f7\u7801',\n `is_auth` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `status` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `content` mediumtext CHARACTER SET utf8 COMMENT '\u8be6\u7ec6\u4fe1\u606f',\n `info` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7b80\u4ecb',\n `true_user_head` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5168\u8eab\u7167',\n PRIMARY KEY (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_user_black":"CREATE TABLE `sky_user_black` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `buserid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u88ab\u62c9\u9ed1\u7528\u6237',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_user_expand":"CREATE TABLE `sky_user_expand` (\n `uid` int(10) unsigned NOT NULL,\n `content` text CHARACTER SET utf8 NOT NULL,\n PRIMARY KEY (`uid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_user_group":"CREATE TABLE `sky_user_group` (\n `groupid` int(11) NOT NULL AUTO_INCREMENT,\n `groupname` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `access` text CHARACTER SET utf8 NOT NULL COMMENT '\u6743\u9650',\n PRIMARY KEY (`groupid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_user_group_people":"CREATE TABLE `sky_user_group_people` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `gid` int(10) unsigned NOT NULL DEFAULT '0',\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `dateline` int(10) unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `gid` (`gid`) ,\n KEY `userid` (`userid`) \n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC","sky_user_invitecode":"CREATE TABLE `sky_user_invitecode` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0',\n `icode` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`),\n KEY `icode` (`icode`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='\u9080\u8bf7\u7801'","sky_user_lastaddr":"CREATE TABLE `sky_user_lastaddr` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '\u7528\u6237',\n `nickname` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8054\u7cfb\u4eba',\n `telephone` varchar(18) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8054\u7cfb\u7535\u8bdd',\n `address` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u8054\u7cfb\u5730\u5740',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4","sky_user_password":"CREATE TABLE `sky_user_password` (\n `userid` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `password` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u767b\u5f55\u5bc6\u7801',\n `paypwd` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8\u5bc6\u7801',\n `salt` varchar(6) NOT NULL DEFAULT '' COMMENT '\u5bc6\u7801\u4e32',\n PRIMARY KEY (`userid`)\n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='\u7528\u6237\u5bc6\u7801'","sky_user_rank":"CREATE TABLE `sky_user_rank` (\n `id` tinyint(4) NOT NULL AUTO_INCREMENT,\n `rank_name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u540d\u79f0',\n `min_grade` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u4f4e\u79ef\u5206',\n `max_grade` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6700\u9ad8\u5206',\n `discount` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u6298\u6263',\n `logo` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u7b49\u7ea7logo',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4","sky_user_vip":"CREATE TABLE `sky_user_vip` (\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `starttime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u5f00\u59cb\u65f6\u95f4',\n `firsttime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u9996\u6b21\u8d2d\u4e70',\n `endtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7ed3\u675f\u65f6\u95f4',\n `stype` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '\u7c7b\u578b',\n PRIMARY KEY (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_weixin":"CREATE TABLE `sky_weixin` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `token` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `dateline` int(11) NOT NULL DEFAULT '0',\n `status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '\u72b6\u6001 1\u663e\u793a',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `domain` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `catid` int(11) unsigned NOT NULL DEFAULT '0',\n `logo` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `imgurl` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `isrecommend` tinyint(4) unsigned NOT NULL DEFAULT '0',\n `imgsdata` text CHARACTER SET utf8,\n `appid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `appkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u516c\u4f17\u5e10\u53f7secert',\n `isshow` tinyint(4) unsigned NOT NULL DEFAULT '0',\n `ysid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `shopid` int(11) unsigned NOT NULL DEFAULT '0',\n `wx_username` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `wx_pwd` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `enkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `mchid` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5546\u6237\u53f7',\n `mchkey` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u5546\u6237\u652f\u4ed8\u5bc6\u94a5',\n `sslcert_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8cer\u8bc1\u4e66',\n `sslkey_path` varchar(225) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '\u652f\u4ed8key\u8bc1\u4e66',\n `openlogin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0\u76f4\u63a5\u767b\u5f55 1\u4e09\u65b9\u7ed1\u5b9a',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4","sky_weixin_command":"CREATE TABLE `sky_weixin_command` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `wid` int(11) NOT NULL DEFAULT '0',\n `title` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `command` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',\n `type_id` tinyint(4) NOT NULL DEFAULT '0',\n `content` text CHARACTER SET utf8,\n `dateline` int(11) NOT NULL DEFAULT '0',\n `fun` varchar(255) CHARACTER SET utf8 DEFAULT '32',\n `isdefault` tinyint(4) DEFAULT '0',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `shopid` int(11) NOT NULL DEFAULT '0',\n `sc_id` int(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `wid` (`wid`),\n KEY `command` (`command`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_weixin_menu":"CREATE TABLE `sky_weixin_menu` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `wid` int(11) NOT NULL DEFAULT '0',\n `pid` int(11) NOT NULL DEFAULT '0',\n `orderindex` tinyint(4) NOT NULL DEFAULT '0',\n `title` varchar(20) CHARACTER SET utf8 DEFAULT NULL,\n `w_type` varchar(10) CHARACTER SET utf8 DEFAULT '\u7c7b\u578b',\n `w_key` varchar(32) CHARACTER SET utf8 DEFAULT NULL,\n `w_url` varchar(225) CHARACTER SET utf8 DEFAULT NULL,\n `sc_id` int(11) NOT NULL DEFAULT '0',\n `shopid` int(11) NOT NULL DEFAULT '0',\n `content` text CHARACTER SET utf8 COMMENT '\u5185\u5bb9',\n PRIMARY KEY (`id`),\n KEY `userid` (`userid`),\n KEY `wid` (`wid`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4","sky_weixin_reply":"CREATE TABLE `sky_weixin_reply` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `status` tinyint(4) DEFAULT '0',\n `openid` varchar(32) CHARACTER SET utf8 NOT NULL,\n `msgtype` char(10) CHARACTER SET utf8 NOT NULL,\n `createtime` int(11) DEFAULT '0',\n `content` text CHARACTER SET utf8,\n `msgid` varchar(32) CHARACTER SET utf8 DEFAULT NULL,\n `picurl` varchar(250) CHARACTER SET utf8 DEFAULT NULL,\n `mediaid` varchar(32) CHARACTER SET utf8 DEFAULT NULL,\n `thumbmediaid` varchar(32) CHARACTER SET utf8 DEFAULT NULL,\n `format` varchar(12) CHARACTER SET utf8 DEFAULT NULL,\n `location_x` varchar(20) CHARACTER SET utf8 DEFAULT NULL,\n `location_y` varchar(20) CHARACTER SET utf8 DEFAULT NULL,\n `scale` int(11) DEFAULT '0',\n `label` varchar(200) CHARACTER SET utf8 DEFAULT NULL,\n `title` varchar(100) CHARACTER SET utf8 DEFAULT NULL,\n `description` varchar(500) CHARACTER SET utf8 DEFAULT NULL,\n `url` varchar(150) CHARACTER SET utf8 DEFAULT NULL,\n `wid` int(11) DEFAULT '0',\n `shopid` int(11) NOT NULL DEFAULT '0',\n `fromusername` varchar(32) CHARACTER SET utf8 DEFAULT NULL,\n `tousername` varchar(32) CHARACTER SET utf8 DEFAULT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4","sky_weixin_sucai":"CREATE TABLE `sky_weixin_sucai` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(50) CHARACTER SET utf8 DEFAULT NULL,\n `dateline` int(11) NOT NULL DEFAULT '0',\n `shopid` int(11) NOT NULL DEFAULT '0',\n `content` mediumtext CHARACTER SET utf8,\n `status` tinyint(4) NOT NULL DEFAULT '0',\n `pid` int(11) NOT NULL DEFAULT '0',\n `imgurl` varchar(225) CHARACTER SET utf8 DEFAULT '',\n `wid` int(11) NOT NULL DEFAULT '0',\n `userid` int(11) unsigned NOT NULL DEFAULT '0',\n `description` varchar(225) CHARACTER SET utf8 DEFAULT NULL,\n `linkurl` varchar(225) CHARACTER SET utf8 DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `shopid` (`shopid`),\n KEY `pid` (`pid`)\n) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4","sky_weixin_user":"CREATE TABLE `sky_weixin_user` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `openid` varchar(64) CHARACTER SET utf8 DEFAULT NULL,\n `dateline` int(11) NOT NULL DEFAULT '0',\n `add_time` int(11) DEFAULT NULL,\n `last_time` int(11) NOT NULL DEFAULT '0',\n `del_time` int(11) NOT NULL DEFAULT '0',\n `status` tinyint(4) NOT NULL DEFAULT '0',\n `nickname` varchar(32) CHARACTER SET utf8 DEFAULT NULL,\n `sex` tinyint(4) DEFAULT NULL,\n `city` varchar(12) CHARACTER SET utf8 DEFAULT NULL,\n `country` varchar(24) CHARACTER SET utf8 DEFAULT NULL,\n `province` varchar(12) CHARACTER SET utf8 DEFAULT NULL,\n `user_head` varchar(225) CHARACTER SET utf8 DEFAULT NULL,\n `update_time` int(11) DEFAULT '0',\n `reply_num` int(11) NOT NULL DEFAULT '0',\n `wid` int(11) NOT NULL DEFAULT '0',\n `shopid` int(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `openid` (`openid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"}
24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明
AI 解读 AI
登录后可用，每次 10 算力，解读结果公开显示在下面。
还没有人解读过这个文件。
微信安全登录