Author: scottbw
Date: Mon Feb 20 14:59:51 2012
New Revision: 1291302
URL: http://svn.apache.org/viewvc?rev=1291302&view=rev
Log:
Removed services-related tables from Wookie schema, and created a migration
file for MySQL (See WOOKIE-263).
Added:
incubator/wookie/trunk/scripts/migration/0.9.2-to-0.10.0/
incubator/wookie/trunk/scripts/migration/0.9.2-to-0.10.0/mysql.sql
Modified:
incubator/wookie/trunk/etc/ddl-schema/wookie-schema.xml
Modified: incubator/wookie/trunk/etc/ddl-schema/wookie-schema.xml
URL:
http://svn.apache.org/viewvc/incubator/wookie/trunk/etc/ddl-schema/wookie-schema.xml?rev=1291302&r1=1291301&r2=1291302&view=diff
==============================================================================
--- incubator/wookie/trunk/etc/ddl-schema/wookie-schema.xml (original)
+++ incubator/wookie/trunk/etc/ddl-schema/wookie-schema.xml Mon Feb 20 14:59:51
2012
@@ -216,40 +216,6 @@
</index>
</table>
- <table name="WidgetDefault">
- <column name="widgetContext" primaryKey="true" required="true" size="255"
type="VARCHAR"/>
- <column name="jpa_version" type="INTEGER"/>
- <column name="widgetId" required="true" type="INTEGER"/>
- <foreign-key foreignTable="Widget" name="FKWidgetDefault1">
- <reference foreign="id" local="widgetId"/>
- </foreign-key>
- <index name="IXWidgetDefault1">
- <index-column name="widgetId"/>
- </index>
- </table>
-
- <table name="WidgetService">
- <column name="id" primaryKey="true" required="true" type="INTEGER"/>
- <column name="jpa_version" type="INTEGER"/>
- <column name="service_name" required="true" size="255" type="VARCHAR"/>
- <index name="IXWidgetService1">
- <index-column name="service_name"/>
- </index>
- </table>
-
- <table name="WidgetType">
- <column name="id" primaryKey="true" required="true" type="INTEGER"/>
- <column name="jpa_version" type="INTEGER"/>
- <column name="widget_context" size="255" type="VARCHAR"/>
- <column name="widget_id" type="INTEGER"/>
- <foreign-key foreignTable="Widget" name="FKWidgetType1">
- <reference foreign="id" local="widget_id"/>
- </foreign-key>
- <index name="IXWidgetType1">
- <index-column name="widget_id"/>
- </index>
- </table>
-
<table name="ApiKey">
<column name="id" primaryKey="true" required="true" type="INTEGER"/>
<column name="jpa_version" type="INTEGER"/>
Added: incubator/wookie/trunk/scripts/migration/0.9.2-to-0.10.0/mysql.sql
URL:
http://svn.apache.org/viewvc/incubator/wookie/trunk/scripts/migration/0.9.2-to-0.10.0/mysql.sql?rev=1291302&view=auto
==============================================================================
--- incubator/wookie/trunk/scripts/migration/0.9.2-to-0.10.0/mysql.sql (added)
+++ incubator/wookie/trunk/scripts/migration/0.9.2-to-0.10.0/mysql.sql Mon Feb
20 14:59:51 2012
@@ -0,0 +1,30 @@
+#
+# Licensed 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.
+#
+
+#
+# MySQL5 database migration script for Apache Wookie (incubating) 0.9.2
+#
+# This script updates a database created with version 0.9.2 of Wookie
+# to work with version 0.10.0. Always use a clone of your database and not the
+# live version when performing migration.
+#
+
+#
+# -----------------------------------------------------------------------
+# Services have been removed (see WOOKIE-263)
+#
+# -----------------------------------------------------------------------
+DROP TABLE IF EXISTS WidgetDefault;
+DROP TABLE IF EXISTS Widgetservice;
+DROP TABLE IF EXISTS WidgetType;
