go-sample-webpage/database/migrations/1_initialize_schema.up.sql

10 lines
281 B
MySQL
Raw Permalink Normal View History

2021-11-08 01:25:36 +00:00
CREATE TABLE user (
2021-11-22 22:11:37 +00:00
id MEDIUMINT NOT NULL AUTO_INCREMENT,
mail VARCHAR(250) NOT NULL UNIQUE,
2021-11-24 02:27:07 +00:00
mailValidationCode VARCHAR(250),
2021-11-22 22:11:37 +00:00
mailValidate TINYINT(1) DEFAULT '0',
username VARCHAR(250) NOT NULL UNIQUE,
password VARCHAR(250) NOT NuLL,
2021-11-08 01:25:36 +00:00
2021-11-22 22:11:37 +00:00
PRIMARY KEY(id)
);