Skip to content

Commit 770297e

Browse files
yadvryadvr
committed
db: move bigswitch related sqls to schema-451to460.sql
We ought not change older schema migrations, so moved sql statements to the latest upgrade path. Signed-off-by: Rohit Yadav <rohit.yadav@shapeblue.com>
1 parent 01864ef commit 770297e

2 files changed

Lines changed: 18 additions & 18 deletions

File tree

‎setup/db/db/schema-442to450.sql‎

Lines changed: 0 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -284,24 +284,6 @@ CREATE TABLE `cloud`.`brocade_network_vlan_map` (
284284
CONSTRAINT `fk_brocade_network_vlan_map__network_id` FOREIGN KEY (`network_id`) REFERENCES `networks`(`id`) ON DELETE CASCADE
285285
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
286286

287-
DROP TABLE IF EXISTS `cloud`.`external_bigswitch_vns_devices`;
288-
CREATE TABLE `cloud`.`external_bigswitch_bcf_devices` (
289-
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
290-
`uuid` varchar(255) UNIQUE,
291-
`physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical network in to which bigswitch bcf device is added',
292-
`provider_name` varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this bigswitch bcf device',
293-
`device_name` varchar(255) NOT NULL COMMENT 'name of the bigswitch bcf device',
294-
`host_id` bigint unsigned NOT NULL COMMENT 'host id coresponding to the external bigswitch bcf device',
295-
`hostname` varchar(255) NOT NULL COMMENT 'host name or IP address for the bigswitch bcf device',
296-
`username` varchar(255) NOT NULL COMMENT 'username for the bigswitch bcf device',
297-
`password` varchar(255) NOT NULL COMMENT 'password for the bigswitch bcf device',
298-
`nat` boolean NOT NULL COMMENT 'NAT support for the bigswitch bcf device',
299-
`hash` varchar(255) NOT NULL COMMENT 'topology hash for the bigswitch bcf networks',
300-
PRIMARY KEY (`id`),
301-
CONSTRAINT `fk_external_bigswitch_bcf_devices__host_id` FOREIGN KEY (`host_id`) REFERENCES `host`(`id`) ON DELETE CASCADE,
302-
CONSTRAINT `fk_external_bigswitch_bcf_devices__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE
303-
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
304-
305287
/* As part of the separation of Xen and XenServer, update the column for the network labels */
306288
ALTER TABLE `cloud`.`physical_network_traffic_types` CHANGE `xen_network_label` `xenserver_network_label` varchar(255) COMMENT 'The network name label of the physical device dedicated to this traffic on a XenServer host';
307289

‎setup/db/db/schema-451to460.sql‎

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -380,3 +380,21 @@ INSERT IGNORE INTO `cloud`.`configuration` (`category`, `instance`, `component`,
380380
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'NetworkManager', 'router.template.ovm3', 'SystemVM Template (Ovm3)', 'Name of the default router template on Ovm3.','SystemVM Template (Ovm3)', NULL, NULL, 0);
381381

382382
UPDATE IGNORE `cloud`.`configuration` SET `value`="PLAINTEXT" WHERE `name`="user.authenticators.exclude";
383+
384+
DROP TABLE IF EXISTS `cloud`.`external_bigswitch_vns_devices`;
385+
CREATE TABLE `cloud`.`external_bigswitch_bcf_devices` (
386+
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
387+
`uuid` varchar(255) UNIQUE,
388+
`physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical network in to which bigswitch bcf device is added',
389+
`provider_name` varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this bigswitch bcf device',
390+
`device_name` varchar(255) NOT NULL COMMENT 'name of the bigswitch bcf device',
391+
`host_id` bigint unsigned NOT NULL COMMENT 'host id coresponding to the external bigswitch bcf device',
392+
`hostname` varchar(255) NOT NULL COMMENT 'host name or IP address for the bigswitch bcf device',
393+
`username` varchar(255) NOT NULL COMMENT 'username for the bigswitch bcf device',
394+
`password` varchar(255) NOT NULL COMMENT 'password for the bigswitch bcf device',
395+
`nat` boolean NOT NULL COMMENT 'NAT support for the bigswitch bcf device',
396+
`hash` varchar(255) NOT NULL COMMENT 'topology hash for the bigswitch bcf networks',
397+
PRIMARY KEY (`id`),
398+
CONSTRAINT `fk_external_bigswitch_bcf_devices__host_id` FOREIGN KEY (`host_id`) REFERENCES `host`(`id`) ON DELETE CASCADE,
399+
CONSTRAINT `fk_external_bigswitch_bcf_devices__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE
400+
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

0 commit comments

Comments
 (0)