openrat-cms

commit 1285f4f6c0dfabb3cef9b8d294e18fcb90105bdf
parent 151d752032a3e7a6c747bc54ce19e8b5df68a46b
Author: dankert <devnull@localhost>
Date:   Sun,  2 May 2004 14:03:08 +0200

Einbau Freigabemechanismus

Diffstat:
doc/database/model/openrat.clay
 | 
10
+++++-----
doc/database/sql/postgresql/create.sql
 | 
6
+++---

2 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/doc/database/model/openrat.clay b/doc/database/model/openrat.clay
@@ -1372,7 +1372,7 @@
 <variant type-name-pattern="INT"/>
 </data-type>
 </column>
-<column name="public" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
+<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"/>
@@ -1384,10 +1384,10 @@
 <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 name="lastchange_userid" alias="" remarks="" mandatory="false" column-size="0" 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 name="INT" jdbc-type="4" selected-variant-pattern="INT">
+<variant type-name-pattern="INT"/>
 </data-type>
 </column>
 </column-list>
@@ -1464,7 +1464,7 @@
 </index>
 <index name="idx_value_07" alias="" remarks="" unique="false">
 <index-description/>
-<index-column name="public" sort="ASC"/>
+<index-column name="publish" sort="ASC"/>
 </index>
 </index-list>
 </table>
diff --git a/doc/database/sql/postgresql/create.sql b/doc/database/sql/postgresql/create.sql
@@ -266,9 +266,9 @@ CREATE TABLE or_value (
      , number INT
      , date INT
      , active INT DEFAULT 0 NOT NULL
-     , public INT NOT NULL
+     , publish INT NOT NULL
      , lastchange_date INT DEFAULT 0 NOT NULL
-     , lastchange_userid CHAR(10) DEFAULT '0'
+     , lastchange_userid INT DEFAULT 0
      , PRIMARY KEY (id)
      , CONSTRAINT fk_value_01 FOREIGN KEY (pageid)
                   REFERENCES or_page (id) ON DELETE RESTRICT ON UPDATE RESTRICT
@@ -287,7 +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 INDEX idx_value_07 ON or_value (publish);
 
 CREATE TABLE or_acl (
        id INT NOT NULL