-- Create payment methods table if it doesn't exist
CREATE TABLE IF NOT EXISTS `payment_methods` (
    `method_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `method_name` VARCHAR(50) NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`method_id`),
    UNIQUE KEY `method_name` (`method_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Insert default payment methods if they don't exist
INSERT IGNORE INTO `payment_methods` (`method_name`) VALUES
    ('Cash'),
    ('Bank Transfer'),
    ('Check'),
    ('Credit Card'); 