diff options
Diffstat (limited to 'util/updates/update_1.19.sql')
| -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 ( |