DROP TABLE IF EXISTS `btdev_list`;
CREATE TABLE `btdev_list` (
	`name` VARCHAR(16) NOT NULL,
	`address` BIGINT UNSIGNED NOT NULL,
	PRIMARY KEY (`name`)
);

DROP TABLE IF EXISTS `btdev_status`;
CREATE TABLE `btdev_status` (
	`dev_name` VARCHAR(16) NOT NULL,
	`host` VARCHAR(16) NOT NULL,
	`last_seen` DATETIME,
	PRIMARY KEY (`dev_name`, `host`)
);