Вот таблица категорий:CREATE TABLE IF NOT EXISTS `vA_categories` ( `categoryID` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `parent` int(11) default NULL, `products_count` int(11) default NULL, `description` text, `picture` varchar(30) default NULL, `show` int(11) de...
Вот таблица категорий:
CREATE TABLE IF NOT EXISTS `vA_categories` (
`categoryID` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`parent` int(11) default NULL,
`products_count` int(11) default NULL,
`description` text,
`picture` varchar(30) default NULL,
`show` int(11) default NULL,
PRIMARY KEY (`categoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;
–
– Data i tabell `vA_categories`
–
INSERT INTO `vA_categories` (`categoryID`, `name`, `parent`, `products_count`, `description`, `picture`, `show`) VALUES
(1, 'Tillbehör', 0, 7, 'Att för data!', 'C1_jaguar.jpg', 1),
(2, 'Datorer', 0, 17, 'Alla datorer!', 'C2_cphone.jpg', 1),
(3, 'Macintosh', 0, 1, 'Apple', 'C3_RBaccess.jpg', 1),
(6, 'AMD +5000', 2, 1, 'descript', 'C3_RBaccess.jpg', 1),
(5, 'DVD-rom', 1, 17, 'descript', 'C2_cphone.jpg', 1),
(4, 'Mus', 1, 7, 'descript', 'C1_jaguar.jpg', 1),
(7, 'MacBook', 3, 3, 'descript', 'C3_RBaccess.jpg', 1),
(8, 'Bilar', 0, 7, 'Att för bilar!', 'C1_jaguar.jpg', 1),
(9, 'Ferrari', 8, 7, 'Att för data!', 'C1_jaguar.jpg', 1),
(10, 'Lotus', 8, 17, 'Alla datorer!', 'C2_cphone.jpg', 1);
И таблица товаров:
CREATE TABLE IF NOT EXISTS `vA_products` (
`productID` int(11) NOT NULL auto_increment,
`categoryID` int(11) default NULL,
`name` varchar(255) default NULL,
`description` text,
`customers_rating` float NOT NULL,
`Price` float default NULL,
`picture` varchar(30) default NULL,
`in_stock` int(11) default NULL,
`thumbnail` varchar(30) default NULL,
`customer_votes` int(11) NOT NULL,
`items_sold` int(11) NOT NULL,
`big_picture` varchar(30) default NULL,
`enabled` int(11) NOT NULL,
`brief_description` text,
`list_price` float default NULL,
`product_code` char(25) default NULL,
PRIMARY KEY (`productID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=115 ;
–
– Data i tabell `vA_products`
–
INSERT INTO `vA_products` (`productID`, `categoryID`, `name`, `description`, `customers_rating`, `Price`, `picture`, `in_stock`, `thumbnail`, `customer_votes`, `items_sold`, `big_picture`, `enabled`, `brief_description`, `list_price`, `product_code`) VALUES
(1, 9, 'Ferrari 360S', 'Super car!', 4.06667, 70000, '1_L2.jpg', 5, '1_L1.jpg', 12, 20, '1_L0.jpg', 1, '', 0, ''),
(2, 10, 'Lotuse Elise ', 'Sport car!', 3.06667, 60000, '1_L2.jpg', 5, '1_L1.jpg', 12, 20, '1_L0.jpg', 1, '', 0, '');