-- @tag: csv_import_report_cache
-- @description: Csv Import Cache
-- @depends: csv_import_profiles_2
--- @encoding: utf-8
CREATE TABLE csv_import_reports (
id SERIAL PRIMARY KEY,
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 (
);
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);