summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-10-25 11:46:46 +0200
committerYorhel <git@yorhel.nl>2022-10-27 13:03:03 +0200
commit750dff5700cc24b8f4c5e007319a410ba4053f3b (patch)
tree0623d109bb0d387e85cb4f01e74ac31387c3e87d /util
parent3ac1eb704f9ee56ccf882b7b5d6300a2f9f2aeb2 (diff)
Chars: add lie flag for traits
Still TODO: filtering & searching.
Diffstat (limited to 'util')
-rw-r--r--util/updates/2022-10-27-trait-lies.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/2022-10-27-trait-lies.sql b/util/updates/2022-10-27-trait-lies.sql
new file mode 100644
index 00000000..fff91ca8
--- /dev/null
+++ b/util/updates/2022-10-27-trait-lies.sql
@@ -0,0 +1,5 @@
+ALTER TABLE chars_traits ADD COLUMN lie boolean NOT NULL DEFAULT false;
+ALTER TABLE chars_traits_hist ADD COLUMN lie boolean NOT NULL DEFAULT false;
+ALTER TABLE traits_chars ADD COLUMN lie boolean NOT NULL DEFAULT false;
+\i sql/editfunc.sql
+\i sql/func.sql