database-create.sql 188 KB
Newer Older
1
-- MySQL dump 10.10
2
3
--
-- Host: localhost    Database: tbdb
4
5
6
7
8
9
10
11
12
13
14
15
16
-- ------------------------------------------------------
-- Server version	5.0.20-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17

Kirk Webb's avatar
Kirk Webb committed
18
19
20
21
22
23
24
25
26
27
28
29
30
--
-- Table structure for table `address_ranges`
--

DROP TABLE IF EXISTS `address_ranges`;
CREATE TABLE `address_ranges` (
  `baseaddr` varchar(40) NOT NULL default '',
  `prefix` tinyint(4) unsigned NOT NULL default '0',
  `type` varchar(30) NOT NULL default '',
  `role` enum('public','internal') NOT NULL default 'internal',
  PRIMARY KEY (`baseaddr`,`prefix`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

31
32
33
34
--
-- Table structure for table `accessed_files`
--

35
36
37
38
39
40
41
DROP TABLE IF EXISTS `accessed_files`;
CREATE TABLE `accessed_files` (
  `fn` text NOT NULL,
  `idx` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`fn`(255)),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
42

Timothy Stack's avatar
   
Timothy Stack committed
43
44
45
46
--
-- Table structure for table `active_checkups`
--

47
48
49
50
51
52
53
54
55
DROP TABLE IF EXISTS `active_checkups`;
CREATE TABLE `active_checkups` (
  `object` varchar(128) NOT NULL default '',
  `object_type` varchar(64) NOT NULL default '',
  `type` varchar(64) NOT NULL default '',
  `state` varchar(16) NOT NULL default 'new',
  `start` datetime default NULL,
  PRIMARY KEY  (`object`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Leigh B Stoller's avatar
Leigh B Stoller committed
56

57
58
59
60
--
-- Table structure for table `apt_datasets`
--

61
62
DROP TABLE IF EXISTS `apt_aggregates`;
CREATE TABLE `apt_aggregates` (
Leigh B Stoller's avatar
Leigh B Stoller committed
63
  `urn` varchar(128) NOT NULL default '',
64
65
66
  `name` varchar(32) NOT NULL default '',
  `nickname` varchar(32) NOT NULL default '',
  `abbreviation` varchar(16) NOT NULL default '',
Leigh B Stoller's avatar
Leigh B Stoller committed
67
  `noupdate` tinyint(1) NOT NULL default '0',
68
69
70
71
72
73
74
75
76
77
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `weburl` tinytext,
  `jsondata` text,
  PRIMARY KEY  (`urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `apt_datasets`
--

78
79
80
81
82
83
84
85
86
87
DROP TABLE IF EXISTS `apt_datasets`;
CREATE TABLE `apt_datasets` (
  `idx` int(10) unsigned NOT NULL default '0',
  `dataset_id` varchar(32) NOT NULL default '',
  `uuid` varchar(40) NOT NULL default '',
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `creator_uid` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `aggregate_urn` varchar(128) default NULL,
88
  `remote_urn` varchar(128) NOT NULL default '',
89
  `remote_uuid` varchar(40) NOT NULL default '',
90
  `remote_url` tinytext,
91
92
93
94
  `created` datetime default NULL,
  `expires` datetime default NULL,
  `last_used` datetime default NULL,
  `state` enum('new','valid','unapproved','grace','locked','expired','busy') NOT NULL default 'new',  
95
  `type` enum('stdataset','ltdataset','imdataset','unknown') NOT NULL default 'unknown',
96
97
  `fstype` varchar(40) NOT NULL default 'none',
  `size` int(10) unsigned NOT NULL default '0',
98
99
  `read_access` enum('project','global') NOT NULL default 'project',
  `write_access` enum('creator','project') NOT NULL default 'creator',
100
101
  `public` tinyint(1) NOT NULL default '0',
  `shared` tinyint(1) NOT NULL default '0',
102
103
104
105
106
107
108
109
  `locked` datetime default NULL, 
  `locker_pid` int(11) default '0',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `plid` (`pid_idx`,`dataset_id`),
  UNIQUE KEY `uuid` (`uuid`),
  UNIQUE KEY `remote_uuid` (`remote_uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

110
111
112
113
114
115
116
117
--
-- Table structure for table `apt_instance_aggregate_history`
--

DROP TABLE IF EXISTS `apt_instance_aggregate_history`;
CREATE TABLE `apt_instance_aggregate_history` (
  `uuid` varchar(40) NOT NULL default '',
  `name` varchar(16) default NULL,
Leigh B Stoller's avatar
Fixes.    
Leigh B Stoller committed
118
  `aggregate_urn` varchar(128) NOT NULL default '',
119
120
121
122
123
124
125
126
127
  `status` varchar(32) default NULL,
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
  `public_url` tinytext,
  `webtask_id` varchar(128) NOT NULL default '',
  `manifest` mediumtext,
  PRIMARY KEY (`uuid`,`aggregate_urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

128
129
130
131
132
133
134
135
--
-- Table structure for table `apt_instance_aggregates`
--

DROP TABLE IF EXISTS `apt_instance_aggregates`;
CREATE TABLE `apt_instance_aggregates` (
  `uuid` varchar(40) NOT NULL default '',
  `name` varchar(16) default NULL,
136
  `aggregate_urn` varchar(128) NOT NULL default '',
137
  `status` varchar(32) default NULL,
138
139
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
140
141
142
143
144
145
  `public_url` tinytext,
  `webtask_id` varchar(128) NOT NULL default '',
  `manifest` mediumtext,
  PRIMARY KEY (`uuid`,`aggregate_urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
146
--
147
-- Table structure for table `apt_instance_history`
Leigh B Stoller's avatar
Leigh B Stoller committed
148
149
--

150
151
152
DROP TABLE IF EXISTS `apt_instance_history`;
CREATE TABLE `apt_instance_history` (
  `uuid` varchar(40) NOT NULL default '',
153
  `name` varchar(16) default NULL,
154
155
156
157
158
159
  `profile_id` int(10) unsigned NOT NULL default '0',
  `profile_version` int(10) unsigned NOT NULL default '0',
  `slice_uuid` varchar(40) NOT NULL default '',
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `creator_uuid` varchar(40) NOT NULL default '',
160
161
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
162
  `aggregate_urn` varchar(128) default NULL,
163
  `public_url` tinytext,
164
165
  `created` datetime default NULL,
  `destroyed` datetime default NULL,
166
  `expired` tinyint(1) NOT NULL default '0',
167
168
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
169
170
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
171
  `servername` tinytext,
172
173
174
  `rspec` mediumtext,
  `params` mediumtext,
  `manifest` mediumtext,
175
176
177
178
179
180
181
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `apt_instances`
--

Leigh B Stoller's avatar
Leigh B Stoller committed
182
183
184
DROP TABLE IF EXISTS `apt_instances`;
CREATE TABLE `apt_instances` (
  `uuid` varchar(40) NOT NULL default '',
185
  `name` varchar(16) default NULL,
186
187
  `profile_id` int(10) unsigned NOT NULL default '0',
  `profile_version` int(10) unsigned NOT NULL default '0',
Leigh B Stoller's avatar
Leigh B Stoller committed
188
189
190
191
  `slice_uuid` varchar(40) NOT NULL default '',
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `creator_uuid` varchar(40) NOT NULL default '',
192
193
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
194
  `aggregate_urn` varchar(128) default NULL,
195
  `public_url` tinytext,
Leigh B Stoller's avatar
Leigh B Stoller committed
196
197
  `created` datetime default NULL,
  `status` varchar(32) default NULL,
198
  `status_timestamp` datetime default NULL,
199
200
  `admin_lockdown` tinyint(1) NOT NULL default '0',
  `user_lockdown` tinyint(1) NOT NULL default '0',
Leigh B Stoller's avatar
Leigh B Stoller committed
201
  `extension_code` varchar(32) default NULL,
202
  `extension_reason` mediumtext,
203
  `extension_history` mediumtext,
204
  `extension_adminonly` tinyint(1) NOT NULL default '0',
205
  `extension_requested` tinyint(1) NOT NULL default '0',
206
207
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
208
209
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
210
  `servername` tinytext,
211
  `monitor_pid` int(11) default '0',
212
  `logfileid` varchar(40) default NULL,
213
214
  `cert` mediumtext,
  `privkey` mediumtext,
215
216
  `rspec` mediumtext,
  `params` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
217
218
219
  `manifest` mediumtext,
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Timothy Stack's avatar
   
Timothy Stack committed
220

221
222
223
224
--
-- Table structure for table `apt_profile_versions`
--

225
DROP TABLE IF EXISTS `apt_profile_versions`;
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
CREATE TABLE `apt_profile_versions` (
  `name` varchar(64) NOT NULL default '',
  `profileid` int(10) unsigned NOT NULL default '0',  
  `version` int(8) unsigned NOT NULL default '0',
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime default NULL,
  `published` datetime default NULL,
  `deleted` datetime default NULL,
  `uuid` varchar(40) NOT NULL,
  `parent_profileid` int(8) unsigned default NULL,
  `parent_version` int(8) unsigned default NULL,
  `status` varchar(32) default NULL,
  `rspec` mediumtext,
242
  `script` mediumtext,
243
  `paramdefs` mediumtext,
244
245
246
247
248
  PRIMARY KEY (`profileid`,`version`),
  UNIQUE KEY `pidname` (`pid_idx`,`name`,`version`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

249
250
251
252
253
254
255
--
-- Table structure for table `apt_profiles`
--

DROP TABLE IF EXISTS `apt_profiles`;
CREATE TABLE `apt_profiles` (
  `name` varchar(64) NOT NULL default '',
256
257
  `profileid` int(10) unsigned NOT NULL default '0',  
  `version` int(8) unsigned NOT NULL default '0',
258
259
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
260
  `uuid` varchar(40) NOT NULL,
261
  `public` tinyint(1) NOT NULL default '0',
262
263
  `shared` tinyint(1) NOT NULL default '0',
  `listed` tinyint(1) NOT NULL default '0',
264
  `topdog` tinyint(1) NOT NULL default '0',
265
  `locked` datetime default NULL,
266
267
268
  `locker_pid` int(11) default '0',
  PRIMARY KEY (`profileid`),
  UNIQUE KEY `pidname` (`pid_idx`,`name`,`version`)
269
270
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
--
-- Table structure for table `archive_revisions`
--

DROP TABLE IF EXISTS `archive_revisions`;
CREATE TABLE `archive_revisions` (
  `archive_idx` int(10) unsigned NOT NULL default '0',
  `revision` int(10) unsigned NOT NULL auto_increment,
  `parent_revision` int(10) unsigned default NULL,
  `tag` varchar(64) NOT NULL default '',
  `view` varchar(64) NOT NULL default '',
  `date_created` int(10) unsigned NOT NULL default '0',
  `converted` tinyint(1) default '0',
  `description` text,
  PRIMARY KEY  (`archive_idx`,`revision`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

288
289
290
291
--
-- Table structure for table `archive_tags`
--

292
293
294
295
296
297
298
299
DROP TABLE IF EXISTS `archive_tags`;
CREATE TABLE `archive_tags` (
  `idx` int(10) unsigned NOT NULL auto_increment,
  `tag` varchar(64) NOT NULL default '',
  `archive_idx` int(10) unsigned NOT NULL default '0',
  `view` varchar(64) NOT NULL default '',
  `date_created` int(10) unsigned NOT NULL default '0',
  `tagtype` enum('user','commit','savepoint','internal') NOT NULL default 'internal',
300
  `version` tinyint(1) default '0',
301
302
303
304
  `description` text,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `tag` (`tag`,`archive_idx`,`view`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
305
306
307
308
309

--
-- Table structure for table `archive_views`
--

310
311
312
313
DROP TABLE IF EXISTS `archive_views`;
CREATE TABLE `archive_views` (
  `view` varchar(64) NOT NULL default '',
  `archive_idx` int(10) unsigned NOT NULL default '0',
314
315
  `revision` int(10) unsigned default NULL,
  `current_tag` varchar(64) default NULL,
316
317
318
319
  `previous_tag` varchar(64) default NULL,
  `date_created` int(10) unsigned NOT NULL default '0',
  `branch_tag` varchar(64) default NULL,
  `parent_view` varchar(64) default NULL,
320
  `parent_revision` int(10) unsigned default NULL,
321
322
  PRIMARY KEY  (`view`,`archive_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
323
324
325
326
327

--
-- Table structure for table `archives`
--

328
329
330
331
332
333
334
335
336
DROP TABLE IF EXISTS `archives`;
CREATE TABLE `archives` (
  `idx` int(10) unsigned NOT NULL auto_increment,
  `directory` tinytext,
  `date_created` int(10) unsigned NOT NULL default '0',
  `archived` tinyint(1) default '0',
  `date_archived` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
337

338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
--
-- Table structure for table `blob_files`
--

DROP TABLE IF EXISTS `blob_files`;
CREATE TABLE `blob_files` (
  `filename` varchar(255) NOT NULL,
  `hash` varchar(64) default NULL,
  `hash_mtime` datetime default NULL,
  PRIMARY KEY  (`filename`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `blobs`
--

DROP TABLE IF EXISTS `blobs`;
CREATE TABLE `blobs` (
  `uuid` varchar(40) NOT NULL,
  `filename` tinytext,
358
  `owner_uid` varchar(8) NOT NULL default '',
359
360
  `vblob_id` varchar(40) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
361
362
363
  PRIMARY KEY  (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

364
365
366
367
368
369
370
371
372
373
374
375
376
--
-- Table structure for table `blockstore_attributes`
--

DROP TABLE IF EXISTS `blockstore_attributes`;
CREATE TABLE `blockstore_attributes` (
  `bsidx` int(10) unsigned NOT NULL,
  `attrkey` varchar(32) NOT NULL default '',
  `attrvalue` tinytext NOT NULL,
  `attrtype` enum('integer','float','boolean','string') default 'string',
  PRIMARY KEY  (`bsidx`,`attrkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

377
378
379
380
381
382
383
384
385
386
--
-- Table structure for table `blockstore_state`
--

DROP TABLE IF EXISTS `blockstore_state`;
CREATE TABLE `blockstore_state` (
  `bsidx` int(10) unsigned NOT NULL,
  `node_id` varchar(32) NOT NULL default '',
  `bs_id` varchar(32) NOT NULL default '',
  `remaining_capacity` int(10) unsigned NOT NULL default '0',
387
  `ready` tinyint(4) unsigned NOT NULL default '0',
388
389
390
391
  PRIMARY KEY (`bsidx`),
  UNIQUE KEY nidbid (`node_id`,`bs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

392
393
394
395
396
397
398
399
400
401
402
403
--
-- Table structure for table `blockstore_trees`
--

DROP TABLE IF EXISTS `blockstore_trees`;
CREATE TABLE `blockstore_trees` (
  `bsidx` int(10) unsigned NOT NULL,
  `aggidx` int(10) unsigned NOT NULL default '0',
  `hint` tinytext NOT NULL,
  PRIMARY KEY (`bsidx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

404
405
406
407
408
409
410
411
412
413
--
-- Table structure for table `blockstore_type_attributes`
--

DROP TABLE IF EXISTS `blockstore_type_attributes`;
CREATE TABLE `blockstore_type_attributes` (
  `type` varchar(30) NOT NULL default '',
  `attrkey` varchar(32) NOT NULL default '',
  `attrvalue` tinytext NOT NULL,
  `attrtype` enum('integer','float','boolean','string') default 'string',
414
  `isfeature` tinyint(4) unsigned NOT NULL default '0',
415
416
417
418
419
420
421
422
423
424
425
426
  PRIMARY KEY  (`type`,`attrkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `blockstores`
--

DROP TABLE IF EXISTS `blockstores`;
CREATE TABLE `blockstores` (
  `bsidx` int(10) unsigned NOT NULL,
  `node_id` varchar(32) NOT NULL default '',
  `bs_id` varchar(32) NOT NULL default '',
427
  `lease_idx` int(10) unsigned NOT NULL default '0',
428
  `type` varchar(30) NOT NULL default '',
429
  `role` enum('element','compound','partition') NOT NULL default 'element',
430
  `total_size` int(10) unsigned NOT NULL default '0',
431
  `exported` tinyint(1) NOT NULL default '0',
432
433
  `inception` datetime default NULL,
  PRIMARY KEY (`bsidx`),
434
  UNIQUE KEY nidbid (`node_id`,`bs_id`,`lease_idx`)
435
436
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
437
438
439
440
441
442
--
-- Table structure for table `bridges`
--

DROP TABLE IF EXISTS `bridges`;
CREATE TABLE `bridges` (
443
  `pid` varchar(48) default NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
444
445
446
447
448
449
450
451
452
453
454
455
  `eid` varchar(32) default NULL,
  `exptidx` int(11) NOT NULL default '0',
  `node_id` varchar(32) NOT NULL default '',
  `bridx` mediumint(8) unsigned NOT NULL default '0',
  `iface` varchar(8) NOT NULL default '',
  `vname` varchar(32) NOT NULL default '',
  `vnode` varchar(32) default NULL,
  PRIMARY KEY  (`node_id`,`bridx`,`iface`),
  KEY `pid` (`pid`,`eid`),
  KEY `exptidx` (`exptidx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

456
457
458
459
--
-- Table structure for table `buildings`
--

460
461
462
463
464
465
466
DROP TABLE IF EXISTS `buildings`;
CREATE TABLE `buildings` (
  `building` varchar(32) NOT NULL default '',
  `image_path` tinytext,
  `title` tinytext NOT NULL,
  PRIMARY KEY  (`building`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
467

468
469
470
471
--
-- Table structure for table `cameras`
--

472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
DROP TABLE IF EXISTS `cameras`;
CREATE TABLE `cameras` (
  `name` varchar(32) NOT NULL default '',
  `building` varchar(32) NOT NULL default '',
  `floor` varchar(32) NOT NULL default '',
  `hostname` varchar(255) default NULL,
  `port` smallint(5) unsigned NOT NULL default '6100',
  `device` varchar(64) NOT NULL default '',
  `loc_x` float NOT NULL default '0',
  `loc_y` float NOT NULL default '0',
  `width` float NOT NULL default '0',
  `height` float NOT NULL default '0',
  `config` tinytext,
  `fixed_x` float NOT NULL default '0',
  `fixed_y` float NOT NULL default '0',
  PRIMARY KEY  (`name`,`building`,`floor`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
489

Kevin Atkinson's avatar
   
Kevin Atkinson committed
490
491
492
493
--
-- Table structure for table `causes`
--

494
495
496
497
498
499
500
DROP TABLE IF EXISTS `causes`;
CREATE TABLE `causes` (
  `cause` varchar(16) NOT NULL default '',
  `cause_desc` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`cause`),
  UNIQUE KEY `cause_desc` (`cause_desc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Kevin Atkinson's avatar
   
Kevin Atkinson committed
501

502
--
503
-- Table structure for table `cdroms`
504
--
505

506
507
508
509
510
511
512
513
514
515
516
DROP TABLE IF EXISTS `cdroms`;
CREATE TABLE `cdroms` (
  `cdkey` varchar(64) NOT NULL default '',
  `user_name` tinytext NOT NULL,
  `user_email` tinytext NOT NULL,
  `ready` tinyint(4) NOT NULL default '0',
  `requested` datetime NOT NULL default '0000-00-00 00:00:00',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `version` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`cdkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
517

Timothy Stack's avatar
   
Timothy Stack committed
518
519
520
521
--
-- Table structure for table `checkup_types`
--

522
523
524
525
526
527
528
529
DROP TABLE IF EXISTS `checkup_types`;
CREATE TABLE `checkup_types` (
  `object_type` varchar(64) NOT NULL default '',
  `checkup_type` varchar(64) NOT NULL default '',
  `major_type` varchar(64) NOT NULL default '',
  `expiration` int(10) NOT NULL default '86400',
  PRIMARY KEY  (`object_type`,`checkup_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Timothy Stack's avatar
   
Timothy Stack committed
530
531
532
533
534

--
-- Table structure for table `checkups`
--

535
536
537
538
539
540
541
542
DROP TABLE IF EXISTS `checkups`;
CREATE TABLE `checkups` (
  `object` varchar(128) NOT NULL default '',
  `object_type` varchar(64) NOT NULL default '',
  `type` varchar(64) NOT NULL default '',
  `next` datetime default NULL,
  PRIMARY KEY  (`object`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Timothy Stack's avatar
   
Timothy Stack committed
543
544
545
546
547

--
-- Table structure for table `checkups_temp`
--

548
549
550
551
552
553
554
555
DROP TABLE IF EXISTS `checkups_temp`;
CREATE TABLE `checkups_temp` (
  `object` varchar(128) NOT NULL default '',
  `object_type` varchar(64) NOT NULL default '',
  `type` varchar(64) NOT NULL default '',
  `next` datetime default NULL,
  PRIMARY KEY  (`object`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Timothy Stack's avatar
   
Timothy Stack committed
556

557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
--
-- Table structure for table `client_service_ctl`
--

DROP TABLE IF EXISTS `client_service_ctl`;
CREATE TABLE `client_service_ctl` (
  `obj_type` enum('node_type','node','osid') NOT NULL default 'node_type',
  `obj_name` varchar(64) NOT NULL default '',
  `service_idx` int(10) NOT NULL default '0',
  `env` enum('load','boot') NOT NULL default 'boot',
  `whence` enum('first','every') NOT NULL default 'every',
  `alt_blob_id` varchar(40) NOT NULL default '',
  `enable` tinyint(1) NOT NULL default '1',
  `enable_hooks` tinyint(1) NOT NULL default '1',
  `fatal` tinyint(1) NOT NULL default '1',
  `user_can_override` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`obj_type`,`obj_name`,`service_idx`,`env`,`whence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `client_service_hooks`
--

DROP TABLE IF EXISTS `client_service_hooks`;
CREATE TABLE `client_service_hooks` (
  `obj_type` enum('node_type','node','osid') NOT NULL default 'node_type',
  `obj_name` varchar(64) NOT NULL default '',
  `service_idx` int(10) NOT NULL default '0',
  `env` enum('load','boot') NOT NULL default 'boot',
  `whence` enum('first','every') NOT NULL default 'every',
  `hook_blob_id` varchar(40) NOT NULL default '',
  `hook_op` enum('boot','shutdown','reconfig','reset') NOT NULL default 'boot',
  `hook_point` enum('pre','post') NOT NULL default 'post',
  `argv` varchar(255) NOT NULL default '',
  `fatal` tinyint(1) NOT NULL default '0',
  `user_can_override` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`obj_type`,`obj_name`,`service_idx`,`env`,`whence`,`hook_blob_id`,`hook_op`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `client_services`
--

DROP TABLE IF EXISTS `client_services`;
CREATE TABLE `client_services` (
  `idx` int(10) NOT NULL default '0',
  `service` varchar(64) NOT NULL default 'isup',
  `env` enum('load','boot') NOT NULL default 'boot',
  `whence` enum('first','every') NOT NULL default 'every',
  `hooks_only` int(1) NOT NULL default '0',
  PRIMARY KEY  (`idx`,`service`,`env`,`whence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

610
--
611
-- Table structure for table `comments`
612
--
613

614
615
616
617
618
619
620
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `table_name` varchar(64) NOT NULL default '',
  `column_name` varchar(64) NOT NULL default '',
  `description` text NOT NULL,
  UNIQUE KEY `table_name` (`table_name`,`column_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
621

622
--
623
-- Table structure for table `current_reloads`
624
--
625

626
627
628
DROP TABLE IF EXISTS `current_reloads`;
CREATE TABLE `current_reloads` (
  `node_id` varchar(32) NOT NULL default '',
629
  `idx` smallint(5) unsigned NOT NULL default '0',
630
  `image_id` int(8) unsigned NOT NULL default '0',
631
  `imageid_version` int(8) unsigned NOT NULL default '0',
632
  `mustwipe` tinyint(4) NOT NULL default '0',
633
634
  `prepare` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`node_id`,`idx`)
635
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
636

637
638
639
640
641
642
--
-- Table structure for table `daily_stats`
--

DROP TABLE IF EXISTS `daily_stats`;
CREATE TABLE `daily_stats` (
643
  `theday` date NOT NULL default '0000-00-00',
644
645
646
647
648
649
650
651
652
653
654
655
656
  `exptstart_count` int(11) unsigned default '0',
  `exptpreload_count` int(11) unsigned default '0',
  `exptswapin_count` int(11) unsigned default '0',
  `exptswapout_count` int(11) unsigned default '0',
  `exptswapmod_count` int(11) unsigned default '0',
  `allexpt_duration` int(11) unsigned default '0',
  `allexpt_vnodes` int(11) unsigned default '0',
  `allexpt_vnode_duration` int(11) unsigned default '0',
  `allexpt_pnodes` int(11) unsigned default '0',
  `allexpt_pnode_duration` int(11) unsigned default '0',
  PRIMARY KEY  (`theday`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

657
658
659
660
--
-- Table structure for table `datapository_databases`
--

661
662
663
DROP TABLE IF EXISTS `datapository_databases`;
CREATE TABLE `datapository_databases` (
  `dbname` varchar(64) NOT NULL default '',
664
665
  `pid` varchar(48) NOT NULL default '',
  `gid` varchar(32) NOT NULL default '',
666
  `uid` varchar(8) NOT NULL default '',
667
668
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
669
670
671
672
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime default NULL,
  PRIMARY KEY  (`dbname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
673

674
675
676
677
--
-- Table structure for table `default_firewall_rules`
--

678
679
DROP TABLE IF EXISTS `default_firewall_rules`;
CREATE TABLE `default_firewall_rules` (
680
  `type` enum('ipfw','ipfw2','iptables','ipfw2-vlan','iptables-vlan','iptables-dom0','iptables-domU') NOT NULL default 'ipfw',
681
682
683
684
685
686
  `style` enum('open','closed','basic','emulab') NOT NULL default 'basic',
  `enabled` tinyint(4) NOT NULL default '0',
  `ruleno` int(10) unsigned NOT NULL default '0',
  `rule` text NOT NULL,
  PRIMARY KEY  (`type`,`style`,`ruleno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
687

688
689
690
691
--
-- Table structure for table `default_firewall_vars`
--

692
693
694
695
696
697
DROP TABLE IF EXISTS `default_firewall_vars`;
CREATE TABLE `default_firewall_vars` (
  `name` varchar(255) NOT NULL default '',
  `value` text,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
698

699
--
700
-- Table structure for table `delays`
701
--
702

703
704
705
706
707
708
DROP TABLE IF EXISTS `delays`;
CREATE TABLE `delays` (
  `node_id` varchar(32) NOT NULL default '',
  `pipe0` smallint(5) unsigned NOT NULL default '0',
  `delay0` float(10,2) NOT NULL default '0.00',
  `bandwidth0` int(10) unsigned NOT NULL default '100',
709
  `backfill0` int(10) unsigned NOT NULL default '0',
710
  `lossrate0` float(10,8) NOT NULL default '0.00000000',
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
  `q0_limit` int(11) default '0',
  `q0_maxthresh` int(11) default '0',
  `q0_minthresh` int(11) default '0',
  `q0_weight` float default '0',
  `q0_linterm` int(11) default '0',
  `q0_qinbytes` tinyint(4) default '0',
  `q0_bytes` tinyint(4) default '0',
  `q0_meanpsize` int(11) default '0',
  `q0_wait` int(11) default '0',
  `q0_setbit` int(11) default '0',
  `q0_droptail` int(11) default '0',
  `q0_red` tinyint(4) default '0',
  `q0_gentle` tinyint(4) default '0',
  `pipe1` smallint(5) unsigned NOT NULL default '0',
  `delay1` float(10,2) NOT NULL default '0.00',
  `bandwidth1` int(10) unsigned NOT NULL default '100',
727
  `backfill1` int(10) unsigned NOT NULL default '0',
728
  `lossrate1` float(10,8) NOT NULL default '0.00000000',
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
  `q1_limit` int(11) default '0',
  `q1_maxthresh` int(11) default '0',
  `q1_minthresh` int(11) default '0',
  `q1_weight` float default '0',
  `q1_linterm` int(11) default '0',
  `q1_qinbytes` tinyint(4) default '0',
  `q1_bytes` tinyint(4) default '0',
  `q1_meanpsize` int(11) default '0',
  `q1_wait` int(11) default '0',
  `q1_setbit` int(11) default '0',
  `q1_droptail` int(11) default '0',
  `q1_red` tinyint(4) default '0',
  `q1_gentle` tinyint(4) default '0',
  `iface0` varchar(8) NOT NULL default '',
  `iface1` varchar(8) NOT NULL default '',
744
  `exptidx` int(11) NOT NULL default '0',
745
  `eid` varchar(32) default NULL,
746
  `pid` varchar(48) default NULL,
747
  `vname` varchar(32) default NULL,
748
749
  `vlan0` varchar(32) default NULL,
  `vlan1` varchar(32) default NULL,
750
751
752
753
754
  `vnode0` varchar(32) default NULL,
  `vnode1` varchar(32) default NULL,
  `card0` tinyint(3) unsigned default NULL,
  `card1` tinyint(3) unsigned default NULL,
  `noshaping` tinyint(1) default '0',
755
  `isbridge` tinyint(1) default '0',
756
  PRIMARY KEY  (`node_id`,`iface0`,`iface1`),
757
758
  KEY `pid` (`pid`,`eid`),
  KEY `exptidx` (`exptidx`)
759
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
760

761
--
Timothy Stack's avatar
   
Timothy Stack committed
762
-- Table structure for table `deleted_users`
763
--
764

765
766
767
768
769
770
771
772
773
DROP TABLE IF EXISTS `deleted_users`;
CREATE TABLE `deleted_users` (
  `uid` varchar(8) NOT NULL default '',
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `usr_created` datetime default NULL,
  `usr_deleted` datetime default NULL,
  `usr_name` tinytext,
  `usr_title` tinytext,
  `usr_affil` tinytext,
774
  `usr_affil_abbrev` varchar(16) default NULL,
775
776
777
778
779
780
781
782
783
784
785
786
787
788
  `usr_email` tinytext,
  `usr_URL` tinytext,
  `usr_addr` tinytext,
  `usr_addr2` tinytext,
  `usr_city` tinytext,
  `usr_state` tinytext,
  `usr_zip` tinytext,
  `usr_country` tinytext,
  `usr_phone` tinytext,
  `webonly` tinyint(1) default '0',
  `wikionly` tinyint(1) default '0',
  `notes` text,
  PRIMARY KEY  (`uid_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
789
790
791
792
793

--
-- Table structure for table `delta_inst`
--

794
795
796
797
798
799
800
DROP TABLE IF EXISTS `delta_inst`;
CREATE TABLE `delta_inst` (
  `node_id` varchar(32) NOT NULL default '',
  `partition` tinyint(4) NOT NULL default '0',
  `delta_id` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`node_id`,`partition`,`delta_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
801

802
--
803
-- Table structure for table `delta_proj`
804
--
805

806
807
808
DROP TABLE IF EXISTS `delta_proj`;
CREATE TABLE `delta_proj` (
  `delta_id` varchar(10) NOT NULL default '',
809
  `pid` varchar(48) NOT NULL default '',
810
811
  PRIMARY KEY  (`delta_id`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
812

813
--
814
-- Table structure for table `deltas`
815
--
816

817
818
819
820
821
822
823
824
DROP TABLE IF EXISTS `deltas`;
CREATE TABLE `deltas` (
  `delta_id` varchar(10) NOT NULL default '',
  `delta_desc` text,
  `delta_path` text NOT NULL,
  `private` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`delta_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
825

826
827
828
829
--
-- Table structure for table `elabinelab_attributes`
--

830
DROP TABLE IF EXISTS `elabinelab_attributes`;
831
CREATE TABLE `elabinelab_attributes` (
832
  `pid` varchar(48) NOT NULL default '',
833
834
835
836
837
  `eid` varchar(32) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
  `role` enum('boss','router','ops','fs','node') NOT NULL default 'node',
  `attrkey` varchar(32) NOT NULL default '',
  `attrvalue` tinytext NOT NULL,
838
839
  `ordering` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`exptidx`,`role`,`attrkey`,`ordering`)
840
841
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

842
843
844
845
--
-- Table structure for table `elabinelab_vlans`
--

846
847
DROP TABLE IF EXISTS `elabinelab_vlans`;
CREATE TABLE `elabinelab_vlans` (
848
  `pid` varchar(48) NOT NULL default '',
849
  `eid` varchar(32) NOT NULL default '',
850
  `exptidx` int(11) NOT NULL default '0',
851
852
853
  `inner_id` varchar(32) NOT NULL default '',
  `outer_id` varchar(32) NOT NULL default '',
  `stack` enum('Control','Experimental') NOT NULL default 'Experimental',
854
855
  PRIMARY KEY  (`exptidx`,`inner_id`),
  UNIQUE KEY `pideid` (`pid`,`eid`,`inner_id`)
856
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
857

858
859
860
861
862
863
864
865
866
867
868
869
870
871
--
-- Table structure for table `emulab_features`
--

DROP TABLE IF EXISTS `emulab_features`;
CREATE TABLE `emulab_features` (
  `feature` varchar(64) NOT NULL default '',
  `description` mediumtext,
  `added` datetime NOT NULL,
  `enabled` tinyint(1) NOT NULL default '0',
  `disabled` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`feature`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

872
873
874
875
--
-- Table structure for table `emulab_indicies`
--

876
877
878
879
880
881
DROP TABLE IF EXISTS `emulab_indicies`;
CREATE TABLE `emulab_indicies` (
  `name` varchar(64) NOT NULL default '',
  `idx` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
882

883
884
885
886
887
888
889
--
-- Table structure for table `emulab_locks`
--

DROP TABLE IF EXISTS `emulab_locks`;
CREATE TABLE `emulab_locks` (
  `name` varchar(64) NOT NULL default '',
890
  `value` int(10) NOT NULL default '0',
891
892
893
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

894
895
896
897
898
899
900
901
902
903
904
905
906
907
--
-- Table structure for table `emulab_peers`
--

DROP TABLE IF EXISTS `emulab_peers`;
CREATE TABLE `emulab_peers` (
  `name` varchar(64) NOT NULL default '',
  `urn` varchar(128) NOT NULL default '',
  `is_primary` tinyint(1) NOT NULL default '0',
  `weburl` tinytext,
  PRIMARY KEY  (`name`),
  UNIQUE KEY `urn` (`urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Kevin Atkinson's avatar
   
Kevin Atkinson committed
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
--
-- Table structure for table `emulab_pubs`
--

DROP TABLE IF EXISTS `emulab_pubs`;
CREATE TABLE `emulab_pubs` (
  `idx` int(10) unsigned NOT NULL auto_increment,
  `uuid` varchar(40) NOT NULL,
  `created` datetime NOT NULL,
  `owner` mediumint(8) unsigned NOT NULL,
  `submitted_by` mediumint(8) unsigned NOT NULL,
  `last_edit` datetime NOT NULL,
  `last_edit_by` mediumint(8) unsigned NOT NULL,
  `type` tinytext NOT NULL,
  `authors` tinytext NOT NULL,
  `affil` tinytext NOT NULL,
  `title` tinytext NOT NULL,
  `conf` tinytext NOT NULL,
  `conf_url` tinytext NOT NULL,
  `where` tinytext NOT NULL,
  `year` tinytext NOT NULL,
  `month` float(3,1) NOT NULL,
  `volume` tinytext NOT NULL,
  `number` tinytext NOT NULL,
  `pages` tinytext NOT NULL,
  `url` tinytext NOT NULL,
  `evaluated_on_emulab` tinytext NOT NULL,
  `category` tinytext NOT NULL,
  `project` tinytext NOT NULL,
  `cite_osdi02` tinyint(1) default NULL,
  `no_cite_why` tinytext NOT NULL,
  `notes` text NOT NULL,
  `visible` tinyint(1) NOT NULL default '1',
  `deleted` tinyint(1) NOT NULL default '0',
  `editable_owner` tinyint(1) NOT NULL default '1',
  `editable_proj` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `emulab_pubs_month_map`
--

DROP TABLE IF EXISTS `emulab_pubs_month_map`;
CREATE TABLE `emulab_pubs_month_map` (
  `display_order` int(10) unsigned NOT NULL auto_increment,
  `month` float(3,1) NOT NULL,
  `month_name` char(8) NOT NULL,
  PRIMARY KEY  (`month`),
  UNIQUE KEY `display_order` (`display_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
--
-- Table structure for table `emulab_sites`
--

DROP TABLE IF EXISTS `emulab_sites`;
CREATE TABLE `emulab_sites` (
  `urn` varchar(128) NOT NULL default '',
  `commonname` varchar(64) NOT NULL,
  `url` tinytext,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `buildinfo` datetime NOT NULL,
  `commithash` varchar(64) NOT NULL,
  `dbrev` tinytext NOT NULL,
  `install` tinytext NOT NULL,
  `os_version` tinytext NOT NULL,
  `perl_version` tinytext NOT NULL,
  `tbops` tinytext,
  UNIQUE KEY `commonname` (`commonname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Kevin Atkinson's avatar
   
Kevin Atkinson committed
982
983
984
985
--
-- Table structure for table `errors`
--

986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
DROP TABLE IF EXISTS `errors`;
CREATE TABLE `errors` (
  `session` int(10) unsigned NOT NULL default '0',
  `rank` tinyint(1) NOT NULL default '0',
  `stamp` int(10) unsigned NOT NULL default '0',
  `exptidx` int(11) NOT NULL default '0',
  `script` smallint(3) NOT NULL default '0',
  `cause` varchar(16) NOT NULL default '',
  `confidence` float NOT NULL default '0',
  `inferred` tinyint(1) default NULL,
  `need_more_info` tinyint(1) default NULL,
  `mesg` text NOT NULL,
  `tblog_revision` varchar(8) NOT NULL default '',
  PRIMARY KEY  (`session`,`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Kevin Atkinson's avatar
Kevin Atkinson committed
1001

1002
--
1003
-- Table structure for table `event_eventtypes`
1004
--
Robert Ricci's avatar
Robert Ricci committed
1005

1006
1007
1008
1009
1010
1011
DROP TABLE IF EXISTS `event_eventtypes`;
CREATE TABLE `event_eventtypes` (
  `idx` smallint(5) unsigned NOT NULL default '0',
  `type` tinytext NOT NULL,
  PRIMARY KEY  (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Robert Ricci's avatar
Robert Ricci committed
1012

Leigh B. Stoller's avatar
Leigh B. Stoller committed
1013
1014
1015
1016
--
-- Table structure for table `event_groups`
--

1017
1018
DROP TABLE IF EXISTS `event_groups`;
CREATE TABLE `event_groups` (
1019
  `pid` varchar(48) NOT NULL default '',
1020
  `eid` varchar(32) NOT NULL default '',
1021
  `exptidx` int(11) NOT NULL default '0',
1022
1023
1024
  `idx` int(10) unsigned NOT NULL auto_increment,
  `group_name` varchar(64) NOT NULL default '',
  `agent_name` varchar(64) NOT NULL default '',
1025
1026
  PRIMARY KEY  (`exptidx`,`idx`),
  UNIQUE KEY `pideid` (`pid`,`eid`,`idx`),
1027
1028
1029
  KEY `group_name` (`group_name`),
  KEY `agent_name` (`agent_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1030

1031
1032
1033
1034
--
-- Table structure for table `event_objecttypes`
--

1035
1036
1037
1038
1039
1040
DROP TABLE IF EXISTS `event_objecttypes`;
CREATE TABLE `event_objecttypes` (
  `idx` smallint(5) unsigned NOT NULL default '0',
  `type` tinytext NOT NULL,
  PRIMARY KEY  (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1041

1042
1043
1044
1045
1046
1047
1048
1049
--
-- Table structure for table `event_triggertypes`
--

DROP TABLE IF EXISTS `event_triggertypes`;
CREATE TABLE `event_triggertypes` (
  `idx` smallint(5) unsigned NOT NULL,
  `type` tinytext NOT NULL,
1050
  PRIMARY KEY  (`idx`)
1051
1052
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1053
--
1054
-- Table structure for table `eventlist`
1055
--
1056

1057
1058
DROP TABLE IF EXISTS `eventlist`;
CREATE TABLE `eventlist` (
1059
  `pid` varchar(48) NOT NULL default '',
1060
  `eid` varchar(32) NOT NULL default '',
1061
  `exptidx` int(11) NOT NULL default '0',
1062
1063
1064
1065
1066
1067
  `idx` int(10) unsigned NOT NULL auto_increment,
  `time` float(10,3) NOT NULL default '0.000',
  `vnode` varchar(32) NOT NULL default '',
  `vname` varchar(64) NOT NULL default '',
  `objecttype` smallint(5) unsigned NOT NULL default '0',
  `eventtype` smallint(5) unsigned NOT NULL default '0',
1068
  `triggertype` smallint(5) unsigned NOT NULL default '0',
1069
1070
1071
1072
  `isgroup` tinyint(1) unsigned default '0',
  `arguments` text,
  `atstring` text,
  `parent` varchar(64) NOT NULL default '',
1073
1074
  PRIMARY KEY  (`exptidx`,`idx`),
  UNIQUE KEY `pideid` (`pid`,`eid`,`idx`),
1075
1076
  KEY `vnode` (`vnode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1077

1078
1079
1080
1081
1082
1083
1084
--
-- Table structure for table `experiment_blobs`
--

DROP TABLE IF EXISTS `experiment_blobs`;
CREATE TABLE `experiment_blobs` (
  `idx` int(11) unsigned NOT NULL auto_increment,
1085
  `pid` varchar(48) NOT NULL default '',
1086
1087
1088
1089
1090
  `eid` varchar(32) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  `action` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idx`),
1091
1092
  UNIQUE KEY `exptidx` (`exptidx`,`path`,`action`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1093

1094
1095
1096
1097
1098
1099
1100
1101
1102
--
-- Table structure for table `experiment_features`
--

DROP TABLE IF EXISTS `experiment_features`;
CREATE TABLE `experiment_features` (
  `feature` varchar(64) NOT NULL default '',
  `added` datetime NOT NULL,
  `exptidx` int(11) NOT NULL default '0',
1103
  `pid` varchar(48) NOT NULL default '',
1104
  `eid` varchar(32) NOT NULL default '',
1105
  PRIMARY KEY  (`feature`,`exptidx`)
1106
1107
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
--
-- Table structure for table `experiment_input_data`
--

DROP TABLE IF EXISTS `experiment_input_data`;
CREATE TABLE `experiment_input_data` (
  `idx` int(10) unsigned NOT NULL auto_increment,
  `md5` varchar(32) NOT NULL default '',
  `compressed` tinyint(1) unsigned default '0',
  `input` mediumblob,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `md5` (`md5`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
1123
-- Table structure for table `experiment_inputs`
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
--

DROP TABLE IF EXISTS `experiment_inputs`;
CREATE TABLE `experiment_inputs` (
  `rsrcidx` int(10) unsigned NOT NULL default '0',
  `exptidx` int(10) unsigned NOT NULL default '0',
  `input_data_idx` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rsrcidx`,`input_data_idx`),
  KEY `rsrcidx` (`rsrcidx`),
  KEY `exptidx` (`exptidx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `experiment_pmapping`
--

DROP TABLE IF EXISTS `experiment_pmapping`;
CREATE TABLE `experiment_pmapping` (
  `rsrcidx` int(10) unsigned NOT NULL default '0',
1143
  `vname` varchar(32) NOT NULL default '',
1144
1145
1146
1147
1148
1149
  `node_id` varchar(32) NOT NULL default '',
  `node_type` varchar(30) NOT NULL default '',
  `node_erole` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`rsrcidx`,`vname`,`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1150
--
1151
-- Table structure for table `experiment_resources`
1152
1153
--

1154
1155
1156
1157
1158
1159
DROP TABLE IF EXISTS `experiment_resources`;
CREATE TABLE `experiment_resources` (
  `idx` int(10) unsigned NOT NULL auto_increment,
  `exptidx` int(10) unsigned NOT NULL default '0',
  `lastidx` int(10) unsigned default NULL,
  `tstamp` datetime default NULL,
1160
1161
1162
1163
1164
1165
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `swapin_time` int(10) unsigned NOT NULL default '0',
  `swapout_time` int(10) unsigned NOT NULL default '0',
  `swapmod_time` int(10) unsigned NOT NULL default '0',
  `byswapmod` tinyint(1) unsigned default '0',
  `byswapin` tinyint(1) unsigned default '0',
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
  `vnodes` smallint(5) unsigned default '0',
  `pnodes` smallint(5) unsigned default '0',
  `wanodes` smallint(5) unsigned default '0',
  `plabnodes` smallint(5) unsigned default '0',
  `simnodes` smallint(5) unsigned default '0',
  `jailnodes` smallint(5) unsigned default '0',
  `delaynodes` smallint(5) unsigned default '0',
  `linkdelays` smallint(5) unsigned default '0',
  `walinks` smallint(5) unsigned default '0',
  `links` smallint(5) unsigned default '0',
  `lans` smallint(5) unsigned default '0',
  `shapedlinks` smallint(5) unsigned default '0',
  `shapedlans` smallint(5) unsigned default '0',
  `wirelesslans` smallint(5) unsigned default '0',
  `minlinks` tinyint(3) unsigned default '0',
  `maxlinks` tinyint(3) unsigned default '0',
  `delay_capacity` tinyint(3) unsigned default NULL,
  `batchmode` tinyint(1) unsigned default '0',
  `archive_tag` varchar(64) default NULL,
1185
  `input_data_idx` int(10) unsigned default NULL,
1186
1187
1188
  `thumbnail` mediumblob,
  PRIMARY KEY  (`idx`),
  KEY `exptidx` (`exptidx`),
1189
  KEY `lastidx` (`lastidx`),
1190
  KEY `inputdata` (`input_data_idx`)
1191
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1192

1193
1194
1195
1196
--
-- Table structure for table `experiment_run_bindings`
--

1197
1198
1199
1200
1201
1202
1203
1204
DROP TABLE IF EXISTS `experiment_run_bindings`;
CREATE TABLE `experiment_run_bindings` (
  `exptidx` int(10) unsigned NOT NULL default '0',
  `runidx` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `value` tinytext NOT NULL,
  PRIMARY KEY  (`exptidx`,`runidx`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1205
1206
1207
1208
1209

--
-- Table structure for table `experiment_runs`
--

1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
DROP TABLE IF EXISTS `experiment_runs`;
CREATE TABLE `experiment_runs` (
  `exptidx` int(10) unsigned NOT NULL default '0',
  `idx` int(10) unsigned NOT NULL auto_increment,
  `runid` varchar(32) NOT NULL default '',
  `description` tinytext,
  `starting_archive_tag` varchar(64) default NULL,
  `ending_archive_tag` varchar(64) default NULL,
  `archive_tag` varchar(64) default NULL,
  `start_time` datetime default NULL,
  `stop_time` datetime default NULL,
  `swapmod` tinyint(1) NOT NULL default '0',
1222
  `hidden` tinyint(1) NOT NULL default '0',
1223
1224
  PRIMARY KEY  (`exptidx`,`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1225

1226
--
1227
-- Table structure for table `experiment_stats`
1228
--
1229

1230
1231
DROP TABLE IF EXISTS `experiment_stats`;
CREATE TABLE `experiment_stats` (
1232
  `pid` varchar(48) NOT NULL default '',
1233
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
1234
  `eid` varchar(32) NOT NULL default '',
1235
  `eid_uuid` varchar(40) NOT NULL default '',
1236
1237
1238
1239
1240
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `exptidx` int(10) unsigned NOT NULL default '0',
  `rsrcidx` int(10) unsigned NOT NULL default '0',
  `lastrsrc` int(10) unsigned default NULL,
1241
  `gid` varchar(32) NOT NULL default '',
1242
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
1243
1244
  `created` datetime default NULL,
  `destroyed` datetime default NULL,
1245
  `last_activity` datetime default NULL,
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
  `swapin_count` smallint(5) unsigned default '0',
  `swapin_last` datetime default NULL,
  `swapout_count` smallint(5) unsigned default '0',
  `swapout_last` datetime default NULL,
  `swapmod_count` smallint(5) unsigned default '0',
  `swapmod_last` datetime default NULL,
  `swap_errors` smallint(5) unsigned default '0',
  `swap_exitcode` tinyint(3) unsigned default '0',
  `idle_swaps` smallint(5) unsigned default '0',
  `swapin_duration` int(10) unsigned default '0',
  `batch` tinyint(3) unsigned default '0',
  `elabinelab` tinyint(1) NOT NULL default '0',
  `elabinelab_exptidx` int(10) unsigned default NULL,
  `security_level` tinyint(1) NOT NULL default '0',
  `archive_idx` int(10) unsigned default NULL,
  `last_error` int(10) unsigned default NULL,
  `dpdbname` varchar(64) default NULL,
1263
1264
  `geniflags` int(10) unsigned default NULL,
  `slice_uuid` varchar(40) default NULL,
Leigh B Stoller's avatar