Updated Branches: refs/heads/internallb [created] b429b9606
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/b429b960/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index ab9df05..a8a7549 100644 --- a/setup/db/db/schema-410to420.sql +++ b/setup/db/db/schema-410to420.sql @@ -405,3 +405,18 @@ INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created, type, VALUES (10, 'routing-10', 'SystemVM Template (LXC)', 0, now(), 'SYSTEM', 0, 64, 1, 'http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2', '2755de1f9ef2ce4d6f2bee2efbb4da92', 0, 'SystemVM Template (LXC)', 'QCOW2', 15, 0, 1, 'LXC'); -- END: support for LXC + +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `uuid` varchar(40); +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `ip_address_id` bigint unsigned COMMENT 'id of the corresponding ip address'; +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `start_port` int(10) COMMENT 'starting port of a port range'; +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `end_port` int(10) COMMENT 'end port of a port range'; +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `state` char(32) NOT NULL COMMENT 'current state of this rule'; +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `protocol` char(16) NOT NULL default 'TCP' COMMENT 'protocol to open these ports for'; +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `account_id` bigint unsigned NOT NULL COMMENT 'owner id'; +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `domain_id` bigint unsigned NOT NULL COMMENT 'domain id'; +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `network_id` bigint unsigned NOT NULL COMMENT 'network id'; +ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `created` datetime COMMENT 'Date created'; + +ALTER TABLE `cloud`.`load_balancing_rules` MODIFY COLUMN `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id'; + +
