· 8 years ago · Jan 19, 2018, 09:36 PM
1CREATE DATABASE IF NOT EXISTS `bcr_life` DEFAULT CHARACTER SET utf8mb4;
2USE `bcr_life`;
3
4CREATE TABLE IF NOT EXISTS `accounts` (
5 `UID` SERIAL,
6 `Social_ID` VARCHAR(16),
7 `Name` VARCHAR(24),
8 `Password` VARCHAR(256),
9 `Access` SMALLINT,
10 `Cash` INT
11) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;