Skip to content

A modern, self-hosted backup solution for secure, encrypted backups across local and cloud storage.

830 B
Raw Blame
import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core';
import { createInsertSchema, createSelectSchema, createUpdateSchema } from 'drizzle-zod';
import { AppSettings } from '../../types/settings';

export const settings = sqliteTable('settings', {
	id: integer('id').primaryKey({ autoIncrement: true }),
	settings: text('settings', { mode: 'json' }).$type<AppSettings>(),
	updatedAt: integer('updated_at', { mode: 'timestamp' }),
	updatedBy: text('updated_by'),
	version: integer('version').default(1),
});

export type Settings = typeof settings.$inferSelect;
export type NewSettings = typeof settings.$inferInsert;
export const settingsInsertSchema = createInsertSchema(settings);
export const settingsUpdateSchema = createUpdateSchema(settings);
export const settingsSelectSchema = createSelectSchema(settings);