mirror of
https://github.com/tale/headplane.git
synced 2026-07-26 07:48:14 +00:00
Aarnav Tale
d2c4f5eb2b
* Cookies are now encrypted JWTs (GHSA-wrqq-v7qw-r5w7) * Authentication is stored in the SQLite database (auto-migrated) * Session logic is much cleaner
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`);
|