使用MySQL创建简单修订系统的最佳方法是什么？

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL
);

CREATE TABLE documents (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  description TEXT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE revisions (
  id INT AUTO_INCREMENT PRIMARY KEY,
  document_id INT NOT NULL,
  user_id INT NOT NULL,
  revision_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  revision_comment TEXT,
  FOREIGN KEY (document_id) REFERENCES documents(id),
  FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO users (username, password, email) VALUES ('user1', 'password1', 'user1@example.com');
INSERT INTO documents (title, description) VALUES ('My Document', 'This is a sample document.');
INSERT INTO revisions (document_id, user_id, revision_comment) VALUES (1, 1, 'Initial revision.');

SELECT * FROM revisions WHERE document_id = 1;
SELECT * FROM revisions WHERE id = 1;

UPDATE revisions SET revision_comment = 'Updated revision comment.' WHERE id = 1;
DELETE FROM revisions WHERE id = 1;