-- http://www.phpmyadmin.net
-- 
-- 
-- Database: `samples`
-- 
CREATE DATABASE `samples`;
USE samples;

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

-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
  `category_id` int(10) unsigned NOT NULL auto_increment,
  `category_name` varchar(30) NOT NULL default '',
  `description` varchar(255) default NULL,
  `image_name` varchar(150) default NULL,
  PRIMARY KEY  (`category_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `categories`
-- 


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

-- 
-- Table structure for table `customers`
-- 

CREATE TABLE `customers` (
  `customer_id` int(10) unsigned NOT NULL auto_increment,
  `fname` varchar(35) NOT NULL default '',
  `mname` varchar(35) default NULL,
  `lname` varchar(35) default NULL,
  `company` varchar(40) default NULL,
  `title` varchar(30) default NULL,
  `address1` varchar(60) NOT NULL default '',
  `address2` varchar(60) default NULL,
  `address3` varchar(60) default NULL,
  `city` varchar(50) NOT NULL default '',
  `state_province` varchar(50) default NULL,
  `country` varchar(50) NOT NULL default '',
  `postal_code` varchar(30) NOT NULL default '',
  `phone` varchar(25) default NULL,
  `fax` varchar(25) default NULL,
  PRIMARY KEY  (`customer_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `customers`
-- 

INSERT INTO `customers` (`customer_id`, `fname`, `mname`, `lname`, `company`, `title`, `address1`, `address2`, `address3`, `city`, `state_province`, `country`, `postal_code`, `phone`, `fax`) VALUES (1, 'George', '', 'Clington', 'Nowhere Inc.', 'President', '101 New York Ave.', '', '', 'New York', 'New York', 'USA', '10101', '212-555-1212', '');
INSERT INTO `customers` (`customer_id`, `fname`, `mname`, `lname`, `company`, `title`, `address1`, `address2`, `address3`, `city`, `state_province`, `country`, `postal_code`, `phone`, `fax`) VALUES (5, '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `customers` (`customer_id`, `fname`, `mname`, `lname`, `company`, `title`, `address1`, `address2`, `address3`, `city`, `state_province`, `country`, `postal_code`, `phone`, `fax`) VALUES (6, 'Fname', 'Mname', 'Lname', 'Company', 'Title', 'Address1', 'Address2', 'Address3', 'City', 'State_province', 'Country', 'Postal_code', 'Phone', 'Fax');
INSERT INTO `customers` (`customer_id`, `fname`, `mname`, `lname`, `company`, `title`, `address1`, `address2`, `address3`, `city`, `state_province`, `country`, `postal_code`, `phone`, `fax`) VALUES (7, '', '', '', '', '', 'George St.', '', '', '', '', '', '', '', '');

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

-- 
-- Table structure for table `order_details`
-- 

CREATE TABLE `order_details` (
  `order_id` int(10) unsigned NOT NULL default '0',
  `product_id` varchar(35) NOT NULL default '',
  `unit_price` float unsigned default NULL,
  `quantity` float unsigned default NULL,
  `discount` float unsigned NOT NULL default '0',
  PRIMARY KEY  (`order_id`,`product_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `order_details`
-- 


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

-- 
-- Table structure for table `orders`
-- 

CREATE TABLE `orders` (
  `order_id` int(10) unsigned NOT NULL auto_increment,
  `customer_id` int(10) unsigned NOT NULL default '0',
  `order_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `shipped_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `shipper` varchar(40) NOT NULL default '',
  `total_order` float NOT NULL default '0',
  `ship_cost` float NOT NULL default '0',
  `ship_address1` varchar(60) NOT NULL default '',
  `ship_address2` varchar(60) default NULL,
  `ship_address3` varchar(60) default NULL,
  `ship_city` varchar(40) NOT NULL default '',
  `ship_state_province` varchar(40) default NULL,
  `ship_country` varchar(50) NOT NULL default '',
  `ship_postal_code` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`order_id`),
  UNIQUE KEY `invoice_id` (`order_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `orders`
-- 


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

-- 
-- Table structure for table `posts`
-- 

CREATE TABLE `posts` (
  `id` mediumint(9) NOT NULL auto_increment,
  `authorname` varchar(60) default NULL,
  `authoremail` varchar(60) default NULL,
  `messagebody` blob,
  KEY `id` (`id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `posts`
-- 

INSERT INTO `posts` (`id`, `authorname`, `authoremail`, `messagebody`) VALUES (12, 'Joe Knoll', 'jknoll@test.com', 0x54686973206973206d7920706f7374);

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

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

CREATE TABLE `products` (
  `product_id` varchar(35) NOT NULL default '',
  `product_name` varchar(100) NOT NULL default '',
  `category_id` int(11) NOT NULL default '0',
  `unit_price` int(11) NOT NULL default '0',
  `in_stock` int(11) NOT NULL default '0',
  `description` varchar(255) default NULL,
  `is_active` tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

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


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

-- 
-- Table structure for table `tbl_users`
-- 

CREATE TABLE `tbl_users` (
  `iUserID` mediumint(8) unsigned NOT NULL auto_increment,
  `sFName` varchar(35) NOT NULL default '',
  `sMName` varchar(35) default NULL,
  `sLName` varchar(35) NOT NULL default '',
  `sAddr1` varchar(40) NOT NULL default '',
  `sAddr2` varchar(35) default NULL,
  `sCity` varchar(35) NOT NULL default '',
  `sState` varchar(35) NOT NULL default '',
  `sPCode` varchar(35) NOT NULL default '',
  `cCountryCode` char(2) NOT NULL default '',
  `sPhone` varchar(30) NOT NULL default '',
  `sEmail` varchar(80) NOT NULL default '',
  `sPassword` varchar(60) NOT NULL default '',
  `sQ1` varchar(60) default NULL,
  `sQ2` varchar(60) default NULL,
  `sQ3` varchar(60) default NULL,
  `sAccessPeriod` tinyint(4) NOT NULL default '0',
  `dtInserted` timestamp(14) NOT NULL,
  `dtUpdated` datetime default NULL,
  PRIMARY KEY  (`iUserID`),
  UNIQUE KEY `iUserID` (`iUserID`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `tbl_users`
-- 

INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (24, 'Bill', 'NULL', 'Rogers', '10 Will Way', 'NULL', 'San Diego', 'CA', '31021', 'US', '212-333-2222', 'webmaster11@renderedlogic.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050304223740', NULL);
INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (23, 'George', 'NULL', 'Lee', '101 New York Ave.', 'NULL', 'New York', 'NY', '10101', 'US', '212-555-1212', 'webmaster@renderedlogic.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050221003134', NULL);
INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (28, 'George', 'NULL', 'Lee', '101 New York Ave.', 'NULL', 'New York', 'NY', '10101', 'US', '212-555-1212', 'bmaxx@invisiontek.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050304015817', NULL);
INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (25, 'Mary', 'NULL', 'Stevens', '222 Trille Hwy.', 'NULL', 'Dallas', 'TX', '32321', 'US', '333-555-1212', 'info@invisiontek.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050304223924', NULL);
INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (26, 'Wilma', 'NULL', 'Flintstone', 'Bedrock Way', 'NULL', 'Bedrock', 'NY', '00001', 'US', '212-545-5543', 'info1@invisiontek.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050304224015', NULL);
INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (27, 'George', 'NULL', 'Lee', '101 New York Ave.', 'NULL', 'New York', 'NY', '10101', 'US', '212-555-1212', 'info2@invisiontek.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050223021304', NULL);
INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (29, 'George', 'NULL', 'Lee', '101 New York Ave.', 'NULL', 'New York', 'NY', '10101', 'US', '212-555-1212', 'webmaster@invisiontek.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050304021705', NULL);
INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (30, 'George', 'NULL', 'Lee', '101 New York Ave.', 'NULL', 'New York', 'NY', '10101', 'US', '212-555-1212', 'webmaster1@invisiontek.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050304022040', NULL);
INSERT INTO `tbl_users` (`iUserID`, `sFName`, `sMName`, `sLName`, `sAddr1`, `sAddr2`, `sCity`, `sState`, `sPCode`, `cCountryCode`, `sPhone`, `sEmail`, `sPassword`, `sQ1`, `sQ2`, `sQ3`, `sAccessPeriod`, `dtInserted`, `dtUpdated`) VALUES (31, 'George', 'NULL', 'Lee', '101 New York Ave.', 'NULL', 'New York', 'NY', '10101', 'US', '212-555-1212', 'info11@invisiontek.com', 'e10adc3949ba59abbe56e057f20f883e', 'College student', 'Section Two', 'Geometry but no trig', 15, '20050304045751', NULL);

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

-- 
-- Table structure for table `topics`
-- 

CREATE TABLE `topics` (
  `id` mediumint(9) NOT NULL auto_increment,
  `subject` varchar(60) NOT NULL default '',
  KEY `id` (`id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `topics`
-- 

INSERT INTO `topics` (`id`, `subject`) VALUES (1, 'Subject');
INSERT INTO `topics` (`id`, `subject`) VALUES (2, 'Subject');
INSERT INTO `topics` (`id`, `subject`) VALUES (3, '1');
INSERT INTO `topics` (`id`, `subject`) VALUES (4, '1222');
