mirror of
https://github.com/pupperpowell/bibdle.git
synced 2026-04-05 17:33:31 -04:00
10 lines
730 B
SQL
10 lines
730 B
SQL
ALTER TABLE `user` ADD `first_name` text;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `last_name` text;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `email` text;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `password_hash` text;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `apple_id` text;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `is_private` integer DEFAULT false;--> statement-breakpoint
|
|
CREATE UNIQUE INDEX `user_email_unique` ON `user` (`email`);--> statement-breakpoint
|
|
CREATE UNIQUE INDEX `user_apple_id_unique` ON `user` (`apple_id`);--> statement-breakpoint
|
|
ALTER TABLE `user` DROP COLUMN `age`;--> statement-breakpoint
|
|
CREATE INDEX `anonymous_id_date_idx` ON `daily_completions` (`anonymous_id`,`date`); |