1
|
-- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64)
|
2
|
--
|
3
|
-- Host: localhost Database: octomon
|
4
|
-- ------------------------------------------------------
|
5
|
-- Server version 5.5.31-1
|
6
|
|
7
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
8
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
9
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
10
|
/*!40101 SET NAMES utf8 */;
|
11
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
12
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
13
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
14
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
15
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
16
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
17
|
|
18
|
--
|
19
|
-- Table structure for table `activity`
|
20
|
--
|
21
|
|
22
|
DROP TABLE IF EXISTS `activity`;
|
23
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
24
|
/*!40101 SET character_set_client = utf8 */;
|
25
|
CREATE TABLE `activity` (
|
26
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
27
|
`school_id` int(11) NOT NULL,
|
28
|
`user_id` int(11) DEFAULT NULL,
|
29
|
`description` varchar(2000) NOT NULL,
|
30
|
`timestamp` datetime DEFAULT NULL,
|
31
|
`end_timestamp` datetime DEFAULT NULL,
|
32
|
PRIMARY KEY (`id`),
|
33
|
KEY `activity_school_id_exists` (`school_id`),
|
34
|
KEY `activity_user_id_exists` (`user_id`)
|
35
|
) ENGINE=MyISAM AUTO_INCREMENT=7545 DEFAULT CHARSET=utf8;
|
36
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
37
|
|
38
|
--
|
39
|
-- Table structure for table `alarm_definition`
|
40
|
--
|
41
|
|
42
|
DROP TABLE IF EXISTS `alarm_definition`;
|
43
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
44
|
/*!40101 SET character_set_client = utf8 */;
|
45
|
CREATE TABLE `alarm_definition` (
|
46
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
47
|
`user_id` int(11) NOT NULL,
|
48
|
`description` varchar(200) NOT NULL,
|
49
|
`code` varchar(2000) NOT NULL,
|
50
|
`active` tinyint(4) NOT NULL,
|
51
|
`local` tinyint(4) NOT NULL,
|
52
|
PRIMARY KEY (`id`),
|
53
|
KEY `alarm_definition_user_id_exists` (`user_id`)
|
54
|
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
|
55
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
56
|
|
57
|
--
|
58
|
-- Table structure for table `alarm_definition_run`
|
59
|
--
|
60
|
|
61
|
DROP TABLE IF EXISTS `alarm_definition_run`;
|
62
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
63
|
/*!40101 SET character_set_client = utf8 */;
|
64
|
CREATE TABLE `alarm_definition_run` (
|
65
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
66
|
`school_id` int(11) NOT NULL,
|
67
|
`definition_id` int(11) NOT NULL,
|
68
|
`school_timestamp` double DEFAULT NULL,
|
69
|
PRIMARY KEY (`id`),
|
70
|
UNIQUE KEY `schoolDefIndex` (`school_id`,`definition_id`),
|
71
|
KEY `alarm_definition_run_definition_id_exists` (`definition_id`)
|
72
|
) ENGINE=MyISAM AUTO_INCREMENT=159 DEFAULT CHARSET=latin1;
|
73
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
74
|
|
75
|
--
|
76
|
-- Table structure for table `alarms`
|
77
|
--
|
78
|
|
79
|
DROP TABLE IF EXISTS `alarms`;
|
80
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
81
|
/*!40101 SET character_set_client = utf8 */;
|
82
|
CREATE TABLE `alarms` (
|
83
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
84
|
`host_id` int(11) NOT NULL,
|
85
|
`definition_id` int(11) DEFAULT NULL,
|
86
|
`description` varchar(200) NOT NULL,
|
87
|
`timestamp` datetime DEFAULT NULL,
|
88
|
`ack` tinyint(4) DEFAULT NULL,
|
89
|
`ack_by_id` int(11) DEFAULT NULL,
|
90
|
`ack_when` datetime DEFAULT NULL,
|
91
|
PRIMARY KEY (`id`),
|
92
|
KEY `alarms_ack_by_id_exists` (`ack_by_id`),
|
93
|
KEY `alarms_host_id_exists` (`host_id`),
|
94
|
KEY `alarms_definition_id_exists` (`definition_id`)
|
95
|
) ENGINE=MyISAM AUTO_INCREMENT=7241 DEFAULT CHARSET=latin1;
|
96
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
97
|
|
98
|
--
|
99
|
-- Table structure for table `area`
|
100
|
--
|
101
|
|
102
|
DROP TABLE IF EXISTS `area`;
|
103
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
104
|
/*!40101 SET character_set_client = utf8 */;
|
105
|
CREATE TABLE `area` (
|
106
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
107
|
`code` varchar(50) DEFAULT NULL,
|
108
|
`name` varchar(150) DEFAULT NULL,
|
109
|
PRIMARY KEY (`id`)
|
110
|
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
|
111
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
112
|
|
113
|
--
|
114
|
-- Table structure for table `components`
|
115
|
--
|
116
|
|
117
|
DROP TABLE IF EXISTS `components`;
|
118
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
119
|
/*!40101 SET character_set_client = utf8 */;
|
120
|
CREATE TABLE `components` (
|
121
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
122
|
`name` varchar(200) DEFAULT NULL,
|
123
|
`value` varchar(200) DEFAULT NULL,
|
124
|
`host_id` int(11) DEFAULT NULL,
|
125
|
`timestamp` datetime DEFAULT NULL,
|
126
|
PRIMARY KEY (`id`),
|
127
|
KEY `components_name_host_id` (`name`,`host_id`),
|
128
|
KEY `components_host_id_name` (`host_id`,`name`)
|
129
|
) ENGINE=MyISAM AUTO_INCREMENT=27731667 DEFAULT CHARSET=latin1;
|
130
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
131
|
|
132
|
--
|
133
|
-- Table structure for table `computer`
|
134
|
--
|
135
|
|
136
|
DROP TABLE IF EXISTS `computer`;
|
137
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
138
|
/*!40101 SET character_set_client = utf8 */;
|
139
|
CREATE TABLE `computer` (
|
140
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
141
|
`school_id` int(11) NOT NULL,
|
142
|
`hostname` varchar(200) DEFAULT NULL,
|
143
|
`serial_number` varchar(200) DEFAULT NULL,
|
144
|
`video_serial_number` varchar(200) DEFAULT NULL,
|
145
|
`location` varchar(200) DEFAULT NULL,
|
146
|
`warranty_expire` date DEFAULT NULL,
|
147
|
`dismissed` tinyint(4) DEFAULT NULL,
|
148
|
PRIMARY KEY (`id`),
|
149
|
KEY `computer_school_id_exists` (`school_id`)
|
150
|
) ENGINE=MyISAM AUTO_INCREMENT=6352 DEFAULT CHARSET=latin1;
|
151
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
152
|
|
153
|
--
|
154
|
-- Table structure for table `group_permission`
|
155
|
--
|
156
|
|
157
|
DROP TABLE IF EXISTS `group_permission`;
|
158
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
159
|
/*!40101 SET character_set_client = utf8 */;
|
160
|
CREATE TABLE `group_permission` (
|
161
|
`group_id` int(11) NOT NULL,
|
162
|
`permission_id` int(11) NOT NULL
|
163
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
164
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
165
|
|
166
|
--
|
167
|
-- Table structure for table `host_scrap_book`
|
168
|
--
|
169
|
|
170
|
DROP TABLE IF EXISTS `host_scrap_book`;
|
171
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
172
|
/*!40101 SET character_set_client = utf8 */;
|
173
|
CREATE TABLE `host_scrap_book` (
|
174
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
175
|
`host_id` int(11) NOT NULL,
|
176
|
`user_id` int(11) DEFAULT NULL,
|
177
|
`content` varchar(2000) NOT NULL,
|
178
|
`timestamp` datetime DEFAULT NULL,
|
179
|
PRIMARY KEY (`id`),
|
180
|
KEY `host_scrap_book_host_id_exists` (`host_id`),
|
181
|
KEY `host_scrap_book_user_id_exists` (`user_id`)
|
182
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
183
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
184
|
|
185
|
--
|
186
|
-- Table structure for table `other_hardware`
|
187
|
--
|
188
|
|
189
|
DROP TABLE IF EXISTS `other_hardware`;
|
190
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
191
|
/*!40101 SET character_set_client = utf8 */;
|
192
|
CREATE TABLE `other_hardware` (
|
193
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
194
|
`school_id` int(11) NOT NULL,
|
195
|
`kind_id` int(11) DEFAULT NULL,
|
196
|
`vendor` varchar(200) DEFAULT NULL,
|
197
|
`model` varchar(200) DEFAULT NULL,
|
198
|
`serial_number` varchar(200) DEFAULT NULL,
|
199
|
`warranty_expire` date DEFAULT NULL,
|
200
|
`location` varchar(200) DEFAULT NULL,
|
201
|
`dismissed` tinyint(1) DEFAULT NULL,
|
202
|
PRIMARY KEY (`id`),
|
203
|
KEY `other_hardware_school_id_exists` (`school_id`),
|
204
|
KEY `other_hardware_kind_id_exists` (`kind_id`)
|
205
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
206
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
207
|
|
208
|
--
|
209
|
-- Table structure for table `other_hardware_kind`
|
210
|
--
|
211
|
|
212
|
DROP TABLE IF EXISTS `other_hardware_kind`;
|
213
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
214
|
/*!40101 SET character_set_client = utf8 */;
|
215
|
CREATE TABLE `other_hardware_kind` (
|
216
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
217
|
`name` varchar(200) DEFAULT NULL,
|
218
|
`description` varchar(200) DEFAULT NULL,
|
219
|
PRIMARY KEY (`id`)
|
220
|
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
|
221
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
222
|
|
223
|
--
|
224
|
-- Table structure for table `permission`
|
225
|
--
|
226
|
|
227
|
DROP TABLE IF EXISTS `permission`;
|
228
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
229
|
/*!40101 SET character_set_client = utf8 */;
|
230
|
CREATE TABLE `permission` (
|
231
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
232
|
`permission_name` varchar(16) NOT NULL,
|
233
|
`description` varchar(255) DEFAULT NULL,
|
234
|
PRIMARY KEY (`id`),
|
235
|
UNIQUE KEY `permission_name` (`permission_name`)
|
236
|
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
|
237
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
238
|
|
239
|
--
|
240
|
-- Table structure for table `school`
|
241
|
--
|
242
|
|
243
|
DROP TABLE IF EXISTS `school`;
|
244
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
245
|
/*!40101 SET character_set_client = utf8 */;
|
246
|
CREATE TABLE `school` (
|
247
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
248
|
`name` varchar(200) DEFAULT NULL,
|
249
|
`area_id` int(11) DEFAULT NULL,
|
250
|
`address` varchar(300) DEFAULT NULL,
|
251
|
`phone_number` varchar(200) DEFAULT NULL,
|
252
|
`email_address` varchar(200) DEFAULT NULL,
|
253
|
`lat` double DEFAULT NULL,
|
254
|
`lon` double DEFAULT NULL,
|
255
|
`last_timestamp` double DEFAULT NULL,
|
256
|
PRIMARY KEY (`id`),
|
257
|
KEY `school_area_id_exists` (`area_id`)
|
258
|
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;
|
259
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
260
|
|
261
|
--
|
262
|
-- Table structure for table `school_key`
|
263
|
--
|
264
|
|
265
|
DROP TABLE IF EXISTS `school_key`;
|
266
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
267
|
/*!40101 SET character_set_client = utf8 */;
|
268
|
CREATE TABLE `school_key` (
|
269
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
270
|
`school_id` int(11) NOT NULL,
|
271
|
`fingerprint` varchar(200) NOT NULL,
|
272
|
`crypto_key` text,
|
273
|
PRIMARY KEY (`id`),
|
274
|
UNIQUE KEY `fingerprint` (`fingerprint`),
|
275
|
KEY `school_key_school_id_exists` (`school_id`)
|
276
|
) ENGINE=MyISAM AUTO_INCREMENT=238 DEFAULT CHARSET=latin1;
|
277
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
278
|
|
279
|
--
|
280
|
-- Table structure for table `school_key_usage`
|
281
|
--
|
282
|
|
283
|
DROP TABLE IF EXISTS `school_key_usage`;
|
284
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
285
|
/*!40101 SET character_set_client = utf8 */;
|
286
|
CREATE TABLE `school_key_usage` (
|
287
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
288
|
`school_id` int(11) NOT NULL,
|
289
|
`key_id` int(11) DEFAULT NULL,
|
290
|
`timestamp` datetime DEFAULT NULL,
|
291
|
`first_data_timestamp` double DEFAULT NULL,
|
292
|
`last_data_timestamp` double DEFAULT NULL,
|
293
|
PRIMARY KEY (`id`),
|
294
|
KEY `school_key_usage_school_id_exists` (`school_id`),
|
295
|
KEY `school_key_usage_key_id_exists` (`key_id`)
|
296
|
) ENGINE=MyISAM AUTO_INCREMENT=10069 DEFAULT CHARSET=latin1;
|
297
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
298
|
|
299
|
--
|
300
|
-- Table structure for table `school_props`
|
301
|
--
|
302
|
|
303
|
DROP TABLE IF EXISTS `school_props`;
|
304
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
305
|
/*!40101 SET character_set_client = utf8 */;
|
306
|
CREATE TABLE `school_props` (
|
307
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
308
|
`school_id` int(11) NOT NULL,
|
309
|
`propname` varchar(200) NOT NULL,
|
310
|
`propvalue` varchar(200) NOT NULL,
|
311
|
PRIMARY KEY (`id`),
|
312
|
KEY `school_props_school_id_exists` (`school_id`)
|
313
|
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
|
314
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
315
|
|
316
|
--
|
317
|
-- Table structure for table `school_tg_user`
|
318
|
--
|
319
|
|
320
|
DROP TABLE IF EXISTS `school_tg_user`;
|
321
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
322
|
/*!40101 SET character_set_client = utf8 */;
|
323
|
CREATE TABLE `school_tg_user` (
|
324
|
`school_id` int(11) NOT NULL,
|
325
|
`tg_user_id` int(11) NOT NULL
|
326
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
327
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
328
|
|
329
|
--
|
330
|
-- Table structure for table `scrap_book`
|
331
|
--
|
332
|
|
333
|
DROP TABLE IF EXISTS `scrap_book`;
|
334
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
335
|
/*!40101 SET character_set_client = utf8 */;
|
336
|
CREATE TABLE `scrap_book` (
|
337
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
338
|
`school_id` int(11) NOT NULL,
|
339
|
`user_id` int(11) DEFAULT NULL,
|
340
|
`content` varchar(2000) NOT NULL,
|
341
|
`timestamp` datetime DEFAULT NULL,
|
342
|
PRIMARY KEY (`id`),
|
343
|
KEY `scrap_book_school_id_exists` (`school_id`),
|
344
|
KEY `scrap_book_user_id_exists` (`user_id`)
|
345
|
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
|
346
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
347
|
|
348
|
--
|
349
|
-- Table structure for table `tg_group`
|
350
|
--
|
351
|
|
352
|
DROP TABLE IF EXISTS `tg_group`;
|
353
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
354
|
/*!40101 SET character_set_client = utf8 */;
|
355
|
CREATE TABLE `tg_group` (
|
356
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
357
|
`group_name` varchar(16) NOT NULL,
|
358
|
`display_name` varchar(255) DEFAULT NULL,
|
359
|
`created` datetime DEFAULT NULL,
|
360
|
PRIMARY KEY (`id`),
|
361
|
UNIQUE KEY `group_name` (`group_name`)
|
362
|
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
|
363
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
364
|
|
365
|
--
|
366
|
-- Table structure for table `tg_user`
|
367
|
--
|
368
|
|
369
|
DROP TABLE IF EXISTS `tg_user`;
|
370
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
371
|
/*!40101 SET character_set_client = utf8 */;
|
372
|
CREATE TABLE `tg_user` (
|
373
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
374
|
`user_name` varchar(16) NOT NULL,
|
375
|
`email_address` varchar(255) NOT NULL,
|
376
|
`display_name` varchar(255) DEFAULT NULL,
|
377
|
`password` varchar(40) DEFAULT NULL,
|
378
|
`created` datetime DEFAULT NULL,
|
379
|
PRIMARY KEY (`id`),
|
380
|
UNIQUE KEY `user_name` (`user_name`),
|
381
|
UNIQUE KEY `email_address` (`email_address`)
|
382
|
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
|
383
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
384
|
|
385
|
--
|
386
|
-- Table structure for table `ticket`
|
387
|
--
|
388
|
|
389
|
DROP TABLE IF EXISTS `ticket`;
|
390
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
391
|
/*!40101 SET character_set_client = utf8 */;
|
392
|
CREATE TABLE `ticket` (
|
393
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
394
|
`opened` datetime DEFAULT NULL,
|
395
|
`opened_by_id` int(11) DEFAULT NULL,
|
396
|
`ticket_for` varchar(200) DEFAULT NULL,
|
397
|
`object_id` int(11) DEFAULT NULL,
|
398
|
`description` varchar(2000) DEFAULT NULL,
|
399
|
`closed` datetime DEFAULT NULL,
|
400
|
`closed_by` int(11) DEFAULT NULL,
|
401
|
PRIMARY KEY (`id`),
|
402
|
KEY `ticket_opened_by_id_exists` (`opened_by_id`)
|
403
|
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
|
404
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
405
|
|
406
|
--
|
407
|
-- Table structure for table `ticket_note`
|
408
|
--
|
409
|
|
410
|
DROP TABLE IF EXISTS `ticket_note`;
|
411
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
412
|
/*!40101 SET character_set_client = utf8 */;
|
413
|
CREATE TABLE `ticket_note` (
|
414
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
415
|
`ticket_id` int(11) DEFAULT NULL,
|
416
|
`user_id` int(11) DEFAULT NULL,
|
417
|
`timestamp` datetime DEFAULT NULL,
|
418
|
`content` varchar(2000) DEFAULT NULL,
|
419
|
PRIMARY KEY (`id`),
|
420
|
KEY `ticket_note_ticket_id_exists` (`ticket_id`),
|
421
|
KEY `ticket_note_user_id_exists` (`user_id`)
|
422
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
423
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
424
|
|
425
|
--
|
426
|
-- Table structure for table `used`
|
427
|
--
|
428
|
|
429
|
DROP TABLE IF EXISTS `used`;
|
430
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
431
|
/*!40101 SET character_set_client = utf8 */;
|
432
|
CREATE TABLE `used` (
|
433
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
434
|
`host_id` int(11) NOT NULL,
|
435
|
`timestamp` datetime DEFAULT NULL,
|
436
|
PRIMARY KEY (`id`),
|
437
|
KEY `used_host_id_exists` (`host_id`)
|
438
|
) ENGINE=MyISAM AUTO_INCREMENT=1185194 DEFAULT CHARSET=latin1;
|
439
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
440
|
|
441
|
--
|
442
|
-- Table structure for table `used_not_good`
|
443
|
--
|
444
|
|
445
|
DROP TABLE IF EXISTS `used_not_good`;
|
446
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
447
|
/*!40101 SET character_set_client = utf8 */;
|
448
|
CREATE TABLE `used_not_good` (
|
449
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
450
|
`host_id` int(11) NOT NULL,
|
451
|
`timestamp` datetime DEFAULT NULL,
|
452
|
PRIMARY KEY (`id`),
|
453
|
KEY `used_host_id_exists` (`host_id`)
|
454
|
) ENGINE=MyISAM AUTO_INCREMENT=793 DEFAULT CHARSET=latin1;
|
455
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
456
|
|
457
|
--
|
458
|
-- Table structure for table `user_group`
|
459
|
--
|
460
|
|
461
|
DROP TABLE IF EXISTS `user_group`;
|
462
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
463
|
/*!40101 SET character_set_client = utf8 */;
|
464
|
CREATE TABLE `user_group` (
|
465
|
`group_id` int(11) NOT NULL,
|
466
|
`user_id` int(11) NOT NULL
|
467
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
468
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
469
|
|
470
|
--
|
471
|
-- Table structure for table `visit`
|
472
|
--
|
473
|
|
474
|
DROP TABLE IF EXISTS `visit`;
|
475
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
476
|
/*!40101 SET character_set_client = utf8 */;
|
477
|
CREATE TABLE `visit` (
|
478
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
479
|
`visit_key` varchar(40) NOT NULL,
|
480
|
`created` datetime DEFAULT NULL,
|
481
|
`expiry` datetime DEFAULT NULL,
|
482
|
PRIMARY KEY (`id`),
|
483
|
UNIQUE KEY `visit_key` (`visit_key`)
|
484
|
) ENGINE=MyISAM AUTO_INCREMENT=15645 DEFAULT CHARSET=latin1;
|
485
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
486
|
|
487
|
--
|
488
|
-- Table structure for table `visit_identity`
|
489
|
--
|
490
|
|
491
|
DROP TABLE IF EXISTS `visit_identity`;
|
492
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
493
|
/*!40101 SET character_set_client = utf8 */;
|
494
|
CREATE TABLE `visit_identity` (
|
495
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
496
|
`visit_key` varchar(40) NOT NULL,
|
497
|
`user_id` int(11) DEFAULT NULL,
|
498
|
PRIMARY KEY (`id`),
|
499
|
UNIQUE KEY `visit_key` (`visit_key`)
|
500
|
) ENGINE=MyISAM AUTO_INCREMENT=3195 DEFAULT CHARSET=latin1;
|
501
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
502
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
503
|
|
504
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
505
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
506
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
507
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
508
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
509
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
510
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
511
|
|
512
|
-- Dump completed on 2013-07-16 19:03:56
|