~$ sudo sqlite3 /var/snap/lxd/common/lxd/database/local.db .dump
[sudo] password for jeff:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE config (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
key VARCHAR(255) NOT NULL,
value TEXT,
UNIQUE (key)
);
INSERT INTO config VALUES(2,'cluster.https_address','192.168.1.20:8443');
INSERT INTO config VALUES(5,'core.https_address','192.168.1.20');
CREATE TABLE patches (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name VARCHAR(255) NOT NULL,
applied_at DATETIME NOT NULL,
UNIQUE (name)
);
INSERT INTO patches VALUES(1,'invalid_profile_names',1520761002);
INSERT INTO patches VALUES(2,'leftover_profile_config',1520761002);
INSERT INTO patches VALUES(3,'fix_uploaded_at',1520761002);
INSERT INTO patches VALUES(4,'shrink_logs_db_file',1563410920);
INSERT INTO patches VALUES(5,'network_permissions',1563410920);
INSERT INTO patches VALUES(6,'storage_api',1563410920);
INSERT INTO patches VALUES(7,'storage_api_v1',1563410920);
INSERT INTO patches VALUES(8,'storage_api_dir_cleanup',1563410920);
INSERT INTO patches VALUES(9,'storage_api_lvm_keys',1563410920);
INSERT INTO patches VALUES(10,'storage_api_keys',1563410920);
INSERT INTO patches VALUES(11,'storage_api_update_storage_configs',1563410920);
INSERT INTO patches VALUES(12,'storage_api_lxd_on_btrfs',1563410920);
INSERT INTO patches VALUES(13,'storage_api_lvm_detect_lv_size',1563410921);
INSERT INTO patches VALUES(14,'storage_api_insert_zfs_driver',1563410921);
INSERT INTO patches VALUES(15,'storage_zfs_noauto',1563410921);
INSERT INTO patches VALUES(16,'storage_zfs_volume_size',1563410921);
INSERT INTO patches VALUES(17,'network_dnsmasq_hosts',1563410921);
INSERT INTO patches VALUES(18,'storage_api_dir_bind_mount',1563410921);
INSERT INTO patches VALUES(19,'storage_api_ceph_size_remove',1563410921);
INSERT INTO patches VALUES(20,'devices_new_naming_scheme',1563410921);
INSERT INTO patches VALUES(21,'storage_api_permissions',1563410921);
INSERT INTO patches VALUES(22,'container_config_regen',1563410921);
INSERT INTO patches VALUES(23,'lvm_node_specific_config_keys',1563410921);
INSERT INTO patches VALUES(24,'candid_rename_config_key',1563410921);
INSERT INTO patches VALUES(25,'move_backups',1590893621);
INSERT INTO patches VALUES(26,'storage_api_rename_container_snapshots_dir',1590893621);
INSERT INTO patches VALUES(27,'storage_api_rename_container_snapshots_links',1590893621);
INSERT INTO patches VALUES(28,'fix_lvm_pool_volume_names',1590893621);
INSERT INTO patches VALUES(29,'storage_api_rename_container_snapshots_dir_again',1590893621);
INSERT INTO patches VALUES(30,'storage_api_rename_container_snapshots_links_again',1590893621);
INSERT INTO patches VALUES(31,'storage_api_rename_container_snapshots_dir_again_again',1590893621);
INSERT INTO patches VALUES(32,'clustering_add_roles',1590893621);
INSERT INTO patches VALUES(33,'clustering_add_roles_again',1590893621);
INSERT INTO patches VALUES(34,'storage_create_vm',1590893623);
INSERT INTO patches VALUES(35,'storage_zfs_mount',1590893623);
INSERT INTO patches VALUES(36,'network_pid_files',1590893623);
INSERT INTO patches VALUES(37,'storage_create_vm_again',1590893623);
INSERT INTO patches VALUES(38,'storage_zfs_volmode',1590893623);
INSERT INTO patches VALUES(39,'storage_rename_custom_volume_add_project',1590893623);
INSERT INTO patches VALUES(40,'storage_lvm_skipactivation',1590893623);
INSERT INTO patches VALUES(41,'clustering_drop_database_role',1593591867);
INSERT INTO patches VALUES(42,'network_clear_bridge_volatile_hwaddr',1597784375);
INSERT INTO patches VALUES(43,'network_fan_enable_nat',1604432066);
INSERT INTO patches VALUES(44,'thinpool_typo_fix',1612193179);
INSERT INTO patches VALUES(45,'vm_rename_uuid_key',1612193179);
INSERT INTO patches VALUES(46,'db_nodes_autoinc',1620309121);
INSERT INTO patches VALUES(47,'clustering_server_cert_trust',1626786707);
INSERT INTO patches VALUES(48,'dnsmasq_entries_include_device_name',1645685425);
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,32,1520761002);
INSERT INTO schema VALUES(2,33,1563410920);
INSERT INTO schema VALUES(3,34,1563410920);
INSERT INTO schema VALUES(4,35,1563410920);
INSERT INTO schema VALUES(5,36,1563410920);
INSERT INTO schema VALUES(6,37,1563410920);
INSERT INTO schema VALUES(7,38,1590893621);
INSERT INTO schema VALUES(8,39,1590893621);
INSERT INTO schema VALUES(9,40,1594330676);
INSERT INTO schema VALUES(10,41,1626786706);
INSERT INTO schema VALUES(11,42,1635811973);
CREATE TABLE raft_nodes (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
address TEXT NOT NULL, role INTEGER NOT NULL DEFAULT 0, name TEXT NOT NULL default "",
UNIQUE (address)
);
INSERT INTO raft_nodes VALUES(1,'0',0,'');
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,
UNIQUE (fingerprint)
);
INSERT INTO certificates VALUES(1828,'2b5c8c5646b88fef9979ff25101937e35c0296230214e02dcb228b8c5cf5c12f',2,'cojoserver',replace('-----BEGIN CERTIFICATE-----\nMIIFcDCCA1igAwIBAgIQT79QP/DrV/MB3wGAHL3mPzANBgkqhkiG9w0BAQsFADA4\nMRwwGgYDVQQKExNsaW51eGNvbnRhaW5lcnMub3JnMRgwFgYDVQQDDA9yb290QGNv\nam9zZXJ2ZXIwHhcNMTgwMzExMDkzNjQ0WhcNMjgwMzA4MDkzNjQ0WjA4MRwwGgYD\nVQQKExNsaW51eGNvbnRhaW5lcnMub3JnMRgwFgYDVQQDDA9yb290QGNvam9zZXJ2\nZXIwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQCy1ojWo9yse1lr1Lp7\nlZAUq5SxVZXaFJwm1aqFQ+aiY1J975Yn6uPy4EnA0/VD2nuaL8T4PI2lEwCHOsZV\n53RkjsPh99O64Q6dEUd6GvGjBFacW6jCYbN1DJx6JhEI2wzoTs6WIOs69z7UVM6i\nX0DZMA0h4TeGFMmSwTJr417/+TLf/Xj2N6NpAIBXab8Ops+bGFIlamSwFKoy0CaN\nTgjzTjrQ2QQZnPYVsSmZAJz8zPN5UUj88rkm4KVr8cErQpt6Cw5UXeRSwWR1oO8W\nGLG/EWZP8VO7oc7lDjTmxEog1Uv2dO2jJ4giT36zeyWo258OsraWPptJ4dBCubbH\n228THJhgp8s67JEVSOnBuTSip+tVOS+NcVc8D0VldUTg5YKv5GYTQDTWwAa4DF44\nwrRUv2W/Lo//ypbRnzF6ytBOdQ+9e3ZzpUh1WYDn+DlRXUCmsjRzmU8kTP2nLBvt\ntjPb9o45jtPso3MvY/3Tz7pQEihX+YR8dQ+aGziMD/k8ejKdZOsQrFGfF6r/4MyU\nrwpAyG4vxt+j+kzmdnynjJ6Rzyi82SHO09CogkylbAbABFi1Tisa/0dBr7GGf2jt\nBUjEOENuqfqQ2EwUsEqzGIgWwP8u3OvqfrkwycGcbTkDI0pwyZYcdDdiXyX0Fb5A\nONWHJm7VPluvjMwGPwZOK3eznwIDAQABo3YwdDAOBgNVHQ8BAf8EBAMCBaAwEwYD\nVR0lBAwwCgYIKwYBBQUHAwEwDAYDVR0TAQH/BAIwADA/BgNVHREEODA2ggpjb2pv\nc2VydmVyhwTAqAEUhxAmAIgFMgAFz6lCoZLMudW/hxAmAIgFMgAFzxK/SP/+2BO0\nMA0GCSqGSIb3DQEBCwUAA4ICAQAnL3k9iBdli9rewSTY0+q/PcSHWiPO7DlrRx+S\niPwoZWeKh6jnugRodpxDI+3Y6ohrWLydhA7+qB+VvULZTpsJp+76ZyFwxGJL8bvS\nSrBoIrs4HS/W7lmeIIgaN4zdf3pd8ZEJpp9y3UhRq3hyyO/LzevmQ18A7GUb+QB1\n8JOU53vDUyTTPpOii1oCgkDfyobPo0Ni2u+umbJ2ESfWDvFh6L+jic6A6BYuDjzL\n4Yn+rPXt7TzG6xami18Bj0UiYEYz6UPqcLU7GD9s1TULXjeVP5e2ujQwCLn1s5uM\n0EpyDzQ2CNipjpC5IbcEK1V36pyDaU/y7F2pceqPWNzeMzkWZ+VcI2uowdyEIS1p\nokNHOMD7qONMYb1nJWXLRL0i3f1OCc5F5NrjGlOirx2TzLWM7AmkIWnXo64MvYGw\najA9YPt8s37nL3db9An+sdBVCVXbDvdl6nEFFqUp9172UQJROsK0VZiZA0V5qeXo\n8mhFEC9psDk9MTrHePc/1FWQ1+by4YWlsHm//Npmci54bA81jdvrfZtod2QB6auT\nBhHbzC3DJpOu3+TlBGd4vZcSEE91Q7XvA4KayYqeCdoS/eNTV+R3t9IOQUAsU5r/\nWuxT0eZVd2nu9h+bZ9K7ET1Fb9JhUWZq+D+13EVlfA2Sx94U3vuONefTPa6DJBkD\nFaNhRg==\n-----END CERTIFICATE-----\n','\n',char(10)));
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('schema',11);
INSERT INTO sqlite_sequence VALUES('patches',48);
INSERT INTO sqlite_sequence VALUES('config',5);
INSERT INTO sqlite_sequence VALUES('raft_nodes',1);
INSERT INTO sqlite_sequence VALUES('certificates',1828);
COMMIT;