基于商标视角的学生管理信息系统在安徽的应用与实现

CREATE TABLE Trademark (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(100) NOT NULL,

description TEXT,

image BLOB

);

]]>

-- 创建用户角色

GRANT SELECT, INSERT ON Trademark TO 'student_admin'@'localhost';

-- 设置密码

ALTER USER 'student_admin'@'localhost' IDENTIFIED BY 'secure_password';

]]>

CREATE TABLE Log (

id INT PRIMARY KEY AUTO_INCREMENT,

trademark_id INT,

user_id INT,

action ENUM('view', 'edit') NOT NULL,

timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,

FOREIGN KEY (trademark_id) REFERENCES Trademark(id),

FOREIGN KEY (user_id) REFERENCES Users(id)

);

]]>