rendered paste body-- 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');