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),
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_row_status (
23 id SERIAL PRIMARY KEY,
24 csv_import_report_row_id INTEGER NOT NULL REFERENCES csv_import_report_rows(id),
29 ALTER TABLE csv_import_profiles DROP constraint "csv_import_profiles_name_key";