X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fcsv_import_report_cache.sql;h=34fbdf64916a842d3c21d9cd470ee6b6f5a43a6a;hb=a8da95826e357e75f78ccfc6b8f2c2523c52723f;hp=e401b8397afaa607adb7dc524afb3d85487ce678;hpb=a5a42ed1bf23da4a35b675ce00781fea99df2acd;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/csv_import_report_cache.sql b/sql/Pg-upgrade2/csv_import_report_cache.sql
index e401b8397..34fbdf649 100644
--- a/sql/Pg-upgrade2/csv_import_report_cache.sql
+++ b/sql/Pg-upgrade2/csv_import_report_cache.sql
@@ -8,7 +8,8 @@ CREATE TABLE csv_import_reports (
   session_id           TEXT NOT NULL,
   profile_id           INTEGER NOT NULL REFERENCES csv_import_profiles(id),
   type                 TEXT NOT NULL,
-  file                 TEXT NOT NULL
+  file                 TEXT NOT NULL,
+  numrows              INTEGER NOT NULL
 );
 
 CREATE TABLE csv_import_report_rows (
@@ -28,3 +29,5 @@ CREATE TABLE csv_import_report_status (
 );
 
 ALTER TABLE csv_import_profiles DROP constraint "csv_import_profiles_name_key";
+
+CREATE INDEX "csv_import_report_rows_index_row" ON csv_import_report_rows (row);