-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4-Debian-2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jan 04, 2006 at 10:52 AM
-- Server version: 4.1.15
-- PHP Version: 4.4.0-4
-- 
-- Database: `edos_debian`
-- 

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

-- DROP DATABASE edos_debian;
CREATE DATABASE edos_debian;
USE edos_debian;

-- 
-- Table structure for table `disjunctions`
-- 

CREATE TABLE `disjunctions` (
  `ID` int(11) NOT NULL auto_increment,
  `RANGE_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `lifetime`
-- 

CREATE TABLE `lifetime` (
  `PACKAGE_ID` int(11) NOT NULL default '0',
  `START` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `END` timestamp NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `packages`
-- 

CREATE TABLE `packages` (
  `ID` int(11) NOT NULL auto_increment,
  `UNIT_ID` int(11) NOT NULL default '0',
  `VERSION_NUMBER` int(11) default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `ranges`
-- 

CREATE TABLE `ranges` (
  `ID` int(11) NOT NULL auto_increment,
  `UNIT_ID` int(11) NOT NULL default '0',
  `MINVER` int(11) default NULL,
  `MAXVER` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `requirements`
-- 

CREATE TABLE `requirements` (
  `PACKAGE_ID` int(11) NOT NULL default '0',
  `TYPE` tinyint(3) unsigned NOT NULL default '0',
  `TARGET` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `units`
-- 

CREATE TABLE `units` (
  `ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `versions`
-- 

CREATE TABLE `versions` (
  `UNIT_ID` int(11) NOT NULL default '0',
  `VERSION` varchar(64) NOT NULL default '',
  `VERSION_NUMBER` int(11) NOT NULL default '0',
  PRIMARY KEY  (`UNIT_ID`,`VERSION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

GRANT ALL PRIVILEGES ON edos_debian.* TO 'edos-debian'@'localhost' IDENTIFIED BY 'hexuronic';
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4-Debian-2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jan 04, 2006 at 10:52 AM
-- Server version: 4.1.15
-- PHP Version: 4.4.0-4
-- 
-- Database: `edos_debian`
-- 

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

-- DROP DATABASE edos_debian;
CREATE DATABASE edos_debian;
USE edos_debian;

-- 
-- Table structure for table `disjunctions`
-- 

CREATE TABLE `disjunctions` (
  `ID` int(11) NOT NULL auto_increment,
  `RANGE_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `lifetime`
-- 

CREATE TABLE `lifetime` (
  `PACKAGE_ID` int(11) NOT NULL default '0',
  `START` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `END` timestamp NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `packages`
-- 

CREATE TABLE `packages` (
  `ID` int(11) NOT NULL auto_increment,
  `UNIT_ID` int(11) NOT NULL default '0',
  `VERSION_NUMBER` int(11) default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `ranges`
-- 

CREATE TABLE `ranges` (
  `ID` int(11) NOT NULL auto_increment,
  `UNIT_ID` int(11) NOT NULL default '0',
  `MINVER` int(11) default NULL,
  `MAXVER` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `requirements`
-- 

CREATE TABLE `requirements` (
  `PACKAGE_ID` int(11) NOT NULL default '0',
  `TYPE` tinyint(3) unsigned NOT NULL default '0',
  `TARGET` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `units`
-- 

CREATE TABLE `units` (
  `ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `versions`
-- 

CREATE TABLE `versions` (
  `UNIT_ID` int(11) NOT NULL default '0',
  `VERSION` varchar(64) NOT NULL default '',
  `VERSION_NUMBER` int(11) NOT NULL default '0',
  PRIMARY KEY  (`UNIT_ID`,`VERSION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

GRANT ALL PRIVILEGES ON edos_debian.* TO 'edos-debian'@'localhost' IDENTIFIED BY 'hexuronic';
