-
Notifications
You must be signed in to change notification settings - Fork 5
/
test.sql
226 lines (203 loc) · 63.5 KB
/
test.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
/*
Navicat MySQL Data Transfer
Source Database : test
Target Server Version : 50615
File Encoding : utf-8
Date: 12/20/2016 20:26:48 PM
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `admin_access`
-- ----------------------------
DROP TABLE IF EXISTS `admin_access`;
CREATE TABLE `admin_access` (
`role_id` smallint(6) unsigned NOT NULL COMMENT '角色id',
`node_id` smallint(6) unsigned NOT NULL COMMENT '节点id',
`level` tinyint(1) NOT NULL COMMENT '1:app,2:action,3:function',
`pid` smallint(6) NOT NULL COMMENT '父节点',
`module` varchar(50) DEFAULT NULL,
KEY `groupId` (`role_id`),
KEY `nodeId` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色节点访问权限表';
-- ----------------------------
-- Records of `admin_access`
-- ----------------------------
BEGIN;
INSERT INTO `admin_access` VALUES ('1', '6', '2', '1', ''), ('1', '5', '2', '1', ''), ('1', '4', '2', '1', ''), ('1', '3', '2', '1', ''), ('1', '2', '2', '1', ''), ('1', '1', '1', '0', ''), ('2', '7', '3', '1', null), ('2', '423', '2', '1', null), ('2', '54', '3', '9', null), ('2', '56', '3', '9', null), ('2', '53', '3', '9', null), ('2', '52', '3', '9', null), ('2', '51', '3', '9', null), ('2', '50', '3', '9', null), ('2', '49', '3', '9', null), ('2', '199', '3', '9', null), ('2', '29', '3', '11', ''), ('2', '37', '3', '12', ''), ('2', '185', '3', '5', null), ('2', '186', '3', '5', null), ('2', '187', '3', '5', null), ('2', '188', '3', '5', null), ('2', '75', '3', '65', ''), ('2', '189', '3', '5', null), ('2', '477', '2', '1', null), ('2', '485', '2', '1', null), ('2', '487', '2', '1', null), ('2', '531', '2', '1', null), ('3', '1', '1', '0', null), ('7', '485', '2', '1', null), ('3', '96', '3', '7', null), ('2', '190', '3', '5', null), ('2', '506', '3', '5', null), ('2', '197', '3', '5', null), ('2', '191', '3', '6', null), ('2', '192', '3', '6', null), ('2', '193', '3', '6', null), ('2', '194', '3', '6', null), ('2', '195', '3', '6', null), ('2', '196', '3', '6', null), ('2', '55', '3', '9', null), ('2', '665', '2', '1', null), ('2', '207', '3', '206', null), ('2', '208', '3', '206', null), ('2', '209', '3', '206', null), ('2', '210', '3', '206', null), ('2', '211', '3', '206', null), ('2', '212', '3', '206', null), ('2', '213', '3', '206', null), ('2', '214', '3', '206', null), ('2', '215', '3', '206', null), ('2', '525', '2', '1', null), ('2', '479', '2', '1', null), ('2', '661', '2', '1', null), ('2', '651', '2', '1', null), ('2', '330', '2', '1', null), ('2', '308', '2', '1', null), ('2', '624', '2', '1', null), ('2', '660', '2', '1', null), ('2', '436', '2', '1', null), ('2', '491', '2', '1', null), ('2', '527', '2', '1', null), ('2', '481', '2', '1', null), ('2', '567', '2', '1', null), ('2', '572', '2', '1', null), ('2', '590', '2', '1', null), ('2', '280', '2', '1', null), ('2', '657', '2', '1', null), ('2', '636', '2', '1', null), ('2', '635', '2', '1', null), ('2', '611', '2', '1', null), ('2', '537', '2', '1', null), ('2', '600', '2', '1', null), ('2', '377', '2', '1', null), ('2', '354', '2', '1', null), ('2', '366', '2', '1', null), ('2', '341', '2', '1', null), ('2', '551', '2', '1', null), ('2', '495', '2', '1', null), ('2', '654', '2', '1', null), ('2', '644', '2', '1', null), ('3', '423', '2', '1', null), ('3', '477', '2', '1', null), ('3', '485', '2', '1', null), ('3', '487', '2', '1', null), ('3', '531', '2', '1', null), ('3', '665', '2', '1', null), ('3', '525', '2', '1', null), ('3', '479', '2', '1', null), ('3', '330', '2', '1', null), ('3', '308', '2', '1', null), ('4', '1', '1', '0', null), ('4', '423', '2', '1', null), ('4', '477', '2', '1', null), ('4', '485', '2', '1', null), ('4', '487', '2', '1', null), ('4', '531', '2', '1', null), ('4', '525', '2', '1', null), ('4', '479', '2', '1', null), ('4', '330', '2', '1', null), ('4', '308', '2', '1', null), ('4', '624', '2', '1', null), ('2', '613', '3', '611', null), ('4', '660', '2', '1', null), ('4', '436', '2', '1', null), ('4', '491', '2', '1', null), ('4', '527', '2', '1', null), ('4', '481', '2', '1', null), ('4', '567', '2', '1', null), ('2', '629', '2', '1', null), ('4', '280', '2', '1', null), ('2', '578', '2', '1', null), ('2', '577', '2', '1', null), ('2', '493', '2', '1', null), ('2', '234', '3', '233', null), ('2', '235', '3', '233', null), ('2', '236', '3', '233', null), ('2', '237', '3', '233', null), ('2', '238', '3', '233', null), ('2', '239', '3', '233', null), ('2', '240', '3', '233', null), ('2', '241', '3', '233', null), ('2', '217', '3', '216', null), ('2', '218', '3', '216', null), ('2', '219', '3', '216', null), ('2', '220', '3', '216', null), ('2', '221', '3', '216', null), ('2', '222', '3', '216', null), ('2', '223', '3', '216', null), ('2', '224', '3', '216', null), ('2', '468', '3', '467', null), ('2', '469', '3', '467', null), ('2', '470', '3', '467', null), ('2', '471', '3', '467', null), ('2', '472', '3', '467', null), ('2', '473', '3', '467', null), ('2', '474', '3', '467', null), ('2', '475', '3', '467', null), ('2', '476', '3', '467', null), ('2', '244', '3', '242', null), ('2', '245', '3', '242', null), ('2', '246', '3', '242', null), ('2', '247', '3', '242', null), ('2', '248', '3', '242', null), ('2', '249', '3', '242', null), ('2', '250', '3', '242', null), ('2', '251', '3', '242', null), ('2', '252', '3', '242', null), ('2', '262', '3', '242', null), ('2', '243', '3', '242', null), ('2', '226', '3', '225', null), ('2', '227', '3', '225', null), ('2', '228', '3', '225', null), ('2', '229', '3', '225', null), ('2', '230', '3', '225', null), ('2', '231', '3', '225', null), ('2', '232', '3', '225', null), ('2', '302', '3', '301', null), ('2', '303', '3', '301', null), ('2', '304', '3', '301', null), ('2', '305', '3', '301', null), ('2', '306', '3', '301', null), ('2', '307', '3', '301', null), ('2', '286', '3', '285', null), ('2', '287', '3', '285', null), ('2', '288', '3', '285', null), ('2', '289', '3', '285', null), ('2', '290', '3', '285', null), ('2', '291', '3', '285', null), ('2', '322', '3', '321', null), ('2', '323', '3', '321', null), ('2', '324', '3', '321', null), ('2', '325', '3', '321', null), ('2', '326', '3', '321', null), ('2', '327', '3', '321', null), ('2', '328', '3', '321', null), ('2', '329', '3', '321', null), ('2', '274', '3', '273', null), ('2', '275', '3', '273', null), ('2', '276', '3', '273', null), ('2', '277', '3', '273', null), ('2', '278', '3', '273', null), ('2', '279', '3', '273', null), ('2', '442', '3', '441', null), ('2', '452', '3', '441', null), ('2', '451', '3', '441', null), ('2', '450', '3', '441', null), ('2', '449', '3', '441', null), ('2', '448', '3', '441', null), ('2', '447', '3', '441', null), ('2', '446', '3', '441', null), ('2', '445', '3', '441', null), ('2', '444', '3', '441', null), ('2', '443', '3', '441', null), ('2', '453', '3', '441', null), ('2', '455', '3', '454', null), ('2', '463', '3', '454', null), ('2', '462', '3', '454', null), ('2', '461', '3', '454', null), ('2', '460', '3', '454', null), ('2', '459', '3', '454', null), ('2', '458', '3', '454', null), ('2', '457', '3', '454', null), ('2', '456', '3', '454', null), ('2', '464', '3', '454', null), ('2', '428', '3', '427', null), ('2', '429', '3', '427', null), ('2', '430', '3', '427', null), ('2', '431', '3', '427', null), ('2', '432', '3', '427', null), ('2', '433', '3', '427', null), ('2', '434', '3', '427', null), ('2', '435', '3', '427', null), ('2', '550', '3', '420', null), ('2', '389', '3', '388', null), ('2', '397', '3', '388', null), ('2', '396', '3', '388', null), ('2', '395', '3', '388', null), ('2', '394', '3', '388', null), ('2', '393', '3', '388', null), ('2', '392', '3', '388', null), ('2', '391', '3', '388', null), ('2', '390', '3', '388', null), ('2', '398', '3', '388', null), ('2', '400', '3', '399', null), ('2', '408', '3', '399', null), ('2', '407', '3', '399', null), ('2', '406', '3', '399', null), ('2', '405', '3', '399', null), ('2', '404', '3', '399', null), ('2', '403', '3', '399', null), ('2', '402', '3', '399', null), ('2', '401', '3', '399', null), ('2', '409', '3', '399', null), ('2', '265', '3', '263', null), ('2', '266', '3', '263', null), ('2', '267', '3', '263', null), ('2', '268', '3', '263', null), ('2', '269', '3', '263', null), ('2', '270', '3', '263', null), ('2', '271', '3', '263', null), ('2', '272', '3', '263', null), ('2', '264', '3', '263', null), ('2', '254', '3', '253', null), ('2', '255', '3', '253', null), ('2', '256', '3', '253', null), ('2', '257', '3', '253', null), ('2', '258', '3', '253', null), ('2', '259', '3', '253', null), ('2', '260', '3', '253', null), ('2', '261', '3', '253', null), ('2', '466', '3', '292', null), ('2', '465', '3', '292', null), ('2', '299', '3', '292', null), ('2', '298', '3', '292', null), ('2', '553', '3', '292', null), ('2', '300', '3', '292', null), ('2', '554', '3', '292', null), ('2', '524', '3', '292', null), ('2', '297', '3', '292', null), ('2', '296', '3', '292', null), ('2', '598', '3', '493', null), ('2', '496', '3', '495', null), ('2', '342', '3', '341', null), ('2', '351', '3', '341', null), ('2', '350', '3', '341', null), ('2', '349', '3', '341', null), ('2', '348', '3', '341', null), ('2', '347', '3', '341', null), ('2', '346', '3', '341', null), ('2', '345', '3', '341', null), ('2', '344', '3', '341', null), ('2', '343', '3', '341', null), ('2', '352', '3', '341', null), ('2', '367', '3', '366', null), ('2', '375', '3', '366', null), ('2', '374', '3', '366', null), ('2', '373', '3', '366', null), ('2', '372', '3', '366', null), ('2', '371', '3', '366', null), ('2', '370', '3', '366', null), ('2', '369', '3', '366', null), ('2', '368', '3', '366', null), ('2', '376', '3', '366', null), ('2', '355', '3', '354', null), ('2', '364', '3', '354', null), ('2', '363', '3', '354', null), ('2', '362', '3', '354', null), ('2', '361', '3', '354', null), ('2', '360', '3', '354', null), ('2', '359', '3', '354', null), ('2', '358', '3', '354', null), ('2', '357', '3', '354', null), ('2', '356', '3', '354', null), ('2', '365', '3', '354', null), ('2', '378', '3', '377', null), ('2', '386', '3', '377', null), ('2', '385', '3', '377', null), ('2', '384', '3', '377', null), ('2', '383', '3', '377', null), ('2', '382', '3', '377', null), ('2', '381', '3', '377', null), ('2', '380', '3', '377', null), ('2', '379', '3', '377', null), ('2', '387', '3', '377', null), ('2', '652', '3', '280', null), ('2', '512', '3', '280', null), ('2', '511', '3', '280', null), ('2', '484', '3', '280', null), ('2', '483', '3', '280', null), ('2', '426', '3', '280', null), ('2', '284', '3', '280', null), ('2', '508', '3', '481', null), ('2', '492', '3', '491', null), ('2', '440', '3', '436', null), ('2', '439', '3', '436', null), ('2', '438', '3', '436', null), ('2', '437', '3', '436', null), ('2', '310', '3', '308', null), ('2', '311', '3', '308', null), ('2', '312', '3', '308', null), ('2', '313', '3', '308', null), ('2', '314', '3', '308', null), ('2', '315', '3', '308', null), ('2', '316', '3', '308', null), ('2', '317', '3', '308', null), ('2', '318', '3', '308', null), ('2', '319', '3', '308', null), ('2', '320', '3', '308', null), ('2', '309', '3', '308', null), ('2', '331', '3', '330', null), ('2', '339', '3', '330', null), ('2', '338', '3', '330', null), ('2', '337', '3', '330', null), ('2', '336', '3', '330', null), ('2', '335', '3', '330', null), ('2', '334', '3', '330', null), ('2', '333', '3', '330', null), ('2', '332', '3', '330', null), ('2', '340', '3', '330', null), ('2', '520', '3', '479', null), ('2', '521', '3', '487', null), ('2', '490', '3', '487', null), ('2', '489', '3', '487', null), ('2', '522', '3', '485', null), ('2', '585', '3', '477', null), ('2', '424', '3', '423', null), ('2', '425', '3', '423', null), ('2', '411', '3', '410', null), ('2', '412', '3', '410', null), ('2', '413', '3', '410', null), ('2', '414', '3', '410', null), ('2', '415', '3', '410', null), ('2', '416', '3', '410', null), ('2', '417', '3', '410', null), ('2', '418', '3', '410', null), ('2', '419', '3', '410', null), ('2', '283', '3', '280', null), ('4', '484', '3', '280', null), ('6', '614', '3', '242', null), ('4', '243', '3', '242', null), ('4', '612', '3', '611', null), ('5', '612', '3', '611', null), ('2', '198', '3', '5', null), ('2', '184', '3', '5', null), ('2', '597', '3', '493', null), ('2', '482', '3', '481', null), ('2', '295', '3', '292', null), ('2', '510', '3', '481', null), ('2', '282', '3', '280', null), ('2', '534', '3', '280', null), ('2', '513', '3', '308', null), ('2', '519', '3', '479', null), ('2', '518', '3', '479', null), ('2', '517', '3', '479', null), ('2', '516', '3', '479', null), ('2', '515', '3', '479', null), ('2', '514', '3', '479', null), ('2', '480', '3', '479', null), ('2', '488', '3', '487', null), ('2', '523', '3', '436', null), ('2', '486', '3', '485', null), ('2', '294', '3', '292', null), ('2', '292', '2', '1', null), ('2', '646', '3', '525', null), ('2', '253', '2', '1', null), ('2', '528', '3', '527', null), ('2', '529', '3', '527', null), ('2', '647', '3', '525', null), ('2', '263', '2', '1', null), ('2', '532', '3', '531', null), ('2', '533', '3', '531', null), ('2', '546', '3', '280', null), ('2', '535', '3', '487', null), ('2', '536', '3', '487', null), ('2', '399', '2', '1', null), ('2', '539', '3', '537', null), ('2', '540', '3', '537', null), ('2', '541', '3', '537', null), ('2', '542', '3', '537', null), ('2', '543', '3', '537', null), ('2', '544', '3', '537', null), ('2', '545', '3', '537', null), ('2', '599', '3', '537', null), ('2', '610', '3', '280', null), ('3', '624', '2', '1', null), ('3', '660', '2', '1', null), ('3', '436', '2', '1', null), ('3', '491', '2', '1', null), ('3', '527', '2', '1', null), ('3', '481', '2', '1', null), ('3', '567', '2', '1', null), ('3', '572', '2', '1', null), ('3', '590', '2', '1', null), ('3', '280', '2', '1', null), ('3', '657', '2', '1', null), ('3', '636', '2', '1', null), ('3', '635', '2', '1', null), ('3', '611', '2', '1', null), ('3', '537', '2', '1', null), ('3', '600', '2', '1', null), ('3', '377', '2', '1', null), ('3', '354', '2', '1', null), ('3', '366', '2', '1', null), ('3', '341', '2', '1', null), ('3', '495', '2', '1', null), ('3', '654', '2', '1', null), ('3', '644', '2', '1', null), ('3', '184', '3', '5', null), ('3', '198', '3', '5', null), ('3', '197', '3', '5', null), ('3', '190', '3', '5', null), ('3', '189', '3', '5', null), ('3', '188', '3', '5', null), ('3', '187', '3', '5', null), ('3', '186', '3', '5', null), ('3', '185', '3', '5', null), ('3', '506', '3', '5', null), ('3', '234', '3', '233', null), ('3', '217', '3', '216', null), ('3', '468', '3', '467', null), ('3', '243', '3', '242', null), ('3', '226', '3', '225', null), ('3', '227', '3', '225', null), ('3', '228', '3', '225', null), ('3', '229', '3', '225', null), ('3', '230', '3', '225', null), ('3', '231', '3', '225', null), ('3', '232', '3', '225', null), ('3', '302', '3', '301', null), ('3', '286', '3', '285', null), ('3', '322', '3', '321', null), ('3', '323', '3', '321', null), ('3', '324', '3', '321', null), ('3', '325', '3', '321', null), ('3', '326', '3', '321', null), ('3', '327', '3', '321', null), ('3', '328', '3', '321', null), ('3', '329', '3', '321', null), ('3', '274', '3', '273', null), ('3', '428', '3', '427', null), ('3', '429', '3', '427', null), ('3', '430', '3', '427', null), ('3', '431', '3', '427', null), ('3', '432', '3', '427', null), ('3', '433', '3', '427', null), ('3', '434', '3', '427', null), ('3', '435', '3', '427', null), ('3', '293', '3', '292', null), ('3', '496', '3', '495', null), ('3', '342', '3', '341', null), ('3', '367', '3', '366', null), ('3', '355', '3', '354', null), ('3', '378', '3', '377', null), ('3', '541', '3', '537', null), ('3', '542', '3', '537', null), ('3', '543', '3', '537', null), ('3', '544', '3', '537', null), ('3', '545', '3', '537', null), ('3', '599', '3', '537', null), ('3', '602', '3', '537', null), ('3', '603', '3', '537', null), ('3', '484', '3', '280', null), ('3', '483', '3', '280', null), ('3', '426', '3', '280', null), ('3', '282', '3', '280', null), ('3', '534', '3', '280', null), ('3', '546', '3', '280', null), ('3', '620', '3', '280', null), ('3', '482', '3', '481', null), ('3', '510', '3', '481', null), ('3', '528', '3', '527', null), ('3', '529', '3', '527', null), ('3', '492', '3', '491', null), ('2', '634', '3', '280', null), ('6', '672', '3', '657', null), ('6', '243', '3', '242', null), ('4', '657', '2', '1', null), ('4', '636', '2', '1', null), ('5', '410', '2', '1', null), ('3', '437', '3', '436', null), ('3', '438', '3', '436', null), ('3', '439', '3', '436', null), ('3', '440', '3', '436', null), ('3', '523', '3', '436', null), ('3', '309', '3', '308', null), ('3', '331', '3', '330', null), ('3', '480', '3', '479', null), ('3', '514', '3', '479', null), ('3', '515', '3', '479', null), ('3', '516', '3', '479', null), ('3', '648', '3', '525', null), ('3', '649', '3', '525', null), ('3', '532', '3', '531', null), ('3', '533', '3', '531', null), ('3', '488', '3', '487', null), ('3', '521', '3', '487', null), ('3', '486', '3', '485', null), ('3', '522', '3', '485', null), ('3', '478', '3', '477', null), ('3', '424', '3', '423', null), ('3', '425', '3', '423', null), ('3', '411', '3', '410', null), ('3', '412', '3', '410', null), ('3', '413', '3', '410', null), ('3', '414', '3', '410', null), ('3', '415', '3', '410', null), ('3', '416', '3', '410', null), ('3', '417', '3', '410', null), ('3', '418', '3', '410', null), ('3', '419', '3', '410', null), ('4', '635', '2', '1', null), ('4', '611', '2', '1', null), ('4', '96', '3', '7', null), ('4', '293', '3', '292', null), ('4', '496', '3', '495', null), ('4', '541', '3', '537', null), ('4', '542', '3', '537', null), ('4', '543', '3', '537', null), ('4', '545', '3', '537', null), ('4', '599', '3', '537', null), ('4', '602', '3', '537', null), ('4', '603', '3', '537', null), ('4', '546', '3', '280', null), ('4', '610', '3', '280', null), ('4', '634', '3', '280', null), ('4', '482', '3', '481', null), ('4', '510', '3', '481', null), ('4', '528', '3', '527', null), ('4', '529', '3', '527', null), ('4', '492', '3', '491', null), ('2', '623', '3', '280', null), ('7', '614', '3', '242', null), ('6', '423', '2', '1', null), ('3', '614', '3', '242', null), ('6', '612', '3', '611', null), ('3', '613', '3', '611', null), ('4', '437', '3', '436', null), ('4', '438', '3', '436', null), ('4', '439', '3', '436', null), ('4', '440', '3', '436', null), ('4', '523', '3', '436', null), ('4', '309', '3', '308', null), ('4', '331', '3', '330', null), ('4', '480', '3', '479', null), ('4', '514', '3', '479', null), ('4', '515', '3', '479', null), ('4', '516', '3', '479', null), ('4', '526', '3', '525', null), ('4', '530', '3', '525', null), ('4', '532', '3', '531', null), ('4', '533', '3', '531', null), ('4', '488', '3', '487', null), ('4', '521', '3', '487', null), ('4', '486', '3', '485', null), ('4', '522', '3', '485', null), ('4', '478', '3', '477', null), ('4', '424', '3', '423', null), ('4', '425', '3', '423', null), ('4', '411', '3', '410', null), ('5', '1', '1', '0', null), ('2', '388', '2', '1', null), ('5', '423', '2', '1', null), ('5', '477', '2', '1', null), ('5', '485', '2', '1', null), ('5', '487', '2', '1', null), ('5', '531', '2', '1', null), ('5', '665', '2', '1', null), ('5', '525', '2', '1', null), ('5', '479', '2', '1', null), ('5', '661', '2', '1', null), ('5', '651', '2', '1', null), ('2', '612', '3', '611', null), ('5', '330', '2', '1', null), ('5', '308', '2', '1', null), ('5', '624', '2', '1', null), ('5', '660', '2', '1', null), ('5', '436', '2', '1', null), ('5', '491', '2', '1', null), ('5', '527', '2', '1', null), ('5', '481', '2', '1', null), ('5', '572', '2', '1', null), ('5', '590', '2', '1', null), ('5', '280', '2', '1', null), ('5', '657', '2', '1', null), ('5', '636', '2', '1', null), ('5', '635', '2', '1', null), ('5', '611', '2', '1', null), ('5', '537', '2', '1', null), ('5', '600', '2', '1', null), ('5', '377', '2', '1', null), ('5', '354', '2', '1', null), ('5', '366', '2', '1', null), ('5', '341', '2', '1', null), ('5', '495', '2', '1', null), ('5', '96', '3', '7', null), ('5', '184', '3', '5', null), ('5', '198', '3', '5', null), ('5', '197', '3', '5', null), ('5', '190', '3', '5', null), ('5', '189', '3', '5', null), ('5', '188', '3', '5', null), ('5', '187', '3', '5', null), ('5', '186', '3', '5', null), ('5', '185', '3', '5', null), ('5', '506', '3', '5', null), ('5', '217', '3', '216', null), ('5', '218', '3', '216', null), ('5', '219', '3', '216', null), ('5', '220', '3', '216', null), ('5', '221', '3', '216', null), ('5', '222', '3', '216', null), ('5', '223', '3', '216', null), ('5', '224', '3', '216', null), ('5', '468', '3', '467', null), ('5', '469', '3', '467', null), ('5', '470', '3', '467', null), ('5', '471', '3', '467', null), ('5', '472', '3', '467', null), ('5', '473', '3', '467', null), ('5', '474', '3', '467', null), ('5', '475', '3', '467', null), ('5', '476', '3', '467', null), ('5', '674', '3', '242', null), ('5', '244', '3', '242', null), ('5', '245', '3', '242', null), ('5', '246', '3', '242', null), ('5', '247', '3', '242', null), ('5', '248', '3', '242', null), ('5', '249', '3', '242', null), ('5', '250', '3', '242', null), ('5', '251', '3', '242', null), ('5', '252', '3', '242', null), ('5', '262', '3', '242', null), ('5', '226', '3', '225', null), ('5', '227', '3', '225', null), ('5', '228', '3', '225', null), ('5', '229', '3', '225', null), ('5', '230', '3', '225', null), ('5', '231', '3', '225', null), ('5', '232', '3', '225', null), ('5', '302', '3', '301', null), ('5', '303', '3', '301', null), ('5', '304', '3', '301', null), ('5', '305', '3', '301', null), ('5', '306', '3', '301', null), ('5', '307', '3', '301', null), ('5', '286', '3', '285', null), ('5', '287', '3', '285', null), ('5', '288', '3', '285', null), ('5', '289', '3', '285', null), ('5', '290', '3', '285', null), ('5', '291', '3', '285', null), ('5', '322', '3', '321', null), ('5', '323', '3', '321', null), ('5', '324', '3', '321', null), ('5', '325', '3', '321', null), ('5', '326', '3', '321', null), ('5', '327', '3', '321', null), ('5', '328', '3', '321', null), ('5', '329', '3', '321', null), ('5', '274', '3', '273', null), ('5', '275', '3', '273', null), ('5', '276', '3', '273', null), ('5', '277', '3', '273', null), ('5', '278', '3', '273', null), ('5', '279', '3', '273', null), ('5', '428', '3', '427', null), ('5', '429', '3', '427', null), ('5', '430', '3', '427', null), ('5', '431', '3', '427', null), ('5', '432', '3', '427', null), ('5', '433', '3', '427', null), ('5', '434', '3', '427', null), ('5', '435', '3', '427', null), ('5', '293', '3', '292', null), ('5', '299', '3', '292', null), ('5', '298', '3', '292', null), ('5', '297', '3', '292', null), ('5', '296', '3', '292', null), ('5', '524', '3', '292', null), ('5', '496', '3', '495', null), ('5', '342', '3', '341', null), ('5', '351', '3', '341', null), ('5', '350', '3', '341', null), ('5', '349', '3', '341', null), ('5', '348', '3', '341', null), ('5', '347', '3', '341', null), ('5', '346', '3', '341', null), ('5', '345', '3', '341', null), ('5', '344', '3', '341', null), ('5', '343', '3', '341', null), ('5', '352', '3', '341', null), ('5', '367', '3', '366', null), ('5', '375', '3', '366', null), ('5', '374', '3', '366', null), ('5', '373', '3', '366', null), ('5', '372', '3', '366', null), ('5', '371', '3', '366', null), ('5', '370', '3', '366', null), ('5', '369', '3', '366', null), ('5', '368', '3', '366', null), ('5', '376', '3', '366', null), ('5', '355', '3', '354', null), ('5', '364', '3', '354', null), ('5', '363', '3', '354', null), ('5', '362', '3', '354', null), ('5', '361', '3', '354', null), ('5', '360', '3', '354', null), ('5', '359', '3', '354', null), ('5', '358', '3', '354', null), ('5', '357', '3', '354', null), ('5', '356', '3', '354', null), ('5', '365', '3', '354', null), ('5', '378', '3', '377', null), ('5', '386', '3', '377', null), ('5', '385', '3', '377', null), ('5', '384', '3', '377', null), ('5', '383', '3', '377', null), ('5', '382', '3', '377', null), ('5', '381', '3', '377', null), ('5', '380', '3', '377', null), ('5', '379', '3', '377', null), ('5', '387', '3', '377', null), ('5', '541', '3', '537', null), ('5', '545', '3', '537', null), ('5', '599', '3', '537', null), ('5', '512', '3', '280', null), ('5', '511', '3', '280', null), ('5', '484', '3', '280', null), ('5', '483', '3', '280', null), ('5', '426', '3', '280', null), ('5', '284', '3', '280', null), ('5', '283', '3', '280', null), ('5', '282', '3', '280', null), ('5', '534', '3', '280', null), ('5', '546', '3', '280', null), ('5', '610', '3', '280', null), ('5', '482', '3', '481', null), ('5', '510', '3', '481', null), ('5', '528', '3', '527', null), ('5', '529', '3', '527', null), ('5', '492', '3', '491', null), ('2', '620', '3', '280', null), ('7', '243', '3', '242', null), ('5', '614', '3', '242', null), ('2', '614', '3', '242', null), ('6', '477', '2', '1', null), ('3', '612', '3', '611', null), ('5', '437', '3', '436', null), ('5', '438', '3', '436', null), ('5', '439', '3', '436', null), ('5', '440', '3', '436', null), ('5', '523', '3', '436', null), ('5', '309', '3', '308', null), ('5', '320', '3', '308', null), ('5', '319', '3', '308', null), ('5', '318', '3', '308', null), ('5', '317', '3', '308', null), ('5', '316', '3', '308', null), ('5', '315', '3', '308', null), ('5', '314', '3', '308', null), ('5', '313', '3', '308', null), ('5', '312', '3', '308', null), ('5', '311', '3', '308', null), ('5', '310', '3', '308', null), ('5', '513', '3', '308', null), ('5', '331', '3', '330', null), ('5', '339', '3', '330', null), ('5', '338', '3', '330', null), ('5', '337', '3', '330', null), ('5', '336', '3', '330', null), ('5', '335', '3', '330', null), ('5', '334', '3', '330', null), ('5', '333', '3', '330', null), ('5', '332', '3', '330', null), ('5', '340', '3', '330', null), ('5', '520', '3', '479', null), ('5', '519', '3', '479', null), ('5', '518', '3', '479', null), ('5', '517', '3', '479', null), ('5', '516', '3', '479', null), ('5', '515', '3', '479', null), ('5', '514', '3', '479', null), ('5', '480', '3', '479', null), ('5', '549', '3', '525', null), ('5', '548', '3', '525', null), ('5', '532', '3', '531', null), ('5', '533', '3', '531', null), ('5', '488', '3', '487', null), ('5', '489', '3', '487', null), ('5', '490', '3', '487', null), ('5', '521', '3', '487', null), ('5', '535', '3', '487', null), ('5', '536', '3', '487', null), ('5', '522', '3', '485', null), ('5', '486', '3', '485', null), ('5', '478', '3', '477', null), ('5', '424', '3', '423', null), ('5', '425', '3', '423', null), ('5', '411', '3', '410', null), ('6', '1', '1', '0', null), ('3', '547', '3', '491', null), ('7', '1', '1', '0', null), ('6', '485', '2', '1', null), ('6', '487', '2', '1', null), ('6', '531', '2', '1', null), ('6', '665', '2', '1', null), ('6', '525', '2', '1', null), ('6', '479', '2', '1', null), ('6', '661', '2', '1', null), ('6', '651', '2', '1', null), ('2', '454', '2', '1', null), ('6', '624', '2', '1', null), ('6', '660', '2', '1', null), ('6', '436', '2', '1', null), ('6', '491', '2', '1', null), ('6', '527', '2', '1', null), ('6', '481', '2', '1', null), ('6', '572', '2', '1', null), ('6', '590', '2', '1', null), ('6', '280', '2', '1', null), ('6', '96', '3', '7', null), ('6', '293', '3', '292', null), ('6', '496', '3', '495', null), ('6', '541', '3', '537', null), ('6', '545', '3', '537', null), ('6', '599', '3', '537', null), ('6', '482', '3', '481', null), ('6', '512', '3', '280', null), ('6', '511', '3', '280', null), ('6', '484', '3', '280', null), ('6', '483', '3', '280', null), ('6', '284', '3', '280', null), ('6', '283', '3', '280', null), ('6', '282', '3', '280', null), ('6', '534', '3', '280', null), ('6', '546', '3', '280', null), ('6', '610', '3', '280', null), ('6', '510', '3', '481', null), ('6', '528', '3', '527', null), ('6', '529', '3', '527', null), ('6', '492', '3', '491', null), ('2', '619', '3', '280', null), ('7', '487', '2', '1', null), ('4', '614', '3', '242', null), ('4', '620', '3', '280', null), ('5', '613', '3', '611', null), ('3', '629', '2', '1', null), ('6', '523', '3', '436', null), ('6', '440', '3', '436', null), ('6', '439', '3', '436', null), ('6', '438', '3', '436', null), ('6', '437', '3', '436', null), ('6', '516', '3', '479', null), ('6', '515', '3', '479', null), ('6', '514', '3', '479', null), ('6', '480', '3', '479', null), ('6', '517', '3', '479', null), ('6', '518', '3', '479', null), ('6', '519', '3', '479', null), ('6', '520', '3', '479', null), ('6', '530', '3', '525', null), ('6', '526', '3', '525', null), ('6', '532', '3', '531', null), ('6', '533', '3', '531', null), ('6', '488', '3', '487', null), ('6', '489', '3', '487', null), ('6', '490', '3', '487', null), ('6', '521', '3', '487', null), ('6', '535', '3', '487', null), ('6', '536', '3', '487', null), ('6', '522', '3', '485', null), ('6', '486', '3', '485', null), ('6', '478', '3', '477', null), ('6', '424', '3', '423', null), ('6', '425', '3', '423', null), ('6', '411', '3', '410', null), ('2', '547', '3', '491', null), ('7', '531', '2', '1', null), ('7', '665', '2', '1', null), ('7', '525', '2', '1', null), ('7', '479', '2', '1', null), ('7', '661', '2', '1', null), ('7', '651', '2', '1', null), ('7', '660', '2', '1', null), ('7', '436', '2', '1', null), ('7', '491', '2', '1', null), ('7', '567', '2', '1', null), ('7', '280', '2', '1', null), ('7', '657', '2', '1', null), ('7', '636', '2', '1', null), ('7', '635', '2', '1', null), ('7', '611', '2', '1', null), ('7', '366', '2', '1', null), ('7', '341', '2', '1', null), ('7', '551', '2', '1', null), ('7', '495', '2', '1', null), ('7', '654', '2', '1', null), ('7', '96', '3', '7', null), ('7', '286', '3', '285', null), ('7', '287', '3', '285', null), ('7', '288', '3', '285', null), ('7', '289', '3', '285', null), ('7', '290', '3', '285', null), ('7', '291', '3', '285', null), ('7', '442', '3', '441', null), ('7', '452', '3', '441', null), ('7', '451', '3', '441', null), ('7', '450', '3', '441', null), ('7', '449', '3', '441', null), ('7', '448', '3', '441', null), ('7', '447', '3', '441', null), ('7', '446', '3', '441', null), ('7', '445', '3', '441', null), ('7', '444', '3', '441', null), ('7', '443', '3', '441', null), ('7', '453', '3', '441', null), ('7', '455', '3', '454', null), ('7', '463', '3', '454', null), ('7', '462', '3', '454', null), ('7', '461', '3', '454', null), ('7', '460', '3', '454', null), ('7', '459', '3', '454', null), ('7', '458', '3', '454', null), ('7', '457', '3', '454', null), ('7', '456', '3', '454', null), ('7', '464', '3', '454', null), ('7', '389', '3', '388', null), ('7', '397', '3', '388', null), ('7', '396', '3', '388', null), ('7', '395', '3', '388', null), ('7', '394', '3', '388', null), ('7', '393', '3', '388', null), ('7', '392', '3', '388', null), ('7', '391', '3', '388', null), ('7', '390', '3', '388', null), ('7', '398', '3', '388', null), ('7', '400', '3', '399', null), ('7', '408', '3', '399', null), ('7', '407', '3', '399', null), ('7', '406', '3', '399', null), ('7', '405', '3', '399', null), ('7', '404', '3', '399', null), ('7', '403', '3', '399', null), ('7', '402', '3', '399', null), ('7', '401', '3', '399', null), ('7', '409', '3', '399', null), ('7', '254', '3', '253', null), ('7', '255', '3', '253', null), ('7', '256', '3', '253', null), ('7', '257', '3', '253', null), ('7', '258', '3', '253', null), ('7', '259', '3', '253', null), ('7', '260', '3', '253', null), ('7', '261', '3', '253', null), ('7', '466', '3', '292', null), ('7', '465', '3', '292', null), ('7', '299', '3', '292', null), ('7', '298', '3', '292', null), ('7', '553', '3', '292', null), ('7', '300', '3', '292', null), ('7', '554', '3', '292', null), ('7', '524', '3', '292', null), ('7', '297', '3', '292', null), ('7', '296', '3', '292', null), ('7', '295', '3', '292', null), ('7', '294', '3', '292', null), ('7', '641', '3', '493', null), ('7', '598', '3', '493', null), ('7', '496', '3', '495', null), ('7', '342', '3', '341', null), ('7', '351', '3', '341', null), ('7', '350', '3', '341', null), ('7', '349', '3', '341', null), ('7', '348', '3', '341', null), ('7', '347', '3', '341', null), ('7', '346', '3', '341', null), ('7', '345', '3', '341', null), ('7', '344', '3', '341', null), ('7', '343', '3', '341', null), ('7', '352', '3', '341', null), ('7', '367', '3', '366', null), ('7', '375', '3', '366', null), ('7', '374', '3', '366', null), ('7', '373', '3', '366', null), ('7', '372', '3', '366', null), ('7', '371', '3', '366', null), ('7', '370', '3', '366', null), ('7', '369', '3', '366', null), ('7', '368', '3', '366', null), ('7', '376', '3', '366', null), ('7', '492', '3', '491', null), ('7', '520', '3', '479', null), ('7', '519', '3', '479', null), ('7', '523', '3', '436', null), ('7', '437', '3', '436', null), ('7', '518', '3', '479', null), ('7', '517', '3', '479', null), ('7', '516', '3', '479', null), ('7', '515', '3', '479', null), ('7', '514', '3', '479', null), ('7', '480', '3', '479', null), ('7', '649', '3', '525', null), ('7', '526', '3', '525', null), ('7', '532', '3', '531', null), ('7', '533', '3', '531', null), ('7', '488', '3', '487', null), ('7', '489', '3', '487', null), ('7', '490', '3', '487', null), ('7', '521', '3', '487', null), ('7', '535', '3', '487', null), ('7', '536', '3', '487', null), ('7', '486', '3', '485', null), ('7', '522', '3', '485', null), ('7', '585', '3', '477', null), ('4', '547', '3', '491', null), ('5', '547', '3', '491', null), ('6', '547', '3', '491', null), ('7', '547', '3', '491', null), ('2', '648', '3', '525', null), ('2', '649', '3', '525', null), ('6', '548', '3', '525', null), ('6', '549', '3', '525', null), ('5', '530', '3', '525', null), ('5', '526', '3', '525', null), ('2', '421', '3', '420', null), ('2', '293', '3', '292', null), ('2', '571', '3', '292', null), ('2', '441', '2', '1', null), ('2', '552', '3', '551', null), ('3', '578', '2', '1', null), ('3', '552', '3', '551', null), ('7', '552', '3', '551', null), ('7', '293', '3', '292', null), ('7', '571', '3', '292', null), ('2', '565', '2', '1', null), ('2', '563', '2', '1', null), ('2', '556', '3', '555', null), ('2', '557', '3', '555', null), ('2', '558', '3', '555', null), ('2', '559', '3', '555', null), ('2', '560', '3', '555', null), ('2', '561', '3', '555', null), ('2', '562', '3', '555', null), ('2', '564', '3', '563', null), ('7', '644', '2', '1', null), ('7', '564', '3', '563', null), ('5', '654', '2', '1', null), ('5', '564', '3', '563', null), ('2', '566', '3', '565', null), ('2', '420', '2', '1', null), ('2', '568', '3', '567', null), ('2', '569', '3', '567', null), ('3', '577', '2', '1', null), ('3', '568', '3', '567', null), ('3', '569', '3', '567', null), ('4', '537', '2', '1', null), ('4', '568', '3', '567', null), ('4', '569', '3', '567', null), ('7', '629', '2', '1', null), ('7', '568', '3', '567', null), ('7', '569', '3', '567', null), ('2', '570', '3', '263', null), ('2', '581', '3', '292', null), ('2', '427', '2', '1', null), ('2', '555', '2', '1', null), ('3', '292', '2', '1', null), ('2', '573', '3', '572', null), ('4', '600', '2', '1', null), ('4', '184', '3', '5', null), ('4', '198', '3', '5', null), ('4', '188', '3', '5', null), ('4', '187', '3', '5', null), ('6', '657', '2', '1', null), ('6', '184', '3', '5', null), ('6', '198', '3', '5', null), ('6', '188', '3', '5', null), ('6', '187', '3', '5', null), ('2', '273', '2', '1', null), ('2', '321', '2', '1', null), ('2', '642', '3', '578', null), ('2', '580', '3', '577', null), ('7', '578', '2', '1', null), ('7', '577', '2', '1', null), ('7', '580', '3', '577', null), ('7', '642', '3', '578', null), ('2', '509', '3', '292', null), ('7', '581', '3', '292', null), ('3', '427', '2', '1', null), ('3', '273', '2', '1', null), ('3', '580', '3', '577', null), ('3', '622', '3', '578', null), ('4', '495', '2', '1', null), ('4', '629', '2', '1', null), ('4', '580', '3', '577', null), ('4', '608', '3', '578', null), ('5', '644', '2', '1', null), ('5', '629', '2', '1', null), ('5', '580', '3', '577', null), ('5', '622', '3', '578', null), ('6', '636', '2', '1', null), ('6', '635', '2', '1', null), ('6', '580', '3', '577', null), ('6', '608', '3', '578', null), ('8', '1', '1', '0', null), ('8', '7', '2', '1', null), ('8', '263', '2', '1', null), ('8', '253', '2', '1', null), ('8', '341', '2', '1', null), ('8', '366', '2', '1', null), ('8', '354', '2', '1', null), ('8', '377', '2', '1', null), ('8', '308', '2', '1', null), ('8', '330', '2', '1', null), ('8', '96', '3', '7', null), ('8', '264', '3', '263', null), ('8', '272', '3', '263', null), ('8', '271', '3', '263', null), ('8', '270', '3', '263', null), ('8', '269', '3', '263', null), ('8', '268', '3', '263', null), ('8', '267', '3', '263', null), ('8', '266', '3', '263', null), ('8', '265', '3', '263', null), ('8', '570', '3', '263', null), ('8', '254', '3', '253', null), ('8', '255', '3', '253', null), ('8', '256', '3', '253', null), ('8', '257', '3', '253', null), ('8', '258', '3', '253', null), ('8', '259', '3', '253', null), ('8', '260', '3', '253', null), ('8', '261', '3', '253', null), ('8', '342', '3', '341', null), ('8', '351', '3', '341', null), ('8', '350', '3', '341', null), ('8', '349', '3', '341', null), ('8', '348', '3', '341', null), ('8', '346', '3', '341', null), ('8', '345', '3', '341', null), ('8', '344', '3', '341', null), ('8', '343', '3', '341', null), ('8', '352', '3', '341', null), ('8', '367', '3', '366', null), ('8', '375', '3', '366', null), ('8', '374', '3', '366', null), ('8', '373', '3', '366', null), ('8', '372', '3', '366', null), ('8', '371', '3', '366', null), ('8', '370', '3', '366', null), ('8', '369', '3', '366', null), ('8', '368', '3', '366', null), ('8', '376', '3', '366', null), ('8', '355', '3', '354', null), ('8', '364', '3', '354', null), ('8', '363', '3', '354', null), ('8', '362', '3', '354', null), ('8', '361', '3', '354', null), ('8', '360', '3', '354', null), ('8', '359', '3', '354', null), ('8', '358', '3', '354', null), ('8', '357', '3', '354', null), ('8', '356', '3', '354', null), ('8', '365', '3', '354', null), ('8', '378', '3', '377', null), ('8', '386', '3', '377', null), ('8', '385', '3', '377', null), ('8', '384', '3', '377', null), ('8', '383', '3', '377', null), ('8', '382', '3', '377', null), ('8', '381', '3', '377', null), ('8', '380', '3', '377', null), ('8', '379', '3', '377', null), ('8', '387', '3', '377', null), ('8', '309', '3', '308', null), ('8', '320', '3', '308', null), ('8', '319', '3', '308', null), ('8', '318', '3', '308', null), ('8', '317', '3', '308', null), ('8', '316', '3', '308', null), ('8', '315', '3', '308', null), ('8', '314', '3', '308', null), ('8', '313', '3', '308', null), ('8', '312', '3', '308', null), ('8', '311', '3', '308', null), ('8', '310', '3', '308', null), ('8', '513', '3', '308', null), ('8', '331', '3', '330', null), ('8', '339', '3', '330', null), ('8', '338', '3', '330', null), ('8', '337', '3', '330', null), ('8', '336', '3', '330', null), ('8', '335', '3', '330', null), ('8', '334', '3', '330', null), ('8', '333', '3', '330', null), ('8', '332', '3', '330', null), ('8', '340', '3', '330', null), ('2', '584', '3', '477', null), ('2', '583', '3', '477', null), ('2', '582', '3', '477', null), ('7', '584', '3', '477', null), ('7', '583', '3', '477', null), ('7', '582', '3', '477', null), ('2', '478', '3', '477', null), ('7', '478', '3', '477', null), ('2', '586', '3', '420', null), ('2', '587', '3', '420', null), ('2', '622', '3', '578', null), ('7', '622', '3', '578', null), ('3', '573', '3', '572', null), ('2', '596', '3', '590', null), ('2', '595', '3', '590', null), ('2', '594', '3', '590', null), ('2', '593', '3', '590', null), ('2', '591', '3', '590', null), ('2', '507', '3', '493', null), ('2', '494', '3', '493', null), ('3', '321', '2', '1', null), ('3', '591', '3', '590', null), ('5', '578', '2', '1', null), ('5', '591', '3', '590', null), ('3', '621', '3', '578', null), ('5', '621', '3', '578', null), ('3', '593', '3', '590', null), ('3', '594', '3', '590', null), ('3', '595', '3', '590', null), ('3', '596', '3', '590', null), ('7', '509', '3', '292', null), ('2', '602', '3', '537', null), ('3', '538', '3', '537', null), ('4', '538', '3', '537', null), ('5', '602', '3', '537', null), ('6', '602', '3', '537', null), ('2', '285', '2', '1', null), ('2', '601', '3', '600', null), ('3', '285', '2', '1', null), ('3', '601', '3', '600', null), ('4', '578', '2', '1', null), ('4', '601', '3', '600', null), ('5', '577', '2', '1', null), ('5', '601', '3', '600', null), ('6', '611', '2', '1', null), ('6', '601', '3', '600', null), ('2', '603', '3', '537', null), ('2', '604', '3', '537', null), ('2', '538', '3', '537', null), ('4', '540', '3', '537', null), ('4', '539', '3', '537', null), ('4', '604', '3', '537', null), ('3', '540', '3', '537', null), ('3', '539', '3', '537', null), ('3', '604', '3', '537', null), ('5', '603', '3', '537', null), ('5', '604', '3', '537', null), ('5', '538', '3', '537', null), ('6', '603', '3', '537', null), ('6', '604', '3', '537', null), ('6', '538', '3', '537', null), ('2', '605', '3', '577', null), ('7', '605', '3', '577', null), ('2', '606', '3', '600', null), ('3', '606', '3', '600', null), ('5', '606', '3', '600', null), ('2', '621', '3', '578', null), ('3', '608', '3', '578', null), ('4', '607', '3', '578', null), ('4', '588', '3', '578', null), ('5', '608', '3', '578', null), ('6', '607', '3', '578', null), ('6', '588', '3', '578', null), ('7', '621', '3', '578', null), ('2', '608', '3', '578', null), ('3', '607', '3', '578', null), ('4', '579', '3', '578', null), ('5', '607', '3', '578', null), ('6', '579', '3', '578', null), ('7', '608', '3', '578', null), ('7', '493', '2', '1', null), ('7', '184', '3', '5', null), ('7', '198', '3', '5', null), ('7', '197', '3', '5', null), ('7', '190', '3', '5', null), ('7', '188', '3', '5', null), ('7', '187', '3', '5', null), ('4', '577', '2', '1', null), ('4', '421', '3', '420', null), ('6', '537', '2', '1', null), ('6', '421', '3', '420', null), ('2', '609', '3', '477', null), ('7', '609', '3', '477', null), ('2', '618', '3', '280', null), ('5', '634', '3', '280', null), ('6', '634', '3', '280', null), ('2', '617', '3', '280', null), ('3', '619', '3', '280', null), ('3', '618', '3', '280', null), ('3', '617', '3', '280', null), ('3', '616', '3', '280', null), ('3', '281', '3', '280', null), ('4', '619', '3', '280', null), ('4', '618', '3', '280', null), ('4', '617', '3', '280', null), ('4', '616', '3', '280', null), ('4', '615', '3', '280', null), ('5', '623', '3', '280', null), ('5', '620', '3', '280', null), ('5', '619', '3', '280', null), ('5', '618', '3', '280', null), ('5', '617', '3', '280', null), ('6', '623', '3', '280', null), ('6', '620', '3', '280', null), ('6', '619', '3', '280', null), ('6', '618', '3', '280', null), ('6', '617', '3', '280', null), ('2', '607', '3', '578', null), ('2', '588', '3', '578', null), ('3', '588', '3', '578', null), ('3', '579', '3', '578', null), ('4', '621', '3', '578', null), ('4', '622', '3', '578', null), ('5', '588', '3', '578', null), ('5', '579', '3', '578', null), ('6', '621', '3', '578', null), ('6', '622', '3', '578', null), ('2', '616', '3', '280', null), ('6', '616', '3', '280', null), ('5', '616', '3', '280', null), ('2', '301', '2', '1', null), ('2', '668', '3', '624', null), ('2', '628', '3', '624', null), ('2', '627', '3', '624', null), ('2', '626', '3', '624', null), ('3', '301', '2', '1', null), ('3', '625', '3', '624', null), ('3', '626', '3', '624', null), ('3', '627', '3', '624', null), ('4', '292', '2', '1', null), ('4', '625', '3', '624', null), ('4', '626', '3', '624', null), ('4', '627', '3', '624', null), ('5', '292', '2', '1', null), ('5', '668', '3', '624', null), ('5', '627', '3', '624', null), ('5', '626', '3', '624', null), ('6', '600', '2', '1', null), ('6', '668', '3', '624', null), ('6', '627', '3', '624', null), ('6', '626', '3', '624', null), ('2', '225', '2', '1', null), ('2', '630', '3', '629', null), ('2', '631', '3', '629', null), ('3', '225', '2', '1', null), ('3', '630', '3', '629', null), ('3', '631', '3', '629', null), ('4', '420', '2', '1', null), ('4', '630', '3', '629', null), ('4', '631', '3', '629', null), ('5', '420', '2', '1', null), ('5', '630', '3', '629', null), ('5', '631', '3', '629', null), ('6', '495', '2', '1', null), ('6', '630', '3', '629', null), ('6', '631', '3', '629', null), ('7', '292', '2', '1', null), ('7', '630', '3', '629', null), ('7', '631', '3', '629', null), ('2', '632', '3', '479', null), ('7', '632', '3', '479', null), ('5', '632', '3', '479', null), ('5', '593', '3', '590', null), ('5', '594', '3', '590', null), ('5', '595', '3', '590', null), ('5', '596', '3', '590', null), ('7', '597', '3', '493', null), ('7', '507', '3', '493', null), ('2', '526', '3', '525', null), ('3', '526', '3', '525', null), ('5', '633', '3', '525', null), ('6', '629', '2', '1', null), ('6', '578', '2', '1', null), ('6', '217', '3', '216', null), ('6', '218', '3', '216', null), ('6', '219', '3', '216', null), ('6', '220', '3', '216', null), ('6', '221', '3', '216', null), ('6', '222', '3', '216', null), ('6', '223', '3', '216', null), ('6', '224', '3', '216', null), ('6', '468', '3', '467', null), ('6', '469', '3', '467', null), ('6', '470', '3', '467', null), ('6', '471', '3', '467', null), ('6', '472', '3', '467', null), ('6', '473', '3', '467', null), ('6', '474', '3', '467', null), ('6', '475', '3', '467', null), ('6', '476', '3', '467', null), ('6', '577', '2', '1', null), ('6', '292', '2', '1', null), ('6', '591', '3', '590', null), ('6', '573', '3', '572', null), ('7', '607', '3', '578', null), ('7', '588', '3', '578', null), ('2', '615', '3', '280', null), ('4', '281', '3', '280', null), ('6', '615', '3', '280', null), ('2', '242', '2', '1', null), ('2', '467', '2', '1', null), ('2', '638', '3', '635', null), ('2', '640', '3', '636', null), ('2', '639', '3', '636', null), ('2', '637', '3', '636', null), ('3', '242', '2', '1', null), ('3', '467', '2', '1', null), ('3', '638', '3', '635', null), ('3', '637', '3', '636', null), ('3', '639', '3', '636', null), ('3', '640', '3', '636', null), ('4', '242', '2', '1', null), ('4', '5', '2', '1', null), ('4', '638', '3', '635', null), ('4', '637', '3', '636', null), ('4', '639', '3', '636', null), ('4', '640', '3', '636', null), ('5', '427', '2', '1', null), ('5', '273', '2', '1', null), ('5', '638', '3', '635', null), ('6', '420', '2', '1', null), ('5', '639', '3', '636', null), ('5', '637', '3', '636', null), ('6', '242', '2', '1', null), ('6', '638', '3', '635', null), ('6', '637', '3', '636', null), ('6', '639', '3', '636', null), ('5', '321', '2', '1', null), ('5', '573', '3', '572', null), ('5', '574', '3', '572', null), ('2', '641', '3', '493', null), ('7', '494', '3', '493', null), ('7', '579', '3', '578', null), ('2', '579', '3', '578', null), ('7', '643', '3', '578', null), ('2', '643', '3', '578', null), ('3', '642', '3', '578', null), ('3', '643', '3', '578', null), ('5', '642', '3', '578', null), ('5', '643', '3', '578', null), ('2', '216', '2', '1', null), ('3', '216', '2', '1', null), ('7', '253', '2', '1', null), ('5', '285', '2', '1', null), ('2', '645', '3', '644', null), ('3', '645', '3', '644', null), ('5', '645', '3', '644', null), ('7', '645', '3', '644', null), ('2', '633', '3', '525', null), ('2', '549', '3', '525', null), ('2', '548', '3', '525', null), ('2', '530', '3', '525', null), ('2', '650', '3', '525', null), ('3', '647', '3', '525', null), ('3', '646', '3', '525', null), ('3', '633', '3', '525', null), ('3', '549', '3', '525', null), ('3', '548', '3', '525', null), ('3', '530', '3', '525', null), ('3', '650', '3', '525', null), ('7', '648', '3', '525', null), ('7', '647', '3', '525', null), ('7', '646', '3', '525', null), ('7', '633', '3', '525', null), ('7', '549', '3', '525', null), ('7', '548', '3', '525', null), ('7', '530', '3', '525', null), ('7', '650', '3', '525', null), ('2', '281', '3', '280', null), ('3', '652', '3', '280', null), ('4', '652', '3', '280', null), ('5', '281', '3', '280', null), ('6', '281', '3', '280', null), ('7', '399', '2', '1', null), ('7', '653', '3', '651', null), ('5', '301', '2', '1', null), ('5', '653', '3', '651', null), ('6', '467', '2', '1', null), ('6', '653', '3', '651', null), ('2', '233', '2', '1', null), ('2', '653', '3', '651', null), ('7', '388', '2', '1', null), ('7', '454', '2', '1', null), ('7', '441', '2', '1', null), ('7', '563', '2', '1', null), ('7', '617', '3', '280', null), ('7', '616', '3', '280', null), ('7', '615', '3', '280', null), ('7', '281', '3', '280', null), ('7', '613', '3', '611', null), ('7', '612', '3', '611', null), ('7', '618', '3', '280', null), ('7', '619', '3', '280', null), ('7', '620', '3', '280', null), ('7', '623', '3', '280', null), ('7', '634', '3', '280', null), ('7', '610', '3', '280', null), ('7', '546', '3', '280', null), ('7', '534', '3', '280', null), ('7', '282', '3', '280', null), ('7', '283', '3', '280', null), ('7', '284', '3', '280', null), ('7', '426', '3', '280', null), ('7', '483', '3', '280', null), ('7', '484', '3', '280', null), ('7', '511', '3', '280', null), ('7', '512', '3', '280', null), ('7', '652', '3', '280', null), ('7', '285', '2', '1', null), ('7', '655', '3', '654', null), ('7', '656', '3', '654', null), ('2', '6', '2', '1', null), ('2', '656', '3', '654', null), ('2', '655', '3', '654', null), ('3', '233', '2', '1', null), ('3', '655', '3', '654', null), ('3', '656', '3', '654', null), ('5', '225', '2', '1', null), ('5', '655', '3', '654', null), ('5', '656', '3', '654', null), ('2', '5', '2', '1', null), ('2', '659', '3', '657', null), ('2', '658', '3', '657', null), ('3', '5', '2', '1', null), ('4', '7', '2', '1', null), ('4', '658', '3', '657', null), ('4', '659', '3', '657', null), ('3', '658', '3', '657', null), ('3', '659', '3', '657', null), ('5', '242', '2', '1', null), ('5', '659', '3', '657', null), ('5', '658', '3', '657', null), ('6', '216', '2', '1', null), ('6', '659', '3', '657', null), ('6', '658', '3', '657', null), ('7', '242', '2', '1', null), ('7', '658', '3', '657', null), ('7', '659', '3', '657', null), ('7', '5', '2', '1', null), ('6', '5', '2', '1', null), ('5', '467', '2', '1', null), ('2', '64', '2', '1', null), ('7', '7', '2', '1', null), ('6', '7', '2', '1', null), ('5', '216', '2', '1', null), ('2', '7', '2', '1', null), ('7', '662', '3', '661', null), ('6', '662', '3', '661', null), ('5', '662', '3', '661', null), ('2', '662', '3', '661', null), ('7', '663', '3', '660', null), ('7', '664', '3', '660', null), ('6', '667', '3', '660', null), ('6', '664', '3', '660', null), ('5', '667', '3', '660', null), ('5', '664', '3', '660', null), ('2', '667', '3', '660', null), ('2', '664', '3', '660', null), ('2', '410', '2', '1', null), ('3', '7', '2', '1', null), ('5', '5', '2', '1', null), ('7', '477', '2', '1', null), ('7', '666', '3', '665', null), ('2', '666', '3', '665', null), ('3', '666', '3', '665', null), ('6', '663', '3', '660', null), ('5', '663', '3', '660', null), ('2', '663', '3', '660', null), ('5', '666', '3', '665', null), ('6', '410', '2', '1', null), ('6', '666', '3', '665', null), ('4', '410', '2', '1', null), ('4', '667', '3', '660', null), ('4', '664', '3', '660', null), ('4', '663', '3', '660', null), ('3', '410', '2', '1', null), ('3', '667', '3', '660', null), ('3', '664', '3', '660', null), ('3', '663', '3', '660', null), ('6', '625', '3', '624', null), ('5', '625', '3', '624', null), ('2', '625', '3', '624', null), ('6', '669', '3', '624', null), ('5', '669', '3', '624', null), ('2', '669', '3', '624', null), ('6', '670', '3', '660', null), ('5', '670', '3', '660', null), ('2', '670', '3', '660', null), ('4', '670', '3', '660', null), ('3', '670', '3', '660', null), ('6', '671', '3', '537', null), ('5', '671', '3', '537', null), ('2', '671', '3', '537', null), ('5', '672', '3', '657', null), ('2', '672', '3', '657', null), ('6', '673', '3', '485', null), ('5', '673', '3', '485', null), ('2', '673', '3', '485', null), ('5', '243', '3', '242', null), ('9', '1', '1', '0', null), ('9', '611', '2', '1', null), ('9', '612', '3', '611', null), ('9', '280', '2', '1', null), ('9', '652', '3', '280', null), ('9', '281', '3', '280', null), ('5', '652', '3', '280', null), ('6', '652', '3', '280', null), ('5', '7', '2', '1', null), ('2', '1', '1', '0', null), ('2', '96', '3', '7', null), ('2', '94', '3', '64', null), ('2', '95', '3', '64', null), ('2', '205', '3', '64', null);
COMMIT;
-- ----------------------------
-- Table structure for `admin_account`
-- ----------------------------
DROP TABLE IF EXISTS `admin_account`;
CREATE TABLE `admin_account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` varchar(50) NOT NULL DEFAULT '' COMMENT '订单号-唯一',
`member_id` varchar(50) NOT NULL DEFAULT '' COMMENT '用户的支付宝账号',
`money` float NOT NULL DEFAULT '0' COMMENT '转账数',
`status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '转账状态：1.转入；2.转出；3.无效',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='账务表\n';
-- ----------------------------
-- Table structure for `admin_node`
-- ----------------------------
DROP TABLE IF EXISTS `admin_node`;
CREATE TABLE `admin_node` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL COMMENT '节点名',
`title` varchar(50) DEFAULT NULL COMMENT '显示名',
`status` tinyint(1) DEFAULT '0' COMMENT '状态',
`remark` varchar(255) DEFAULT NULL,
`sort` smallint(6) unsigned DEFAULT NULL COMMENT '序号',
`pid` smallint(6) unsigned NOT NULL COMMENT '父节点',
`level` tinyint(1) unsigned NOT NULL COMMENT '层级',
`type` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `level` (`level`),
KEY `pid` (`pid`),
KEY `status` (`status`),
KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=713 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='节点表';
-- ----------------------------
-- Records of `admin_node`
-- ----------------------------
BEGIN;
INSERT INTO `admin_node` VALUES ('1', 'Admin', '后台管理', '1', '', '0', '0', '1', '0'), ('2', 'Public', '公共模块', '1', '', '3', '1', '2', '0'), ('3', 'Index', '后台主页', '1', '', '4', '1', '2', '0'), ('4', 'Node', '节点管理', '1', '', '73', '1', '2', '1'), ('5', 'User', '用户管理', '1', '', '70', '1', '2', '2'), ('6', 'Role', '权限管理', '1', '', '71', '1', '2', '2'), ('7', 'SysInfo', '系统信息', '1', '', '72', '1', '2', '1'), ('64', 'Variable', '全局变量设置', '1', '', '74', '1', '2', '1'), ('93', 'edit', '编辑', '1', '', null, '64', '3', '0'), ('94', 'update', '保存编辑', '1', '', null, '64', '3', '0'), ('95', 'index', '列表', '1', '', null, '64', '3', '0'), ('96', 'index', '列表', '1', '', null, '7', '3', '0'), ('184', 'index', '列表', '1', '', null, '5', '3', '0'), ('185', 'add', '新增', '1', '', null, '5', '3', '0'), ('186', 'insert', '保存新增', '1', '', null, '5', '3', '0'), ('187', 'edit', '编辑', '1', '', null, '5', '3', '0'), ('188', 'update', '保存编辑', '1', '', null, '5', '3', '0'), ('189', 'foreverdelete', '永久删除', '1', '', null, '5', '3', '0'), ('190', 'quickUpdateText', '快速编辑文本', '1', '', null, '5', '3', '0'), ('191', 'index', '列表', '1', '', null, '6', '3', '0'), ('192', 'accredit', '权限列表', '1', '', null, '6', '3', '0'), ('193', 'getNodesByPid', '按上级节点取节点', '1', '', null, '6', '3', '0'), ('194', 'saveAccess', '保存角色权限', '1', '', null, '6', '3', '0'), ('195', 'userlist', '用户列表', '1', '', null, '6', '3', '0'), ('196', 'saveUserList', '保存用户列表', '1', '', null, '6', '3', '0'), ('197', 'checkAccount', '检查帐号', '1', '', null, '5', '3', '0'), ('198', 'resetPwd', '重置密码', '1', '', null, '5', '3', '0'), ('205', 'quickUpdateText', '快速编辑文本', '1', '', null, '64', '3', '0'), ('506', 'publish', '发布/撤销', '1', '', null, '5', '3', '0'), ('694', 'Mall', '建材城管理', '1', '', null, '1', '2', '6'), ('695', 'Shop', '门店管理', '1', '', null, '1', '2', '6'), ('696', 'Band', '品牌管理', '1', '', null, '1', '2', '6'), ('697', 'Activity', '装修团购', '1', '', '1', '1', '2', '4'), ('698', 'Type', '品类管理', '1', '', null, '1', '2', '6'), ('699', 'Good', '商品列表', '1', '', null, '1', '2', '5'), ('700', 'Tuan', '拼团列表', '1', '', '4', '1', '2', '4'), ('701', 'Bandhot', '热门品牌', '1', '', null, '1', '2', '6'), ('702', 'Weixinfocus', '关注回复设置', '1', '', null, '1', '2', '3'), ('703', 'Member', '前台用户管理', '1', '', null, '1', '2', '3'), ('704', 'Bandtj', '品牌统计', '1', '', null, '1', '2', '7'), ('705', 'Activitytj', '活动统计', '1', '', null, '1', '2', '7'), ('706', 'Searchtj', '搜索词统计', '1', '', null, '1', '2', '7'), ('707', 'Sell', '商家列表', '1', '', null, '1', '2', '6'), ('708', 'Quan', '优惠券', '1', '', '6', '1', '2', '4'), ('709', 'Quantj', '优惠券统计', '1', '', null, '1', '2', '7'), ('710', 'Wxactivity', '微信抽奖', '1', '', '2', '1', '2', '4'), ('711', 'Crowd', '众筹抽奖', '1', '', '3', '1', '2', '4'), ('712', 'Freedes', '验房报名', '1', '', '5', '1', '2', '4');
COMMIT;
-- ----------------------------
-- Table structure for `admin_role`
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL COMMENT '名称',
`pid` smallint(6) DEFAULT NULL COMMENT '父级id',
`status` tinyint(1) unsigned DEFAULT NULL COMMENT '状态',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`ename` varchar(5) DEFAULT NULL COMMENT '英文名',
`create_time` int(11) unsigned NOT NULL COMMENT '创建时间',
`update_time` int(11) unsigned NOT NULL COMMENT '末次修改',
PRIMARY KEY (`id`),
KEY `parentId` (`pid`),
KEY `ename` (`ename`),
KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色表';
-- ----------------------------
-- Records of `admin_role`
-- ----------------------------
BEGIN;
INSERT INTO `admin_role` VALUES ('1', '超级管理员', '0', '1', '所有权限', '', '0', '1353153801'), ('2', '系统管理员', '0', '1', '所有常规操作权限', '', '1311330953', '1369646869');
COMMIT;
-- ----------------------------
-- Table structure for `admin_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_user`;
CREATE TABLE `admin_role_user` (
`role_id` mediumint(9) unsigned DEFAULT NULL COMMENT '角色',
`user_id` char(32) DEFAULT NULL COMMENT '用户',
KEY `group_id` (`role_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色用户对照表';
-- ----------------------------
-- Records of `admin_role_user`
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_user` VALUES ('1', '1'), ('2', '2');
COMMIT;
-- ----------------------------
-- Table structure for `admin_user`
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(64) NOT NULL COMMENT '账号',
`nickname` varchar(50) NOT NULL COMMENT '昵称',
`password` char(32) NOT NULL COMMENT '密码',
`last_login_time` int(11) unsigned DEFAULT '0' COMMENT '末次登录时间',
`last_login_ip` varchar(40) DEFAULT NULL COMMENT '末次登录ip',
`login_count` mediumint(8) unsigned DEFAULT '0' COMMENT '登录次数',
`face` varchar(32) NOT NULL DEFAULT 'photo.png' COMMENT '头像',
`email` varchar(50) NOT NULL COMMENT '邮箱',
`mobile` varchar(20) NOT NULL COMMENT '手机',
`qq` varchar(30) NOT NULL,
`skype` varchar(90) NOT NULL,
`wx` varchar(30) DEFAULT NULL COMMENT '微信',
`my_sch_charge` varchar(200) DEFAULT NULL COMMENT '负责校区',
`remark` varchar(255) NOT NULL COMMENT '备注',
`create_time` int(11) unsigned NOT NULL COMMENT '创建时间',
`update_time` int(11) unsigned NOT NULL COMMENT '更新时间',
`status` tinyint(1) DEFAULT '0' COMMENT '-1:删除,0:禁用,1:正常,2:待审',
PRIMARY KEY (`id`),
UNIQUE KEY `account` (`account`),
UNIQUE KEY `nickname` (`nickname`),
UNIQUE KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户表';
-- ----------------------------
-- Records of `admin_user`
-- ----------------------------
BEGIN;
INSERT INTO `admin_user` VALUES ('1', 'admin', 'Steven12', '21232f297a57a5a743894a0e4a801fc3', '1482236098', '127.0.0.1', '906', '5315cb0ba1317.gif', '[email protected]', '88888888888', '1239806377', 'peshine', 'peshine', null, '超级管理员\nwwww', '1310985711', '1467171344', '1'), ('2', 'keaixiaou', 'keaixiaou', '08965d74c1a8e5c9cb5df4ed5e5621b4', '1461766883', '127.0.0.1', '7', 'photo.png', '[email protected]', '18167158602', '286252682', '286252682', '286252682', null, '', '1432734565', '1432734565', '1');
COMMIT;
-- ----------------------------
-- Table structure for `admin_variable`
-- ----------------------------
DROP TABLE IF EXISTS `admin_variable`;
CREATE TABLE `admin_variable` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mykey` varchar(30) NOT NULL COMMENT '变量名',
`myvalue` varchar(500) NOT NULL DEFAULT '' COMMENT '变量值',
`cat` varchar(30) DEFAULT NULL COMMENT '类别',
`remark` varchar(60) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`mykey`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='网站变量表';
-- ----------------------------
-- Records of `admin_variable`
-- ----------------------------
BEGIN;
INSERT INTO `admin_variable` VALUES ('1', 'meta_title', '后台管理\n', 'seo', '标题'), ('2', 'meta_keywords', '建材', 'seo', '关键词'), ('3', 'meta_description', '介绍各种活动并且可以购买相应的商品', 'seo', '描述'), ('7', 'menu_types', '{ \"0\":\"系统管理\", \"2\":\"用户管理\", \"1\":\"杂项管理\", \"7\":\"杂项二管理\", \"3\":\"活动管理\", \"4\":\"商品管理\", \"5\":\"商家管理\", \"6\":\"统计管理\" }', '', '菜单类别，以“|”分隔'), ('8', 'node_names', 'index|add|insert|edit|update|delete|resume|foreverdelete|sort|saveSort|toTop|sortTop|moveto|publish|uploadPic|uploadAtt|quickUpdateText|quickUpdateDate', '', '操作名称，用于批新增操作节点'), ('9', 'node_titles', '列表|新增|保存新增|编辑|保存编辑|删除|恢复|永久删除|排序|保存排序|置顶/取消|置顶排序|转移|发布/撤销|上传图片|上传附件|快速编辑文本|快速编辑日期', '', '显示名称，用于批新增操作节点'), ('10', 'bg_list_rows', '50', '', '后台每页记录数'), ('11', 'quan_num', '3', '', '');
COMMIT;
-- ----------------------------
-- Table structure for `test`
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(11) NOT NULL,
`content` varchar(200) NOT NULL DEFAULT '',
`no` int(11) NOT NULL DEFAULT '0' COMMENT 'no',
PRIMARY KEY (`id`),
UNIQUE KEY `no_index` (`no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `test`
-- ----------------------------
BEGIN;
INSERT INTO `test` VALUES ('1', '333', '1'), ('2', '333', '2'), ('3', '333', '0'), ('4', '333', '4'), ('5', '222', '5'), ('6', '222', '6'), ('7', '222', '7'), ('8', '222', '8');
COMMIT;
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(64) NOT NULL COMMENT '账号',
`nickname` varchar(50) NOT NULL COMMENT '昵称',
`password` char(32) NOT NULL COMMENT '密码',
`mobile` varchar(20) NOT NULL COMMENT '手机',
`qq` varchar(30) NOT NULL,
`remark` varchar(255) NOT NULL COMMENT '备注',
`create_time` int(11) unsigned NOT NULL COMMENT '创建时间',
`update_time` int(11) unsigned NOT NULL COMMENT '更新时间',
`status` tinyint(1) DEFAULT '0' COMMENT '-1:删除,0:禁用,1:正常,2:待审',
PRIMARY KEY (`id`),
UNIQUE KEY `account` (`account`),
UNIQUE KEY `nickname` (`nickname`),
UNIQUE KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户表';
-- ----------------------------
-- Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'admin', 'Steven', 'a3753e2045fde88aa03a7810d1162512', '88888888888', '1239806377', '超级管理员\nwwww', '1310985711', '1467171344', '1'), ('2', 'keaixiaou', 'keaixiaou', '08965d74c1a8e5c9cb5df4ed5e5621b4', '18167158602', '286252682', '', '1432734565', '1432734565', '1');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;