{
	"id": "e50ff0fb-4111-4d20-b550-9407ee397517",
	"prevId": "e52fe10a-3f36-4b21-abef-c15990d28363",
	"version": "6",
	"dialect": "sqlite",
	"tables": {
		"app_metadata": {
			"name": "app_metadata",
			"columns": {
				"key": {
					"name": "key",
					"type": "text",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": false
				},
				"value": {
					"name": "value",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				}
			},
			"indexes": {},
			"foreignKeys": {},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"backup_schedule_notifications_table": {
			"name": "backup_schedule_notifications_table",
			"columns": {
				"schedule_id": {
					"name": "schedule_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"destination_id": {
					"name": "destination_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"notify_on_start": {
					"name": "notify_on_start",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": false
				},
				"notify_on_success": {
					"name": "notify_on_success",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": false
				},
				"notify_on_failure": {
					"name": "notify_on_failure",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": true
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				}
			},
			"indexes": {},
			"foreignKeys": {
				"backup_schedule_notifications_table_schedule_id_backup_schedules_table_id_fk": {
					"name": "backup_schedule_notifications_table_schedule_id_backup_schedules_table_id_fk",
					"tableFrom": "backup_schedule_notifications_table",
					"columnsFrom": ["schedule_id"],
					"tableTo": "backup_schedules_table",
					"columnsTo": ["id"],
					"onUpdate": "no action",
					"onDelete": "cascade"
				},
				"backup_schedule_notifications_table_destination_id_notification_destinations_table_id_fk": {
					"name": "backup_schedule_notifications_table_destination_id_notification_destinations_table_id_fk",
					"tableFrom": "backup_schedule_notifications_table",
					"columnsFrom": ["destination_id"],
					"tableTo": "notification_destinations_table",
					"columnsTo": ["id"],
					"onUpdate": "no action",
					"onDelete": "cascade"
				}
			},
			"compositePrimaryKeys": {
				"backup_schedule_notifications_table_schedule_id_destination_id_pk": {
					"columns": ["schedule_id", "destination_id"],
					"name": "backup_schedule_notifications_table_schedule_id_destination_id_pk"
				}
			},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"backup_schedules_table": {
			"name": "backup_schedules_table",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"volume_id": {
					"name": "volume_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"repository_id": {
					"name": "repository_id",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"enabled": {
					"name": "enabled",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": true
				},
				"cron_expression": {
					"name": "cron_expression",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"retention_policy": {
					"name": "retention_policy",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"exclude_patterns": {
					"name": "exclude_patterns",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false,
					"default": "'[]'"
				},
				"include_patterns": {
					"name": "include_patterns",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false,
					"default": "'[]'"
				},
				"last_backup_at": {
					"name": "last_backup_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"last_backup_status": {
					"name": "last_backup_status",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"last_backup_error": {
					"name": "last_backup_error",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"next_backup_at": {
					"name": "next_backup_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				}
			},
			"indexes": {},
			"foreignKeys": {
				"backup_schedules_table_volume_id_volumes_table_id_fk": {
					"name": "backup_schedules_table_volume_id_volumes_table_id_fk",
					"tableFrom": "backup_schedules_table",
					"columnsFrom": ["volume_id"],
					"tableTo": "volumes_table",
					"columnsTo": ["id"],
					"onUpdate": "no action",
					"onDelete": "cascade"
				},
				"backup_schedules_table_repository_id_repositories_table_id_fk": {
					"name": "backup_schedules_table_repository_id_repositories_table_id_fk",
					"tableFrom": "backup_schedules_table",
					"columnsFrom": ["repository_id"],
					"tableTo": "repositories_table",
					"columnsTo": ["id"],
					"onUpdate": "no action",
					"onDelete": "cascade"
				}
			},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"notification_destinations_table": {
			"name": "notification_destinations_table",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"name": {
					"name": "name",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"enabled": {
					"name": "enabled",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": true
				},
				"type": {
					"name": "type",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"config": {
					"name": "config",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				}
			},
			"indexes": {
				"notification_destinations_table_name_unique": {
					"name": "notification_destinations_table_name_unique",
					"columns": ["name"],
					"isUnique": true
				}
			},
			"foreignKeys": {},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"repositories_table": {
			"name": "repositories_table",
			"columns": {
				"id": {
					"name": "id",
					"type": "text",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": false
				},
				"short_id": {
					"name": "short_id",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"name": {
					"name": "name",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"type": {
					"name": "type",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"config": {
					"name": "config",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"compression_mode": {
					"name": "compression_mode",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false,
					"default": "'auto'"
				},
				"status": {
					"name": "status",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false,
					"default": "'unknown'"
				},
				"last_checked": {
					"name": "last_checked",
					"type": "integer",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"last_error": {
					"name": "last_error",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				}
			},
			"indexes": {
				"repositories_table_short_id_unique": {
					"name": "repositories_table_short_id_unique",
					"columns": ["short_id"],
					"isUnique": true
				},
				"repositories_table_name_unique": {
					"name": "repositories_table_name_unique",
					"columns": ["name"],
					"isUnique": true
				}
			},
			"foreignKeys": {},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"sessions_table": {
			"name": "sessions_table",
			"columns": {
				"id": {
					"name": "id",
					"type": "text",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": false
				},
				"user_id": {
					"name": "user_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"expires_at": {
					"name": "expires_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				}
			},
			"indexes": {},
			"foreignKeys": {
				"sessions_table_user_id_users_table_id_fk": {
					"name": "sessions_table_user_id_users_table_id_fk",
					"tableFrom": "sessions_table",
					"columnsFrom": ["user_id"],
					"tableTo": "users_table",
					"columnsTo": ["id"],
					"onUpdate": "no action",
					"onDelete": "cascade"
				}
			},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"users_table": {
			"name": "users_table",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"username": {
					"name": "username",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"password_hash": {
					"name": "password_hash",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"has_downloaded_restic_password": {
					"name": "has_downloaded_restic_password",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				}
			},
			"indexes": {
				"users_table_username_unique": {
					"name": "users_table_username_unique",
					"columns": ["username"],
					"isUnique": true
				}
			},
			"foreignKeys": {},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"volumes_table": {
			"name": "volumes_table",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"short_id": {
					"name": "short_id",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"name": {
					"name": "name",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"type": {
					"name": "type",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"status": {
					"name": "status",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "'unmounted'"
				},
				"last_error": {
					"name": "last_error",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"last_health_check": {
					"name": "last_health_check",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "(unixepoch())"
				},
				"config": {
					"name": "config",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"auto_remount": {
					"name": "auto_remount",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": true
				}
			},
			"indexes": {
				"volumes_table_short_id_unique": {
					"name": "volumes_table_short_id_unique",
					"columns": ["short_id"],
					"isUnique": true
				},
				"volumes_table_name_unique": {
					"name": "volumes_table_name_unique",
					"columns": ["name"],
					"isUnique": true
				}
			},
			"foreignKeys": {},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		}
	},
	"views": {},
	"enums": {},
	"_meta": {
		"columns": {},
		"schemas": {},
		"tables": {}
	},
	"internal": {
		"indexes": {}
	}
}
