diff options
| author | Yorhel <git@yorhel.nl> | 2011-02-27 09:59:03 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2011-02-27 09:59:03 +0100 |
| commit | 4582a5dce7c0793fe64806d4cba5ab9d386ea878 (patch) | |
| tree | fab8a5eab8a6fc416e43d1ca0ea5f85d114d9528 /util | |
| parent | 77f6ce0bb06e0496fbcc98656b82108d62c6aeef (diff) | |
chardb: Allow specifying the order of trait groups +'sexual' trait flag
The sexual flag isn't used yet.
Diffstat (limited to 'util')
| -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); |