· 7 years ago · Dec 23, 2018, 06:24 PM
1CREATE TABLE IF NOT EXISTS 'user' (
2 'id' INT NOT NULL AUTO_INCREMENT,
3 'registerDate' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
4 'login' VARCHAR(255) NOT NULL,
5 'password' VARCHAR(255) NOT NULL,
6 'status' TINYINT NOT NULL,
7 'credits' INT NOT NULL DEFAULT 0,
8 PRIMARY KEY ('id'),
9 UNIQUE INDEX 'login_UNIQUE' ('login' ASC) VISIBLE)
10ENGINE = InnoDB;