26 lines
1.3 KiB
SQL
26 lines
1.3 KiB
SQL
CREATE TABLE import_sources
|
|
(
|
|
id TEXT NOT NULL PRIMARY KEY,
|
|
model TEXT DEFAULT 'import_source' NOT NULL,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
workspace_id TEXT NOT NULL,
|
|
importer TEXT NOT NULL,
|
|
origin TEXT NOT NULL,
|
|
origin_label TEXT NOT NULL,
|
|
last_imported_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
|
|
);
|
|
|
|
CREATE TABLE import_source_resources
|
|
(
|
|
model TEXT DEFAULT 'import_source_resource' NOT NULL,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
import_source_id TEXT NOT NULL,
|
|
source_key TEXT NOT NULL,
|
|
model_type TEXT NOT NULL,
|
|
model_id TEXT NOT NULL,
|
|
snapshot TEXT NOT NULL,
|
|
PRIMARY KEY (import_source_id, source_key)
|
|
);
|