Tabel Database Webauction

-- phpMyAdmin SQL Dump
-- version 2.8.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost:3306
-- Generation Time: Feb 09, 2008 at 09:40 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.4
-- 
-- Database: `apps_12`
-- 

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

-- 
-- Table structure for table `bids`
-- 

CREATE TABLE `bids` (
  `bid_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL default '0',
  `username` varchar(32) NOT NULL default ,
  `time_of_bid` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `bid_amount` float NOT NULL default '0',
  `bid_status` enum('PENDING','APPROVED','REJECTED') NOT NULL default 'PENDING',
  PRIMARY KEY  (`bid_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `bids`
-- 

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

-- 
-- Table structure for table `closed`
-- 

CREATE TABLE `closed` (
  `product_id` int(11) NOT NULL default '0',
  `winner` varchar(32) NOT NULL default ,
  `bid_amount` float NOT NULL default '0',
  `email_sent` tinyint(1) NOT NULL default '0',
  `admin_email_sent` tinyint(4) NOT NULL default '0',
  `close_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `closed`
-- 

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

-- 
-- Table structure for table `config`
-- 

CREATE TABLE `config` (
  `auction_id` int(11) NOT NULL auto_increment,
  `title` varchar(64) default NULL,
  `admin_email` varchar(128) default NULL,
  `notification_from_address` varchar(128) default NULL,
  `closing_time` datetime default NULL,
  `bid_increment` float default NULL,
  `minimum_bid` float default NULL,
  `default_closing_time` datetime default NULL,
  `default_opening_time` datetime default NULL,
  `timezone` varchar(64) default NULL,
  `send_email_notifications` tinyint(1) default NULL,
  `send_outbid_notifications_to_admin` tinyint(1) default NULL,
  `winner_instructions` text,
  `reverse_auction` tinyint(1) unsigned NOT NULL default '0',
  `custom_header` text,
  `custom_footer` text,
  `custom_css` text,
  PRIMARY KEY  (`auction_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `config`
-- 

INSERT INTO `config` (`auction_id`, `title`, `admin_email`, `notification_from_address`, `closing_time`,  `bid_increment`, `minimum_bid`, `default_closing_time`, `default_opening_time`, `timezone`, `send_email_notifications`, `send_outbid_notifications_to_admin`, `winner_instructions`, `reverse_auction`, `custom_header`, `custom_footer`, `custom_css`) VALUES (1, 'My Super Auction', 'admin@yourdomain.com', 'Auction <admin@yourdomain.com>', NULL, 5, 5, '2007-12-31 20:08:00', '2007-12-21 20:09:00', NULL, 1, 1, 'You have won the auction.', 0, NULL, NULL, NULL);

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

-- 
-- Table structure for table `dataface__version`
-- 

CREATE TABLE `dataface__version` (
  `version` int(5) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `dataface__version`
-- 

INSERT INTO `dataface__version` (`version`) VALUES (30);

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

-- 
-- Table structure for table `product_categories`
-- 

CREATE TABLE `product_categories` (
  `category_id` int(11) NOT NULL auto_increment,
  `category_name` varchar(64) NOT NULL default ,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `product_categories`
-- 

INSERT INTO `product_categories` (`category_id`, `category_name`) VALUES (6, 'VCRs');

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

-- 
-- Table structure for table `products`
-- 

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL auto_increment,
  `product_name` varchar(64) NOT NULL default ,
  `product_description` text,
  `product_image` varchar(128) default NULL,
  `product_image_mimetype` varchar(128) default NULL,
  `product_categories` varchar(32) default NULL,
  `seller_username` varchar(32) NOT NULL default ,
  `minimum_bid` float default NULL,
  `bid_increment` float NOT NULL default '5',
  `opening_time` datetime default NULL,
  `closing_time` datetime default NULL,
  `created_date` datetime default NULL,
  `modified_date` datetime default NULL,
  `entered_by` varchar(32) default NULL,
  PRIMARY KEY  (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `products`
-- 

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

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `username` varchar(32) NOT NULL default ,
  `password` varchar(32) NOT NULL default ,
  `firstname` varchar(32) default NULL,
  `lastname` varchar(32) default NULL,
  `title` varchar(32) default NULL,
  `department` varchar(32) default NULL,
  `phone` varchar(15) default NULL,
  `email` varchar(64) NOT NULL default ,
  `role` enum('USER','ADMIN') NOT NULL default 'USER',
  `prefs_receive_outbid_notifications` tinyint(1) NOT NULL default '1',
  `timezone` varchar(64) default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `users`
-- 

INSERT INTO `users` (`username`, `password`, `firstname`, `lastname`, `title`, `department`, `phone`, `email`, `role`, `prefs_receive_outbid_notifications`, `timezone`) VALUES ('admin', '5f4dcc3b5aa765d61d8327deb882cf99',  'Administrator', , 'Admin', 'Auction', '555-5555', 'admin@weblite.ca', 'ADMIN', 1, NULL);