Habs gefunden:
CREATE TABLE `products` (
`products_id` int(11) NOT NULL auto_increment,
`products_quantity` int(4) NOT NULL default '0',
`products_model` varchar(12) default NULL,
`products_image` varchar(64) default NULL,
`products_image_medium` varchar(64) NOT NULL default '',
`products_image_large` varchar(64) NOT NULL default '',
`products_price` decimal(15,4) NOT NULL default '0.0000',
`products_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`products_last_modified` datetime default NULL,
`products_date_available` datetime default NULL,
`products_weight` decimal(5,2) NOT NULL default '0.00',
`products_status` tinyint(1) NOT NULL default '0',
`products_tax_class_id` int(11) NOT NULL default '0',
`manufacturers_id` int(11) default NULL,
`products_ordered` int(11) NOT NULL default '0',
`products_price_pref` tinyint(1) NOT NULL default '0',
`products_family` varchar(64) NOT NULL default '',
`v_order` tinyint(3) unsigned NOT NULL default '0',
`products_ean` varchar(13) NOT NULL default '',
`products_userfield_1` varchar(255) NOT NULL default '',
`products_userfield_2` varchar(255) NOT NULL default '',
`products_userfield_3` varchar(255) NOT NULL default '',
`products_userfield_4` varchar(255) NOT NULL default '',
`products_userfield_5` varchar(255) NOT NULL default '',
`products_userfield_6` varchar(255) NOT NULL default '',
`products_userfield_7` varchar(255) NOT NULL default '',
`products_userfield_8` varchar(255) NOT NULL default '',
`products_userfield_9` varchar(255) NOT NULL default '',
`products_userfield_10` varchar(255) NOT NULL default '',
`zwischenablage_userfeld_2` text NOT NULL,
`rec_id` int(11) NOT NULL default '0',
PRIMARY KEY (`products_id`),
KEY `idx_products_model` (`products_model`),
KEY `idx_products_date_added` (`products_date_added`)
) ENGINE=MyISAM AUTO_INCREMENT=9237 DEFAULT CHARSET=latin1
PHP-Code:
CREATE TABLE `products_attributes` (n `products_attributes_id` int(11) NOT NULL auto_increment,n `products_id` int(11) NOT NULL default '0',n `options_id` int(11) NOT NULL default '0',n `options_values_id` int(11) NOT NULL default '0',n `options_values_price` decimal(15,4) NOT NULL default '0.0000',n `price_prefix` char(1) NOT NULL default '+',n `bestellnummer` varchar(15) NOT NULL default '',n PRIMARY KEY (`products_attributes_id`),n KEY `idx_products_attributes_products_id` (`products_id`)n) ENGINE=MyISAM AUTO_INCREMENT=14180 DEFAULT CHARSET=latin1