A decentralized music tracking and discovery platform built on AT Protocol 馃幍
rocksky.app
spotify
atproto
lastfm
musicbrainz
scrobbling
listenbrainz
1import type { InferInsertModel, InferSelectModel } from "drizzle-orm";
2import { pgTable, text, timestamp } from "drizzle-orm/pg-core";
3import dropboxDirectories from "./dropbox-directories";
4
5const dropboxPaths = pgTable("dropbox_paths", {
6 id: text("xata_id").primaryKey(),
7 path: text("path").notNull(),
8 name: text("name").notNull(),
9 dropboxId: text("dropbox_id").notNull(),
10 trackId: text("track_id").notNull(),
11 directoryId: text("directory_id").references(() => dropboxDirectories.id),
12 fileId: text("file_id").notNull().unique(),
13 xataVersion: text("xata_version"),
14 createdAt: timestamp("xata_createdat").defaultNow().notNull(),
15 updatedAt: timestamp("xata_updatedat").defaultNow().notNull(),
16});
17
18export type SelectDropboxPaths = InferSelectModel<typeof dropboxPaths>;
19export type InsertDropboxDirectories = InferInsertModel<typeof dropboxPaths>;
20
21export default dropboxPaths;