diff options
Diffstat (limited to 'util/updates/update_2.19.sql')
-rw-r--r-- | util/updates/update_2.19.sql | 2 |
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); |