diff options
Diffstat (limited to 'src/db.rs')
| -rw-r--r-- | src/db.rs | 16 |
1 files changed, 16 insertions, 0 deletions
| @@ -62,6 +62,18 @@ impl Database { | |||
| 62 | updated_at TEXT NOT NULL DEFAULT (datetime('now')) | 62 | updated_at TEXT NOT NULL DEFAULT (datetime('now')) |
| 63 | ); | 63 | ); |
| 64 | 64 | ||
| 65 | CREATE TABLE IF NOT EXISTS mods ( | ||
| 66 | id INTEGER PRIMARY KEY AUTOINCREMENT, | ||
| 67 | instance_id INTEGER NOT NULL, | ||
| 68 | filename TEXT NOT NULL, | ||
| 69 | display_name TEXT, | ||
| 70 | side TEXT NOT NULL DEFAULT 'UNKNOWN', | ||
| 71 | accepted INTEGER NOT NULL DEFAULT 0, | ||
| 72 | rejection_reason TEXT, | ||
| 73 | created_at TEXT NOT NULL DEFAULT (datetime('now')), | ||
| 74 | FOREIGN KEY (instance_id) REFERENCES instances(id) ON DELETE CASCADE | ||
| 75 | ); | ||
| 76 | |||
| 65 | CREATE TABLE IF NOT EXISTS backups ( | 77 | CREATE TABLE IF NOT EXISTS backups ( |
| 66 | id INTEGER PRIMARY KEY AUTOINCREMENT, | 78 | id INTEGER PRIMARY KEY AUTOINCREMENT, |
| 67 | instance_id INTEGER NOT NULL, | 79 | instance_id INTEGER NOT NULL, |
| @@ -98,6 +110,10 @@ impl Database { | |||
| 98 | let _ = conn.execute_batch( | 110 | let _ = conn.execute_batch( |
| 99 | "ALTER TABLE instances ADD COLUMN container_state TEXT NOT NULL DEFAULT 'stopped'", | 111 | "ALTER TABLE instances ADD COLUMN container_state TEXT NOT NULL DEFAULT 'stopped'", |
| 100 | ); | 112 | ); |
| 113 | // Migration: add whitelist_enabled column if missing | ||
| 114 | let _ = conn.execute_batch( | ||
| 115 | "ALTER TABLE instances ADD COLUMN whitelist_enabled INTEGER NOT NULL DEFAULT 1", | ||
| 116 | ); | ||
| 101 | Ok(()) | 117 | Ok(()) |
| 102 | } | 118 | } |
| 103 | 119 | ||
