· 9 years ago · Nov 09, 2016, 08:14 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : auth
5Source Server Version : 50541
6Source Host : 178.218.223.206:5876
7Source Database : auth_bnet
8
9Target Server Type : MYSQL
10Target Server Version : 50541
11File Encoding : 65001
12
13Date: 2016-11-09 17:17:24
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 `type` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
26 `return` tinyint(1) unsigned NOT NULL DEFAULT '1',
27 `index` tinyint(2) unsigned NOT NULL DEFAULT '1',
28 `sort` int(11) unsigned NOT NULL DEFAULT '0',
29 `enable` tinyint(1) unsigned NOT NULL DEFAULT '1',
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=230121 DEFAULT CHARSET=utf8;
32
33-- ----------------------------
34-- Records of store_categories
35-- ----------------------------
36INSERT INTO `store_categories` VALUES ('3', '4', '0', '0', '0', '0', '1');
37INSERT INTO `store_categories` VALUES ('4', '0', '0', '0', '0', '3', '1');
38INSERT INTO `store_categories` VALUES ('5', '0', '0', '0', '0', '0', '1');
39INSERT INTO `store_categories` VALUES ('6', '5', '0', '0', '0', '0', '1');
40INSERT INTO `store_categories` VALUES ('7', '0', '0', '0', '0', '0', '1');
41INSERT INTO `store_categories` VALUES ('8', '0', '0', '0', '0', '0', '1');
42INSERT INTO `store_categories` VALUES ('9', '0', '0', '0', '0', '0', '1');
43INSERT INTO `store_categories` VALUES ('10', '2', '0', '0', '0', '0', '1');
44INSERT INTO `store_categories` VALUES ('11', '2', '0', '0', '0', '2', '1');
45INSERT INTO `store_categories` VALUES ('12', '8', '2', '0', '0', '0', '1');
46INSERT INTO `store_categories` VALUES ('13', '8', '2', '0', '0', '0', '1');
47INSERT INTO `store_categories` VALUES ('14', '8', '2', '0', '0', '0', '1');
48INSERT INTO `store_categories` VALUES ('15', '8', '2', '0', '0', '0', '1');
49INSERT INTO `store_categories` VALUES ('16', '9', '0', '0', '0', '0', '1');
50INSERT INTO `store_categories` VALUES ('17', '9', '0', '0', '0', '0', '1');
51INSERT INTO `store_categories` VALUES ('230100', '3', '0', '0', '0', '0', '1');
52INSERT INTO `store_categories` VALUES ('230101', '3', '0', '0', '0', '0', '1');
53INSERT INTO `store_categories` VALUES ('230102', '3', '0', '0', '0', '0', '1');
54INSERT INTO `store_categories` VALUES ('230103', '3', '0', '0', '0', '0', '1');
55INSERT INTO `store_categories` VALUES ('230104', '3', '0', '0', '0', '0', '1');
56INSERT INTO `store_categories` VALUES ('230105', '3', '0', '0', '0', '0', '1');
57INSERT INTO `store_categories` VALUES ('230106', '3', '0', '0', '0', '0', '1');
58INSERT INTO `store_categories` VALUES ('230107', '3', '0', '0', '0', '0', '1');
59INSERT INTO `store_categories` VALUES ('230108', '3', '0', '0', '0', '0', '1');
60INSERT INTO `store_categories` VALUES ('230109', '3', '0', '0', '0', '0', '1');
61INSERT INTO `store_categories` VALUES ('230110', '4', '0', '0', '0', '0', '1');
62INSERT INTO `store_categories` VALUES ('230111', '4', '0', '0', '0', '0', '1');
63INSERT INTO `store_categories` VALUES ('230112', '5', '0', '0', '0', '0', '1');
64INSERT INTO `store_categories` VALUES ('230113', '5', '0', '0', '0', '0', '1');
65INSERT INTO `store_categories` VALUES ('230114', '5', '0', '0', '0', '0', '1');
66INSERT INTO `store_categories` VALUES ('230115', '7', '0', '0', '0', '0', '1');
67INSERT INTO `store_categories` VALUES ('230116', '7', '0', '0', '0', '0', '1');
68INSERT INTO `store_categories` VALUES ('230117', '7', '0', '0', '0', '0', '1');
69INSERT INTO `store_categories` VALUES ('230118', '0', '0', '0', '0', '0', '1');
70INSERT INTO `store_categories` VALUES ('230119', '0', '0', '0', '0', '0', '1');
71INSERT INTO `store_categories` VALUES ('230120', '0', '0', '0', '0', '0', '1');
72INSERT INTO `store_categories` VALUES ('230121', '5', '3', '0', '0', '0', '1');
73INSERT INTO `store_categories` VALUES ('230122', '0', '0', '0', '0', '0', '1');
74INSERT INTO `store_categories` VALUES ('230123', '0', '0', '0', '0', '0', '1');
75INSERT INTO `store_categories` VALUES ('230124', '6', '5', '0', '0', '0', '1');
76INSERT INTO `store_categories` VALUES ('230125', '6', '4', '0', '0', '0', '1');
77INSERT INTO `store_categories` VALUES ('230126', '10', '0', '0', '0', '0', '1');
78INSERT INTO `store_categories` VALUES ('230127', '10', '0', '0', '0', '0', '1');
79INSERT INTO `store_categories` VALUES ('230128', '10', '0', '0', '0', '0', '1');
80INSERT INTO `store_categories` VALUES ('230129', '10', '0', '0', '0', '0', '1');
81INSERT INTO `store_categories` VALUES ('230130', '10', '0', '0', '0', '0', '1');
82INSERT INTO `store_categories` VALUES ('230131', '10', '0', '0', '0', '0', '1');
83INSERT INTO `store_categories` VALUES ('230132', '10', '0', '0', '0', '0', '1');
84INSERT INTO `store_categories` VALUES ('230133', '10', '0', '0', '0', '0', '1');
85INSERT INTO `store_categories` VALUES ('230134', '10', '0', '0', '0', '0', '1');
86INSERT INTO `store_categories` VALUES ('230135', '10', '0', '0', '0', '0', '1');
87INSERT INTO `store_categories` VALUES ('230136', '10', '0', '0', '0', '0', '1');
88INSERT INTO `store_categories` VALUES ('230137', '10', '0', '0', '0', '0', '1');
89INSERT INTO `store_categories` VALUES ('230138', '11', '0', '0', '0', '0', '1');
90INSERT INTO `store_categories` VALUES ('230139', '11', '0', '0', '0', '0', '1');
91INSERT INTO `store_categories` VALUES ('230140', '11', '0', '0', '0', '0', '1');
92INSERT INTO `store_categories` VALUES ('230141', '11', '0', '0', '0', '0', '1');
93INSERT INTO `store_categories` VALUES ('230142', '11', '0', '0', '0', '0', '1');
94INSERT INTO `store_categories` VALUES ('230143', '11', '0', '0', '0', '0', '1');
95INSERT INTO `store_categories` VALUES ('230144', '11', '0', '0', '0', '0', '1');
96INSERT INTO `store_categories` VALUES ('230145', '11', '0', '0', '0', '0', '1');
97INSERT INTO `store_categories` VALUES ('230146', '11', '0', '0', '0', '0', '1');
98INSERT INTO `store_categories` VALUES ('230147', '11', '0', '0', '0', '0', '1');
99INSERT INTO `store_categories` VALUES ('230148', '11', '0', '0', '0', '0', '1');
100INSERT INTO `store_categories` VALUES ('230149', '11', '0', '0', '0', '0', '1');
101SET FOREIGN_KEY_CHECKS=1;