s3browser-backend/internal/db/setup.sql

12 lines
279 B
MySQL
Raw Permalink Normal View History

2021-10-20 14:11:18 +00:00
CREATE TABLE s3Browser.`user` (
id INT auto_increment NOT NULL,
username varchar(100) NOT NULL,
password varchar(60) NOT NULL,
CONSTRAINT user_PK PRIMARY KEY (id),
CONSTRAINT user_UN UNIQUE KEY (username)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_general_ci;