commit 269ced9302ffb8f95bc5218eaecdf6bf7471b7d7
parent a460fcaddd03907eafb7bb8bcbb241d1f8148f4b
Author: dankert <devnull@localhost>
Date: Sun, 25 Apr 2004 15:07:04 +0200
Namen von FK und IDX angepasst
Diffstat:
1 file changed, 155 insertions(+), 103 deletions(-)
diff --git a/doc/database/model/openrat.clay b/doc/database/model/openrat.clay
@@ -108,28 +108,28 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="fk_acl_groupid" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_group" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_acl_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_group" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="groupid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="fk_acl_userid" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_acl_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="userid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="fk_acl_objectid" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_acl_03" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="objectid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_or_acl_languageid" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_language" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_acl_04" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_language" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -138,27 +138,27 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="idx_acl_primary" alias="" remarks="" unique="true">
+<index name="idx_acl_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="idx_acl_userid" alias="" remarks="" unique="false">
+<index name="idx_acl_01" alias="" remarks="" unique="false">
<index-description/>
<index-column name="userid" sort="ASC"/>
</index>
-<index name="idx_acl_groupid" alias="" remarks="" unique="false">
+<index name="idx_acl_02" alias="" remarks="" unique="false">
<index-description/>
<index-column name="groupid" sort="ASC"/>
</index>
-<index name="idx_acl_languageid" alias="" remarks="" unique="false">
+<index name="idx_acl_03" alias="" remarks="" unique="false">
<index-description/>
<index-column name="languageid" sort="ASC"/>
</index>
-<index name="idx_acl_objectid" alias="" remarks="" unique="false">
+<index name="idx_acl_04" alias="" remarks="" unique="false">
<index-description/>
<index-column name="objectid" sort="ASC"/>
</index>
-<index name="idx_acl_transmit" alias="" remarks="" unique="false">
+<index name="idx_acl_05" alias="" remarks="" unique="false">
<index-description/>
<index-column name="is_transmit" sort="ASC"/>
</index>
@@ -166,7 +166,7 @@
</table>
<table name="or_element" alias="" remarks="">
<table-description/>
-<table-figure-bounds x="1261" y="1104" width="-1" height="-1"/>
+<table-figure-bounds x="1181" y="986" width="-1" height="-1"/>
<column-list>
<column name="id" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="true">
<column-description/>
@@ -289,21 +289,21 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_or_element_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_element_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="default_objectid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_or_element_2" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_element_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="folderobjectid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_or_element_3" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_template" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_element_03" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_template" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -312,15 +312,19 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="element_id" alias="" remarks="" unique="true">
+<index name="idx_element_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="element_templateid" alias="" remarks="" unique="false">
+<index name="idx_element_01" alias="" remarks="" unique="false">
<index-description/>
<index-column name="templateid" sort="ASC"/>
</index>
-<index name="IX_or_element_3" alias="" remarks="" unique="true">
+<index name="idx_element_02" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="name" sort="ASC"/>
+</index>
+<index name="idx_element_uk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="templateid" sort="ASC"/>
<index-column name="name" sort="ASC"/>
@@ -368,7 +372,7 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_file_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="NO ACTION" on-delete="RESTRICT">
+<foreign-key name="fk_file_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -377,11 +381,11 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="file_primary" alias="" remarks="" unique="true">
+<index name="idx_file_ok" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="file_objectid" alias="" remarks="" unique="true">
+<index name="idx_file_01" alias="" remarks="" unique="true">
<index-description/>
<index-column name="objectid" sort="ASC"/>
</index>
@@ -410,7 +414,7 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_folder_objectid" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_folder_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -419,11 +423,11 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="folder_primary" alias="" remarks="" unique="true">
+<index name="idx_folder_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="folder_objectid" alias="" remarks="" unique="true">
+<index name="idx_folder_01" alias="" remarks="" unique="true">
<index-description/>
<index-column name="objectid" sort="ASC"/>
</index>
@@ -450,23 +454,22 @@
<primary-key-description/>
<primary-key-column name="id"/>
</primary-key>
-<unique-key-list>
-<unique-key name="UQ_or_group_1" alias="" remarks="">
-<unique-key-description/>
-<unique-key-column name="name"/>
-</unique-key>
-</unique-key-list>
+<unique-key-list/>
<foreign-key-list/>
<index-list>
-<index name="group_primary" alias="" remarks="" unique="true">
+<index name="idx_group_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
+<index name="idx_group_uk" alias="" remarks="" unique="true">
+<index-description/>
+<index-column name="name" sort="ASC"/>
+</index>
</index-list>
</table>
<table name="or_language" alias="" remarks="">
<table-description/>
-<table-figure-bounds x="403" y="755" width="-1" height="-1"/>
+<table-figure-bounds x="401" y="671" width="-1" height="-1"/>
<column-list>
<column name="id" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="true">
<column-description/>
@@ -505,7 +508,7 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_language_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_project" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_language_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_project" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -514,11 +517,11 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="language_primary" alias="" remarks="" unique="true">
+<index name="idx_language_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="IX_or_language_2" alias="" remarks="" unique="true">
+<index name="idx_language_uk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="projectid" sort="ASC"/>
<index-column name="isocode" sort="ASC"/>
@@ -560,14 +563,14 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_link_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_link_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="objectid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_link_2" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_link_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -576,15 +579,15 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="link_primary" alias="" remarks="" unique="true">
+<index name="idx_link_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="link_objectid" alias="" remarks="" unique="false">
+<index name="idx_link_01" alias="" remarks="" unique="true">
<index-description/>
<index-column name="objectid" sort="ASC"/>
</index>
-<index name="link_linkobjectid" alias="" remarks="" unique="false">
+<index name="idx_link_02" alias="" remarks="" unique="false">
<index-description/>
<index-column name="link_objectid" sort="ASC"/>
</index>
@@ -606,16 +609,16 @@
<variant type-name-pattern="INT"/>
</data-type>
</column>
-<column name="name" alias="" remarks="" mandatory="true" column-size="128" decimal-digits="0" default-value="" auto-increment="false">
+<column name="name" alias="" remarks="" mandatory="true" column-size="255" decimal-digits="0" default-value="" auto-increment="false">
<column-description/>
<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="2147483647"/>
</data-type>
</column>
-<column name="descr" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
+<column name="descr" alias="" remarks="" mandatory="true" column-size="255" decimal-digits="0" default-value="" auto-increment="false">
<column-description/>
-<data-type name="TEXT" jdbc-type="-1" selected-variant-pattern="TEXT" literal-prefix="'" literal-suffix="'">
-<variant type-name-pattern="TEXT"/>
+<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="2147483647"/>
</data-type>
</column>
<column name="languageid" alias="" remarks="" mandatory="true" column-size="11" decimal-digits="0" default-value="0" auto-increment="false">
@@ -631,14 +634,14 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_name_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="NO ACTION" on-delete="RESTRICT">
+<foreign-key name="fk_name_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="objectid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_name_2" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_language" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_name_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_language" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -647,18 +650,23 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="name_primary" alias="" remarks="" unique="true">
+<index name="idx_name_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="name_objectid" alias="" remarks="" unique="false">
+<index name="idx_name_01" alias="" remarks="" unique="false">
<index-description/>
<index-column name="objectid" sort="ASC"/>
</index>
-<index name="name_languageid" alias="" remarks="" unique="false">
+<index name="idx_name_02" alias="" remarks="" unique="false">
<index-description/>
<index-column name="languageid" sort="ASC"/>
</index>
+<index name="idx_name_uk" alias="" remarks="" unique="true">
+<index-description/>
+<index-column name="objectid" sort="ASC"/>
+<index-column name="languageid" sort="ASC"/>
+</index>
</index-list>
</table>
<table name="or_object" alias="" remarks="">
@@ -683,7 +691,7 @@
<variant type-name-pattern="INT"/>
</data-type>
</column>
-<column name="filename" alias="" remarks="" mandatory="true" column-size="256" decimal-digits="0" default-value="" auto-increment="false">
+<column name="filename" alias="" remarks="" mandatory="true" column-size="255" decimal-digits="0" default-value="" auto-increment="false">
<column-description/>
<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="2147483647"/>
@@ -750,21 +758,21 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_object_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_project" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_object_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_project" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="projectid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_object_2" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_object_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="lastchange_userid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_object_3" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_object_03" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -773,47 +781,47 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="object_primary" alias="" remarks="" unique="true">
+<index name="idx_object_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="parentid" alias="" remarks="" unique="false">
+<index name="idx_object_01" alias="" remarks="" unique="false">
<index-description/>
<index-column name="parentid" sort="ASC"/>
</index>
-<index name="object_projectid" alias="" remarks="" unique="false">
+<index name="idx_object_02" alias="" remarks="" unique="false">
<index-description/>
<index-column name="projectid" sort="ASC"/>
</index>
-<index name="is_folder" alias="" remarks="" unique="false">
+<index name="idx_object_03" alias="" remarks="" unique="false">
<index-description/>
<index-column name="is_folder" sort="ASC"/>
</index>
-<index name="is_file" alias="" remarks="" unique="false">
+<index name="idx_object_04" alias="" remarks="" unique="false">
<index-description/>
<index-column name="is_file" sort="ASC"/>
</index>
-<index name="is_page" alias="" remarks="" unique="false">
+<index name="idx_object_05" alias="" remarks="" unique="false">
<index-description/>
<index-column name="is_page" sort="ASC"/>
</index>
-<index name="is_link" alias="" remarks="" unique="false">
+<index name="idx_object_06" alias="" remarks="" unique="false">
<index-description/>
<index-column name="is_link" sort="ASC"/>
</index>
-<index name="orderid" alias="" remarks="" unique="false">
+<index name="idx_object_07" alias="" remarks="" unique="false">
<index-description/>
<index-column name="orderid" sort="ASC"/>
</index>
-<index name="object_create_userid" alias="" remarks="" unique="false">
+<index name="idx_object_08" alias="" remarks="" unique="false">
<index-description/>
<index-column name="create_userid" sort="ASC"/>
</index>
-<index name="object_lastchange_userid" alias="" remarks="" unique="false">
+<index name="idx_object_09" alias="" remarks="" unique="false">
<index-description/>
<index-column name="lastchange_userid" sort="ASC"/>
</index>
-<index name="IX_or_object_11" alias="" remarks="" unique="true">
+<index name="idx_object_uk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="parentid" sort="ASC"/>
<index-column name="filename" sort="ASC"/>
@@ -849,14 +857,14 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_page_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_template" referenced-key="PRIMARY" on-update="NO ACTION" on-delete="RESTRICT">
+<foreign-key name="fk_page_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_template" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="templateid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_page_2" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="NO ACTION" on-delete="RESTRICT">
+<foreign-key name="fk_page_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -865,15 +873,15 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="page_primary" alias="" remarks="" unique="true">
+<index name="idx_page_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="objectid" alias="" remarks="" unique="true">
+<index name="idx_page_uk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="objectid" sort="ASC"/>
</index>
-<index name="page_templateid" alias="" remarks="" unique="false">
+<index name="idx_page_01" alias="" remarks="" unique="false">
<index-description/>
<index-column name="templateid" sort="ASC"/>
</index>
@@ -881,7 +889,7 @@
</table>
<table name="or_project" alias="" remarks="">
<table-description/>
-<table-figure-bounds x="447" y="999" width="-1" height="-1"/>
+<table-figure-bounds x="420" y="888" width="-1" height="-1"/>
<column-list>
<column name="id" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="true">
<column-description/>
@@ -939,11 +947,11 @@
<unique-key-list/>
<foreign-key-list/>
<index-list>
-<index name="project_primary" alias="" remarks="" unique="true">
+<index name="idx_project_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="projectname" alias="" remarks="" unique="true">
+<index name="idx_project_uk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="name" sort="ASC"/>
</index>
@@ -971,16 +979,16 @@
<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="2147483647"/>
</data-type>
</column>
-<column name="extension" alias="" remarks="" mandatory="true" column-size="10" decimal-digits="0" default-value="" auto-increment="false">
+<column name="extension" alias="" remarks="not in use" mandatory="false" column-size="10" decimal-digits="0" default-value="" auto-increment="false">
<column-description/>
<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="2147483647"/>
</data-type>
</column>
-<column name="is_default" alias="" remarks="" mandatory="true" column-size="1" decimal-digits="0" default-value="0" auto-increment="false">
+<column name="is_default" alias="" remarks="" mandatory="true" column-size="10" decimal-digits="0" default-value="0" auto-increment="false">
<column-description/>
-<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT">
-<variant type-name-pattern="INT"/>
+<data-type name="CHAR" jdbc-type="1" selected-variant-pattern="CHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="CHAR(%n)" precision-variable="%n" precision-min="1" precision-max="2147483647"/>
</data-type>
</column>
</column-list>
@@ -990,7 +998,7 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_projectmodel_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_project" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_projectmodel_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_project" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -999,18 +1007,18 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="projectmodel_id" alias="" remarks="" unique="true">
+<index name="idx_projectmodel_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="projectmodel_projectid" alias="" remarks="" unique="false">
+<index name="idx_projectmodel_01" alias="" remarks="" unique="false">
<index-description/>
<index-column name="projectid" sort="ASC"/>
</index>
-<index name="IX_or_projectmodel_3" alias="" remarks="" unique="false">
+<index name="idx_projectmodel_uk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="projectid" sort="ASC"/>
-<index-column name="extension" sort="ASC"/>
+<index-column name="name" sort="ASC"/>
</index>
</index-list>
</table>
@@ -1024,7 +1032,7 @@
<variant type-name-pattern="INT"/>
</data-type>
</column>
-<column name="projectid" alias="" remarks="" mandatory="false" column-size="11" decimal-digits="0" default-value="" auto-increment="false">
+<column name="projectid" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
<column-description/>
<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT">
<variant type-name-pattern="INT"/>
@@ -1043,7 +1051,7 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_template_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_project" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_template_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_project" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -1052,18 +1060,23 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="PRIMARYINDEX" alias="" remarks="" unique="true">
+<index name="idx_template_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="projectid" alias="" remarks="" unique="false">
+<index name="idx_template_01" alias="" remarks="" unique="false">
<index-description/>
<index-column name="projectid" sort="ASC"/>
</index>
-<index name="templatename" alias="" remarks="" unique="false">
+<index name="idx_template_02" alias="" remarks="" unique="false">
<index-description/>
<index-column name="name" sort="ASC"/>
</index>
+<index name="idx_template_uk" alias="" remarks="" unique="true">
+<index-description/>
+<index-column name="projectid" sort="ASC"/>
+<index-column name="name" sort="ASC"/>
+</index>
</index-list>
</table>
<table name="or_templatemodel" alias="" remarks="">
@@ -1113,14 +1126,14 @@
</unique-key>
</unique-key-list>
<foreign-key-list>
-<foreign-key name="FK_templatemodel_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_template" referenced-key="PRIMARY" on-update="NO ACTION" on-delete="RESTRICT">
+<foreign-key name="fk_templatemodel_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_template" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="templateid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_templatemodel_2" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_projectmodel" referenced-key="PRIMARY" on-update="NO ACTION" on-delete="RESTRICT">
+<foreign-key name="fk_templatemodel_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_projectmodel" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -1129,13 +1142,23 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="templatemodel_primary" alias="" remarks="" unique="true">
+<index name="idx_templatemodel_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="templateid" alias="" remarks="" unique="false">
+<index name="idx_templatemodel_01" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="templateid" sort="ASC"/>
+</index>
+<index name="idx_templatemodel_uk_01" alias="" remarks="" unique="true">
<index-description/>
<index-column name="templateid" sort="ASC"/>
+<index-column name="projectmodelid" sort="ASC"/>
+</index>
+<index name="idx_templatemodel_uk_02" alias="" remarks="" unique="true">
+<index-description/>
+<index-column name="templateid" sort="ASC"/>
+<index-column name="extension" sort="ASC"/>
</index>
</index-list>
</table>
@@ -1211,11 +1234,11 @@
<unique-key-list/>
<foreign-key-list/>
<index-list>
-<index name="user_primary" alias="" remarks="" unique="true">
+<index name="idx_user_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="name" alias="" remarks="" unique="true">
+<index name="idx_user_uk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="name" sort="ASC"/>
</index>
@@ -1250,14 +1273,14 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_usergroup_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_group" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_usergroup_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_group" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="groupid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_usergroup_2" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_usergroup_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -1266,23 +1289,28 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="usergroup_primary" alias="" remarks="" unique="true">
+<index name="idx_usergroup_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
-<index name="groupid" alias="" remarks="" unique="false">
+<index name="idx_usergroup_01" alias="" remarks="" unique="false">
<index-description/>
<index-column name="groupid" sort="ASC"/>
</index>
-<index name="userid" alias="" remarks="" unique="false">
+<index name="idx_usergroup_02" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="userid" sort="ASC"/>
+</index>
+<index name="idx_usergroup_uk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="userid" sort="ASC"/>
+<index-column name="groupid" sort="ASC"/>
</index>
</index-list>
</table>
<table name="or_value" alias="" remarks="">
<table-description/>
-<table-figure-bounds x="950" y="1028" width="-1" height="-1"/>
+<table-figure-bounds x="890" y="970" width="-1" height="-1"/>
<column-list>
<column name="id" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="true">
<column-description/>
@@ -1357,35 +1385,35 @@
</primary-key>
<unique-key-list/>
<foreign-key-list>
-<foreign-key name="FK_value_1" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_page" referenced-key="PRIMARY" on-update="NO ACTION" on-delete="RESTRICT">
+<foreign-key name="fk_value_01" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_page" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="pageid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_value_2" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_element" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_value_02" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_element" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="elementid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_value_3" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_language" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_value_03" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_language" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="languageid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_value_4" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_value_04" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_user" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="lastchange_userid" referenced-key-column-name="id"/>
</foreign-key>
-<foreign-key name="FK_value_5" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
+<foreign-key name="fk_value_05" alias="" remarks="" referenced-table-schema="PUBLIC" referenced-table="or_object" referenced-key="PRIMARY" on-update="RESTRICT" on-delete="RESTRICT">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-bendpoint-list/>
@@ -1394,10 +1422,34 @@
</foreign-key>
</foreign-key-list>
<index-list>
-<index name="value_primary" alias="" remarks="" unique="true">
+<index name="idx_value_pk" alias="" remarks="" unique="true">
<index-description/>
<index-column name="id" sort="ASC"/>
</index>
+<index name="idx_value_01" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="pageid" sort="ASC"/>
+</index>
+<index name="idx_value_02" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="languageid" sort="ASC"/>
+</index>
+<index name="idx_value_03" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="elementid" sort="ASC"/>
+</index>
+<index name="idx_value_04" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="active" sort="ASC"/>
+</index>
+<index name="idx_value_05" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="lastchange_date" sort="ASC"/>
+</index>
+<index name="idx_value_06" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="elementid" sort="ASC"/>
+</index>
</index-list>
</table>
</table-list>