mysql> drop table cluster;
Query OK, 0 rows affected (0.06 sec)
mysql> CREATE TABLE `cluster` (
 -> `id` int(11) NOT NULL AUTO_INCREMENT,
 -> `name` varchar(50) NOT NULL DEFAULT '' COMMENT '集群名稱',
 -> `cdr_api` varchar(255) NOT NULL DEFAULT '' COMMENT '話單接口地址',
 -> `monitor_api` varchar(255) NOT NULL DEFAULT '' COMMENT '監控接口地址',
 -> `control_api` varchar(255) NOT NULL DEFAULT '' COMMENT '控制接口地址',
 -> `is_public` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否為共有集群1是0否',
 -> `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '集群是否有效1是0否',
 -> PRIMARY KEY (`id`)
 -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='集群管理表';
Query OK, 0 rows affected (0.23 sec)
mysql> show create table cluster;
+---------+---------------------------------------------------------------------------+
| Table | Create Table |
+---------+---------------------------------------------------------------------------+
| cluster | CREATE TABLE `cluster` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(50) NOT NULL DEFAULT '' COMMENT '集群名稱',
 `cdr_api` varchar(255) NOT NULL DEFAULT '' COMMENT '話單接口地址',
 `monitor_api` varchar(255) NOT NULL DEFAULT '' COMMENT '監控接口地址',
 `control_api` varchar(255) NOT NULL DEFAULT '' COMMENT '控制接口地址',
 `is_public` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否為共有集群1是0否',
 `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '集群是否有效1是0否',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='集群管理表' |
+---------+-------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> insert into cluster(`id`,`name`,`cdr_api`,`monitor_api`,`control_api`,`is_public`,`status`) select `id`,`name`,`daddr`,`monitorurl`,`opensipsurl`,`type`,1 from trunking.trunking_manager;
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
mysql> show create table cluster;
+---------+--------------------------------------------------------------------------+
| Table | Create Table |
+---------+--------------------------------------------------------------------------+
| cluster | CREATE TABLE `cluster` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(50) NOT NULL DEFAULT '' COMMENT '集群名稱',
 `cdr_api` varchar(255) NOT NULL DEFAULT '' COMMENT '話單接口地址',
 `monitor_api` varchar(255) NOT NULL DEFAULT '' COMMENT '監控接口地址',
 `control_api` varchar(255) NOT NULL DEFAULT '' COMMENT '控制接口地址',
 `is_public` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否為共有集群1是0否',
 `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '集群是否有效1是0否',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='集群管理表' |
+---------+---------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select * from cluster;
Empty set (0.00 sec)