openstatus.dev
Openstatus
www.openstatus.dev
1DROP TABLE IF EXISTS "__drizzle_migrations";
2CREATE TABLE "__drizzle_migrations" (
3 id SERIAL PRIMARY KEY,
4 hash text NOT NULL,
5 created_at numeric
6 );
7
8DROP TABLE IF EXISTS "page";
9CREATE TABLE `page` (
10 `id` integer PRIMARY KEY NOT NULL,
11 `workspace_id` integer NOT NULL,
12 `title` text NOT NULL,
13 `description` text NOT NULL,
14 `icon` text(256),
15 `slug` text(256) NOT NULL,
16 `custom_domain` text(256) NOT NULL,
17 `published` integer DEFAULT false,
18 "created_at" integer DEFAULT (strftime('%s', 'now')), `updated_at` integer, `password` text(256), `password_protected` integer DEFAULT false, `show_monitor_values` integer DEFAULT true, `force_theme` text DEFAULT 'system' NOT NULL, `legacy_page` integer DEFAULT true NOT NULL, `configuration` text, `homepage_url` text(256), `contact_url` text(256),
19 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE cascade
20);
21
22DROP TABLE IF EXISTS "monitors_to_pages";
23CREATE TABLE `monitors_to_pages` (
24 `monitor_id` integer NOT NULL,
25 `page_id` integer NOT NULL, `created_at` integer DEFAULT (strftime('%s', 'now')), `order` integer DEFAULT 0,
26 PRIMARY KEY(`monitor_id`, `page_id`),
27 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE cascade,
28 FOREIGN KEY (`page_id`) REFERENCES `page`(`id`) ON UPDATE no action ON DELETE cascade
29);
30
31DROP TABLE IF EXISTS "user";
32CREATE TABLE `user` (
33 `id` integer PRIMARY KEY NOT NULL,
34 `tenant_id` text(256),
35 "created_at" integer DEFAULT (strftime('%s', 'now'))
36, `first_name` text DEFAULT '', `last_name` text DEFAULT '', `email` text DEFAULT '', `photo_url` text DEFAULT '', `updated_at` integer, `name` text, `emailVerified` integer);
37
38DROP TABLE IF EXISTS "users_to_workspaces";
39CREATE TABLE `users_to_workspaces` (
40 `user_id` integer NOT NULL,
41 `workspace_id` integer NOT NULL, `role` text DEFAULT 'owner' NOT NULL, `created_at` integer DEFAULT (strftime('%s', 'now')),
42 PRIMARY KEY(`user_id`, `workspace_id`),
43 FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action,
44 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action
45);
46
47DROP TABLE IF EXISTS "workspace";
48CREATE TABLE `workspace` (
49 `id` integer PRIMARY KEY NOT NULL,
50 `slug` text NOT NULL,
51 `stripe_id` text(256),
52 `name` text,
53 "created_at" integer DEFAULT (strftime('%s', 'now'))
54, `updated_at` integer, `subscription_id` text, `plan` text(3), `ends_at` integer, `paid_until` integer, `dsn` text, `limits` text DEFAULT '{}' NOT NULL);
55
56DROP TABLE IF EXISTS "status_report_update";
57CREATE TABLE "status_report_update" (
58 `id` integer PRIMARY KEY NOT NULL,
59 "status" text NOT NULL,
60 `date` integer NOT NULL,
61 `message` text NOT NULL,
62 `created_at` integer DEFAULT (strftime('%s', 'now')),
63 `updated_at` integer DEFAULT (strftime('%s', 'now')),
64 "status_report_id" integer NOT NULL,
65 FOREIGN KEY ("status_report_id") REFERENCES "status_report"(`id`) ON UPDATE no action ON DELETE cascade
66);
67
68DROP TABLE IF EXISTS "status_report_to_monitors";
69CREATE TABLE "status_report_to_monitors" (
70 `monitor_id` integer NOT NULL,
71 "status_report_id" integer NOT NULL, `created_at` integer DEFAULT (strftime('%s', 'now')),
72 PRIMARY KEY("status_report_id", `monitor_id`),
73 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE cascade,
74 FOREIGN KEY ("status_report_id") REFERENCES "status_report"(`id`) ON UPDATE no action ON DELETE cascade
75);
76
77DROP TABLE IF EXISTS "monitor";
78CREATE TABLE "monitor" (
79 `id` integer PRIMARY KEY NOT NULL,
80 `job_type` text(3) DEFAULT 'other' NOT NULL,
81 `periodicity` text(6) DEFAULT 'other' NOT NULL,
82 `active` integer DEFAULT false,
83 `url` text(512) NOT NULL,
84 `name` text(256) DEFAULT '' NOT NULL,
85 `description` text DEFAULT '' NOT NULL,
86 `workspace_id` integer,
87 `headers` text DEFAULT '',
88 `body` text DEFAULT '',
89 `method` text(5) DEFAULT 'GET',
90 `created_at` integer DEFAULT (strftime('%s', 'now')), `regions` text DEFAULT '' NOT NULL, `updated_at` integer, `status` text(2) DEFAULT 'active' NOT NULL, `assertions` text, `deleted_at` integer, `public` integer DEFAULT false, `timeout` integer DEFAULT 45000 NOT NULL, `degraded_after` integer, `otel_endpoint` text, `otel_headers` text, `retry` integer DEFAULT 3, `follow_redirects` integer DEFAULT true,
91 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action
92);
93
94DROP TABLE IF EXISTS "integration";
95CREATE TABLE `integration` (
96 `id` integer PRIMARY KEY NOT NULL,
97 `name` text(256) NOT NULL,
98 `workspace_id` integer,
99 `credential` text,
100 `external_id` text NOT NULL,
101 `created_at` integer DEFAULT (strftime('%s', 'now')),
102 `updated_at` integer DEFAULT (strftime('%s', 'now')),
103 `data` text NOT NULL,
104 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action
105);
106
107DROP TABLE IF EXISTS "notification";
108CREATE TABLE `notification` (
109 `id` integer PRIMARY KEY NOT NULL,
110 `name` text NOT NULL,
111 `provider` text NOT NULL,
112 `data` text DEFAULT '{}',
113 `workspace_id` integer,
114 `created_at` integer DEFAULT (strftime('%s', 'now')),
115 `updated_at` integer DEFAULT (strftime('%s', 'now')),
116 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action
117);
118
119DROP TABLE IF EXISTS "notifications_to_monitors";
120CREATE TABLE `notifications_to_monitors` (
121 `monitor_id` integer NOT NULL,
122 `notification_id` integer NOT NULL, `created_at` integer DEFAULT (strftime('%s', 'now')),
123 PRIMARY KEY(`monitor_id`, `notification_id`),
124 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE cascade,
125 FOREIGN KEY (`notification_id`) REFERENCES `notification`(`id`) ON UPDATE no action ON DELETE cascade
126);
127
128DROP TABLE IF EXISTS "status_reports_to_pages";
129CREATE TABLE "status_reports_to_pages" (
130 `page_id` integer NOT NULL,
131 "status_report_id" integer NOT NULL, `created_at` integer DEFAULT (strftime('%s', 'now')),
132 PRIMARY KEY("status_report_id", `page_id`),
133 FOREIGN KEY (`page_id`) REFERENCES `page`(`id`) ON UPDATE no action ON DELETE cascade,
134 FOREIGN KEY ("status_report_id") REFERENCES "status_report"(`id`) ON UPDATE no action ON DELETE cascade
135);
136
137DROP TABLE IF EXISTS "monitor_status";
138CREATE TABLE `monitor_status` (
139 `monitor_id` integer NOT NULL,
140 `region` text DEFAULT '' NOT NULL,
141 `status` text DEFAULT 'active' NOT NULL,
142 `created_at` integer DEFAULT (strftime('%s', 'now')),
143 `updated_at` integer DEFAULT (strftime('%s', 'now')),
144 PRIMARY KEY(`monitor_id`, `region`),
145 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE cascade
146);
147
148DROP TABLE IF EXISTS "invitation";
149CREATE TABLE `invitation` (
150 `id` integer PRIMARY KEY NOT NULL,
151 `email` text NOT NULL,
152 `role` text DEFAULT 'member' NOT NULL,
153 `workspace_id` integer NOT NULL,
154 `token` text NOT NULL,
155 `expires_at` integer NOT NULL,
156 `created_at` integer DEFAULT (strftime('%s', 'now')),
157 `accepted_at` integer
158);
159
160DROP TABLE IF EXISTS "incident";
161CREATE TABLE "incident" (
162 `id` integer PRIMARY KEY NOT NULL,
163 `title` text DEFAULT '' NOT NULL,
164 `summary` text DEFAULT '' NOT NULL,
165 `status` text DEFAULT 'triage' NOT NULL,
166 `monitor_id` integer,
167 `workspace_id` integer,
168 `started_at` integer DEFAULT (strftime('%s', 'now')) NOT NULL,
169 `acknowledged_at` integer,
170 `acknowledged_by` integer,
171 `resolved_at` integer,
172 `resolved_by` integer,
173 `created_at` integer DEFAULT (strftime('%s', 'now')),
174 `updated_at` integer DEFAULT (strftime('%s', 'now')), `auto_resolved` integer DEFAULT false, `incident_screenshot_url` text, `recovery_screenshot_url` text,
175 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE set default,
176 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action,
177 FOREIGN KEY (`acknowledged_by`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action,
178 FOREIGN KEY (`resolved_by`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action
179);
180
181DROP TABLE IF EXISTS "monitor_tag";
182CREATE TABLE `monitor_tag` (
183 `id` integer PRIMARY KEY NOT NULL,
184 `workspace_id` integer NOT NULL,
185 `name` text NOT NULL,
186 `color` text NOT NULL,
187 `created_at` integer DEFAULT (strftime('%s', 'now')),
188 `updated_at` integer DEFAULT (strftime('%s', 'now')),
189 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE cascade
190);
191
192DROP TABLE IF EXISTS "monitor_tag_to_monitor";
193CREATE TABLE `monitor_tag_to_monitor` (
194 `monitor_id` integer NOT NULL,
195 `monitor_tag_id` integer NOT NULL,
196 `created_at` integer DEFAULT (strftime('%s', 'now')),
197 PRIMARY KEY(`monitor_id`, `monitor_tag_id`),
198 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE cascade,
199 FOREIGN KEY (`monitor_tag_id`) REFERENCES `monitor_tag`(`id`) ON UPDATE no action ON DELETE cascade
200);
201
202DROP TABLE IF EXISTS "account";
203CREATE TABLE `account` (
204 `user_id` integer NOT NULL,
205 `type` text NOT NULL,
206 `provider` text NOT NULL,
207 `provider_account_id` text NOT NULL,
208 `refresh_token` text,
209 `access_token` text,
210 `expires_at` integer,
211 `token_type` text,
212 `scope` text,
213 `id_token` text,
214 `session_state` text,
215 PRIMARY KEY(`provider`, `provider_account_id`),
216 FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
217);
218
219DROP TABLE IF EXISTS "session";
220CREATE TABLE `session` (
221 `session_token` text PRIMARY KEY NOT NULL,
222 `user_id` integer NOT NULL,
223 `expires` integer NOT NULL,
224 FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
225);
226
227DROP TABLE IF EXISTS "verification_token";
228CREATE TABLE `verification_token` (
229 `identifier` text NOT NULL,
230 `token` text NOT NULL,
231 `expires` integer NOT NULL,
232 PRIMARY KEY(`identifier`, `token`)
233);
234
235DROP TABLE IF EXISTS "application";
236CREATE TABLE `application` (
237 `id` integer PRIMARY KEY NOT NULL,
238 `name` text,
239 `dsn` text,
240 `workspace_id` integer,
241 `created_at` integer DEFAULT (strftime('%s', 'now')),
242 `updated_at` integer DEFAULT (strftime('%s', 'now')),
243 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action
244);
245
246DROP TABLE IF EXISTS "maintenance_to_monitor";
247CREATE TABLE `maintenance_to_monitor` (
248 `monitor_id` integer NOT NULL,
249 `maintenance_id` integer NOT NULL,
250 `created_at` integer DEFAULT (strftime('%s', 'now')),
251 PRIMARY KEY(`maintenance_id`, `monitor_id`),
252 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE cascade,
253 FOREIGN KEY (`maintenance_id`) REFERENCES `maintenance`(`id`) ON UPDATE no action ON DELETE cascade
254);
255
256DROP TABLE IF EXISTS "check";
257CREATE TABLE `check` (
258 `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
259 `regions` text DEFAULT '' NOT NULL,
260 `url` text(4096) NOT NULL,
261 `headers` text DEFAULT '',
262 `body` text DEFAULT '',
263 `method` text DEFAULT 'GET',
264 `count_requests` integer DEFAULT 1,
265 `workspace_id` integer,
266 `created_at` integer DEFAULT (strftime('%s', 'now')),
267 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action
268);
269
270
271
272DROP TABLE IF EXISTS "monitor_run";
273CREATE TABLE `monitor_run` (
274 `id` integer PRIMARY KEY NOT NULL,
275 `workspace_id` integer,
276 `monitor_id` integer,
277 `runned_at` integer,
278 `created_at` integer DEFAULT (strftime('%s', 'now')),
279 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action,
280 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE no action
281);
282
283DROP TABLE IF EXISTS "page_subscriber";
284CREATE TABLE "page_subscriber" (
285 `id` integer PRIMARY KEY NOT NULL,
286 `email` text NOT NULL,
287 `page_id` integer NOT NULL,
288 `token` text,
289 `accepted_at` integer,
290 `expires_at` integer,
291 `created_at` integer DEFAULT (strftime('%s', 'now')),
292 `updated_at` integer DEFAULT (strftime('%s', 'now')),
293 FOREIGN KEY (`page_id`) REFERENCES `page`(`id`) ON UPDATE no action ON DELETE cascade
294);
295
296DROP TABLE IF EXISTS "status_report";
297CREATE TABLE "status_report" (
298 `id` integer PRIMARY KEY NOT NULL,
299 `status` text NOT NULL,
300 `title` text(256) NOT NULL,
301 `workspace_id` integer,
302 `page_id` integer,
303 `created_at` integer DEFAULT (strftime('%s', 'now')),
304 `updated_at` integer DEFAULT (strftime('%s', 'now')),
305 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action,
306 FOREIGN KEY (`page_id`) REFERENCES `page`(`id`) ON UPDATE no action ON DELETE cascade
307);
308
309DROP TABLE IF EXISTS "notification_trigger";
310CREATE TABLE "notification_trigger" (
311 `id` integer PRIMARY KEY NOT NULL,
312 `monitor_id` integer,
313 `notification_id` integer,
314 `cron_timestamp` integer NOT NULL,
315 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE cascade,
316 FOREIGN KEY (`notification_id`) REFERENCES `notification`(`id`) ON UPDATE no action ON DELETE cascade
317);
318
319DROP TABLE IF EXISTS "maintenance";
320CREATE TABLE "maintenance" (
321 `id` integer PRIMARY KEY NOT NULL,
322 `title` text(256) NOT NULL,
323 `message` text NOT NULL,
324 `from` integer NOT NULL,
325 `to` integer NOT NULL,
326 `workspace_id` integer,
327 `page_id` integer,
328 `created_at` integer DEFAULT (strftime('%s', 'now')),
329 `updated_at` integer DEFAULT (strftime('%s', 'now')),
330 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action,
331 FOREIGN KEY (`page_id`) REFERENCES `page`(`id`) ON UPDATE no action ON DELETE cascade
332);
333
334DROP TABLE IF EXISTS "private_location";
335CREATE TABLE `private_location` (
336 `id` integer PRIMARY KEY NOT NULL,
337 `name` text NOT NULL,
338 `token` text NOT NULL,
339 `last_seen_at` integer,
340 `workspace_id` integer,
341 `created_at` integer DEFAULT (strftime('%s', 'now')),
342 `updated_at` integer DEFAULT (strftime('%s', 'now')),
343 FOREIGN KEY (`workspace_id`) REFERENCES `workspace`(`id`) ON UPDATE no action ON DELETE no action
344);
345
346DROP TABLE IF EXISTS "private_location_to_monitor";
347CREATE TABLE `private_location_to_monitor` (
348 `private_location_id` integer,
349 `monitor_id` integer,
350 `created_at` integer DEFAULT (strftime('%s', 'now')),
351 `deleted_at` integer,
352 FOREIGN KEY (`private_location_id`) REFERENCES `private_location`(`id`) ON UPDATE no action ON DELETE no action,
353 FOREIGN KEY (`monitor_id`) REFERENCES `monitor`(`id`) ON UPDATE no action ON DELETE no action
354);
355
356
357INSERT INTO "__drizzle_migrations" ("id", "hash", "created_at") VALUES
358(NULL, 'ea497587bb639bbeae27f3f644634b7429f37df241c999e22f3acbf3cce74ec9', '1690309905039'),
359(NULL, '680e79fc5537135bcfa4da88cc0c06a7a9eaf810ab87f8ae06ef67f7b4802fad', '1690892003254'),
360(NULL, 'b8ae7d5887e4cd8416a443f193753dabc6bc1ee76a6cbcfd4b338fbc6d3d10e7', '1691573899721'),
361(NULL, '790cf15e409b0c02f0e164824289aaacacb7aee21f5e84ab4f5a48df4b46e528', '1691614487733'),
362(NULL, 'ac5db9b31935382412791565e1c11ce1c99e69bd6f826da9ff08fb4ea64acc67', '1691850907670'),
363(NULL, '4cc5cc57b2e087276e6283cbd639e2ccd27c800eec6def5bb3ff7ea3ee3d9ba9', '1691930414569'),
364(NULL, 'cc99f49622240771a187a79a7c5646ed7f1e6e86b6eefcc04e9a6be78e57a5b0', '1692646649111'),
365(NULL, '49e497500b2fdb01624090863808ab15db1e50d4bc393c1e6e820960cb070d60', '1694362217174'),
366(NULL, 'a76eb5c9a12c6828bdef95e6ca65483055e7dabdf94f0b95fdae437c811b6b55', '1695756345957'),
367(NULL, '223292dcce0a81148dfbf7338ed4fe5878503d6bf785e1a13042b7c7b7b5bf24', '1697285841283'),
368(NULL, '5cc395568f9f61ebf4b57f69fd6397da2661062db813a85c5433d56841cecc9c', '1700586221141'),
369(NULL, '4ceefb80e855b8fde6c430758d9b557cef09c42afca4575c8fe4236628112d33', '1701100570578'),
370(NULL, '4c8d34ebf56874f41a1b22cb93db50e022233ff53f763eb73a73d2e01223fa39', '1701713135829'),
371(NULL, '4f47a6efc84f60e41437134c6eec5b2a3be68aae2a0525f2109b61f7473bb5ea', '1702144660818'),
372(NULL, '6f1b9eac8a3c7cf72703171402a9f42ea7523c091e393b3972fd231ab6eac6f9', '1702227904130'),
373(NULL, '4ae3b4c679065c4ca450126e14a73dbb3d21d71b7b1de2be182c32500b5c16ea', '1705856545397'),
374(NULL, '04e2ca02dbf77bce1755dc28e624d1620d662bec94373cea08983f4801fe778d', '1706111184826'),
375(NULL, 'd3c0f8670dd8e3666b3e0bd3ef1d75aec6b593c11d35e5a75bf58abe6208c642', '1707411900987'),
376(NULL, 'a028a05328ef4480fb5d79caed96da17b68793f7c9af037dbe8bb77ce42f5e36', '1707770189561'),
377(NULL, '826d9207a73609ff0f15acb2109fed80a253beb826836a93e122157584f9ca35', '1707899175705'),
378(NULL, '0055fd4b62b8b1c7029ed978cdd2f946084acae39966cb8cf85c26923a87d1cc', '1707905605592'),
379(NULL, 'af0035a9de14837b62dddba9e40bb85bf249a0c75683867be2a2d6f70f28da6d', '1710677383007'),
380(NULL, '498de5adf9c0ea5ed4c3d57b6a0905b709a58550e79c157909f13e1269896c5a', '1711307113089'),
381(NULL, 'ce825562d32c32c28da76e2d06b5e76f4c1603d178ce82ff97e1436819f3273c', '1712311348272'),
382(NULL, '45fc9d668e1a0d69701267444ca79da8e392180635761f24e41d9a7ac30a6d8c', '1712354121499'),
383(NULL, 'e9a11163fbaa7bdb2e2350265cc3e260bdb24ae1eb42d975fbf03cba7b3c8ce7', '1713095971713'),
384(NULL, '62f1cd998d6258df5c2a89222f5b71082d575b474f6d86b75fb4bf3aefe1d063', '1713384976187'),
385(NULL, '4c0d7cd418b66257e0a49454c54e8e65c388c5a246b3f5a51df0618da1faa67d', '1714586658374'),
386(NULL, 'd785a89fd7aa7bad6dbae4db4a3daaaa26c5f14374ed045cfd22420453cc4cea', '1715173356076'),
387(NULL, '9216b9d717de25f7b615f625659b7acfbbb09adacd3b121fa4f05ec0796fbd3c', '1716215342026'),
388(NULL, 'a9ced3ac1a3f9e8de9d8240ccdeed9d9e9c80b1bb6caefea59a7dbf7cf411fa7', '1716364430118'),
389(NULL, '9d0ae1d1e4bc742555e5ae5d990b62d23bb3dcefd7f62079df0bfa908f74133b', '1717837961923'),
390(NULL, '698cdffe2cad7d5b65190d09cb8f2b2ba906b1218fedb1a727fb72049090dfb6', '1718027484219'),
391(NULL, '6255470457dc29e4e1f7b8aa84f349a68b04ba3d51b9380006ddac53d5ce90a2', '1719740057514'),
392(NULL, 'bbf2f3122e76c5cbd3b76bc36e97d8f8efdddfab25c98c16f8024154e9bb2609', '1720727898360'),
393(NULL, '812b9def5df2ffe21b91680764590eda65e5ac4674500966d921d9e8627ca2f0', '1721159796428'),
394(NULL, '56181582f13b5eb66f2598a28fc7800ec6a0b9dd31d74c99cea1299ea7321917', '1723459608109'),
395(NULL, '82e57027c88612343af361f30edb148f2fca91919d6fa44048e992462d71163d', '1729533101998'),
396(NULL, '215e2ab2354eaa50923566a10a99e79f8d8514d7e3d4ca5c5720a9f5d16714ee', '1729579461221'),
397(NULL, 'fca63d63ad18ce6864418f1597b7bb0013ab2a3e0b4c681326ee4b257de2eb66', '1739193014150'),
398(NULL, '42d3cbf03d76541be2bdd9036e2f97864aa2807fe625f3b4c2b4f6440db60bd4', '1740684132626'),
399(NULL, '1a8b01776fbc88eaad155e2d0d2c69fc41d970411193ddd97806d70e1c66248b', '1741936835660'),
400(NULL, '427ca6a7f11dce1f4c0a20344d32af5f3f146a128adce1e87c7f76c80ab080fd', '1747410497521'),
401(NULL, '150ecc57f8a96341713848b1eec1293e713289b8b87854067d543fce3ff03849', '1747908803707'),
402(NULL, '8980cf55bf7b9b7f9a2cb00e5f21be8454260dd2826644b7683aaad65ff40df6', '1753730490635'),
403(NULL, 'bd5e4767fcfcd79179bb9ac9576b58a0c51c0a3af65fc0140e53f57c40e56a9c', '1756185045968'),
404(NULL, 'c7180363acc6879b749b2e9c34d3b9ac012f13aed0c62bf7ed2104e936f72085', '1757580216081'),
405(NULL, '0b90478b428afe479c6da99669ba33dd78ca2b8b5039ca2305bd9771213f4089', '1757840904190'),
406(NULL, 'b2c7b149f424a30adbf9dbe4c1db363e85d5dfe9aca3845969b14238c1117178', '1759865914553');
407
408INSERT INTO "page" ("id", "workspace_id", "title", "description", "icon", "slug", "custom_domain", "published", "created_at", "updated_at", "password", "password_protected", "show_monitor_values", "force_theme", "legacy_page", "configuration", "homepage_url", "contact_url") VALUES
409('1', '1', 'Test Page', 'hello', 'https://www.openstatus.dev/favicon.ico', 'status', '', '1', '1760358329', '1760358329', NULL, '0', '1', 'system', '1', NULL, NULL, NULL);
410
411INSERT INTO "monitors_to_pages" ("monitor_id", "page_id", "created_at", "order") VALUES
412('1', '1', '1760358329', '0');
413
414INSERT INTO "user" ("id", "tenant_id", "created_at", "first_name", "last_name", "email", "photo_url", "updated_at", "name", "emailVerified") VALUES
415('1', '1', '1760358329', 'Speed', 'Matters', 'ping@openstatus.dev', '', '1760358329', NULL, NULL);
416
417INSERT INTO "users_to_workspaces" ("user_id", "workspace_id", "role", "created_at") VALUES
418('1', '1', 'member', '1760358329');
419
420INSERT INTO "workspace" ("id", "slug", "stripe_id", "name", "created_at", "updated_at", "subscription_id", "plan", "ends_at", "paid_until", "dsn", "limits") VALUES
421('1', 'love-openstatus', 'stripeId1', 'test', '1760358329', '1760358329', 'subscriptionId', 'team', NULL, NULL, NULL, '{"monitors":50,"synthetic-checks":150000,"periodicity":["30s","1m","5m","10m","30m","1h"],"multi-region":true,"max-regions":35,"data-retention":"24 months","status-pages":20,"maintenance":true,"status-subscribers":true,"custom-domain":true,"password-protection":true,"white-label":true,"notifications":true,"sms":true,"pagerduty":true,"notification-channels":50,"members":"Unlimited","audit-log":true,"regions":["ams","arn","atl","bog","bom","bos","cdg","den","dfw","ewr","eze","fra","gdl","gig","gru","hkg","iad","jnb","lax","lhr","mad","mia","nrt","ord","otp","phx","qro","scl","sea","sin","sjc","syd","waw","yul","yyz"]}'),
422('2', 'test2', 'stripeId2', 'test2', '1760358329', '1760358329', 'subscriptionId2', 'free', NULL, NULL, NULL, '{}'),
423('3', 'test3', 'stripeId3', 'test3', '1760358329', '1760358329', 'subscriptionId3', 'team', NULL, NULL, NULL, '{}');
424
425INSERT INTO "status_report_update" ("id", "status", "date", "message", "created_at", "updated_at", "status_report_id") VALUES
426('1', 'investigating', '1760358329', 'Message', '1760358329', '1760358329', '1'),
427('2', 'investigating', '1760358329', 'Message', '1760358329', '1760358329', '2'),
428('3', 'monitoring', '1760358329', 'test', '1760358329', '1760358329', '1');
429
430INSERT INTO "status_report_to_monitors" ("monitor_id", "status_report_id", "created_at") VALUES
431('1', '2', '1760358329'),
432('2', '2', '1760358329');
433
434INSERT INTO "monitor" ("id", "job_type", "periodicity", "active", "url", "name", "description", "workspace_id", "headers", "body", "method", "created_at", "regions", "updated_at", "status", "assertions", "deleted_at", "public", "timeout", "degraded_after", "otel_endpoint", "otel_headers", "retry", "follow_redirects") VALUES
435('1', 'http', '1m', '1', 'https://www.openstatus.dev', 'OpenStatus', 'OpenStatus website', '1', '[{"key":"key", "value":"value"}]', '{"hello":"world"}', 'POST', '1760358329', 'ams', '1760358329', 'active', NULL, NULL, '0', '45000', NULL, NULL, NULL, '3', '1'),
436('2', 'http', '10m', '0', 'https://www.google.com', '', '', '1', '', '', 'GET', '1760358329', 'gru', '1760358329', 'active', NULL, NULL, '1', '45000', NULL, NULL, NULL, '3', '1'),
437('3', 'http', '1m', '1', 'https://www.openstatus.dev', 'OpenStatus', 'OpenStatus website', '1', '[{"key":"key", "value":"value"}]', '{"hello":"world"}', 'GET', '1760358329', 'ams', '1760358329', 'active', NULL, NULL, '0', '45000', NULL, NULL, NULL, '3', '1'),
438('4', 'http', '10m', '1', 'https://www.google.com', '', '', '1', '', '', 'GET', '1760358329', 'gru', '1760358329', 'active', NULL, NULL, '1', '45000', NULL, 'https://otel.com:4337', '[{"key":"Authorization","value":"Basic"}]', '3', '1'),
439('5', 'http', '10m', '1', 'https://openstat.us', '', '', '3', '', '', 'GET', '1760358329', 'ams', '1760358329', 'active', NULL, NULL, '1', '45000', NULL, NULL, NULL, '3', '1'),
440('6', 'tcp', '5m', '1', 'tcp://db.example.com:5432', 'Database TCP', 'Database TCP check', '3', '', '', '', '1760358329', 'ams', '1760358329', 'active', NULL, NULL, '0', '30000', '5000', NULL, NULL, '2', '0'),
441('7', 'dns', '5m', '1', 'openstatus.dev', 'DNS Check', 'DNS check for openstatus.dev', '3', '', '', '', '1760358329', 'ams', '1760358329', 'active', '[{"version":"v1","type":"dnsRecord","key":"A","compare":"contains","target":"76.76.21.21"}]', NULL, '0', '30000', '3000', NULL, NULL, '2', '0');
442
443INSERT INTO "notification" ("id", "name", "provider", "data", "workspace_id", "created_at", "updated_at") VALUES
444('1', 'sample test notification', 'email', '{"email":"ping@openstatus.dev"}', '1', '1760358329', '1760358329');
445
446INSERT INTO "notifications_to_monitors" ("monitor_id", "notification_id", "created_at") VALUES
447('1', '1', '1760358329');
448
449INSERT INTO "incident" ("id", "title", "summary", "status", "monitor_id", "workspace_id", "started_at", "acknowledged_at", "acknowledged_by", "resolved_at", "resolved_by", "created_at", "updated_at", "auto_resolved", "incident_screenshot_url", "recovery_screenshot_url") VALUES
450('1', '', '', 'triage', '1', '1', '1760358329', NULL, NULL, NULL, NULL, '1760358329', '1760358329', '0', NULL, NULL),
451('2', '', '', 'triage', '1', '1', '1760358330', NULL, NULL, NULL, NULL, '1760358329', '1760358329', '0', NULL, NULL);
452
453INSERT INTO "maintenance_to_monitor" ("monitor_id", "maintenance_id", "created_at") VALUES
454('1', '1', '1760358329');
455
456INSERT INTO "status_report" ("id", "status", "title", "workspace_id", "page_id", "created_at", "updated_at") VALUES
457('1', 'monitoring', 'Test Status Report', '1', '1', '1760358329', '1760358329'),
458('2', 'investigating', 'Test Status Report', '1', '1', '1760358329', '1760358329');
459
460INSERT INTO "maintenance" ("id", "title", "message", "from", "to", "workspace_id", "page_id", "created_at", "updated_at") VALUES
461('1', 'Test Maintenance', 'Test message', '1760358329', '1760358330', '1', '1', '1760358329', '1760358329');
462
463INSERT INTO "private_location" ("id", "name", "token", "last_seen_at", "workspace_id", "created_at", "updated_at") VALUES
464('1', 'My Home', 'my-secret-key', NULL, '3', '1760358329', '1760358329');
465
466INSERT INTO "private_location_to_monitor" ("private_location_id", "monitor_id", "created_at", "deleted_at") VALUES
467('1', '5', '1760358329', NULL),
468('1', '6', '1760358329', NULL),
469('1', '7', '1760358329', NULL);