database-create.sql

-- MySQL dump 10.10
--
-- Host: localhost    Database: tbdb
-- ------------------------------------------------------
-- 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 */;

--
-- 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;

--
-- Table structure for table `accessed_files`
--

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;

--
-- Table structure for table `active_checkups`
--

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;

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

DROP TABLE IF EXISTS `apt_aggregates`;
CREATE TABLE `apt_aggregates` (
  `urn` varchar(128) NOT NULL default '',
  `name` varchar(32) NOT NULL default '',
  `nickname` varchar(32) NOT NULL default '',
  `abbreviation` varchar(16) NOT NULL default '',
  `noupdate` tinyint(1) NOT NULL default '0',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `weburl` tinytext,
  `jsondata` text,
  PRIMARY KEY  (`urn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

DROP TABLE IF EXISTS `apt_datasets`;
CREATE TABLE `apt_datasets` (
  `idx` int(10) unsigned NOT NULL default '0',
  `dataset_id` varchar(32) NOT NULL default '',
  `uuid` varchar(40) NOT NULL default '',
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `creator_uid` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `aggregate_urn` varchar(128) default NULL,
  `remote_urn` varchar(128) NOT NULL default '',
  `remote_uuid` varchar(40) NOT NULL default '',
  `remote_url` tinytext,
  `created` datetime default NULL,
  `expires` datetime default NULL,
  `last_used` datetime default NULL,
  `state` enum('new','valid','unapproved','grace','locked','expired','busy') NOT NULL default 'new',  
  `type` enum('stdataset','ltdataset','imdataset','unknown') NOT NULL default 'unknown',
  `fstype` varchar(40) NOT NULL default 'none',
  `size` int(10) unsigned NOT NULL default '0',
  `read_access` enum('project','global') NOT NULL default 'project',
  `write_access` enum('creator','project') NOT NULL default 'creator',
  `public` tinyint(1) NOT NULL default '0',
  `shared` tinyint(1) NOT NULL default '0',
  `locked` datetime default NULL, 
  `locker_pid` int(11) default '0',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `plid` (`pid_idx`,`dataset_id`),
  UNIQUE KEY `uuid` (`uuid`),
  UNIQUE KEY `remote_uuid` (`remote_uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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,
  `aggregate_urn` varchar(128) NOT NULL default '',
  `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;

--
-- 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,
  `aggregate_urn` varchar(128) NOT NULL default '',
  `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;

--
-- Table structure for table `apt_instance_history`
--

DROP TABLE IF EXISTS `apt_instance_history`;
CREATE TABLE `apt_instance_history` (
  `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) 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 '',
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
  `aggregate_urn` varchar(128) default NULL,
  `public_url` tinytext,
  `created` datetime default NULL,
  `destroyed` datetime default NULL,
  `expired` tinyint(1) NOT NULL default '0',
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
  `servername` tinytext,
  `rspec` mediumtext,
  `params` mediumtext,
  `manifest` mediumtext,
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

DROP TABLE IF EXISTS `apt_instances`;
CREATE TABLE `apt_instances` (
  `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) 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 '',
  `pid` varchar(48) default NULL,
  `pid_idx` mediumint(8) unsigned default NULL,
  `aggregate_urn` varchar(128) default NULL,
  `public_url` tinytext,
  `created` datetime default NULL,
  `status` varchar(32) default NULL,
  `admin_lockdown` tinyint(1) NOT NULL default '0',
  `user_lockdown` tinyint(1) NOT NULL default '0',
  `extension_code` varchar(32) default NULL,
  `extension_reason` mediumtext,
  `extension_history` mediumtext,
  `extension_adminonly` tinyint(1) NOT NULL default '0',
  `extension_requested` tinyint(1) NOT NULL default '0',
  `extension_count` smallint(5) unsigned NOT NULL default '0',
  `extension_days` smallint(5) unsigned NOT NULL default '0',
  `physnode_count` smallint(5) unsigned NOT NULL default '0',
  `virtnode_count` smallint(5) unsigned NOT NULL default '0',
  `servername` tinytext,
  `monitor_pid` int(11) default '0',
  `logfileid` varchar(40) default NULL,
  `cert` mediumtext,
  `privkey` mediumtext,
  `rspec` mediumtext,
  `params` mediumtext,
  `manifest` mediumtext,
  PRIMARY KEY (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

DROP TABLE IF EXISTS `apt_profile_versions`;
CREATE TABLE `apt_profile_versions` (
  `name` varchar(64) NOT NULL default '',
  `profileid` int(10) unsigned NOT NULL default '0',  
  `version` int(8) unsigned NOT NULL default '0',
  `pid` varchar(48) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `creator` varchar(8) NOT NULL default '',
  `creator_idx` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime default NULL,
  `published` datetime default NULL,
  `deleted` datetime default NULL,
  `uuid` varchar(40) NOT NULL,
  `parent_profileid` int(8) unsigned default NULL,
  `parent_version` int(8) unsigned default NULL,
  `status` varchar(32) default NULL,
  `rspec` mediumtext,
  `script` mediumtext,
  `paramdefs` mediumtext,
  PRIMARY KEY (`profileid`,`version`),
  UNIQUE KEY `pidname` (`pid_idx`,`name`,`version`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `apt_profiles`
--

DROP TABLE IF EXISTS `apt_profiles`;
CREATE TABLE `apt_profiles` (
  `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',
  `uuid` varchar(40) NOT NULL,
  `public` tinyint(1) NOT NULL default '0',
  `shared` tinyint(1) NOT NULL default '0',
  `listed` tinyint(1) NOT NULL default '0',
  `topdog` tinyint(1) NOT NULL default '0',
  `locked` datetime default NULL,
  `locker_pid` int(11) default '0',
  PRIMARY KEY (`profileid`),
  UNIQUE KEY `pidname` (`pid_idx`,`name`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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;

--
-- Table structure for table `archive_tags`
--

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',
  `version` tinyint(1) default '0',
  `description` text,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `tag` (`tag`,`archive_idx`,`view`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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',
  `revision` int(10) unsigned default NULL,
  `current_tag` varchar(64) default NULL,
  `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,
  `parent_revision` int(10) unsigned default NULL,
  PRIMARY KEY  (`view`,`archive_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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;

--
-- 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,
  `owner_uid` varchar(8) NOT NULL default '',
  `vblob_id` varchar(40) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
  PRIMARY KEY  (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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;

--
-- 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',
  `ready` tinyint(4) unsigned NOT NULL default '0',
  PRIMARY KEY (`bsidx`),
  UNIQUE KEY nidbid (`node_id`,`bs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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;

--
-- 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',
  `isfeature` tinyint(4) unsigned NOT NULL default '0',
  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 '',
  `lease_idx` int(10) unsigned NOT NULL default '0',
  `type` varchar(30) NOT NULL default '',
  `role` enum('element','compound','partition') NOT NULL default 'element',
  `total_size` int(10) unsigned NOT NULL default '0',
  `exported` tinyint(1) NOT NULL default '0',
  `inception` datetime default NULL,
  PRIMARY KEY (`bsidx`),
  UNIQUE KEY nidbid (`node_id`,`bs_id`,`lease_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `bridges`
--

DROP TABLE IF EXISTS `bridges`;
CREATE TABLE `bridges` (
  `pid` varchar(48) default NULL,
  `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;

--
-- Table structure for table `buildings`
--

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;

--
-- Table structure for table `cameras`
--

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;

--
-- Table structure for table `causes`
--

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;

--
-- Table structure for table `cdroms`
--

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;

--
-- Table structure for table `checkup_types`
--

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;

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

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;

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

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;

--
-- 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;

--
-- Table structure for table `comments`
--

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;

--
-- Table structure for table `current_reloads`
--

DROP TABLE IF EXISTS `current_reloads`;
CREATE TABLE `current_reloads` (
  `node_id` varchar(32) NOT NULL default '',
  `idx` smallint(5) unsigned NOT NULL default '0',
  `image_id` int(8) unsigned NOT NULL default '0',
  `imageid_version` int(8) unsigned NOT NULL default '0',
  `mustwipe` tinyint(4) NOT NULL default '0',
  `prepare` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`node_id`,`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `daily_stats`
--

DROP TABLE IF EXISTS `daily_stats`;
CREATE TABLE `daily_stats` (
  `theday` date NOT NULL default '0000-00-00',
  `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;

--
-- Table structure for table `datapository_databases`
--

DROP TABLE IF EXISTS `datapository_databases`;
CREATE TABLE `datapository_databases` (
  `dbname` varchar(64) NOT NULL default '',
  `pid` varchar(48) NOT NULL default '',
  `gid` varchar(32) NOT NULL default '',
  `uid` varchar(8) NOT NULL default '',
  `pid_idx` mediumint(8) unsigned NOT NULL default '0',
  `gid_idx` mediumint(8) unsigned NOT NULL default '0',
  `uid_idx` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime default NULL,
  PRIMARY KEY  (`dbname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `default_firewall_rules`
--

DROP TABLE IF EXISTS `default_firewall_rules`;
CREATE TABLE `default_firewall_rules` (
  `type` enum('ipfw','ipfw2','iptables','ipfw2-vlan','iptables-vlan','iptables-dom0','iptables-domU') NOT NULL default 'ipfw',
  `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;

--
-- Table structure for table `default_firewall_vars`
--

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;

--
-- Table structure for table `delays`
--

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',
  `backfill0` int(10) unsigned NOT NULL default '0',
  `lossrate0` float(10,8) NOT NULL default '0.00000000',
  `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',
  `backfill1` int(10) unsigned NOT NULL default '0',
  `lossrate1` float(10,8) NOT NULL default '0.00000000',
  `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 '',
  `exptidx` int(11) NOT NULL default '0',
  `eid` varchar(32) default NULL,
  `pid` varchar(48) default NULL,
  `vname` varchar(32) default NULL,
  `vlan0` varchar(32) default NULL,
  `vlan1` varchar(32) default NULL,
  `vnode0` varchar(32) default NULL,
  `vnode1` varchar(32) default NULL,
  `card0` tinyint(3) unsigned default NULL,
  `card1` tinyint(3) unsigned default NULL,
  `noshaping` tinyint(1) default '0',
  `isbridge` tinyint(1) default '0',
  PRIMARY KEY  (`node_id`,`iface0`,`iface1`),
  KEY `pid` (`pid`,`eid`),
  KEY `exptidx` (`exptidx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `deleted_users`
--

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,
  `usr_affil_abbrev` varchar(16) default NULL,
  `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;

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

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;

--
-- Table structure for table `delta_proj`
--

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

--
-- Table structure for table `deltas`
--

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;

--
-- Table structure for table `elabinelab_attributes`
--

DROP TABLE IF EXISTS `elabinelab_attributes`;
CREATE TABLE `elabinelab_attributes` (
  `pid` varchar(48) NOT NULL default '',
  `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,
  `ordering` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`exptidx`,`role`,`attrkey`,`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `elabinelab_vlans`
--

DROP TABLE IF EXISTS `elabinelab_vlans`;
CREATE TABLE `elabinelab_vlans` (
  `pid` varchar(48) NOT NULL default '',
  `eid` varchar(32) NOT NULL default '',
  `exptidx` int(11) NOT NULL default '0',
  `inner_id` varchar(32) NOT NULL default '',
  `outer_id` varchar(32) NOT NULL default '',
  `stack` enum('Control','Experimental') NOT NULL default 'Experimental',
  PRIMARY KEY  (`exptidx`,`inner_id`),
  UNIQUE KEY `pideid` (`pid`,`eid`,`inner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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;

--
-- Table structure for table `emulab_indicies`
--

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;

--
-- Table structure for table `emulab_locks`
--

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

--
-- 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;

--
-- 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;

--
-- 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;

--
-- Table structure for table `errors`
--

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;