diff options
author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-07-08 12:33:05 +0000 |
---|---|---|
committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-07-08 12:33:05 +0000 |
commit | b7f866432cc3a44e9c62d4ad081f62e3ca791d1c (patch) | |
tree | 887ffe53a21019448be0dd197c3c9d01d4194396 /util | |
parent | 0d177e5bfb3ffd531f8904d99758cbc171261cdb (diff) |
Added primary key to threads_tags, added documentation, and mods can now hide DB entries
git-svn-id: svn://vndb.org/vndb@60 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/update_1.19.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/util/updates/update_1.19.sql b/util/updates/update_1.19.sql index 225cddfb..a28b525a 100644 --- a/util/updates/update_1.19.sql +++ b/util/updates/update_1.19.sql @@ -12,7 +12,8 @@ CREATE TABLE threads ( CREATE TABLE threads_tags ( tid integer NOT NULL DEFAULT 0 REFERENCES threads (id) DEFERRABLE INITIALLY DEFERRED, type char(2) NOT NULL DEFAULT 0, - iid integer NOT NULL DEFAULT 0 -- references to (vn|releases|producers|users).id + iid integer NOT NULL DEFAULT 0, -- references to (vn|releases|producers|users).id + PRIMARY KEY(tid, type, iid) ) WITHOUT OIDS; CREATE TABLE threads_posts ( |