socksthewolf.com / skyscheduler
Schedule posts to Bluesky with Cloudflare workers. skyscheduler.work
cf tool bsky-tool cloudflare bluesky schedule bsky service social-media cloudflare-workers
fork atom
skyscheduler / migrations / 0014_ambitious_siren.sql
at main 10 lines 421 B view raw
SocksTheWolf handle abandoned files with cleanup
7fd6164d
1CREATE TABLE `media` ( 2 `file` text PRIMARY KEY NOT NULL, 3 `hasPost` integer DEFAULT false, 4 `user` text, 5 `created_at` integer NOT NULL, 6 FOREIGN KEY (`user`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade 7); 8--> statement-breakpoint 9CREATE INDEX `media_oldWithNoPost_idx` ON `media` (`hasPost`,`created_at`) WHERE hasPost = 0;--> statement-breakpoint 10CREATE INDEX `media_userid_idx` ON `media` (`user`);