openrat-cms

commit 4f7c2e5cba1ca4bc661d81acbbde96abad927d27
parent 57f90b35a29e1bb9eddfaf24872cabfd46aa8e4f
Author: dankert <devnull@localhost>
Date:   Wed, 28 Apr 2004 22:33:34 +0200

Neue Spalte is_release in or_acl, neue Spalte public in or_value

Diffstat:
doc/database/model/openrat.clay
 | 
26
+++++++++++++++++++++-----
doc/database/sql/postgresql/create.sql
 | 
7
+++++--

2 files changed, 26 insertions(+), 7 deletions(-)
diff --git a/doc/database/model/openrat.clay b/doc/database/model/openrat.clay
@@ -83,24 +83,30 @@
 <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 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_grant" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="0" auto-increment="false">
+<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_transmit" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
+<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/>
@@ -1366,18 +1372,24 @@
 <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 name="public" 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_userid" alias="" remarks="" mandatory="false" column-size="0" decimal-digits="0" default-value="0" auto-increment="false">
+<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="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/>
@@ -1450,6 +1462,10 @@
 <index-description/>
 <index-column name="elementid" sort="ASC"/>
 </index>
+<index name="idx_value_07" alias="" remarks="" unique="false">
+<index-description/>
+<index-column name="public" sort="ASC"/>
+</index>
 </index-list>
 </table>
 </table-list>
diff --git a/doc/database/sql/postgresql/create.sql b/doc/database/sql/postgresql/create.sql
@@ -266,8 +266,9 @@ CREATE TABLE or_value (
      , number INT
      , date INT
      , active INT DEFAULT 0 NOT NULL
+     , public INT NOT NULL
      , lastchange_date INT DEFAULT 0 NOT NULL
-     , lastchange_userid INT DEFAULT 0
+     , lastchange_userid CHAR(10) DEFAULT '0'
      , PRIMARY KEY (id)
      , CONSTRAINT fk_value_01 FOREIGN KEY (pageid)
                   REFERENCES or_page (id) ON DELETE RESTRICT ON UPDATE RESTRICT
@@ -286,6 +287,7 @@ CREATE INDEX idx_value_03 ON or_value (elementid);
 CREATE INDEX idx_value_04 ON or_value (active);
 CREATE INDEX idx_value_05 ON or_value (lastchange_date);
 CREATE INDEX idx_value_06 ON or_value (elementid);
+CREATE INDEX idx_value_07 ON or_value (public);
 
 CREATE TABLE or_acl (
        id INT NOT NULL
@@ -300,9 +302,10 @@ CREATE TABLE or_acl (
      , is_create_link INT DEFAULT 0 NOT NULL
      , is_create_page INT DEFAULT 0 NOT NULL
      , is_delete INT DEFAULT 0 NOT NULL
+     , is_release INT NOT NULL
      , is_publish INT DEFAULT 0 NOT NULL
      , is_grant INT DEFAULT 0 NOT NULL
-     , is_transmit INT NOT NULL
+     , is_transmit CHAR(10) NOT NULL
      , PRIMARY KEY (id)
      , CONSTRAINT fk_acl_01 FOREIGN KEY (groupid)
                   REFERENCES or_group (id) ON DELETE RESTRICT ON UPDATE RESTRICT