commit 7153e829e5b61db43c85aa6780b39cf9578193f3 parent 3933aaaa49d7188a620877ff8adbc4262c61c4ef Author: dankert <devnull@localhost> Date: Sat, 20 Feb 2010 01:48:41 +0100 Datenmodell rausgeworfen. Diffstat:
| doc/database/model/openrat.clay | | | 1475 | ------------------------------------------------------------------------------- |
1 file changed, 0 insertions(+), 1475 deletions(-)
diff --git a/doc/database/model/openrat.clay b/doc/database/model/openrat.clay @@ -1,1475 +0,0 @@ -<?xml version="1.0" encoding="UTF-8" standalone="yes"?> -<clay-model clay-version="1.0.3"> -<database-model name="openrat" alias="" remarks="" author="" version="1.0" sql-dialect-id="jp.azzurri.clay.model.physical.dialect.Postgre_7_2_Dialect" begin-script="-- OpenRat Content Management System -- SQL-Dump -- -- (c) Jan Dankert -- Licensed under the GNU General Public Licence " end-script=" -- Insert 1 Admin-User INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES( 1,'admin','21232f297a57a5a743894a0e4a801fc3','','Administrator','','','The Admin User','default',1 )"> -<database-model-description/> -<schema-list> -<schema name="PUBLIC" alias="" remarks=""> -<schema-description/> -<domain-list/> -<table-list> -<table name="or_acl" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="1165" y="95" 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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="userid" alias="" remarks="" mandatory="false" column-size="11" 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"/> -</data-type> -</column> -<column name="groupid" alias="" remarks="" mandatory="false" column-size="11" 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"/> -</data-type> -</column> -<column name="objectid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="languageid" alias="" remarks="" mandatory="false" column-size="0" 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> -</column> -<column name="is_write" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_prop" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_create_folder" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_create_file" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_create_link" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_create_page" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_delete" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_release" 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"/> -</data-type> -</column> -<column name="is_publish" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_grant" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_transmit" alias="" remarks="" mandatory="true" column-size="10" decimal-digits="0" default-value="" auto-increment="false"> -<column-description/> -<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> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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_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_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_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/> -</foreign-key-figure> -<foreign-key-column column-name="languageid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_acl_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_acl_01" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="userid" sort="ASC"/> -</index> -<index name="idx_acl_02" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="groupid" sort="ASC"/> -</index> -<index name="idx_acl_03" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="languageid" sort="ASC"/> -</index> -<index name="idx_acl_04" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="objectid" sort="ASC"/> -</index> -<index name="idx_acl_05" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="is_transmit" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_element" alias="" remarks=""> -<table-description/> -<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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="templateid" alias="" remarks="Template fuer das dieses Element gilt" mandatory="true" column-size="0" 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> -</column> -<column name="name" alias="" remarks="Name des Elementes" mandatory="true" column-size="50" 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="Beschreibung fuer den Redakteur" 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="type" alias="" remarks="interner Typ des Elementes" mandatory="true" column-size="20" 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="subtype" alias="" remarks="Untertyp, fuer bestimmte Typen notwendig" mandatory="false" column-size="20" 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="with_icon" alias="" remarks="ja/nein ob Editier-Ikon vor Element erscheint" mandatory="true" column-size="1" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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 name="dateformat" alias="" remarks="Datumsformat (nur bei Datums-Elementen)" mandatory="false" column-size="100" 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="wiki" alias="" remarks="ja/nein ob Text-Schnellauszeichnung erfolgen soll (nur bei Textelementen)" mandatory="false" column-size="1" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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 name="html" alias="" remarks="ja/nein ob HTML im Text erlaubt ist (nur bei Textelementen)" mandatory="false" column-size="1" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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 name="all_languages" alias="" remarks="ja/nein ob Inhalt fuer alle Sprachen gilt" mandatory="true" column-size="1" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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 name="writable" alias="" remarks="ja/nein ob Inhalt vom Redakteur veraenderbar" mandatory="true" column-size="1" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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 name="decimals" alias="" remarks="Anzahl Nachkommastellen (bei Typ Zahl)" mandatory="false" column-size="0" 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> -</column> -<column name="dec_point" alias="" remarks="Dezimalstelle (bei Typ Zahl)" mandatory="false" column-size="5" 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="thousand_sep" alias="" remarks="Tausenderpunkt (bei Typ Zahl)" mandatory="false" column-size="1" decimal-digits="0" default-value="" auto-increment="false"> -<column-description/> -<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 name="code" alias="" remarks="PHP-Code fuer dynamische Inhalte" mandatory="false" column-size="0" 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> -</column> -<column name="default_text" alias="" remarks="Standard-Inhalt wenn kein Inhalt vorhanden ist" mandatory="false" column-size="0" 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> -</column> -<column name="folderobjectid" alias="" remarks="Verweis auf Ordner" mandatory="false" 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"/> -</data-type> -</column> -<column name="default_objectid" alias="" remarks="verlinktes Objekt, wenn kein anderer Inhalt verfuegbar ist." mandatory="false" 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"/> -</data-type> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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_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_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/> -</foreign-key-figure> -<foreign-key-column column-name="templateid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_element_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_element_01" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="templateid" sort="ASC"/> -</index> -<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"/> -</index> -</index-list> -</table> -<table name="or_file" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="798" y="94" width="-1" height="-1"/> -<column-list> -<column name="id" 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"/> -</data-type> -</column> -<column name="objectid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="extension" alias="" remarks="" mandatory="true" 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="size" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="value" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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/> -</foreign-key-figure> -<foreign-key-column column-name="objectid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_file_ok" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_file_01" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="objectid" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_folder" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="994" y="97" width="115" height="103"/> -<column-list> -<column name="id" 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"/> -</data-type> -</column> -<column name="objectid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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/> -</foreign-key-figure> -<foreign-key-column column-name="objectid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_folder_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_folder_01" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="objectid" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_group" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="1368" y="105" width="-1" height="-1"/> -<column-list> -<column name="id" 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"/> -</data-type> -</column> -<column name="name" alias="" remarks="" mandatory="true" column-size="100" 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-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list/> -<index-list> -<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="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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="projectid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="isocode" alias="" remarks="" mandatory="true" 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="name" alias="" remarks="" mandatory="true" column-size="50" 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-description/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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/> -</foreign-key-figure> -<foreign-key-column column-name="projectid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_language_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_language_uk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="projectid" sort="ASC"/> -<index-column name="isocode" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_link" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="585" y="93" 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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="objectid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="link_objectid" alias="" remarks="" mandatory="false" column-size="11" 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"/> -</data-type> -</column> -<column name="url" alias="" remarks="" mandatory="false" 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-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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_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="link_objectid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_link_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_link_01" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="objectid" sort="ASC"/> -</index> -<index name="idx_link_02" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="link_objectid" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_name" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="384" y="488" 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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="objectid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<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="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="languageid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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_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/> -</foreign-key-figure> -<foreign-key-column column-name="languageid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_name_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_name_01" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="objectid" sort="ASC"/> -</index> -<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=""> -<table-description/> -<table-figure-bounds x="902" y="393" width="216" height="244"/> -<column-list> -<column name="id" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="true"> -<column-description/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="parentid" alias="" remarks="" mandatory="false" column-size="10" 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"/> -</data-type> -</column> -<column name="projectid" 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> -</column> -<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"/> -</data-type> -</column> -<column name="orderid" 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> -</column> -<column name="create_date" 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> -</column> -<column name="create_userid" alias="" remarks="" mandatory="false" column-size="0" 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> -</column> -<column name="lastchange_date" 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> -</column> -<column name="lastchange_userid" alias="" remarks="" mandatory="false" column-size="0" 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> -</column> -<column name="is_folder" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_file" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_page" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="is_link" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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_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_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/> -</foreign-key-figure> -<foreign-key-column column-name="create_userid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_object_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_object_01" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="parentid" sort="ASC"/> -</index> -<index name="idx_object_02" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="projectid" sort="ASC"/> -</index> -<index name="idx_object_03" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="is_folder" sort="ASC"/> -</index> -<index name="idx_object_04" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="is_file" sort="ASC"/> -</index> -<index name="idx_object_05" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="is_page" sort="ASC"/> -</index> -<index name="idx_object_06" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="is_link" sort="ASC"/> -</index> -<index name="idx_object_07" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="orderid" sort="ASC"/> -</index> -<index name="idx_object_08" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="create_userid" sort="ASC"/> -</index> -<index name="idx_object_09" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="lastchange_userid" sort="ASC"/> -</index> -<index name="idx_object_uk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="parentid" sort="ASC"/> -<index-column name="filename" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_page" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="653" y="424" width="-1" height="-1"/> -<column-list> -<column name="id" 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"/> -</data-type> -</column> -<column name="objectid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="templateid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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_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="objectid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_page_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_page_uk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="objectid" sort="ASC"/> -</index> -<index name="idx_page_01" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="templateid" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_project" alias="" remarks=""> -<table-description/> -<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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<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-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="target_dir" 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="ftp_url" 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="ftp_passive" alias="" remarks="" mandatory="true" column-size="1" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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="254"/> -</data-type> -</column> -<column name="cmd_after_publish" 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="content_negotiation" alias="" remarks="" mandatory="true" column-size="1" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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="254"/> -</data-type> -</column> -<column name="cut_index" alias="" remarks="" mandatory="true" column-size="1" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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="254"/> -</data-type> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list/> -<index-list> -<index name="idx_project_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_project_uk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="name" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_projectmodel" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="1340" y="889" 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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="projectid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="name" alias="" remarks="" mandatory="true" column-size="50" 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="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="10" decimal-digits="0" default-value="0" auto-increment="false"> -<column-description/> -<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> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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/> -</foreign-key-figure> -<foreign-key-column column-name="projectid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_projectmodel_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_projectmodel_01" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="projectid" sort="ASC"/> -</index> -<index name="idx_projectmodel_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_template" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="1082" y="678" width="-1" height="-1"/> -<column-list> -<column name="id" alias="" remarks="auto_increment" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="true"> -<column-description/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<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"/> -</data-type> -</column> -<column name="name" alias="" remarks="" mandatory="true" column-size="50" 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-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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/> -</foreign-key-figure> -<foreign-key-column column-name="projectid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_template_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_template_01" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="projectid" sort="ASC"/> -</index> -<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=""> -<table-description>Inhalt des Templates abhaengig vom Projektmodell</table-description> -<table-figure-bounds x="1313" y="697" 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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="templateid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="projectmodelid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="extension" alias="" remarks="" 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="text" alias="" remarks="" mandatory="true" column-size="2147483647" decimal-digits="0" default-value="" auto-increment="false"> -<column-description/> -<data-type name="TEXT" jdbc-type="-1" selected-variant-pattern="TEXT"> -<variant type-name-pattern="TEXT"/> -</data-type> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list> -<unique-key name="UQ_or_templatemodel_1" alias="" remarks=""> -<unique-key-description/> -<unique-key-column name="templateid"/> -<unique-key-column name="extension"/> -</unique-key> -</unique-key-list> -<foreign-key-list> -<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_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/> -</foreign-key-figure> -<foreign-key-column column-name="projectmodelid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<index name="idx_templatemodel_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<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> -<table name="or_user" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="1313" y="416" width="-1" height="-1"/> -<column-list> -<column name="id" 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"/> -</data-type> -</column> -<column name="name" alias="" remarks="" mandatory="true" column-size="128" 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="password" alias="" remarks="" mandatory="true" column-size="50" 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="ldap_dn" 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="fullname" alias="" remarks="" mandatory="true" column-size="128" 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="tel" alias="" remarks="" mandatory="true" column-size="128" 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="mail" 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="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="style" alias="" remarks="" mandatory="true" column-size="64" 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_admin" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list/> -<index-list> -<index name="idx_user_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_user_uk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="name" sort="ASC"/> -</index> -</index-list> -</table> -<table name="or_usergroup" alias="" remarks=""> -<table-description/> -<table-figure-bounds x="1389" y="243" 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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="userid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="groupid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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_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-list> -<index-list> -<index name="idx_usergroup_pk" alias="" remarks="" unique="true"> -<index-description/> -<index-column name="id" sort="ASC"/> -</index> -<index name="idx_usergroup_01" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="groupid" sort="ASC"/> -</index> -<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="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/> -<data-type name="INT" jdbc-type="4" selected-variant-pattern="INT"> -<variant type-name-pattern="INT"/> -</data-type> -</column> -<column name="pageid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="languageid" 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"/> -</data-type> -</column> -<column name="elementid" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="linkobjectid" alias="" remarks="" mandatory="false" column-size="11" 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"/> -</data-type> -</column> -<column name="text" alias="" remarks="" mandatory="false" column-size="2147483647" decimal-digits="0" default-value="" auto-increment="false"> -<column-description/> -<data-type name="TEXT" jdbc-type="-1" selected-variant-pattern="TEXT"> -<variant type-name-pattern="TEXT"/> -</data-type> -</column> -<column name="number" alias="" remarks="" mandatory="false" column-size="11" 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"/> -</data-type> -</column> -<column name="date" alias="" remarks="" mandatory="false" column-size="11" 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"/> -</data-type> -</column> -<column name="active" alias="" remarks="" mandatory="true" column-size="0" 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> -</column> -<column name="publish" 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"/> -</data-type> -</column> -<column name="lastchange_date" alias="" remarks="" mandatory="true" column-size="11" 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> -</column> -<column name="lastchange_userid" alias="" remarks="" mandatory="false" column-size="0" 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> -</column> -</column-list> -<primary-key name="PRIMARY" alias="" remarks=""> -<primary-key-description/> -<primary-key-column name="id"/> -</primary-key> -<unique-key-list/> -<foreign-key-list> -<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_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_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_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_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/> -</foreign-key-figure> -<foreign-key-column column-name="linkobjectid" referenced-key-column-name="id"/> -</foreign-key> -</foreign-key-list> -<index-list> -<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 name="idx_value_07" alias="" remarks="" unique="false"> -<index-description/> -<index-column name="publish" sort="ASC"/> -</index> -</index-list> -</table> -</table-list> -</schema> -</schema-list> -</database-model> -</clay-model>