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

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

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

DROP TABLE IF EXISTS `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 `config`
-- 

DROP TABLE IF EXISTS `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', '2678400', 0),
('nodeuser', 'default', 0),
('language', 'en_US', 0);

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

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

DROP TABLE IF EXISTS `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,
  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`
-- 

DROP TABLE IF EXISTS `disks`;
CREATE TABLE `disks` (
  `id` int(11) NOT NULL auto_increment,
  `vmuuid` varchar(36) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

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


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

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

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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=7 ;

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

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

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

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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=1 ;

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

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

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

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

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `nodeconfig`;
CREATE TABLE `nodeconfig` (
  `node` 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`
-- 

DROP TABLE IF EXISTS `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=2 ;

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


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

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

DROP TABLE IF EXISTS `nodestats`;
CREATE TABLE `nodestats` (
  `node` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  KEY `timestamp` (`timestamp`),
  KEY `node` (`node`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `plugins`;
CREATE TABLE `plugins` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `frontend` int(1) NOT NULL,
  `backend` int(1) NOT NULL,
  `enabled` int(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `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`
-- 

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

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

DROP TABLE IF EXISTS `revisions`;
CREATE TABLE `revisions` (
  `id` int(11) NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `vmuuid` 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=57 ;

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

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

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

DROP TABLE IF EXISTS `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=241 ;

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

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

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

DROP TABLE IF EXISTS `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 %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`
-- 

DROP TABLE IF EXISTS `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 `templates`
-- 

DROP TABLE IF EXISTS `templates`;
CREATE TABLE `templates` (
  `templateid` int(11) NOT NULL auto_increment,
  `description` varchar(255) NOT NULL,
  `OS` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `vmtype` enum('pv','hvm') NOT NULL,
  `storagetype` enum('file','lvm','phy') NOT NULL,
  `path` varchar(255) NOT NULL,
  PRIMARY KEY  (`templateid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `templates`
-- 


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

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

DROP TABLE IF EXISTS `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=26 ;

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

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

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

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `vifs`;
CREATE TABLE `vifs` (
  `id` int(11) NOT NULL auto_increment,
  `vmuuid` varchar(36) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

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

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

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

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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 `vmnotes`
-- 

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `vms`;
CREATE TABLE `vms` (
  `id` int(11) NOT NULL auto_increment,
  `vmuuid` varchar(36) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

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

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

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

DROP TABLE IF EXISTS `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`
--