database-create.sql 199 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
--
-- 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 '',
78
  `status` enum('up','down','unknown') NOT NULL default 'unknown',
79
80
81
82
83
84
85
86
87
  `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
326
327
328
329
330
331
332
333
334
335
336
337
338
339
--
-- Table structure for table `apt_news`
--

DROP TABLE IF EXISTS `apt_news`;
CREATE TABLE `apt_news` (
  `idx` int(11) NOT NULL auto_increment,
  `title` tinytext,
  `created` datetime default NULL,
  `author` varchar(32) default NULL,
  `author_idx` mediumint(8) unsigned NOT NULL default '0',
  `portals` set('emulab','aptlab','cloudlab','phantomnet') default NULL,
  `body` text,
  PRIMARY KEY  (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

340
--
341
-- Table structure for table `apt_profile_favorites`
342
343
--

344
345
346
347
348
349
350
351
352
353
354
355
356
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`
--

357
DROP TABLE IF EXISTS `apt_profile_versions`;
358
359
360
361
362
363
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',
364
365
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
366
367
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
368
369
  `updater` varchar(8) NOT NULL default '',
  `updater_idx` mediumint(8) unsigned NOT NULL default '0',
370
371
372
  `created` datetime default NULL,
  `published` datetime default NULL,
  `deleted` datetime default NULL,
373
  `disabled` tinyint(1) NOT NULL default '0',
374
375
376
377
378
  `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,
379
  `script` mediumtext,
380
  `paramdefs` mediumtext,
381
382
383
384
  PRIMARY KEY (`profileid`,`version`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

385
386
387
388
389
390
391
--
-- Table structure for table `apt_profiles`
--

DROP TABLE IF EXISTS `apt_profiles`;
CREATE TABLE `apt_profiles` (
  `name` varchar(64) NOT NULL default '',
392
393
  `profileid` int(10) unsigned NOT NULL default '0',  
  `version` int(8) unsigned NOT NULL default '0',
394
395
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
396
397
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
398
  `uuid` varchar(40) NOT NULL,
399
  `public` tinyint(1) NOT NULL default '0',
400
401
  `shared` tinyint(1) NOT NULL default '0',
  `listed` tinyint(1) NOT NULL default '0',
402
  `topdog` tinyint(1) NOT NULL default '0',
403
  `disabled` tinyint(1) NOT NULL default '0',
404
  `locked` datetime default NULL,
405
406
407
  `locker_pid` int(11) default '0',
  PRIMARY KEY (`profileid`),
  UNIQUE KEY `pidname` (`pid_idx`,`name`,`version`)
408
409
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

410
411
412
413
414
415
416
417
418
419
420

--
-- 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',
421
  `portal` varchar(64) NOT NULL default 'emulab',
422
  `retired` tinyint(1) NOT NULL default '0',
423
  `max_seen` int(8) NOT NULL default '20',
Jonathon Duerig's avatar
Jonathon Duerig committed
424
  `text` mediumtext,
425
  `style` varchar(64) NOT NULL default 'alert-info',
Jonathon Duerig's avatar
Jonathon Duerig committed
426
427
  `link_label` tinytext,
  `link_url` tinytext,
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
  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;

446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
--
-- 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;

463
464
465
466
--
-- Table structure for table `archive_tags`
--

467
468
469
470
471
472
473
474
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',
475
  `version` tinyint(1) default '0',
476
477
478
479
  `description` text,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `tag` (`tag`,`archive_idx`,`view`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
480
481
482
483
484

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

485
486
487
488
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',
489
490
  `revision` int(10) unsigned default NULL,
  `current_tag` varchar(64) default NULL,
491
492
493
494
  `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,
495
  `parent_revision` int(10) unsigned default NULL,
496
497
  PRIMARY KEY  (`view`,`archive_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
498
499
500
501
502

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

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

513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
--
-- 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,
533
  `owner_uid` varchar(8) NOT NULL default '',
534
535
  `vblob_id` varchar(40) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
536
537
538
  PRIMARY KEY  (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

539
540
541
542
543
544
545
546
547
548
549
550
551
--
-- 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;

552
553
554
555
556
557
558
559
560
561
--
-- 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',
562
  `ready` tinyint(4) unsigned NOT NULL default '0',
563
564
565
566
  PRIMARY KEY (`bsidx`),
  UNIQUE KEY nidbid (`node_id`,`bs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

567
568
569
570
571
572
573
574
575
576
577
578
--
-- 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;

579
580
581
582
583
584
585
586
587
588
--
-- 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',
589
  `isfeature` tinyint(4) unsigned NOT NULL default '0',
590
591
592
593
594
595
596
597
598
599
600
601
  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 '',
602
  `lease_idx` int(10) unsigned NOT NULL default '0',
603
  `type` varchar(30) NOT NULL default '',
604
  `role` enum('element','compound','partition') NOT NULL default 'element',
605
  `total_size` int(10) unsigned NOT NULL default '0',
606
  `exported` tinyint(1) NOT NULL default '0',
607
608
  `inception` datetime default NULL,
  PRIMARY KEY (`bsidx`),
609
  UNIQUE KEY nidbid (`node_id`,`bs_id`,`lease_idx`)
610
611
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
612
613
614
615
616
617
--
-- Table structure for table `bridges`
--

DROP TABLE IF EXISTS `bridges`;
CREATE TABLE `bridges` (
618
  `pid` varchar(48) default NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
619
620
621
622
623
624
625
626
627
628
629
630
  `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;

631
632
633
634
--
-- Table structure for table `buildings`
--

635
636
637
638
639
640
641
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;
642

643
644
645
646
--
-- Table structure for table `cameras`
--

647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
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;
664

Kevin Atkinson's avatar
   
Kevin Atkinson committed
665
666
667
668
--
-- Table structure for table `causes`
--

669
670
671
672
673
674
675
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
676

677
--
678
-- Table structure for table `cdroms`
679
--
680

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

Timothy Stack's avatar
   
Timothy Stack committed
693
694
695
696
--
-- Table structure for table `checkup_types`
--

697
698
699
700
701
702
703
704
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
705
706
707
708
709

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

710
711
712
713
714
715
716
717
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
718
719
720
721
722

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

723
724
725
726
727
728
729
730
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
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
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
--
-- 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;

785
--
786
-- Table structure for table `comments`
787
--
788

789
790
791
792
793
794
795
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;
796

797
--
798
-- Table structure for table `current_reloads`
799
--
800

801
802
803
DROP TABLE IF EXISTS `current_reloads`;
CREATE TABLE `current_reloads` (
  `node_id` varchar(32) NOT NULL default '',
804
  `idx` smallint(5) unsigned NOT NULL default '0',
805
  `image_id` int(8) unsigned NOT NULL default '0',
806
  `imageid_version` int(8) unsigned NOT NULL default '0',
807
  `mustwipe` tinyint(4) NOT NULL default '0',
808
809
  `prepare` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`node_id`,`idx`)
810
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
811

812
813
814
815
816
817
--
-- Table structure for table `daily_stats`
--

DROP TABLE IF EXISTS `daily_stats`;
CREATE TABLE `daily_stats` (
818
  `theday` date NOT NULL default '0000-00-00',
819
820
821
822
823
824
825
826
827
828
829
830
831
  `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;

832
833
834
835
--
-- Table structure for table `datapository_databases`
--

836
837
838
DROP TABLE IF EXISTS `datapository_databases`;
CREATE TABLE `datapository_databases` (
  `dbname` varchar(64) NOT NULL default '',
839
840
  `pid` varchar(48) NOT NULL default '',
  `gid` varchar(32) NOT NULL default '',
841
  `uid` varchar(8) NOT NULL default '',
842
843
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
844
845
846
847
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime default NULL,
  PRIMARY KEY  (`dbname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
848

849
850
851
852
--
-- Table structure for table `default_firewall_rules`
--

853
854
DROP TABLE IF EXISTS `default_firewall_rules`;
CREATE TABLE `default_firewall_rules` (
855
  `type` enum('ipfw','ipfw2','iptables','ipfw2-vlan','iptables-vlan','iptables-dom0','iptables-domU') NOT NULL default 'ipfw',
856
857
858
859
860
861
  `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;
862

863
864
865
866
--
-- Table structure for table `default_firewall_vars`
--

867
868
869
870
871
872
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;
873

874
--
875
-- Table structure for table `delays`
876
--
877

878
879
880
881
882
883
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',
884
  `backfill0` int(10) unsigned NOT NULL default '0',
885
  `lossrate0` float(10,8) NOT NULL default '0.00000000',
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
  `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',
902
  `backfill1` int(10) unsigned NOT NULL default '0',
903
  `lossrate1` float(10,8) NOT NULL default '0.00000000',
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
  `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 '',
919
920
  `viface_unit0` int(10) default NULL,
  `viface_unit1` int(10) default NULL,
921
  `exptidx` int(11) NOT NULL default '0',
922
  `eid` varchar(32) default NULL,
923
  `pid` varchar(48) default NULL,
924
  `vname` varchar(32) default NULL,
925
926
927
928
  `vlan0` varchar(32) NOT NULL default '',
  `vlan1` varchar(32) NOT NULL default '',
  `vnode0` varchar(32) NOT NULL default '',
  `vnode1` varchar(32) NOT NULL default '',
929
930
931
  `card0` tinyint(3) unsigned default NULL,
  `card1` tinyint(3) unsigned default NULL,
  `noshaping` tinyint(1) default '0',
932
  `isbridge` tinyint(1) default '0',
933
  PRIMARY KEY  (`node_id`,`iface0`,`iface1`,`vlan0`,`vlan1`,`vnode0`,`vnode1`),
934
935
  KEY `pid` (`pid`,`eid`),
  KEY `exptidx` (`exptidx`)
936
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
937

938
--
Timothy Stack's avatar
   
Timothy Stack committed
939
-- Table structure for table `deleted_users`
940
--
941

942
943
944
945
946
947
948
949
950
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,
951
  `usr_affil_abbrev` varchar(16) default NULL,
952
953
954
955
956
957
958
959
960
961
962
963
964
965
  `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;
966
967
968
969
970

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

971
972
973
974
975
976
977
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;
978

979
--
980
-- Table structure for table `delta_proj`
981
--
982

983
984
985
DROP TABLE IF EXISTS `delta_proj`;
CREATE TABLE `delta_proj` (
  `delta_id` varchar(10) NOT NULL default '',
986
  `pid` varchar(48) NOT NULL default '',
987
988
  PRIMARY KEY  (`delta_id`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
989

990
--
991
-- Table structure for table `deltas`
992
--
993

994
995
996
997
998
999
1000
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`)
For faster browsing, not all history is shown. View entire blame