diff options
author | Yorhel <git@yorhel.nl> | 2011-02-04 19:26:36 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-02-04 19:26:36 +0100 |
commit | 80d22665f3f4a99f60c4b808bb5dc97a1f8f6830 (patch) | |
tree | d28444b0d592bced999e3e424e1b71ab248796c7 /util/updates | |
parent | 9b8d7c719a722007839ec501b42070c2291f9e04 (diff) |
Added category field to tags (content/ero/technical)
Not very useful at the moment, but will be used to improve several other
things.
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.18.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_2.18.sql b/util/updates/update_2.18.sql new file mode 100644 index 00000000..c4cfe84f --- /dev/null +++ b/util/updates/update_2.18.sql @@ -0,0 +1,5 @@ + +CREATE TYPE tag_category AS ENUM('cont', 'ero', 'tech'); + +ALTER TABLE tags ADD COLUMN cat tag_category NOT NULL DEFAULT 'cont'; + |