-- Agency Doorlock — database table (auto-created on first start, this is a manual fallback)
CREATE TABLE IF NOT EXISTS `agency_doorlock` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(64) NOT NULL DEFAULT 'Door',
    `locked` TINYINT(1) NOT NULL DEFAULT 1,
    `doors` LONGTEXT NOT NULL,
    `access` LONGTEXT NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
