diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 2 | ||||
-rw-r--r-- | util/updates/update_2.19.sql | 26 |
2 files changed, 27 insertions, 1 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index dd2b2ffd..452983e0 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -200,7 +200,7 @@ CREATE TABLE tags ( -- tags_aliases CREATE TABLE tags_aliases ( alias varchar(250) NOT NULL PRIMARY KEY, - tag integer NOT NULL, + tag integer NOT NULL ); -- tags_parents diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql new file mode 100644 index 00000000..9819f685 --- /dev/null +++ b/util/updates/update_2.19.sql @@ -0,0 +1,26 @@ +-- These changes have not been synced with the /util/sql/ files yet. + + +-- character database -> traits + +CREATE TABLE traits ( + id SERIAL PRIMARY KEY, + name varchar(250) NOT NULL UNIQUE, + description text NOT NULL DEFAULT '', + meta boolean NOT NULL DEFAULT false, + added timestamptz NOT NULL DEFAULT NOW(), + state smallint NOT NULL DEFAULT 0, + addedby integer NOT NULL DEFAULT 0 REFERENCES users (id) +); + +CREATE TABLE traits_aliases ( + alias varchar(250) NOT NULL PRIMARY KEY, + trait integer NOT NULL REFERENCES traits (id) +); + +CREATE TABLE traits_parents ( + trait integer NOT NULL REFERENCES traits (id), + parent integer NOT NULL REFERENCES traits (id), + PRIMARY KEY(trait, parent) +); + |