USE flystarcourier_db;

CREATE TABLE IF NOT EXISTS `invoice_formats` (
  `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_formats` (`name`, `status`) VALUES
('B2B', 'active'),
('C2C', 'active'),
('COM', 'active'),
('CSB 5', 'active'),
('performainv1', 'active'),
('performainv2', 'active'),
('performainvcom', 'active'),
('performainvGSTBill', 'active'),
('PERSONAL', 'active');