[2/2] git commit: developer: Move custom sql commands to one prefill schema file

[bh...@apache.org]

developer: Move custom sql commands to one prefill schema file

The sql-maven plugin does not allow multiple sqlCommands to executed, only the
last one in the <configuration> gets executed, so moving out all the developer
related schema to one file.

Adds:
  - ROOT domain
  - system and admin accounts
  - system and admin users
  - custom configurations

Signed-off-by: Rohit Yadav <bh...@apache.org>


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

Branch: refs/heads/master
Commit: 2bbbdbf58b40b6a5dbd9b010db89e5c934a69433
Parents: d8fbb0d
Author: Rohit Yadav <bh...@apache.org>
Authored: Sun Nov 4 01:57:05 2012 +0530
Committer: Rohit Yadav <bh...@apache.org>
Committed: Sun Nov 4 01:57:05 2012 +0530

----------------------------------------------------------------------
 developer/developer-prefill.sql |   47 ++++++++++++++++++++++++++++++++++
 1 files changed, 47 insertions(+), 0 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/2bbbdbf5/developer/developer-prefill.sql
----------------------------------------------------------------------
diff --git a/developer/developer-prefill.sql b/developer/developer-prefill.sql
new file mode 100644
index 0000000..cba5382
--- /dev/null
+++ b/developer/developer-prefill.sql
@@ -0,0 +1,47 @@
+-- Licensed to the Apache Software Foundation (ASF) under one
+-- or more contributor license agreements.  See the NOTICE file
+-- distributed with this work for additional information
+-- regarding copyright ownership.  The ASF licenses this file
+-- to you under the Apache License, Version 2.0 (the
+-- "License"); you may not use this file except in compliance
+-- with the License.  You may obtain a copy of the License at
+--
+--   http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing,
+-- software distributed under the License is distributed on an
+-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+-- KIND, either express or implied.  See the License for the
+-- specific language governing permissions and limitations
+-- under the License.
+
+-- Add a default ROOT domain
+INSERT INTO `cloud`.`domain` (id, name, parent, path, owner) VALUES
+            (1, 'ROOT', NULL, '/', 2);
+
+-- Add system and admin accounts
+INSERT INTO `cloud`.`account` (id, account_name, type, domain_id, state) VALUES
+            (1, 'system', 1, 1, 'enabled');
+
+INSERT INTO `cloud`.`account` (id, account_name, type, domain_id, state) VALUES
+            (2, 'admin', 1, 1, 'enabled');
+
+-- Add system user
+INSERT INTO `cloud`.`user` (id, username, password, account_id, firstname,
+            lastname, email, state, created) VALUES (1, 'system', RAND(),
+            '1', 'system', 'cloud', NULL, 'enabled', NOW());
+
+-- Add system user with encrypted password=password
+INSERT INTO `cloud`.`user` (id, username, password, account_id, firstname,
+            lastname, email, state, created) VALUES (2, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99',
+            '2', 'Admin', 'User', 'admin@mailprovider.com', 'enabled', NOW());
+
+-- Add configurations
+INSERT INTO `cloud`.`configuration` (category, instance, component, name, value)
+            VALUES ('Hidden', 'DEFAULT', 'management-server', 'init', 'false');
+
+INSERT INTO `cloud`.`configuration` (category, instance, component, name, value)
+            VALUES ('Advanced', 'DEFAULT', 'management-server',
+            'integration.api.port', '8096');
+
+commit;