-- ----------------------------------------------------------------
-- Create the correct license archive table.
-- This is to replace file_upload_test table
-- ----------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `license_archive` (
  `FID` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(250) DEFAULT NULL,
  `file_mime` varchar(45) DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  `file_blob` blob,
  `name` varchar(255) DEFAULT NULL,
  `purchaseDate` date DEFAULT NULL,
  `invoiceDate` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `uploadDate` date DEFAULT NULL,
  `file_data` longtext,
  PRIMARY KEY (`FID`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='This table is to replace the file_upload_test table.';