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.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql
index bc1b5afe..76379e96 100644
--- a/util/updates/update_2.19.sql
+++ b/util/updates/update_2.19.sql
@@ -13,6 +13,8 @@ CREATE TABLE traits (
state smallint NOT NULL DEFAULT 0,
addedby integer NOT NULL DEFAULT 0 REFERENCES users (id),
"group" integer,
+ "order" smallint NOT NULL DEFAULT 0,
+ sexual boolean NOT NULL DEFAULT false,
c_items integer NOT NULL DEFAULT 0
);
ALTER TABLE traits ADD FOREIGN KEY ("group") REFERENCES traits (id);