Sync-in · Sovereign platform for file storage, sharing, synchronization, and collaboration.
TypeScript cloud-alternativecollaborationcollaborative-editingdropboxfile-serverfile-sharingfile-storagefile-syncfull-text-searchhomelabnextcloudon-premiseopen-sourceprivacy-firstprivate-cloudrealtimesecureself-hostedstorage-serverwebdav
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`);