install.sql

-- onetime setup for the api database
CREATE USER IF NOT EXISTS apiuser IDENTIFIED BY 'CHANGEME';
DROP DATABASE IF EXISTS api;
CREATE DATABASE IF NOT EXISTS api;
USE api;
GRANT INSERT, SELECT, UPDATE, DELETE ON api.* TO apiuser;

CREATE TABLE IF NOT EXISTS accounts (
  id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(25) NOT NULL,
  password VARCHAR(60) NOT NULL,
  email VARCHAR(25) NOT NULL
);