-- Initialize Telegram Data Centers
USE tg_manage;

-- Create table if not exists
CREATE TABLE IF NOT EXISTS `tg_dc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) NOT NULL COMMENT 'IP地址',
  `port` varchar(255) NOT NULL COMMENT '端口',
  `address` varchar(255) NOT NULL COMMENT '地址,1美国,2荷兰,3美国,4荷兰,5新加坡',
  `createdAt` datetime DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Telegram数据中心表';

-- Clear existing data
TRUNCATE TABLE `tg_dc`;

-- Insert Telegram Data Centers
INSERT INTO `tg_dc` (`id`, `ip`, `port`, `address`) VALUES
(1, '149.154.175.50', '443', '1'),  -- DC1 Miami, USA
(2, '149.154.167.50', '443', '2'),  -- DC2 Amsterdam, Netherlands
(3, '149.154.175.100', '443', '3'), -- DC3 Miami, USA
(4, '149.154.167.91', '443', '4'),  -- DC4 Amsterdam, Netherlands
(5, '91.108.56.100', '443', '5');   -- DC5 Singapore

-- Verify data
SELECT * FROM `tg_dc`;