summaryrefslogtreecommitdiff
path: root/drizzle/20260115093614_optimal_hobgoblin
diff options
context:
space:
mode:
authorJustZvan <justzvan@justzvan.xyz>2026-02-06 12:16:40 +0100
committerJustZvan <justzvan@justzvan.xyz>2026-02-06 12:16:40 +0100
commite904e9634548e47d611bdcbb88d7b180b927fd5f (patch)
tree21aa5be08fc5b22585508c0263ee5ea4effcc593 /drizzle/20260115093614_optimal_hobgoblin
feat: initial commit!
Diffstat (limited to 'drizzle/20260115093614_optimal_hobgoblin')
-rw-r--r--drizzle/20260115093614_optimal_hobgoblin/migration.sql11
-rw-r--r--drizzle/20260115093614_optimal_hobgoblin/snapshot.json329
2 files changed, 340 insertions, 0 deletions
diff --git a/drizzle/20260115093614_optimal_hobgoblin/migration.sql b/drizzle/20260115093614_optimal_hobgoblin/migration.sql
new file mode 100644
index 0000000..b114b35
--- /dev/null
+++ b/drizzle/20260115093614_optimal_hobgoblin/migration.sql
@@ -0,0 +1,11 @@
+CREATE TABLE "deviceConfig" (
+ "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "deviceConfig_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+ "device_id" integer NOT NULL UNIQUE,
+ "disable_buddy" boolean DEFAULT false NOT NULL,
+ "block_adult_sites" boolean DEFAULT true NOT NULL,
+ "content_filtering" boolean DEFAULT true NOT NULL,
+ "new_contact_alerts" boolean DEFAULT true NOT NULL,
+ "block_strangers" boolean DEFAULT false NOT NULL,
+ "notify_dangerous_messages" boolean DEFAULT true NOT NULL,
+ "notify_new_contact_added" boolean DEFAULT true NOT NULL
+);
diff --git a/drizzle/20260115093614_optimal_hobgoblin/snapshot.json b/drizzle/20260115093614_optimal_hobgoblin/snapshot.json
new file mode 100644
index 0000000..b6b626e
--- /dev/null
+++ b/drizzle/20260115093614_optimal_hobgoblin/snapshot.json
@@ -0,0 +1,329 @@
+{
+ "version": "8",
+ "dialect": "postgres",
+ "id": "81584059-8172-4fa3-90c9-027ea1697c49",
+ "prevIds": [
+ "eab7999e-ded1-4ae7-9559-4977e2679734"
+ ],
+ "ddl": [
+ {
+ "isRlsEnabled": false,
+ "name": "deviceConfig",
+ "entityType": "tables",
+ "schema": "public"
+ },
+ {
+ "isRlsEnabled": false,
+ "name": "linkedDevices",
+ "entityType": "tables",
+ "schema": "public"
+ },
+ {
+ "isRlsEnabled": false,
+ "name": "users",
+ "entityType": "tables",
+ "schema": "public"
+ },
+ {
+ "type": "integer",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": null,
+ "generated": null,
+ "identity": {
+ "type": "always",
+ "name": "deviceConfig_id_seq",
+ "increment": "1",
+ "startWith": "1",
+ "minValue": "1",
+ "maxValue": "2147483647",
+ "cache": 1,
+ "cycle": false
+ },
+ "name": "id",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "integer",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": null,
+ "generated": null,
+ "identity": null,
+ "name": "device_id",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "boolean",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": "false",
+ "generated": null,
+ "identity": null,
+ "name": "disable_buddy",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "boolean",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": "true",
+ "generated": null,
+ "identity": null,
+ "name": "block_adult_sites",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "boolean",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": "true",
+ "generated": null,
+ "identity": null,
+ "name": "content_filtering",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "boolean",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": "true",
+ "generated": null,
+ "identity": null,
+ "name": "new_contact_alerts",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "boolean",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": "false",
+ "generated": null,
+ "identity": null,
+ "name": "block_strangers",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "boolean",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": "true",
+ "generated": null,
+ "identity": null,
+ "name": "notify_dangerous_messages",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "boolean",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": "true",
+ "generated": null,
+ "identity": null,
+ "name": "notify_new_contact_added",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "deviceConfig"
+ },
+ {
+ "type": "integer",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": null,
+ "generated": null,
+ "identity": {
+ "type": "always",
+ "name": "linkedDevices_id_seq",
+ "increment": "1",
+ "startWith": "1",
+ "minValue": "1",
+ "maxValue": "2147483647",
+ "cache": 1,
+ "cycle": false
+ },
+ "name": "id",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "linkedDevices"
+ },
+ {
+ "type": "varchar(255)",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": "'New Device'",
+ "generated": null,
+ "identity": null,
+ "name": "nickname",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "linkedDevices"
+ },
+ {
+ "type": "integer",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": null,
+ "generated": null,
+ "identity": null,
+ "name": "parent_id",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "linkedDevices"
+ },
+ {
+ "type": "integer",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": null,
+ "generated": null,
+ "identity": {
+ "type": "always",
+ "name": "users_id_seq",
+ "increment": "1",
+ "startWith": "1",
+ "minValue": "1",
+ "maxValue": "2147483647",
+ "cache": 1,
+ "cycle": false
+ },
+ "name": "id",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "users"
+ },
+ {
+ "type": "varchar(255)",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": null,
+ "generated": null,
+ "identity": null,
+ "name": "email",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "users"
+ },
+ {
+ "type": "varchar(255)",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": null,
+ "generated": null,
+ "identity": null,
+ "name": "password",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "users"
+ },
+ {
+ "type": "boolean",
+ "typeSchema": null,
+ "notNull": false,
+ "dimensions": 0,
+ "default": "false",
+ "generated": null,
+ "identity": null,
+ "name": "emailVerified",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "users"
+ },
+ {
+ "type": "varchar(6)",
+ "typeSchema": null,
+ "notNull": true,
+ "dimensions": 0,
+ "default": null,
+ "generated": null,
+ "identity": null,
+ "name": "emailCode",
+ "entityType": "columns",
+ "schema": "public",
+ "table": "users"
+ },
+ {
+ "columns": [
+ "id"
+ ],
+ "nameExplicit": false,
+ "name": "deviceConfig_pkey",
+ "schema": "public",
+ "table": "deviceConfig",
+ "entityType": "pks"
+ },
+ {
+ "columns": [
+ "id"
+ ],
+ "nameExplicit": false,
+ "name": "linkedDevices_pkey",
+ "schema": "public",
+ "table": "linkedDevices",
+ "entityType": "pks"
+ },
+ {
+ "columns": [
+ "id"
+ ],
+ "nameExplicit": false,
+ "name": "users_pkey",
+ "schema": "public",
+ "table": "users",
+ "entityType": "pks"
+ },
+ {
+ "nameExplicit": false,
+ "columns": [
+ "device_id"
+ ],
+ "nullsNotDistinct": false,
+ "name": "deviceConfig_device_id_key",
+ "schema": "public",
+ "table": "deviceConfig",
+ "entityType": "uniques"
+ },
+ {
+ "nameExplicit": false,
+ "columns": [
+ "email"
+ ],
+ "nullsNotDistinct": false,
+ "name": "users_email_key",
+ "schema": "public",
+ "table": "users",
+ "entityType": "uniques"
+ }
+ ],
+ "renames": []
+} \ No newline at end of file