summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/sql/schema.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 9d71d7b8..b641c556 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -545,9 +545,12 @@ CREATE TABLE traits (
);
-- traits_chars
+-- This table is a cache for the data in chars_traits and includes child traits
+-- into parent traits. In order to improve performance, there are no foreign
+-- key constraints on this table.
CREATE TABLE traits_chars (
- cid integer NOT NULL,
- tid integer NOT NULL,
+ cid integer NOT NULL, -- chars (id)
+ tid integer NOT NULL, -- traits (id)
spoil smallint NOT NULL DEFAULT 0,
PRIMARY KEY(cid, tid)
);