 ALTER TABLE `service_list`
   ADD PRIMARY KEY (`id`),
   ADD UNIQUE KEY `idx_ip_port` (`ip`,`port`) USING BTREE,
-  ADD KEY `idx_name` (`name`) USING BTREE;
+  ADD KEY `idx_name` (`name`) USING BTREE,
+  ADD KEY `registerKey` (`registerKey`);
+
+--
+-- Indexes for table `subscriber`
+--
+ALTER TABLE `subscriber`
+  ADD PRIMARY KEY (`id`),
+  ADD KEY `serviceName` (`serviceName`),
+  ADD KEY `subcriber` (`subcriber`);
 
 --
 -- AUTO_INCREMENT for dumped tables

  `port` mediumint(8) NOT NULL COMMENT '服务端口',
  `status` tinyint(1) NOT NULL COMMENT '运行状态',
  `rate` smallint(4) NOT NULL COMMENT '权重',
  `startTime` int(10) NOT NULL COMMENT '启动时间'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='服务表';

--
-- 转存表中的数据 `service_list`
--

INSERT INTO `service_list` (`id`, `name`, `ip`, `port`, `status`, `rate`, `startTime`) VALUES
(1, 'dproxy', '10.94.107.22', 9939, 0, 0, 1477984417);

--
-- Indexes for dumped tables

--
-- Database: `register_center`
--
CREATE DATABASE IF NOT EXISTS `register_center` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `register_center`;

-- --------------------------------------------------------

