537d65275a
- Fix Prisma database errors in LXC config sync (advanced and rootfs field issues) - Remove double confirmation from LXC settings modal (keep confirmation modal, remove inline input) - Fix dependency loop in status check useEffect - Add LXC configuration management with proper validation - Improve error handling and user experience
75 lines
2.2 KiB
SQL
75 lines
2.2 KiB
SQL
-- CreateTable
|
|
CREATE TABLE "installed_scripts" (
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
"script_name" TEXT NOT NULL,
|
|
"script_path" TEXT NOT NULL,
|
|
"container_id" TEXT,
|
|
"server_id" INTEGER,
|
|
"execution_mode" TEXT NOT NULL,
|
|
"installation_date" DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
"status" TEXT NOT NULL,
|
|
"output_log" TEXT,
|
|
"web_ui_ip" TEXT,
|
|
"web_ui_port" INTEGER,
|
|
CONSTRAINT "installed_scripts_server_id_fkey" FOREIGN KEY ("server_id") REFERENCES "servers" ("id") ON DELETE SET NULL ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "servers" (
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
"name" TEXT NOT NULL,
|
|
"ip" TEXT NOT NULL,
|
|
"user" TEXT NOT NULL,
|
|
"password" TEXT,
|
|
"auth_type" TEXT DEFAULT 'password',
|
|
"ssh_key" TEXT,
|
|
"ssh_key_passphrase" TEXT,
|
|
"ssh_port" INTEGER DEFAULT 22,
|
|
"color" TEXT,
|
|
"created_at" DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
"updated_at" DATETIME,
|
|
"ssh_key_path" TEXT,
|
|
"key_generated" BOOLEAN DEFAULT false
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "lxc_configs" (
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
"installed_script_id" INTEGER NOT NULL,
|
|
"arch" TEXT,
|
|
"cores" INTEGER,
|
|
"memory" INTEGER,
|
|
"hostname" TEXT,
|
|
"swap" INTEGER,
|
|
"onboot" INTEGER,
|
|
"ostype" TEXT,
|
|
"unprivileged" INTEGER,
|
|
"net_name" TEXT,
|
|
"net_bridge" TEXT,
|
|
"net_hwaddr" TEXT,
|
|
"net_ip_type" TEXT,
|
|
"net_ip" TEXT,
|
|
"net_gateway" TEXT,
|
|
"net_type" TEXT,
|
|
"net_vlan" INTEGER,
|
|
"rootfs_storage" TEXT,
|
|
"rootfs_size" TEXT,
|
|
"feature_keyctl" INTEGER,
|
|
"feature_nesting" INTEGER,
|
|
"feature_fuse" INTEGER,
|
|
"feature_mount" TEXT,
|
|
"tags" TEXT,
|
|
"advanced_config" TEXT,
|
|
"synced_at" DATETIME,
|
|
"config_hash" TEXT,
|
|
"created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updated_at" DATETIME NOT NULL,
|
|
CONSTRAINT "lxc_configs_installed_script_id_fkey" FOREIGN KEY ("installed_script_id") REFERENCES "installed_scripts" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "servers_name_key" ON "servers"("name");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "lxc_configs_installed_script_id_key" ON "lxc_configs"("installed_script_id");
|