|
-- @tag: file_version
|
|
-- @description: Tabelle für Dokumentenversion
|
|
-- @depends: release_3_8_0
|
|
|
|
CREATE TABLE IF NOT EXISTS file_versions (
|
|
guid TEXT,
|
|
file_id INTEGER NOT NULL REFERENCES files(id) ON DELETE CASCADE,
|
|
version INTEGER NOT NULL,
|
|
file_location TEXT NOT NULL,
|
|
doc_path TEXT NOT NULL,
|
|
backend TEXT NOT NULL,
|
|
itime TIMESTAMP NOT NULL DEFAULT now(),
|
|
mtime TIMESTAMP,
|
|
PRIMARY KEY (file_id, version)
|
|
);
|
|
|
|
CREATE TRIGGER mtime_file_version BEFORE UPDATE ON file_versions FOR EACH ROW EXECUTE PROCEDURE set_mtime();
|