-- phpMyAdmin SQL Dump
-- version 2.11.4deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 16. Mai 2008 um 12:41
-- Server Version: 5.0.51
-- PHP-Version: 5.2.5-3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `adamoto`
--
DROP DATABASE `adamoto`;
CREATE DATABASE `adamoto` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `adamoto`;

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

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

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

--
-- Daten für Tabelle `Distribution`
--

INSERT INTO `Distribution` (`ID`, `PackageID`, `SystemID`, `CDate`, `DDate`, `State`) VALUES
(3897, 33, 12, '2008-05-16 12:34:02', '0000-00-00 00:00:00', 2),
(3898, 33, 13, '2008-05-16 12:34:02', '0000-00-00 00:00:00', 10),
(3899, 33, 14, '2008-05-16 12:34:02', '0000-00-00 00:00:00', 2),
(3900, 33, 15, '2008-05-16 12:34:02', '0000-00-00 00:00:00', 1),
(3901, 33, 16, '2008-05-16 12:34:02', '0000-00-00 00:00:00', 2),
(3902, 33, 17, '2008-05-16 12:34:02', '0000-00-00 00:00:00', 0),
(3903, 33, 18, '2008-05-16 12:34:02', '0000-00-00 00:00:00', 0),
(3904, 33, 19, '2008-05-16 12:34:02', '0000-00-00 00:00:00', 0),
(3905, 26, 2, '2008-05-16 12:34:10', '0000-00-00 00:00:00', 0),
(3906, 26, 7, '2008-05-16 12:34:10', '0000-00-00 00:00:00', 0),
(3907, 26, 8, '2008-05-16 12:34:10', '0000-00-00 00:00:00', 2),
(3908, 26, 9, '2008-05-16 12:34:10', '0000-00-00 00:00:00', 0),
(3909, 26, 10, '2008-05-16 12:34:10', '0000-00-00 00:00:00', 0),
(3910, 26, 11, '2008-05-16 12:34:10', '0000-00-00 00:00:00', 2),
(3911, 28, 2, '2008-05-16 12:34:31', '0000-00-00 00:00:00', 0),
(3912, 28, 7, '2008-05-16 12:34:31', '0000-00-00 00:00:00', 2),
(3913, 28, 8, '2008-05-16 12:34:31', '0000-00-00 00:00:00', 0);

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

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

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

--
-- Daten für Tabelle `OS`
--

INSERT INTO `OS` (`ID`, `Name`) VALUES
(1, 'Linux'),
(2, 'Windows');

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

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

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

--
-- Daten für Tabelle `Package`
--

INSERT INTO `Package` (`ID`, `Name`, `NetConnection`, `File`, `InstallationProgram`, `Active`, `Priority`, `CreationDate`, `OSID`, `NetConnectionInstallProgram`, `CheckFile`, `timeout`, `autocheck`, `Type`) VALUES
(33, 'install_firefox', 'http://adamoto.localdomain.local/adamoto/packages/install_firefox/', 'install_firefox.sh', '', 1, 1, '0000-00-00 00:00:00', 0, '', '/opt/adamoto/autocheck/install_firefox', 5, 1, 'native installer(linux bash)'),
(26, 'change_smb_conf', 'http://adamoto.localdomain.local/adamoto/packages/change_smb_conf/', 'change_smb_conf.sh', '', 1, 3, '0000-00-00 00:00:00', 0, '', '/opt/adamoto/autocheck/change_smb_conf', 31, 1, 'native installer(linux bash)'),
(28, 'restart_apache_service', 'http://adamoto.localdomain.local/adamoto/packages/change_smb_conf/restart_apache_service', 'restart_apache_service.sh', '', 1, 1, '0000-00-00 00:00:00', 0, '', '/opt/adamoto/autocheck/restart_apache_service', 60, 1, 'native installer(linux bash)');

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

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

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

--
-- Daten für Tabelle `States`
--

INSERT INTO `States` (`ID`, `Description`) VALUES
(0, 'Queued for Deployment (0)'),
(1, 'Currently Deploying (1)'),
(2, 'Succesfully Deployed (2)'),
(10, 'Timeout Error (10)'),
(20, 'XML Package Error (20)');

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

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

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

--
-- Daten für Tabelle `System`
--

INSERT INTO `System` (`ID`, `Name`, `OSID`, `CDate`, `Reserved`) VALUES
(2, 'Lin1', 1, '0000-00-00 00:00:00', 0),
(7, 'Lin2', 1, '0000-00-00 00:00:00', 0),
(8, 'Lin3', 1, '0000-00-00 00:00:00', 0),
(9, 'Lin4', 1, '0000-00-00 00:00:00', 0),
(10, 'Lin5', 1, '0000-00-00 00:00:00', 0),
(11, 'Lin6', 1, '0000-00-00 00:00:00', 0),
(12, 'Win1', 1, '0000-00-00 00:00:00', 0),
(13, 'Win2', 1, '0000-00-00 00:00:00', 0),
(14, 'Win3', 1, '0000-00-00 00:00:00', 0),
(15, 'Win4', 1, '0000-00-00 00:00:00', 0),
(16, 'Win5', 1, '0000-00-00 00:00:00', 0),
(17, 'Win6', 1, '0000-00-00 00:00:00', 0),
(18, 'Win7', 1, '0000-00-00 00:00:00', 0),
(19, 'Win8', 1, '0000-00-00 00:00:00', 0);