CREATE TABLE historymaster (
  ID int(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  TerminalNo smallint(10),
  OrderNO varchar(20),
  VideoID int(11),
  IdentificationID varchar(100),
  FirstName varchar(200),
  LastName varchar(200),
  PassportImage mediumblob,
  Date varchar(10),
  Time varchar(10),
  IsPrint smallint(1),
  LocalCurrency varchar(4),
  AcceptCurrency varchar(4),
  ForeginToLocalRate decimal(30,12),
  ExchangeCurrency varchar(4),
  LocalToForeginRate decimal(30,12),
  ExchangeRates decimal(30,12),
  OutedExchangeCurrencyAmount int(11),
  OutedLocalCurrencyAmount decimal(12,4),
  TransStatus smallint(1),
  AcceptBillJam smallint(1),
  Camera1_Photo mediumblob,
  Camera2_Photo mediumblob,
  Camera3_Photo mediumblob,
  LiquidationID int(11),
  LiquidationDate varchar(10),
  IsLiquidation smallint(1),
  Last_Update timestamp
);