-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 12, 2006 at 01:13 PM
-- Server version: 5.0.15
-- PHP Version: 5.0.5
-- 
-- Database: `compbuild`
-- 

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

-- 
-- Table structure for table `compb_case`
-- 

CREATE TABLE `compb_case` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `ATX` enum('Yes','No') NOT NULL default 'Yes',
  `description` varchar(200) NOT NULL default '',
  `picture` varchar(200) NOT NULL
) TYPE=MyISAM;

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

-- 
-- Table structure for table `compb_cpu`
-- 

CREATE TABLE `compb_cpu` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `class` enum('A64939','A939X2','A939FX','AM2X2','AM2FX','AM264','AM2SEMP','PENT775','CEL775','7752DUO','7752EXT') NOT NULL,
  `64bit` enum('Yes','No') NOT NULL default 'Yes'
) TYPE=MyISAM;

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

-- 
-- Table structure for table `compb_drives`
-- 

CREATE TABLE `compb_drives` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `inter` enum('flpy','ide') NOT NULL default 'flpy'
) TYPE=MyISAM;

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

-- 
-- Table structure for table `compb_hd`
-- 

CREATE TABLE `compb_hd` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `SATA` enum('Yes','No') NOT NULL default 'Yes'
) TYPE=MyISAM;

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

-- 
-- Table structure for table `compb_mb`
-- 

CREATE TABLE `compb_mb` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `SATA` enum('Yes','No') NOT NULL default 'Yes',
  `ATX` enum('Yes','No') NOT NULL default 'Yes',
  `video` enum('Yes','No') NOT NULL default 'Yes',
  `class` set('A64939','A939X2','A939FX','AM2X2','AM2FX','AM264','PENT775','CEL775','7752DUO','7752EXT') NOT NULL,
  `vidinter` set('agp','pcie','cf','sli','pci') NOT NULL default '',
  `description` varchar(200) NOT NULL default ''
) TYPE=MyISAM;

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

-- 
-- Table structure for table `compb_orders`
-- 

CREATE TABLE `compb_orders` (
  `id` int(11) NOT NULL,
  `user` varchar(200) NOT NULL,
  `cpu` varchar(200) NOT NULL,
  `mb` varchar(200) NOT NULL,
  `case` varchar(200) NOT NULL,
  `ram` varchar(200) NOT NULL,
  `hd` varchar(200) NOT NULL,
  `drives` varchar(200) NOT NULL,
  `video` varchar(200) NOT NULL,
  `os` varchar(200) NOT NULL,
  `other` varchar(200) NOT NULL,
  `time` varchar(30) NOT NULL,
  `shipper` varchar(10) NOT NULL,
  `status` enum('awaiting payment','payed','completing','problem','shipped') NOT NULL default 'awaiting payment',
  `con1` varchar(10) NOT NULL,
  `con2` varchar(10) NOT NULL,
  `email` varchar(30) NOT NULL,
  `total` float NOT NULL,
  `details` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `compb_os`
-- 

CREATE TABLE `compb_os` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `64bit` enum('Yes','No') NOT NULL default 'Yes'
) TYPE=MyISAM;

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

-- 
-- Table structure for table `compb_other`
-- 

CREATE TABLE `compb_other` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `type` enum('monitor','kb/mouse','expcard','print/scan','other') NOT NULL default 'monitor'
) TYPE=MyISAM;

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

-- 
-- Table structure for table `compb_premade`
-- 

CREATE TABLE `compb_premade` (
  `id` int(11) NOT NULL,
  `Name` varchar(20) NOT NULL,
  `cpu` varchar(200) NOT NULL,
  `mb` varchar(200) NOT NULL,
  `case` varchar(200) NOT NULL,
  `ram` varchar(200) NOT NULL,
  `hd` varchar(200) NOT NULL,
  `drives` varchar(200) NOT NULL,
  `video` varchar(200) NOT NULL,
  `os` varchar(200) NOT NULL,
  `other` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `compb_ram`
-- 

CREATE TABLE `compb_ram` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0'
) TYPE=MyISAM;

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

-- 
-- Table structure for table `compb_saved`
-- 

CREATE TABLE `compb_saved` (
  `id` int(11) NOT NULL,
  `user` varchar(200) NOT NULL,
  `cpu` varchar(200) NOT NULL,
  `mb` varchar(200) NOT NULL,
  `case` varchar(200) NOT NULL,
  `ram` varchar(200) NOT NULL,
  `hd` varchar(200) NOT NULL,
  `drives` varchar(200) NOT NULL,
  `video` varchar(200) NOT NULL,
  `os` varchar(200) NOT NULL,
  `other` varchar(200) NOT NULL,
  `time` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `compb_users`
-- 

CREATE TABLE `compb_users` (
  `id` int(10) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address1` varchar(100) NOT NULL,
  `address2` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `zip` varchar(100) NOT NULL,
  `country1` varchar(100) NOT NULL,
  `country2` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `admin` int(11) NOT NULL,
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

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

-- 
-- Table structure for table `compb_video`
-- 

CREATE TABLE `compb_video` (
  `id` varchar(10) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `inter` enum('pci','pcie','agp','cf','sli') NOT NULL default 'pci',
  `card` enum('Yes','No') NOT NULL default 'Yes',
  `description` varchar(200) NOT NULL
) TYPE=MyISAM;