clean up database scripts, start readmes.

1 files changed, 11 insertions, 0 deletions

diff --git a/db/sql/triggers.sql b/db/sql/triggers.sql
new file mode 100644
index 0000000..3827642
--- /dev/null
+++ b/db/sql/triggers.sql
@@ -0,0 +1,11 @@
+CREATE TRIGGER IF NOT EXISTS enforce_size_id
+BEFORE INSERT ON Preferences
+BEGIN
+    SELECT
+        CASE
+            WHEN (
+                SELECT COUNT(*) FROM Sizes WHERE id = new.size_id
+            ) = 0
+            THEN RAISE(ABORT, 'Size does not exist')
+        END;
+END;