`/var/snap/lxd/common/lxd/database/local.db` before running `lxd init`

local.db

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,39,1593510249);
CREATE TABLE config (
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    key VARCHAR(255) NOT NULL,
    value TEXT,
    UNIQUE (key)
);
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,'shrink_logs_db_file',1593510249);
INSERT INTO patches VALUES(2,'invalid_profile_names',1593510249);
INSERT INTO patches VALUES(3,'leftover_profile_config',1593510249);
INSERT INTO patches VALUES(4,'network_permissions',1593510249);
INSERT INTO patches VALUES(5,'storage_api',1593510249);
INSERT INTO patches VALUES(6,'storage_api_v1',1593510250);
INSERT INTO patches VALUES(7,'storage_api_dir_cleanup',1593510250);
INSERT INTO patches VALUES(8,'storage_api_lvm_keys',1593510250);
INSERT INTO patches VALUES(9,'storage_api_keys',1593510250);
INSERT INTO patches VALUES(10,'storage_api_update_storage_configs',1593510250);
INSERT INTO patches VALUES(11,'storage_api_lxd_on_btrfs',1593510250);
INSERT INTO patches VALUES(12,'storage_api_lvm_detect_lv_size',1593510250);
INSERT INTO patches VALUES(13,'storage_api_insert_zfs_driver',1593510250);
INSERT INTO patches VALUES(14,'storage_zfs_noauto',1593510250);
INSERT INTO patches VALUES(15,'storage_zfs_volume_size',1593510250);
INSERT INTO patches VALUES(16,'network_dnsmasq_hosts',1593510250);
INSERT INTO patches VALUES(17,'storage_api_dir_bind_mount',1593510250);
INSERT INTO patches VALUES(18,'fix_uploaded_at',1593510250);
INSERT INTO patches VALUES(19,'storage_api_ceph_size_remove',1593510250);
INSERT INTO patches VALUES(20,'devices_new_naming_scheme',1593510250);
INSERT INTO patches VALUES(21,'storage_api_permissions',1593510250);
INSERT INTO patches VALUES(22,'container_config_regen',1593510250);
INSERT INTO patches VALUES(23,'lvm_node_specific_config_keys',1593510250);
INSERT INTO patches VALUES(24,'candid_rename_config_key',1593510250);
INSERT INTO patches VALUES(25,'move_backups',1593510250);
INSERT INTO patches VALUES(26,'storage_api_rename_container_snapshots_dir',1593510250);
INSERT INTO patches VALUES(27,'storage_api_rename_container_snapshots_links',1593510250);
INSERT INTO patches VALUES(28,'fix_lvm_pool_volume_names',1593510250);
INSERT INTO patches VALUES(29,'storage_api_rename_container_snapshots_dir_again',1593510250);
INSERT INTO patches VALUES(30,'storage_api_rename_container_snapshots_links_again',1593510250);
INSERT INTO patches VALUES(31,'storage_api_rename_container_snapshots_dir_again_again',1593510250);
INSERT INTO patches VALUES(32,'clustering_add_roles',1593510250);
INSERT INTO patches VALUES(33,'clustering_add_roles_again',1593510250);
INSERT INTO patches VALUES(34,'storage_create_vm',1593510250);
INSERT INTO patches VALUES(35,'storage_zfs_mount',1593510250);
INSERT INTO patches VALUES(36,'network_pid_files',1593510250);
INSERT INTO patches VALUES(37,'storage_create_vm_again',1593510250);
INSERT INTO patches VALUES(38,'storage_zfs_volmode',1593510250);
INSERT INTO patches VALUES(39,'storage_rename_custom_volume_add_project',1593510250);
INSERT INTO patches VALUES(40,'storage_lvm_skipactivation',1593510250);
CREATE TABLE raft_nodes (
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    address TEXT NOT NULL,
    role INTEGER NOT NULL DEFAULT 0,
    UNIQUE (address)
);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('schema',1);
INSERT INTO sqlite_sequence VALUES('patches',40);
COMMIT;