summaryrefslogtreecommitdiff
path: root/drizzle/20260110120306_previous_zodiak
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/20260110120306_previous_zodiak
feat: initial commit!
Diffstat (limited to 'drizzle/20260110120306_previous_zodiak')
-rw-r--r--drizzle/20260110120306_previous_zodiak/migration.sql13
-rw-r--r--drizzle/20260110120306_previous_zodiak/snapshot.json176
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