mirror of
https://github.com/tale/headplane.git
synced 2026-07-26 07:48:14 +00:00
Aarnav Tale
9 lines
245 B
SQL
9 lines
245 B
SQL
CREATE TABLE `users` (
|
|
`id` text PRIMARY KEY NOT NULL,
|
|
`sub` text NOT NULL,
|
|
`caps` integer DEFAULT 0 NOT NULL,
|
|
`onboarded` integer DEFAULT false NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE UNIQUE INDEX `users_sub_unique` ON `users` (`sub`);
|