-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 05, 2007 at 12:35 AM
-- Server version: 5.0.19
-- PHP Version: 5.1.6
-- 
-- Database: `bootmanager`
-- 

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

-- 
-- Table structure for table `machines`
-- 

CREATE TABLE `machines` (
  `id` int(11) NOT NULL auto_increment,
  `hostname` varchar(16) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `mac` varchar(20) NOT NULL,
  `os` tinyint(4) NOT NULL,
  `app` tinyint(4) NOT NULL,
  `lastchanged` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `comment` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `machines`
-- 

INSERT INTO `machines` VALUES (1, 'quad01', '10.0.0.151', '00:50:45:5D:6D:7B', 1, 1, '0000-00-00 00:00:00', 'just testing..');

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

-- 
-- Table structure for table `os`
-- 

CREATE TABLE `os` (
  `id` tinyint(4) NOT NULL auto_increment,
  `os` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `os`
-- 

INSERT INTO `os` VALUES (1, 'windows xp');
INSERT INTO `os` VALUES (2, 'windows xp x64');
INSERT INTO `os` VALUES (3, 'linux ubuntu');