# phpMyAdmin MySQL-Dump
# version 2.5.1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Feb 11, 2004 at 11:59 AM
# Server version: 4.0.13
# PHP Version: 4.3.2
# Database : `test`
# --------------------------------------------------------
#
# Table structure for table `inventory`
#
# Creation: Feb 11, 2004 at 09:56 AM
# Last update: Feb 11, 2004 at 11:53 AM
#
CREATE TABLE `inventory` (
`idnum` int(11) NOT NULL auto_increment,
`boldlabel` tinytext,
`description` mediumtext,
`status` tinytext,
`price` tinytext,
`picture1` varchar(30) NOT NULL default '',
`picture2` varchar(30) NOT NULL default '',
`picture3` varchar(30) NOT NULL default '',
`active` smallint(6) NOT NULL default '0',
`dateadded` date NOT NULL default '0000-00-00',
`datesold` date NOT NULL default '0000-00-00',
`fldsort` varchar(5) NOT NULL default '',
PRIMARY KEY (`idnum`),
FULLTEXT KEY `fldsort` (`fldsort`)
) TYPE=MyISAM COMMENT='charlie''s table' AUTO_INCREMENT=4 ;
#
# Dumping data for table `inventory`
#
INSERT INTO `inventory` VALUES (1, 'BAKER, USA,', '"Special Paragon" SLNE, c.1903. Bespoke gun engraved by Frank Mason. Damascus proofed for nitro powder. 2 3/4", 32" choked Mod/Full. 14 1/4" lightly figured, original, refinished stock with Baker butt plate. Action retains sharp game scene and scroll engraving and has gone to gray. 8lbs 12oz. Beautiful barrels.', 'Sale Pending', '$1,000', 'DSCN3758.jpg', 'DSCN3759.jpg', '', 1, '2004-02-10', '0000-00-00', '3');
INSERT INTO `inventory` VALUES (2, 'PARKER, USA,', 'Trojan, BLNE, 2 1/2", 30" choked Full/Full. 14" lightly figured wood to grooved butt plate. Action has gone to gray. 7lbs 10oz.', 'New Listing', '$1,350', 'DSCN3764.jpg', 'DSCN3766.jpg', '', 1, '2004-01-30', '0000-00-00', '');
INSERT INTO `inventory` VALUES (3, 'WW GREENER, BIRMINGHAM,', '20 bore, back action, round body, top lever hammer gun with rebounding locks. Recently re-furbished by Malcolm Cruxton in \r\nEngland. Sleeved 30" barrels, choked Full/Full, 13 7/8" LOP. Manufactured 1883, provenances by Graham Greener. 5lbs 5oz. Beautiful little hammer that would make an excellent dove and quail gun.', 'Sold', '$3000', 'DSCN1765.jpg', 'DSCN1785.jpg', '', 2, '2003-02-14', '2003-06-14', '2');