database-create.sql 203 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
71
72
73
74
75
76
77
78
--
-- Table structure for table `addr_pool_history`
--

DROP TABLE IF EXISTS `addr_pool_history`;
CREATE TABLE `addr_pool_history` (
  `history_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pool_id` varchar(32) NOT NULL DEFAULT '',
  `op` enum('alloc','free') NOT NULL DEFAULT 'alloc',
  `uid` varchar(8) NOT NULL DEFAULT '',
  `uid_idx` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `exptidx` int(10) unsigned DEFAULT NULL,
  `stamp` int(10) unsigned DEFAULT NULL,
  `addr` varchar(15) DEFAULT NULL,
  `version` enum('ipv4','ipv6') NOT NULL DEFAULT 'ipv4',
  PRIMARY KEY (`history_id`),
  KEY `exptidx` (`exptidx`),
  KEY `stamp` (`stamp`),
  KEY `addr` (`addr`),
  KEY `addrstamp` (`addr`,`stamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

79
80
81
82
83
84
85
86
87
88
89
90
91
92
--
-- 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;

93
94
95
96
97
98
99
--
-- 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 '',
100
  `status` enum('up','down','unknown') NOT NULL default 'unknown',
101
102
103
104
105
  `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',
106
  `vfree` int(11) default '0',
107
108
109
110
  `last_error` text,
  PRIMARY KEY  (`urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

111
--
112
-- Table structure for table `apt_aggregates`
113
114
--

115
116
DROP TABLE IF EXISTS `apt_aggregates`;
CREATE TABLE `apt_aggregates` (
Leigh B Stoller's avatar
Leigh B Stoller committed
117
  `urn` varchar(128) NOT NULL default '',
118
119
120
  `name` varchar(32) NOT NULL default '',
  `nickname` varchar(32) NOT NULL default '',
  `abbreviation` varchar(16) NOT NULL default '',
121
122
  `adminonly` tinyint(1) NOT NULL default '0',
  `isfederate` tinyint(1) NOT NULL default '0',
123
  `disabled` tinyint(1) NOT NULL default '0',
Leigh B Stoller's avatar
Leigh B Stoller committed
124
  `noupdate` tinyint(1) NOT NULL default '0',
125
  `nomonitor` tinyint(1) NOT NULL default '0',
126
127
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `weburl` tinytext,
128
  `has_datasets` tinyint(1) NOT NULL default '0',
129
  `reservations` tinyint(1) NOT NULL default '0',
130
  `portals` set('emulab','aptlab','cloudlab','phantomnet') default NULL,
131
132
133
134
135
136
137
138
  `jsondata` text,
  PRIMARY KEY  (`urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

139
140
141
142
143
144
145
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',
146
147
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
148
149
150
  `creator_uid` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `aggregate_urn` varchar(128) default NULL,
151
  `remote_urn` varchar(128) NOT NULL default '',
152
  `remote_uuid` varchar(40) NOT NULL default '',
153
  `remote_url` tinytext,
154
  `created` datetime default NULL,
155
  `updated` datetime default NULL,
156
157
158
  `expires` datetime default NULL,
  `last_used` datetime default NULL,
  `state` enum('new','valid','unapproved','grace','locked','expired','busy') NOT NULL default 'new',  
159
  `type` enum('stdataset','ltdataset','imdataset','unknown') NOT NULL default 'unknown',
160
161
  `fstype` varchar(40) NOT NULL default 'none',
  `size` int(10) unsigned NOT NULL default '0',
162
163
  `read_access` enum('project','global') NOT NULL default 'project',
  `write_access` enum('creator','project') NOT NULL default 'creator',
164
165
  `public` tinyint(1) NOT NULL default '0',
  `shared` tinyint(1) NOT NULL default '0',
166
167
  `locked` datetime default NULL, 
  `locker_pid` int(11) default '0',
Leigh B Stoller's avatar
Leigh B Stoller committed
168
  `webtask_id` varchar(128) default NULL,
169
  `credential_string` text,
170
171
  PRIMARY KEY (`idx`),
  UNIQUE KEY `plid` (`pid_idx`,`dataset_id`),
172
  UNIQUE KEY `uuid` (`uuid`)
173
174
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

175
176
177
178
179
180
181
182
--
-- 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
183
  `aggregate_urn` varchar(128) NOT NULL default '',
184
185
186
187
188
189
190
191
192
  `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;

193
194
195
196
197
198
199
200
--
-- 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,
201
  `aggregate_urn` varchar(128) NOT NULL default '',
202
  `status` varchar(32) default NULL,
203
204
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
205
206
207
208
209
210
  `public_url` tinytext,
  `webtask_id` varchar(128) NOT NULL default '',
  `manifest` mediumtext,
  PRIMARY KEY (`uuid`,`aggregate_urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

211
212
213
214
215
216
217
218
219
220
221
222
--
-- 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',
223
  `action` enum('request','deny','info') NOT NULL default 'request',
224
225
  `wanted` smallint(5) unsigned NOT NULL default '0',
  `granted` smallint(5) unsigned default NULL,
226
  `needapproval` tinyint(1) NOT NULL default '0',
227
228
229
230
231
232
  `admin` tinyint(1) NOT NULL default '0',
  `reason` mediumtext,
  `message` mediumtext,
  PRIMARY KEY (`uuid`,`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
--
-- 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,
249
250
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
251
252
253
  `created` datetime default NULL,
  `exitcode` int(10) default '0',
  `exitmessage` mediumtext,
254
  `public_url` tinytext,
255
  `logfileid` varchar(40) default NULL,
256
257
258
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
259
--
260
-- Table structure for table `apt_instance_history`
Leigh B Stoller's avatar
Leigh B Stoller committed
261
262
--

263
264
265
DROP TABLE IF EXISTS `apt_instance_history`;
CREATE TABLE `apt_instance_history` (
  `uuid` varchar(40) NOT NULL default '',
266
  `name` varchar(16) default NULL,
267
268
269
270
271
272
  `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 '',
273
274
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
275
276
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
277
  `aggregate_urn` varchar(128) default NULL,
278
  `public_url` tinytext,
279
  `logfileid` varchar(40) default NULL,
280
281
  `created` datetime default NULL,
  `destroyed` datetime default NULL,
282
  `expired` tinyint(1) NOT NULL default '0',
283
284
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
285
286
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
287
  `servername` tinytext,
Leigh B Stoller's avatar
Leigh B Stoller committed
288
289
  `repourl` tinytext,
  `reponame` varchar(40) default NULL,
290
  `reporef` varchar(128) default NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
291
  `repohash` varchar(64) default NULL,
292
  `rspec` mediumtext,
293
  `script` mediumtext,
294
295
  `params` mediumtext,
  `manifest` mediumtext,
296
297
  PRIMARY KEY (`uuid`),
  KEY `profile_id` (`profile_id`)
298
299
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334

--
-- Table structure for table `apt_instance_slice_status`
--

DROP TABLE IF EXISTS `apt_instance_slice_status`;
CREATE TABLE `apt_instance_slice_status` (
  `uuid` varchar(40) NOT NULL default '',
  `name` varchar(16) default NULL,
  `aggregate_urn` varchar(128) NOT NULL default '',
  `timestamp` int(10) unsigned NOT NULL default '0',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `slice_data` mediumtext,
  PRIMARY KEY (`uuid`,`aggregate_urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `apt_instance_sliver_status`
--

DROP TABLE IF EXISTS `apt_instance_sliver_status`;
CREATE TABLE `apt_instance_sliver_status` (
  `uuid` varchar(40) NOT NULL default '',
  `name` varchar(16) default NULL,
  `aggregate_urn` varchar(128) NOT NULL default '',
  `sliver_urn` varchar(128) NOT NULL default '',
  `resource_id` varchar(32) NOT NULL default '',
  `client_id` varchar(32) NOT NULL default '',
  `timestamp` int(10) unsigned NOT NULL default '0',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `sliver_data` mediumtext,
  `frisbee_data` mediumtext,
  PRIMARY KEY (`uuid`,`aggregate_urn`,`sliver_urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

335
336
337
338
--
-- Table structure for table `apt_instances`
--

Leigh B Stoller's avatar
Leigh B Stoller committed
339
340
341
DROP TABLE IF EXISTS `apt_instances`;
CREATE TABLE `apt_instances` (
  `uuid` varchar(40) NOT NULL default '',
342
  `name` varchar(16) default NULL,
343
344
  `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
345
346
347
348
  `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 '',
349
350
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
351
352
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
353
  `aggregate_urn` varchar(128) default NULL,
354
  `public_url` tinytext,
Leigh B Stoller's avatar
Leigh B Stoller committed
355
  `webtask_id` varchar(128) default NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
356
357
  `created` datetime default NULL,
  `status` varchar(32) default NULL,
358
  `status_timestamp` datetime default NULL,
359
360
  `canceled` tinyint(2) NOT NULL default '0',
  `canceled_timestamp` datetime default NULL,
361
362
  `paniced` tinyint(2) NOT NULL default '0',
  `paniced_timestamp` datetime default NULL,
363
364
  `admin_lockdown` tinyint(1) NOT NULL default '0',
  `user_lockdown` tinyint(1) NOT NULL default '0',
365
  `admin_notes` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
366
  `extension_code` varchar(32) default NULL,
367
  `extension_reason` mediumtext,
368
  `extension_history` mediumtext,
369
  `extension_adminonly` tinyint(1) NOT NULL default '0',
370
  `extension_requested` tinyint(1) NOT NULL default '0',
371
372
  `extension_denied` tinyint(1) NOT NULL default '0',
  `extension_denied_reason` mediumtext,
373
374
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
375
376
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
377
  `servername` tinytext,
378
  `monitor_pid` int(11) default '0',
379
  `needupdate` tinyint(3) NOT NULL default '0',
380
  `isopenstack` tinyint(1) NOT NULL default '0',
381
  `logfileid` varchar(40) default NULL,
382
383
  `cert` mediumtext,
  `privkey` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
384
385
  `repourl` tinytext,
  `reponame` varchar(40) default NULL,
386
  `reporef` varchar(128) default NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
387
  `repohash` varchar(64) default NULL,
388
  `rspec` mediumtext,
389
  `script` mediumtext,
390
  `params` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
391
  `manifest` mediumtext,
392
  `openstack_utilization` mediumtext,
Leigh B Stoller's avatar
Leigh B Stoller committed
393
394
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Timothy Stack's avatar
   
Timothy Stack committed
395

396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
--
-- 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;

412
--
413
-- Table structure for table `apt_profile_favorites`
414
415
--

416
417
418
419
420
421
422
423
424
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;

425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
--
-- Table structure for table `apt_profile_images`
--

DROP TABLE IF EXISTS `apt_profile_images`;
CREATE TABLE `apt_profile_images` (
  `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',
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
  `client_id` varchar(32) NOT NULL default '',
  `authority` varchar(64) default NULL,
  `ospid` varchar(64) default NULL,
  `os` varchar(128) default NULL,
  `osvers` int(8) default NULL,
  `local_pid` varchar(48) default NULL,
  `image` varchar(256) NOT NULL default '',
  PRIMARY KEY (`profileid`,`version`,`client_id`),
  KEY `image` (`image`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

449
450
451
452
--
-- Table structure for table `apt_profile_versions`
--

453
DROP TABLE IF EXISTS `apt_profile_versions`;
454
455
456
457
458
459
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',
460
461
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
462
463
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
464
465
  `updater` varchar(8) NOT NULL default '',
  `updater_idx` mediumint(8) unsigned NOT NULL default '0',
466
467
468
  `created` datetime default NULL,
  `published` datetime default NULL,
  `deleted` datetime default NULL,
469
  `disabled` tinyint(1) NOT NULL default '0',
470
  `nodelete` tinyint(1) NOT NULL default '0',
471
472
473
474
  `uuid` varchar(40) NOT NULL,
  `parent_profileid` int(8) unsigned default NULL,
  `parent_version` int(8) unsigned default NULL,
  `status` varchar(32) default NULL,
475
476
477
  `repourl` tinytext,
  `reponame` varchar(40) default NULL,
  `repohash` varchar(64) default NULL,
478
  `repokey` varchar(64) default NULL,
479
  `portal_converted` tinyint(1) NOT NULL default '0',
480
  `rspec` mediumtext,
481
  `script` mediumtext,
482
  `paramdefs` mediumtext,
483
484
485
486
  PRIMARY KEY (`profileid`,`version`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

487
488
489
490
491
492
493
--
-- Table structure for table `apt_profiles`
--

DROP TABLE IF EXISTS `apt_profiles`;
CREATE TABLE `apt_profiles` (
  `name` varchar(64) NOT NULL default '',
494
495
  `profileid` int(10) unsigned NOT NULL default '0',  
  `version` int(8) unsigned NOT NULL default '0',
496
497
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
498
499
  `gid` varchar(32) NOT NULL default '',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
500
  `uuid` varchar(40) NOT NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
501
  `webtask_id` varchar(128) default NULL,
502
  `public` tinyint(1) NOT NULL default '0',
503
504
  `shared` tinyint(1) NOT NULL default '0',
  `listed` tinyint(1) NOT NULL default '0',
505
  `topdog` tinyint(1) NOT NULL default '0',
Mike Hibler's avatar
Mike Hibler committed
506
  `no_image_versions` tinyint(1) NOT NULL default '0',
507
  `disabled` tinyint(1) NOT NULL default '0',
508
  `nodelete` tinyint(1) NOT NULL default '0',
509
  `locked` datetime default NULL,
510
  `locker_pid` int(11) default '0',
511
512
  `lastused` datetime default NULL,
  `usecount` int(11) default '0',
513
514
  PRIMARY KEY (`profileid`),
  UNIQUE KEY `pidname` (`pid_idx`,`name`,`version`)
515
516
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

517
518
519
520
521
522
523
524
525
526
527

--
-- 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',
528
  `portal` varchar(64) NOT NULL default 'emulab',
529
  `retired` tinyint(1) NOT NULL default '0',
530
  `max_seen` int(8) NOT NULL default '20',
Jonathon Duerig's avatar
Jonathon Duerig committed
531
  `text` mediumtext,
532
  `style` varchar(64) NOT NULL default 'alert-info',
Jonathon Duerig's avatar
Jonathon Duerig committed
533
534
  `link_label` tinytext,
  `link_url` tinytext,
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
  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;

553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
--
-- 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;

570
571
572
573
--
-- Table structure for table `archive_tags`
--

574
575
576
577
578
579
580
581
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',
582
  `version` tinyint(1) default '0',
583
584
585
586
  `description` text,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `tag` (`tag`,`archive_idx`,`view`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
587
588
589
590
591

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

592
593
594
595
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',
596
597
  `revision` int(10) unsigned default NULL,
  `current_tag` varchar(64) default NULL,
598
599
600
601
  `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,
602
  `parent_revision` int(10) unsigned default NULL,
603
604
  PRIMARY KEY  (`view`,`archive_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
605
606
607
608
609

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

610
611
612
613
614
615
616
617
618
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;
619

620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
--
-- 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,
640
  `owner_uid` varchar(8) NOT NULL default '',
641
642
  `vblob_id` varchar(40) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
643
644
645
  PRIMARY KEY  (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

659
660
661
662
663
664
665
666
667
668
--
-- 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',
669
  `ready` tinyint(4) unsigned NOT NULL default '0',
670
671
672
673
  PRIMARY KEY (`bsidx`),
  UNIQUE KEY nidbid (`node_id`,`bs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

686
687
688
689
690
691
692
693
694
695
--
-- 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',
696
  `isfeature` tinyint(4) unsigned NOT NULL default '0',
697
698
699
700
701
702
703
704
705
706
707
708
  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 '',
709
  `lease_idx` int(10) unsigned NOT NULL default '0',
710
  `type` varchar(30) NOT NULL default '',
711
  `role` enum('element','compound','partition') NOT NULL default 'element',
712
  `total_size` int(10) unsigned NOT NULL default '0',
713
  `exported` tinyint(1) NOT NULL default '0',
714
715
  `inception` datetime default NULL,
  PRIMARY KEY (`bsidx`),
716
  UNIQUE KEY nidbid (`node_id`,`bs_id`,`lease_idx`)
717
718
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leigh B Stoller's avatar
Leigh B Stoller committed
719
720
721
722
723
724
--
-- Table structure for table `bridges`
--

DROP TABLE IF EXISTS `bridges`;
CREATE TABLE `bridges` (
725
  `pid` varchar(48) default NULL,
Leigh B Stoller's avatar
Leigh B Stoller committed
726
727
728
729
730
731
732
733
734
735
736
737
  `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;

738
739
740
741
--
-- Table structure for table `buildings`
--

742
743
744
745
746
747
748
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;
749

750
751
752
753
--
-- Table structure for table `cameras`
--

754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
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;
771

Kevin Atkinson's avatar
   
Kevin Atkinson committed
772
773
774
775
--
-- Table structure for table `causes`
--

776
777
778
779
780
781
782
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
783

784
--
785
-- Table structure for table `cdroms`
786
--
787

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

Timothy Stack's avatar
   
Timothy Stack committed
800
801
802
803
--
-- Table structure for table `checkup_types`
--

804
805
806
807
808
809
810
811
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
812
813
814
815
816

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

817
818
819
820
821
822
823
824
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
825
826
827
828
829

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

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

839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
--
-- 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;

892
--
893
-- Table structure for table `comments`
894
--
895

896
897
898
899
900
901
902
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;
903

904
--
905
-- Table structure for table `current_reloads`
906
--
907

908
909
910
DROP TABLE IF EXISTS `current_reloads`;
CREATE TABLE `current_reloads` (
  `node_id` varchar(32) NOT NULL default '',
911
  `idx` smallint(5) unsigned NOT NULL default '0',
912
  `image_id` int(8) unsigned NOT NULL default '0',
913
  `imageid_version` int(8) unsigned NOT NULL default '0',
914
  `mustwipe` tinyint(4) NOT NULL default '0',
915
916
  `prepare` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`node_id`,`idx`)
917
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
918

919
920
921
922
923
924
--
-- Table structure for table `daily_stats`
--

DROP TABLE IF EXISTS `daily_stats`;
CREATE TABLE `daily_stats` (
925
  `theday` date NOT NULL default '0000-00-00',
926
927
928
929
930
931
932
933
934
935
936
937
938
  `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;

939
940
941
942
--
-- Table structure for table `datapository_databases`
--

943
944
945
DROP TABLE IF EXISTS `datapository_databases`;
CREATE TABLE `datapository_databases` (
  `dbname` varchar(64) NOT NULL default '',
946
947
  `pid` varchar(48) NOT NULL default '',
  `gid` varchar(32) NOT NULL default '',
948
  `uid` varchar(8) NOT NULL default '',
949
950
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
951
952
953
954
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime default NULL,
  PRIMARY KEY  (`dbname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
955

956
957
958
959
--
-- Table structure for table `default_firewall_rules`
--

960
961
DROP TABLE IF EXISTS `default_firewall_rules`;
CREATE TABLE `default_firewall_rules` (
962
  `type` enum('ipfw','ipfw2','iptables','ipfw2-vlan','iptables-vlan','iptables-dom0','iptables-domU') NOT NULL default 'ipfw',
963
964
965
966
967
968
  `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;
969

970
971
972
973
--
-- Table structure for table `default_firewall_vars`
--

974
975
976
977
978
979
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;
980

981
--
982
-- Table structure for table `delays`
983
--
984

985
986
987
988
989
990
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',
991
  `backfill0` int(10) unsigned NOT NULL default '0',
992
  `lossrate0` float(10,8) NOT NULL default '0.00000000',
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
  `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',
1009
  `backfill1` int(10) unsigned NOT NULL default '0',
1010
  `lossrate1` float(10,8) NOT NULL default '0.00000000',
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
  `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 '',
1026
1027
  `viface_unit0` int(10) default NULL,
  `viface_unit1` int(10) default NULL,
1028
  `exptidx` int(11) NOT NULL default '0',
1029
  `eid` varchar(32) default NULL,
1030
  `pid` varchar(48) default NULL,
1031
  `vname` varchar(32) default NULL,
1032
1033
1034
1035
  `vlan0` varchar(32) NOT NULL default '',
  `vlan1` varchar(32) NOT NULL default '',
  `vnode0` varchar(32) NOT NULL default '',
  `vnode1` varchar(32) NOT NULL default '',
1036
1037
1038
  `card0` tinyint(3) unsigned default NULL,
  `card1` tinyint(3) unsigned default NULL,
  `noshaping` tinyint(1) default '0',
1039
  `isbridge` tinyint(1) default '0',
1040
  PRIMARY KEY  (`node_id`,`iface0`,`iface1`,`vlan0`,`vlan1`,`vnode0`,`vnode1`),
1041
1042
  KEY `pid` (`pid`,`eid`),
  KEY `exptidx` (`exptidx`)
1043
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1044

1045
--
Timothy Stack's avatar
   
Timothy Stack committed
1046
-- Table structure for table `deleted_users`
1047
--
1048

1049
1050
1051
1052
1053
1054
1055
1056
1057
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,
1058
  `usr_affil_abbrev` varchar(16) default NULL,
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
  `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;
1073
1074
1075
1076
1077

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

1078
1079
1080
1081
1082
1083
1084
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;
1085

1086
--
1087
-- Table structure for table `delta_proj`
1088
--
1089

1090
1091
1092
DROP TABLE IF EXISTS `delta_proj`;
CREATE TABLE `delta_proj` (
  `delta_id` varchar(10) NOT NULL default '',
1093
  `pid` varchar(48) NOT NULL default '',
1094
1095
  PRIMARY KEY  (`delta_id`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1096

1097
--
1098
-- Table structure for table `deltas`
1099
--
1100

1101
1102
1103
1104
1105
1106
1107
1108
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;
1109

1110
1111
1112
1113
--
-- Table structure for table `elabinelab_attributes`
--

1114
DROP TABLE IF EXISTS `elabinelab_attributes`;
1115
CREATE TABLE `elabinelab_attributes` (
1116
  `pid` varchar(48) NOT NULL default '',
1117
1118
1119
1120
1121
  `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,
1122
1123
  `ordering` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`exptidx`,`role`,`attrkey`,`ordering`)
1124
1125
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1126
1127
1128
1129
--
-- Table structure for table `elabinelab_vlans`
--

1130
1131
DROP TABLE IF EXISTS `elabinelab_vlans`;
CREATE TABLE `elabinelab_vlans` (
1132
  `pid` varchar(48) NOT NULL default '',
1133
  `eid` varchar(32) NOT NULL default '',
1134
  `exptidx` int(11) NOT NULL default '0',
1135
1136
1137
  `inner_id` varchar(32) NOT NULL default '',
  `outer_id` varchar(32) NOT NULL default '',
  `stack` enum('Control','Experimental') NOT NULL default 'Experimental',
1138
1139
  PRIMARY KEY  (`exptidx`,`inner_id`),
  UNIQUE KEY `pideid` (`pid`,`eid`,`inner_id`)
1140
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1141

1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
--
-- Table structure for table `emulab_features`
--

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

1156
1157
1158
1159
--
-- Table structure for table `emulab_indicies`
--

1160
1161
1162
1163
1164
1165
DROP TABLE IF EXISTS `emulab_indicies`;
CREATE TABLE `emulab_indicies` (
  `name` varchar(64) NOT NULL default '',
  `idx` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1166

1167
1168
1169
1170
1171
1172
1173
--
-- Table structure for table `emulab_locks`
--

DROP TABLE IF EXISTS `emulab_locks`;
CREATE TABLE `emulab_locks` (
  `name` varchar(64) NOT NULL default '',
1174
  `value` int(10) NOT NULL default '0',
1175
1176
1177
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
--
-- Table structure for table `emulab_peers`
--

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

Kevin Atkinson's avatar
   
Kevin Atkinson committed
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
--
-- Table structure for table `emulab_pubs`
--

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

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

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

1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
--
-- Table structure for table `emulab_sites`
--

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

Kevin Atkinson's avatar
   
Kevin Atkinson committed
1266
1267
1268
1269
--
-- Table structure for table `errors`
--

1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
DROP TABLE IF EXISTS `errors`;
CREATE TABLE `errors` (
  `session` int(10) unsigned NOT NULL default '0',
  `rank` tinyint(1) NOT NULL default '0',
  `stamp` int(10) unsigned NOT NULL default '0',
  `exptidx` int(11) NOT NULL default '0',
  `script` smallint(3) NOT NULL default '0',
  `cause` varchar(16) NOT NULL default '',
  `confidence` float NOT NULL default '0',
  `inferred` tinyint(1) default NULL,
  `need_more_info` tinyint(1) default NULL,
  `mesg` text NOT NULL,
  `tblog_revision` varchar(8) NOT NULL default '',
  PRIMARY KEY  (`session`,`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Kevin Atkinson's avatar
Kevin Atkinson committed
1285

1286
--
1287
-- Table structure for table `event_eventtypes`
1288
--
Robert Ricci's avatar
Robert Ricci committed
1289

1290
1291
1292
1293
1294
1295
DROP TABLE IF EXISTS `event_eventtypes`;
CREATE TABLE `event_eventtypes` (
  `idx` smallint(5) unsigned NOT NULL default '0',
  `type` tinytext NOT NULL,
  PRIMARY KEY  (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Robert Ricci's avatar
Robert Ricci committed
1296

Leigh B. Stoller's avatar
Leigh B. Stoller committed
1297
1298
1299
1300
--
-- Table structure for table `event_groups`
--

1301
1302
DROP TABLE IF EXISTS `event_groups`;
CREATE TABLE `event_groups` (
1303
  `pid` varchar(48) NOT NULL default '',
1304
  `eid` varchar(32) NOT NULL default '',
1305
  `exptidx` int(11) NOT NULL default '0',
1306
1307
1308
  `idx` int(10) unsigned NOT NULL auto_increment,
  `group_name` varchar(64) NOT NULL default '',
  `agent_name` varchar(64) NOT NULL default '',
1309
1310
  PRIMARY KEY  (`exptidx`,`idx`),
  UNIQUE KEY `pideid` (`pid`,`eid`,`idx`),
1311
1312
1313
  KEY `group_name` (`group_name`),
  KEY `agent_name` (`agent_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1314

1315
1316
1317
1318
--
-- Table structure for table `event_objecttypes`
--

1319
1320
1321
1322
1323
1324
DROP TABLE IF EXISTS `event_objecttypes`;
CREATE TABLE `event_objecttypes` (
  `idx` smallint(5) unsigned NOT NULL default '0',
  `type` tinytext NOT NULL,
  PRIMARY KEY  (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1325

1326
1327
1328
1329
1330
1331
1332
1333
--
-- Table structure for table `event_triggertypes`
--

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

1337
--
1338
-- Table structure for table `eventlist`
1339
--
1340

1341
1342
DROP TABLE IF EXISTS `eventlist`;
CREATE TABLE `eventlist` (
1343
  `pid` varchar(48) NOT NULL default '',
1344
  `eid` varchar(32) NOT NULL default '',
1345
  `exptidx` int(11) NOT NULL default '0',
1346
1347
1348
1349
1350
1351
  `idx` int(10) unsigned NOT NULL auto_increment,
  `time` float(10,3) NOT NULL default '0.000',
  `vnode` varchar(32) NOT NULL default '',
  `vname` varchar(64) NOT NULL default '',
  `objecttype` smallint(5) unsigned NOT NULL default '0',
  `eventtype` smallint(5) unsigned NOT NULL default '0',
1352
  `triggertype` smallint(5) unsigned NOT NULL default '0',
1353
1354
1355
1356
  `isgroup` tinyint(1) unsigned default '0',
  `arguments` text,
  `atstring` text,
  `parent` varchar(64) NOT NULL default '',
1357
1358
  PRIMARY KEY  (`exptidx`,`idx`),
  UNIQUE KEY `pideid` (`pid`,`eid`,`idx`),
1359
1360
  KEY `vnode` (`vnode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1361

1362
1363
1364
1365
1366
1367
1368
--
-- Table structure for table `experiment_blobs`
--

DROP TABLE IF EXISTS `experiment_blobs`;
CREATE TABLE `experiment_blobs` (
  `idx` int(11) unsigned NOT NULL auto_increment,
1369
  `pid` varchar(48) NOT NULL default '',
1370
1371
1372
1373
1374
  `eid` varchar(32) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  `action` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idx`),
1375
1376
  UNIQUE KEY `exptidx` (`exptidx`,`path`,`action`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1377

1378
1379
1380
1381
1382
1383
1384
1385
1386
--
-- Table structure for table `experiment_features`
--

DROP TABLE IF EXISTS `experiment_features`;
CREATE TABLE `experiment_features` (
  `feature` varchar(64) NOT NULL default '',
  `added` datetime NOT NULL,
  `exptidx` int(11) NOT NULL default '0',
1387
  `pid` varchar(48) NOT NULL default '',
1388
  `eid` varchar(32) NOT NULL default '',
1389
  PRIMARY KEY  (`feature`,`exptidx`)
1390
1391
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
--
-- Table structure for table `experiment_input_data`
--

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

--
1407
-- Table structure for table `experiment_inputs`
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
--

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

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

DROP TABLE IF EXISTS `experiment_pmapping`;
CREATE TABLE `experiment_pmapping` (
  `rsrcidx` int(10) unsigned NOT NULL default '0',
1427
  `vname` varchar(32) NOT NULL default '',
1428
1429
1430
1431
1432
1433
  `node_id` varchar(32) NOT NULL default '',
  `node_type` varchar(30) NOT NULL default '',
  `node_erole` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`rsrcidx`,`vname`,`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1434
--
1435
-- Table structure for table `experiment_resources`
1436
1437
--

1438
1439
1440
1441
1442
1443
DROP TABLE IF EXISTS `experiment_resources`;
CREATE TABLE `experiment_resources` (
  `idx` int(10) unsigned NOT NULL auto_increment,
  `exptidx` int(10) unsigned NOT NULL default '0',
  `lastidx` int(10) unsigned default NULL,
  `tstamp` datetime default NULL,
1444
1445
1446
1447
1448
1449
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `swapin_time` int(10) unsigned NOT NULL default '0',
  `swapout_time` int(10) unsigned NOT NULL default '0',
  `swapmod_time` int(10) unsigned NOT NULL default '0',
  `byswapmod` tinyint(1) unsigned default '0',
  `byswapin` tinyint(1) unsigned default '0',
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
  `vnodes` smallint(5) unsigned default '0',
  `pnodes` smallint(5) unsigned default '0',
  `wanodes` smallint(5) unsigned default '0',
  `plabnodes` smallint(5) unsigned default '0',
  `simnodes` smallint(5) unsigned default '0',
  `jailnodes` smallint(5) unsigned default '0',
  `delaynodes` smallint(5) unsigned default '0',
  `linkdelays` smallint(5) unsigned default '0',
  `walinks` smallint(5) unsigned default '0',
  `links` smallint(5) unsigned default '0',
  `lans` smallint(5) unsigned default '0',
  `shapedlinks` smallint(5) unsigned default '0',
  `shapedlans` smallint(5) unsigned default '0',
  `wirelesslans` smallint(5) unsigned default '0',
  `minlinks` tinyint(3) unsigned default '0',
  `maxlinks` tinyint(3) unsigned default '0',
  `delay_capacity` tinyint(3) unsigned default NULL,
  `batchmode` tinyint(1) unsigned default '0',
  `archive_tag` varchar(64) default NULL,
1469
  `input_data_idx` int(10) unsigned default NULL,
1470
1471
1472
  `thumbnail` mediumblob,
  PRIMARY KEY  (`idx`),
  KEY `exptidx` (`exptidx`),
1473
  KEY `lastidx` (`lastidx`),
1474
  KEY `inputdata` (`input_data_idx`)
1475
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1476