diff options
| author | JustZvan <justzvan@justzvan.xyz> | 2026-02-06 12:16:40 +0100 |
|---|---|---|
| committer | JustZvan <justzvan@justzvan.xyz> | 2026-02-06 12:16:40 +0100 |
| commit | e904e9634548e47d611bdcbb88d7b180b927fd5f (patch) | |
| tree | 21aa5be08fc5b22585508c0263ee5ea4effcc593 /drizzle/20260110120306_previous_zodiak | |
feat: initial commit!
Diffstat (limited to 'drizzle/20260110120306_previous_zodiak')
| -rw-r--r-- | drizzle/20260110120306_previous_zodiak/migration.sql | 13 | ||||
| -rw-r--r-- | drizzle/20260110120306_previous_zodiak/snapshot.json | 176 |
2 files changed, 189 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 |