From 64ec9e20987072692227d8817d9fd99d497fea5e Mon Sep 17 00:00:00 2001
From: Lorenz Diener <lorenzd@gmail.com>
Date: Wed, 18 Apr 2018 22:00:35 +0200
Subject: Update the tests

---
 tests/setup.sql | 40 ++++++++++++++++++++++++++++++++++++----
 1 file changed, 36 insertions(+), 4 deletions(-)

(limited to 'tests/setup.sql')

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()
+);
-- 
cgit v1.2.3