Untitled

CREATE TABLE `fp_freight` (
  `freight_id` varchar(50) NOT NULL,
  `order_id` varchar(50) DEFAULT NULL,
  `invoice_number` varchar(70) DEFAULT NULL,
  `connote_number` varchar(50) DEFAULT NULL,
  `dispatch_date` datetime DEFAULT NULL,
  `charge_weight` double NOT NULL DEFAULT '0',
  `total_dead_weight` double NOT NULL DEFAULT '0',
  `total_cubic` double NOT NULL DEFAULT '0',
  `freight_cost` double NOT NULL DEFAULT '0',
  `remote_fee` double NOT NULL DEFAULT '0',
  `futile_fee` double NOT NULL DEFAULT '0',
  `resi_fee` double NOT NULL DEFAULT '0',
  `oversize_fee` double NOT NULL DEFAULT '0',
  `mhp` double NOT NULL DEFAULT '0',
  `resifee_heavy` double NOT NULL DEFAULT '0',
  `fuel_surcharge` double NOT NULL DEFAULT '0',
  `other_surcharges` double NOT NULL DEFAULT '0',
  `freight_created_date` datetime DEFAULT NULL,
  `freight_modified_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `freight_created_by` varchar(50) DEFAULT NULL,
  `freight_modified_by` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`freight_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;