summaryrefslogtreecommitdiff
path: root/util/updates/update_2.19.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/update_2.19.sql')
-rw-r--r--util/updates/update_2.19.sql14
1 files changed, 13 insertions, 1 deletions
diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql
index 14c3e30e..1332d666 100644
--- a/util/updates/update_2.19.sql
+++ b/util/updates/update_2.19.sql
@@ -12,7 +12,8 @@ CREATE TABLE traits (
added timestamptz NOT NULL DEFAULT NOW(),
state smallint NOT NULL DEFAULT 0,
addedby integer NOT NULL DEFAULT 0 REFERENCES users (id),
- "group" integer
+ "group" integer,
+ c_items integer NOT NULL DEFAULT 0
);
ALTER TABLE traits ADD FOREIGN KEY ("group") REFERENCES traits (id);
@@ -24,6 +25,7 @@ CREATE TABLE traits_parents (
CREATE TRIGGER insert_notify AFTER INSERT ON traits FOR EACH STATEMENT EXECUTE PROCEDURE insert_notify();
+ALTER TABLE tags RENAME c_vns TO c_items;
-- character database -> chars
@@ -75,6 +77,14 @@ CREATE TABLE chars_vns (
PRIMARY KEY(cid, vid, rid)
);
+-- cache table
+CREATE TABLE traits_chars (
+ cid integer NOT NULL REFERENCES chars (id),
+ tid integer NOT NULL REFERENCES traits (id),
+ spoil smallint NOT NULL DEFAULT 0,
+ PRIMARY KEY(cid, tid)
+);
+
CREATE SEQUENCE charimg_seq;
@@ -144,5 +154,7 @@ UPDATE edit_char SET name = 'Saya', original = '沙耶', "desc" = 'There is more
INSERT INTO edit_char_traits VALUES (4, 0), (12, 0);
SELECT edit_char_commit();
+SELECT traits_chars_calc();
+
-- */