USE flystarcourier_db;

CREATE TABLE IF NOT EXISTS `invoice_terms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT IGNORE INTO `invoice_terms` (`name`, `status`) VALUES
('Cost and Freight(CFR)', 'active'),
('Cost, Insurance and Freight(CIF)', 'active'),
('Carriage and Insurance Paid(CIP)', 'active'),
('Carriage Paid To(CPT)', 'active'),
('Delivered At Frontier(DAF)', 'active'),
('Delivered at Place(DAP)', 'active'),
('Delivered at Terminal(DAT)', 'active'),
('Delivery Duty Paid(DDP)', 'active'),
('Delivery Duty Unpaid(DDU)', 'active'),
('Delivered Ex Quay(DEQ)', 'active'),
('Delivered Ex Ship(DES)', 'active'),
('Ex Works(EXW)', 'active'),
('Free Along Side(FAS)', 'active'),
('Free Carrier(FCA)', 'active'),
('Free On Board(FOB)', 'active'),
('Unknown(UNK)', 'active');