Oops. Here you go.
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE schema (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
version INTEGER NOT NULL,
updated_at DATETIME NOT NULL,
UNIQUE (version)
);
INSERT INTO schema VALUES(1,30,1593544096);
INSERT INTO schema VALUES(2,31,1593727463);
INSERT INTO schema VALUES(3,32,1596490434);
INSERT INTO schema VALUES(4,33,1596490434);
INSERT INTO schema VALUES(5,34,1600357204);
INSERT INTO schema VALUES(6,35,1600357204);
INSERT INTO schema VALUES(7,36,1600357204);
INSERT INTO schema VALUES(8,37,1600720149);
INSERT INTO schema VALUES(9,38,1600720149);
INSERT INTO schema VALUES(10,39,1603160445);
INSERT INTO schema VALUES(11,40,1608088084);
INSERT INTO schema VALUES(12,41,1608088084);
INSERT INTO schema VALUES(13,42,1608088084);
INSERT INTO schema VALUES(14,43,1608088084);
INSERT INTO schema VALUES(15,44,1610397612);
INSERT INTO schema VALUES(16,45,1615406142);
INSERT INTO schema VALUES(17,46,1615406142);
INSERT INTO schema VALUES(18,47,1615406142);
INSERT INTO schema VALUES(19,48,1620678658);
INSERT INTO schema VALUES(20,49,1626107804);
INSERT INTO schema VALUES(21,50,1630967820);
INSERT INTO schema VALUES(22,51,1636498056);
INSERT INTO schema VALUES(23,52,1636498056);
INSERT INTO schema VALUES(24,53,1636498056);
INSERT INTO schema VALUES(25,54,1639490252);
INSERT INTO schema VALUES(26,55,1642559554);
INSERT INTO schema VALUES(27,56,1642559554);
INSERT INTO schema VALUES(28,57,1642614752);
INSERT INTO schema VALUES(29,58,1642867952);
INSERT INTO schema VALUES(30,59,1643164364);
INSERT INTO schema VALUES(31,60,1644881863);
INSERT INTO schema VALUES(32,61,1658877882);
INSERT INTO schema VALUES(33,62,1658877882);
INSERT INTO schema VALUES(34,63,1661592294);
INSERT INTO schema VALUES(35,64,1661592294);
INSERT INTO schema VALUES(36,65,1661592294);
CREATE TABLE certificates (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
fingerprint TEXT NOT NULL,
type INTEGER NOT NULL,
name TEXT NOT NULL,
certificate TEXT NOT NULL, restricted INTEGER NOT NULL DEFAULT 0,
UNIQUE (fingerprint)
);
INSERT INTO certificates VALUES(1,'f006734366df0b318d0536c9bd92acd643af1f15757178d953e9c93ecf9450d6',2,'lxd0',replace('-----BEGIN CERTIFICATE-----\nMIICIjCCAaegAwIBAgIQWolJXcKR44WllJckceza+TAKBggqhkjOPQQDAzA+MRww\nGgYDVQQKExNsaW51eGNvbnRhaW5lcnMub3JnMR4wHAYDVQQDDBVyb290QGlwLTE3\nMi0zMS00My0xMjkwHhcNMjAwNjMwMTkwODE2WhcNMzAwNjI4MTkwODE2WjA+MRww\nGgYDVQQKExNsaW51eGNvbnRhaW5lcnMub3JnMR4wHAYDVQQDDBVyb290QGlwLTE3\nMi0zMS00My0xMjkwdjAQBgcqhkjOPQIBBgUrgQQAIgNiAARonk/7Lrk1hOmdErYA\nB9Qlw+EQ8083nMqRXHbuAdsfnG3Dl7lQ8SrQRP/hUnVMhTDo+c5R2pugyoXcgoK6\nyk1Vko8+Nxn1uQ0X3XNK2XR0e9n5ujzb17I6ERHE83TZmTSjajBoMA4GA1UdDwEB\n/wQEAwIFoDATBgNVHSUEDDAKBggrBgEFBQcDATAMBgNVHRMBAf8EAjAAMDMGA1Ud\nEQQsMCqCEGlwLTE3Mi0zMS00My0xMjmHBH8AAAGHEAAAAAAAAAAAAAAAAAAAAAEw\nCgYIKoZIzj0EAwMDaQAwZgIxALpU5ZuRNJiNJzi67hwkq7J3yAn8L1fCTFwda7x/\nQE6NeTJ4NIfgq64OmwLGdaEOVwIxAMhysTpAfknUZWW1dZE+oKREeA5p8/rZ0QLk\nM5FffNZCN4p+exA476G7/ux8oR3K2w==\n-----END CERTIFICATE-----\n','\n',char(10)),0);
CREATE TABLE config (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
key TEXT NOT NULL,
value TEXT,
UNIQUE (key)
);
INSERT INTO config VALUES(1,'core.trust_password','33e8f007af7eb71aaf0d153ae8a9981c47576a66831e24a23c663d6bb809717d9f7642e4f3db9fe706dd4d14d681c440ad1abeaa13d69687b9b227ebf9978f325ab8e160239984d6070e874a7e617ef8265ccd839a501e27a683eda85d207988');
CREATE TABLE nodes_failure_domains (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
UNIQUE (name)
);
CREATE TABLE IF NOT EXISTS "cluster_groups" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
UNIQUE (name)
);
INSERT INTO cluster_groups VALUES(1,'default','Default cluster group');
CREATE TABLE IF NOT EXISTS "projects" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
UNIQUE (name)
);
INSERT INTO projects VALUES(1,'default','Default LXD project');
CREATE TABLE IF NOT EXISTS "certificates_projects" (
certificate_id INTEGER NOT NULL,
project_id INTEGER NOT NULL,
FOREIGN KEY (certificate_id) REFERENCES certificates (id) ON DELETE CASCADE,
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE,
UNIQUE (certificate_id, project_id)
);
CREATE TABLE IF NOT EXISTS "images" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
fingerprint TEXT NOT NULL,
filename TEXT NOT NULL,
size INTEGER NOT NULL,
public INTEGER NOT NULL DEFAULT 0,
architecture INTEGER NOT NULL,
creation_date DATETIME,
expiry_date DATETIME,
upload_date DATETIME NOT NULL,
cached INTEGER NOT NULL DEFAULT 0,
last_use_date DATETIME,
auto_update INTEGER NOT NULL DEFAULT 0,
project_id INTEGER NOT NULL,
type INTEGER NOT NULL DEFAULT 0,
UNIQUE (project_id, fingerprint),
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
INSERT INTO images VALUES(113,'e299296138c256b79dda4e61ac7454cf4ac134b43f5521f1ac894f49a9421d00','ubuntu-20.04-server-cloudimg-amd64-lxd.tar.xz',416224064,0,2,'2022-08-24 00:00:00+00:00','2025-04-23 00:00:00+00:00','2022-08-25 04:15:52.677398165+00:00',0,'0000-12-31 17:55:36-05:50',1,1,0);
CREATE TABLE IF NOT EXISTS "images_aliases" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
image_id INTEGER NOT NULL,
description TEXT NOT NULL,
project_id INTEGER NOT NULL,
UNIQUE (project_id, name),
FOREIGN KEY (image_id) REFERENCES "images" (id) ON DELETE CASCADE,
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "nodes" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
address TEXT NOT NULL,
schema INTEGER NOT NULL,
api_extensions INTEGER NOT NULL,
heartbeat DATETIME DEFAULT CURRENT_TIMESTAMP,
state INTEGER NOT NULL DEFAULT 0,
arch INTEGER NOT NULL DEFAULT 0 CHECK (arch > 0),
failure_domain_id INTEGER DEFAULT NULL REFERENCES nodes_failure_domains (id) ON DELETE SET NULL,
UNIQUE (name),
UNIQUE (address)
);
INSERT INTO nodes VALUES(1,'lxd0','','172.31.43.129:8443',65,322,'2022-09-02 09:09:43.518541487-05:00',0,2,NULL);
CREATE TABLE IF NOT EXISTS "images_nodes" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
image_id INTEGER NOT NULL,
node_id INTEGER NOT NULL,
UNIQUE (image_id, node_id),
FOREIGN KEY (image_id) REFERENCES "images" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE
);
INSERT INTO images_nodes VALUES(113,113,1);
CREATE TABLE IF NOT EXISTS "profiles" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
project_id INTEGER NOT NULL,
UNIQUE (project_id, name),
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
INSERT INTO profiles VALUES(1,'default','Default LXD profile',1);
CREATE TABLE IF NOT EXISTS "images_profiles" (
image_id INTEGER NOT NULL,
profile_id INTEGER NOT NULL,
FOREIGN KEY (image_id) REFERENCES "images" (id) ON DELETE CASCADE,
FOREIGN KEY (profile_id) REFERENCES "profiles" (id) ON DELETE CASCADE,
UNIQUE (image_id, profile_id)
);
INSERT INTO images_profiles VALUES(113,1);
CREATE TABLE IF NOT EXISTS "images_properties" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
image_id INTEGER NOT NULL,
type INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT,
FOREIGN KEY (image_id) REFERENCES "images" (id) ON DELETE CASCADE
);
INSERT INTO images_properties VALUES(897,113,0,'description','ubuntu 20.04 LTS amd64 (release) (20220824)');
INSERT INTO images_properties VALUES(898,113,0,'type','squashfs');
INSERT INTO images_properties VALUES(899,113,0,'os','ubuntu');
INSERT INTO images_properties VALUES(900,113,0,'release','focal');
INSERT INTO images_properties VALUES(901,113,0,'version','20.04');
INSERT INTO images_properties VALUES(902,113,0,'architecture','amd64');
INSERT INTO images_properties VALUES(903,113,0,'label','release');
INSERT INTO images_properties VALUES(904,113,0,'serial','20220824');
CREATE TABLE IF NOT EXISTS "images_source" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
image_id INTEGER NOT NULL,
server TEXT NOT NULL,
protocol INTEGER NOT NULL,
certificate TEXT NOT NULL,
alias TEXT NOT NULL,
FOREIGN KEY (image_id) REFERENCES "images" (id) ON DELETE CASCADE
);
INSERT INTO images_source VALUES(113,113,'https://cloud-images.ubuntu.com/releases',2,'','20.04');
CREATE TABLE IF NOT EXISTS "instances" (
id INTEGER primary key AUTOINCREMENT NOT NULL,
node_id INTEGER NOT NULL,
name TEXT NOT NULL,
architecture INTEGER NOT NULL,
type INTEGER NOT NULL,
ephemeral INTEGER NOT NULL DEFAULT 0,
creation_date DATETIME NOT NULL DEFAULT 0,
stateful INTEGER NOT NULL DEFAULT 0,
last_use_date DATETIME,
description TEXT NOT NULL,
project_id INTEGER NOT NULL,
expiry_date DATETIME,
UNIQUE (project_id, name),
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE,
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
INSERT INTO instances VALUES(15,1,'p0',2,0,0,'2020-07-03 02:31:02.785418035-05:00',0,'2021-01-24 20:05:00.449652202+00:00','',1,'0001-01-01 00:00:00+00:00');
CREATE TABLE IF NOT EXISTS "instances_backups" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
instance_id INTEGER NOT NULL,
name VARCHAR(255) NOT NULL,
creation_date DATETIME,
expiry_date DATETIME,
container_only INTEGER NOT NULL default 0,
optimized_storage INTEGER NOT NULL default 0,
FOREIGN KEY (instance_id) REFERENCES "instances" (id) ON DELETE CASCADE,
UNIQUE (instance_id, name)
);
CREATE TABLE IF NOT EXISTS "instances_devices" (
id INTEGER primary key AUTOINCREMENT NOT NULL,
instance_id INTEGER NOT NULL,
name TEXT NOT NULL,
type INTEGER NOT NULL default 0,
FOREIGN KEY (instance_id) REFERENCES "instances" (id) ON DELETE CASCADE,
UNIQUE (instance_id, name)
);
INSERT INTO instances_devices VALUES(269,15,'jn',2);
INSERT INTO instances_devices VALUES(270,15,'yard',2);
INSERT INTO instances_devices VALUES(271,15,'eth0',1);
INSERT INTO instances_devices VALUES(272,15,'tun',3);
INSERT INTO instances_devices VALUES(273,15,'aan',2);
INSERT INTO instances_devices VALUES(274,15,'aex',2);
INSERT INTO instances_devices VALUES(275,15,'s-win',2);
INSERT INTO instances_devices VALUES(276,15,'yrch',2);
INSERT INTO instances_devices VALUES(277,15,'ipvlan',1);
INSERT INTO instances_devices VALUES(278,15,'cs',2);
INSERT INTO instances_devices VALUES(279,15,'cds',2);
INSERT INTO instances_devices VALUES(280,15,'ady',2);
INSERT INTO instances_devices VALUES(281,15,'au',2);
INSERT INTO instances_devices VALUES(282,15,'jta',2);
INSERT INTO instances_devices VALUES(283,15,'bj',2);
CREATE TABLE IF NOT EXISTS "instances_profiles" (
id INTEGER primary key AUTOINCREMENT NOT NULL,
instance_id INTEGER NOT NULL,
profile_id INTEGER NOT NULL,
apply_order INTEGER NOT NULL default 0,
UNIQUE (instance_id, profile_id),
FOREIGN KEY (instance_id) REFERENCES "instances" (id) ON DELETE CASCADE,
FOREIGN KEY (profile_id) REFERENCES "profiles"(id) ON DELETE CASCADE
);
INSERT INTO instances_profiles VALUES(112,15,1,1);
CREATE TABLE IF NOT EXISTS "instances_snapshots" (
id INTEGER primary key AUTOINCREMENT NOT NULL,
instance_id INTEGER NOT NULL,
name TEXT NOT NULL,
creation_date DATETIME NOT NULL DEFAULT 0,
stateful INTEGER NOT NULL DEFAULT 0,
description TEXT NOT NULL,
expiry_date DATETIME,
UNIQUE (instance_id, name),
FOREIGN KEY (instance_id) REFERENCES "instances" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "instances_snapshots_devices" (
id INTEGER primary key AUTOINCREMENT NOT NULL,
instance_snapshot_id INTEGER NOT NULL,
name TEXT NOT NULL,
type INTEGER NOT NULL default 0,
FOREIGN KEY (instance_snapshot_id) REFERENCES "instances_snapshots" (id) ON DELETE CASCADE,
UNIQUE (instance_snapshot_id, name)
);
CREATE TABLE IF NOT EXISTS "networks" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
project_id INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
state INTEGER NOT NULL DEFAULT 0,
type INTEGER NOT NULL DEFAULT 0,
UNIQUE (project_id, name),
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
INSERT INTO networks VALUES(1,1,'ipvlan','',1,0);
CREATE TABLE IF NOT EXISTS "networks_acls" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
project_id INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
ingress TEXT NOT NULL,
egress TEXT NOT NULL,
UNIQUE (project_id, name),
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_forwards" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_id INTEGER NOT NULL,
node_id INTEGER,
listen_address TEXT NOT NULL,
description TEXT NOT NULL,
ports TEXT NOT NULL,
UNIQUE (network_id, node_id, listen_address),
FOREIGN KEY (network_id) REFERENCES "networks" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_nodes" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_id INTEGER NOT NULL,
node_id INTEGER NOT NULL,
state INTEGER NOT NULL DEFAULT 0,
UNIQUE (network_id, node_id),
FOREIGN KEY (network_id) REFERENCES "networks" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE
);
INSERT INTO networks_nodes VALUES(1,1,1,1);
CREATE TABLE IF NOT EXISTS "networks_peers" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_id INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
target_network_project TEXT NULL,
target_network_name TEXT NULL,
target_network_id INTEGER NULL,
UNIQUE (network_id, name),
UNIQUE (network_id, target_network_project, target_network_name),
UNIQUE (network_id, target_network_id),
FOREIGN KEY (network_id) REFERENCES "networks" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_zones" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
project_id INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
UNIQUE (name),
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "nodes_roles" (
node_id INTEGER NOT NULL,
role INTEGER NOT NULL,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE,
UNIQUE (node_id, role)
);
CREATE TABLE IF NOT EXISTS "operations" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
uuid TEXT NOT NULL,
node_id TEXT NOT NULL,
type INTEGER NOT NULL DEFAULT 0,
project_id INTEGER,
UNIQUE (uuid),
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE,
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "profiles_devices" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
profile_id INTEGER NOT NULL,
name TEXT NOT NULL,
type INTEGER NOT NULL default 0,
UNIQUE (profile_id, name),
FOREIGN KEY (profile_id) REFERENCES "profiles" (id) ON DELETE CASCADE
);
INSERT INTO profiles_devices VALUES(1,1,'root',2);
CREATE TABLE IF NOT EXISTS "storage_pools" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
driver TEXT NOT NULL,
description TEXT NOT NULL,
state INTEGER NOT NULL DEFAULT 0,
UNIQUE (name)
);
INSERT INTO storage_pools VALUES(1,'local','zfs','',1);
CREATE TABLE IF NOT EXISTS "storage_pools_nodes" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
storage_pool_id INTEGER NOT NULL,
node_id INTEGER NOT NULL,
state INTEGER NOT NULL DEFAULT 0,
UNIQUE (storage_pool_id, node_id),
FOREIGN KEY (storage_pool_id) REFERENCES "storage_pools" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE
);
INSERT INTO storage_pools_nodes VALUES(1,1,1,1);
CREATE TABLE IF NOT EXISTS "storage_volumes" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
storage_pool_id INTEGER NOT NULL,
node_id INTEGER,
type INTEGER NOT NULL,
description TEXT NOT NULL,
project_id INTEGER NOT NULL,
content_type INTEGER NOT NULL DEFAULT 0,
UNIQUE (storage_pool_id, node_id, project_id, name, type),
FOREIGN KEY (storage_pool_id) REFERENCES "storage_pools" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE,
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
INSERT INTO storage_volumes VALUES(18,'p0',1,1,0,'',1,0);
INSERT INTO storage_volumes VALUES(132,'e299296138c256b79dda4e61ac7454cf4ac134b43f5521f1ac894f49a9421d00',1,1,1,'',1,0);
CREATE TABLE IF NOT EXISTS "storage_volumes_backups" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
storage_volume_id INTEGER NOT NULL,
name VARCHAR(255) NOT NULL,
creation_date DATETIME,
expiry_date DATETIME,
volume_only INTEGER NOT NULL default 0,
optimized_storage INTEGER NOT NULL default 0,
FOREIGN KEY (storage_volume_id) REFERENCES "storage_volumes" (id) ON DELETE CASCADE,
UNIQUE (storage_volume_id, name)
);
CREATE TABLE IF NOT EXISTS "storage_volumes_snapshots" (
id INTEGER NOT NULL,
storage_volume_id INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
expiry_date DATETIME,
UNIQUE (id),
UNIQUE (storage_volume_id, name),
FOREIGN KEY (storage_volume_id) REFERENCES "storage_volumes" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "warnings" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
node_id INTEGER,
project_id INTEGER,
entity_type_code INTEGER,
entity_id INTEGER,
uuid TEXT NOT NULL,
type_code INTEGER NOT NULL,
status INTEGER NOT NULL,
first_seen_date DATETIME NOT NULL,
last_seen_date DATETIME NOT NULL,
updated_date DATETIME,
last_message TEXT NOT NULL,
count INTEGER NOT NULL,
UNIQUE (uuid),
FOREIGN KEY (node_id) REFERENCES "nodes"(id) ON DELETE CASCADE,
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
INSERT INTO warnings VALUES(1,1,NULL,NULL,NULL,'85f697a9-45a8-499f-8ac9-a7e737bb9174',2,1,'2021-05-10 15:30:58.851469067-05:00','2022-08-27 04:24:57.354393438-05:00','2022-08-27 04:24:57.354393438-05:00','disk priority will be ignored',61);
INSERT INTO warnings VALUES(2,1,NULL,NULL,NULL,'27681f4d-84e3-4019-b8e9-2c56504e5d1a',12,1,'2021-05-10 15:30:58.858929398-05:00','2022-08-27 04:24:57.35933386-05:00','2022-08-27 04:24:57.35933386-05:00','swap limits will be ignored',61);
INSERT INTO warnings VALUES(3,1,NULL,NULL,NULL,'adc7c00e-d8df-432e-b9ea-eb7c0fded348',23,1,'2021-12-14 07:57:34.322266163-06:00','2022-08-27 04:24:57.374160995-05:00','2022-08-27 04:24:57.374160995-05:00','KVM support is missing (no /dev/kvm)',37);
CREATE TABLE networks_zones_records (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_zone_id INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
entries TEXT NOT NULL,
UNIQUE (name),
FOREIGN KEY (network_zone_id) REFERENCES networks_zones (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_load_balancers" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_id INTEGER NOT NULL,
node_id INTEGER,
listen_address TEXT NOT NULL,
description TEXT NOT NULL,
backends TEXT NOT NULL,
ports TEXT NOT NULL,
UNIQUE (network_id, node_id, listen_address),
FOREIGN KEY (network_id) REFERENCES "networks" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_load_balancers_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_load_balancer_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (network_load_balancer_id, key),
FOREIGN KEY (network_load_balancer_id) REFERENCES "networks_load_balancers" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "instances_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
instance_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
FOREIGN KEY (instance_id) REFERENCES "instances" (id) ON DELETE CASCADE,
UNIQUE (instance_id, key)
);
INSERT INTO instances_config VALUES(2212,15,'raw.lxc','lxc.cgroup.devices.allow = c 10:200 rwm');
INSERT INTO instances_config VALUES(2213,15,'volatile.idmap.base','0');
INSERT INTO instances_config VALUES(2214,15,'image.architecture','amd64');
INSERT INTO instances_config VALUES(2215,15,'image.description','ubuntu 20.04 LTS amd64 (release) (20200701)');
INSERT INTO instances_config VALUES(2216,15,'image.os','ubuntu');
INSERT INTO instances_config VALUES(2217,15,'security.privileged','true');
INSERT INTO instances_config VALUES(2218,15,'volatile.idmap.next','[]');
INSERT INTO instances_config VALUES(2219,15,'volatile.ipvlan.hwaddr','00:16:3e:07:03:30');
INSERT INTO instances_config VALUES(2220,15,'image.type','squashfs');
INSERT INTO instances_config VALUES(2221,15,'image.version','20.04');
INSERT INTO instances_config VALUES(2222,15,'volatile.idmap.current','[]');
INSERT INTO instances_config VALUES(2225,15,'image.label','release');
INSERT INTO instances_config VALUES(2226,15,'image.release','focal');
INSERT INTO instances_config VALUES(2227,15,'image.serial','20200701');
INSERT INTO instances_config VALUES(2228,15,'user.user-data',replace('Contp_sasl_tls_security_options = noanonymous\nsmtp_sasl_mechanism_filter = AUTH LOGIN\nEOF\n\nsystemctl restart postfix\n\n--===============8800397899945669640==--\n','\n',char(10)));
INSERT INTO instances_config VALUES(2229,15,'volatile.base_image','b4f4dad78e49ba52d901600b4ab832994eca9b7046a62715cb640175e8307542');
INSERT INTO instances_config VALUES(2231,15,'volatile.eth0.name','eth1');
INSERT INTO instances_config VALUES(2232,15,'volatile.ipvlan.name','eth0');
INSERT INTO instances_config VALUES(2233,15,'volatile.last_state.idmap','[]');
INSERT INTO instances_config VALUES(2320,15,'volatile.uuid','6af68236-f44c-4140-8c5e-6494c77bd30c');
INSERT INTO instances_config VALUES(2380,15,'volatile.eth0.last_state.created','false');
INSERT INTO instances_config VALUES(2381,15,'volatile.ipvlan.host_name','vethd0913c82');
INSERT INTO instances_config VALUES(2382,15,'volatile.last_state.power','RUNNING');
CREATE TABLE IF NOT EXISTS "instances_devices_config" (
id INTEGER primary key AUTOINCREMENT NOT NULL,
instance_device_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
FOREIGN KEY (instance_device_id) REFERENCES "instances_devices" (id) ON DELETE CASCADE,
UNIQUE (instance_device_id, key)
);
INSERT INTO instances_devices_config VALUES(878,277,'nictype','bridged');
INSERT INTO instances_devices_config VALUES(879,277,'parent','ipvlan');
INSERT INTO instances_devices_config VALUES(880,277,'type','nic');
CREATE TABLE IF NOT EXISTS "instances_snapshots_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
instance_snapshot_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
FOREIGN KEY (instance_snapshot_id) REFERENCES "instances_snapshots" (id) ON DELETE CASCADE,
UNIQUE (instance_snapshot_id, key)
);
CREATE TABLE IF NOT EXISTS "instances_snapshots_devices_config" (
id INTEGER primary key AUTOINCREMENT NOT NULL,
instance_snapshot_device_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
FOREIGN KEY (instance_snapshot_device_id) REFERENCES "instances_snapshots_devices" (id) ON DELETE CASCADE,
UNIQUE (instance_snapshot_device_id, key)
);
CREATE TABLE IF NOT EXISTS "networks_acls_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_acl_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (network_acl_id, key),
FOREIGN KEY (network_acl_id) REFERENCES "networks_acls" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_id INTEGER NOT NULL,
node_id INTEGER,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (network_id, node_id, key),
FOREIGN KEY (network_id) REFERENCES "networks" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE
);
INSERT INTO networks_config VALUES(1,1,NULL,'ipv6.address','fd42:83e1:79f9:f9e4::1/64');
INSERT INTO networks_config VALUES(2,1,NULL,'ipv6.nat','true');
INSERT INTO networks_config VALUES(3,1,NULL,'ipv4.address','10.84.63.1/24');
INSERT INTO networks_config VALUES(4,1,NULL,'ipv4.nat','true');
CREATE TABLE IF NOT EXISTS "networks_forwards_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_forward_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (network_forward_id, key),
FOREIGN KEY (network_forward_id) REFERENCES "networks_forwards" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_peers_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_peer_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (network_peer_id, key),
FOREIGN KEY (network_peer_id) REFERENCES "networks_peers" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_zones_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_zone_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (network_zone_id, key),
FOREIGN KEY (network_zone_id) REFERENCES "networks_zones" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "networks_zones_records_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
network_zone_record_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (network_zone_record_id, key),
FOREIGN KEY (network_zone_record_id) REFERENCES networks_zones_records (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "nodes_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
node_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE,
UNIQUE (node_id, key)
);
CREATE TABLE IF NOT EXISTS "profiles_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
profile_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (profile_id, key),
FOREIGN KEY (profile_id) REFERENCES "profiles"(id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "profiles_devices_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
profile_device_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (profile_device_id, key),
FOREIGN KEY (profile_device_id) REFERENCES "profiles_devices" (id) ON DELETE CASCADE
);
INSERT INTO profiles_devices_config VALUES(1,1,'path','/');
INSERT INTO profiles_devices_config VALUES(2,1,'pool','local');
INSERT INTO profiles_devices_config VALUES(3,1,'type','disk');
CREATE TABLE IF NOT EXISTS "projects_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
project_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE,
UNIQUE (project_id, key)
);
INSERT INTO projects_config VALUES(1,1,'features.images','true');
INSERT INTO projects_config VALUES(2,1,'features.profiles','true');
INSERT INTO projects_config VALUES(3,1,'features.storage.volumes','true');
INSERT INTO projects_config VALUES(4,1,'features.networks','true');
INSERT INTO projects_config VALUES(5,1,'features.storage.buckets','true');
CREATE TABLE IF NOT EXISTS "storage_pools_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
storage_pool_id INTEGER NOT NULL,
node_id INTEGER,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (storage_pool_id, node_id, key),
FOREIGN KEY (storage_pool_id) REFERENCES "storage_pools" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE
);
INSERT INTO storage_pools_config VALUES(3,1,1,'zfs.pool_name','local');
INSERT INTO storage_pools_config VALUES(4,1,1,'source','local');
INSERT INTO storage_pools_config VALUES(5,1,1,'volatile.initial_source','/dev/nvme2n1');
CREATE TABLE IF NOT EXISTS "storage_volumes_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
storage_volume_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (storage_volume_id, key),
FOREIGN KEY (storage_volume_id) REFERENCES "storage_volumes" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "storage_volumes_snapshots_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
storage_volume_snapshot_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
FOREIGN KEY (storage_volume_snapshot_id) REFERENCES "storage_volumes_snapshots" (id) ON DELETE CASCADE,
UNIQUE (storage_volume_snapshot_id, key)
);
CREATE TABLE IF NOT EXISTS "storage_buckets" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name TEXT NOT NULL,
storage_pool_id INTEGER NOT NULL,
node_id INTEGER,
description TEXT NOT NULL,
project_id INTEGER NOT NULL,
UNIQUE (node_id, name),
FOREIGN KEY (storage_pool_id) REFERENCES "storage_pools" (id) ON DELETE CASCADE,
FOREIGN KEY (node_id) REFERENCES "nodes" (id) ON DELETE CASCADE,
FOREIGN KEY (project_id) REFERENCES "projects" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "storage_buckets_config" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
storage_bucket_id INTEGER NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
UNIQUE (storage_bucket_id, key),
FOREIGN KEY (storage_bucket_id) REFERENCES "storage_buckets" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "storage_buckets_keys" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
storage_bucket_id INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
access_key TEXT NOT NULL,
secret_key TEXT NOT NULL,
role TEXT NOT NULL,
UNIQUE (storage_bucket_id, name),
FOREIGN KEY (storage_bucket_id) REFERENCES "storage_buckets" (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "nodes_cluster_groups" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
node_id INTEGER NOT NULL,
group_id INTEGER NOT NULL,
FOREIGN KEY (node_id) REFERENCES nodes (id) ON DELETE CASCADE,
FOREIGN KEY (group_id) REFERENCES cluster_groups (id) ON DELETE CASCADE,
UNIQUE (node_id, group_id)
);
INSERT INTO nodes_cluster_groups VALUES(1,1,1);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('schema',36);
INSERT INTO sqlite_sequence VALUES('config',1);
INSERT INTO sqlite_sequence VALUES('certificates',1);
INSERT INTO sqlite_sequence VALUES('cluster_groups',1);
INSERT INTO sqlite_sequence VALUES('projects',1);
INSERT INTO sqlite_sequence VALUES('images',113);
INSERT INTO sqlite_sequence VALUES('images_aliases',0);
INSERT INTO sqlite_sequence VALUES('nodes',1);
INSERT INTO sqlite_sequence VALUES('images_nodes',113);
INSERT INTO sqlite_sequence VALUES('profiles',1);
INSERT INTO sqlite_sequence VALUES('images_properties',904);
INSERT INTO sqlite_sequence VALUES('images_source',113);
INSERT INTO sqlite_sequence VALUES('instances',15);
INSERT INTO sqlite_sequence VALUES('instances_backups',0);
INSERT INTO sqlite_sequence VALUES('instances_devices',283);
INSERT INTO sqlite_sequence VALUES('instances_profiles',112);
INSERT INTO sqlite_sequence VALUES('instances_snapshots',0);
INSERT INTO sqlite_sequence VALUES('instances_snapshots_devices',0);
INSERT INTO sqlite_sequence VALUES('networks',1);
INSERT INTO sqlite_sequence VALUES('networks_acls',0);
INSERT INTO sqlite_sequence VALUES('networks_forwards',0);
INSERT INTO sqlite_sequence VALUES('networks_nodes',1);
INSERT INTO sqlite_sequence VALUES('networks_peers',0);
INSERT INTO sqlite_sequence VALUES('networks_zones',0);
INSERT INTO sqlite_sequence VALUES('operations',20956);
INSERT INTO sqlite_sequence VALUES('profiles_devices',1);
INSERT INTO sqlite_sequence VALUES('storage_pools',1);
INSERT INTO sqlite_sequence VALUES('storage_pools_nodes',1);
INSERT INTO sqlite_sequence VALUES('storage_volumes',132);
INSERT INTO sqlite_sequence VALUES('storage_volumes_backups',0);
INSERT INTO sqlite_sequence VALUES('warnings',3);
INSERT INTO sqlite_sequence VALUES('instances_config',2382);
INSERT INTO sqlite_sequence VALUES('instances_devices_config',898);
INSERT INTO sqlite_sequence VALUES('instances_snapshots_config',0);
INSERT INTO sqlite_sequence VALUES('instances_snapshots_devices_config',0);
INSERT INTO sqlite_sequence VALUES('networks_acls_config',0);
INSERT INTO sqlite_sequence VALUES('networks_config',4);
INSERT INTO sqlite_sequence VALUES('networks_forwards_config',0);
INSERT INTO sqlite_sequence VALUES('networks_peers_config',0);
INSERT INTO sqlite_sequence VALUES('networks_zones_config',0);
INSERT INTO sqlite_sequence VALUES('networks_zones_records_config',0);
INSERT INTO sqlite_sequence VALUES('nodes_config',0);
INSERT INTO sqlite_sequence VALUES('profiles_config',0);
INSERT INTO sqlite_sequence VALUES('profiles_devices_config',3);
INSERT INTO sqlite_sequence VALUES('projects_config',5);
INSERT INTO sqlite_sequence VALUES('storage_pools_config',5);
INSERT INTO sqlite_sequence VALUES('storage_volumes_config',0);
INSERT INTO sqlite_sequence VALUES('storage_volumes_snapshots_config',0);
INSERT INTO sqlite_sequence VALUES('nodes_cluster_groups',1);
CREATE INDEX images_aliases_project_id_idx ON images_aliases (project_id);
CREATE INDEX images_project_id_idx ON images (project_id);
CREATE INDEX instances_project_id_and_name_idx ON instances (project_id, name);
CREATE INDEX instances_project_id_and_node_id_and_name_idx ON instances (project_id, node_id, name);
CREATE INDEX instances_project_id_and_node_id_idx ON instances (project_id, node_id);
CREATE INDEX instances_project_id_idx ON instances (project_id);
CREATE INDEX instances_node_id_idx ON instances (node_id);
CREATE INDEX profiles_project_id_idx ON profiles (project_id);
CREATE UNIQUE INDEX warnings_unique_node_id_project_id_entity_type_code_entity_id_type_code ON warnings(IFNULL(node_id, -1), IFNULL(project_id, -1), entity_type_code, entity_id, type_code);
CREATE TRIGGER storage_volumes_check_id
BEFORE INSERT ON storage_volumes
WHEN NEW.id IN (SELECT id FROM storage_volumes_snapshots)
BEGIN
SELECT RAISE(FAIL,
"invalid ID");
END;
CREATE TRIGGER storage_volumes_snapshots_check_id
BEFORE INSERT ON storage_volumes_snapshots
WHEN NEW.id IN (SELECT id FROM storage_volumes)
BEGIN
SELECT RAISE(FAIL,
"invalid ID");
END;
CREATE VIEW storage_volumes_all (
id,
name,
storage_pool_id,
node_id,
type,
description,
project_id,
content_type) AS
SELECT id,
name,
storage_pool_id,
node_id,
type,
description,
project_id,
content_type
FROM storage_volumes UNION
SELECT storage_volumes_snapshots.id,
printf('%s/%s',
storage_volumes.name,
storage_volumes_snapshots.name),
storage_volumes.storage_pool_id,
storage_volumes.node_id,
storage_volumes.type,
storage_volumes_snapshots.description,
storage_volumes.project_id,
storage_volumes.content_type
FROM storage_volumes
JOIN storage_volumes_snapshots ON storage_volumes.id = storage_volumes_snapshots.storage_volume_id;
CREATE UNIQUE INDEX networks_unique_network_id_node_id_key ON "networks_config" (network_id, IFNULL(node_id, -1), key);
CREATE UNIQUE INDEX storage_pools_unique_storage_pool_id_node_id_key ON storage_pools_config (storage_pool_id, IFNULL(node_id, -1), key);
CREATE UNIQUE INDEX storage_volumes_unique_storage_pool_id_node_id_project_id_name_type ON "storage_volumes" (storage_pool_id, IFNULL(node_id, -1), project_id, name, type);
CREATE UNIQUE INDEX storage_buckets_unique_storage_pool_id_node_id_name ON "storage_buckets" (storage_pool_id, IFNULL(node_id, -1), name);
COMMIT;