diff options
author | Yorhel <git@yorhel.nl> | 2019-11-02 11:09:38 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-11-02 11:25:55 +0100 |
commit | f4253cd0472fd077d33f536a78f6d255907b1cfc (patch) | |
tree | 5b75e44ff4ede3f3052c10219f98b72eac9134de /util/sql/schema.sql | |
parent | 2cd005791529c6501901ac2bc0a7752f88fa7481 (diff) |
Add character age field + conversion
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r-- | util/sql/schema.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index ff753619..eca69e2e 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -121,7 +121,8 @@ CREATE TABLE chars ( -- dbentry_type=c bloodt blood_type NOT NULL DEFAULT 'unknown', -- [pub] main integer, -- [pub] chars.id main_spoil smallint NOT NULL DEFAULT 0, -- [pub] - cup_size cup_size NOT NULL DEFAULT '' -- [pub] + cup_size cup_size NOT NULL DEFAULT '', -- [pub] + age smallint -- [pub] ); -- chars_hist @@ -143,7 +144,8 @@ CREATE TABLE chars_hist ( bloodt blood_type NOT NULL DEFAULT 'unknown', main integer, -- chars.id main_spoil smallint NOT NULL DEFAULT 0, - cup_size cup_size NOT NULL DEFAULT '' + cup_size cup_size NOT NULL DEFAULT '', + age smallint ); -- chars_traits |