1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| Structure de la table `cms_shop_items`
--
CREATE TABLE `cms_shop_items` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`rc_id` smallint(5) unsigned NOT NULL default '0',
`brand_id` tinyint(4) unsigned NOT NULL default '0',
`target_id` tinyint(3) unsigned NOT NULL default '0',
`item_description` text,
`item_trax` varchar(7) NOT NULL default '',
`item_id` varchar(30) NOT NULL default '',
`item_price` varchar(7) NOT NULL default '0.00',
`item_pic` varchar(50) NOT NULL default 'nopic.gif',
`item_pic1` varchar(50) NOT NULL default 'spacer.gif',
`item_pic2` varchar(50) NOT NULL default 'spacer.gif',
`item_pic3` varchar(50) NOT NULL default 'spacer.gif',
`item_comment` varchar(50) default '',
`item_ftech` text,
`item_dia` tinyint(3) unsigned default NULL,
`item_nosell` tinyint(4) NOT NULL default '0',
`item_new` tinyint(1) unsigned NOT NULL default '0',
`item_special` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=127 ;
--
-- Contenu de la table `cms_shop_items`
--
INSERT INTO `cms_shop_items` VALUES (91, 8, 11, 6, 'Mag PPG A', '5x120', '16PPGA', '120', '5.gif', 'spacer.gif', 'spacer.gif', 'spacer.gif', NULL, NULL, 17, 0, 1, 0);
INSERT INTO `cms_shop_items` VALUES (92, 8, 11, 6, NULL, '5x120', '', '', '6.gif', 'spacer.gif', 'spacer.gif', 'spacer.gif', NULL, NULL, 16, 0, 0, 0); |
Partager