-- phpMyAdmin SQL Dump
-- version 2.10.3deb1ubuntu0.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 18, 2008 at 09:40 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.3-1ubuntu6.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `aus`
-- 

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

-- 
-- Table structure for table `buildId`
-- 

DROP TABLE IF EXISTS `buildIds`;
CREATE TABLE IF NOT EXISTS `buildIds` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `buildTarget`
-- 

DROP TABLE IF EXISTS `buildTargets`;
CREATE TABLE IF NOT EXISTS `buildTargets` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `channel`
-- 

DROP TABLE IF EXISTS `channels`;
CREATE TABLE IF NOT EXISTS `channels` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `distribution`
-- 

DROP TABLE IF EXISTS `distributions`;
CREATE TABLE IF NOT EXISTS `distributions` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `distributionVersion`
-- 

DROP TABLE IF EXISTS `distributionVersions`;
CREATE TABLE IF NOT EXISTS `distributionVersions` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `locale`
-- 

DROP TABLE IF EXISTS `locales`;
CREATE TABLE IF NOT EXISTS `locales` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `osVersion`
-- 

DROP TABLE IF EXISTS `osVersions`;
CREATE TABLE IF NOT EXISTS `osVersions` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `patches`
-- 

DROP TABLE IF EXISTS `patches`;
CREATE TABLE IF NOT EXISTS `patches` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` int(10) unsigned NOT NULL COMMENT "1 - complete; 2 - partial",
  `url` varchar(1024) NOT NULL,
  `hashFunction` varchar(10) NOT NULL,
  `hashValue` varchar(1024) NOT NULL,
  `size` varchar(15) NOT NULL,
  `build` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `product`
-- 

DROP TABLE IF EXISTS `products`;
CREATE TABLE IF NOT EXISTS `products` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `releases`
-- 

DROP TABLE IF EXISTS `releases`;
CREATE TABLE IF NOT EXISTS `releases` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'PK',
  `product_id` int(10) unsigned NOT NULL COMMENT 'FK(products)',
  `version_id` int(10) unsigned NOT NULL COMMENT 'FK(versions)',
  `buildId_id` int(10) unsigned NOT NULL COMMENT 'FK(buildIds)',
  `buildTarget_id` int(10) unsigned NOT NULL COMMENT 'FK(buildTargets)',
  `locale_id` int(10) unsigned NOT NULL COMMENT 'FK(locales)',
  `channel_id` int(10) unsigned NOT NULL COMMENT 'FK(channels)',
  `osVersion_id` int(10) unsigned default NULL COMMENT 'FK(osVersions)',
  `distribution_id` int(10) unsigned default NULL COMMENT 'FK(distributions)',
  `distributionVersion_id` int(10) unsigned default NULL COMMENT 'FK(distributionVersions)',
  `update_id` int(10) unsigned default NULL COMMENT 'FK(updates)',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `updates`
-- 

DROP TABLE IF EXISTS `updates`;
CREATE TABLE IF NOT EXISTS `updates` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `updateType` int(10) unsigned default '1' COMMENT '1 - minor; 2 - major',
  `version` varchar(10) default NULL,
  `appv` varchar(50) NOT NULL,
  `extv` varchar(50) NOT NULL,
  `detailsUrl` varchar(1024) default NULL,
  `licenseUrl` varchar(1024) default NULL,
  `complete_patch__id` int(10) unsigned NOT NULL,
  `partial_patch_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `version`
-- 

DROP TABLE IF EXISTS `versions`;
CREATE TABLE IF NOT EXISTS `versions` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;