CREATE TABLE invoice_additional_documents (
  document_id int(11) NOT NULL AUTO_INCREMENT,
  invoice_id int(11) NOT NULL,
  name varchar(50) NOT NULL,
  amount decimal(10, 2) DEFAULT 0,
  path varchar(255) DEFAULT NULL,
  requested_date date NOT NULL,
  expected_date date NOT NULL,
  uploaded_date date DEFAULT NULL,
  approved_date date DEFAULT NULL,
  PRIMARY KEY (document_id)
)
ENGINE = INNODB
AVG_ROW_LENGTH = 8192
CHARACTER SET utf8
COLLATE utf8_general_ci;