resources/sql/001-users.up.sql

CREATE SCHEMA blog;

CREATE TABLE blog.Users (
       ID SERIAL,
       Username VARCHAR(100) NOT NULL UNIQUE,
       Password CHAR(128) NOT NULL, 	--SHA-512
       Nickname VARCHAR(1000) NOT NULL DEFAULT '',
       Img_location VARCHAR(2000),
       PRIMARY KEY(ID));