X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/67643d0386e7ad051009af639cada8a5ad60d1ea..19bc00f2f06ffa53668f39e55915b9b0df3970ba:/sql/Pg-upgrade2/csv_import_report_cache.sql diff --git a/sql/Pg-upgrade2/csv_import_report_cache.sql b/sql/Pg-upgrade2/csv_import_report_cache.sql index 440c34610..e401b8397 100644 --- a/sql/Pg-upgrade2/csv_import_report_cache.sql +++ b/sql/Pg-upgrade2/csv_import_report_cache.sql @@ -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 );