chardb: Added notes file and started implementing the traits

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)
+);
+