cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alena1...@apache.org
Subject [1/3] Refactoring for the Load Balancing feature -
Date Tue, 02 Apr 2013 19:12:12 GMT
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';
+
+


Mime
View raw message