Moderator: heiner
Heinerder User hat die ZIP-Dateien mit den Plugins direkt in den "plugins"-Ordner kopiert. Das geht nicht. Entweder manuell im Ordner "plugins" ENTPACKEN oder den Plugin-Manager unter Datei->Einstellungen->Plugins verwenden.
Code: Alles auswählen
private void update0329(Connection conn) throws ApplicationException
{
Map<String, String> statements = new HashMap<String, String>();
// Update fuer H2
statements
.put(
DBSupportH2Impl.class.getName(),
"CREATE TABLE qifimporthead( "
+ " id IDENTITY(1), "
+ " name VARCHAR(30), "
+ " beschreibung VARCHAR(30), "
+ " startsalto DOUBLE, "
+ " startdate DATE, "
+ " konto INTEGER, "
+ " importdatum DATE NOT NULL, "
+ " importfile VARCHAR(256), "
+ " processdate DATE, "
+ " UNIQUE(id), "
+ " PRIMARY KEY(id) "
+ ");\n "
+
" CREATE TABLE qifimportpos( "
+ " posid IDENTITY(1), "
+ " headid INTEGER NOT NULL, "
+ " datum DATE NOT NULL, "
+ " betrag DOUBLE NOT NULL, "
+ " beleg VARCHAR(30), "
+ " name VARCHAR(100), "
+ " zweck VARCHAR(100), "
+ " buchartex VARCHAR(50), "
+ " buchart INTEGER, "
+ " mitgliedbar VARCHAR(1), "
+ " mitglied INTEGER, "
+ " sperre VARCHAR(1), "
+ " UNIQUE(posid) "
+ " );\n "
+
" ALTER TABLE qifimportpos ADD CONSTRAINT fkImpKntPos1 FOREIGN KEY (headid) REFERENCES qifimporthead(id) DEFERRABLE;\n");
// Update fuer MySQL
statements
.put(
DBSupportMySqlImpl.class.getName(),
"CREATE TABLE qifimporthead( "
+ " id int(10) AUTO_INCREMENT, "
+ " name VARCHAR(30), "
+ " beschreibung VARCHAR(30), "
+ " startdate DATE, "
+ " startsalto DOUBLE, "
+ " konto int(10), "
+ " importdatum DATE NOT NULL, "
+ " importfile VARCHAR(256), "
+ " processdate DATE, "
+ " UNIQUE(id), "
+ " PRIMARY KEY(id) "
+ " );\n "
+
"CREATE TABLE qifimportpos( "
+ " posid int(10) AUTO_INCREMENT, "
+ " headid int(10) NOT NULL, "
+ " datum DATE NOT NULL, "
+ " betrag DOUBLE NOT NULL, "
+ " beleg VARCHAR(30), "
+ " name VARCHAR(100), "
+ " zweck VARCHAR(100), "
+ " buchartex VARCHAR(50), "
+ " buchart int(10), "
+ " mitgliedbar VARCHAR(1), "
+ " mitglied int(10), "
+ " sperre VARCHAR(1), "
+ " UNIQUE(posid) "
+ " );\n "
+
"ALTER TABLE qifimportpos ADD CONSTRAINT fkImpKntPos1 FOREIGN KEY (headid) REFERENCES qifimporthead(id);\n");
execute(conn, statements,
"Neue Tabellen für Import von Buchungen aus z.B. Quicken.", 329);
}
Code: Alles auswählen
lower_case_table_names=1Code: Alles auswählen
ENGINE=InnoDB