diff options
Diffstat (limited to 'drizzle/20260110120306_previous_zodiak/migration.sql')
| -rw-r--r-- | drizzle/20260110120306_previous_zodiak/migration.sql | 13 |
1 files changed, 13 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 +); |