-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 13, 2006 at 10:52 PM
-- Server version: 5.0.18
-- PHP Version: 4.4.1
-- 
-- Database: `gp_version2`
-- 

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

-- 
-- Table structure for table `category`
-- 

CREATE TABLE `category` (
  `category_p` int(11) unsigned NOT NULL auto_increment,
  `category_title` varchar(250) NOT NULL default '',
  `_added` datetime default NULL,
  `_removed` datetime default NULL,
  `_marker` int(1) NOT NULL default '0',
  PRIMARY KEY  (`category_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Ebuild Categories' AUTO_INCREMENT=147 ;

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

-- 
-- Table structure for table `contest_vote`
-- 

CREATE TABLE `contest_vote` (
  `user_f` int(6) NOT NULL,
  `vote` int(2) NOT NULL,
  `votetime` datetime NOT NULL,
  UNIQUE KEY `user_f` (`user_f`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `ebuild`
-- 

CREATE TABLE `ebuild` (
  `ebuild_p` int(11) unsigned NOT NULL auto_increment,
  `package_f` int(11) unsigned NOT NULL default '0',
  `ebuild_display` varchar(250) NOT NULL default '',
  `ebuild_search` varchar(250) NOT NULL default '',
  `ebuild_description` text NOT NULL,
  `ebuild_urls` text NOT NULL,
  `ebuild_keywords` text NOT NULL,
  `ebuild_use` text NOT NULL,
  `ebuild_licence` text NOT NULL,
  `ebuild_ideps` text NOT NULL,
  `ebuild_rdeps` text NOT NULL,
  `ebuild_version` varchar(30) NOT NULL default '',
  `ebuild_revision` int(5) NOT NULL default '0',
  `ebuild_contents_md5` varchar(80) NOT NULL default '',
  `hard_masked` int(1) NOT NULL default '0',
  `_added` datetime default NULL,
  `_edited` datetime default NULL,
  `_removed` datetime default NULL,
  `_marker` int(1) NOT NULL default '0',
  PRIMARY KEY  (`ebuild_p`),
  FULLTEXT KEY `ebuild_display` (`ebuild_display`,`ebuild_search`,`ebuild_description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24321 ;

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

-- 
-- Table structure for table `ebuild_contents`
-- 

CREATE TABLE `ebuild_contents` (
  `ebuild_f` int(11) unsigned NOT NULL default '0',
  `ebuild_contents` text NOT NULL,
  UNIQUE KEY `ebuild_f` (`ebuild_f`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `ebuild_keyword`
-- 

CREATE TABLE `ebuild_keyword` (
  `ebuild_f` int(11) NOT NULL default '0',
  `keyword_f` int(11) NOT NULL default '0',
  `_added` datetime default NULL,
  UNIQUE KEY `ebuild_f` (`ebuild_f`,`keyword_f`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `gentoo_bugs`
-- 

CREATE TABLE `gentoo_bugs` (
  `bug_id` int(11) NOT NULL default '0',
  `severity` varchar(20) NOT NULL default '',
  `priority` varchar(10) NOT NULL default '',
  `platform` varchar(15) NOT NULL default '',
  `assigned_to` varchar(100) NOT NULL default '',
  `status` varchar(30) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`bug_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='bugs retrived from gentoo.org';

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

-- 
-- Table structure for table `glsa`
-- 

CREATE TABLE `glsa` (
  `glsa_p` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `_added` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`glsa_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=662 ;

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

-- 
-- Table structure for table `keyword`
-- 

CREATE TABLE `keyword` (
  `keyword_p` int(4) unsigned NOT NULL auto_increment,
  `keyword` varchar(10) NOT NULL default '',
  `_added` datetime default NULL,
  PRIMARY KEY  (`keyword_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='keywords' AUTO_INCREMENT=29 ;

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

-- 
-- Table structure for table `local_use_flag`
-- 

CREATE TABLE `local_use_flag` (
  `local_use_flag_p` int(10) unsigned NOT NULL auto_increment,
  `use_flag` varchar(25) NOT NULL default '',
  `pkg_title` varchar(100) NOT NULL default '',
  `use_desc` text NOT NULL,
  PRIMARY KEY  (`local_use_flag_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1600 ;

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

-- 
-- Table structure for table `news`
-- 

CREATE TABLE `news` (
  `news_p` int(6) unsigned NOT NULL auto_increment,
  `user_f` int(11) NOT NULL default '1',
  `news_title` varchar(250) NOT NULL default '',
  `news_content` text NOT NULL,
  `comment_count` int(10) NOT NULL default '0',
  `_publish` int(1) NOT NULL default '0',
  `_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`news_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

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

-- 
-- Table structure for table `news_comment`
-- 

CREATE TABLE `news_comment` (
  `news_comment_p` int(11) unsigned NOT NULL auto_increment,
  `news_f` int(11) NOT NULL default '0',
  `user_f` int(11) NOT NULL default '0',
  `comment_text` text NOT NULL,
  `_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`news_comment_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ;

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

-- 
-- Table structure for table `package`
-- 

CREATE TABLE `package` (
  `package_p` int(11) unsigned NOT NULL auto_increment,
  `category_f` int(11) unsigned NOT NULL default '0',
  `package_title` varchar(250) NOT NULL default '',
  `package_description` text NOT NULL,
  `_added` datetime default NULL,
  `_removed` datetime default NULL,
  `_marker` int(1) NOT NULL default '0',
  PRIMARY KEY  (`package_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11073 ;

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

-- 
-- Table structure for table `package_changelog`
-- 

CREATE TABLE `package_changelog` (
  `package_changelog_p` int(11) unsigned NOT NULL auto_increment,
  `package_f` int(11) NOT NULL default '0',
  `changelog` text NOT NULL,
  `changelog_md5` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`package_changelog_p`),
  UNIQUE KEY `package_f` (`package_f`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10794 ;

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

-- 
-- Table structure for table `package_comment`
-- 

CREATE TABLE `package_comment` (
  `package_comment_p` int(11) unsigned NOT NULL auto_increment,
  `package_f` int(11) NOT NULL default '0',
  `user_f` int(11) NOT NULL default '0',
  `comment_text` text NOT NULL,
  `_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`package_comment_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

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

-- 
-- Table structure for table `package_image`
-- 

CREATE TABLE `package_image` (
  `package_image_p` int(10) unsigned NOT NULL auto_increment,
  `package_f` int(11) NOT NULL default '0',
  `login_f` int(11) NOT NULL default '0',
  `image_md5` varchar(80) NOT NULL default '',
  `image_ext` varchar(5) NOT NULL default '',
  `image_caption` text NOT NULL,
  `_added` datetime default NULL,
  PRIMARY KEY  (`package_image_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=781 ;

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

-- 
-- Table structure for table `page404`
-- 

CREATE TABLE `page404` (
  `page404_p` int(10) unsigned NOT NULL auto_increment,
  `page` varchar(250) NOT NULL,
  `referrer` varchar(250) NOT NULL,
  `ip_address` varchar(50) NOT NULL,
  `404_time` datetime NOT NULL,
  PRIMARY KEY  (`page404_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `site_vars`
-- 

CREATE TABLE `site_vars` (
  `key` varchar(250) NOT NULL default '',
  `value` varchar(250) NOT NULL default '',
  UNIQUE KEY `key` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `stats`
-- 

CREATE TABLE `stats` (
  `stats_p` int(11) unsigned NOT NULL auto_increment,
  `category` int(6) NOT NULL default '0',
  `package` int(6) NOT NULL default '0',
  `ebuild` int(6) NOT NULL default '0',
  `add_category` int(6) NOT NULL default '0',
  `add_package` int(6) NOT NULL default '0',
  `add_ebuild` int(6) NOT NULL default '0',
  `del_category` int(6) NOT NULL default '0',
  `del_package` int(6) NOT NULL default '0',
  `del_ebuild` int(6) NOT NULL default '0',
  `comments` int(6) NOT NULL default '0',
  `images` int(6) NOT NULL default '0',
  `stats_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`stats_p`),
  UNIQUE KEY `stats_date` (`stats_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

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

-- 
-- Table structure for table `use_flag`
-- 

CREATE TABLE `use_flag` (
  `use_flag_p` int(10) unsigned NOT NULL auto_increment,
  `use_flag` varchar(50) NOT NULL default '',
  `use_desc` text NOT NULL,
  `use_type` int(1) NOT NULL default '0',
  `pkg_count` int(5) NOT NULL default '0',
  PRIMARY KEY  (`use_flag_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1507 ;

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

-- 
-- Table structure for table `user`
-- 

CREATE TABLE `user` (
  `user_p` int(10) unsigned NOT NULL auto_increment,
  `user_email` varchar(100) NOT NULL default '',
  `user_display` varchar(250) NOT NULL default '',
  `user_password` varchar(50) NOT NULL default '',
  `temp_password` varchar(50) NOT NULL default '',
  `cookie_key` varchar(50) NOT NULL default '',
  `preferences` text NOT NULL,
  `admin` int(1) NOT NULL default '0',
  `ip_address` varchar(75) NOT NULL,
  `_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_p`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4509 ;

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

-- 
-- Table structure for table `user_tracking`
-- 

CREATE TABLE `user_tracking` (
  `user_tracking_p` int(11) unsigned NOT NULL auto_increment,
  `user_f` int(11) NOT NULL default '0',
  `package_f` int(11) NOT NULL default '0',
  `package_display` varchar(250) NOT NULL default '',
  `_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_tracking_p`),
  UNIQUE KEY `user_f` (`user_f`,`package_f`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1316 ;