-- phpMyAdmin SQL Dump
-- version 2.8.1-Debian-1~dapper1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 02, 2009 at 02:32 PM
-- Server version: 5.0.22
-- PHP Version: 5.1.2
-- 
-- Database: `zentific`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `available_functions`
-- 

CREATE TABLE `available_functions` (
  `id` int(11) NOT NULL auto_increment,
  `platform` enum('xen','vmware','kvm') NOT NULL default 'xen',
  `method` enum('legacy','xmlrpc','soap','libvirt') NOT NULL default 'legacy',
  `type` enum('internal','addon','shell') NOT NULL default 'addon',
  `name` varchar(64) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `available_functions`
-- 


-- --------------------------------------------------------

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

CREATE TABLE `bridges` (
  `node` int(11) NOT NULL,
  `bridge` varchar(32) NOT NULL,
  `description` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bridges`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `config`
-- 

CREATE TABLE `config` (
  `key` varchar(64) NOT NULL,
  `value` varchar(1024) NOT NULL,
  `priv` int(11) NOT NULL,
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `config`
-- 

INSERT INTO `config` (`key`, `value`, `priv`) VALUES ('stat_retention', '25', 0),
('nodeuser', 'default', 0),
('language', 'en_US', 0),
('max_memory', '4194304', 3),
('max_vcpu_count', '4', 3);

-- --------------------------------------------------------

-- 
-- Table structure for table `diskconfig`
-- 

CREATE TABLE `diskconfig` (
  `disk` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `revision` int(11) NOT NULL,
  `type` enum('file','tap','phy') NOT NULL default 'tap',
  `backend` varchar(32) NOT NULL,
  `mode` varchar(2) NOT NULL,
  `int_dev` varchar(255) NOT NULL,
  `ext_dev` varchar(1024) NOT NULL,
  `num_sectors` int(11) NOT NULL,
  `size_sector` int(11) NOT NULL,
  `blocksize` int(11) NOT NULL,
  `startsector` int(11) NOT NULL,
  `partitiontype` varchar(64) NOT NULL,
  KEY `timestamp` (`timestamp`),
  KEY `disk` (`disk`),
  KEY `ext_dev` (`ext_dev`(1000))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `diskconfig`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `disks`
-- 

CREATE TABLE `disks` (
  `id` int(11) NOT NULL auto_increment,
  `uuid` varchar(36) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `disks`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `diskstats`
-- 

CREATE TABLE `diskstats` (
  `disk` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `rdreq` int(11) NOT NULL default '0',
  `wrreq` int(11) NOT NULL default '0',
  `ooreq` int(11) NOT NULL default '0',
  KEY `timestamp` (`timestamp`),
  KEY `disk` (`disk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `diskstats`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `groups`
-- 

CREATE TABLE `groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL,
  `desc` varchar(255) NOT NULL,
  `privilege` tinyint(1) NOT NULL default '4',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `groups`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `groupvms`
-- 

CREATE TABLE `groupvms` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL,
  `desc` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `groupvms`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `jobs`
-- 

CREATE TABLE `jobs` (
  `id` bigint(20) NOT NULL auto_increment,
  `uid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `jobtype_class` enum('shell','internal','addon') NOT NULL default 'shell',
  `type` varchar(31) NOT NULL,
  `scheduled` datetime default NULL,
  `target_domU` char(36) default NULL,
  `target_dom0` char(36) default NULL,
  `target_host` varchar(255) default NULL,
  `extra` varchar(255) default NULL,
  `time_started` int(11) NOT NULL default '-1',
  `return_value` int(11) default NULL,
  `pid` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `jobs`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `kernels`
-- 

CREATE TABLE `kernels` (
  `kernelid` int(11) NOT NULL auto_increment,
  `kernel` varchar(255) NOT NULL,
  `initrd` varchar(255) NOT NULL,
  `config` varchar(255) NOT NULL,
  `sysmap` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `arch` enum('x86_32','x86_64','i686','i386','x86_32p') NOT NULL,
  `pvfb` smallint(1) NOT NULL default '0',
  `blktap` smallint(1) NOT NULL default '0',
  `xennet` smallint(1) NOT NULL default '0',
  `defaultargs` varchar(255) NOT NULL,
  PRIMARY KEY  (`kernelid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `kernels`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `languages`
-- 

CREATE TABLE `languages` (
  `id` int(11) NOT NULL auto_increment,
  `language` varchar(8) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `languages`
-- 

INSERT INTO `languages` (`id`, `language`) VALUES (1, 'en_US');

-- --------------------------------------------------------

-- 
-- Table structure for table `logs`
-- 

CREATE TABLE `logs` (
  `id` int(11) NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `uuid` varchar(32) NOT NULL,
  `severity` enum('info','warning','error','alert') NOT NULL default 'info',
  `message` varchar(1023) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `logs`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `membership`
-- 

CREATE TABLE `membership` (
  `gid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `privilege` tinyint(1) NOT NULL default '4'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `membership`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `membershipvm`
-- 

CREATE TABLE `membershipvm` (
  `gid` int(11) NOT NULL,
  `uuid` varchar(36) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `membershipvm`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `nodechildren`
-- 

CREATE TABLE `nodechildren` (
  `vm` int(11) NOT NULL,
  `node` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  KEY `vm` (`vm`),
  KEY `node` (`node`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nodechildren`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `nodeconfig`
-- 

CREATE TABLE `nodeconfig` (
  `node` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `revision` int(11) NOT NULL,
  `kernel` varchar(255) NOT NULL,
  `os` varchar(255) NOT NULL,
  `architecture` varchar(24) NOT NULL,
  `hostname` varchar(255) NOT NULL,
  `address` varchar(15) NOT NULL,
  `domainname` varchar(255) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `platformver` varchar(255) NOT NULL,
  `numcpus` int(11) NOT NULL,
  `corespersocket` int(11) NOT NULL,
  `threadspercore` int(11) NOT NULL,
  `numcpunodes` int(11) NOT NULL,
  `socketspernode` int(11) NOT NULL,
  `cpumhz` int(11) NOT NULL,
  `totalmem` int(11) NOT NULL,
  `control_mechanism` varchar(64) NOT NULL,
  PRIMARY KEY  (`node`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nodeconfig`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `nodes`
-- 

CREATE TABLE `nodes` (
  `id` int(11) NOT NULL auto_increment,
  `uuid` varchar(36) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `nodes`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `nodestats`
-- 

CREATE TABLE `nodestats` (
  `node` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `iowait` double NOT NULL,
  `loadavg` varchar(24) NOT NULL,
  `uptime` int(11) NOT NULL,
  `cpupct` double NOT NULL,
  `intr` int(11) NOT NULL,
  `ctxts` int(11) NOT NULL,
  `num_procs` int(11) NOT NULL,
  `mem_free` int(11) NOT NULL,
  `mem_total` int(11) NOT NULL,
  `mem_shared` int(11) NOT NULL,
  `mem_buffered` int(11) NOT NULL,
  `swap_total` int(11) NOT NULL,
  `swap_free` int(11) NOT NULL,
  `free_phys_mem` double NOT NULL,
  `total_phys_mem` double NOT NULL,
  KEY `timestamp` (`timestamp`),
  KEY `node` (`node`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nodestats`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `ownershipnode`
-- 

CREATE TABLE `ownershipnode` (
  `uid` int(11) NOT NULL,
  `node` int(11) NOT NULL,
  `privileges` int(1) NOT NULL default '4'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `ownershipnode`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `ownershipvm`
-- 

CREATE TABLE `ownershipvm` (
  `uid` int(11) NOT NULL,
  `vm` int(11) NOT NULL,
  `privileges` int(1) NOT NULL default '4'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `ownershipvm`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `platforms`
-- 

CREATE TABLE `platforms` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `mechanism` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `platforms`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `plugins`
-- 

CREATE TABLE `plugins` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `frontend` int(1) NOT NULL,
  `xmlrpc` int(1) NOT NULL,
  `scheduler` int(1) NOT NULL,
  `poller` int(1) NOT NULL,
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `plugins`
-- 

INSERT INTO `plugins` (`id`, `name`, `description`, `frontend`, `xmlrpc`, `scheduler`, `poller`, `enabled`) VALUES (1, 'Base', 'Base Module - Cannot be Disabled', 1, 0, 0, 0, 1),
(2, 'Vms', 'Manage and view virtual machines', 1, 0, 0, 0, 1),
(3, 'Nodes', 'Manage and view physical nodes', 1, 0, 0, 0, 1),
(4, 'Users', 'User Management and Preferences', 1, 0, 0, 0, 1),
(5, 'Configuration', 'Global Config and Module management', 1, 0, 0, 0, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `privileges`
-- 

CREATE TABLE `privileges` (
  `privilege` tinyint(1) NOT NULL default '4',
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `privileges`
-- 

INSERT INTO `privileges` (`privilege`, `name`, `description`) VALUES (0, 'superuser', 'owner of machine, can do anything, see all virtual machines'),
(1, 'maintenance', 'temporarily assigned to an admin for the purpose of fixing a VM, etc. same privs as admin for any assigned vms'),
(2, 'admin', 'can control all aspects of any machines they own'),
(3, 'read-only admin', 'can only view information about the machines they own, these can be added by admin-level users to their account'),
(4, 'none', 'no privs whatsoever, placeholder only, expired or not-yet-activated accounts, etc'),
(5, 'node', 'for nodes posting data to xmlrpc');

-- --------------------------------------------------------

-- 
-- Table structure for table `revisions`
-- 

CREATE TABLE `revisions` (
  `id` int(11) NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `uuid` varchar(36) NOT NULL,
  `vm` int(11) NOT NULL,
  `vif` int(11) NOT NULL,
  `disk` int(11) NOT NULL,
  `uid` int(11) NOT NULL default '-1',
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `timestamp` (`timestamp`),
  KEY `uid` (`uid`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `revisions`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `sessions`
-- 

CREATE TABLE `sessions` (
  `id` int(11) NOT NULL auto_increment,
  `session_id` varchar(36) NOT NULL,
  `authenticated` tinyint(1) NOT NULL default '0',
  `uid` int(9) NOT NULL,
  `host` varchar(255) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `referrer` varchar(255) NOT NULL,
  `failures` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `sessions`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `shell_jobtypes`
-- 

CREATE TABLE `shell_jobtypes` (
  `name` varchar(31) NOT NULL,
  `template` varchar(255) NOT NULL,
  `speed` enum('slow','default','fast') NOT NULL default 'default',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `shell_jobtypes`
-- 

INSERT INTO `shell_jobtypes` (`name`, `template`, `speed`) VALUES ('start', '%ssh% sudo xm create /opt/zentific/vms/%domU_name%-%domU_uuid%.conf %extra%', 'default'),
('shutdown', '%ssh% "sudo xm shutdown %domU_name%"', 'default'),
('pause', '%ssh% "sudo xm pause %domU_uuid%"', 'default'),
('unpause', '%ssh% "sudo xm unpause %domU_uuid%"', 'default'),
('resume', '%ssh% sudo xm resume %domU_id%', 'default'),
('save', '%ssh% sudo xm save %domU_uuid%', 'default'),
('destroy', '%ssh% "sudo xm destroy %domU_uuid%"', 'default'),
('reboot', '%ssh% "sudo xm reboot %domU_uuid%"', 'default'),
('migrate', '%ssh% sudo xm migrate %domU_id% %dom0_hostname%', 'slow'),
('addisk', '%ssh% echo "adding disk" >> /tmp/jobs', 'default'),
('removedisk', '%ssh% echo "removing disk" >> /tmp/jobs', 'default'),
('addvif', '%ssh% echo "adding vif" >> /tmp/jobs', 'default'),
('delvif', '%ssh% echo "deleting vif" >> /tmp/jobs', 'default'),
('singleuserboot', '%ssh% echo "rebooting to single user" >> /tmp/jobs', 'default'),
('emergencyboot', '%ssh% echo "emergency boot option" >> /tmp/jobs', 'default'),
('addvmgroup', '%ssh% echo "adding  vm group" >> /tmp/jobs', 'default'),
('delvmgroup', '%ssh% echo "deleting vm group" >> /tmp/jobs', 'default'),
('example', 'echo "hello world" >> /tmp/Example.job', 'fast'),
('example_slow', 'echo "starting slow" >> /tmp/example_slow && sleep 25 && echo "ending slow" >> /tmp/example_slow', 'slow');

-- --------------------------------------------------------

-- 
-- Table structure for table `storage`
-- 

CREATE TABLE `storage` (
  `storageid` int(11) NOT NULL auto_increment,
  `type` enum('phy','file','tap:aio','qcow','nbd','iscsi','aoe','drdb') NOT NULL default 'file',
  `mode` enum('rw','ro') NOT NULL default 'rw',
  `path` varchar(512) NOT NULL COMMENT 'path to device representation, e.g. /dev/mapper/somelv',
  `vdevice` enum('hd','sd','xd') default NULL,
  `partition` varchar(4) default NULL COMMENT 'If vdevice null, use this field for entire vdevice of config',
  `onlyDom0id` int(11) default NULL COMMENT 'If not null, then storage system only available on given dom0',
  PRIMARY KEY  (`storageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `storage`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `uid` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `hash` varchar(255) NOT NULL,
  `salt` varchar(4) NOT NULL,
  `active` int(11) NOT NULL,
  `registered` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `type` int(11) NOT NULL default '4',
  `lang` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL,
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `username` (`username`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

-- 
-- Dumping data for table `users`
-- 

INSERT INTO `users` (`uid`, `username`, `hash`, `salt`, `active`, `registered`, `type`, `lang`, `email`) VALUES (2, 'demo', 'a504ac96c235c618d2d9a200534bf4b85fce3ea2', 'QprZ', 1, '2008-09-12 14:45:06', 2, 0, 'demo@zentific.com  '),
(15, 'admin', '6139d0e1e688b5c89d85b03545a11afc3acb720d', 'wpT0', 1, '2008-11-21 17:11:31', 0, 0, '');

-- --------------------------------------------------------

-- 
-- Table structure for table `vifconfig`
-- 

CREATE TABLE `vifconfig` (
  `vif` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `revision` int(11) NOT NULL,
  `type` enum('netfront','ioemu') NOT NULL default 'netfront',
  `mac` varchar(17) NOT NULL,
  `bridge` varchar(64) NOT NULL,
  `ip` double NOT NULL,
  `name` varchar(128) NOT NULL,
  `script` varchar(255) NOT NULL,
  `backend` varchar(32) NOT NULL,
  `model` varchar(16) NOT NULL default '',
  KEY `vif` (`vif`),
  KEY `timestamp` (`timestamp`),
  KEY `mac` (`mac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `vifconfig`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vifs`
-- 

CREATE TABLE `vifs` (
  `id` int(11) NOT NULL auto_increment,
  `uuid` varchar(36) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `vifs`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vifstats`
-- 

CREATE TABLE `vifstats` (
  `vif` int(11) NOT NULL,
  `timestamp` timestamp NULL default CURRENT_TIMESTAMP,
  `rxpackets` double NOT NULL default '0',
  `rxbytes` double NOT NULL default '0',
  `rxdrop` double NOT NULL default '0',
  `rxerr` double NOT NULL default '0',
  `txpackets` double NOT NULL default '0',
  `txbytes` double NOT NULL default '0',
  `txdrop` double NOT NULL default '0',
  `txerr` double NOT NULL default '0',
  KEY `timestamp` (`timestamp`),
  KEY `vif` (`vif`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `vifstats`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vmconfig`
-- 

CREATE TABLE `vmconfig` (
  `vm` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `revision` int(11) NOT NULL default '0',
  `vncpasswd` varchar(255) NOT NULL,
  `vcpus` int(11) NOT NULL,
  `kernel` varchar(1024) NOT NULL,
  `ramdisk` varchar(1024) NOT NULL,
  `cmdline` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('host','para','full','hybrid','other') NOT NULL,
  `os` varchar(255) NOT NULL,
  `mem` int(11) NOT NULL,
  `maxmem` int(11) NOT NULL,
  `vnc` tinyint(4) NOT NULL,
  `vncport` int(11) NOT NULL,
  `sdl` tinyint(4) NOT NULL,
  `pae` tinyint(4) NOT NULL,
  `acpi` tinyint(4) NOT NULL,
  `apic` tinyint(4) NOT NULL,
  `backend` tinyint(4) NOT NULL,
  `bootloader` varchar(255) NOT NULL,
  `bootloaderargs` varchar(255) NOT NULL,
  `sound` varchar(255) NOT NULL,
  `boot` varchar(255) NOT NULL,
  `device_model` varchar(255) NOT NULL,
  `on_reboot` varchar(32) NOT NULL default 'preserve',
  `on_crash` varchar(32) NOT NULL default 'preserve',
  `on_poweroff` varchar(32) NOT NULL default 'preserve',
  `monitorstate` tinyint(1) NOT NULL default '0',
  `zon_reboot` varchar(128) NOT NULL default 'reboot',
  `zon_crash` varchar(128) NOT NULL default 'reboot',
  `zon_poweroff` varchar(128) NOT NULL default 'destroy',
  KEY `vm` (`vm`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `vmconfig`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vmconsolelocks`
-- 

CREATE TABLE `vmconsolelocks` (
  `vm` int(11) NOT NULL,
  `nodehost` varchar(64) NOT NULL,
  `session` int(11) NOT NULL,
  `client` varchar(64) NOT NULL,
  `externalport` int(11) NOT NULL,
  `tunnelport` int(11) NOT NULL,
  `type` enum('vnc','text') NOT NULL,
  KEY `vm` (`vm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `vmconsolelocks`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vmlogs`
-- 

CREATE TABLE `vmlogs` (
  `vm` int(11) NOT NULL default '-1',
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `uid` int(11) NOT NULL,
  `severity` varchar(16) NOT NULL,
  `message` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `vmlogs`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vmnotes`
-- 

CREATE TABLE `vmnotes` (
  `vm` int(11) NOT NULL,
  `notes` longtext NOT NULL,
  PRIMARY KEY  (`vm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `vmnotes`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vms`
-- 

CREATE TABLE `vms` (
  `id` int(11) NOT NULL auto_increment,
  `uuid` varchar(36) NOT NULL,
  `needsreboot` int(11) NOT NULL,
  `locked` int(11) NOT NULL,
  `template` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `vms`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vmstats`
-- 

CREATE TABLE `vmstats` (
  `vm` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `state` varchar(6) NOT NULL,
  `uptime` int(11) NOT NULL,
  `cputime` double NOT NULL,
  `cpupct` double NOT NULL,
  `rxbw` int(11) NOT NULL,
  `txbw` int(11) NOT NULL,
  `domid` int(11) NOT NULL,
  KEY `timestamp` (`timestamp`),
  KEY `vm` (`vm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `vmstats`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vmtemplates`
-- 

CREATE TABLE `vmtemplates` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL,
  `architecture` enum('32','32p','64') NOT NULL,
  `description` varchar(255) NOT NULL,
  `type` enum('pv','full','hybrid') NOT NULL,
  `uuid` varchar(36) NOT NULL,
  `platform` int(11) NOT NULL,
  UNIQUE KEY `name` (`name`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `vmtemplates`
-- 

INSERT INTO `vmtemplates` (`id`, `name`, `architecture`, `description`, `type`, `uuid`, `platform`) VALUES (2, 'Ubuntu 8.04', '64', 'Hardy paravirtual installer', 'pv', 'deadbeef-0000-0000-0000-000000000000', 0);