You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by bf...@apache.org on 2013/01/03 01:45:23 UTC
[1/2] git commit: db / upgrade: Add columns to sync_queue and
sync_queue_item
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 <wi...@widodh.nl>
Authored: Wed Jan 2 17:01:23 2013 +0100
Committer: Brian Federle <br...@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`;