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-禁用'
);