james-l
2/2/2017 - 12:16 AM

Create Table in MySQL MySQL中建表

BEGIN;

DROP TABLE IF EXISTS file_info;

CREATE TABLE file_info(
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  md5 CHAR(32),
  sha256 CHAR(64),
  type_id TINYINT(1) UNSIGNED REFERENCES file_type(id),
  host_id TINYINT(1) UNSIGNED REFERENCES file_host(id),
  path VARCHAR(256) NOT NULL,
  virus VARCHAR(128),
  risk_score TINYINT(1),
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY(id),
  UNIQUE INDEX idx_md5(md5),
  UNIQUE INDEX idx_sha256(sha256)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE utf8_general_ci;

COMMIT;