1 -- @tag: csv_import_report_cache
2 -- @description: Csv Import Cache
3 -- @depends: csv_import_profiles_2
5 CREATE TABLE csv_import_reports (
7 session_id TEXT NOT NULL,
8 profile_id INTEGER NOT NULL REFERENCES csv_import_profiles(id),
11 numrows INTEGER NOT NULL
14 CREATE TABLE csv_import_report_rows (
15 id SERIAL PRIMARY KEY,
16 csv_import_report_id INTEGER NOT NULL REFERENCES csv_import_reports(id),
22 CREATE TABLE csv_import_report_status (
23 id SERIAL PRIMARY KEY,
24 csv_import_report_id INTEGER NOT NULL REFERENCES csv_import_reports(id),
30 ALTER TABLE csv_import_profiles DROP constraint "csv_import_profiles_name_key";
32 CREATE INDEX "csv_import_report_rows_index_row" ON csv_import_report_rows (row);