CREATE TABLE trans_closes (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  table_name VARCHAR(80) COMMENT "テーブル名",
  close_date DATE COMMENT "締め日",
  created_at DATETIME COMMENT "作成日時",
  updated_at DATETIME COMMENT "更新日時"
) type=InnoDB;

INSERT INTO trans_closes SET table_name="sales", created_at=NOW(), updated_at=NOW();
INSERT INTO trans_closes SET table_name="receivables", created_at=NOW(), updated_at=NOW();
INSERT INTO trans_closes SET table_name="payables", created_at=NOW(), updated_at=NOW();


