cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bfede...@apache.org
Subject [1/2] git commit: db / upgrade: Add columns to sync_queue and sync_queue_item
Date Thu, 03 Jan 2013 00:45:23 GMT
db / upgrade: Add columns to sync_queue and sync_queue_item

These columns were not added by the upgrade from 4.0 to 4.1 causing SQL-errors

These columns are present in create-schema.sql, so by adding them here the upgrade also works
to 4.1


Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/f81cdd8f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/f81cdd8f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/f81cdd8f

Branch: refs/heads/ui-plugins
Commit: f81cdd8fbdcc0a9f1fb6846fdc74e0b8279c0bed
Parents: 8c1b340
Author: Wido den Hollander <wido@widodh.nl>
Authored: Wed Jan 2 17:01:23 2013 +0100
Committer: Brian Federle <brian.federle@citrix.com>
Committed: Wed Jan 2 16:45:04 2013 -0800

----------------------------------------------------------------------
 setup/db/db/schema-40to410.sql |    5 +++++
 1 files changed, 5 insertions(+), 0 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/f81cdd8f/setup/db/db/schema-40to410.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-40to410.sql b/setup/db/db/schema-40to410.sql
index 73289bc..b09ebb9 100644
--- a/setup/db/db/schema-40to410.sql
+++ b/setup/db/db/schema-40to410.sql
@@ -60,3 +60,8 @@ ALTER TABLE `cloud`.`network_offerings` ADD COLUMN `eip_associate_public_ip`
int
 
 INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network','DEFAULT','NetworkManager','network.dhcp.nondefaultnetwork.setgateway.guestos','Windows','The
guest OS\'s name start with this fields would result in DHCP server response gateway information
even when the network it\'s on is not default network. Names are separated by comma.');
 
+ALTER TABLE `sync_queue` ADD `queue_size` SMALLINT NOT NULL DEFAULT '0' COMMENT 'number of
items being processed by the queue';
+
+ALTER TABLE `sync_queue` ADD `queue_size_limit` SMALLINT NOT NULL DEFAULT '1' COMMENT 'max
number of items the queue can process concurrently';
+
+ALTER TABLE `sync_queue_item` ADD `queue_proc_time` DATETIME NOT NULL COMMENT 'when processing
started for the item' AFTER `queue_proc_number`;


Mime
View raw message