summaryrefslogtreecommitdiff
path: root/util/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-11-02 10:43:47 +0100
committerYorhel <git@yorhel.nl>2019-11-02 10:43:47 +0100
commit2cd005791529c6501901ac2bc0a7752f88fa7481 (patch)
treeaec3c0a19e08f9cf821c8b3a65bb95d5df12e723 /util/sql
parent155f4d335a698f6cef6f0ddaf932d3302ebcc53d (diff)
Add character cup size field + conversion + filter
Diffstat (limited to 'util/sql')
-rw-r--r--util/sql/schema.sql7
1 files changed, 5 insertions, 2 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index a3c65c7b..ff753619 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -51,6 +51,7 @@ CREATE TYPE blood_type AS ENUM ('unknown', 'a', 'b', 'ab', 'o');
CREATE TYPE board_type AS ENUM ('an', 'db', 'ge', 'v', 'p', 'u');
CREATE TYPE char_role AS ENUM ('main', 'primary', 'side', 'appears');
CREATE TYPE credit_type AS ENUM ('scenario', 'chardesign', 'art', 'music', 'songs', 'director', 'staff');
+CREATE TYPE cup_size AS ENUM ('', 'AAA', 'AA', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
CREATE TYPE dbentry_type AS ENUM ('v', 'r', 'p', 'c', 's', 'd');
CREATE TYPE edit_rettype AS (itemid integer, chid integer, rev integer);
CREATE TYPE gender AS ENUM ('unknown', 'm', 'f', 'b');
@@ -119,7 +120,8 @@ CREATE TABLE chars ( -- dbentry_type=c
weight smallint, -- [pub]
bloodt blood_type NOT NULL DEFAULT 'unknown', -- [pub]
main integer, -- [pub] chars.id
- main_spoil smallint NOT NULL DEFAULT 0 -- [pub]
+ main_spoil smallint NOT NULL DEFAULT 0, -- [pub]
+ cup_size cup_size NOT NULL DEFAULT '' -- [pub]
);
-- chars_hist
@@ -140,7 +142,8 @@ CREATE TABLE chars_hist (
weight smallint,
bloodt blood_type NOT NULL DEFAULT 'unknown',
main integer, -- chars.id
- main_spoil smallint NOT NULL DEFAULT 0
+ main_spoil smallint NOT NULL DEFAULT 0,
+ cup_size cup_size NOT NULL DEFAULT ''
);
-- chars_traits