-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSampleTable.sql
More file actions
232 lines (225 loc) · 19.2 KB
/
SampleTable.sql
File metadata and controls
232 lines (225 loc) · 19.2 KB
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
227
228
229
230
231
232
-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 19, 2012 at 11:49 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9-2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `testing`
--
-- --------------------------------------------------------
--
-- Table structure for table `equipment`
--
CREATE TABLE IF NOT EXISTS `equipment` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NID` int(11) NOT NULL,
`DID` int(11) NOT NULL,
`DLID` int(11) NOT NULL,
`DLD` varchar(14) NOT NULL,
`LIN` int(11) NOT NULL,
`SN` varchar(50) NOT NULL,
`RACK` varchar(11) NOT NULL,
`STATUS` int(11) NOT NULL,
`LOC` int(1) NOT NULL,
`DETAILS` text NOT NULL,
`PID` int(11) NOT NULL,
`PLT` int(11) NOT NULL,
`SECT` int(11) NOT NULL,
`OPStatus` int(1) NOT NULL,
`DA` varchar(14) NOT NULL,
`TS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`IMG` varchar(255) NOT NULL,
`CLASSIFICATION` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=185 ;
--
-- Dumping data for table `equipment`
--
INSERT INTO `equipment` (`ID`, `NID`, `DID`, `DLID`, `DLD`, `LIN`, `SN`, `RACK`, `STATUS`, `LOC`, `DETAILS`, `PID`, `PLT`, `SECT`, `OPStatus`, `DA`, `TS`, `IMG`, `CLASSIFICATION`) VALUES
(1, 1, 0, 17, '', 1, '12345', '', 0, 0, '', 0, 1, 1, 1, '', '2011-11-26 16:35:11', '', 0),
(3, 0, 0, 0, '', 0, '111111', '', 0, 0, '', 0, 0, 0, 0, '', '2010-02-18 23:04:09', '', 0),
(4, 2, 0, 0, '', 2, '23142134', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(5, 3, 0, 0, '', 3, '2FS2342', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(6, 3, 0, 0, '', 3, '123FDFS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(7, 3, 0, 0, '', 3, 'DFE234', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(8, 3, 0, 0, '', 3, 'DSFSF3', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(9, 3, 0, 0, '', 3, '123234F', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(10, 3, 0, 0, '', 3, '2323FS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(11, 4, 0, 0, '', 4, 'SFADAFAE2233', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(12, 4, 0, 0, '', 4, 'ASDF32223', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(13, 5, 0, 0, '', 5, 'ASDF223442', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(14, 6, 0, 0, '', 6, 'SAFD2323222', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(15, 7, 0, 0, '', 7, 'KHGK4545646456', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(16, 7, 0, 0, '', 7, 'JFTH5456343', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(17, 8, 0, 0, '', 8, 'GHF23543456', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(18, 9, 0, 0, '', 9, 'HK335334', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(19, 9, 0, 0, '', 9, 'JX3453445', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(20, 10, 0, 0, '', 10, 'OXZDR24324234', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(21, 10, 0, 0, '', 10, 'SADF2342342', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(22, 10, 0, 0, '', 10, 'HE4345533', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(23, 10, 0, 0, '', 10, 'GSDGF2342', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(24, 10, 0, 0, '', 10, 'HJK345345', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(25, 10, 0, 0, '', 10, 'S345HD46', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(26, 10, 0, 0, '', 10, 'WRF234323', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(27, 10, 0, 0, '', 10, '234FSDFS23', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(28, 10, 0, 0, '', 10, 'H456RTYFH', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(29, 11, 0, 0, '', 11, '345FHNDRH6363', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(30, 11, 0, 0, '', 11, 'TDE34535', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(31, 11, 0, 0, '', 11, 'FGH4FH452SXHN33', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(32, 11, 0, 0, '', 11, 'GSDG4343535G', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(33, 11, 0, 0, '', 11, 'EWRTWE3434534NKL', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(34, 11, 0, 0, '', 11, '345HNDW43244', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(35, 12, 0, 0, '', 12, 'ASDF23', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(36, 13, 0, 0, '', 13, '234', '', 0, 0, '', 0, 0, 0, 1, '', '2011-11-26 16:35:11', '', 0),
(37, 13, 0, 0, '', 13, '123SG3', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(38, 13, 0, 0, '', 13, 'F588J4GRY', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(39, 13, 0, 0, '', 13, '23426', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(40, 13, 0, 0, '', 13, '345G34', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(41, 13, 0, 0, '', 13, 'H74F5HI', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(42, 13, 0, 0, '', 13, '43567', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(43, 13, 0, 0, '', 13, 'DFHGSD44', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(44, 13, 0, 0, '', 13, '345992JE', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(45, 13, 0, 0, '', 13, '945234', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(46, 13, 0, 0, '', 13, 'SDH23', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(47, 13, 0, 0, '', 13, '3453S4G', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(48, 13, 0, 0, '', 13, '23452', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(49, 13, 0, 0, '', 13, 'AWDSG34', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(50, 13, 0, 0, '', 13, 'E453455', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(51, 13, 0, 0, '', 13, '324522', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(52, 13, 0, 0, '', 13, 'SG4HGS4', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(53, 13, 0, 0, '', 13, 'SDFG4WGW3', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(54, 13, 0, 0, '', 13, 'DSWED4', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(55, 13, 0, 0, '', 13, 'SDG5Y', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(56, 14, 0, 0, '', 14, '1234EF423', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(57, 15, 0, 0, '', 15, 'ASDF2348BUH48', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(58, 15, 0, 0, '', 15, '5H4237KG', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(59, 15, 0, 0, '', 15, '23465JSDAFU2', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(60, 15, 0, 0, '', 15, 'F865JG874H3YTR', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(61, 15, 0, 0, '', 15, 'FGH5U2JF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(62, 15, 0, 0, '', 15, 'FASE3U8YO9', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(63, 15, 0, 0, '', 15, 'FU58GJT', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(64, 15, 0, 0, '', 15, 'FJ3283', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(65, 15, 0, 0, '', 15, 'F375487KF91', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(66, 16, 0, 0, '', 16, 'FJ348RF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(67, 16, 0, 0, '', 16, 'SFJ348JG', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(68, 16, 0, 0, '', 16, 'SDI328J', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(69, 16, 0, 0, '', 16, 'FJH238GK', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(70, 16, 0, 0, '', 16, 'KCMZY323', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(71, 16, 0, 0, '', 16, 'SDH437DFK', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(72, 17, 0, 0, '', 17, 'AFSJH3468', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(73, 18, 0, 0, '', 18, 'WFJ3489V', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(74, 18, 0, 0, '', 18, '1238GT5723894', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(75, 18, 0, 0, '', 18, 'SFD348AK', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(76, 18, 0, 0, '', 18, '34G43N', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(77, 18, 0, 0, '', 18, 'ASDFHGJ823FH', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(78, 18, 0, 0, '', 18, 'W35SFAS567', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(79, 18, 0, 0, '', 18, 'T234T23B', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(80, 18, 0, 0, '', 18, 'ASFDH-F2QRJ', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(81, 18, 0, 0, '', 18, 'JI8OIJL', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(82, 18, 0, 0, '', 18, '3452345B', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(83, 18, 0, 0, '', 18, 'SADFJ37F', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(84, 18, 0, 0, '', 18, 'W34R5AJ8F9HY', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(85, 18, 0, 0, '', 18, '2345N2NJ', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(86, 18, 0, 0, '', 18, 'ASF8I3PSAF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(87, 18, 0, 0, '', 18, 'F8239HJFOAJFL', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(88, 18, 0, 0, '', 18, 'SADFH4711', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(89, 18, 0, 0, '', 18, 'FA2JR85927G', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(90, 18, 0, 0, '', 18, '8Y3295UAZ', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(91, 18, 0, 0, '', 18, 'ASDF29ER', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(92, 18, 0, 0, '', 18, '23894H28FV', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(93, 18, 0, 0, '', 18, '283RH58OYFAS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(94, 18, 0, 0, '', 18, '12384JG82', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(95, 18, 0, 0, '', 18, '283495YAQZ', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(96, 18, 0, 0, '', 18, '2389Y4UFFS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(97, 19, 0, 0, '', 19, 'ASHDOIF23', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(98, 19, 0, 0, '', 19, 'ASFJ2R8AF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(99, 19, 0, 0, '', 19, '283ROAJF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(100, 19, 0, 0, '', 19, '298RFFJALSFJ', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(101, 19, 0, 0, '', 19, 'AW8FR23FA', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(102, 20, 0, 0, '', 20, 'ASDFHJ4839', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(103, 20, 0, 0, '', 20, 'SF823FJF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(104, 20, 0, 19, '', 20, '23489USFVAL', '', 0, 0, '', 1, 1, 1, 0, '', '2011-11-26 16:36:24', '', 0),
(105, 20, 0, 0, '', 20, 'ASFD2398FA', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(106, 20, 0, 0, '', 20, '823R4897FL', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(107, 21, 0, 0, '', 21, '6572342983JKSDAFH', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(108, 21, 0, 0, '', 21, '2394U2UJASFLKJASFD', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(109, 21, 0, 0, '', 21, 'W234JUOJFOWJF22F', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(110, 21, 0, 0, '', 21, '25892424KHASF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(111, 21, 0, 0, '', 21, '23049U234JAFS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(112, 21, 0, 0, '', 21, '2F9J290OJF2JFO2JF9OJ23', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(113, 21, 0, 0, '', 21, '2348923497KHAF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(114, 21, 0, 0, '', 21, '2394U2LFAJSFLKJ', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(115, 21, 0, 0, '', 21, '2F923JF9J2F9FJAJFZ', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(116, 21, 0, 0, '', 21, '3297497283497AZF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(117, 21, 0, 0, '', 21, '238429384FASFJSLFA', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(118, 21, 0, 0, '', 21, 'O2JFOJFJASAUHFUWHFIH', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(119, 21, 0, 0, '', 21, '2983492874AZZS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(120, 21, 0, 0, '', 21, '234UASFJLAJF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(121, 21, 0, 0, '', 21, 'WHF8H2378HF98A9F', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(122, 21, 0, 0, '', 21, '29348729374ZFISFA', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(123, 21, 0, 0, '', 21, 'A2JROJFLAWJF82', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(124, 21, 0, 0, '', 21, '238R928R2HF89HQ8JFQ', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(125, 21, 0, 0, '', 21, '2349897FZOIU', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(126, 21, 0, 0, '', 21, 'ASFJAFJF28F8288', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(127, 21, 0, 0, '', 21, 'F98H2Q89FA8VH28NQV89JV', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(128, 21, 0, 0, '', 21, '2304987928RZZS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(129, 21, 0, 0, '', 21, 'ASFJAWLFJ8282828', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(130, 21, 0, 0, '', 21, '982H89H82F8NV8NQ9FN', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(131, 21, 0, 0, '', 21, 'OIAJF79878ZSSS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(132, 21, 0, 0, '', 21, 'ASFJALFJLE288F828', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(133, 21, 0, 0, '', 21, 'HQF298HFQ89FHAFOIAJSF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(134, 21, 0, 0, '', 21, '239423J4LKJSFS', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(135, 21, 0, 0, '', 21, 'SAFJOIAJELFJ28882', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(136, 21, 0, 0, '', 21, '82R98HOFIAVIOANV', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(137, 21, 0, 0, '', 21, '2389U42983742Z', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(138, 21, 0, 0, '', 21, 'ASIFJALF28YR82824', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(139, 21, 0, 0, '', 21, '298HFJAOJFAOISVJOAIVN', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(140, 21, 0, 0, '', 21, 'IOASLIFJLASJFEW8', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(141, 21, 0, 0, '', 21, 'AWFJOW8248723847234', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(142, 21, 0, 0, '', 21, '298HJRHOANVNA', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(143, 21, 0, 0, '', 21, 'ASOIDFJIEJFEF8', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(144, 21, 0, 0, '', 21, 'AFIAJFWLIEJ283489248', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(145, 21, 0, 0, '', 21, '82HFO9HAIOVHNAKNV', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(146, 21, 0, 0, '', 21, 'FASLKJF-9U234UOI', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(147, 21, 0, 0, '', 21, 'ASFGOW2984279847222', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(148, 21, 0, 0, '', 21, '892OANVNVLANV', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(149, 21, 0, 0, '', 21, 'SAKLDFJLAJF87324', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(150, 21, 0, 0, '', 21, 'AFUASOJF2832837333', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(151, 21, 0, 0, '', 21, '892H93RIFALIVAHG', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(152, 21, 0, 0, '', 21, 'SAIHFAWJEF72322', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(153, 21, 0, 0, '', 21, 'AFJOIEJFJL28382872723', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(154, 21, 0, 0, '', 21, '82389UUOAIJFLKNVA', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(155, 21, 0, 0, '', 21, 'ASIFDJLAWJEF282382', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(156, 21, 0, 0, '', 21, 'AWOJIFO2383747474344', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(157, 21, 0, 0, '', 21, '8Y2U9RTYUOIAJFJLAKNV', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(158, 21, 0, 0, '', 21, 'ASFJALSKJFLAKWJ28', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(159, 21, 0, 0, '', 21, '28394928374SIFIAJFA2', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(160, 21, 0, 0, '', 21, '89YUWRHJALKVGFLKAS2O89U', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(161, 21, 0, 0, '', 21, 'SAFHOWEYF8272', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(162, 21, 0, 0, '', 21, '8W2URROIWJFLJ28R2JFO', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(163, 21, 0, 0, '', 21, 'AOIUFIOJFOWUFVAVL', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(164, 21, 0, 0, '', 21, 'ASFDHGELIHF278342', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(165, 21, 0, 0, '', 21, '2RUJF238U42NFN22837', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(166, 21, 0, 0, '', 21, '9A0U2LJFALKJV9U39W', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(167, 21, 0, 0, '', 21, 'SAJFLAEJF27372', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(168, 21, 0, 0, '', 21, 'WOU2384YHF2FH82HFO8J2OF', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(169, 21, 0, 0, '', 21, 'V09UASJVW9U8382803', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(170, 21, 0, 0, '', 21, 'SAFALEJFLE27272', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(171, 21, 0, 0, '', 21, '2JR892J3FJ28JF2JF92J', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(172, 22, 0, 0, '', 18, '2342342', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(173, 22, 0, 0, '', 18, '2345277', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(174, 22, 0, 0, '', 18, '236366', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(175, 22, 0, 0, '', 18, '23425161', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(176, 22, 0, 0, '', 18, '26236', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(177, 22, 0, 0, '', 18, '63262362364235', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(178, 22, 0, 0, '', 18, '2623466', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(179, 22, 0, 0, '', 18, '262366', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(180, 22, 0, 0, '', 18, '23523232', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(181, 22, 0, 0, '', 18, '2363262', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-08 03:20:26', '', 0),
(182, 23, 0, 0, '20110920163847', 22, '5734983', '', 3, 0, '', 0, 0, 0, 0, '', '2011-09-20 16:38:47', '', 0),
(183, 20, 0, 0, '', 2, '123123123', '', 0, 0, '', 0, 0, 0, 0, '', '2010-09-20 14:58:06', '', 0),
(184, 24, 0, 0, '', 2, '545464542', '', 0, 0, '', 3, 2, 2, 0, '', '2011-10-19 18:58:51', '', 0);