htmlhouse/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;