- Table structure for table `items`
-- 

CREATE TABLE `items` (
  `itemId` int(11) NOT NULL auto_increment,
  `userId` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `description` blob NOT NULL,
  `price` float(10,2) NOT NULL default '0.00',
  `date` date NOT NULL default '0000-00-00',
  `image` varchar(100) NOT NULL default '',
  `thumb` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`itemId`),
  KEY `userId` (`userId`)
) TYPE=MyISAM AUTO_INCREMENT=583 ;

-- 
-- Dumping data for table `items`
-- 

INSERT INTO `items` VALUES (556, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (557, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (554, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (555, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (553, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (546, 34, 'tes', 'antiques', 0x746573, 324.00, '2006-06-19', 'images/34/james1.jpg', 'thumb_images/34/james1.jpg');
INSERT INTO `items` VALUES (547, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/34/james1.jpg', 'thumb_images/34/james1.jpg');
INSERT INTO `items` VALUES (558, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (559, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (560, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (561, 34, '1988 buick reatta', 'antiques', 0x63617220666f722073616c65, 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (562, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (563, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (564, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (565, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (566, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (567, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (568, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (569, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (570, 34, '', '', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (571, 34, 'car for sale', 'antiques', 0x492068617665206120757365642063617220666f722073616c65, 3000.00, '2006-06-19', 'images/34/Sunset.jpg', 'thumb_images/34/Sunset.jpg');
INSERT INTO `items` VALUES (572, 24, '1999 CHEVY 1/2 SHORTBED SILVERADO PICKUP', '', 0x524544, 0.00, '2006-06-20', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (573, 24, '1999 CHEVY 1/2 SHORTBED SILVERADO PICKUP', '', 0x524544, 0.00, '2006-06-20', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (574, 34, '', 'appliances', '', 0.00, '2006-06-20', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (575, 0, '', 'appliances', '', 0.00, '2006-06-20', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (576, 0, '', 'appliances', '', 0.00, '2006-06-20', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (577, 34, '', 'antiques', '', 0.00, '2006-06-20', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (578, 34, '', 'antiques', '', 0.00, '2006-06-20', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (579, 36, 'test', 'antiques', 0x74657374, 32423.00, '2006-06-20', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (580, 36, 'this is a test', 'antiques', 0x7468697320697320612074657374, 3200.00, '2006-06-20', 'images/36/image.jpg', 'thumb_images/36/image.jpg');
INSERT INTO `items` VALUES (581, 36, '', 'antiques', '', 0.00, '2006-06-20', 'images/36/002-02dodge.jpg', 'thumb_images/36/002-02dodge.jpg');
INSERT INTO `items` VALUES (582, 36, '2002 dodge', 'antiques', 0x4920686176652061203230303220646f64676520666f722073616c6520706c6561736520636f6e74616374206d6520666f72206d6f726520696e666f726d6174696f6e, 10.00, '2006-06-20', 'images/36/002-02dodge.jpg', 'thumb_images/36/002-02dodge.jpg');
INSERT INTO `items` VALUES (551, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/34/', 'thumb_images/34/');
INSERT INTO `items` VALUES (552, 34, '', '', '', 0.00, '2006-06-19', 'images/noimage.jpg', 'thumb_images/noimage.jpg');
INSERT INTO `items` VALUES (550, 34, '', 'antiques', '', 0.00, '2006-06-19', 'images/34/', 'thumb_images/34/');
INSERT INTO `items` VALUES (549, 34, '1998 Ford durango', 'antiques', 0x4772656174206a6565702077697468206e6963652072696d73, 23423.00, '2006-06-19', 'images/34/james1.jpg', 'thumb_images/34/james1.jpg');
INSERT INTO `items` VALUES (548, 34, '1998 Ford durango', 'antiques', 0x4772656174206a6565702077697468206e6963652072696d73, 23423.00, '2006-06-19', 'images/34/james1.jpg', 'thumb_images/34/james1.jpg');