von kulli » Di 15. Jan 2013, 17:07
jetzt hab ichs noch mit mysqldumper probiert:
MySQL-ERROR
MySQL meldet:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) , `aktiv` smallint(1) unsigned NULL DEFAULT '0', `lager` int(5' at line 25
Fehler bei der Anfrage:
CREATE TABLE `randshop_artikel` ( `id` int(11) unsigned NULL auto_increment, `artikel_nr` varchar(30) NULL, `variante1` int(10) unsigned NULL DEFAULT '0', `variante2` int(10) unsigned NULL DEFAULT '0', `variante3` int(10) unsigned NULL DEFAULT '0', `variante4` int(10) unsigned NULL DEFAULT '0', `preis_alt_netto` decimal(12,2) unsigned NULL DEFAULT '0.00', `preis_alt_brutto` decimal(12,2) unsigned NULL DEFAULT '0.00', `preis_netto` decimal(12,2) unsigned NULL DEFAULT '0.00', `preis_brutto` decimal(12,2) unsigned NULL DEFAULT '0.00', `mwst` int(10) unsigned NULL DEFAULT '0', `timestamp` timestamp NULL DEFAULT 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP, `aktiv` smallint(1) unsigned NULL DEFAULT '0', `lager` int(5) NULL DEFAULT '0', `wie_oft_bestellt` int(6) NULL DEFAULT '0', `angebote` int(6) NULL DEFAULT '0', `merkmalauswahl` tinyint(1) unsigned NULL DEFAULT '0', `kundengruppenpreis` tinyint(1) unsigned NULL DEFAULT '0', `merkmalkombination` int(10) unsigned NULL DEFAULT '0', `merkmalkombinationparentid` int(10) unsigned NULL DEFAULT '0', `merkmalkombinationsort` int(10) unsigned NULL DEFAULT '0', `merkmalkombinationstandard` int(10) unsigned NULL DEFAULT '0', `produktgruppe` int(5) NULL DEFAULT '0', `gewicht` decimal(12,2) unsigned NULL DEFAULT '0.00', `voe_datum` date NULL DEFAULT '0000-00-00', `hersteller_id` int(11) unsigned NULL DEFAULT '0', `startseitenangebot` tinyint(1) unsigned NULL DEFAULT '0', `aktuellartikel` tinyint(1) NULL DEFAULT '0', `lieferstatus` int(10) unsigned NULL DEFAULT '0', `artikel_download` int(10) NULL DEFAULT '0', `ean` varchar(50) NULL, `image_language_independent` tinyint(1) unsigned NULL DEFAULT '0', `download_language_independent` tinyint(1) unsigned NULL DEFAULT '0', `gruppenartikel` smallint(1) unsigned NULL DEFAULT '0', `giveaway` tinyint(1) NULL, `giveaway_min_bestellwert` decimal(12,2) NULL DEFAULT '0.00', `giveaway_rabattprozent` decimal(12,0) NULL DEFAULT '0', `einheit_groesse` float unsigned NULL, `einheit_masseinheit` varchar(10) NULL, `upload` tinyint(1) unsigned NULL DEFAULT '0', `lager_bestellungen` int(10) unsigned NULL, `meldebestand` int(10) unsigned NULL, PRIMARY KEY (id), KEY `mwstsatz` (mwst), KEY `INDEX_wie_oft_bestellt` (wie_oft_bestellt), KEY `merkmalkombinationparentid` (merkmalkombinationparentid), FULLTEXT KEY `FULLTEXT_artikel_nr` (artikel_nr) );
Fatal error: Couldn't create table or view `randshop_artikel´
carpe diem