1 -- @tag: file_full_texts
2 -- @description: Tabelle f. Volltext-Suche anlegen
3 -- @depends: release_3_6_0
5 CREATE TABLE IF NOT EXISTS file_full_texts (
7 file_id INTEGER NOT NULL REFERENCES files(id) ON DELETE CASCADE,
8 full_text TEXT NOT NULL,
9 itime TIMESTAMP NOT NULL DEFAULT now(),
15 CREATE TRIGGER mtime_file_full_texts BEFORE UPDATE ON file_full_texts FOR EACH ROW EXECUTE PROCEDURE set_mtime();