aboutsummaryrefslogtreecommitdiffstats
path: root/packages/db/schema.ts
diff options
context:
space:
mode:
Diffstat (limited to 'packages/db/schema.ts')
-rw-r--r--packages/db/schema.ts44
1 files changed, 15 insertions, 29 deletions
diff --git a/packages/db/schema.ts b/packages/db/schema.ts
index 8edd1d83..d94d3963 100644
--- a/packages/db/schema.ts
+++ b/packages/db/schema.ts
@@ -38,11 +38,26 @@ export const users = sqliteTable("user", {
password: text("password"),
salt: text("salt").notNull().default(""),
role: text("role", { enum: ["admin", "user"] }).default("user"),
+
+ // Admin Only Settings
bookmarkQuota: integer("bookmarkQuota"),
storageQuota: integer("storageQuota"),
browserCrawlingEnabled: integer("browserCrawlingEnabled", {
mode: "boolean",
}),
+
+ // User Settings
+ bookmarkClickAction: text("bookmarkClickAction", {
+ enum: ["open_original_link", "expand_bookmark_preview"],
+ })
+ .notNull()
+ .default("open_original_link"),
+ archiveDisplayBehaviour: text("archiveDisplayBehaviour", {
+ enum: ["show", "hide"],
+ })
+ .notNull()
+ .default("show"),
+ timezone: text("timezone").default("UTC"),
});
export const accounts = sqliteTable(
@@ -554,24 +569,6 @@ export const ruleEngineActionsTable = sqliteTable(
],
);
-export const userSettings = sqliteTable("userSettings", {
- userId: text("userId")
- .notNull()
- .primaryKey()
- .references(() => users.id, { onDelete: "cascade" }),
- bookmarkClickAction: text("bookmarkClickAction", {
- enum: ["open_original_link", "expand_bookmark_preview"],
- })
- .notNull()
- .default("open_original_link"),
- archiveDisplayBehaviour: text("archiveDisplayBehaviour", {
- enum: ["show", "hide"],
- })
- .notNull()
- .default("show"),
- timezone: text("timezone").default("UTC"),
-});
-
export const invites = sqliteTable("invites", {
id: text("id")
.notNull()
@@ -639,10 +636,6 @@ export const userRelations = relations(users, ({ many, one }) => ({
webhooks: many(webhooksTable),
rules: many(ruleEngineRulesTable),
invites: many(invites),
- settings: one(userSettings, {
- fields: [users.id],
- references: [userSettings.userId],
- }),
subscription: one(subscriptions),
}));
@@ -779,13 +772,6 @@ export const rssFeedImportsTableRelations = relations(
}),
);
-export const userSettingsRelations = relations(userSettings, ({ one }) => ({
- user: one(users, {
- fields: [userSettings.userId],
- references: [users.id],
- }),
-}));
-
export const invitesRelations = relations(invites, ({ one }) => ({
invitedBy: one(users, {
fields: [invites.invitedBy],