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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
--
-- Table structure for table `apt_aggregate_status`
--

DROP TABLE IF EXISTS `apt_aggregate_status`;
CREATE TABLE `apt_aggregate_status` (
  `urn` varchar(128) NOT NULL default '',
  `status` enum("up","down","unknown") NOT NULL default "unknown",
  `last_success` datetime default NULL,
  `last_attempt` datetime default NULL,
  `pcount` int(11) default '0',
  `pfree` int(11) default '0',
  `vcount` int(11) default '0',
  `last_error` text,
  PRIMARY KEY  (`urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

88
--
89
-- Table structure for table `apt_aggregates`
90
91
--

92
93
DROP TABLE IF EXISTS `apt_aggregates`;
CREATE TABLE `apt_aggregates` (
Leigh B Stoller's avatar
Leigh B Stoller committed
94
  `urn` varchar(128) NOT NULL default '',
95
96
97
  `name` varchar(32) NOT NULL default '',
  `nickname` varchar(32) NOT NULL default '',
  `abbreviation` varchar(16) NOT NULL default '',
98
99
  `adminonly` tinyint(1) NOT NULL default '0',
  `isfederate` tinyint(1) NOT NULL default '0',
100
  `disabled` tinyint(1) NOT NULL default '0',
Leigh B Stoller's avatar
Leigh B Stoller committed
101
  `noupdate` tinyint(1) NOT NULL default '0',
102
  `nomonitor` tinyint(1) NOT NULL default '0',
103
104
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `weburl` tinytext,
105
  `has_datasets` tinyint(1) NOT NULL default '0',
106
  `reservations` tinyint(1) NOT NULL default '0',
107
  `portals` set('emulab','aptlab','cloudlab','phantomnet') default NULL,
108
109
110
111
112
113
114
115
  `jsondata` text,
  PRIMARY KEY  (`urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

116
117
118
119
120
121
122
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',
123
124
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
125
126
127
  `creator_uid` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `aggregate_urn` varchar(128) default NULL,
128
  `remote_urn` varchar(128) NOT NULL default '',
129
  `remote_uuid` varchar(40) NOT NULL default '',
130
  `remote_url` tinytext,
131
  `created` datetime default NULL,
132
  `updated` datetime default NULL,
133
134
135
  `expires` datetime default NULL,
  `last_used` datetime default NULL,
  `state` enum('new','valid','unapproved','grace','locked','expired','busy') NOT NULL default 'new',  
136
  `type` enum('stdataset','ltdataset','imdataset','unknown') NOT NULL default 'unknown',
137
138
  `fstype` varchar(40) NOT NULL default 'none',
  `size` int(10) unsigned NOT NULL default '0',
139
140
  `read_access` enum('project','global') NOT NULL default 'project',
  `write_access` enum('creator','project') NOT NULL default 'creator',
141
142
  `public` tinyint(1) NOT NULL default '0',
  `shared` tinyint(1) NOT NULL default '0',
143
144
  `locked` datetime default NULL, 
  `locker_pid` int(11) default '0',
145
  `credential_string` text,
146
147
  PRIMARY KEY (`idx`),
  UNIQUE KEY `plid` (`pid_idx`,`dataset_id`),
148
  UNIQUE KEY `uuid` (`uuid`)
149
150
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

151
152
153
154
155
156
157
158
--
-- 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
159
  `aggregate_urn` varchar(128) NOT NULL default '',
160
161
162
163
164
165
166
167
168
  `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;

169
170
171
172
173
174
175
176
--
-- 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,
177
  `aggregate_urn` varchar(128) NOT NULL default '',
178
  `status` varchar(32) default NULL,
179
180
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
181
182
183
184
185
186
  `public_url` tinytext,
  `webtask_id` varchar(128) NOT NULL default '',
  `manifest` mediumtext,
  PRIMARY KEY (`uuid`,`aggregate_urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

187
188
189
190
191
192
193
194
195
196
197
198
--
-- 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',
199
  `action` enum('request','deny','info') NOT NULL default 'request',
200
201
202
203
204
205
206
207
  `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;

208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
--
-- 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,
224
225
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
226
227
228
  `created` datetime default NULL,
  `exitcode` int(10) default '0',
  `exitmessage` mediumtext,
229
  `public_url` tinytext,
230
  `logfileid` varchar(40) default NULL,
231
232
233
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
234
--
235
-- Table structure for table `apt_instance_history`
Leigh B Stoller's avatar
Leigh B Stoller committed
236
237
--

238
239
240
DROP TABLE IF EXISTS `apt_instance_history`;
CREATE TABLE `apt_instance_history` (
  `uuid` varchar(40) NOT NULL default '',
241
  `name` varchar(16) default NULL,
242
243
244
245
246
247
  `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 '',
248
249
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
250
251
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
252
  `aggregate_urn` varchar(128) default NULL,
253
  `public_url` tinytext,
254
  `logfileid` varchar(40) default NULL,
255
256
  `created` datetime default NULL,
  `destroyed` datetime default NULL,
257
  `expired` tinyint(1) NOT NULL default '0',
258
259
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
260
261
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
262
  `servername` tinytext,
263
264
265
  `rspec` mediumtext,
  `params` mediumtext,
  `manifest` mediumtext,
266
267
  PRIMARY KEY (`uuid`),
  KEY `profile_id` (`profile_id`)
268
269
270
271
272
273
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

Leigh B Stoller's avatar
Leigh B Stoller committed
274
275
276
DROP TABLE IF EXISTS `apt_instances`;
CREATE TABLE `apt_instances` (
  `uuid` varchar(40) NOT NULL default '',
277
  `name` varchar(16) default NULL,
278
279
  `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
280
281
282
283
  `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 '',
284
285
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
286
287
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
288
  `aggregate_urn` varchar(128) default NULL,
289
  `public_url` tinytext,
Leigh B Stoller's avatar
Leigh B Stoller committed
290
291
  `created` datetime default NULL,
  `status` varchar(32) default NULL,
292
  `status_timestamp` datetime default NULL,
293
294
  `canceled` tinyint(2) NOT NULL default '0',
  `canceled_timestamp` datetime default NULL,
295
296
  `paniced` tinyint(2) NOT NULL default '0',
  `paniced_timestamp` datetime default NULL,
297
298
  `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
299
  `extension_code` varchar(32) default NULL,
300
  `extension_reason` mediumtext,
301
  `extension_history` mediumtext,
302
  `extension_adminonly` tinyint(1) NOT NULL default '0',
303
  `extension_requested` tinyint(1) NOT NULL default '0',
304
305
  `extension_denied` tinyint(1) NOT NULL default '0',
  `extension_denied_reason` mediumtext,
306
307
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
308
309
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
310
  `servername` tinytext,
311
  `monitor_pid` int(11) default '0',
312
  `needupdate` tinyint(3) NOT NULL default '0',
313
  `isopenstack` tinyint(1) NOT NULL default '0',
314
  `logfileid` varchar(40) default NULL,
315
316
  `cert` mediumtext,
  `privkey` mediumtext,
317
318
  `rspec` mediumtext,
  `params` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
319
  `manifest` mediumtext,
320
  `openstack_utilization` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
321
322
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Timothy Stack's avatar
   
Timothy Stack committed
323

324
--
325
-- Table structure for table `apt_profile_favorites`
326
327
--

328
329
330
331
332
333
334
335
336
337
338
339
340
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`
--

341
DROP TABLE IF EXISTS `apt_profile_versions`;
342
343
344
345
346
347
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',
348
349
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
350
351
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
352
353
  `updater` varchar(8) NOT NULL default '',
  `updater_idx` mediumint(8) unsigned NOT NULL default '0',
354
355
356
  `created` datetime default NULL,
  `published` datetime default NULL,
  `deleted` datetime default NULL,
357
  `disabled` tinyint(1) NOT NULL default '0',
358
359
360
361
362
  `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,
363
  `script` mediumtext,
364
  `paramdefs` mediumtext,
365
366
367
368
  PRIMARY KEY (`profileid`,`version`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

369
370
371
372
373
374
375
--
-- Table structure for table `apt_profiles`
--

DROP TABLE IF EXISTS `apt_profiles`;
CREATE TABLE `apt_profiles` (
  `name` varchar(64) NOT NULL default '',
376
377
  `profileid` int(10) unsigned NOT NULL default '0',  
  `version` int(8) unsigned NOT NULL default '0',
378
379
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
380
381
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
382
  `uuid` varchar(40) NOT NULL,
383
  `public` tinyint(1) NOT NULL default '0',
384
385
  `shared` tinyint(1) NOT NULL default '0',
  `listed` tinyint(1) NOT NULL default '0',
386
  `topdog` tinyint(1) NOT NULL default '0',
387
  `disabled` tinyint(1) NOT NULL default '0',
388
  `locked` datetime default NULL,
389
390
391
  `locker_pid` int(11) default '0',
  PRIMARY KEY (`profileid`),
  UNIQUE KEY `pidname` (`pid_idx`,`name`,`version`)
392
393
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

394
395
396
397
398
399
400
401
402
403
404

--
-- 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',
405
  `portal` varchar(64) NOT NULL default 'emulab',
406
  `retired` tinyint(1) NOT NULL default '0',
407
  `max_seen` int(8) NOT NULL default '20',
Jonathon Duerig's avatar
Jonathon Duerig committed
408
  `text` mediumtext,
409
  `style` varchar(64) NOT NULL default 'alert-info',
Jonathon Duerig's avatar
Jonathon Duerig committed
410
411
  `link_label` tinytext,
  `link_url` tinytext,
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
  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;

430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
--
-- 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;

447
448
449
450
--
-- Table structure for table `archive_tags`
--

451
452
453
454
455
456
457
458
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',
459
  `version` tinyint(1) default '0',
460
461
462
463
  `description` text,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `tag` (`tag`,`archive_idx`,`view`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
464
465
466
467
468

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

469
470
471
472
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',
473
474
  `revision` int(10) unsigned default NULL,
  `current_tag` varchar(64) default NULL,
475
476
477
478
  `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,
479
  `parent_revision` int(10) unsigned default NULL,
480
481
  PRIMARY KEY  (`view`,`archive_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
482
483
484
485
486

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

487
488
489
490
491
492
493
494
495
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;
496

497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
--
-- 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,
517
  `owner_uid` varchar(8) NOT NULL default '',
518
519
  `vblob_id` varchar(40) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
520
521
522
  PRIMARY KEY  (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

523
524
525
526
527
528
529
530
531
532
533
534
535
--
-- 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;

536
537
538
539
540
541
542
543
544
545
--
-- 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',
546
  `ready` tinyint(4) unsigned NOT NULL default '0',
547
548
549
550
  PRIMARY KEY (`bsidx`),
  UNIQUE KEY nidbid (`node_id`,`bs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

551
552
553
554
555
556
557
558
559
560
561
562
--
-- 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;

563
564
565
566
567
568
569
570
571
572
--
-- 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',
573
  `isfeature` tinyint(4) unsigned NOT NULL default '0',
574
575
576
577
578
579
580
581
582
583
584
585
  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 '',
586
  `lease_idx` int(10) unsigned NOT NULL default '0',
587
  `type` varchar(30) NOT NULL default '',
588
  `role` enum('element','compound','partition') NOT NULL default 'element',
589
  `total_size` int(10) unsigned NOT NULL default '0',
590
  `exported` tinyint(1) NOT NULL default '0',
591
592
  `inception` datetime default NULL,
  PRIMARY KEY (`bsidx`),
593
  UNIQUE KEY nidbid (`node_id`,`bs_id`,`lease_idx`)
594
595
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
596
597
598
599
600
601
--
-- Table structure for table `bridges`
--

DROP TABLE IF EXISTS `bridges`;
CREATE TABLE `bridges` (
602
  `pid` varchar(48) default NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
603
604
605
606
607
608
609
610
611
612
613
614
  `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;

615
616
617
618
--
-- Table structure for table `buildings`
--

619
620
621
622
623
624
625
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;
626

627
628
629
630
--
-- Table structure for table `cameras`
--

631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
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;
648

Kevin Atkinson's avatar
   
Kevin Atkinson committed
649
650
651
652
--
-- Table structure for table `causes`
--

653
654
655
656
657
658
659
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
660

661
--
662
-- Table structure for table `cdroms`
663
--
664

665
666
667
668
669
670
671
672
673
674
675
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;
676

Timothy Stack's avatar
   
Timothy Stack committed
677
678
679
680
--
-- Table structure for table `checkup_types`
--

681
682
683
684
685
686
687
688
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
689
690
691
692
693

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

694
695
696
697
698
699
700
701
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
702
703
704
705
706

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

707
708
709
710
711
712
713
714
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
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
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
--
-- 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;

769
--
770
-- Table structure for table `comments`
771
--
772

773
774
775
776
777
778
779
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;
780

781
--
782
-- Table structure for table `current_reloads`
783
--
784

785
786
787
DROP TABLE IF EXISTS `current_reloads`;
CREATE TABLE `current_reloads` (
  `node_id` varchar(32) NOT NULL default '',
788
  `idx` smallint(5) unsigned NOT NULL default '0',
789
  `image_id` int(8) unsigned NOT NULL default '0',
790
  `imageid_version` int(8) unsigned NOT NULL default '0',
791
  `mustwipe` tinyint(4) NOT NULL default '0',
792
793
  `prepare` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`node_id`,`idx`)
794
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
795

796
797
798
799
800
801
--
-- Table structure for table `daily_stats`
--

DROP TABLE IF EXISTS `daily_stats`;
CREATE TABLE `daily_stats` (
802
  `theday` date NOT NULL default '0000-00-00',
803
804
805
806
807
808
809
810
811
812
813
814
815
  `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;

816
817
818
819
--
-- Table structure for table `datapository_databases`
--

820
821
822
DROP TABLE IF EXISTS `datapository_databases`;
CREATE TABLE `datapository_databases` (
  `dbname` varchar(64) NOT NULL default '',
823
824
  `pid` varchar(48) NOT NULL default '',
  `gid` varchar(32) NOT NULL default '',
825
  `uid` varchar(8) NOT NULL default '',
826
827
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
828
829
830
831
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime default NULL,
  PRIMARY KEY  (`dbname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
832

833
834
835
836
--
-- Table structure for table `default_firewall_rules`
--

837
838
DROP TABLE IF EXISTS `default_firewall_rules`;
CREATE TABLE `default_firewall_rules` (
839
  `type` enum('ipfw','ipfw2','iptables','ipfw2-vlan','iptables-vlan','iptables-dom0','iptables-domU') NOT NULL default 'ipfw',
840
841
842
843
844
845
  `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;
846

847
848
849
850
--
-- Table structure for table `default_firewall_vars`
--

851
852
853
854
855
856
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;
857

858
--
859
-- Table structure for table `delays`
860
--
861

862
863
864
865
866
867
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',
868
  `backfill0` int(10) unsigned NOT NULL default '0',
869
  `lossrate0` float(10,8) NOT NULL default '0.00000000',
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
  `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',
886
  `backfill1` int(10) unsigned NOT NULL default '0',
887
  `lossrate1` float(10,8) NOT NULL default '0.00000000',
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
  `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 '',
903
904
  `viface_unit0` int(10) default NULL,
  `viface_unit1` int(10) default NULL,
905
  `exptidx` int(11) NOT NULL default '0',
906
  `eid` varchar(32) default NULL,
907
  `pid` varchar(48) default NULL,
908
  `vname` varchar(32) default NULL,
909
910
911
912
  `vlan0` varchar(32) NOT NULL default '',
  `vlan1` varchar(32) NOT NULL default '',
  `vnode0` varchar(32) NOT NULL default '',
  `vnode1` varchar(32) NOT NULL default '',
913
914
915
  `card0` tinyint(3) unsigned default NULL,
  `card1` tinyint(3) unsigned default NULL,
  `noshaping` tinyint(1) default '0',
916
  `isbridge` tinyint(1) default '0',
917
  PRIMARY KEY  (`node_id`,`iface0`,`iface1`,`vlan0`,`vlan1`,`vnode0`,`vnode1`),
918
919
  KEY `pid` (`pid`,`eid`),
  KEY `exptidx` (`exptidx`)
920
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
921

922
--
Timothy Stack's avatar
   
Timothy Stack committed
923
-- Table structure for table `deleted_users`
924
--
925

926
927
928
929
930
931
932
933
934
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,
935
  `usr_affil_abbrev` varchar(16) default NULL,
936
937
938
939
940
941
942
943
944
945
946
947
948
949
  `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;
950
951
952
953
954

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

955
956
957
958
959
960
961
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;
962

963
--
964
-- Table structure for table `delta_proj`
965
--
966

967
968
969
DROP TABLE IF EXISTS `delta_proj`;
CREATE TABLE `delta_proj` (
  `delta_id` varchar(10) NOT NULL default '',
970
  `pid` varchar(48) NOT NULL default '',
971
972
  PRIMARY KEY  (`delta_id`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
973

974
--
975
-- Table structure for table `deltas`
976
--
977

978
979
980
981
982
983
984
985
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;
986

987
988
989
990
--
-- Table structure for table `elabinelab_attributes`
--

991
DROP TABLE IF EXISTS `elabinelab_attributes`;
992
CREATE TABLE `elabinelab_attributes` (
993
  `pid` varchar(48) NOT NULL default '',
994
995
996
997
998
  `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,
999
1000
  `ordering` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`exptidx`,`role`,`attrkey`,`ordering`)