/*
Navicat MySQL Data Transfer
Source Host     : localhost:3306
Source Database : norwaybox
Target Host     : localhost:3306
Target Database : norwaybox
Date: 1/3/2010 10:54:56 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for catalogue_items
-- ----------------------------
DROP TABLE IF EXISTS `catalogue_items`;
CREATE TABLE `catalogue_items` (
  `tid` int(10) NOT NULL AUTO_INCREMENT,
  `catalogue_name` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `catalogue_description` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `catalogue_cost` int(5) NOT NULL DEFAULT '0',
  `typeid` int(1) NOT NULL DEFAULT '0',
  `length` int(2) NOT NULL DEFAULT '0',
  `width` int(2) NOT NULL DEFAULT '0',
  `top` double(4,2) NOT NULL DEFAULT '0.00',
  `name_cct` varchar(110) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `colour` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `catalogue_id_page` int(3) NOT NULL DEFAULT '0',
  `door` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `tradeable` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `recycleable` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `picture` varchar(20) COLLATE latin1_general_ci DEFAULT 'placeholder.gif',
  `catalogue_id_index` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `typeid` (`typeid`),
  KEY `catalogue_id_index` (`catalogue_id_index`)
) ENGINE=MyISAM AUTO_INCREMENT=2065234 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of catalogue_items
-- ----------------------------
INSERT INTO `catalogue_items` VALUES ('2050', 'pet0', 'pet0', '25', '1', '1', '1', '1.00', 'pet0', '0,0,0', '8', '0', '0', '0', 'placeholder.gif', '2050');
INSERT INTO `catalogue_items` VALUES ('2051', 'pet1', 'pet1', '25', '1', '1', '1', '1.00', 'pet1', '0,0,0', '8', '0', '0', '0', 'placeholder.gif', '2051');
INSERT INTO `catalogue_items` VALUES ('2052', 'pet2', 'pet2', '25', '1', '1', '1', '1.00', 'pet2', '0,0,0', '8', '0', '0', '0', 'placeholder.gif', '2052');
INSERT INTO `catalogue_items` VALUES ('2053', 'nest', 'nest', '0', '4', '1', '1', '1.00', 'nest', '0,0,0', '8', '0', '0', '0', 'placeholder.gif', '2053');
