summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-11-02 11:09:38 +0100
committerYorhel <git@yorhel.nl>2019-11-02 11:25:55 +0100
commitf4253cd0472fd077d33f536a78f6d255907b1cfc (patch)
tree5b75e44ff4ede3f3052c10219f98b72eac9134de /util/sql/schema.sql
parent2cd005791529c6501901ac2bc0a7752f88fa7481 (diff)
Add character age field + conversion
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r--util/sql/schema.sql6
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