· 10 years ago · Sep 12, 2016, 05:36 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : localhost
5Source Server Version : 50715
6Source Host : localhost:3306
7Source Database : auth
8
9Target Server Type : MYSQL
10Target Server Version : 50715
11File Encoding : 65001
12
13Date: 2016-09-12 12:43:54
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for store_categories
20-- ----------------------------
21DROP TABLE IF EXISTS `store_categories`;
22CREATE TABLE `store_categories` (
23 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
24 `pid` int(11) unsigned NOT NULL,
25 `realm` json DEFAULT NULL,
26 `type` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
27 `return` tinyint(1) unsigned NOT NULL DEFAULT '1',
28 `index` tinyint(2) unsigned NOT NULL DEFAULT '1',
29 `sort` int(11) unsigned NOT NULL DEFAULT '0',
30 `enable` tinyint(1) unsigned NOT NULL DEFAULT '1',
31 PRIMARY KEY (`id`)
32) ENGINE=InnoDB AUTO_INCREMENT=230121 DEFAULT CHARSET=utf8;
33
34-- ----------------------------
35-- Records of store_categories
36-- ----------------------------
37INSERT INTO `store_categories` VALUES ('1', '0', '{\"ex\": [\"2\"], \"in\": \"all\"}', '0', '0', '1', '0', '1');
38INSERT INTO `store_categories` VALUES ('2', '0', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
39INSERT INTO `store_categories` VALUES ('3', '4', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
40INSERT INTO `store_categories` VALUES ('4', '1', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '0', '3', '1');
41INSERT INTO `store_categories` VALUES ('5', '1', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '0', '0', '1');
42INSERT INTO `store_categories` VALUES ('6', '5', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
43INSERT INTO `store_categories` VALUES ('7', '6', '{\"ex\": \"null\", \"in\": \"all\"}', '5', '0', '1', '0', '1');
44INSERT INTO `store_categories` VALUES ('8', '6', '{\"ex\": \"null\", \"in\": \"all\"}', '4', '0', '1', '0', '1');
45INSERT INTO `store_categories` VALUES ('9', '1', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '0', '0', '1');
46INSERT INTO `store_categories` VALUES ('10', '1', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '0', '0', '1');
47INSERT INTO `store_categories` VALUES ('11', '10', '{\"ex\": \"null\", \"in\": \"all\"}', '2', '0', '1', '0', '1');
48INSERT INTO `store_categories` VALUES ('12', '10', '{\"ex\": \"null\", \"in\": \"all\"}', '2', '0', '1', '0', '1');
49INSERT INTO `store_categories` VALUES ('13', '10', '{\"ex\": \"null\", \"in\": \"all\"}', '2', '0', '1', '0', '1');
50INSERT INTO `store_categories` VALUES ('14', '10', '{\"ex\": \"null\", \"in\": \"all\"}', '2', '0', '1', '0', '1');
51INSERT INTO `store_categories` VALUES ('15', '1', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '0', '0', '1');
52INSERT INTO `store_categories` VALUES ('16', '15', '{\"ex\": \"null\", \"in\": \"all\"}', '1', '0', '1', '0', '1');
53INSERT INTO `store_categories` VALUES ('17', '15', '{\"ex\": \"null\", \"in\": \"all\"}', '1', '0', '1', '0', '1');
54INSERT INTO `store_categories` VALUES ('18', '2', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '0', '1', '1');
55INSERT INTO `store_categories` VALUES ('19', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
56INSERT INTO `store_categories` VALUES ('20', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
57INSERT INTO `store_categories` VALUES ('21', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
58INSERT INTO `store_categories` VALUES ('22', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
59INSERT INTO `store_categories` VALUES ('23', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
60INSERT INTO `store_categories` VALUES ('24', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
61INSERT INTO `store_categories` VALUES ('25', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
62INSERT INTO `store_categories` VALUES ('26', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
63INSERT INTO `store_categories` VALUES ('27', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
64INSERT INTO `store_categories` VALUES ('28', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
65INSERT INTO `store_categories` VALUES ('29', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
66INSERT INTO `store_categories` VALUES ('30', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
67INSERT INTO `store_categories` VALUES ('31', '18', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
68INSERT INTO `store_categories` VALUES ('32', '2', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '0', '2', '1');
69INSERT INTO `store_categories` VALUES ('33', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
70INSERT INTO `store_categories` VALUES ('34', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
71INSERT INTO `store_categories` VALUES ('35', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
72INSERT INTO `store_categories` VALUES ('36', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
73INSERT INTO `store_categories` VALUES ('37', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
74INSERT INTO `store_categories` VALUES ('38', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
75INSERT INTO `store_categories` VALUES ('39', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
76INSERT INTO `store_categories` VALUES ('40', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
77INSERT INTO `store_categories` VALUES ('41', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
78INSERT INTO `store_categories` VALUES ('42', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
79INSERT INTO `store_categories` VALUES ('43', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
80INSERT INTO `store_categories` VALUES ('44', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
81INSERT INTO `store_categories` VALUES ('45', '32', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '1', '0', '1');
82INSERT INTO `store_categories` VALUES ('46', '2', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '0', '0', '1');
83INSERT INTO `store_categories` VALUES ('47', '2', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '1', '0', '0', '1');
84INSERT INTO `store_categories` VALUES ('48', '5', '{\"ex\": \"null\", \"in\": \"all\"}', '3', '1', '1', '0', '1');
85INSERT INTO `store_categories` VALUES ('230100', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
86INSERT INTO `store_categories` VALUES ('230101', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
87INSERT INTO `store_categories` VALUES ('230102', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
88INSERT INTO `store_categories` VALUES ('230103', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
89INSERT INTO `store_categories` VALUES ('230104', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
90INSERT INTO `store_categories` VALUES ('230105', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
91INSERT INTO `store_categories` VALUES ('230106', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
92INSERT INTO `store_categories` VALUES ('230107', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
93INSERT INTO `store_categories` VALUES ('230108', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
94INSERT INTO `store_categories` VALUES ('230109', '3', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
95INSERT INTO `store_categories` VALUES ('230110', '4', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
96INSERT INTO `store_categories` VALUES ('230111', '4', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
97INSERT INTO `store_categories` VALUES ('230112', '5', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
98INSERT INTO `store_categories` VALUES ('230113', '5', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
99INSERT INTO `store_categories` VALUES ('230114', '5', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
100INSERT INTO `store_categories` VALUES ('230115', '9', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
101INSERT INTO `store_categories` VALUES ('230116', '9', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
102INSERT INTO `store_categories` VALUES ('230117', '9', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '1', '0', '1');
103INSERT INTO `store_categories` VALUES ('230118', '1', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '0', '0', '1');
104INSERT INTO `store_categories` VALUES ('230119', '1', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '0', '0', '1');
105INSERT INTO `store_categories` VALUES ('230120', '1', '{\"ex\": \"null\", \"in\": \"all\"}', '0', '0', '0', '0', '1');
106SET FOREIGN_KEY_CHECKS=1;