blob: 4a68575a5c91cf5d9d820f420e712230df079038 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<!--
/*
* $Id$
*
* 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.
*/
-->
<architect-project version="1.0" appversion="0.9.10">
<project-name>tiles</project-name>
<project-data-sources>
<data-source id="DS0">
<property key="Logical" value="Not Configured" />
</data-source>
<data-source id="DS2">
<property key="Connection Type" value="HSQLDB" />
<property key="Logical" value="Tiles in file" />
<property key="JDBC URL" value="jdbc:hsqldb:file:/home/antonio/javadev/db/tiles;shutdown=true" />
<property key="UID" value="sa" />
<property key="PWD" value="" />
<property key="ca.sqlpower.architect.etl.kettle.database" value="" />
<property key="ca.sqlpower.architect.etl.kettle.port" value="" />
<property key="ca.sqlpower.architect.etl.kettle.hostname" value="" />
<property key="ca.sqlpower.architect.etl.kettle.repos.login" value="" />
<property key="ca.sqlpower.architect.etl.kettle.repos.password" value="" />
</data-source>
<data-source id="DS2">
<property key="Connection Type" value="HSQLDB" />
<property key="Logical" value="Tiles in file" />
<property key="JDBC URL" value="jdbc:hsqldb:file:/home/antonio/javadev/db/tiles;shutdown=true" />
<property key="UID" value="sa" />
<property key="PWD" value="" />
<property key="ca.sqlpower.architect.etl.kettle.database" value="" />
<property key="ca.sqlpower.architect.etl.kettle.port" value="" />
<property key="ca.sqlpower.architect.etl.kettle.hostname" value="" />
<property key="ca.sqlpower.architect.etl.kettle.repos.login" value="" />
<property key="ca.sqlpower.architect.etl.kettle.repos.password" value="" />
</data-source>
</project-data-sources>
<source-databases>
<database id="DB0" populated="true" dbcs-ref="DS2" name="Tiles in file" physicalName="Tiles in memory" >
<schema id="SCH1" populated="false" name="INFORMATION_SCHEMA" nativeTerm="schema" physicalName="INFORMATION_SCHEMA" />
<schema id="SCH2" populated="true" name="PUBLIC" nativeTerm="schema" physicalName="PUBLIC" >
<table id="TAB3" populated="true" name="ATTRIBUTE" objectType="TABLE" physicalName="ATTRIBUTE" >
<folder id="FOL4" populated="false" name="Columns" physicalName="Columns" type="1" />
<folder id="FOL5" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
<folder id="FOL6" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
<folder id="FOL7" populated="false" name="Indices" physicalName="Indices" type="4" />
</table>
<table id="TAB8" populated="true" name="ATTRIBUTE_VISIBLE_FOR" objectType="TABLE" physicalName="ATTRIBUTE_VISIBLE_FOR" >
<folder id="FOL9" populated="false" name="Columns" physicalName="Columns" type="1" />
<folder id="FOL10" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
<folder id="FOL11" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
<folder id="FOL12" populated="false" name="Indices" physicalName="Indices" type="4" />
</table>
<table id="TAB13" populated="true" name="CUSTOMIZATION" objectType="TABLE" physicalName="CUSTOMIZATION" >
<folder id="FOL14" populated="false" name="Columns" physicalName="Columns" type="1" />
<folder id="FOL15" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
<folder id="FOL16" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
<folder id="FOL17" populated="false" name="Indices" physicalName="Indices" type="4" />
</table>
<table id="TAB18" populated="true" name="DEFINITION" objectType="TABLE" physicalName="DEFINITION" >
<folder id="FOL19" populated="false" name="Columns" physicalName="Columns" type="1" />
<folder id="FOL20" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
<folder id="FOL21" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
<folder id="FOL22" populated="false" name="Indices" physicalName="Indices" type="4" />
</table>
<table id="TAB23" populated="true" name="ROLE" objectType="TABLE" physicalName="ROLE" >
<folder id="FOL24" populated="false" name="Columns" physicalName="Columns" type="1" />
<folder id="FOL25" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
<folder id="FOL26" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
<folder id="FOL27" populated="false" name="Indices" physicalName="Indices" type="4" />
</table>
<table id="TAB28" populated="true" name="VISIBLE_FOR" objectType="TABLE" physicalName="VISIBLE_FOR" >
<folder id="FOL29" populated="false" name="Columns" physicalName="Columns" type="1" />
<folder id="FOL30" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
<folder id="FOL31" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
<folder id="FOL32" populated="false" name="Indices" physicalName="Indices" type="4" />
</table>
</schema>
<relationships>
</relationships>
</database>
<database id="DB33" populated="true" dbcs-ref="DS2" name="Tiles in file" physicalName="Tiles in file" >
<schema id="SCH34" populated="true" name="INFORMATION_SCHEMA" nativeTerm="schema" physicalName="INFORMATION_SCHEMA" >
</schema>
<schema id="SCH35" populated="true" name="PUBLIC" nativeTerm="schema" physicalName="PUBLIC" >
</schema>
<relationships>
</relationships>
</database>
</source-databases>
<target-database dbcs-ref="DS0">
<table id="TAB36" populated="true" name="Definition" objectType="TABLE" physicalName="Definition" remarks="" >
<folder id="FOL37" populated="true" name="Columns" physicalName="Columns" type="1" >
<column id="COL38" populated="true" autoIncrement="false" autoIncrementSequenceName="Definition_seq" name="id" nullable="0" physicalName="id" precision="12" primaryKeySeq="0" referenceCount="2" remarks="" scale="0" type="2" />
<column id="COL39" populated="true" autoIncrement="false" autoIncrementSequenceName="Definition_name_seq" name="name" nullable="0" physicalName="name" precision="255" referenceCount="1" remarks="" scale="0" type="12" />
<column id="COL40" populated="true" autoIncrement="false" autoIncrementSequenceName="Definition_preparer_seq" name="preparer" nullable="1" physicalName="preparer" precision="1000" referenceCount="1" remarks="" scale="0" type="12" />
<column id="COL41" populated="true" autoIncrement="false" autoIncrementSequenceName="Definition_template_seq" name="template" nullable="1" physicalName="template" precision="1000" referenceCount="1" remarks="" scale="0" type="12" />
<column id="COL42" populated="true" autoIncrement="false" autoIncrementSequenceName="Definition_Customization_id_seq" name="Customization_id" nullable="0" physicalName="Customization_id" precision="12" referenceCount="1" remarks="" scale="0" type="2" />
<column id="COL43" populated="true" autoIncrement="false" autoIncrementSequenceName="Definition_parent_name_seq" name="parent_name" nullable="1" physicalName="parent_name" precision="255" referenceCount="1" remarks="" scale="0" type="12" />
</folder>
<folder id="FOL44" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
</folder>
<folder id="FOL45" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
</folder>
<folder id="FOL46" populated="true" name="Indices" physicalName="Indices" type="4" >
<index id="IDX47" populated="true" clustered="false" name="Definition_pk" physicalName="Definition_pk" primaryKeyIndex="true" unique="true" >
<index-column id="IDC48" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL38" name="id" physicalName="id" />
</index>
<index id="IDX49" populated="true" clustered="false" name="Definition_idx" physicalName="Definition_idx" primaryKeyIndex="false" unique="false" >
<index-column id="IDC50" populated="true" ascendingOrDescending="ASCENDING" column-ref="COL39" name="name" physicalName="name" />
</index>
</folder>
</table>
<table id="TAB51" populated="true" name="Attribute" objectType="TABLE" physicalName="Attribute" remarks="" >
<folder id="FOL52" populated="true" name="Columns" physicalName="Columns" type="1" >
<column id="COL53" populated="true" autoIncrement="false" autoIncrementSequenceName="Attribute_seq" name="id" nullable="0" physicalName="id" precision="12" primaryKeySeq="0" referenceCount="2" remarks="" scale="0" type="2" />
<column id="COL54" populated="true" autoIncrement="false" autoIncrementSequenceName="Attribute_name_seq" name="name" nullable="0" physicalName="name" precision="255" referenceCount="1" remarks="" scale="0" type="12" />
<column id="COL55" populated="true" autoIncrement="false" autoIncrementSequenceName="Attribute_type_seq" name="type" nullable="1" physicalName="type" precision="255" referenceCount="1" remarks="" scale="0" type="12" />
<column id="COL56" populated="true" autoIncrement="false" autoIncrementSequenceName="Attribute_value_seq" name="value" nullable="0" physicalName="value" precision="1000" referenceCount="1" remarks="" scale="0" type="12" />
<column id="COL57" populated="true" autoIncrement="false" autoIncrementSequenceName="Attribute_cascade_attribute_seq" name="cascade_attribute" nullable="0" physicalName="cascade_attribute" precision="10" referenceCount="1" remarks="" scale="0" type="16" />
<column id="COL58" populated="true" autoIncrement="false" autoIncrementSequenceName="Attribute_Definition_id_seq" name="Definition_id" nullable="1" physicalName="Definition_id" precision="12" referenceCount="1" remarks="" scale="0" type="2" />
<column id="COL59" populated="true" autoIncrement="false" autoIncrementSequenceName="Attribute_seq" name="Parent_id" nullable="1" physicalName="Parent_id" precision="12" referenceCount="1" remarks="" scale="0" type="2" />
</folder>
<folder id="FOL60" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
</folder>
<folder id="FOL61" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
</folder>
<folder id="FOL62" populated="true" name="Indices" physicalName="Indices" type="4" >
<index id="IDX63" populated="true" clustered="false" name="Attribute_pk" physicalName="Attribute_pk" primaryKeyIndex="true" unique="true" >
<index-column id="IDC64" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL53" name="id" physicalName="id" />
</index>
</folder>
</table>
<table id="TAB65" populated="true" name="Role" objectType="TABLE" physicalName="Role" remarks="" >
<folder id="FOL66" populated="true" name="Columns" physicalName="Columns" type="1" >
<column id="COL67" populated="true" autoIncrement="false" autoIncrementSequenceName="Role_seq" name="id" nullable="0" physicalName="id" precision="12" primaryKeySeq="0" referenceCount="1" remarks="" scale="0" type="2" />
<column id="COL68" populated="true" autoIncrement="false" autoIncrementSequenceName="Role_name_seq" name="name" nullable="0" physicalName="name" precision="255" referenceCount="1" remarks="" scale="0" type="12" />
</folder>
<folder id="FOL69" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
</folder>
<folder id="FOL70" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
</folder>
<folder id="FOL71" populated="true" name="Indices" physicalName="Indices" type="4" >
<index id="IDX72" populated="true" clustered="false" name="Role_pk" physicalName="Role_pk" primaryKeyIndex="true" unique="true" >
<index-column id="IDC73" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL67" name="id" physicalName="id" />
</index>
<index id="IDX74" populated="true" clustered="false" name="Role_idx" physicalName="Role_idx" primaryKeyIndex="false" unique="false" >
<index-column id="IDC75" populated="true" ascendingOrDescending="ASCENDING" column-ref="COL68" name="name" physicalName="name" />
</index>
</folder>
</table>
<table id="TAB76" populated="true" name="Customization" objectType="TABLE" physicalName="Customization" remarks="" >
<folder id="FOL77" populated="true" name="Columns" physicalName="Columns" type="1" >
<column id="COL78" populated="true" autoIncrement="false" autoIncrementSequenceName="Customization_seq" name="id" nullable="0" physicalName="id" precision="12" primaryKeySeq="0" referenceCount="1" remarks="" scale="0" type="2" />
<column id="COL79" populated="true" autoIncrement="false" autoIncrementSequenceName="Customization_seq" name="Parent_id" nullable="1" physicalName="Parent_id" precision="12" referenceCount="1" remarks="" scale="0" type="2" />
<column id="COL80" populated="true" autoIncrement="false" autoIncrementSequenceName="Customization_name_seq" name="name" nullable="0" physicalName="name" precision="255" referenceCount="1" remarks="" scale="0" type="12" />
</folder>
<folder id="FOL81" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
</folder>
<folder id="FOL82" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
</folder>
<folder id="FOL83" populated="true" name="Indices" physicalName="Indices" type="4" >
<index id="IDX84" populated="true" clustered="false" name="Customization_pk" physicalName="Customization_pk" primaryKeyIndex="true" unique="true" >
<index-column id="IDC85" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL78" name="id" physicalName="id" />
</index>
<index id="IDX86" populated="true" clustered="false" name="Customization_idx" physicalName="Customization_idx" primaryKeyIndex="false" unique="false" >
<index-column id="IDC87" populated="true" ascendingOrDescending="ASCENDING" column-ref="COL80" name="name" physicalName="name" />
</index>
<index id="IDX88" populated="true" clustered="false" name="Customization_idx1" physicalName="Customization_idx1" primaryKeyIndex="false" unique="false" >
<index-column id="IDC89" populated="true" ascendingOrDescending="ASCENDING" column-ref="COL80" name="name" physicalName="name" />
</index>
</folder>
</table>
<table id="TAB90" populated="true" name="Visible_for" objectType="TABLE" physicalName="Visible_for" remarks="" >
<folder id="FOL91" populated="true" name="Columns" physicalName="Columns" type="1" >
<column id="COL92" populated="true" autoIncrement="false" autoIncrementSequenceName="Definition_seq" name="Definition_id" nullable="0" physicalName="Definition_id" precision="12" primaryKeySeq="0" referenceCount="1" remarks="" scale="0" type="2" />
<column id="COL93" populated="true" autoIncrement="false" autoIncrementSequenceName="Role_seq" name="Role_id" nullable="0" physicalName="Role_id" precision="12" primaryKeySeq="1" referenceCount="1" remarks="" scale="0" type="2" />
</folder>
<folder id="FOL94" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
</folder>
<folder id="FOL95" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
</folder>
<folder id="FOL96" populated="true" name="Indices" physicalName="Indices" type="4" >
<index id="IDX97" populated="true" clustered="false" name="Visible_for_pk" physicalName="Visible_for_pk" primaryKeyIndex="true" unique="true" >
<index-column id="IDC98" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL92" name="Definition_id" physicalName="Definition_id" />
<index-column id="IDC99" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL93" name="Role_id" physicalName="Role_id" />
</index>
</folder>
</table>
<table id="TAB100" populated="true" name="Attribute_visible_for" objectType="TABLE" physicalName="Attribute_visible_for" remarks="" >
<folder id="FOL101" populated="true" name="Columns" physicalName="Columns" type="1" >
<column id="COL102" populated="true" autoIncrement="false" autoIncrementSequenceName="Attribute_seq" name="Attribute_id" nullable="0" physicalName="Attribute_id" precision="12" primaryKeySeq="0" referenceCount="1" remarks="" scale="0" type="2" />
<column id="COL103" populated="true" autoIncrement="false" autoIncrementSequenceName="Role_seq" name="Role_id" nullable="0" physicalName="Role_id" precision="12" primaryKeySeq="1" referenceCount="1" remarks="" scale="0" type="2" />
</folder>
<folder id="FOL104" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
</folder>
<folder id="FOL105" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
</folder>
<folder id="FOL106" populated="true" name="Indices" physicalName="Indices" type="4" >
<index id="IDX107" populated="true" clustered="false" name="Attribute_visible_for_pk" physicalName="Attribute_visible_for_pk" primaryKeyIndex="true" unique="true" >
<index-column id="IDC108" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL102" name="Attribute_id" physicalName="Attribute_id" />
<index-column id="IDC109" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL103" name="Role_id" physicalName="Role_id" />
</index>
</folder>
</table>
<relationships>
<relationship id="REL110" populated="true" deferrability="7" deleteRule="0" fk-table-ref="TAB51" fkCardinality="7" identifying="false" name="Definition_Attribute_fk" physicalName="Definition_Attribute_fk" pk-table-ref="TAB36" pkCardinality="3" updateRule="0" >
<column-mapping id="CMP111" populated="true" fk-column-ref="COL58" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL38" />
</relationship>
<relationship id="REL112" populated="true" deferrability="7" deleteRule="0" fk-table-ref="TAB90" fkCardinality="7" identifying="true" name="Definition_Visible_for_fk" physicalName="Definition_Visible_for_fk" pk-table-ref="TAB36" pkCardinality="2" updateRule="0" >
<column-mapping id="CMP113" populated="true" fk-column-ref="COL92" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL38" />
</relationship>
<relationship id="REL114" populated="true" deferrability="7" deleteRule="0" fk-table-ref="TAB36" fkCardinality="7" identifying="true" name="Customization_Definition_fk" physicalName="Customization_Definition_fk" pk-table-ref="TAB76" pkCardinality="2" updateRule="0" >
<column-mapping id="CMP115" populated="true" fk-column-ref="COL42" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL78" />
</relationship>
<relationship id="REL116" populated="true" deferrability="7" deleteRule="0" fk-table-ref="TAB51" fkCardinality="7" identifying="false" name="Attribute_Attribute_fk" physicalName="Attribute_Attribute_fk" pk-table-ref="TAB51" pkCardinality="3" updateRule="0" >
<column-mapping id="CMP117" populated="true" fk-column-ref="COL59" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL53" />
</relationship>
<relationship id="REL118" populated="true" deferrability="7" deleteRule="0" fk-table-ref="TAB100" fkCardinality="7" identifying="true" name="Attribute_Attribute_visible_for_fk" physicalName="Attribute_Attribute_visible_for_fk" pk-table-ref="TAB51" pkCardinality="2" updateRule="0" >
<column-mapping id="CMP119" populated="true" fk-column-ref="COL102" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL53" />
</relationship>
<reference ref-id="REL110" />
<reference ref-id="REL116" />
<relationship id="REL120" populated="true" deferrability="7" deleteRule="0" fk-table-ref="TAB90" fkCardinality="7" identifying="true" name="Role_Visible_for_fk" physicalName="Role_Visible_for_fk" pk-table-ref="TAB65" pkCardinality="2" updateRule="0" >
<column-mapping id="CMP121" populated="true" fk-column-ref="COL93" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL67" />
</relationship>
<relationship id="REL122" populated="true" deferrability="7" deleteRule="0" fk-table-ref="TAB100" fkCardinality="7" identifying="true" name="Role_Attribute_visible_for_fk" physicalName="Role_Attribute_visible_for_fk" pk-table-ref="TAB65" pkCardinality="2" updateRule="0" >
<column-mapping id="CMP123" populated="true" fk-column-ref="COL103" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL67" />
</relationship>
<reference ref-id="REL114" />
<relationship id="REL124" populated="true" deferrability="7" deleteRule="0" fk-table-ref="TAB76" fkCardinality="7" identifying="false" name="Customization_Customization_fk" physicalName="Customization_Customization_fk" pk-table-ref="TAB76" pkCardinality="3" updateRule="0" >
<column-mapping id="CMP125" populated="true" fk-column-ref="COL79" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL78" />
</relationship>
<reference ref-id="REL124" />
<reference ref-id="REL112" />
<reference ref-id="REL120" />
<reference ref-id="REL118" />
<reference ref-id="REL122" />
</relationships>
</target-database>
<ddl-generator type="ca.sqlpower.architect.ddl.HSQLDBDDLGenerator" allow-connection="false" target-schema="public"> </ddl-generator>
<create-kettle-job-settings filePath="" jobName="" schemaName="" kettleJoinType="0" savingToFile="true" />
<play-pen zoom="1.0" viewportX="0" viewportY="0" relationship-style="rectilinear">
<table-pane table-ref="TAB36" x="234" y="51" />
<table-pane table-ref="TAB51" x="700" y="53" />
<table-pane table-ref="TAB65" x="729" y="488" />
<table-pane table-ref="TAB76" x="217" y="457" />
<table-pane table-ref="TAB90" x="481" y="321" />
<table-pane table-ref="TAB100" x="748" y="319" />
<table-link relationship-ref="REL110" pk-x="187" pk-y="45" fk-x="0" fk-y="43" orientation="33" />
<table-link relationship-ref="REL116" pk-x="33" pk-y="143" fk-x="0" fk-y="82" orientation="36" />
<table-link relationship-ref="REL114" pk-x="56" pk-y="0" fk-x="39" fk-y="120" orientation="72" />
<table-link relationship-ref="REL124" pk-x="70" pk-y="79" fk-x="0" fk-y="39" orientation="36" />
<table-link relationship-ref="REL112" pk-x="95" pk-y="120" fk-x="0" fk-y="28" orientation="36" />
<table-link relationship-ref="REL120" pk-x="0" pk-y="33" fk-x="44" fk-y="63" orientation="66" />
<table-link relationship-ref="REL118" pk-x="70" pk-y="143" fk-x="84" fk-y="0" orientation="132" />
<table-link relationship-ref="REL122" pk-x="64" pk-y="0" fk-x="45" fk-y="63" orientation="72" />
</play-pen>
<profiles topNCount="10">
</profiles>
</architect-project>