Add some fixture code.

[mailshears.git] / test / sql / davical-fixtures.sql

diff --git a/test/sql/davical-fixtures.sql b/test/sql/davical-fixtures.sql
new file mode 100644 (file)
index 0000000..775fa6b
--- /dev/null
+++ b/test/sql/davical-fixtures.sql
@@ -0,0 +1,8 @@
+/* Add a DAViCal record for one user. */
+INSERT INTO usr (user_no, username) VALUES (17, 'alice@example.com');
+
+/* Create a settings record for that user -- these should be linked
+ * via a foreign key.
+ */
+INSERT INTO usr_setting (user_no, setting_name, setting_value)
+  VALUES (17, 'dumb setting', 'its dumb value');