编辑代码

CREATE TABLE Users (
    UserID INT AUTO_INCREMENT PRIMARY KEY,
    Username VARCHAR(50) NOT NULL UNIQUE,
    Password VARCHAR(255) NOT NULL,
    Email VARCHAR(100) NOT NULL UNIQUE,
    Phone VARCHAR(20),
    RealName VARCHAR(50),
    IDCard VARCHAR(18),
    Sex ENUM('男','女','其他'),
    RegisterDate DATETIME DEFAULT CURRENT_TIMESTAMP,
    LastLogin DATETIME,
    Status TINYINT DEFAULT 1 COMMENT '1-正常, 0-禁用'
);