You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@stratos.apache.org by ma...@apache.org on 2013/09/05 08:21:26 UTC
git commit: Add missing license headers for sqls
Updated Branches:
refs/heads/master 0fd9e737b -> b7d1abdb4
Add missing license headers for sqls
Signed-off-by: Manula Thantriwatte <ma...@wso2.com>
Project: http://git-wip-us.apache.org/repos/asf/incubator-stratos/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-stratos/commit/b7d1abdb
Tree: http://git-wip-us.apache.org/repos/asf/incubator-stratos/tree/b7d1abdb
Diff: http://git-wip-us.apache.org/repos/asf/incubator-stratos/diff/b7d1abdb
Branch: refs/heads/master
Commit: b7d1abdb45ff1934ac87e15b4ab7802c230c21a0
Parents: 0fd9e73
Author: Dinesh Bandara <di...@wso2.com>
Authored: Thu Sep 5 11:34:34 2013 +0530
Committer: Manula Thantriwatte <ma...@wso2.com>
Committed: Thu Sep 5 11:50:51 2013 +0530
----------------------------------------------------------------------
.../resources/database/wso2_slive_status.sql | 148 -------------------
.../resources/carbon-home/dbscripts/db2.sql | 19 +++
.../resources/carbon-home/dbscripts/derby.sql | 19 +++
.../test/resources/carbon-home/dbscripts/h2.sql | 19 +++
.../resources/carbon-home/dbscripts/mssql.sql | 19 +++
.../resources/carbon-home/dbscripts/mysql.sql | 19 +++
.../resources/carbon-home/dbscripts/oracle.sql | 19 +++
.../carbon-home/dbscripts/oracle_rac.sql | 19 +++
.../carbon-home/dbscripts/postgresql.sql | 19 +++
.../stratos-controller/dbscripts/billing-h2.sql | 19 +++
.../dbscripts/billing-mysql.sql | 19 +++
.../dbscripts/metering_h2.sql | 19 +++
.../dbscripts/metering_mysql.sql | 19 +++
.../stratos-controller/dbscripts/migration.sql | 19 +++
products/stratos-controller/dbscripts/s2_h2.sql | 19 +++
.../dbscripts/stratos_mysql.sql | 19 +++
.../stratos-controller/dbscripts/wso2_rss.sql | 18 +++
.../resources/billing-mysql.sql | 19 +++
.../resources/metering_mysql.sql | 19 +++
tools/stratos-installer/resources/registry.sql | 19 +++
.../resources/stratos_foundation.sql | 19 +++
tools/stratos-installer/resources/userstore.sql | 19 +++
22 files changed, 398 insertions(+), 148 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.status.monitor.core/src/main/resources/database/wso2_slive_status.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.status.monitor.core/src/main/resources/database/wso2_slive_status.sql b/components/org.apache.stratos.status.monitor.core/src/main/resources/database/wso2_slive_status.sql
deleted file mode 100644
index 65a93cb..0000000
--- a/components/org.apache.stratos.status.monitor.core/src/main/resources/database/wso2_slive_status.sql
+++ /dev/null
@@ -1,148 +0,0 @@
--- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (x86_64)
---
--- Host: localhost Database: wso2_slive_status
--- ------------------------------------------------------
--- Server version 5.1.41-3ubuntu12.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `WSL_MAIL_CONTENT_HASH`
---
-drop database stratos_status;
-create database stratos_status;
-use stratos_status;
-DROP TABLE IF EXISTS `WSL_MAIL_CONTENT_HASH`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `WSL_MAIL_CONTENT_HASH` (
- `WSL_HASH_ID` int(11) NOT NULL AUTO_INCREMENT,
- `WSL_MAIL_HASH` varchar(255) NOT NULL,
- `WSL_IS_MAIL_SENT` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`WSL_HASH_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `WSL_SERVICE`
---
-
-DROP TABLE IF EXISTS `WSL_SERVICE`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `WSL_SERVICE` (
- `WSL_ID` int(11) NOT NULL AUTO_INCREMENT,
- `WSL_NAME` varchar(265) NOT NULL,
- PRIMARY KEY (`WSL_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `WSL_SERVICE_HEARTBEAT`
---
-
-DROP TABLE IF EXISTS `WSL_SERVICE_HEARTBEAT`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `WSL_SERVICE_HEARTBEAT` (
- `WSL_ID` bigint(20) NOT NULL AUTO_INCREMENT,
- `WSL_SERVICE_ID` int(11) NOT NULL,
- `WSL_STATUS` tinyint(1) NOT NULL DEFAULT '0',
- `WSL_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`WSL_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=50286 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `WSL_SERVICE_STATE`
---
-
-DROP TABLE IF EXISTS `WSL_SERVICE_STATE`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `WSL_SERVICE_STATE` (
- `WSL_ID` bigint(20) NOT NULL AUTO_INCREMENT,
- `WSL_SERVICE_ID` int(11) NOT NULL,
- `WSL_STATE_ID` int(11) NOT NULL,
- `WSL_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`WSL_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=45884 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `WSL_SERVICE_STATE_DETAIL`
---
-
-DROP TABLE IF EXISTS `WSL_SERVICE_STATE_DETAIL`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `WSL_SERVICE_STATE_DETAIL` (
- `WSL_ID` bigint(20) NOT NULL AUTO_INCREMENT,
- `WSL_SERVICE_STATE_ID` bigint(20) NOT NULL,
- `WSL_DETAIL` varchar(2048) NOT NULL,
- `WSL_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`WSL_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=1249 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `WSL_STATE`
---
-
-DROP TABLE IF EXISTS `WSL_STATE`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `WSL_STATE` (
- `WSL_ID` int(11) NOT NULL AUTO_INCREMENT,
- `WSL_NAME` varchar(256) NOT NULL,
- PRIMARY KEY (`WSL_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `WSL_USER`
---
-
-DROP TABLE IF EXISTS `WSL_USER`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `WSL_USER` (
- `WSL_UID` int(11) NOT NULL AUTO_INCREMENT,
- `WSL_MAIL` varchar(255) NOT NULL,
- PRIMARY KEY (`WSL_UID`),
- UNIQUE KEY `WSL_UID` (`WSL_UID`)
-) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-LOCK TABLES `WSL_SERVICE` WRITE;
-/*!40000 ALTER TABLE `WSL_SERVICE` DISABLE KEYS */;
-INSERT INTO `WSL_SERVICE` VALUES (1,'StratosLive Manager'),(2,'StratosLive Enterprise Service Bus'),(3,'StratosLive Application Server'),(4,'StratosLive Data Services Server'),(5,'StratosLive Governance Registry'),(6,'StratosLive Identity Server'),(7,'StratosLive Business Activity Monitor'),(8,'StratosLive Business Process Server'),(9,'StratosLive Business Rules Server'),(10,'StratosLive Mashup Server'),(11,'StratosLive Gadget Server'),(12,'StratosLive Complex Event Processing Server'),(13,'StratosLive Message Broker');
-/*!40000 ALTER TABLE `WSL_SERVICE` ENABLE KEYS */;
-UNLOCK TABLES;
-
-LOCK TABLES `WSL_STATE` WRITE;
-/*!40000 ALTER TABLE `WSL_STATE` DISABLE KEYS */;
-INSERT INTO `WSL_STATE` VALUES (1,'Up & Running'),(2,'Broken'),(3,'Down'),(4,'Resolved');
-/*!40000 ALTER TABLE `WSL_STATE` ENABLE KEYS */;
-UNLOCK TABLES;
-
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2011-09-06 9:39:52
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/db2.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/db2.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/db2.sql
index 077da05..6bf1da8 100644
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/db2.sql
+++ b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/db2.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE TABLE REG_CLUSTER_LOCK (
REG_LOCK_NAME VARCHAR (20) NOT NULL,
REG_LOCK_STATUS VARCHAR (20),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/derby.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/derby.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/derby.sql
index 2253785..f3141bc 100644
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/derby.sql
+++ b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/derby.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE TABLE REG_CLUSTER_LOCK (
REG_LOCK_NAME VARCHAR (20),
REG_LOCK_STATUS VARCHAR (20),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/h2.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/h2.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/h2.sql
index 19f81cd..d7a7a53 100644
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/h2.sql
+++ b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/h2.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE TABLE IF NOT EXISTS REG_CLUSTER_LOCK (
REG_LOCK_NAME VARCHAR (20),
REG_LOCK_STATUS VARCHAR (20),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mssql.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mssql.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mssql.sql
index 1e67fc5..8aa0b84 100755
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mssql.sql
+++ b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mssql.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
--create table REG_CLUSTER_LOCK
IF NOT EXISTS (SELECT * FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].[REG_CLUSTER_LOCK]') AND TYPE IN (N'U'))
CREATE TABLE REG_CLUSTER_LOCK (
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mysql.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mysql.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mysql.sql
index 5b9b234..a72241b 100644
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mysql.sql
+++ b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/mysql.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE TABLE IF NOT EXISTS REG_CLUSTER_LOCK (
REG_LOCK_NAME VARCHAR (20),
REG_LOCK_STATUS VARCHAR (20),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql
index e7cc68f..def74c8 100644
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql
+++ b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE TABLE REG_CLUSTER_LOCK (
REG_LOCK_NAME VARCHAR2(20),
REG_LOCK_STATUS VARCHAR2(20),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql
index 4bdffd1..d608d76 100644
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql
+++ b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE TABLE REG_CLUSTER_LOCK (
REG_LOCK_NAME VARCHAR2(20),
REG_LOCK_STATUS VARCHAR2(20),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql
index 4f897da..36ae8a1 100644
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql
+++ b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
DROP TABLE IF EXISTS REG_CLUSTER_LOCK;
CREATE TABLE REG_CLUSTER_LOCK (
REG_LOCK_NAME VARCHAR (20),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/products/stratos-controller/dbscripts/billing-h2.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/billing-h2.sql b/products/stratos-controller/dbscripts/billing-h2.sql
index e70be14..ccf1393 100755
--- a/products/stratos-controller/dbscripts/billing-h2.sql
+++ b/products/stratos-controller/dbscripts/billing-h2.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE TABLE IF NOT EXISTS BC_CUSTOMER (
BC_ID INTEGER AUTO_INCREMENT,
BC_NAME VARCHAR (64),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/products/stratos-controller/dbscripts/billing-mysql.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/billing-mysql.sql b/products/stratos-controller/dbscripts/billing-mysql.sql
index 55cab9a..cfe828f 100755
--- a/products/stratos-controller/dbscripts/billing-mysql.sql
+++ b/products/stratos-controller/dbscripts/billing-mysql.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE TABLE IF NOT EXISTS BC_CUSTOMER (
BC_ID INTEGER AUTO_INCREMENT,
BC_NAME VARCHAR (64),
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/products/stratos-controller/dbscripts/metering_h2.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/metering_h2.sql b/products/stratos-controller/dbscripts/metering_h2.sql
index 0491b8e..1f38fe2 100755
--- a/products/stratos-controller/dbscripts/metering_h2.sql
+++ b/products/stratos-controller/dbscripts/metering_h2.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
--
-- TABLES
--
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/products/stratos-controller/dbscripts/metering_mysql.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/metering_mysql.sql b/products/stratos-controller/dbscripts/metering_mysql.sql
index 3ab4ee3..755403d 100755
--- a/products/stratos-controller/dbscripts/metering_mysql.sql
+++ b/products/stratos-controller/dbscripts/metering_mysql.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
-- WSO2 METERING DATABASE SQL FOR MySQL
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/products/stratos-controller/dbscripts/migration.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/migration.sql b/products/stratos-controller/dbscripts/migration.sql
index 379e859..421fd1d 100755
--- a/products/stratos-controller/dbscripts/migration.sql
+++ b/products/stratos-controller/dbscripts/migration.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
ALTER TABLE UM_TENANT ADD UM_CREATED_DATE TIMESTAMP NOT NULL DEFAULT '2010-06-01 00:00:01';
ALTER TABLE UM_TENANT ADD UNIQUE INDEX INDEX_UM_TENANT_UM_DOMAIN_NAME (UM_DOMAIN_NAME);
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/products/stratos-controller/dbscripts/s2_h2.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/s2_h2.sql b/products/stratos-controller/dbscripts/s2_h2.sql
index 170c77b..d88149d 100644
--- a/products/stratos-controller/dbscripts/s2_h2.sql
+++ b/products/stratos-controller/dbscripts/s2_h2.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
--
-- Create schema s2_db
--
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/products/stratos-controller/dbscripts/stratos_mysql.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/stratos_mysql.sql b/products/stratos-controller/dbscripts/stratos_mysql.sql
index 8aa3269..ce32a3b 100644
--- a/products/stratos-controller/dbscripts/stratos_mysql.sql
+++ b/products/stratos-controller/dbscripts/stratos_mysql.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/products/stratos-controller/dbscripts/wso2_rss.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/wso2_rss.sql b/products/stratos-controller/dbscripts/wso2_rss.sql
index 411b1ce..4a2348f 100755
--- a/products/stratos-controller/dbscripts/wso2_rss.sql
+++ b/products/stratos-controller/dbscripts/wso2_rss.sql
@@ -1,3 +1,21 @@
+/*
+* 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.
+*/
CREATE TABLE RSS_INSTANCE (
rss_instance_id INTEGER AUTO_INCREMENT,
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/tools/stratos-installer/resources/billing-mysql.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/billing-mysql.sql b/tools/stratos-installer/resources/billing-mysql.sql
index 96a782d..07aca63 100644
--- a/tools/stratos-installer/resources/billing-mysql.sql
+++ b/tools/stratos-installer/resources/billing-mysql.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE DATABASE IF NOT EXISTS billing;
USE billing;
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/tools/stratos-installer/resources/metering_mysql.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/metering_mysql.sql b/tools/stratos-installer/resources/metering_mysql.sql
index aa6b748..8908ef0 100644
--- a/tools/stratos-installer/resources/metering_mysql.sql
+++ b/tools/stratos-installer/resources/metering_mysql.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
-- WSO2 METERING DATABASE SQL FOR MySQL
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/tools/stratos-installer/resources/registry.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/registry.sql b/tools/stratos-installer/resources/registry.sql
index 18be571..2e5dd06 100644
--- a/tools/stratos-installer/resources/registry.sql
+++ b/tools/stratos-installer/resources/registry.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE DATABASE IF NOT EXISTS registry;
USE registry;
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/tools/stratos-installer/resources/stratos_foundation.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/stratos_foundation.sql b/tools/stratos-installer/resources/stratos_foundation.sql
index 8aa3269..ce32a3b 100644
--- a/tools/stratos-installer/resources/stratos_foundation.sql
+++ b/tools/stratos-installer/resources/stratos_foundation.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/b7d1abdb/tools/stratos-installer/resources/userstore.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/userstore.sql b/tools/stratos-installer/resources/userstore.sql
index 09755a7..cf289b7 100644
--- a/tools/stratos-installer/resources/userstore.sql
+++ b/tools/stratos-installer/resources/userstore.sql
@@ -1,3 +1,22 @@
+/*
+* 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.
+*/
+
CREATE DATABASE IF NOT EXISTS userstore;
USE userstore;