CREATE DATABASE IF NOT EXISTS `bcr_life` DEFAULT CHARACTER SET utf8mb4;
USE `bcr_life`;

CREATE TABLE IF NOT EXISTS `accounts` (
  `UID` SERIAL,
  `Social_ID` VARCHAR(16),
  `Name` VARCHAR(24),
  `Password` VARCHAR(256),
  `Access` SMALLINT,
  `Cash` INT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;