init.sql

DROP TABLE IF EXISTS `houses`;
CREATE TABLE `houses` (
 `id` char(8) COLLATE utf8mb4_bin NOT NULL,
 `view_count` INT(6) NOT NULL,
 `html` text COLLATE utf8mb4_bin NOT NULL,
 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

DROP TABLE IF EXISTS `publichouses`;
CREATE TABLE `publichouses` (
 `house_id` char(8) NOT NULL,
 `title` varchar(128) COLLATE utf8mb4_bin NOT NULL,
 `thumb_url` varchar(28) NOT NULL,
 `added` datetime NOT NULL,
 `updated` datetime NOT NULL,
 `approved` tinyint(1) DEFAULT NULL,
 `loves` int(4) NOT NULL,
 PRIMARY KEY (`house_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE IF NOT EXISTS `tweetedhouses` (
 `house_id` char(8) NOT NULL,
 `tweet_id` bigint(20) unsigned NOT NULL,
 PRIMARY KEY (`house_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;