SQL for LD33 entry tables

ld33-tables.sql

CREATE DATABASE IF NOT EXISTS `ld33` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `ld33`;

CREATE TABLE IF NOT EXISTS `player` (
  `uuid` varchar(36) NOT NULL,
  `name` varchar(256) NOT NULL,
  `password_hash` varchar(256) NOT NULL,
  `password_salt` varchar(256) NOT NULL,
  `resources` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `unit` (
  `uuid` varchar(36) DEFAULT NULL,
  `player_uuid` varchar(36) DEFAULT NULL,
  `health` int(11) DEFAULT NULL,
  `max_health` int(11) DEFAULT NULL,
  `solid` tinyint(1) DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `type` varchar(256) DEFAULT NULL,
  `completion_time` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `player`
 ADD PRIMARY KEY (`uuid`);

ALTER TABLE `unit`
 ADD KEY `player_uuid` (`player_uuid`);