diff options
Diffstat (limited to 'drizzle')
15 files changed, 2812 insertions, 0 deletions
diff --git a/drizzle/20260110120306_previous_zodiak/migration.sql b/drizzle/20260110120306_previous_zodiak/migration.sql new file mode 100644 index 0000000..771e953 --- /dev/null +++ b/drizzle/20260110120306_previous_zodiak/migration.sql @@ -0,0 +1,13 @@ +CREATE TABLE "linkedDevices" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "linkedDevices_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "nickname" varchar(255) DEFAULT 'New Device' NOT NULL, + "parent_id" integer NOT NULL +); +--> statement-breakpoint +CREATE TABLE "users" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "users_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "email" varchar(255) NOT NULL UNIQUE, + "password" varchar(255) NOT NULL, + "emailVerified" boolean DEFAULT false, + "emailCode" varchar(6) NOT NULL +); diff --git a/drizzle/20260110120306_previous_zodiak/snapshot.json b/drizzle/20260110120306_previous_zodiak/snapshot.json new file mode 100644 index 0000000..d0996d9 --- /dev/null +++ b/drizzle/20260110120306_previous_zodiak/snapshot.json @@ -0,0 +1,176 @@ +{ + "version": "8", + "dialect": "postgres", + "id": "eab7999e-ded1-4ae7-9559-4977e2679734", + "prevIds": [ + "00000000-0000-0000-0000-000000000000" + ], + "ddl": [ + { + "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": "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": "linkedDevices_pkey", + "schema": "public", + "table": "linkedDevices", + "entityType": "pks" + }, + { + "columns": [ + "id" + ], + "nameExplicit": false, + "name": "users_pkey", + "schema": "public", + "table": "users", + "entityType": "pks" + }, + { + "nameExplicit": false, + "columns": [ + "email" + ], + "nullsNotDistinct": false, + "name": "users_email_key", + "schema": "public", + "table": "users", + "entityType": "uniques" + } + ], + "renames": [] +}
\ No newline at end of file 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 diff --git a/drizzle/20260115112155_parched_night_thrasher/migration.sql b/drizzle/20260115112155_parched_night_thrasher/migration.sql new file mode 100644 index 0000000..5155288 --- /dev/null +++ b/drizzle/20260115112155_parched_night_thrasher/migration.sql @@ -0,0 +1 @@ +ALTER TABLE "linkedDevices" ADD COLUMN "last_online" integer;
\ No newline at end of file diff --git a/drizzle/20260115112155_parched_night_thrasher/snapshot.json b/drizzle/20260115112155_parched_night_thrasher/snapshot.json new file mode 100644 index 0000000..75af819 --- /dev/null +++ b/drizzle/20260115112155_parched_night_thrasher/snapshot.json @@ -0,0 +1,342 @@ +{ + "version": "8", + "dialect": "postgres", + "id": "7f12fa4b-4924-432f-972f-99045f274c90", + "prevIds": [ + "81584059-8172-4fa3-90c9-027ea1697c49" + ], + "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": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "last_online", + "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 diff --git a/drizzle/20260115135212_abnormal_thundra/migration.sql b/drizzle/20260115135212_abnormal_thundra/migration.sql new file mode 100644 index 0000000..20cbccb --- /dev/null +++ b/drizzle/20260115135212_abnormal_thundra/migration.sql @@ -0,0 +1,2 @@ +ALTER TABLE "users" ADD COLUMN "push_token" text;--> statement-breakpoint +ALTER TABLE "deviceConfig" DROP COLUMN "content_filtering";
\ No newline at end of file diff --git a/drizzle/20260115135212_abnormal_thundra/snapshot.json b/drizzle/20260115135212_abnormal_thundra/snapshot.json new file mode 100644 index 0000000..e233738 --- /dev/null +++ b/drizzle/20260115135212_abnormal_thundra/snapshot.json @@ -0,0 +1,342 @@ +{ + "version": "8", + "dialect": "postgres", + "id": "3673abad-8c2e-40e2-842b-5b94f1f0979f", + "prevIds": [ + "7f12fa4b-4924-432f-972f-99045f274c90" + ], + "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": "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": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "last_online", + "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" + }, + { + "type": "text", + "typeSchema": null, + "notNull": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "push_token", + "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 diff --git a/drizzle/20260115140000_push_tokens_array/migration.sql b/drizzle/20260115140000_push_tokens_array/migration.sql new file mode 100644 index 0000000..9adc51a --- /dev/null +++ b/drizzle/20260115140000_push_tokens_array/migration.sql @@ -0,0 +1,9 @@ +-- Convert push_token from text to text[] array +-- First, create the new column +ALTER TABLE "users" ADD COLUMN "push_tokens" text[] DEFAULT '{}';--> statement-breakpoint + +-- Migrate existing single token to array format (skip null values) +UPDATE "users" SET "push_tokens" = ARRAY[push_token]::text[] WHERE push_token IS NOT NULL;--> statement-breakpoint + +-- Drop the old column +ALTER TABLE "users" DROP COLUMN "push_token"; diff --git a/drizzle/20260115153715_little_legion/migration.sql b/drizzle/20260115153715_little_legion/migration.sql new file mode 100644 index 0000000..adffaea --- /dev/null +++ b/drizzle/20260115153715_little_legion/migration.sql @@ -0,0 +1,16 @@ +CREATE TABLE "alerts" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "alerts_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "device_id" integer NOT NULL, + "parent_id" integer NOT NULL, + "category" varchar(50), + "title" varchar(255) NOT NULL, + "message" text NOT NULL, + "summary" text NOT NULL, + "confidence" integer NOT NULL, + "packageName" varchar(255), + "timestamp" integer NOT NULL, + "read" boolean DEFAULT false NOT NULL +); +--> statement-breakpoint +ALTER TABLE "users" ADD COLUMN "push_tokens" text[] DEFAULT '{}'::text[];--> statement-breakpoint +ALTER TABLE "users" DROP COLUMN "push_token";
\ No newline at end of file diff --git a/drizzle/20260115153715_little_legion/snapshot.json b/drizzle/20260115153715_little_legion/snapshot.json new file mode 100644 index 0000000..7f889e9 --- /dev/null +++ b/drizzle/20260115153715_little_legion/snapshot.json @@ -0,0 +1,510 @@ +{ + "version": "8", + "dialect": "postgres", + "id": "20210d2e-5ece-45cc-92d5-960b1045a90b", + "prevIds": [ + "3673abad-8c2e-40e2-842b-5b94f1f0979f" + ], + "ddl": [ + { + "isRlsEnabled": false, + "name": "alerts", + "entityType": "tables", + "schema": "public" + }, + { + "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": "alerts_id_seq", + "increment": "1", + "startWith": "1", + "minValue": "1", + "maxValue": "2147483647", + "cache": 1, + "cycle": false + }, + "name": "id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "device_id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "parent_id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(50)", + "typeSchema": null, + "notNull": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "category", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(255)", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "title", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "text", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "message", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "text", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "summary", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "confidence", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(255)", + "typeSchema": null, + "notNull": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "packageName", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "timestamp", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "boolean", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": "false", + "generated": null, + "identity": null, + "name": "read", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "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": "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": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "last_online", + "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" + }, + { + "type": "text", + "typeSchema": null, + "notNull": false, + "dimensions": 1, + "default": "'{}'", + "generated": null, + "identity": null, + "name": "push_tokens", + "entityType": "columns", + "schema": "public", + "table": "users" + }, + { + "columns": [ + "id" + ], + "nameExplicit": false, + "name": "alerts_pkey", + "schema": "public", + "table": "alerts", + "entityType": "pks" + }, + { + "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 diff --git a/drizzle/20260118111253_thick_firelord/migration.sql b/drizzle/20260118111253_thick_firelord/migration.sql new file mode 100644 index 0000000..15c8cef --- /dev/null +++ b/drizzle/20260118111253_thick_firelord/migration.sql @@ -0,0 +1 @@ +ALTER TABLE "deviceConfig" ADD COLUMN "family_link_anti_circumvention" boolean DEFAULT false NOT NULL;
\ No newline at end of file diff --git a/drizzle/20260118111253_thick_firelord/snapshot.json b/drizzle/20260118111253_thick_firelord/snapshot.json new file mode 100644 index 0000000..401d530 --- /dev/null +++ b/drizzle/20260118111253_thick_firelord/snapshot.json @@ -0,0 +1,523 @@ +{ + "version": "8", + "dialect": "postgres", + "id": "0cbb7e67-cf93-4bb1-a167-4b347794dbdc", + "prevIds": [ + "20210d2e-5ece-45cc-92d5-960b1045a90b" + ], + "ddl": [ + { + "isRlsEnabled": false, + "name": "alerts", + "entityType": "tables", + "schema": "public" + }, + { + "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": "alerts_id_seq", + "increment": "1", + "startWith": "1", + "minValue": "1", + "maxValue": "2147483647", + "cache": 1, + "cycle": false + }, + "name": "id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "device_id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "parent_id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(50)", + "typeSchema": null, + "notNull": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "category", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(255)", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "title", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "text", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "message", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "text", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "summary", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "confidence", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(255)", + "typeSchema": null, + "notNull": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "packageName", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "timestamp", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "boolean", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": "false", + "generated": null, + "identity": null, + "name": "read", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "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": "false", + "generated": null, + "identity": null, + "name": "family_link_anti_circumvention", + "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": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "last_online", + "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" + }, + { + "type": "text", + "typeSchema": null, + "notNull": false, + "dimensions": 1, + "default": "'{}'", + "generated": null, + "identity": null, + "name": "push_tokens", + "entityType": "columns", + "schema": "public", + "table": "users" + }, + { + "columns": [ + "id" + ], + "nameExplicit": false, + "name": "alerts_pkey", + "schema": "public", + "table": "alerts", + "entityType": "pks" + }, + { + "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 diff --git a/drizzle/20260122172742_damp_serpent_society/migration.sql b/drizzle/20260122172742_damp_serpent_society/migration.sql new file mode 100644 index 0000000..bc40de1 --- /dev/null +++ b/drizzle/20260122172742_damp_serpent_society/migration.sql @@ -0,0 +1 @@ +ALTER TABLE "linkedDevices" ADD COLUMN "devEnabled" boolean DEFAULT false;
\ No newline at end of file diff --git a/drizzle/20260122172742_damp_serpent_society/snapshot.json b/drizzle/20260122172742_damp_serpent_society/snapshot.json new file mode 100644 index 0000000..684dc7e --- /dev/null +++ b/drizzle/20260122172742_damp_serpent_society/snapshot.json @@ -0,0 +1,536 @@ +{ + "version": "8", + "dialect": "postgres", + "id": "0bd19c7f-e5f9-468c-9fa3-150f7c6e5cf3", + "prevIds": [ + "0cbb7e67-cf93-4bb1-a167-4b347794dbdc" + ], + "ddl": [ + { + "isRlsEnabled": false, + "name": "alerts", + "entityType": "tables", + "schema": "public" + }, + { + "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": "alerts_id_seq", + "increment": "1", + "startWith": "1", + "minValue": "1", + "maxValue": "2147483647", + "cache": 1, + "cycle": false + }, + "name": "id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "device_id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "parent_id", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(50)", + "typeSchema": null, + "notNull": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "category", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(255)", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "title", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "text", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "message", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "text", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "summary", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "confidence", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "varchar(255)", + "typeSchema": null, + "notNull": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "packageName", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "integer", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "timestamp", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "type": "boolean", + "typeSchema": null, + "notNull": true, + "dimensions": 0, + "default": "false", + "generated": null, + "identity": null, + "name": "read", + "entityType": "columns", + "schema": "public", + "table": "alerts" + }, + { + "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": "false", + "generated": null, + "identity": null, + "name": "family_link_anti_circumvention", + "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": false, + "dimensions": 0, + "default": null, + "generated": null, + "identity": null, + "name": "last_online", + "entityType": "columns", + "schema": "public", + "table": "linkedDevices" + }, + { + "type": "boolean", + "typeSchema": null, + "notNull": false, + "dimensions": 0, + "default": "false", + "generated": null, + "identity": null, + "name": "devEnabled", + "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" + }, + { + "type": "text", + "typeSchema": null, + "notNull": false, + "dimensions": 1, + "default": "'{}'", + "generated": null, + "identity": null, + "name": "push_tokens", + "entityType": "columns", + "schema": "public", + "table": "users" + }, + { + "columns": [ + "id" + ], + "nameExplicit": false, + "name": "alerts_pkey", + "schema": "public", + "table": "alerts", + "entityType": "pks" + }, + { + "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 |