-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 12. Februar 2008 um 15:27
-- Server Version: 5.0.32
-- PHP-Version: 5.2.0-8+etch4
-- 
-- Datenbank: `adamoto`
-- 

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

-- 
-- Tabellenstruktur für Tabelle `Distribution`
-- 

CREATE TABLE IF NOT EXISTS `Distribution` (
  `ID` int(11) NOT NULL auto_increment,
  `PackageID` int(11) NOT NULL default '0',
  `SystemID` int(11) NOT NULL default '0',
  `CDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `DDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `State` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3884 ;

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

-- 
-- Tabellenstruktur für Tabelle `OS`
-- 

CREATE TABLE IF NOT EXISTS `OS` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

-- 
-- Tabellenstruktur für Tabelle `Package`
-- 

CREATE TABLE IF NOT EXISTS `Package` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL default '',
  `NetConnection` varchar(255) NOT NULL default '',
  `File` varchar(255) NOT NULL default '',
  `InstallationProgram` varchar(255) NOT NULL default '',
  `Active` tinyint(4) NOT NULL default '0',
  `Priority` tinyint(4) NOT NULL default '0',
  `CreationDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `OSID` int(11) NOT NULL default '0',
  `NetConnectionInstallProgram` varchar(255) NOT NULL default '',
  `CheckFile` varchar(255) NOT NULL default '',
  `timeout` int(11) NOT NULL default '0',
  `autocheck` tinyint(4) NOT NULL default '0',
  `Type` enum('automatic detection','linux rpm','native installer(linux bash)','native installer(linux executeble)','windows msi','windows setup','native installer(windows exe)','native installer(windows bat)') NOT NULL default 'automatic detection',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

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

-- 
-- Tabellenstruktur für Tabelle `States`
-- 

CREATE TABLE IF NOT EXISTS `States` (
  `ID` tinyint(4) NOT NULL default '0',
  `Description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Tabellenstruktur für Tabelle `System`
-- 

CREATE TABLE IF NOT EXISTS `System` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL default '',
  `OSID` int(11) NOT NULL default '1',
  `CDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Reserved` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=200 ;