developer: Move custom sql commands to one prefill schema file

yadvr · yadvr · commit 2bbbdbf58b40 · 2012-11-04T01:57:05.000+05:30
The sql-maven plugin does not allow multiple sqlCommands to executed, only the
last one in the &lt;configuration&gt; 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 &lt;bhaisaab@apache.org&gt;
diff --git a/developer/developer-prefill.sql 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;
