database-create.sql 198 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
61
62
63
64
65
66
67
68
69
70
--
-- Table structure for table `apt_aggregate_nodetypes`
--

DROP TABLE IF EXISTS `apt_aggregate_nodetypes`;
CREATE TABLE `apt_aggregate_nodetypes` (
  `urn` varchar(128) NOT NULL default '',
  `type` varchar(30) NOT NULL default '',
  `count` int(11) default '0',
  `free` int(11) default '0',
  `updated` datetime default NULL,
  PRIMARY KEY  (`urn`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

71
--
72
-- Table structure for table `apt_aggregates`
73
74
--

75
76
DROP TABLE IF EXISTS `apt_aggregates`;
CREATE TABLE `apt_aggregates` (
Leigh B Stoller's avatar
Leigh B Stoller committed
77
  `urn` varchar(128) NOT NULL default '',
78
79
80
  `name` varchar(32) NOT NULL default '',
  `nickname` varchar(32) NOT NULL default '',
  `abbreviation` varchar(16) NOT NULL default '',
81
82
  `adminonly` tinyint(1) NOT NULL default '0',
  `isfederate` tinyint(1) NOT NULL default '0',
83
  `disabled` tinyint(1) NOT NULL default '0',
Leigh B Stoller's avatar
Leigh B Stoller committed
84
  `noupdate` tinyint(1) NOT NULL default '0',
85
86
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `weburl` tinytext,
87
  `has_datasets` tinyint(1) NOT NULL default '0',
88
  `reservations` tinyint(1) NOT NULL default '0',
89
  `portals` set('emulab','aptlab','cloudlab','phantomnet') default NULL,
90
91
92
93
94
95
96
97
  `jsondata` text,
  PRIMARY KEY  (`urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

98
99
100
101
102
103
104
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',
105
106
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
107
108
109
  `creator_uid` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `aggregate_urn` varchar(128) default NULL,
110
  `remote_urn` varchar(128) NOT NULL default '',
111
  `remote_uuid` varchar(40) NOT NULL default '',
112
  `remote_url` tinytext,
113
  `created` datetime default NULL,
114
  `updated` datetime default NULL,
115
116
117
  `expires` datetime default NULL,
  `last_used` datetime default NULL,
  `state` enum('new','valid','unapproved','grace','locked','expired','busy') NOT NULL default 'new',  
118
  `type` enum('stdataset','ltdataset','imdataset','unknown') NOT NULL default 'unknown',
119
120
  `fstype` varchar(40) NOT NULL default 'none',
  `size` int(10) unsigned NOT NULL default '0',
121
122
  `read_access` enum('project','global') NOT NULL default 'project',
  `write_access` enum('creator','project') NOT NULL default 'creator',
123
124
  `public` tinyint(1) NOT NULL default '0',
  `shared` tinyint(1) NOT NULL default '0',
125
126
  `locked` datetime default NULL, 
  `locker_pid` int(11) default '0',
127
  `credential_string` text,
128
129
  PRIMARY KEY (`idx`),
  UNIQUE KEY `plid` (`pid_idx`,`dataset_id`),
130
  UNIQUE KEY `uuid` (`uuid`)
131
132
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

133
134
135
136
137
138
139
140
--
-- 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
141
  `aggregate_urn` varchar(128) NOT NULL default '',
142
143
144
145
146
147
148
149
150
  `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;

151
152
153
154
155
156
157
158
--
-- 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,
159
  `aggregate_urn` varchar(128) NOT NULL default '',
160
  `status` varchar(32) default NULL,
161
162
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
163
164
165
166
167
168
  `public_url` tinytext,
  `webtask_id` varchar(128) NOT NULL default '',
  `manifest` mediumtext,
  PRIMARY KEY (`uuid`,`aggregate_urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

169
170
171
172
173
174
175
176
177
178
179
180
--
-- Table structure for table `apt_instance_extension_info`
--

DROP TABLE IF EXISTS `apt_instance_extension_info`;
CREATE TABLE `apt_instance_extension_info` (
  `uuid` varchar(40) NOT NULL default '',
  `idx` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(16) NOT NULL default '',
  `tstamp` datetime default NULL,
  `uid` varchar(8) NOT NULL default '',
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
181
  `action` enum('request','deny','info') NOT NULL default 'request',
182
183
184
185
186
187
188
189
  `wanted` smallint(5) unsigned NOT NULL default '0',
  `granted` smallint(5) unsigned default NULL,
  `admin` tinyint(1) NOT NULL default '0',
  `reason` mediumtext,
  `message` mediumtext,
  PRIMARY KEY (`uuid`,`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
--
-- Table structure for table `apt_instance_failures`
--

DROP TABLE IF EXISTS `apt_instance_failures`;
CREATE TABLE `apt_instance_failures` (
  `uuid` varchar(40) NOT NULL default '',
  `name` varchar(16) default NULL,
  `profile_id` int(10) unsigned NOT NULL default '0',
  `profile_version` int(10) unsigned NOT NULL default '0',
  `slice_uuid` varchar(40) default NULL,
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `creator_uuid` varchar(40) NOT NULL default '',
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
206
207
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
208
209
210
  `created` datetime default NULL,
  `exitcode` int(10) default '0',
  `exitmessage` mediumtext,
211
  `public_url` tinytext,
212
  `logfileid` varchar(40) default NULL,
213
214
215
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
216
--
217
-- Table structure for table `apt_instance_history`
Leigh B Stoller's avatar
Leigh B Stoller committed
218
219
--

220
221
222
DROP TABLE IF EXISTS `apt_instance_history`;
CREATE TABLE `apt_instance_history` (
  `uuid` varchar(40) NOT NULL default '',
223
  `name` varchar(16) default NULL,
224
225
226
227
228
229
  `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 '',
230
231
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
232
233
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
234
  `aggregate_urn` varchar(128) default NULL,
235
  `public_url` tinytext,
236
  `logfileid` varchar(40) default NULL,
237
238
  `created` datetime default NULL,
  `destroyed` datetime default NULL,
239
  `expired` tinyint(1) NOT NULL default '0',
240
241
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
242
243
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
244
  `servername` tinytext,
245
246
247
  `rspec` mediumtext,
  `params` mediumtext,
  `manifest` mediumtext,
248
249
  PRIMARY KEY (`uuid`),
  KEY `profile_id` (`profile_id`)
250
251
252
253
254
255
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

Leigh B Stoller's avatar
Leigh B Stoller committed
256
257
258
DROP TABLE IF EXISTS `apt_instances`;
CREATE TABLE `apt_instances` (
  `uuid` varchar(40) NOT NULL default '',
259
  `name` varchar(16) default NULL,
260
261
  `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
262
263
264
265
  `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 '',
266
267
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
268
269
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
270
  `aggregate_urn` varchar(128) default NULL,
271
  `public_url` tinytext,
Leigh B Stoller's avatar
Leigh B Stoller committed
272
273
  `created` datetime default NULL,
  `status` varchar(32) default NULL,
274
  `status_timestamp` datetime default NULL,
275
276
  `canceled` tinyint(2) NOT NULL default '0',
  `canceled_timestamp` datetime default NULL,
277
278
  `paniced` tinyint(2) NOT NULL default '0',
  `paniced_timestamp` datetime default NULL,
279
280
  `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
281
  `extension_code` varchar(32) default NULL,
282
  `extension_reason` mediumtext,
283
  `extension_history` mediumtext,
284
  `extension_adminonly` tinyint(1) NOT NULL default '0',
285
  `extension_requested` tinyint(1) NOT NULL default '0',
286
287
  `extension_denied` tinyint(1) NOT NULL default '0',
  `extension_denied_reason` mediumtext,
288
289
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
290
291
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
292
  `servername` tinytext,
293
  `monitor_pid` int(11) default '0',
294
  `needupdate` tinyint(3) NOT NULL default '0',
295
  `isopenstack` tinyint(1) NOT NULL default '0',
296
  `logfileid` varchar(40) default NULL,
297
298
  `cert` mediumtext,
  `privkey` mediumtext,
299
300
  `rspec` mediumtext,
  `params` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
301
  `manifest` mediumtext,
302
  `openstack_utilization` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
303
304
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Timothy Stack's avatar
   
Timothy Stack committed
305

306
--
307
-- Table structure for table `apt_profile_favorites`
308
309
--

310
311
312
313
314
315
316
317
318
319
320
321
322
DROP TABLE IF EXISTS `apt_profile_favorites`;
CREATE TABLE `apt_profile_favorites` (
  `uid` varchar(8) NOT NULL default '',
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `profileid` int(10) unsigned NOT NULL default '0',  
  `marked` datetime default NULL,
  PRIMARY KEY (`uid_idx`,`profileid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `apt_profile_versions`
--

323
DROP TABLE IF EXISTS `apt_profile_versions`;
324
325
326
327
328
329
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',
330
331
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
332
333
334
335
336
  `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,
337
  `disabled` tinyint(1) NOT NULL default '0',
338
339
340
341
342
  `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,
343
  `script` mediumtext,
344
  `paramdefs` mediumtext,
345
346
347
348
  PRIMARY KEY (`profileid`,`version`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

349
350
351
352
353
354
355
--
-- Table structure for table `apt_profiles`
--

DROP TABLE IF EXISTS `apt_profiles`;
CREATE TABLE `apt_profiles` (
  `name` varchar(64) NOT NULL default '',
356
357
  `profileid` int(10) unsigned NOT NULL default '0',  
  `version` int(8) unsigned NOT NULL default '0',
358
359
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
360
361
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
362
  `uuid` varchar(40) NOT NULL,
363
  `public` tinyint(1) NOT NULL default '0',
364
365
  `shared` tinyint(1) NOT NULL default '0',
  `listed` tinyint(1) NOT NULL default '0',
366
  `topdog` tinyint(1) NOT NULL default '0',
367
  `disabled` tinyint(1) NOT NULL default '0',
368
  `locked` datetime default NULL,
369
370
371
  `locker_pid` int(11) default '0',
  PRIMARY KEY (`profileid`),
  UNIQUE KEY `pidname` (`pid_idx`,`name`,`version`)
372
373
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

374
375
376
377
378
379
380
381
382
383
384

--
-- Table structure for table `apt_announcements`
--

DROP TABLE IF EXISTS `apt_announcements`;
CREATE TABLE `apt_announcements` (
  `idx` int(10) unsigned NOT NULL auto_increment,
  `created` datetime default NULL,
  `uid_idx` int(10) default NULL,
  `genesis` varchar(64) NOT NULL default 'emulab',
385
  `portal` varchar(64) NOT NULL default 'emulab',
386
  `retired` tinyint(1) NOT NULL default '0',
387
  `max_seen` int(8) NOT NULL default '20',
Jonathon Duerig's avatar
Jonathon Duerig committed
388
  `text` mediumtext,
389
  `style` varchar(64) NOT NULL default 'alert-info',
Jonathon Duerig's avatar
Jonathon Duerig committed
390
391
  `link_label` tinytext,
  `link_url` tinytext,
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `apt_announcement_info`
-- 

DROP TABLE IF EXISTS `apt_announcement_info`;
CREATE TABLE `apt_announcement_info` (
  `idx` int(10) unsigned NOT NULL auto_increment,
  `aid` int(10) NOT NULL default '0',
  `uid_idx` int(10) default NULL,
  `dismissed` tinyint(1) NOT NULL default '0',
  `clicked` tinyint(1) NOT NULL default '0',
  `seen_count` int(8) NOT NULL default '0',
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
--
-- 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;

427
428
429
430
--
-- Table structure for table `archive_tags`
--

431
432
433
434
435
436
437
438
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',
439
  `version` tinyint(1) default '0',
440
441
442
443
  `description` text,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `tag` (`tag`,`archive_idx`,`view`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
444
445
446
447
448

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

449
450
451
452
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',
453
454
  `revision` int(10) unsigned default NULL,
  `current_tag` varchar(64) default NULL,
455
456
457
458
  `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,
459
  `parent_revision` int(10) unsigned default NULL,
460
461
  PRIMARY KEY  (`view`,`archive_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
462
463
464
465
466

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

467
468
469
470
471
472
473
474
475
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;
476

477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
--
-- 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,
497
  `owner_uid` varchar(8) NOT NULL default '',
498
499
  `vblob_id` varchar(40) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
500
501
502
  PRIMARY KEY  (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

503
504
505
506
507
508
509
510
511
512
513
514
515
--
-- 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;

516
517
518
519
520
521
522
523
524
525
--
-- 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',
526
  `ready` tinyint(4) unsigned NOT NULL default '0',
527
528
529
530
  PRIMARY KEY (`bsidx`),
  UNIQUE KEY nidbid (`node_id`,`bs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

531
532
533
534
535
536
537
538
539
540
541
542
--
-- 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;

543
544
545
546
547
548
549
550
551
552
--
-- 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',
553
  `isfeature` tinyint(4) unsigned NOT NULL default '0',
554
555
556
557
558
559
560
561
562
563
564
565
  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 '',
566
  `lease_idx` int(10) unsigned NOT NULL default '0',
567
  `type` varchar(30) NOT NULL default '',
568
  `role` enum('element','compound','partition') NOT NULL default 'element',
569
  `total_size` int(10) unsigned NOT NULL default '0',
570
  `exported` tinyint(1) NOT NULL default '0',
571
572
  `inception` datetime default NULL,
  PRIMARY KEY (`bsidx`),
573
  UNIQUE KEY nidbid (`node_id`,`bs_id`,`lease_idx`)
574
575
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
576
577
578
579
580
581
--
-- Table structure for table `bridges`
--

DROP TABLE IF EXISTS `bridges`;
CREATE TABLE `bridges` (
582
  `pid` varchar(48) default NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
583
584
585
586
587
588
589
590
591
592
593
594
  `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;

595
596
597
598
--
-- Table structure for table `buildings`
--

599
600
601
602
603
604
605
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;
606

607
608
609
610
--
-- Table structure for table `cameras`
--

611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
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;
628

Kevin Atkinson's avatar
   
Kevin Atkinson committed
629
630
631
632
--
-- Table structure for table `causes`
--

633
634
635
636
637
638
639
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
640

641
--
642
-- Table structure for table `cdroms`
643
--
644

645
646
647
648
649
650
651
652
653
654
655
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;
656

Timothy Stack's avatar
   
Timothy Stack committed
657
658
659
660
--
-- Table structure for table `checkup_types`
--

661
662
663
664
665
666
667
668
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
669
670
671
672
673

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

674
675
676
677
678
679
680
681
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
682
683
684
685
686

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

687
688
689
690
691
692
693
694
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
695

696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
--
-- 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;

749
--
750
-- Table structure for table `comments`
751
--
752

753
754
755
756
757
758
759
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;
760

761
--
762
-- Table structure for table `current_reloads`
763
--
764

765
766
767
DROP TABLE IF EXISTS `current_reloads`;
CREATE TABLE `current_reloads` (
  `node_id` varchar(32) NOT NULL default '',
768
  `idx` smallint(5) unsigned NOT NULL default '0',
769
  `image_id` int(8) unsigned NOT NULL default '0',
770
  `imageid_version` int(8) unsigned NOT NULL default '0',
771
  `mustwipe` tinyint(4) NOT NULL default '0',
772
773
  `prepare` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`node_id`,`idx`)
774
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
775

776
777
778
779
780
781
--
-- Table structure for table `daily_stats`
--

DROP TABLE IF EXISTS `daily_stats`;
CREATE TABLE `daily_stats` (
782
  `theday` date NOT NULL default '0000-00-00',
783
784
785
786
787
788
789
790
791
792
793
794
795
  `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;

796
797
798
799
--
-- Table structure for table `datapository_databases`
--

800
801
802
DROP TABLE IF EXISTS `datapository_databases`;
CREATE TABLE `datapository_databases` (
  `dbname` varchar(64) NOT NULL default '',
803
804
  `pid` varchar(48) NOT NULL default '',
  `gid` varchar(32) NOT NULL default '',
805
  `uid` varchar(8) NOT NULL default '',
806
807
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
808
809
810
811
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime default NULL,
  PRIMARY KEY  (`dbname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
812

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

817
818
DROP TABLE IF EXISTS `default_firewall_rules`;
CREATE TABLE `default_firewall_rules` (
819
  `type` enum('ipfw','ipfw2','iptables','ipfw2-vlan','iptables-vlan','iptables-dom0','iptables-domU') NOT NULL default 'ipfw',
820
821
822
823
824
825
  `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;
826

827
828
829
830
--
-- Table structure for table `default_firewall_vars`
--

831
832
833
834
835
836
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;
837

838
--
839
-- Table structure for table `delays`
840
--
841

842
843
844
845
846
847
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',
848
  `backfill0` int(10) unsigned NOT NULL default '0',
849
  `lossrate0` float(10,8) NOT NULL default '0.00000000',
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
  `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',
866
  `backfill1` int(10) unsigned NOT NULL default '0',
867
  `lossrate1` float(10,8) NOT NULL default '0.00000000',
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
  `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 '',
883
884
  `viface_unit0` int(10) default NULL,
  `viface_unit1` int(10) default NULL,
885
  `exptidx` int(11) NOT NULL default '0',
886
  `eid` varchar(32) default NULL,
887
  `pid` varchar(48) default NULL,
888
  `vname` varchar(32) default NULL,
889
890
891
892
  `vlan0` varchar(32) NOT NULL default '',
  `vlan1` varchar(32) NOT NULL default '',
  `vnode0` varchar(32) NOT NULL default '',
  `vnode1` varchar(32) NOT NULL default '',
893
894
895
  `card0` tinyint(3) unsigned default NULL,
  `card1` tinyint(3) unsigned default NULL,
  `noshaping` tinyint(1) default '0',
896
  `isbridge` tinyint(1) default '0',
897
  PRIMARY KEY  (`node_id`,`iface0`,`iface1`,`vlan0`,`vlan1`,`vnode0`,`vnode1`),
898
899
  KEY `pid` (`pid`,`eid`),
  KEY `exptidx` (`exptidx`)
900
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
901

902
--
Timothy Stack's avatar
   
Timothy Stack committed
903
-- Table structure for table `deleted_users`
904
--
905

906
907
908
909
910
911
912
913
914
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,
915
  `usr_affil_abbrev` varchar(16) default NULL,
916
917
918
919
920
921
922
923
924
925
926
927
928
929
  `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;
930
931
932
933
934

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

935
936
937
938
939
940
941
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;
942

943
--
944
-- Table structure for table `delta_proj`
945
--
946

947
948
949
DROP TABLE IF EXISTS `delta_proj`;
CREATE TABLE `delta_proj` (
  `delta_id` varchar(10) NOT NULL default '',
950
  `pid` varchar(48) NOT NULL default '',
951
952
  PRIMARY KEY  (`delta_id`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
953

954
--
955
-- Table structure for table `deltas`
956
--
957

958
959
960
961
962
963
964
965
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;
966

967
968
969
970
--
-- Table structure for table `elabinelab_attributes`
--

971
DROP TABLE IF EXISTS `elabinelab_attributes`;
972
CREATE TABLE `elabinelab_attributes` (
973
  `pid` varchar(48) NOT NULL default '',
974
975
976
977
978
  `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,
979
980
  `ordering` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`exptidx`,`role`,`attrkey`,`ordering`)
981
982
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

983
984
985
986
--
-- Table structure for table `elabinelab_vlans`
--

987
988
DROP TABLE IF EXISTS `elabinelab_vlans`;
CREATE TABLE `elabinelab_vlans` (
989
  `pid` varchar(48) NOT NULL default '',
990
  `eid` varchar(32) NOT NULL default '',
991
  `exptidx` int(11) NOT NULL default '0',
992
993
994
  `inner_id` varchar(32) NOT NULL default '',
  `outer_id` varchar(32) NOT NULL default '',
  `stack` enum('Control','Experimental') NOT NULL default 'Experimental',
995
996
  PRIMARY KEY  (`exptidx`,`inner_id`),
  UNIQUE KEY `pideid` (`pid`,`eid`,`inner_id`)
997
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
998

999
1000
--
-- Table structure for table `emulab_features`