From a262844aca73da467dceeff3153bbebf5179ae4b Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Wed, 25 Jul 2007 15:37:31 +0200 Subject: [PATCH] Create a tag table. --- sql/pr0n.sql | 8 ++++++++ sql/upgrade-v2.50.sql | 8 ++++++++ 2 files changed, 16 insertions(+) diff --git a/sql/pr0n.sql b/sql/pr0n.sql index c65d1ca..cddf386 100644 --- a/sql/pr0n.sql +++ b/sql/pr0n.sql @@ -82,6 +82,14 @@ CREATE TABLE exif_info ( CREATE INDEX exif_info_key ON exif_info ( key ); CLUSTER exif_info_key ON exif_info; +CREATE TABLE tags ( + image integer NOT NULL REFERENCES images (id) ON DELETE CASCADE, + tag varchar NOT NULL, + + PRIMARY KEY ( image, tag ) +); +CREATE INDEX tags_tag ON tags ( tag ); + GRANT INSERT ON TABLE deleted_images TO pr0n; GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE events TO pr0n; GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE fake_files TO pr0n; diff --git a/sql/upgrade-v2.50.sql b/sql/upgrade-v2.50.sql index 51bd757..d2440ae 100644 --- a/sql/upgrade-v2.50.sql +++ b/sql/upgrade-v2.50.sql @@ -7,3 +7,11 @@ ALTER TABLE exif_info RENAME COLUMN tag TO key; CREATE INDEX exif_info_key ON exif_info ( key ); CLUSTER exif_info_key ON exif_info; +CREATE TABLE tags ( + image integer NOT NULL REFERENCES images (id) ON DELETE CASCADE, + tag varchar NOT NULL, + + PRIMARY KEY ( image, tag ) +); +CREATE INDEX tags_tag ON tags ( tag ); + -- 2.39.2