cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sw...@apache.org
Subject [3/4] git commit: updated refs/heads/master to 419f8fb
Date Fri, 01 Apr 2016 02:25:41 GMT
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/master
Commit: c19d8b47397ffb528e3836c9b86749f601b29dbe
Parents: 9857f41
Author: nvazquez <nicovazquez90@gmail.com>
Authored: Fri Mar 11 06:35:24 2016 -0300
Committer: nvazquez <nicovazquez90@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`,


Mime
View raw message