You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by bh...@apache.org on 2016/04/04 08:27:55 UTC
[03/15] git commit: updated refs/heads/4.9-mvn-upgrade to 4c10aff
CLOUDSTACK-9298: Remove user definer from view creations
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/c19d8b47
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/c19d8b47
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/c19d8b47
Branch: refs/heads/4.9-mvn-upgrade
Commit: c19d8b47397ffb528e3836c9b86749f601b29dbe
Parents: 9857f41
Author: nvazquez <ni...@gmail.com>
Authored: Fri Mar 11 06:35:24 2016 -0300
Committer: nvazquez <ni...@gmail.com>
Committed: Fri Mar 11 07:04:33 2016 -0300
----------------------------------------------------------------------
setup/db/db/schema-481to490.sql | 12 +-----------
1 file changed, 1 insertion(+), 11 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/c19d8b47/setup/db/db/schema-481to490.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-481to490.sql b/setup/db/db/schema-481to490.sql
index cebe605..75df7d0 100644
--- a/setup/db/db/schema-481to490.sql
+++ b/setup/db/db/schema-481to490.sql
@@ -24,9 +24,6 @@ ALTER TABLE `event` ADD INDEX `state` (`state`);
DROP VIEW IF EXISTS `cloud`.`template_view`;
CREATE
- ALGORITHM = UNDEFINED
- DEFINER = `cloud`@`%`
- SQL SECURITY DEFINER
VIEW `template_view` AS
SELECT
`vm_template`.`id` AS `id`,
@@ -128,9 +125,6 @@ VIEW `template_view` AS
DROP VIEW IF EXISTS `cloud`.`volume_view`;
CREATE
- ALGORITHM = UNDEFINED
- DEFINER = `cloud`@`%`
- SQL SECURITY DEFINER
VIEW `volume_view` AS
SELECT
`volumes`.`id` AS `id`,
@@ -239,12 +233,8 @@ VIEW `volume_view` AS
AND (`async_job`.`instance_type` = 'Volume')
AND (`async_job`.`job_status` = 0))));
-DROP VIEW IF EXISTS `cloud`.`user_vm__view`;
-
+DROP VIEW IF EXISTS `cloud`.`user_vm_view`;
CREATE
- ALGORITHM = UNDEFINED
- DEFINER = `cloud`@`%`
- SQL SECURITY DEFINER
VIEW `user_vm_view` AS
SELECT
`vm_instance`.`id` AS `id`,