UI:DB Structure

From SoftwareFor

 CREATE TABLE `pkgs` (
   pkg_id int(4) unsigned NOT NULL auto_increment,
   title varchar(50) NOT NULL default ,
   description varchar(250) NOT NULL default ,
   author varchar(50) NOT NULL default ,
   url varchar(250) NOT NULL default ,
   path varchar(100) NOT NULL default ,
   version varchar(20) default NULL,
   installer varchar(50) NOT NULL default ,
   lic_id int(4) unsigned NULL default 
   cat_id varchar(50) NOT NULL default ,
   complexity_id tinyint NOT NULL default '1',
   language varchar(10) NOT NULL default 'en_US',
   PRIMARY KEY  (`pkg_id`)
 );

 CREATE TABLE `software` (
   sw_id int(4) unsigned NOT NULL auto_increment,
   pkg_id int(4) unsigned NOT NULL default ,
   version enum('mac', 'win'),
   path varchar(150) NOT NULL default ,
   PRIMARY KEY (`sw_id`)
 );

 CREATE TABLE `deps` (
   dep_id int(4) unsigned NOT NULL default ,
   pkg_id int(4) unsigned NOT NULL default 
 );

 CREATE TABLE `category` (
   cat_id int(4) unsigned NOT NULL auto_increment,
   cat_name varchar(50) NOT NULL default ,
   description varchar(255) NULL,
   PRIMARY KEY (`cat_id`)
 );

 CREATE TABLE `complexity` (
   complexity_id int(4) unsigned NOT NULL auto_increment,
   complexity_name varchar(50) NOT NULL default ,
   PRIMARY KEY (`complexity_id`)
 );

 CREATE TABLE `licenses` (
   lic_id int(4) unsigned NOT NULL auto_increment,
   name varchar(50) NOT NULL default 'GNU Public License v2',
   url varchar(150) NOT NULL default ,
   PRIMARY KEY  (`lic_id`)
 );

 CREATE TABLE `pkg_licenses` (
   pkg_id int(4) unsigned NOT NULL default ,
   lic_id int(4) unsigned NOT NULL default 
 );

 CREATE TABLE `media` (
   media_id int(4) unsigned NOT NULL auto_increment,
   pkg_id int(4) unsigned NOT NULL,
   type enum('image', 'video'),
   file varchar(60) NOT NULL default ,
   alt_file varchar(70) NOT NULL default ,
   description text NOT NULL default ,
   PRIMARY KEY  (`media_id`)
 );