supermemory/apps/web/migrations/0001_index_telegram_id.sql
2024-06-30 18:22:34 -05:00

9 lines
No EOL
485 B
SQL

ALTER TABLE `space` ADD COLUMN `createdAt` integer;
ALTER TABLE `space` ADD COLUMN `numItems` integer NOT NULL DEFAULT 0;
--> statement-breakpoint
CREATE INDEX `users_email_idx` ON `user` (`email`);--> statement-breakpoint
CREATE INDEX `users_telegram_idx` ON `user` (`telegramId`);--> statement-breakpoint
CREATE INDEX `users_id_idx` ON `user` (`id`);
CREATE UNIQUE INDEX `storedContent_baseUrl_unique` ON `storedContent` (`baseUrl`);
ALTER TABLE `user` ADD COLUMN `telegramId` text;