Skip to content

Sync-in · Sovereign platform for file storage, sharing, synchronization, and collaboration.

986 B
Raw Blame
CREATE TABLE `files_favorites` (
	`userId` bigint unsigned NOT NULL,
	`fileId` bigint unsigned NOT NULL,
	`createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
	CONSTRAINT `files_favorites_userId_fileId_pk` PRIMARY KEY(`userId`,`fileId`)
);
--> statement-breakpoint
ALTER TABLE `users` ADD `externalId` varchar(255);--> statement-breakpoint
ALTER TABLE `users` ADD CONSTRAINT `external_id_idx` UNIQUE(`externalId`);--> statement-breakpoint
ALTER TABLE `files_favorites` ADD CONSTRAINT `files_favorites_userId_users_id_fk` FOREIGN KEY (`userId`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE `files_favorites` ADD CONSTRAINT `files_favorites_fileId_files_id_fk` FOREIGN KEY (`fileId`) REFERENCES `files`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
CREATE INDEX `file_idx` ON `files_favorites` (`fileId`);--> statement-breakpoint
CREATE INDEX `user_created_idx` ON `files_favorites` (`userId`,`createdAt`);