Code: Select all
CREATE TABLE user_data.accounts (
ID int(11) NOT NULL,
Email varchar(255) DEFAULT NULL,
MobilePhone varchar(32) DEFAULT NULL,
PasswordHash varchar(255) DEFAULT NULL,
PRIMARY KEY (ID)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 8192,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;