1 files changed, 36 insertions, 4 deletions

diff --git a/tests/setup.sql b/tests/setup.sql
index 0ff6da0..57e8316 100644
--- a/tests/setup.sql
+++ b/tests/setup.sql
@@ -1,4 +1,4 @@
-DELETE FROM settings WHERE id = 1234567890123456;
+DELETE FROM settings WHERE thing_id = 1234567890123456;
 DELETE FROM oauth_access_tokens WHERE id = 6543210987654321;
 DELETE FROM oauth_access_tokens WHERE id = 1234567890123456;
 DELETE FROM oauth_applications WHERE id = 1234567890123456;
@@ -38,7 +38,6 @@ INSERT INTO users (
 );
 
 
-
 INSERT INTO oauth_applications (
     id,
     name,
@@ -62,7 +61,6 @@ INSERT INTO oauth_applications (
     now(),
     now()
 );
-
 INSERT INTO oauth_access_tokens (
     id,
     token,
@@ -102,4 +100,38 @@ INSERT INTO settings (
     1234567890123456,
     now(),
     now()
-)
+);
+INSERT INTO settings (
+    id, 
+    var, 
+    value, 
+    thing_type,
+    thing_id,
+    created_at,
+    updated_at
+) VALUES (
+    1234567890123457, 
+    'default_privacy', 
+    E'--- public\n...\n', 
+    'User',
+    1234567890123456,
+    now(),
+    now()
+);
+INSERT INTO settings (
+    id, 
+    var, 
+    value, 
+    thing_type,
+    thing_id,    
+    created_at, 
+    updated_at
+) VALUES (
+    1234567890123458,
+    'default_sensitive',
+    E'--- false\n...\n',
+    'User',
+    1234567890123456,
+    now(),
+    now()
+);