-- Gate Management Table
CREATE TABLE IF NOT EXISTS gateyonetim (
    id INT AUTO_INCREMENT PRIMARY KEY,
    gate_name VARCHAR(50) NOT NULL UNIQUE,
    is_active TINYINT(1) DEFAULT 1,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Insert default gates
INSERT INTO gateyonetim (gate_name, is_active) VALUES
('bot_status', 1),
('vbv', 1),
('vbvmass', 1),
('auth1', 1),
('auth1mass', 1),
('auth2', 1),
('auth2mass', 1),
('stripe1', 1),
('stripe2', 1),
('stripe3', 1),
('stripeauth', 1),
('puan1', 1),
('puanmass', 1),
('puan2', 1),
('puan2mass', 1),
('puan3', 1),
('puan3mass', 1)
ON DUPLICATE KEY UPDATE gate_name = gate_name;
