Hmm....
fangen die Probleme schon an? Ich habs grad nochmal mit einer alten Datenbank getestet und es ging ohne Probleme. Nun denn, führe folgende Befehle in der Datenbank aus:
Code: Alles auswählen
ALTER TABLE EKBESTELL_OP DROP COLUMN LIEFERTERMIN,DROP COLUMN LIEFERINFO;
CREATE TABLE EKBESTELL_INFO (
ARTIKEL_ID INT(11) UNSIGNED NOT NULL DEFAULT "0",
EKBESTPOS_ID INT(11) UNSIGNED NOT NULL DEFAULT "0",
LIEFERTERMIN DATE NULL DEFAULT "0000-00-00",
LIEFERINFO TEXT NULL,
PRIMARY KEY (EKBESTPOS_ID)
) Type=MyISAM;
CREATE TABLE KASSE_ZBON (
REC_ID INT(11) NOT NULL AUTO_INCREMENT,
RDATUM DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00",
PRTDATUM DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00",
ZBON INT(11) NOT NULL DEFAULT "0",
BELEG_VON VARCHAR(20) NOT NULL DEFAULT "",
BELEG_BIS VARCHAR(20) NOT NULL DEFAULT "",
MWST_0 DECIMAL(5,2) NOT NULL DEFAULT "0.00",
MWST_1 DECIMAL(5,2) NOT NULL DEFAULT "0.00",
MWST_2 DECIMAL(5,2) NOT NULL DEFAULT "0.00",
MWST_3 DECIMAL(5,2) NOT NULL DEFAULT "0.00",
NSUMME_0 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
NSUMME_1 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
NSUMME_2 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
NSUMME_3 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
NSUMME DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME_0 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME_1 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME_2 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME_3 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME_0 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME_1 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME_2 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME_3 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME DECIMAL(10,2) NOT NULL DEFAULT "0.00",
WAEHRUNG VARCHAR(5) NOT NULL DEFAULT "",
KURS DECIMAL(16,4) NOT NULL DEFAULT "1.0000",
ERSTELLT DATE NULL DEFAULT NULL,
ERST_NAME VARCHAR(20) NULL DEFAULT NULL,
PRIMARY KEY (REC_ID),
INDEX IDX_RDATUM (RDATUM),
INDEX IDX_REC_ZBON (REC_ID, ZBON)
) Type=MYISAM;
CREATE TABLE KASSE_STORNO (
REC_ID INT(11) NOT NULL AUTO_INCREMENT,
BELEG VARCHAR(20) NOT NULL DEFAULT "",
RDATUM DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00",
ADDR_ID INT(11) NOT NULL DEFAULT "-1",
ZAHLART TINYINT(2) NOT NULL DEFAULT "-1",
MWST_0 DECIMAL(5,2) NOT NULL DEFAULT "0.00",
MWST_1 DECIMAL(5,2) NOT NULL DEFAULT "0.00",
MWST_2 DECIMAL(5,2) NOT NULL DEFAULT "0.00",
MWST_3 DECIMAL(5,2) NOT NULL DEFAULT "0.00",
NSUMME_0 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
NSUMME_1 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
NSUMME_2 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
NSUMME_3 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
NSUMME DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME_0 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME_1 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME_2 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME_3 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
MSUMME DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME_0 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME_1 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME_2 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME_3 DECIMAL(10,2) NOT NULL DEFAULT "0.00",
BSUMME DECIMAL(10,2) NOT NULL DEFAULT "0.00",
WAEHRUNG VARCHAR(5) NOT NULL DEFAULT "",
KURS DECIMAL(16,4) NOT NULL DEFAULT "1.0000",
STADIUM TINYINT(4) NOT NULL DEFAULT "0",
ERSTELLT DATE NULL DEFAULT NULL,
ERST_NAME VARCHAR(20) NULL DEFAULT NULL,
PRIMARY KEY (REC_ID),
INDEX IDX_RDATUM (RDATUM),
INDEX ADDR_ID (ADDR_ID, RDATUM)
) TYPE=MYISAM;