CREATE TABLE `{business_code}_payment_method` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `method_code` VARCHAR(50) NOT NULL UNIQUE,
    `method_name` VARCHAR(100) NOT NULL,
    `is_active` TINYINT(1) NOT NULL DEFAULT 1,
    `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `uniq_method_code` (`method_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Insert default payment methods
INSERT INTO `{business_code}_payment_method` (`method_code`, `method_name`) VALUES
('CASH', 'Cash'),
('DEBIT_CARD', 'Debit Card'),
('CREDIT_CARD', 'Credit Card'),
('CREDIT', 'Credit'); 