# phpMyAdmin MySQL-Dump
# version 2.5.1
# http://www.phpmyadmin.net/ (download page)
#
# Host: galileo
# Generation Time: Jun 11, 2004 at 01:57 AM
# Server version: 3.23.58
# PHP Version: 4.3.2
# Database : `UML`
# --------------------------------------------------------

#
# Table structure for table `Configurations`
#
# Creation: Apr 05, 2004 at 11:57 PM
# Last update: Apr 05, 2004 at 11:57 PM
#

CREATE TABLE `Configurations` (
  `ID` int(16) NOT NULL auto_increment,
  `User` varchar(16) NOT NULL default '',
  `Label` longtext NOT NULL,
  `Memory` int(16) NOT NULL default '0',
  `ubda` int(16) NOT NULL default '0',
  `ubdb` int(16) NOT NULL default '0',
  `ubdc` int(16) NOT NULL default '0',
  `ubdd` int(16) NOT NULL default '0',
  `ubde` int(16) NOT NULL default '0',
  `ubdf` int(16) NOT NULL default '0',
  `ubdg` int(16) NOT NULL default '0',
  `ubdh` int(16) NOT NULL default '0',
  `root` varchar(32) NOT NULL default '',
  `kernel` int(16) NOT NULL default '0',
  UNIQUE KEY `ID` (`ID`),
  KEY `User` (`User`)
) TYPE=MyISAM COMMENT='Configuration profiles' AUTO_INCREMENT=1 ;

#
# Dumping data for table `Configurations`
#

# --------------------------------------------------------

#
# Table structure for table `Disks`
#
# Creation: Apr 06, 2004 at 12:03 AM
# Last update: Apr 06, 2004 at 12:03 AM
#

CREATE TABLE `Disks` (
  `ID` int(16) NOT NULL auto_increment,
  `User` varchar(16) NOT NULL default '',
  `Size` bigint(32) NOT NULL default '0',
  `Type` enum('ext2','swap') NOT NULL default 'ext2',
  `Label` varchar(32) NOT NULL default '',
  UNIQUE KEY `ID` (`ID`),
  KEY `User` (`User`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `Disks`
#

# --------------------------------------------------------

#
# Table structure for table `Distros`
#
# Creation: Apr 14, 2004 at 09:50 AM
# Last update: Apr 28, 2004 at 04:58 PM
#

CREATE TABLE `Distros` (
  `ID` varchar(16) NOT NULL default '',
  `Text` varchar(32) NOT NULL default '',
  `Description` varchar(128) NOT NULL default '',
  `Size` int(16) NOT NULL default '0',
  `Avail` enum('FALSE','TRUE') NOT NULL default 'FALSE',
  `Default` enum('FALSE','TRUE') NOT NULL default 'FALSE',
  UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM;

#
# Dumping data for table `Distros`
#

INSERT INTO `Distros` VALUES ('redhat9', 'RedHat 9 (small)', 'RedHat Linux 9 (small)', 0, 'TRUE', 'FALSE');
INSERT INTO `Distros` VALUES ('debian', 'Debian (not supported)', 'Debian', 0, 'TRUE', 'FALSE');
INSERT INTO `Distros` VALUES ('gentoo', 'Gentoo (not supported)', 'Gentoo', 0, 'TRUE', 'FALSE');
INSERT INTO `Distros` VALUES ('fc1', 'Fedora Core 1 (not supported)', 'Fedora Core 1', 635, 'TRUE', 'FALSE');
INSERT INTO `Distros` VALUES ('redhat9_large', 'RedHat 9 (large)', 'RedHat Linux 9 (large)', 1700, 'TRUE', 'TRUE');
# --------------------------------------------------------

#
# Table structure for table `Group_Membership`
#
# Creation: Apr 06, 2004 at 12:33 AM
# Last update: Apr 11, 2004 at 07:23 PM
# Last check: Apr 06, 2004 at 12:33 AM
#

CREATE TABLE `Group_Membership` (
  `UID` int(16) NOT NULL default '0',
  `GID` int(16) NOT NULL default '0',
  `Type` enum('none','view','control','full') NOT NULL default 'none',
  KEY `GID` (`GID`),
  KEY `UID` (`UID`)
) TYPE=MyISAM COMMENT='Maps Users to Groups';

#
# Dumping data for table `Group_Membership`
#

INSERT INTO `Group_Membership` VALUES (1001, 1, 'full');
INSERT INTO `Group_Membership` VALUES (0, 1, 'full');
INSERT INTO `Group_Membership` VALUES (0, 2, 'full');
# --------------------------------------------------------

#
# Table structure for table `Groups`
#
# Creation: Apr 06, 2004 at 12:09 AM
# Last update: Apr 11, 2004 at 06:32 PM
#

CREATE TABLE `Groups` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(16) NOT NULL default '',
  `Description` varchar(128) NOT NULL default '',
  UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM COMMENT='Groups' AUTO_INCREMENT=4 ;

#
# Dumping data for table `Groups`
#

INSERT INTO `Groups` VALUES (1, 'Test', 'Test Machines');
# --------------------------------------------------------

#
# Table structure for table `Settings`
#
# Creation: Mar 21, 2004 at 03:31 AM
# Last update: Mar 21, 2004 at 03:33 AM
#

CREATE TABLE `Settings` (
  `StartupDelay` int(11) NOT NULL default '2',
  `ShutdownDelay` int(11) NOT NULL default '20',
  `HaltDelay` int(11) NOT NULL default '20',
  `BaseDir` longtext,
  `StatusDir` longtext,
  `HostsDir` longtext,
  `RefreshDefault` int(11) NOT NULL default '10'
) TYPE=MyISAM;

#
# Dumping data for table `Settings`
#

INSERT INTO `Settings` VALUES (2, 20, 20, '/home/uml/', 'Status/', 'Hosts/', 10);
# --------------------------------------------------------

#
# Table structure for table `Status`
#
# Creation: Apr 29, 2004 at 02:40 PM
# Last update: May 28, 2004 at 03:42 AM
#

CREATE TABLE `Status` (
  `ID` varchar(16) NOT NULL default '',
  `UpdateTime` varchar(32) NOT NULL default '0000-00-00 00:00:00',
  `status` enum('on','off','unconfig','deploying') NOT NULL default 'unconfig',
  `runlevel` varchar(32) NOT NULL default '',
  `uptime` varchar(32) NOT NULL default '',
  `load` varchar(32) NOT NULL default '',
  `kernel` varchar(32) NOT NULL default '',
  `host` enum('0','1') NOT NULL default '0',
  UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM;

#
# Dumping data for table `Status`
#

INSERT INTO `Status` VALUES ('uml5', '2004-05-03 19:48:35', 'on', '3', '3 days, 03:56:56.78', '0.07 0.04 0.00', '2.4.24-2um', '0');
INSERT INTO `Status` VALUES ('uml-host2', '2004-05-03 19:48:35', 'on', '3', '5 days, 02:52:10.07', '0.09 0.04 0.01', '2.4.25', '1');
# --------------------------------------------------------

#
# Table structure for table `queue`
#
# Creation: Apr 30, 2004 at 03:31 PM
# Last update: May 26, 2004 at 02:54 PM
#

CREATE TABLE `queue` (
  `qid` bigint(20) NOT NULL auto_increment,
  `umid` varchar(16) NOT NULL default '',
  `host` varchar(32) NOT NULL default '',
  `action` enum('none','boot','halt','shutdown','password','deploy') NOT NULL default 'none',
  `arg1` varchar(64) NOT NULL default '',
  `arg2` varchar(64) NOT NULL default '',
  `arg3` varchar(128) NOT NULL default '',
  `processing` enum('0','1') NOT NULL default '0',
  `complete` enum('0','1') NOT NULL default '0',
  `entrytime` varchar(32) NOT NULL default '0000-00-00 00:00:00',
  `starttime` varchar(32) NOT NULL default '0000-00-00 00:00:00',
  `finishtime` varchar(32) NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`qid`),
  KEY `umid` (`umid`),
  KEY `host` (`host`)
) TYPE=MyISAM AUTO_INCREMENT=57 ;

#
# Dumping data for table `queue`
#

INSERT INTO `queue` VALUES (1, 'uml12', 'uml-host3', 'shutdown', '', '', '', '0', '1', '2004-04-30 15:45:20', '2004-04-30 15:45:21', '2004-04-30 15:45:39');
INSERT INTO `queue` VALUES (2, 'uml12', 'uml-host3', 'password', 'root', '$1$fwCkubOK$jleAfTDHpA7uHa.Wk7Zii1', '', '0', '1', '2004-04-30 15:46:01', '2004-04-30 15:46:05', '2004-04-30 15:46:06');
# --------------------------------------------------------

#
# Table structure for table `umls`
#
# Creation: Apr 14, 2004 at 09:56 AM
# Last update: May 26, 2004 at 02:48 PM
# Last check: Apr 14, 2004 at 09:56 AM
#

CREATE TABLE `umls` (
  `umid` varchar(16) NOT NULL default '',
  `Distro` varchar(32) NOT NULL default '',
  `TotalMemory` mediumint(9) NOT NULL default '0',
  `mem` mediumint(9) NOT NULL default '0',
  `TotalDisk` int(16) NOT NULL default '5120',
  `AvailableDisk` int(16) NOT NULL default '5120',
  `kernel` varchar(32) NOT NULL default '',
  `host` varchar(128) NOT NULL default '',
  `GID` int(16) NOT NULL default '0',
  `Runlevel` enum('default','single') NOT NULL default 'default',
  `onoff` enum('off','on') NOT NULL default 'off',
  `AutoFSCK` enum('off','on') NOT NULL default 'off',
  UNIQUE KEY `umid` (`umid`),
  KEY `Group` (`GID`)
) TYPE=MyISAM;

#
# Dumping data for table `umls`
#

INSERT INTO `umls` VALUES ('uml1', 'redhat9_large', 512, 128, 5120, 5120, '', 'uml-host1', 1, 'default', 'on', 'off');
INSERT INTO `umls` VALUES ('uml3', 'debian', 512, 512, 5120, 5120, '', 'uml-host1', 1, 'default', 'on', 'off');
INSERT INTO `umls` VALUES ('uml5', 'redhat9_large', 512, 320, 5120, 5120, '', 'uml-host2', 3, 'default', 'on', 'off');
# --------------------------------------------------------

#
# Table structure for table `users`
#
# Creation: Apr 08, 2004 at 01:52 PM
# Last update: May 26, 2004 at 02:48 PM
#

CREATE TABLE `users` (
  `username` varchar(16) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `uid` int(11) NOT NULL auto_increment,
  `gid` int(11) NOT NULL default '500',
  `Names` longtext NOT NULL,
  `admin` enum('FALSE','TRUE') NOT NULL default 'FALSE',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=1036 ;

#
# Dumping data for table `users`
#

INSERT INTO `users` VALUES ('umltest1', '$1$AUGwqoQW$bB2.lWgduwsEHT0FutTeQ/', 1001, 500, 'Frank', '');
INSERT INTO `users` VALUES ('uml1', '$1$p6yBwCvq$UFfgV4jJjrUuzMpREMEEM.', 1007, 500, 'Frank', '');
INSERT INTO `users` VALUES ('uml3', '$1$u09uTlps$9ILFXFMLIGCJnrW.T11ko.', 1009, 500, '', '');
INSERT INTO `users` VALUES ('uml5', '$1$yZYwzl9F$O7V/k3Cvtv3nLkHJzMVPY0', 1011, 500, 'Frank', 'FALSE');

