summaryrefslogtreecommitdiff
path: root/util/updates/update_2.14.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-11-28 10:03:16 +0100
committerYorhel <git@yorhel.nl>2010-11-28 10:03:16 +0100
commitd82f42629c802d968be247832c2e7cbf17eb16c6 (patch)
treedda59c514f81fbc151b9d53480a85090537b700d /util/updates/update_2.14.sql
parent80106c9930e39047fb24f0486412085ca99efef9 (diff)
VN Filter Selector: Added "original language" filter
The original language is the language of the first release of the VN, and is cached in vn.c_olang. (Geez, the vn table has more caching columns than actual information >.>)
Diffstat (limited to 'util/updates/update_2.14.sql')
-rw-r--r--util/updates/update_2.14.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/util/updates/update_2.14.sql b/util/updates/update_2.14.sql
index 5c8cfe76..2233e0a8 100644
--- a/util/updates/update_2.14.sql
+++ b/util/updates/update_2.14.sql
@@ -1,6 +1,13 @@
+-- add vn.c_olang
+
+ALTER TABLE vn ADD COLUMN c_olang language[] NOT NULL DEFAULT '{}';
+
+
+-- reload functions
\i util/sql/func.sql
+
-- redefine the triggers to use the new conditional triggers in PostgreSQL 9.0
DROP TRIGGER hidlock_update ON vn;