1 -- @tag: csv_import_report_cache
2 -- @description: Csv Import Cache
3 -- @depends: csv_import_profiles_2
6 CREATE TABLE csv_import_reports (
8 session_id TEXT NOT NULL,
9 profile_id INTEGER NOT NULL REFERENCES csv_import_profiles(id),
12 numrows INTEGER NOT NULL
15 CREATE TABLE csv_import_report_rows (
16 id SERIAL PRIMARY KEY,
17 csv_import_report_id INTEGER NOT NULL REFERENCES csv_import_reports(id),
23 CREATE TABLE csv_import_report_status (
24 id SERIAL PRIMARY KEY,
25 csv_import_report_id INTEGER NOT NULL REFERENCES csv_import_reports(id),
31 ALTER TABLE csv_import_profiles DROP constraint "csv_import_profiles_name_key";
33 CREATE INDEX "csv_import_report_rows_index_row" ON csv_import_report_rows (row);