]> wagnertech.de Git - mfinanz.git/blobdiff - sql/Pg-upgrade2/csv_import_report_cache.sql
BackgroundJobCleanup
[mfinanz.git] / sql / Pg-upgrade2 / csv_import_report_cache.sql
index 440c346108f1993fa19f8484cd03aa45355ef2e0..e401b8397afaa607adb7dc524afb3d85487ce678 100644 (file)
@@ -19,9 +19,10 @@ CREATE TABLE csv_import_report_rows (
   value                TEXT
 );
 
-CREATE TABLE csv_import_report_row_status (
+CREATE TABLE csv_import_report_status (
   id                   SERIAL PRIMARY KEY,
-  csv_import_report_row_id INTEGER NOT NULL REFERENCES csv_import_report_rows(id),
+  csv_import_report_id INTEGER NOT NULL REFERENCES csv_import_reports(id),
+  row                  INTEGER NOT NULL,
   type                 TEXT NOT NULL,
   value                TEXT
 );