CLOUDSTACK-6199: Add the column display_event to event table ~
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/f2919519 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/f2919519 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/f2919519 Branch: refs/heads/resize-root Commit: f291951990fbf0c51c2e9aa95d246d73e8abde8b Parents: 8b0e04b Author: Nitin Mehta <nitin.me...@citrix.com> Authored: Tue Mar 4 18:26:09 2014 -0800 Committer: Nitin Mehta <nitin.me...@citrix.com> Committed: Tue Mar 4 18:26:09 2014 -0800 ---------------------------------------------------------------------- setup/db/db/schema-430to440.sql | 2 ++ 1 file changed, 2 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/f2919519/setup/db/db/schema-430to440.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-430to440.sql b/setup/db/db/schema-430to440.sql index ec7ee4d..f755a08 100644 --- a/setup/db/db/schema-430to440.sql +++ b/setup/db/db/schema-430to440.sql @@ -543,6 +543,8 @@ ALTER TABLE `cloud`.`s2s_vpn_gateway` ADD COLUMN `display` tinyint(1) NOT NULL D INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (225, UUID(), 9, 'FreeBSD 10 (32-bit)'); INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (226, UUID(), 9, 'FreeBSD 10 (64-bit)'); +ALTER TABLE `cloud`.`event` ADD COLUMN `display_event` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the detail can be displayed to the end user'; + DROP VIEW IF EXISTS `cloud`.`event_view`; CREATE VIEW `cloud`.`event_view` AS select
