Updated Branches:
  refs/heads/4.1 df2e0108e -> 799d906ac

CLOUDSTACK-2147: Missing configuration variable max.project.cpus in 
configuration table


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/799d906a
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/799d906a
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/799d906a

Branch: refs/heads/4.1
Commit: 799d906ac99cc739929dc64874b03acd66d68772
Parents: df2e010
Author: Sanjay Tripathi <[email protected]>
Authored: Tue Apr 23 16:13:51 2013 +0530
Committer: Chip Childers <[email protected]>
Committed: Tue Apr 23 15:41:38 2013 +0100

----------------------------------------------------------------------
 setup/db/db/schema-40to410.sql |   24 ------------------------
 1 files changed, 0 insertions(+), 24 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/799d906a/setup/db/db/schema-40to410.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-40to410.sql b/setup/db/db/schema-40to410.sql
index 3fbd075..fe53d36 100644
--- a/setup/db/db/schema-40to410.sql
+++ b/setup/db/db/schema-40to410.sql
@@ -263,14 +263,6 @@ CREATE TABLE  `cloud`.`region` (
 
 INSERT INTO `cloud`.`region` values 
('1','Local','http://localhost:8080/client/');
 
-INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Account Defaults', 
'DEFAULT', 'management-server', 'max.account.cpus', '40', 'The default maximum 
number of cpu cores that can be used for an account');
-
-INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Account Defaults', 
'DEFAULT', 'management-server', 'max.account.memory', '40960', 'The default 
maximum memory (in MB) that can be used for an account');
-
-INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 
'DEFAULT', 'management-server', 'max.project.cpus', '40', 'The default maximum 
number of cpu cores that can be used for a project');
-
-INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 
'DEFAULT', 'management-server', 'max.project.memory', '40960', 'The default 
maximum memory (in MB) that can be used for a project');
-
 CREATE TABLE `cloud`.`nicira_nvp_router_map` (
   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
   `logicalrouter_uuid` varchar(255) NOT NULL UNIQUE COMMENT 'nicira uuid of 
logical router',
@@ -1262,10 +1254,6 @@ CREATE VIEW `cloud`.`account_view` AS
         projectcount.count projectTotal,
         networklimit.max networkLimit,
         networkcount.count networkTotal,
-        cpulimit.max cpuLimit,
-        cpucount.count cpuTotal,
-        memorylimit.max memoryLimit,
-        memorycount.count memoryTotal,
         async_job.id job_id,
         async_job.uuid job_uuid,
         async_job.job_status job_status,
@@ -1334,18 +1322,6 @@ CREATE VIEW `cloud`.`account_view` AS
         `cloud`.`resource_count` networkcount ON account.id = 
networkcount.account_id
             and networkcount.type = 'network'
             left join
-        `cloud`.`resource_limit` cpulimit ON account.id = cpulimit.account_id
-            and cpulimit.type = 'cpu'
-            left join
-        `cloud`.`resource_count` cpucount ON account.id = cpucount.account_id
-            and cpucount.type = 'cpu'
-            left join
-        `cloud`.`resource_limit` memorylimit ON account.id = 
memorylimit.account_id
-            and memorylimit.type = 'memory'
-            left join
-        `cloud`.`resource_count` memorycount ON account.id = 
memorycount.account_id
-            and memorycount.type = 'memory'
-            left join
         `cloud`.`async_job` ON async_job.instance_id = account.id
             and async_job.instance_type = 'Account'
             and async_job.job_status = 0;

Reply via email to