diff options
Diffstat (limited to 'tests/setup.sql')
-rw-r--r-- | tests/setup.sql | 40 |
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 @@ | |||
1 | DELETE FROM settings WHERE id = 1234567890123456; | 1 | DELETE FROM settings WHERE thing_id = 1234567890123456; |
2 | DELETE FROM oauth_access_tokens WHERE id = 6543210987654321; | 2 | DELETE FROM oauth_access_tokens WHERE id = 6543210987654321; |
3 | DELETE FROM oauth_access_tokens WHERE id = 1234567890123456; | 3 | DELETE FROM oauth_access_tokens WHERE id = 1234567890123456; |
4 | DELETE FROM oauth_applications WHERE id = 1234567890123456; | 4 | DELETE FROM oauth_applications WHERE id = 1234567890123456; |
@@ -38,7 +38,6 @@ INSERT INTO users ( | |||
38 | ); | 38 | ); |
39 | 39 | ||
40 | 40 | ||
41 | |||
42 | INSERT INTO oauth_applications ( | 41 | INSERT INTO oauth_applications ( |
43 | id, | 42 | id, |
44 | name, | 43 | name, |
@@ -62,7 +61,6 @@ INSERT INTO oauth_applications ( | |||
62 | now(), | 61 | now(), |
63 | now() | 62 | now() |
64 | ); | 63 | ); |
65 | |||
66 | INSERT INTO oauth_access_tokens ( | 64 | INSERT INTO oauth_access_tokens ( |
67 | id, | 65 | id, |
68 | token, | 66 | token, |
@@ -102,4 +100,38 @@ INSERT INTO settings ( | |||
102 | 1234567890123456, | 100 | 1234567890123456, |
103 | now(), | 101 | now(), |
104 | now() | 102 | now() |
105 | ) | 103 | ); |
104 | INSERT INTO settings ( | ||
105 | id, | ||
106 | var, | ||
107 | value, | ||
108 | thing_type, | ||
109 | thing_id, | ||
110 | created_at, | ||
111 | updated_at | ||
112 | ) VALUES ( | ||
113 | 1234567890123457, | ||
114 | 'default_privacy', | ||
115 | E'--- public\n...\n', | ||
116 | 'User', | ||
117 | 1234567890123456, | ||
118 | now(), | ||
119 | now() | ||
120 | ); | ||
121 | INSERT INTO settings ( | ||
122 | id, | ||
123 | var, | ||
124 | value, | ||
125 | thing_type, | ||
126 | thing_id, | ||
127 | created_at, | ||
128 | updated_at | ||
129 | ) VALUES ( | ||
130 | 1234567890123458, | ||
131 | 'default_sensitive', | ||
132 | E'--- false\n...\n', | ||
133 | 'User', | ||
134 | 1234567890123456, | ||
135 | now(), | ||
136 | now() | ||
137 | ); | ||