- add grants table
CREATE TABLE grants
(
ID
int NOT NULL,
amount
varchar(45) NOT NULL,
updated
datetime DEFAULT NULL,
PRIMARY KEY (ID
),
UNIQUE KEY ID_UNIQUE
(ID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
- add Users table
CREATE TABLE users
(
idusers
int NOT NULL,
login
varchar(45) NOT NULL,
password
varchar(45) NOT NULL,
role
varchar(45) NOT NULL,
PRIMARY KEY (idusers
),
UNIQUE KEY idusers_UNIQUE
(idusers
),
UNIQUE KEY login_UNIQUE
(login
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;