cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wid...@apache.org
Subject git commit: db / upgrade: Add columns to sync_queue and sync_queue_item
Date Wed, 02 Jan 2013 16:03:04 GMT
Updated Branches:
  refs/heads/master eff071642 -> 3d2fefabd


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/3d2fefab
Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/3d2fefab
Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/3d2fefab

Branch: refs/heads/master
Commit: 3d2fefabdd12e3a84067a3d5d02d664aad7ce2d6
Parents: eff0716
Author: Wido den Hollander <wido@widodh.nl>
Authored: Wed Jan 2 17:01:23 2013 +0100
Committer: Wido den Hollander <wido@widodh.nl>
Committed: Wed Jan 2 17:01:23 2013 +0100

----------------------------------------------------------------------
 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/3d2fefab/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