DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `buyer_id` int NOT NULL,
  `seller_id` int NOT NULL,
  `ship_fee` float NOT NULL,
  `mode_of_payment` int NOT NULL,
  `order_placed` datetime DEFAULT now(),
  `order_shipped` datetime DEFAULT NULL,
  `order_completed` datetime DEFAULT NULL,
  `delivery_location` varchar(100) NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`)
);