Author: scottbw
Date: Mon Feb 3 19:31:28 2014
New Revision: 1564019
URL: http://svn.apache.org/r1564019
Log:
added missing properties and schema files from resources package
Added:
wookie/trunk/wookie-server/src/main/resources/org/
wookie/trunk/wookie-server/src/main/resources/org/apache/
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages.properties
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages_nl.properties
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/derby-wookie-schema.sql
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/persistence.properties
Added:
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages.properties
URL:
http://svn.apache.org/viewvc/wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages.properties?rev=1564019&view=auto
==============================================================================
---
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages.properties
(added)
+++
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages.properties
Mon Feb 3 19:31:28 2014
@@ -0,0 +1,113 @@
+widgets.no-widget-file-uploaded=No file found uploaded to server
+widgets.invalid-config-xml=Invalid Widget: Config.xml is not a valid W3C
Widgets configuration document
+widgets.cant-parse-config-xml=Unable to parse the config.xml file
+widgets.bad-zip-file=Invalid Widget: Bad zip file
+widgets.no-start-file=Invalid Widget: No valid custom start file was
specified, and no valid default start file can be located
+widgets.unsupported-content-type=Invalid Widget: Config.xml specifies an
unsupported content type
+
+WidgetAdminServlet.0=New Service Type was added.
+WidgetAdminServlet.2=New uri was added.
+WidgetAdminServlet.3=There was a problem adding the entry.
+WidgetAdminServlet.4=No such operation allowed
+WidgetAdminServlet.5=No operation could be ascertained
+WidgetAdminServlet.6=Service was successfully removed.
+WidgetAdminServlet.7=A problem occurred removing this service.
+WidgetAdminServlet.8=Type was successfully removed from the widget.
+WidgetAdminServlet.9=A problem occured removing this service type.
+WidgetAdminServlet.1=There was a problem adding the new service.
+WidgetAdminServlet.10=Entry was successfully removed.
+WidgetAdminServlet.11=A problem occurred removing this entry.
+WidgetAdminServlet.12=The widget and its resources was successfully deleted.
+WidgetAdminServlet.13=There was a problem deleting the widget resources.
+WidgetAdminServlet.14=There was a problem removing the widget from the system.
+WidgetAdminServlet.15=Widget types were successfully set
+WidgetAdminServlet.16=Successfully created a new entry for this gadget
+WidgetAdminServlet.17=This gadget is already available
+WidgetAdminServlet.18=There was a problem registering this gadget
+WidgetAdminServlet.19=Widget was successfully imported into the system.
+WidgetAdminServlet.20=Widget was successfully updated in the system.
+WidgetAdminServlet.21=The id of this widget cannot be empty - please modifiy
the manifest xml attribute 'id' of the widget element and try again.
+WidgetAdminServlet.22=A custom start file was defined in config.xml, but was
not found in the zip file
+WidgetAdminServlet.23=Invalid Widget:Unable to find config.xml in uploaded
content.
+WidgetAdminServlet.24=No file found uploaded to server
+WidgetAdminServlet.25=Unable to parse the config.xml file
+WidgetAdminServlet.26=test
+WidgetAdminServlet.27=Invalid Widget: No valid custom start file was
specified, and no valid default start file can be located
+WidgetAdminServlet.28=Invalid Widget: Config.xml is not a valid W3C Widgets
configuration document
+WidgetAdminServlet.29=Invalid Widget: Bad zip file
+WidgetAdminServlet.30=Invalid Widget: Config.xml specifies an unsupported
content type
+
+WidgetHotDeploy.0=Hot deploy disabled
+WidgetHotDeploy.1=Hot deploy error: Unable to move dropped .wgt file to upload
folder
+WidgetHotDeploy.2=Hot deploy error: file is not a valid widget package
+WidgetHotDeploy.3=Hot deploy error: widget has invalid manifest
+WidgetHotDeploy.4=Unable to load specified key file, so a new one was generated
+
+WidgetServiceServlet.0=No valid requestid was found.
+WidgetServiceServlet.1=completed
+WidgetServiceServlet.2=Invalid API key
+WidgetServiceServlet.3=Widget instance does not exist
+WidgetServiceServlet.4=could not set property for
+WidgetServiceServlet.5=could not remove participant
+WidgetServiceServlet.6=could not add participant
+
+WidgetWebMenuServlet.0=No such operation allowed
+WidgetWebMenuServlet.1=You must include a valid email address to register for
an API key
+WidgetWebMenuServlet.2=No operation could be ascertained
+WidgetWebMenuServlet.3=Your API key has been sent to your email address
+WidgetWebMenuServlet.4=There was a problem with the API key service
+
+ManifestHelper.0=Unnamed Widget
+ManifestHelper.1=No Description
+ManifestHelper.2=Anonymous
+
+OpenSocialUtils.0=Instance used to create token cannot be null
+OpenSocialUtils.1=Instance cannot be used to create token - invalid content
+
+WidgetKeyManager.0=Your API key is
+WidgetKeyManager.1=You need your API key when communicating with the Widget
server. Please look after it!
+
+WidgetServiceManager.0=This widget type is not supported
+WidgetServiceManager.1=Widget is not supported
+
+WidgetAPIImpl.0=Unauthorised
+WidgetAPIImpl.1=No matching key found
+WidgetAPIImpl.2=Widget Instance is locked by another user
+
+webmenu.index.0=Wookie Widget Server
+webmenu.index.1=Options
+webmenu.index.2=View Widget Gallery
+webmenu.index.3=Administration menu
+webmenu.index.4=Instantiate a widget
+webmenu.index.5=Request an API key for your application
+webmenu.index.6=Main Menu
+
+webmenu.listall.0=Widget Gallery
+webmenu.listall.1=menu
+webmenu.listall.2=Current Widgets
+
+webmenu.instantiate.header.title=Wookie Widget Server
+webmenu.instantiate.menu=menu
+webmenu.instantiate.page.title=Instantiate widget
+webmenu.instantiate.intro=To instantiate a widget, you must supply some
parameters. Use the form below to enter your values and then click submit.
+webmenu.instantiate.form.title=Request widget instance
+webmenu.instantiate.api.key=API key
+webmenu.instantiate.user.id=User ID
+webmenu.instantiate.sharedDataKey=SharedDataKey
+webmenu.instantiate.service.type=Service type
+webmenu.instantiate.submit=Submit
+
+webmenu.requestapikey.0=Wookie Widget Server
+webmenu.requestapikey.1=menu
+webmenu.requestapikey.2=Ok
+webmenu.requestapikey.3=To request an API key, enter your email address and
click 'Request key'
+webmenu.requestapikey.4=Request key
+webmenu.requestapikey.5=Invalid email address
+webmenu.requestapikey.6=Request an API key
+webmenu.requestapikey.7=Email
+webmenu.requestapikey.8=Warning
+
+webmenu.demo.title=Widget Demo
+
+webmenu.home.menu=Menu
+
Added:
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages_nl.properties
URL:
http://svn.apache.org/viewvc/wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages_nl.properties?rev=1564019&view=auto
==============================================================================
---
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages_nl.properties
(added)
+++
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/Messages_nl.properties
Mon Feb 3 19:31:28 2014
@@ -0,0 +1,113 @@
+widgets.no-widget-file-uploaded=No file found uploaded to server
+widgets.invalid-config-xml=Invalid Widget: Config.xml is not a valid W3C
Widgets configuration document
+widgets.cant-parse-config-xml=Unable to parse the config.xml file
+widgets.bad-zip-file=Invalid Widget: Bad zip file
+widgets.no-start-file=Invalid Widget: No valid custom start file was
specified, and no valid default start file can be located
+widgets.unsupported-content-type=Invalid Widget: Config.xml specifies an
unsupported content type
+
+WidgetAdminServlet.0=New Service Type was added.(dutch)
+WidgetAdminServlet.2=New uri was added.(dutch)
+WidgetAdminServlet.3=There was a problem adding the entry.(dutch)
+WidgetAdminServlet.4=No such operation allowed(dutch)
+WidgetAdminServlet.5=No operation could be ascertained(dutch)
+WidgetAdminServlet.6=Service was successfully removed.(dutch)
+WidgetAdminServlet.7=A problem occured removing this service.(dutch)
+WidgetAdminServlet.8=Type was successfully removed from the widget.(dutch)
+WidgetAdminServlet.9=A problem occured removing this service type.(dutch)
+WidgetAdminServlet.1=There was a problem adding the new service.(dutch)
+WidgetAdminServlet.10=Entry was successfully removed.(dutch)
+WidgetAdminServlet.11=A problem occured removing this entry.(dutch)
+WidgetAdminServlet.12=The widget and its resources was successfully
deleted.(dutch)
+WidgetAdminServlet.13=There was a problem deleting the widget resources.(dutch)
+WidgetAdminServlet.14=There was a problem removing the widget from the
system.(dutch)
+WidgetAdminServlet.15=Widget types were successfully set(dutch)
+WidgetAdminServlet.16=Successfully created a new entry for this gadget(dutch)
+WidgetAdminServlet.17=Couldn't create a new entry for this gadget(dutch)
+WidgetAdminServlet.18=There was a problem registering this gadget(dutch)
+WidgetAdminServlet.19=Widget was successfully imported into the system.(dutch)
+WidgetAdminServlet.20=Widget was successfully updated in the system.(dutch)
+WidgetAdminServlet.21=The id of this widget cannot be empty - please modifiy
the manifest xml attribute 'id' of the widget element and try again.(dutch)
+WidgetAdminServlet.22=Referenced start page not found in zip file(dutch)
+WidgetAdminServlet.23=Unable to find manifest file in uploaded content.(dutch)
+WidgetAdminServlet.24=No file found uploaded to server(dutch)
+WidgetAdminServlet.25=Unable to parse the config.xml file(dutch)
+WidgetAdminServlet.26=Test
+WidgetAdminServlet.27=Invalid Widget: No valid custom start file was
specified, and no valid default start file can be located(dutch)
+WidgetAdminServlet.28=Invalid Widget: Config.xml is not a valid W3C Widgets
configuration document(dutch)
+WidgetAdminServlet.29=Invalid Widget: Bad zip file(dutch)
+WidgetAdminServlet.30=Invalid Widget: Config.xml specifies an unsupported
content type (dutch)
+
+WidgetHotDeploy.0=Hot deploy disabled (dutch)
+WidgetHotDeploy.1=Hot deploy error: Unable to move dropped .wgt file to upload
folder (dutch)
+WidgetHotDeploy.2=Hot deploy error: file is not a valid widget package (dutch)
+WidgetHotDeploy.3=Hot deploy error: widget has invalid manifest (dutch)
+WidgetHotDeploy.4=Unable to load specified key file, so a new one was
generated (dutch)
+
+WidgetServiceServlet.0=No valid requestid was found.(dutch)
+WidgetServiceServlet.1=completed(dutch)
+WidgetServiceServlet.2=Invalid API key(dutch)
+WidgetServiceServlet.3=Widget instance does not exist(dutch)
+WidgetServiceServlet.4=could not set property for(dutch)
+
+WidgetWebMenuServlet.0=No such operation allowed(dutch)
+WidgetWebMenuServlet.1=You must include a valid email address to register for
an API key(dutch)
+WidgetWebMenuServlet.2=No operation could be ascertained(dutch)
+WidgetWebMenuServlet.3=Your API key has been sent to your email address(dutch)
+WidgetWebMenuServlet.4=There was a problem with the API key service(dutch)
+
+ManifestHelper.0=Unnamed Widget(dutch)
+ManifestHelper.1=No Description(dutch)
+ManifestHelper.2=Anonymous(dutch)
+ManifestHelper.3=uploading file...(dutch)
+ManifestHelper.4=Upload completed successfully(dutch)
+
+OpenSocialUtils.0=Instance used to create token cannot be null(dutch)
+OpenSocialUtils.1=Instance cannot be used to create token - invalid
content(dutch)
+
+WidgetKeyManager.0=Your API key is (dutch)
+WidgetKeyManager.1=You need your API key when communicating with the Widget
server. Please look after it!(dutch)
+
+WidgetServiceManager.0=This widget type is not supported (dutch)
+WidgetServiceManager.1=Widget is not supported (dutch)
+
+WidgetAPIImpl.0=Unauthorised (dutch)
+WidgetAPIImpl.1=No matching key found (dutch)
+WidgetAPIImpl.2=Widget Instance is locked by another user (dutch)
+
+webmenu.index.0=Wookie Widget Server (dutch)
+webmenu.index.1=Options (dutch)
+webmenu.index.2=View Widget Gallery (dutch)
+webmenu.index.3=Administration menu (dutch)
+webmenu.index.4=Instantiate a widget (dutch)
+webmenu.index.5=Request an API key for your application (dutch)
+webmenu.index.6=Main Menu (dutch)
+
+webmenu.listall.0=Widget Gallery (dutch)
+webmenu.listall.1=menu (dutch)
+webmenu.listall.2=Current Widgets (dutch)
+
+
+webmenu.instantiate.header.title=Wookie Widget Server (dutch)
+webmenu.instantiate.menu=menu (dutch)
+webmenu.instantiate.page.title=Instantiate widget (dutch)
+webmenu.instantiate.intro=To instantiate a widget, you must supply some
parameters. Use the form below to enter your values and then click submit.
(dutch)
+webmenu.instantiate.form.title=Request widget instance (dutch)
+webmenu.instantiate.api.key=API key (dutch)
+webmenu.instantiate.user.id=User ID (dutch)
+webmenu.instantiate.sharedDataKey=SharedDataKey (dutch)
+webmenu.instantiate.service.type=Service type (dutch)
+webmenu.instantiate.submit=Submit (dutch)
+
+webmenu.requestapikey.0=Wookie Widget Server (dutch)
+webmenu.requestapikey.1=menu (dutch)
+webmenu.requestapikey.2=Ok (dutch)
+webmenu.requestapikey.3=To request an API key, enter your email address and
click 'Request key' (dutch)
+webmenu.requestapikey.4=Request key (dutch)
+webmenu.requestapikey.5=Invalid email address (dutch)
+webmenu.requestapikey.6=Request an API key (dutch)
+webmenu.requestapikey.7=Email (dutch)
+webmenu.requestapikey.8=Warning (dutch)
+
+webmenu.demo.title=Widget Demo (dutch)
+
+webmenu.home.menu=Menu (dutch)
Added:
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/derby-wookie-schema.sql
URL:
http://svn.apache.org/viewvc/wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/derby-wookie-schema.sql?rev=1564019&view=auto
==============================================================================
---
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/derby-wookie-schema.sql
(added)
+++
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/derby-wookie-schema.sql
Mon Feb 3 19:31:28 2014
@@ -0,0 +1,460 @@
+ALTER TABLE OAuthToken
+ DROP CONSTRAINT FKOAuthToken1;
+
+ALTER TABLE Param
+ DROP CONSTRAINT FKParam1;
+
+ALTER TABLE Feature
+ DROP CONSTRAINT FKFeature1;
+
+ALTER TABLE SharedData
+ DROP CONSTRAINT FKSharedData1;
+
+ALTER TABLE Preference
+ DROP CONSTRAINT FKPreference1;
+
+ALTER TABLE PreferenceDefault
+ DROP CONSTRAINT FKPreferenceDefault1;
+
+ALTER TABLE WidgetInstance
+ DROP CONSTRAINT FKWidgetInstance1;
+
+ALTER TABLE StartFile
+ DROP CONSTRAINT FKStartFile1;
+
+ALTER TABLE Description
+ DROP CONSTRAINT FKDescription1;
+
+ALTER TABLE Author
+ DROP CONSTRAINT FKAuthor1;
+
+ALTER TABLE Name
+ DROP CONSTRAINT FKName1;
+
+ALTER TABLE License
+ DROP CONSTRAINT FKLicense1;
+
+ALTER TABLE WidgetIcon
+ DROP CONSTRAINT FKWidgetIcon1;
+
+-- -----------------------------------------------------------------------
+-- OAuthToken
+-- -----------------------------------------------------------------------
+
+DROP TABLE OAuthToken;
+
+-- -----------------------------------------------------------------------
+-- Param
+-- -----------------------------------------------------------------------
+
+DROP TABLE Param;
+
+-- -----------------------------------------------------------------------
+-- Feature
+-- -----------------------------------------------------------------------
+
+DROP TABLE Feature;
+
+-- -----------------------------------------------------------------------
+-- SharedData
+-- -----------------------------------------------------------------------
+
+DROP TABLE SharedData;
+
+-- -----------------------------------------------------------------------
+-- Preference
+-- -----------------------------------------------------------------------
+
+DROP TABLE Preference;
+
+-- -----------------------------------------------------------------------
+-- Participant
+-- -----------------------------------------------------------------------
+
+DROP TABLE Participant;
+
+-- -----------------------------------------------------------------------
+-- PreferenceDefault
+-- -----------------------------------------------------------------------
+
+DROP TABLE PreferenceDefault;
+
+-- -----------------------------------------------------------------------
+-- WidgetInstance
+-- -----------------------------------------------------------------------
+
+DROP TABLE WidgetInstance;
+
+-- -----------------------------------------------------------------------
+-- StartFile
+-- -----------------------------------------------------------------------
+
+DROP TABLE StartFile;
+
+-- -----------------------------------------------------------------------
+-- Description
+-- -----------------------------------------------------------------------
+
+DROP TABLE Description;
+
+-- -----------------------------------------------------------------------
+-- Author
+-- -----------------------------------------------------------------------
+
+DROP TABLE Author;
+
+-- -----------------------------------------------------------------------
+-- Name
+-- -----------------------------------------------------------------------
+
+DROP TABLE Name;
+
+-- -----------------------------------------------------------------------
+-- License
+-- -----------------------------------------------------------------------
+
+DROP TABLE License;
+
+-- -----------------------------------------------------------------------
+-- WidgetIcon
+-- -----------------------------------------------------------------------
+
+DROP TABLE WidgetIcon;
+
+-- -----------------------------------------------------------------------
+-- Widget
+-- -----------------------------------------------------------------------
+
+DROP TABLE Widget;
+
+-- -----------------------------------------------------------------------
+-- OPENJPA_SEQUENCE_TABLE
+-- -----------------------------------------------------------------------
+
+DROP TABLE OPENJPA_SEQUENCE_TABLE;
+
+-- -----------------------------------------------------------------------
+-- OPENJPA_SEQUENCE_TABLE
+-- -----------------------------------------------------------------------
+
+CREATE TABLE OPENJPA_SEQUENCE_TABLE
+(
+ ID SMALLINT NOT NULL,
+ SEQUENCE_VALUE BIGINT,
+ PRIMARY KEY (ID)
+);
+
+-- -----------------------------------------------------------------------
+-- Widget
+-- -----------------------------------------------------------------------
+
+CREATE TABLE Widget
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ package_path VARCHAR(255),
+ default_locale VARCHAR(255),
+ height INTEGER,
+ width INTEGER,
+ guid VARCHAR(255) NOT NULL,
+ update_location LONG VARCHAR,
+ widget_version VARCHAR(255),
+ dir VARCHAR(255),
+ lang VARCHAR(255),
+ PRIMARY KEY (id)
+);
+
+CREATE UNIQUE INDEX UNWidget1 ON Widget (guid);
+
+-- -----------------------------------------------------------------------
+-- WidgetIcon
+-- -----------------------------------------------------------------------
+
+CREATE TABLE WidgetIcon
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ src LONG VARCHAR,
+ height INTEGER,
+ width INTEGER,
+ lang VARCHAR(255),
+ widget_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXWidgetIcon1 ON WidgetIcon (widget_id);
+
+-- -----------------------------------------------------------------------
+-- License
+-- -----------------------------------------------------------------------
+
+CREATE TABLE License
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ href LONG VARCHAR,
+ text LONG VARCHAR,
+ dir VARCHAR(255),
+ lang VARCHAR(255),
+ widget_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXLicense1 ON License (widget_id);
+
+-- -----------------------------------------------------------------------
+-- Name
+-- -----------------------------------------------------------------------
+
+CREATE TABLE Name
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ name LONG VARCHAR,
+ shortName VARCHAR(255),
+ dir VARCHAR(255),
+ lang VARCHAR(255),
+ widget_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXName1 ON Name (widget_id);
+
+-- -----------------------------------------------------------------------
+-- Author
+-- -----------------------------------------------------------------------
+
+CREATE TABLE Author
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ author LONG VARCHAR,
+ email LONG VARCHAR,
+ href LONG VARCHAR,
+ lang VARCHAR(255),
+ dir VARCHAR(255),
+ widget_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXAuthor1 ON Author (widget_id);
+
+-- -----------------------------------------------------------------------
+-- Description
+-- -----------------------------------------------------------------------
+
+CREATE TABLE Description
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ content LONG VARCHAR,
+ dir VARCHAR(255),
+ lang VARCHAR(255),
+ widget_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXDescription1 ON Description (widget_id);
+
+-- -----------------------------------------------------------------------
+-- StartFile
+-- -----------------------------------------------------------------------
+
+CREATE TABLE StartFile
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ url LONG VARCHAR,
+ charset VARCHAR(255),
+ lang VARCHAR(255),
+ widget_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXStartFile1 ON StartFile (widget_id);
+
+-- -----------------------------------------------------------------------
+-- WidgetInstance
+-- -----------------------------------------------------------------------
+
+CREATE TABLE WidgetInstance
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ apikey VARCHAR(255) NOT NULL,
+ userId VARCHAR(255) NOT NULL,
+ sharedDataKey VARCHAR(255),
+ nonce VARCHAR(255),
+ idKey VARCHAR(255) NOT NULL,
+ opensocialToken LONG VARCHAR NOT NULL,
+ widget_id INTEGER NOT NULL,
+ updated CHAR(1),
+ shown CHAR(1),
+ hidden CHAR(1),
+ locked CHAR(1),
+ lang VARCHAR(255),
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXWidgetInstance1 ON WidgetInstance (widget_id);
+
+CREATE UNIQUE INDEX UNWidgetInstance1 ON WidgetInstance (idKey);
+
+-- -----------------------------------------------------------------------
+-- PreferenceDefault
+-- -----------------------------------------------------------------------
+
+CREATE TABLE PreferenceDefault
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ widget_id INTEGER,
+ preference VARCHAR(255) NOT NULL,
+ value VARCHAR(1024) NOT NULL,
+ readOnly CHAR(1),
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXPreferenceDefault1 ON PreferenceDefault (widget_id);
+
+-- -----------------------------------------------------------------------
+-- Participant
+-- -----------------------------------------------------------------------
+
+CREATE TABLE Participant
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ participant_id VARCHAR(255) NOT NULL,
+ participant_display_name VARCHAR(255) NOT NULL,
+ participant_thumbnail_url VARCHAR(1024),
+ sharedDataKey VARCHAR(255) NOT NULL,
+ role VARCHAR(255),
+ PRIMARY KEY (id)
+);
+
+-- -----------------------------------------------------------------------
+-- Preference
+-- -----------------------------------------------------------------------
+
+CREATE TABLE Preference
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ widget_instance_id INTEGER,
+ dkey VARCHAR(255),
+ dvalue LONG VARCHAR,
+ readOnly CHAR(1),
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXPreference1 ON Preference (widget_instance_id);
+
+CREATE UNIQUE INDEX UNPreference1 ON Preference (widget_instance_id, dkey);
+
+-- -----------------------------------------------------------------------
+-- SharedData
+-- -----------------------------------------------------------------------
+
+CREATE TABLE SharedData
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ sharedDataKey VARCHAR(255),
+ dkey VARCHAR(255),
+ dvalue LONG VARCHAR,
+ widget_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXSharedData1 ON SharedData (widget_id);
+
+-- -----------------------------------------------------------------------
+-- Feature
+-- -----------------------------------------------------------------------
+
+CREATE TABLE Feature
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ featureName VARCHAR(255) NOT NULL,
+ required CHAR(1),
+ widget_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXFeature1 ON Feature (widget_id);
+
+-- -----------------------------------------------------------------------
+-- Param
+-- -----------------------------------------------------------------------
+
+CREATE TABLE Param
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ feature_id INTEGER,
+ parameterName VARCHAR(255) NOT NULL,
+ parameterValue VARCHAR(255) NOT NULL,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXParam1 ON Param (feature_id);
+
+-- -----------------------------------------------------------------------
+-- OAuthToken
+-- -----------------------------------------------------------------------
+
+CREATE TABLE OAuthToken
+(
+ id INTEGER NOT NULL,
+ jpa_version INTEGER,
+ authzUrl VARCHAR(255) NOT NULL,
+ accessToken VARCHAR(255) NOT NULL,
+ clientId VARCHAR(255) NOT NULL,
+ expires BIGINT NOT NULL,
+ widget_instance_id INTEGER,
+ PRIMARY KEY (id)
+);
+
+CREATE INDEX IXOAuthToken1 ON OAuthToken (widget_instance_id);
+
+ALTER TABLE WidgetIcon
+ ADD CONSTRAINT FKWidgetIcon1 FOREIGN KEY (widget_id) REFERENCES Widget
(id);
+
+ALTER TABLE License
+ ADD CONSTRAINT FKLicense1 FOREIGN KEY (widget_id) REFERENCES Widget (id);
+
+ALTER TABLE Name
+ ADD CONSTRAINT FKName1 FOREIGN KEY (widget_id) REFERENCES Widget (id);
+
+ALTER TABLE Author
+ ADD CONSTRAINT FKAuthor1 FOREIGN KEY (widget_id) REFERENCES Widget (id);
+
+ALTER TABLE Description
+ ADD CONSTRAINT FKDescription1 FOREIGN KEY (widget_id) REFERENCES Widget
(id);
+
+ALTER TABLE StartFile
+ ADD CONSTRAINT FKStartFile1 FOREIGN KEY (widget_id) REFERENCES Widget (id);
+
+ALTER TABLE WidgetInstance
+ ADD CONSTRAINT FKWidgetInstance1 FOREIGN KEY (widget_id) REFERENCES Widget
(id);
+
+ALTER TABLE PreferenceDefault
+ ADD CONSTRAINT FKPreferenceDefault1 FOREIGN KEY (widget_id) REFERENCES
Widget (id);
+
+ALTER TABLE Preference
+ ADD CONSTRAINT FKPreference1 FOREIGN KEY (widget_instance_id) REFERENCES
WidgetInstance (id);
+
+ALTER TABLE SharedData
+ ADD CONSTRAINT FKSharedData1 FOREIGN KEY (widget_id) REFERENCES Widget
(id);
+
+ALTER TABLE Feature
+ ADD CONSTRAINT FKFeature1 FOREIGN KEY (widget_id) REFERENCES Widget (id);
+
+ALTER TABLE Param
+ ADD CONSTRAINT FKParam1 FOREIGN KEY (feature_id) REFERENCES Feature (id);
+
+ALTER TABLE OAuthToken
+ ADD CONSTRAINT FKOAuthToken1 FOREIGN KEY (widget_instance_id) REFERENCES
WidgetInstance (id);
+
Added:
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/persistence.properties
URL:
http://svn.apache.org/viewvc/wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/persistence.properties?rev=1564019&view=auto
==============================================================================
---
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/persistence.properties
(added)
+++
wookie/trunk/wookie-server/src/main/resources/org/apache/wookie/beans/jpa/persistence.properties
Mon Feb 3 19:31:28 2014
@@ -0,0 +1,19 @@
+# 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.
+
+openjpa.Log=log4j
+openjpa.jdbc.SchemaFactory=native(ForeignKeys=true)
+openjpa.DataCache=true(CacheSize=1000,SoftReferenceSize=0)
+openjpa.QueryCache=CacheSize=100,SoftReferenceSize=0
+openjpa.DataCacheTimeout=3600000
+openjpa.RemoteCommitProvider=sjvm
+#openjpa.RemoteCommitProvider=tcp(Port=5636,Addresses=10.0.0.1;10.0.0.2)
