Es gibt mittlerweile den Datenbank-Updater, daher sind diese Dateien völlig unnötig. - openrat-cms - Unnamed repository; edit this file 'description' to name the repository.

commit b45062f54c38bd615aa0d73bd910930d15494b45
parent ad5a5d5f6cdd7b9d30f7675b6f39b66016cc8e73
Author: Jan Dankert <devnull@localhost>
Date:   Fri, 12 Jan 2018 23:06:41 +0100

Es gibt mittlerweile den Datenbank-Updater, daher sind diese Dateien völlig unnötig.

Diffstat:
doc/database/sql/create.sh  | 548 -------------------------------------------------------------------------------
doc/database/sql/mysql/create.sql  | 393 -------------------------------------------------------------------------------
doc/database/sql/mysql/demo.sql  | 65 -----------------------------------------------------------------
doc/database/sql/mysql/drop.sql  | 20 --------------------
doc/database/sql/mysql/truncate.sql  | 20 --------------------
doc/database/sql/oracle/create.sql  | 363 -------------------------------------------------------------------------------
doc/database/sql/postgresql/create.sql  | 393 -------------------------------------------------------------------------------
doc/database/sql/postgresql/drop.sql  | 20 --------------------
doc/database/sql/postgresql/grant.sql  | 23 -----------------------
doc/database/sql/sqlite/create.sql  | 393 -------------------------------------------------------------------------------

10 files changed, 0 insertions(+), 2238 deletions(-)
diff --git a/doc/database/sql/create.sh b/doc/database/sql/create.sh
@@ -1,547 +0,0 @@
-#!/bin/bash
-#
-#
-
-
-# table name prefix
-prefix=or_
-
-# table name suffix
-suffix=
-
-# Standard Storing engine for MySQL
-mysql_engine=InnoDB
-
-outfile=
-type=
-db=
-db_fc=0
-table=
-cnt=0
-
-# Creating a new table
-# param 1: table name
-open_table()
-{
-    echo "" >> $outfile
-    echo "-- Table $1" >> $outfile
-    echo "CREATE TABLE ${prefix}${1}${suffix}(" >> $outfile
-    db_fc=1
-    table=$1
-}
-
-# Closing the table
-close_table()
-{
-    echo -n ")" >> $outfile
-    
-    case "$type" in
-     mysql)
-            #echo -n " ENGINE=$mysql_engine" >> $outfile
-            echo -n " TYPE=$mysql_engine" >> $outfile
-            ;;
-     *)
-             ;;
-	esac
-    echo ";" >> $outfile
-    
-}
-
-
-# Creating a new column
-# param 1: column name
-# param 2: type (available are: INT,VARCHAR,TEXT,BLOB)
-# param 3: size (number value)
-# param 4: default (number value)
-# param 5: nullable (available are: J,N)
-column()
-{
-    if	[ $db_fc -eq 1 ]; then
-		echo -n "   " >> $outfile
-    else
-		echo -n "  ," >> $outfile
-	fi
-	if	[ "$type" == "oracle" ]; then
-		# Oracle needs uppercase
-		uc=`echo $1|tr 'a-z' 'A-Z'`
-    	echo -n "\"$uc\"" >> $outfile # column name
-	else
-    	echo -n "$1" >> $outfile # column name
-    fi
-    
-    echo -n " " >> $outfile
-    case "$2" in
-     INT)
-     	if	[ "$type" == "mysql" ]; then
-     		if	[ "$3" == "1" ]; then
-        		echo -n "TINYINT" >> $outfile
-        	else
-        		echo -n "INT" >> $outfile
-        	fi
-     	elif	[ "$type" == "oracle" ]; then
-        	echo -n "NUMBER" >> $outfile
-     	else
-        	echo -n "INTEGER" >> $outfile
-        fi
-        ;;
-     VARCHAR)
-        echo -n "VARCHAR" >> $outfile
-        ;;
-     TEXT)
-     	if	[ "$type" == "mysql" ]; then
-            echo -n "MEDIUMTEXT" >> $outfile
-     	elif	[ "$type" == "oracle" ]; then
-            echo -n "CLOB" >> $outfile
-        elif	[ "$type" == "postgresql" ]; then
-            echo -n "TEXT" >> $outfile
-        else
-            echo -n "TEXT" >> $outfile
-        fi
-            ;;
-     BLOB)
-     	if	[ "$type" == "mysql" ]; then
-            echo -n "MEDIUMBLOB" >> $outfile
-     	elif	[ "$type" == "postgresql" ]; then
-            echo -n "TEXT" >> $outfile
-     	elif	[ "$type" == "oracle" ]; then
-            echo -n "CLOB" >> $outfile
-     	elif	[ "$type" == "sqlite" ]; then
-            echo -n "TEXT" >> $outfile
-        else
-            echo -n "BLOB" >> $outfile
-        fi
-            ;;
-     *)
-     	echo "failed: unknown column type $2"
-     	exit 4
-             ;;
-	esac
-    
-    # Column-size
-    if [ "$3" != "" -a "$3" != "-" ]; then
-    	echo -n "($3)" >> $outfile
-    fi
-    
-    if	[ "$type" == "oracle" ]; then
-    	# Oracle wants the DEFAULT-command as first
-    
-	    # DEFAULT-value
-	    if [ "$4" != "" -a "$4" != "-" ]; then
-	    	echo -n " DEFAULT $4" >> $outfile
-	    fi
-	    
-	    # Nullable?
-	    # TEXT-columns should be nullable in Oracle, because empty strings are treated as NULL :(
-	    if [ "$5" == "J" -o "$5" == "1" -o "$2" == "VARCHAR" -o  "$2" == "TEXT" ]; then
-	    	echo -n " NULL" >> $outfile
-	    else
-	    	echo -n " NOT NULL" >> $outfile
-    	fi
-    else
-    	# ANSI-SQL: DEFAULT after NULL-command
-    	
-	    # Nullable?
-	    if [ "$5" == "J" -o "$5" == "1" ]; then
-	    	echo -n " NULL" >> $outfile
-	    else
-	    	echo -n " NOT NULL" >> $outfile
-	    fi
-	    
-	    # DEFAULT-value
-	    if [ "$4" != "" -a "$4" != "-" ]; then
-	    	echo -n " DEFAULT $4" >> $outfile
-	    fi
-	    
-    fi
-    
-    
-    echo >> $outfile
-    db_fc=0
-}
-
-# Creating a primary key
-# param 1: column name
-primary_key()
-{
-    echo "  ,PRIMARY KEY ($1)" >> $outfile
-}
-
-# Creating a unique key
-# param 1: name of index column. Seperate multiple columns with ','
-unique_index()
-{
-	if	[ "$type" == "oracle" ]; then
-		cnt=$(($cnt+1))
-    	echo "CREATE UNIQUE INDEX ${prefix}uidx_${cnt}" >> $outfile
-	else
-    	echo "CREATE UNIQUE INDEX ${prefix}uidx_${table}${suffix}_`echo $1|tr ',' '_'`" >> $outfile
-    fi
-    echo "                 ON ${prefix}${table}${suffix} ($1);" >> $outfile
-}
-
-# Creating a non-unique key
-# param 1: name of index column. Seperate multiple columns with ','
-index()
-{
-	if	[ "$type" == "oracle" ]; then
-		cnt=$(($cnt+1))
-		echo "CREATE INDEX ${prefix}idx_${cnt}" >> $outfile
-	else
-    	echo "CREATE INDEX ${prefix}idx_${table}${suffix}_`echo $1|tr ',' '_'`" >> $outfile
-    fi
-    echo "          ON ${prefix}${table}${suffix} ($1);" >> $outfile
-}
-
-# Creating a foreign key
-# param 1: column name
-# param 2: target table name
-# param 3: target column name
-constraint()
-{
-	if	[ "$type" == "oracle" ]; then
-		cnt=$(($cnt+1))
-	    echo "  ,CONSTRAINT ${prefix}fk_${cnt}" >> $outfile
-	else
-	    echo "  ,CONSTRAINT ${prefix}fk_${table}${suffix}_$1" >> $outfile
-	fi
-
-    echo "     FOREIGN KEY ($1) REFERENCES ${prefix}${2}${suffix} ($3)" >> $outfile
-   	# Oracle doesn't support "ON DELETE RESTRICT"-Statements, but its the default.
-    if	[ "$type" != "oracle" ]; then
-    	echo "     ON DELETE RESTRICT ON UPDATE RESTRICT" >> $outfile
-    fi
-
-}
-
-# Inserting values
-# param 1: table name
-# param 2: name of columns. Seperate multiple columns with ','
-# param 3: values. Seperate multiple values with ','
-insert()
-{
-	echo "INSERT INTO ${prefix}${1}${suffix} ($2) VALUES($3);" >> $outfile
-}
-
-
-
-
-
-for	db in mysql postgresql oracle sqlite; do
-
-    type=$db
-    outfile=${db}/create.sql
-    echo "-- DDL-Script for $db" > $outfile
-    
-
-
-
-
-    
-    # Now beginning the table definitions
-
-
-
-    
-    open_table project
-    column id                  INT     -   - N
-    column name                VARCHAR 128 - N
-    column target_dir          VARCHAR 255 - N
-    column ftp_url             VARCHAR 255 - N
-    column ftp_passive         INT     1   0 N
-    column cmd_after_publish   VARCHAR 255 - N
-    column content_negotiation INT     1   0 N
-    column cut_index           INT     1   0 N
-    primary_key id
-    close_table
-    unique_index name
-
-
-	open_table user  
-	column id       INT     -   - N
-	column name     VARCHAR 128 - N
-	column password VARCHAR 50  - N
-	column ldap_dn  VARCHAR 255 - N
-	column fullname VARCHAR 128 - N
-	column tel      VARCHAR 128 - N
-	column mail     VARCHAR 255 - N
-	column descr    VARCHAR 255 - N
-	column style    VARCHAR 64  - N
-	column is_admin INT     1   0 N
-	primary_key id 
-    close_table
-	unique_index name
-	
-	
-	open_table group  
-	column id   INT     -   - N 
-	column name VARCHAR 100 - N
-	primary_key id 
-    close_table
-	unique_index name
-	
-	open_table object  
-	column id                INT
-	column parentid          INT     -   - J
-	column projectid         INT     -   0 0
-	column filename          VARCHAR 255 -
-	column orderid           INT     -   0
-	column create_date       INT     -   0
-	column create_userid     INT     -   0 J
-	column lastchange_date   INT     -   0
-	column lastchange_userid INT     -   0 J
-	column is_folder         INT     1   -
-	column is_file           INT     1   - 
-	column is_page           INT     1   -
-	column is_link           INT     1   -
-	primary_key  id 
-    constraint projectid          project id
-    constraint lastchange_userid  user    id
-    constraint create_userid      user    id
-    close_table
- 
-	index parentid
-	index projectid
-	index is_folder
-	index is_file
-	index is_page
-	index is_link
-	index orderid
-	index create_userid
-	index lastchange_userid
-	unique_index parentid,filename 
-
-	open_table template  
-	column id        INT
-	column projectid INT
-	column name      VARCHAR 50
-	primary_key id 
-	constraint projectid project  id
-	close_table
-
-	index projectid 
-	index name 
-	unique_index projectid,name 
-
-	open_table language  
-	column id         INT
-	column projectid  INT     -  0
-	column isocode    VARCHAR 10
-	column name       VARCHAR 50
-	column is_default INT     1  0
-	primary_key  id
-	constraint projectid project id
-	close_table
-	unique_index projectid,isocode 
-	
-	open_table page
-	column id         INT
-	column objectid   INT - 0
-	column templateid INT - 0
-	primary_key  id 
-	constraint  templateid template id
-	constraint  objectid   object   id  
-	close_table
-     
-	unique_index objectid 
-	index templateid 
-	
-	open_table projectmodel  
-	column id         INT
-	column projectid  INT     -  0
-	column name       VARCHAR 50
-	column extension  VARCHAR 10 - J
-	column is_default INT     1  0
-	primary_key  id 
-	constraint  projectid  project  id  
-	close_table
- 
-	index        projectid
-	unique_index projectid,name
-
-	
-	open_table element
-	column      id               INT
-	column      templateid       INT     -   0 0
-	column      name             VARCHAR 50
-	column      descr            VARCHAR 255
-	column      type             VARCHAR 20
-	column      subtype          VARCHAR 20  - J
-	column      with_icon        INT     1   0
-	column      dateformat       VARCHAR 100 - J
-	column      wiki             INT     1   0 J
-	column      html             INT     1   0 J
-	column      all_languages    INT     1   0
-	column      writable         INT     1   0
-	column      decimals         INT     -   0 J
-	column      dec_point        VARCHAR 5   - J 
-	column      thousand_sep     VARCHAR 1   - J
-	column      code             TEXT    -   - J
-	column      default_text     TEXT    -   - J
-	column      folderobjectid   INT     -   - J
-	column      default_objectid INT     -   - J
-    primary_key  id 
-    constraint  default_objectid     object  id  
-    constraint  folderobjectid   object  id  
-    constraint  templateid   template  id  
-    close_table
- 
-	index  templateid 
-	index  name 
-	unique_index templateid,name 
-
-
-	open_table file  
-	column      id        INT
-	column      objectid  INT     -  0
-	column      extension VARCHAR 10 
-	column      size      INT     -  0
-	column      value     BLOB
-	primary_key  id 
-	constraint  objectid   object  id  
-    close_table
-	 
-	unique_index objectid 
-
-	
-	open_table folder  
-	column id       INT
-	column objectid INT - 0
-	primary_key  id 
-	constraint objectid object id  
-    close_table
- 
-	unique_index objectid 
-	
-
-	open_table link  
-	column id            INT     -   - N
-	column objectid      INT     -   0 N
-	column link_objectid INT     -   - J
-	column url           VARCHAR 255 - J
-    primary_key  id 
-    constraint objectid      object  id  
-    constraint link_objectid object  id  
-    close_table
- 
-	unique_index objectid 
-	index link_objectid 
-
-	
-	open_table name  
-	column id         INT
-	column objectid   INT     -   0
-	column name       VARCHAR 255 - N
-	column descr      VARCHAR 255
-	column languageid INT     -   0 N
-    primary_key  id 
-    constraint objectid   object   id  
-    constraint languageid language id  
-    close_table
- 
-	index objectid 
-	index languageid 
-	unique_index objectid,languageid 
-
-
-	open_table templatemodel  
-	column      id             INT     -  - N
-	column      templateid     INT     -  0 N
-	column      projectmodelid INT     -  0 N
-	column      extension      VARCHAR 10 - J 
-	column      text           TEXT
-    primary_key  id 
-    constraint templateid     template     id  
-    constraint projectmodelid projectmodel id  
-    close_table
-    
-	index templateid 
-    unique_index templateid,extension 
-	unique_index templateid,projectmodelid 
- 
-	
-	open_table usergroup  
-	column      id       INT
-	column      userid   INT - - N
-	column      groupid  INT - - N
-    primary_key id 
-    constraint groupid group id  
-    constraint userid  user  id  
-    close_table
- 
-	index  groupid 
-	index userid 
-	unique_index userid,groupid 
-
-	
-	open_table value  
-	column      id                INT
-	column      pageid            INT  - 0
-	column      languageid        INT
-	column      elementid         INT  - 0
-	column      linkobjectid      INT  - - J
-	column      text              TEXT - - J
-	column      number            INT  - - J
-	column      date              INT  - - J
-	column      active            INT  - 0
-	column      publish           INT  - - N
-	column      lastchange_date   INT  - 0 N
-	column      lastchange_userid INT  - - J
-    primary_key  id 
-    constraint pageid            page     id  
-    constraint elementid         element  id  
-    constraint languageid        language id  
-    constraint lastchange_userid user     id  
-    constraint linkobjectid      object   id  
-    close_table
- 
-	index pageid 
-	index languageid 
-	index elementid 
-	index active 
-	index lastchange_date 
-	index publish 
-
-	
-	open_table acl  
-	column id INT
-	column      userid           INT - - J
-	column      groupid          INT - - J
-	column      objectid         INT - - N
-	column      languageid       INT - 0 J
-	column      is_write         INT 1 0
-	column      is_prop          INT 1 0
-	column      is_create_folder INT 1 0
-	column      is_create_file   INT 1 0
-	column      is_create_link   INT 1 0
-	column      is_create_page   INT 1 0
-	column      is_delete        INT 1 0
-	column      is_release       INT 1 0
-	column      is_publish       INT 1 0
-	column      is_grant         INT 1 0
-	column      is_transmit      INT 1 0
-    primary_key  id 
-    constraint groupid    group    id  
-    constraint userid     user     id  
-    constraint objectid   object   id  
-    constraint languageid language id  
-    close_table
- 
-	index userid 
-	index groupid 
-	index languageid 
-	index objectid 
-	index is_transmit 
-
-
-	insert user "id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin" "1,'admin','admin','','Administrator','','','Admin user','default',1"
-
-
-
-
-    # end of table definitions
-
-    
-
-done
-
-exit 0-
\ No newline at end of file
diff --git a/doc/database/sql/mysql/create.sql b/doc/database/sql/mysql/create.sql
@@ -1,393 +0,0 @@
--- DDL-Script for mysql
-
--- Table project
-CREATE TABLE or_project(
-   id INT NOT NULL
-  ,name VARCHAR(128) NOT NULL
-  ,target_dir VARCHAR(255) NOT NULL
-  ,ftp_url VARCHAR(255) NOT NULL
-  ,ftp_passive TINYINT(1) NOT NULL DEFAULT 0
-  ,cmd_after_publish VARCHAR(255) NOT NULL
-  ,content_negotiation TINYINT(1) NOT NULL DEFAULT 0
-  ,cut_index TINYINT(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-) TYPE=InnoDB;
-CREATE UNIQUE INDEX or_uidx_project_name
-                 ON or_project (name);
-
--- Table user
-CREATE TABLE or_user(
-   id INT NOT NULL
-  ,name VARCHAR(128) NOT NULL
-  ,password VARCHAR(50) NOT NULL
-  ,ldap_dn VARCHAR(255) NOT NULL
-  ,fullname VARCHAR(128) NOT NULL
-  ,tel VARCHAR(128) NOT NULL
-  ,mail VARCHAR(255) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,style VARCHAR(64) NOT NULL
-  ,is_admin TINYINT(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-) TYPE=InnoDB;
-CREATE UNIQUE INDEX or_uidx_user_name
-                 ON or_user (name);
-
--- Table group
-CREATE TABLE or_group(
-   id INT NOT NULL
-  ,name VARCHAR(100) NOT NULL
-  ,PRIMARY KEY (id)
-) TYPE=InnoDB;
-CREATE UNIQUE INDEX or_uidx_group_name
-                 ON or_group (name);
-
--- Table object
-CREATE TABLE or_object(
-   id INT NOT NULL
-  ,parentid INT NULL
-  ,projectid INT NOT NULL DEFAULT 0
-  ,filename VARCHAR(255) NOT NULL
-  ,orderid INT NOT NULL DEFAULT 0
-  ,create_date INT NOT NULL DEFAULT 0
-  ,create_userid INT NULL DEFAULT 0
-  ,lastchange_date INT NOT NULL DEFAULT 0
-  ,lastchange_userid INT NULL DEFAULT 0
-  ,is_folder TINYINT(1) NOT NULL
-  ,is_file TINYINT(1) NOT NULL
-  ,is_page TINYINT(1) NOT NULL
-  ,is_link TINYINT(1) NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_object_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_object_lastchange_userid
-     FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_object_create_userid
-     FOREIGN KEY (create_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_object_parentid
-          ON or_object (parentid);
-CREATE INDEX or_idx_object_projectid
-          ON or_object (projectid);
-CREATE INDEX or_idx_object_is_folder
-          ON or_object (is_folder);
-CREATE INDEX or_idx_object_is_file
-          ON or_object (is_file);
-CREATE INDEX or_idx_object_is_page
-          ON or_object (is_page);
-CREATE INDEX or_idx_object_is_link
-          ON or_object (is_link);
-CREATE INDEX or_idx_object_orderid
-          ON or_object (orderid);
-CREATE INDEX or_idx_object_create_userid
-          ON or_object (create_userid);
-CREATE INDEX or_idx_object_lastchange_userid
-          ON or_object (lastchange_userid);
-CREATE UNIQUE INDEX or_uidx_object_parentid_filename
-                 ON or_object (parentid,filename);
-
--- Table template
-CREATE TABLE or_template(
-   id INT NOT NULL
-  ,projectid INT NOT NULL
-  ,name VARCHAR(50) NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_template_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_template_projectid
-          ON or_template (projectid);
-CREATE INDEX or_idx_template_name
-          ON or_template (name);
-CREATE UNIQUE INDEX or_uidx_template_projectid_name
-                 ON or_template (projectid,name);
-
--- Table language
-CREATE TABLE or_language(
-   id INT NOT NULL
-  ,projectid INT NOT NULL DEFAULT 0
-  ,isocode VARCHAR(10) NOT NULL
-  ,name VARCHAR(50) NOT NULL
-  ,is_default TINYINT(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_language_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE UNIQUE INDEX or_uidx_language_projectid_isocode
-                 ON or_language (projectid,isocode);
-
--- Table page
-CREATE TABLE or_page(
-   id INT NOT NULL
-  ,objectid INT NOT NULL DEFAULT 0
-  ,templateid INT NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_page_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_page_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE UNIQUE INDEX or_uidx_page_objectid
-                 ON or_page (objectid);
-CREATE INDEX or_idx_page_templateid
-          ON or_page (templateid);
-
--- Table projectmodel
-CREATE TABLE or_projectmodel(
-   id INT NOT NULL
-  ,projectid INT NOT NULL DEFAULT 0
-  ,name VARCHAR(50) NOT NULL
-  ,extension VARCHAR(10) NULL
-  ,is_default TINYINT(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_projectmodel_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_projectmodel_projectid
-          ON or_projectmodel (projectid);
-CREATE UNIQUE INDEX or_uidx_projectmodel_projectid_name
-                 ON or_projectmodel (projectid,name);
-
--- Table element
-CREATE TABLE or_element(
-   id INT NOT NULL
-  ,templateid INT NOT NULL DEFAULT 0
-  ,name VARCHAR(50) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,type VARCHAR(20) NOT NULL
-  ,subtype VARCHAR(20) NULL
-  ,with_icon TINYINT(1) NOT NULL DEFAULT 0
-  ,dateformat VARCHAR(100) NULL
-  ,wiki TINYINT(1) NULL DEFAULT 0
-  ,html TINYINT(1) NULL DEFAULT 0
-  ,all_languages TINYINT(1) NOT NULL DEFAULT 0
-  ,writable TINYINT(1) NOT NULL DEFAULT 0
-  ,decimals INT NULL DEFAULT 0
-  ,dec_point VARCHAR(5) NULL
-  ,thousand_sep VARCHAR(1) NULL
-  ,code MEDIUMTEXT NULL
-  ,default_text MEDIUMTEXT NULL
-  ,folderobjectid INT NULL
-  ,default_objectid INT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_element_default_objectid
-     FOREIGN KEY (default_objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_element_folderobjectid
-     FOREIGN KEY (folderobjectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_element_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_element_templateid
-          ON or_element (templateid);
-CREATE INDEX or_idx_element_name
-          ON or_element (name);
-CREATE UNIQUE INDEX or_uidx_element_templateid_name
-                 ON or_element (templateid,name);
-
--- Table file
-CREATE TABLE or_file(
-   id INT NOT NULL
-  ,objectid INT NOT NULL DEFAULT 0
-  ,extension VARCHAR(10) NOT NULL
-  ,size INT NOT NULL DEFAULT 0
-  ,value MEDIUMBLOB NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_file_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE UNIQUE INDEX or_uidx_file_objectid
-                 ON or_file (objectid);
-
--- Table folder
-CREATE TABLE or_folder(
-   id INT NOT NULL
-  ,objectid INT NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_folder_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE UNIQUE INDEX or_uidx_folder_objectid
-                 ON or_folder (objectid);
-
--- Table link
-CREATE TABLE or_link(
-   id INT NOT NULL
-  ,objectid INT NOT NULL DEFAULT 0
-  ,link_objectid INT NULL
-  ,url VARCHAR(255) NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_link_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_link_link_objectid
-     FOREIGN KEY (link_objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE UNIQUE INDEX or_uidx_link_objectid
-                 ON or_link (objectid);
-CREATE INDEX or_idx_link_link_objectid
-          ON or_link (link_objectid);
-
--- Table name
-CREATE TABLE or_name(
-   id INT NOT NULL
-  ,objectid INT NOT NULL DEFAULT 0
-  ,name VARCHAR(255) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,languageid INT NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_name_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_name_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_name_objectid
-          ON or_name (objectid);
-CREATE INDEX or_idx_name_languageid
-          ON or_name (languageid);
-CREATE UNIQUE INDEX or_uidx_name_objectid_languageid
-                 ON or_name (objectid,languageid);
-
--- Table templatemodel
-CREATE TABLE or_templatemodel(
-   id INT NOT NULL
-  ,templateid INT NOT NULL DEFAULT 0
-  ,projectmodelid INT NOT NULL DEFAULT 0
-  ,extension VARCHAR(10) NULL
-  ,text MEDIUMTEXT NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_templatemodel_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_templatemodel_projectmodelid
-     FOREIGN KEY (projectmodelid) REFERENCES or_projectmodel (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_templatemodel_templateid
-          ON or_templatemodel (templateid);
-CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_extension
-                 ON or_templatemodel (templateid,extension);
-CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_projectmodelid
-                 ON or_templatemodel (templateid,projectmodelid);
-
--- Table usergroup
-CREATE TABLE or_usergroup(
-   id INT NOT NULL
-  ,userid INT NOT NULL
-  ,groupid INT NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_usergroup_groupid
-     FOREIGN KEY (groupid) REFERENCES or_group (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_usergroup_userid
-     FOREIGN KEY (userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_usergroup_groupid
-          ON or_usergroup (groupid);
-CREATE INDEX or_idx_usergroup_userid
-          ON or_usergroup (userid);
-CREATE UNIQUE INDEX or_uidx_usergroup_userid_groupid
-                 ON or_usergroup (userid,groupid);
-
--- Table value
-CREATE TABLE or_value(
-   id INT NOT NULL
-  ,pageid INT NOT NULL DEFAULT 0
-  ,languageid INT NOT NULL
-  ,elementid INT NOT NULL DEFAULT 0
-  ,linkobjectid INT NULL
-  ,text MEDIUMTEXT NULL
-  ,number INT NULL
-  ,date INT NULL
-  ,active INT NOT NULL DEFAULT 0
-  ,publish INT NOT NULL
-  ,lastchange_date INT NOT NULL DEFAULT 0
-  ,lastchange_userid INT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_value_pageid
-     FOREIGN KEY (pageid) REFERENCES or_page (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_elementid
-     FOREIGN KEY (elementid) REFERENCES or_element (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_lastchange_userid
-     FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_linkobjectid
-     FOREIGN KEY (linkobjectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_value_pageid
-          ON or_value (pageid);
-CREATE INDEX or_idx_value_languageid
-          ON or_value (languageid);
-CREATE INDEX or_idx_value_elementid
-          ON or_value (elementid);
-CREATE INDEX or_idx_value_active
-          ON or_value (active);
-CREATE INDEX or_idx_value_lastchange_date
-          ON or_value (lastchange_date);
-CREATE INDEX or_idx_value_publish
-          ON or_value (publish);
-
--- Table acl
-CREATE TABLE or_acl(
-   id INT NOT NULL
-  ,userid INT NULL
-  ,groupid INT NULL
-  ,objectid INT NOT NULL
-  ,languageid INT NULL DEFAULT 0
-  ,is_write TINYINT(1) NOT NULL DEFAULT 0
-  ,is_prop TINYINT(1) NOT NULL DEFAULT 0
-  ,is_create_folder TINYINT(1) NOT NULL DEFAULT 0
-  ,is_create_file TINYINT(1) NOT NULL DEFAULT 0
-  ,is_create_link TINYINT(1) NOT NULL DEFAULT 0
-  ,is_create_page TINYINT(1) NOT NULL DEFAULT 0
-  ,is_delete TINYINT(1) NOT NULL DEFAULT 0
-  ,is_release TINYINT(1) NOT NULL DEFAULT 0
-  ,is_publish TINYINT(1) NOT NULL DEFAULT 0
-  ,is_grant TINYINT(1) NOT NULL DEFAULT 0
-  ,is_transmit TINYINT(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_acl_groupid
-     FOREIGN KEY (groupid) REFERENCES or_group (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_userid
-     FOREIGN KEY (userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-) TYPE=InnoDB;
-CREATE INDEX or_idx_acl_userid
-          ON or_acl (userid);
-CREATE INDEX or_idx_acl_groupid
-          ON or_acl (groupid);
-CREATE INDEX or_idx_acl_languageid
-          ON or_acl (languageid);
-CREATE INDEX or_idx_acl_objectid
-          ON or_acl (objectid);
-CREATE INDEX or_idx_acl_is_transmit
-          ON or_acl (is_transmit);
-INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1);
diff --git a/doc/database/sql/mysql/demo.sql b/doc/database/sql/mysql/demo.sql
@@ -1,65 +0,0 @@
-INSERT INTO `or_acl` (`id`, `userid`, `groupid`, `objectid`, `languageid`, `is_write`, `is_prop`, `is_create_folder`, `is_create_file`, `is_create_link`, `is_create_page`, `is_delete`, `is_release`, `is_publish`, `is_grant`, `is_transmit`) VALUES (1,2,NULL,1,NULL,1,1,1,1,1,1,1,0,0,1,'0');
-INSERT INTO `or_acl` (`id`, `userid`, `groupid`, `objectid`, `languageid`, `is_write`, `is_prop`, `is_create_folder`, `is_create_file`, `is_create_link`, `is_create_page`, `is_delete`, `is_release`, `is_publish`, `is_grant`, `is_transmit`) VALUES (2,2,NULL,2,NULL,1,1,0,0,0,0,1,0,0,1,'0');
-INSERT INTO `or_acl` (`id`, `userid`, `groupid`, `objectid`, `languageid`, `is_write`, `is_prop`, `is_create_folder`, `is_create_file`, `is_create_link`, `is_create_page`, `is_delete`, `is_release`, `is_publish`, `is_grant`, `is_transmit`) VALUES (3,2,NULL,3,NULL,1,1,0,0,0,0,1,0,0,1,'0');
-INSERT INTO `or_acl` (`id`, `userid`, `groupid`, `objectid`, `languageid`, `is_write`, `is_prop`, `is_create_folder`, `is_create_file`, `is_create_link`, `is_create_page`, `is_delete`, `is_release`, `is_publish`, `is_grant`, `is_transmit`) VALUES (4,2,NULL,4,NULL,1,1,0,0,0,0,1,0,0,1,'0');
-INSERT INTO `or_acl` (`id`, `userid`, `groupid`, `objectid`, `languageid`, `is_write`, `is_prop`, `is_create_folder`, `is_create_file`, `is_create_link`, `is_create_page`, `is_delete`, `is_release`, `is_publish`, `is_grant`, `is_transmit`) VALUES (5,2,NULL,5,NULL,1,1,0,0,0,0,1,0,0,1,'0');
-INSERT INTO `or_acl` (`id`, `userid`, `groupid`, `objectid`, `languageid`, `is_write`, `is_prop`, `is_create_folder`, `is_create_file`, `is_create_link`, `is_create_page`, `is_delete`, `is_release`, `is_publish`, `is_grant`, `is_transmit`) VALUES (6,2,NULL,6,NULL,1,1,1,1,1,1,1,0,0,1,'0');
-INSERT INTO `or_acl` (`id`, `userid`, `groupid`, `objectid`, `languageid`, `is_write`, `is_prop`, `is_create_folder`, `is_create_file`, `is_create_link`, `is_create_page`, `is_delete`, `is_release`, `is_publish`, `is_grant`, `is_transmit`) VALUES (7,2,NULL,7,NULL,1,1,0,0,0,0,1,0,0,1,'0');
-INSERT INTO `or_acl` (`id`, `userid`, `groupid`, `objectid`, `languageid`, `is_write`, `is_prop`, `is_create_folder`, `is_create_file`, `is_create_link`, `is_create_page`, `is_delete`, `is_release`, `is_publish`, `is_grant`, `is_transmit`) VALUES (8,2,NULL,8,NULL,1,1,0,0,0,0,1,0,0,1,'0');
-INSERT INTO `or_element` (`id`, `templateid`, `name`, `descr`, `type`, `subtype`, `with_icon`, `dateformat`, `wiki`, `html`, `all_languages`, `writable`, `decimals`, `dec_point`, `thousand_sep`, `code`, `default_text`, `folderobjectid`, `default_objectid`) VALUES (1,1,'stylesheet','','link','file,page,link','0','','0','0','0','0',0,'','','','',1,3);
-INSERT INTO `or_element` (`id`, `templateid`, `name`, `descr`, `type`, `subtype`, `with_icon`, `dateformat`, `wiki`, `html`, `all_languages`, `writable`, `decimals`, `dec_point`, `thousand_sep`, `code`, `default_text`, `folderobjectid`, `default_objectid`) VALUES (2,1,'title','','info','page_name','0','','0','0','0','0',0,'','','','',NULL,NULL);
-INSERT INTO `or_element` (`id`, `templateid`, `name`, `descr`, `type`, `subtype`, `with_icon`, `dateformat`, `wiki`, `html`, `all_languages`, `writable`, `decimals`, `dec_point`, `thousand_sep`, `code`, `default_text`, `folderobjectid`, `default_objectid`) VALUES (3,1,'text','','longtext','','0','','1','0','0','1',0,'','','','',NULL,NULL);
-INSERT INTO `or_element` (`id`, `templateid`, `name`, `descr`, `type`, `subtype`, `with_icon`, `dateformat`, `wiki`, `html`, `all_languages`, `writable`, `decimals`, `dec_point`, `thousand_sep`, `code`, `default_text`, `folderobjectid`, `default_objectid`) VALUES (4,1,'menu','','dynamic','ClassicMenu','0','','0','0','0','0',0,'','','','',NULL,NULL);
-INSERT INTO `or_element` (`id`, `templateid`, `name`, `descr`, `type`, `subtype`, `with_icon`, `dateformat`, `wiki`, `html`, `all_languages`, `writable`, `decimals`, `dec_point`, `thousand_sep`, `code`, `default_text`, `folderobjectid`, `default_objectid`) VALUES (5,1,'username','','info','lastch_user_username','0','','0','0','0','0',0,'','','','',NULL,NULL);
-INSERT INTO `or_element` (`id`, `templateid`, `name`, `descr`, `type`, `subtype`, `with_icon`, `dateformat`, `wiki`, `html`, `all_languages`, `writable`, `decimals`, `dec_point`, `thousand_sep`, `code`, `default_text`, `folderobjectid`, `default_objectid`) VALUES (6,1,'date','','infodate','date_saved','0','F j, Y, g:i a','0','0','0','0',0,'','','','',NULL,NULL);
-INSERT INTO `or_file` (`id`, `objectid`, `extension`, `size`, `value`) VALUES (1,3,'',1966,'a:link{color:#022A50; font-weight:bold; text-decoration:underline }\r\na:active{color:#022A50; font-weight:bold; text-decoration:underline }\r\na:visited{color:#022A50; font-weight:bold; text-decoration:underline }\r\na:hover{color:#022A50; font-weight:bold; text-decoration:underline }\r\n\r\nli.menu2 a{color:#022A50; font-weight:normal; text-decoration:underline }\r\n\r\nbody{color:#000000; font-family:Arial;font-size:13px; background-color:white; margin:0px; }\r\n     \r\ntd {font-family:Arial;font-size:13px; vertical-align:top; }\r\n\r\n\r\ntd.oben { border-bottom:25px solid #7B9CBD; }\r\ntd.submenu { border-right:1px solid #7B9CBD; }\r\ntd.menu { vertical-align:bottom; text-align:right; }\r\n\r\nul.submenu { line-height:25px; padding-left:0px; }\r\n\r\nul.menu0 { line-height:25px; padding:0px; margin:0px; list-style-type:none; }\r\nli.menu0 { font-size:16px; margin-top:5px; }\r\n\r\nul.menu1 { border-left: 2px solid #7B9CBD; padding:6px; margin:0px; list-style-type:none; }\r\nli.menu1 { font-size:13px;  }\r\n\r\nul.menu2 { border-left: 2px solid #7B9CBD; margin:0px; padding:5px; list-style-type:none;  }\r\nli.menu2 { font-weight:normal; font-size:12px;  }\r\n\r\ndt { border-left:1px solid #7B9CBD; border-top:1px solid #7B9CBD; padding:2px; margin-bottom:5px; }\r\ndd { border-right:1px solid #7B9CBD; border-bottom:1px solid #7B9CBD; padding:2px; margin-bottom:10px; }\r\n\r\npre { border:1px solid #7B9CBD; background-color:#D7E5F3; padding:5px; }\r\ncode { border-left:2px solid #7B9CBD;border-right:2px solid #7B9CBD; background-color:#D7E5F3; padding-left:3px; padding-right:3px; }\r\n\r\nblockquote { border-left:10px solid #7B9CBD; border-top:1px solid #D7E5F3;border-right:1px solid #D7E5F3;border-bottom:1px solid #D7E5F3; margin-left:10px; padding-left:10px; }\r\n\r\nh1 { color:#7B9CBD; font-weight:normal; font-size:2.2em; }\r\nh2 { color:#7B9CBD; font-weight:normal; font-size:1.8em;}\r\nh3 { color:#7B9CBD; font-weight:normal; font-size:1.4em;}\r\nh4 { color:#7B9CBD; font-weight:normal; font-size:1.2em;}');
-INSERT INTO `or_folder` (`id`, `objectid`) VALUES (1,1);
-INSERT INTO `or_folder` (`id`, `objectid`) VALUES (2,6);
-INSERT INTO `or_group` (`id`, `name`) VALUES (1,'Redakteure');
-INSERT INTO `or_group` (`id`, `name`) VALUES (2,'LDAP-Test-1');
-INSERT INTO `or_group` (`id`, `name`) VALUES (3,'presidents');
-INSERT INTO `or_language` (`id`, `projectid`, `isocode`, `name`, `is_default`) VALUES (1,1,'en','english',1);
-INSERT INTO `or_language` (`id`, `projectid`, `isocode`, `name`, `is_default`) VALUES (2,1,'DE','German',0);
-INSERT INTO `or_name` (`id`, `objectid`, `name`, `descr`, `languageid`) VALUES (1,1,'demo site','',1);
-INSERT INTO `or_name` (`id`, `objectid`, `name`, `descr`, `languageid`) VALUES (2,2,'cars','',1);
-INSERT INTO `or_name` (`id`, `objectid`, `name`, `descr`, `languageid`) VALUES (3,3,'demo stylesheet','',1);
-INSERT INTO `or_name` (`id`, `objectid`, `name`, `descr`, `languageid`) VALUES (5,5,'tanks','',1);
-INSERT INTO `or_name` (`id`, `objectid`, `name`, `descr`, `languageid`) VALUES (4,4,'bicycles','',1);
-INSERT INTO `or_name` (`id`, `objectid`, `name`, `descr`, `languageid`) VALUES (6,6,'other','',1);
-INSERT INTO `or_name` (`id`, `objectid`, `name`, `descr`, `languageid`) VALUES (7,7,'animals','',1);
-INSERT INTO `or_name` (`id`, `objectid`, `name`, `descr`, `languageid`) VALUES (8,8,'oceans','',1);
-INSERT INTO `or_object` (`id`, `parentid`, `projectid`, `filename`, `orderid`, `create_date`, `create_userid`, `lastchange_date`, `lastchange_userid`, `is_folder`, `is_file`, `is_page`, `is_link`) VALUES (1,NULL,1,'demo site',99999,1243978825,2,1243980196,2,1,0,0,0);
-INSERT INTO `or_object` (`id`, `parentid`, `projectid`, `filename`, `orderid`, `create_date`, `create_userid`, `lastchange_date`, `lastchange_userid`, `is_folder`, `is_file`, `is_page`, `is_link`) VALUES (2,1,1,'2',99999,1243978825,2,1243980638,2,0,0,1,0);
-INSERT INTO `or_object` (`id`, `parentid`, `projectid`, `filename`, `orderid`, `create_date`, `create_userid`, `lastchange_date`, `lastchange_userid`, `is_folder`, `is_file`, `is_page`, `is_link`) VALUES (3,1,1,'demo.css',99999,1243979266,2,1243979283,2,0,1,0,0);
-INSERT INTO `or_object` (`id`, `parentid`, `projectid`, `filename`, `orderid`, `create_date`, `create_userid`, `lastchange_date`, `lastchange_userid`, `is_folder`, `is_file`, `is_page`, `is_link`) VALUES (4,1,1,'4',99999,1243979699,2,1243979842,2,0,0,1,0);
-INSERT INTO `or_object` (`id`, `parentid`, `projectid`, `filename`, `orderid`, `create_date`, `create_userid`, `lastchange_date`, `lastchange_userid`, `is_folder`, `is_file`, `is_page`, `is_link`) VALUES (5,1,1,'5',99999,1243980122,2,1243980500,2,0,0,1,0);
-INSERT INTO `or_object` (`id`, `parentid`, `projectid`, `filename`, `orderid`, `create_date`, `create_userid`, `lastchange_date`, `lastchange_userid`, `is_folder`, `is_file`, `is_page`, `is_link`) VALUES (6,1,1,'6',99999,1243980196,2,1243980228,2,1,0,0,0);
-INSERT INTO `or_object` (`id`, `parentid`, `projectid`, `filename`, `orderid`, `create_date`, `create_userid`, `lastchange_date`, `lastchange_userid`, `is_folder`, `is_file`, `is_page`, `is_link`) VALUES (7,6,1,'7',99999,1243980211,2,1243980421,2,0,0,1,0);
-INSERT INTO `or_object` (`id`, `parentid`, `projectid`, `filename`, `orderid`, `create_date`, `create_userid`, `lastchange_date`, `lastchange_userid`, `is_folder`, `is_file`, `is_page`, `is_link`) VALUES (8,6,1,'8',99999,1243980228,2,1243980478,2,0,0,1,0);
-INSERT INTO `or_page` (`id`, `objectid`, `templateid`) VALUES (1,2,1);
-INSERT INTO `or_page` (`id`, `objectid`, `templateid`) VALUES (2,4,1);
-INSERT INTO `or_page` (`id`, `objectid`, `templateid`) VALUES (3,5,1);
-INSERT INTO `or_page` (`id`, `objectid`, `templateid`) VALUES (4,7,1);
-INSERT INTO `or_page` (`id`, `objectid`, `templateid`) VALUES (5,8,1);
-INSERT INTO `or_project` (`id`, `name`, `target_dir`, `ftp_url`, `ftp_passive`, `cmd_after_publish`, `content_negotiation`, `cut_index`) VALUES (1,'demo site','','',0,'',0,0);
-INSERT INTO `or_projectmodel` (`id`, `projectid`, `name`, `extension`, `is_default`) VALUES (1,1,'html','','0');
-INSERT INTO `or_template` (`id`, `projectid`, `name`) VALUES (1,1,'my_template');
-INSERT INTO `or_templatemodel` (`id`, `templateid`, `projectmodelid`, `extension`, `text`) VALUES (1,1,1,'html','<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\r\n          \"http://www.w3.org/TR/html4/loose.dtd\">\r\n<html>\r\n  <head>\r\n    <title>{{2}}</title>\r\n    <meta name=\"author\" content=\"Jan Dankert\">\r\n    <link type=\"text/css\" href=\"{{1}}\" rel=\"stylesheet\"> \r\n  </head>\r\n  <body>\r\n    <table width=\"100%\" cellpadding=\"10\" cellspacing=\"0\">\r\n      <tr>\r\n\r\n        <td class=\"oben\">\r\n          <table width=\"100%\">\r\n            <tr>\r\n              <td class=\"\"><h1>{{2}}</h2></td>\r\n              <td class=\"menu\">... a simple openrat demo site</td>\r\n\r\n            </tr>\r\n          </table>\r\n        </td>\r\n      </tr>\r\n      <tr>\r\n        <td>\r\n          <table width=\"100%\" cellpadding=\"10\">\r\n            <tr>\r\n              <td class=\"submenu\" width=\"100\">\r\n{{4}}\r\n</td>\r\n              <td colspan=\"2\">\r\n\r\n{{3}}\r\n\r\n<hr size=\"1\">\r\nLast edited on {{6}} by the user \r\n{{5}}.\r\n</td>\r\n\r\n            </tr>\r\n          </table>\r\n        </td>\r\n      </tr>\r\n    </table>\r\n  </body>\r\n</html>\r\n\r\n\r\n');
-INSERT INTO `or_user` (`id`, `name`, `password`, `ldap_dn`, `fullname`, `tel`, `mail`, `descr`, `style`, `is_admin`) VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3','','Administrator','','','Admin user','default',1);
-INSERT INTO `or_user` (`id`, `name`, `password`, `ldap_dn`, `fullname`, `tel`, `mail`, `descr`, `style`, `is_admin`) VALUES (2,'dankert','','uid=dankert,ou=users,dc=ss19a','dankert','','','','',1);
-INSERT INTO `or_user` (`id`, `name`, `password`, `ldap_dn`, `fullname`, `tel`, `mail`, `descr`, `style`, `is_admin`) VALUES (3,'george','','','','','','','default',0);
-INSERT INTO `or_user` (`id`, `name`, `password`, `ldap_dn`, `fullname`, `tel`, `mail`, `descr`, `style`, `is_admin`) VALUES (4,'barack','','','','','','','default',0);
-INSERT INTO `or_usergroup` (`id`, `userid`, `groupid`) VALUES (1,2,1);
-INSERT INTO `or_usergroup` (`id`, `userid`, `groupid`) VALUES (2,2,2);
-INSERT INTO `or_usergroup` (`id`, `userid`, `groupid`) VALUES (3,3,1);
-INSERT INTO `or_usergroup` (`id`, `userid`, `groupid`) VALUES (4,4,1);
-INSERT INTO `or_usergroup` (`id`, `userid`, `groupid`) VALUES (5,3,3);
-INSERT INTO `or_usergroup` (`id`, `userid`, `groupid`) VALUES (6,4,3);
-INSERT INTO `or_value` (`id`, `pageid`, `languageid`, `elementid`, `linkobjectid`, `text`, `number`, `date`, `active`, `publish`, `lastchange_date`, `lastchange_userid`) VALUES (1,1,1,3,NULL,'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.',NULL,NULL,0,0,1243979831,2);
-INSERT INTO `or_value` (`id`, `pageid`, `languageid`, `elementid`, `linkobjectid`, `text`, `number`, `date`, `active`, `publish`, `lastchange_date`, `lastchange_userid`) VALUES (2,2,1,3,NULL,'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.',NULL,NULL,1,1,1243979842,2);
-INSERT INTO `or_value` (`id`, `pageid`, `languageid`, `elementid`, `linkobjectid`, `text`, `number`, `date`, `active`, `publish`, `lastchange_date`, `lastchange_userid`) VALUES (3,1,1,3,NULL,'Überall dieselbe alte Leier. Das Layout ist fertig, der Text lässt auf sich warten. Damit das Layout nun nicht nackt im Raume steht und sich klein und leer vorkommt, springe ich ein: der Blindtext. Genau zu diesem Zwecke erschaffen, immer im Schatten meines großen Bruders »Lorem Ipsum«, freue ich mich jedes Mal, wenn Sie ein paar Zeilen lesen. Denn esse est percipi - Sein ist wahrgenommen werden. Und weil Sie nun schon die Güte haben, mich ein paar weitere Sätze lang zu begleiten, möchte ich diese Gelegenheit nutzen, Ihnen nicht nur als Lückenfüller zu dienen, sondern auf etwas hinzuweisen, das es ebenso verdient wahrgenommen zu werden: Webstandards nämlich. Sehen Sie, Webstandards sind das Regelwerk, auf dem Webseiten aufbauen. So gibt es Regeln für HTML, CSS, JavaScript oder auch XML; Worte, die Sie vielleicht schon einmal von Ihrem Entwickler gehört haben. Diese Standards sorgen dafür, dass alle Beteiligten aus einer Webseite den größten Nutzen ziehen. Im Gegensatz zu früheren Webseiten müssen wir zum Beispiel nicht mehr zwei verschiedene Webseiten für den Internet Explorer und einen anderen Browser programmieren. Es reicht eine Seite, die - richtig angelegt - sowohl auf verschiedenen Browsern im Netz funktioniert, aber ebenso gut für den Ausdruck oder',NULL,NULL,0,0,1243980076,2);
-INSERT INTO `or_value` (`id`, `pageid`, `languageid`, `elementid`, `linkobjectid`, `text`, `number`, `date`, `active`, `publish`, `lastchange_date`, `lastchange_userid`) VALUES (4,3,1,3,NULL,'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet. Etiam ultricies nisi vel augue. Curabitur ullamcorper ultricies nisi. Nam eget dui. Etiam rhoncus. Maecenas tempus, tellus eget condimentum rhoncus, sem quam semper libero, sit amet adipiscing sem neque sed ipsum. Nam quam nunc, blandit vel, luctus pulvinar, hendrerit id, lorem. Maecenas nec odio et ante tincidunt tempus. Donec vitae sapien ut libero venenatis faucibus. Nullam quis ante. Etiam sit amet orci eget eros faucibus tincidunt. Duis leo. Sed fringilla mauris sit amet nibh. Donec sodales sagittis magna. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc,',NULL,NULL,0,0,1243980160,2);
-INSERT INTO `or_value` (`id`, `pageid`, `languageid`, `elementid`, `linkobjectid`, `text`, `number`, `date`, `active`, `publish`, `lastchange_date`, `lastchange_userid`) VALUES (5,4,1,3,NULL,'Uh, here are some *animals*.\r\n- elephant\r\n- mouse\r\n- tiger',NULL,NULL,1,1,1243980421,2);
-INSERT INTO `or_value` (`id`, `pageid`, `languageid`, `elementid`, `linkobjectid`, `text`, `number`, `date`, `active`, `publish`, `lastchange_date`, `lastchange_userid`) VALUES (6,5,1,3,NULL,'Do you know some _oceans_?\r\n\r\nLike...\r\n- Atlantic\r\n- Pacific\r\n',NULL,NULL,1,1,1243980478,2);
-INSERT INTO `or_value` (`id`, `pageid`, `languageid`, `elementid`, `linkobjectid`, `text`, `number`, `date`, `active`, `publish`, `lastchange_date`, `lastchange_userid`) VALUES (7,3,1,3,NULL,'Lorem ipsum dolor sit amet, consectetuer adipiscing elit.\r\n\r\nAenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus.\r\n\r\nVivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet. Etiam ultricies nisi vel augue. Curabitur ullamcorper ultricies nisi. Nam eget dui. Etiam rhoncus. Maecenas tempus, tellus eget condimentum rhoncus, sem quam semper libero, sit amet adipiscing sem neque sed ipsum. Nam quam nunc, blandit vel, luctus pulvinar, hendrerit id, lorem.\r\n\r\nMaecenas nec odio et ante tincidunt tempus. Donec vitae sapien ut libero venenatis faucibus. Nullam quis ante. Etiam sit amet orci eget eros faucibus tincidunt. Duis leo. Sed fringilla mauris sit amet nibh. Donec sodales sagittis magna. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc,',NULL,NULL,1,1,1243980500,2);
-INSERT INTO `or_value` (`id`, `pageid`, `languageid`, `elementid`, `linkobjectid`, `text`, `number`, `date`, `active`, `publish`, `lastchange_date`, `lastchange_userid`) VALUES (8,1,1,3,NULL,'Lorem Ipsum is simply dummy text of the printing and typesetting industry.\r\n\r\nLorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.\r\n\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.',NULL,NULL,1,1,1243980638,2);
diff --git a/doc/database/sql/mysql/drop.sql b/doc/database/sql/mysql/drop.sql
@@ -1,19 +0,0 @@
--- Drop all OpenRat tables 
---
-DROP TABLE or_acl;
-DROP TABLE or_value;
-DROP TABLE or_usergroup;
-DROP TABLE or_templatemodel;
-DROP TABLE or_name;
-DROP TABLE or_link;
-DROP TABLE or_folder;
-DROP TABLE or_file;
-DROP TABLE or_element;
-DROP TABLE or_projectmodel;
-DROP TABLE or_page;
-DROP TABLE or_language;
-DROP TABLE or_template;
-DROP TABLE or_object;
-DROP TABLE or_group;
-DROP TABLE or_user;
-DROP TABLE or_project;-
\ No newline at end of file
diff --git a/doc/database/sql/mysql/truncate.sql b/doc/database/sql/mysql/truncate.sql
@@ -1,19 +0,0 @@
--- Truncate all OpenRat tables 
--- Attention, this cannot be rolled back!
-TRUNCATE TABLE or_acl;
-TRUNCATE TABLE or_value;
-TRUNCATE TABLE or_usergroup;
-TRUNCATE TABLE or_templatemodel;
-TRUNCATE TABLE or_name;
-TRUNCATE TABLE or_link;
-TRUNCATE TABLE or_folder;
-TRUNCATE TABLE or_file;
-TRUNCATE TABLE or_element;
-TRUNCATE TABLE or_projectmodel;
-TRUNCATE TABLE or_page;
-TRUNCATE TABLE or_language;
-TRUNCATE TABLE or_template;
-TRUNCATE TABLE or_object;
-TRUNCATE TABLE or_group;
-TRUNCATE TABLE or_user;
-TRUNCATE TABLE or_project;-
\ No newline at end of file
diff --git a/doc/database/sql/oracle/create.sql b/doc/database/sql/oracle/create.sql
@@ -1,363 +0,0 @@
--- DDL-Script for oracle
-
--- Table project
-CREATE TABLE or_project(
-   "ID" NUMBER NOT NULL
-  ,"NAME" VARCHAR(128) NULL
-  ,"TARGET_DIR" VARCHAR(255) NULL
-  ,"FTP_URL" VARCHAR(255) NULL
-  ,"FTP_PASSIVE" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"CMD_AFTER_PUBLISH" VARCHAR(255) NULL
-  ,"CONTENT_NEGOTIATION" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"CUT_INDEX" NUMBER(1) DEFAULT 0 NOT NULL
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_1
-                 ON or_project (name);
-
--- Table user
-CREATE TABLE or_user(
-   "ID" NUMBER NOT NULL
-  ,"NAME" VARCHAR(128) NULL
-  ,"PASSWORD" VARCHAR(50) NULL
-  ,"LDAP_DN" VARCHAR(255) NULL
-  ,"FULLNAME" VARCHAR(128) NULL
-  ,"TEL" VARCHAR(128) NULL
-  ,"MAIL" VARCHAR(255) NULL
-  ,"DESCR" VARCHAR(255) NULL
-  ,"STYLE" VARCHAR(64) NULL
-  ,"IS_ADMIN" NUMBER(1) DEFAULT 0 NOT NULL
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_2
-                 ON or_user (name);
-
--- Table group
-CREATE TABLE or_group(
-   "ID" NUMBER NOT NULL
-  ,"NAME" VARCHAR(100) NULL
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_3
-                 ON or_group (name);
-
--- Table object
-CREATE TABLE or_object(
-   "ID" NUMBER NOT NULL
-  ,"PARENTID" NUMBER NULL
-  ,"PROJECTID" NUMBER DEFAULT 0 NOT NULL
-  ,"FILENAME" VARCHAR(255) NULL
-  ,"ORDERID" NUMBER DEFAULT 0 NOT NULL
-  ,"CREATE_DATE" NUMBER DEFAULT 0 NOT NULL
-  ,"CREATE_USERID" NUMBER DEFAULT 0 NULL
-  ,"LASTCHANGE_DATE" NUMBER DEFAULT 0 NOT NULL
-  ,"LASTCHANGE_USERID" NUMBER DEFAULT 0 NULL
-  ,"IS_FOLDER" NUMBER(1) NOT NULL
-  ,"IS_FILE" NUMBER(1) NOT NULL
-  ,"IS_PAGE" NUMBER(1) NOT NULL
-  ,"IS_LINK" NUMBER(1) NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_4
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-  ,CONSTRAINT or_fk_5
-     FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
-  ,CONSTRAINT or_fk_6
-     FOREIGN KEY (create_userid) REFERENCES or_user (id)
-);
-CREATE INDEX or_idx_7
-          ON or_object (parentid);
-CREATE INDEX or_idx_8
-          ON or_object (projectid);
-CREATE INDEX or_idx_9
-          ON or_object (is_folder);
-CREATE INDEX or_idx_10
-          ON or_object (is_file);
-CREATE INDEX or_idx_11
-          ON or_object (is_page);
-CREATE INDEX or_idx_12
-          ON or_object (is_link);
-CREATE INDEX or_idx_13
-          ON or_object (orderid);
-CREATE INDEX or_idx_14
-          ON or_object (create_userid);
-CREATE INDEX or_idx_15
-          ON or_object (lastchange_userid);
-CREATE UNIQUE INDEX or_uidx_16
-                 ON or_object (parentid,filename);
-
--- Table template
-CREATE TABLE or_template(
-   "ID" NUMBER NOT NULL
-  ,"PROJECTID" NUMBER NOT NULL
-  ,"NAME" VARCHAR(50) NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_17
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-);
-CREATE INDEX or_idx_18
-          ON or_template (projectid);
-CREATE INDEX or_idx_19
-          ON or_template (name);
-CREATE UNIQUE INDEX or_uidx_20
-                 ON or_template (projectid,name);
-
--- Table language
-CREATE TABLE or_language(
-   "ID" NUMBER NOT NULL
-  ,"PROJECTID" NUMBER DEFAULT 0 NOT NULL
-  ,"ISOCODE" VARCHAR(10) NULL
-  ,"NAME" VARCHAR(50) NULL
-  ,"IS_DEFAULT" NUMBER(1) DEFAULT 0 NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_21
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-);
-CREATE UNIQUE INDEX or_uidx_22
-                 ON or_language (projectid,isocode);
-
--- Table page
-CREATE TABLE or_page(
-   "ID" NUMBER NOT NULL
-  ,"OBJECTID" NUMBER DEFAULT 0 NOT NULL
-  ,"TEMPLATEID" NUMBER DEFAULT 0 NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_23
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-  ,CONSTRAINT or_fk_24
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-);
-CREATE UNIQUE INDEX or_uidx_25
-                 ON or_page (objectid);
-CREATE INDEX or_idx_26
-          ON or_page (templateid);
-
--- Table projectmodel
-CREATE TABLE or_projectmodel(
-   "ID" NUMBER NOT NULL
-  ,"PROJECTID" NUMBER DEFAULT 0 NOT NULL
-  ,"NAME" VARCHAR(50) NULL
-  ,"EXTENSION" VARCHAR(10) NULL
-  ,"IS_DEFAULT" NUMBER(1) DEFAULT 0 NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_27
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-);
-CREATE INDEX or_idx_28
-          ON or_projectmodel (projectid);
-CREATE UNIQUE INDEX or_uidx_29
-                 ON or_projectmodel (projectid,name);
-
--- Table element
-CREATE TABLE or_element(
-   "ID" NUMBER NOT NULL
-  ,"TEMPLATEID" NUMBER DEFAULT 0 NOT NULL
-  ,"NAME" VARCHAR(50) NULL
-  ,"DESCR" VARCHAR(255) NULL
-  ,"TYPE" VARCHAR(20) NULL
-  ,"SUBTYPE" VARCHAR(20) NULL
-  ,"WITH_ICON" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"DATEFORMAT" VARCHAR(100) NULL
-  ,"WIKI" NUMBER(1) DEFAULT 0 NULL
-  ,"HTML" NUMBER(1) DEFAULT 0 NULL
-  ,"ALL_LANGUAGES" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"WRITABLE" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"DECIMALS" NUMBER DEFAULT 0 NULL
-  ,"DEC_POINT" VARCHAR(5) NULL
-  ,"THOUSAND_SEP" VARCHAR(1) NULL
-  ,"CODE" CLOB NULL
-  ,"DEFAULT_TEXT" CLOB NULL
-  ,"FOLDEROBJECTID" NUMBER NULL
-  ,"DEFAULT_OBJECTID" NUMBER NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_30
-     FOREIGN KEY (default_objectid) REFERENCES or_object (id)
-  ,CONSTRAINT or_fk_31
-     FOREIGN KEY (folderobjectid) REFERENCES or_object (id)
-  ,CONSTRAINT or_fk_32
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-);
-CREATE INDEX or_idx_33
-          ON or_element (templateid);
-CREATE INDEX or_idx_34
-          ON or_element (name);
-CREATE UNIQUE INDEX or_uidx_35
-                 ON or_element (templateid,name);
-
--- Table file
-CREATE TABLE or_file(
-   "ID" NUMBER NOT NULL
-  ,"OBJECTID" NUMBER DEFAULT 0 NOT NULL
-  ,"EXTENSION" VARCHAR(10) NULL
-  ,"SIZE" NUMBER DEFAULT 0 NOT NULL
-  ,"VALUE" CLOB NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_36
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-);
-CREATE UNIQUE INDEX or_uidx_37
-                 ON or_file (objectid);
-
--- Table folder
-CREATE TABLE or_folder(
-   "ID" NUMBER NOT NULL
-  ,"OBJECTID" NUMBER DEFAULT 0 NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_38
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-);
-CREATE UNIQUE INDEX or_uidx_39
-                 ON or_folder (objectid);
-
--- Table link
-CREATE TABLE or_link(
-   "ID" NUMBER NOT NULL
-  ,"OBJECTID" NUMBER DEFAULT 0 NOT NULL
-  ,"LINK_OBJECTID" NUMBER NULL
-  ,"URL" VARCHAR(255) NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_40
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-  ,CONSTRAINT or_fk_41
-     FOREIGN KEY (link_objectid) REFERENCES or_object (id)
-);
-CREATE UNIQUE INDEX or_uidx_42
-                 ON or_link (objectid);
-CREATE INDEX or_idx_43
-          ON or_link (link_objectid);
-
--- Table name
-CREATE TABLE or_name(
-   "ID" NUMBER NOT NULL
-  ,"OBJECTID" NUMBER DEFAULT 0 NOT NULL
-  ,"NAME" VARCHAR(255) NULL
-  ,"DESCR" VARCHAR(255) NULL
-  ,"LANGUAGEID" NUMBER DEFAULT 0 NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_44
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-  ,CONSTRAINT or_fk_45
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-);
-CREATE INDEX or_idx_46
-          ON or_name (objectid);
-CREATE INDEX or_idx_47
-          ON or_name (languageid);
-CREATE UNIQUE INDEX or_uidx_48
-                 ON or_name (objectid,languageid);
-
--- Table templatemodel
-CREATE TABLE or_templatemodel(
-   "ID" NUMBER NOT NULL
-  ,"TEMPLATEID" NUMBER DEFAULT 0 NOT NULL
-  ,"PROJECTMODELID" NUMBER DEFAULT 0 NOT NULL
-  ,"EXTENSION" VARCHAR(10) NULL
-  ,"TEXT" CLOB NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_49
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-  ,CONSTRAINT or_fk_50
-     FOREIGN KEY (projectmodelid) REFERENCES or_projectmodel (id)
-);
-CREATE INDEX or_idx_51
-          ON or_templatemodel (templateid);
-CREATE UNIQUE INDEX or_uidx_52
-                 ON or_templatemodel (templateid,extension);
-CREATE UNIQUE INDEX or_uidx_53
-                 ON or_templatemodel (templateid,projectmodelid);
-
--- Table usergroup
-CREATE TABLE or_usergroup(
-   "ID" NUMBER NOT NULL
-  ,"USERID" NUMBER NOT NULL
-  ,"GROUPID" NUMBER NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_54
-     FOREIGN KEY (groupid) REFERENCES or_group (id)
-  ,CONSTRAINT or_fk_55
-     FOREIGN KEY (userid) REFERENCES or_user (id)
-);
-CREATE INDEX or_idx_56
-          ON or_usergroup (groupid);
-CREATE INDEX or_idx_57
-          ON or_usergroup (userid);
-CREATE UNIQUE INDEX or_uidx_58
-                 ON or_usergroup (userid,groupid);
-
--- Table value
-CREATE TABLE or_value(
-   "ID" NUMBER NOT NULL
-  ,"PAGEID" NUMBER DEFAULT 0 NOT NULL
-  ,"LANGUAGEID" NUMBER NOT NULL
-  ,"ELEMENTID" NUMBER DEFAULT 0 NOT NULL
-  ,"LINKOBJECTID" NUMBER NULL
-  ,"TEXT" CLOB NULL
-  ,"NUMBER" NUMBER NULL
-  ,"DATE" NUMBER NULL
-  ,"ACTIVE" NUMBER DEFAULT 0 NOT NULL
-  ,"PUBLISH" NUMBER NOT NULL
-  ,"LASTCHANGE_DATE" NUMBER DEFAULT 0 NOT NULL
-  ,"LASTCHANGE_USERID" NUMBER NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_59
-     FOREIGN KEY (pageid) REFERENCES or_page (id)
-  ,CONSTRAINT or_fk_60
-     FOREIGN KEY (elementid) REFERENCES or_element (id)
-  ,CONSTRAINT or_fk_61
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-  ,CONSTRAINT or_fk_62
-     FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
-  ,CONSTRAINT or_fk_63
-     FOREIGN KEY (linkobjectid) REFERENCES or_object (id)
-);
-CREATE INDEX or_idx_64
-          ON or_value (pageid);
-CREATE INDEX or_idx_65
-          ON or_value (languageid);
-CREATE INDEX or_idx_66
-          ON or_value (elementid);
-CREATE INDEX or_idx_67
-          ON or_value (active);
-CREATE INDEX or_idx_68
-          ON or_value (lastchange_date);
-CREATE INDEX or_idx_69
-          ON or_value (publish);
-
--- Table acl
-CREATE TABLE or_acl(
-   "ID" NUMBER NOT NULL
-  ,"USERID" NUMBER NULL
-  ,"GROUPID" NUMBER NULL
-  ,"OBJECTID" NUMBER NOT NULL
-  ,"LANGUAGEID" NUMBER DEFAULT 0 NULL
-  ,"IS_WRITE" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_PROP" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_CREATE_FOLDER" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_CREATE_FILE" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_CREATE_LINK" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_CREATE_PAGE" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_DELETE" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_RELEASE" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_PUBLISH" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_GRANT" NUMBER(1) DEFAULT 0 NOT NULL
-  ,"IS_TRANSMIT" NUMBER(1) DEFAULT 0 NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_70
-     FOREIGN KEY (groupid) REFERENCES or_group (id)
-  ,CONSTRAINT or_fk_71
-     FOREIGN KEY (userid) REFERENCES or_user (id)
-  ,CONSTRAINT or_fk_72
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-  ,CONSTRAINT or_fk_73
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-);
-CREATE INDEX or_idx_74
-          ON or_acl (userid);
-CREATE INDEX or_idx_75
-          ON or_acl (groupid);
-CREATE INDEX or_idx_76
-          ON or_acl (languageid);
-CREATE INDEX or_idx_77
-          ON or_acl (objectid);
-CREATE INDEX or_idx_78
-          ON or_acl (is_transmit);
-INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1);
diff --git a/doc/database/sql/postgresql/create.sql b/doc/database/sql/postgresql/create.sql
@@ -1,393 +0,0 @@
--- DDL-Script for postgresql
-
--- Table project
-CREATE TABLE or_project(
-   id INTEGER NOT NULL
-  ,name VARCHAR(128) NOT NULL
-  ,target_dir VARCHAR(255) NOT NULL
-  ,ftp_url VARCHAR(255) NOT NULL
-  ,ftp_passive INTEGER(1) NOT NULL DEFAULT 0
-  ,cmd_after_publish VARCHAR(255) NOT NULL
-  ,content_negotiation INTEGER(1) NOT NULL DEFAULT 0
-  ,cut_index INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_project_name
-                 ON or_project (name);
-
--- Table user
-CREATE TABLE or_user(
-   id INTEGER NOT NULL
-  ,name VARCHAR(128) NOT NULL
-  ,password VARCHAR(50) NOT NULL
-  ,ldap_dn VARCHAR(255) NOT NULL
-  ,fullname VARCHAR(128) NOT NULL
-  ,tel VARCHAR(128) NOT NULL
-  ,mail VARCHAR(255) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,style VARCHAR(64) NOT NULL
-  ,is_admin INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_user_name
-                 ON or_user (name);
-
--- Table group
-CREATE TABLE or_group(
-   id INTEGER NOT NULL
-  ,name VARCHAR(100) NOT NULL
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_group_name
-                 ON or_group (name);
-
--- Table object
-CREATE TABLE or_object(
-   id INTEGER NOT NULL
-  ,parentid INTEGER NULL
-  ,projectid INTEGER NOT NULL DEFAULT 0
-  ,filename VARCHAR(255) NOT NULL
-  ,orderid INTEGER NOT NULL DEFAULT 0
-  ,create_date INTEGER NOT NULL DEFAULT 0
-  ,create_userid INTEGER NULL DEFAULT 0
-  ,lastchange_date INTEGER NOT NULL DEFAULT 0
-  ,lastchange_userid INTEGER NULL DEFAULT 0
-  ,is_folder INTEGER(1) NOT NULL
-  ,is_file INTEGER(1) NOT NULL
-  ,is_page INTEGER(1) NOT NULL
-  ,is_link INTEGER(1) NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_object_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_object_lastchange_userid
-     FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_object_create_userid
-     FOREIGN KEY (create_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_object_parentid
-          ON or_object (parentid);
-CREATE INDEX or_idx_object_projectid
-          ON or_object (projectid);
-CREATE INDEX or_idx_object_is_folder
-          ON or_object (is_folder);
-CREATE INDEX or_idx_object_is_file
-          ON or_object (is_file);
-CREATE INDEX or_idx_object_is_page
-          ON or_object (is_page);
-CREATE INDEX or_idx_object_is_link
-          ON or_object (is_link);
-CREATE INDEX or_idx_object_orderid
-          ON or_object (orderid);
-CREATE INDEX or_idx_object_create_userid
-          ON or_object (create_userid);
-CREATE INDEX or_idx_object_lastchange_userid
-          ON or_object (lastchange_userid);
-CREATE UNIQUE INDEX or_uidx_object_parentid_filename
-                 ON or_object (parentid,filename);
-
--- Table template
-CREATE TABLE or_template(
-   id INTEGER NOT NULL
-  ,projectid INTEGER NOT NULL
-  ,name VARCHAR(50) NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_template_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_template_projectid
-          ON or_template (projectid);
-CREATE INDEX or_idx_template_name
-          ON or_template (name);
-CREATE UNIQUE INDEX or_uidx_template_projectid_name
-                 ON or_template (projectid,name);
-
--- Table language
-CREATE TABLE or_language(
-   id INTEGER NOT NULL
-  ,projectid INTEGER NOT NULL DEFAULT 0
-  ,isocode VARCHAR(10) NOT NULL
-  ,name VARCHAR(50) NOT NULL
-  ,is_default INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_language_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_language_projectid_isocode
-                 ON or_language (projectid,isocode);
-
--- Table page
-CREATE TABLE or_page(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,templateid INTEGER NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_page_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_page_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_page_objectid
-                 ON or_page (objectid);
-CREATE INDEX or_idx_page_templateid
-          ON or_page (templateid);
-
--- Table projectmodel
-CREATE TABLE or_projectmodel(
-   id INTEGER NOT NULL
-  ,projectid INTEGER NOT NULL DEFAULT 0
-  ,name VARCHAR(50) NOT NULL
-  ,extension VARCHAR(10) NULL
-  ,is_default INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_projectmodel_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_projectmodel_projectid
-          ON or_projectmodel (projectid);
-CREATE UNIQUE INDEX or_uidx_projectmodel_projectid_name
-                 ON or_projectmodel (projectid,name);
-
--- Table element
-CREATE TABLE or_element(
-   id INTEGER NOT NULL
-  ,templateid INTEGER NOT NULL DEFAULT 0
-  ,name VARCHAR(50) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,type VARCHAR(20) NOT NULL
-  ,subtype VARCHAR(20) NULL
-  ,with_icon INTEGER(1) NOT NULL DEFAULT 0
-  ,dateformat VARCHAR(100) NULL
-  ,wiki INTEGER(1) NULL DEFAULT 0
-  ,html INTEGER(1) NULL DEFAULT 0
-  ,all_languages INTEGER(1) NOT NULL DEFAULT 0
-  ,writable INTEGER(1) NOT NULL DEFAULT 0
-  ,decimals INTEGER NULL DEFAULT 0
-  ,dec_point VARCHAR(5) NULL
-  ,thousand_sep VARCHAR(1) NULL
-  ,code TEXT NULL
-  ,default_text TEXT NULL
-  ,folderobjectid INTEGER NULL
-  ,default_objectid INTEGER NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_element_default_objectid
-     FOREIGN KEY (default_objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_element_folderobjectid
-     FOREIGN KEY (folderobjectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_element_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_element_templateid
-          ON or_element (templateid);
-CREATE INDEX or_idx_element_name
-          ON or_element (name);
-CREATE UNIQUE INDEX or_uidx_element_templateid_name
-                 ON or_element (templateid,name);
-
--- Table file
-CREATE TABLE or_file(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,extension VARCHAR(10) NOT NULL
-  ,size INTEGER NOT NULL DEFAULT 0
-  ,value TEXT NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_file_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_file_objectid
-                 ON or_file (objectid);
-
--- Table folder
-CREATE TABLE or_folder(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_folder_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_folder_objectid
-                 ON or_folder (objectid);
-
--- Table link
-CREATE TABLE or_link(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,link_objectid INTEGER NULL
-  ,url VARCHAR(255) NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_link_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_link_link_objectid
-     FOREIGN KEY (link_objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_link_objectid
-                 ON or_link (objectid);
-CREATE INDEX or_idx_link_link_objectid
-          ON or_link (link_objectid);
-
--- Table name
-CREATE TABLE or_name(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,name VARCHAR(255) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,languageid INTEGER NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_name_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_name_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_name_objectid
-          ON or_name (objectid);
-CREATE INDEX or_idx_name_languageid
-          ON or_name (languageid);
-CREATE UNIQUE INDEX or_uidx_name_objectid_languageid
-                 ON or_name (objectid,languageid);
-
--- Table templatemodel
-CREATE TABLE or_templatemodel(
-   id INTEGER NOT NULL
-  ,templateid INTEGER NOT NULL DEFAULT 0
-  ,projectmodelid INTEGER NOT NULL DEFAULT 0
-  ,extension VARCHAR(10) NULL
-  ,text TEXT NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_templatemodel_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_templatemodel_projectmodelid
-     FOREIGN KEY (projectmodelid) REFERENCES or_projectmodel (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_templatemodel_templateid
-          ON or_templatemodel (templateid);
-CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_extension
-                 ON or_templatemodel (templateid,extension);
-CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_projectmodelid
-                 ON or_templatemodel (templateid,projectmodelid);
-
--- Table usergroup
-CREATE TABLE or_usergroup(
-   id INTEGER NOT NULL
-  ,userid INTEGER NOT NULL
-  ,groupid INTEGER NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_usergroup_groupid
-     FOREIGN KEY (groupid) REFERENCES or_group (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_usergroup_userid
-     FOREIGN KEY (userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_usergroup_groupid
-          ON or_usergroup (groupid);
-CREATE INDEX or_idx_usergroup_userid
-          ON or_usergroup (userid);
-CREATE UNIQUE INDEX or_uidx_usergroup_userid_groupid
-                 ON or_usergroup (userid,groupid);
-
--- Table value
-CREATE TABLE or_value(
-   id INTEGER NOT NULL
-  ,pageid INTEGER NOT NULL DEFAULT 0
-  ,languageid INTEGER NOT NULL
-  ,elementid INTEGER NOT NULL DEFAULT 0
-  ,linkobjectid INTEGER NULL
-  ,text TEXT NULL
-  ,number INTEGER NULL
-  ,date INTEGER NULL
-  ,active INTEGER NOT NULL DEFAULT 0
-  ,publish INTEGER NOT NULL
-  ,lastchange_date INTEGER NOT NULL DEFAULT 0
-  ,lastchange_userid INTEGER NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_value_pageid
-     FOREIGN KEY (pageid) REFERENCES or_page (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_elementid
-     FOREIGN KEY (elementid) REFERENCES or_element (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_lastchange_userid
-     FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_linkobjectid
-     FOREIGN KEY (linkobjectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_value_pageid
-          ON or_value (pageid);
-CREATE INDEX or_idx_value_languageid
-          ON or_value (languageid);
-CREATE INDEX or_idx_value_elementid
-          ON or_value (elementid);
-CREATE INDEX or_idx_value_active
-          ON or_value (active);
-CREATE INDEX or_idx_value_lastchange_date
-          ON or_value (lastchange_date);
-CREATE INDEX or_idx_value_publish
-          ON or_value (publish);
-
--- Table acl
-CREATE TABLE or_acl(
-   id INTEGER NOT NULL
-  ,userid INTEGER NULL
-  ,groupid INTEGER NULL
-  ,objectid INTEGER NOT NULL
-  ,languageid INTEGER NULL DEFAULT 0
-  ,is_write INTEGER(1) NOT NULL DEFAULT 0
-  ,is_prop INTEGER(1) NOT NULL DEFAULT 0
-  ,is_create_folder INTEGER(1) NOT NULL DEFAULT 0
-  ,is_create_file INTEGER(1) NOT NULL DEFAULT 0
-  ,is_create_link INTEGER(1) NOT NULL DEFAULT 0
-  ,is_create_page INTEGER(1) NOT NULL DEFAULT 0
-  ,is_delete INTEGER(1) NOT NULL DEFAULT 0
-  ,is_release INTEGER(1) NOT NULL DEFAULT 0
-  ,is_publish INTEGER(1) NOT NULL DEFAULT 0
-  ,is_grant INTEGER(1) NOT NULL DEFAULT 0
-  ,is_transmit INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_acl_groupid
-     FOREIGN KEY (groupid) REFERENCES or_group (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_userid
-     FOREIGN KEY (userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_acl_userid
-          ON or_acl (userid);
-CREATE INDEX or_idx_acl_groupid
-          ON or_acl (groupid);
-CREATE INDEX or_idx_acl_languageid
-          ON or_acl (languageid);
-CREATE INDEX or_idx_acl_objectid
-          ON or_acl (objectid);
-CREATE INDEX or_idx_acl_is_transmit
-          ON or_acl (is_transmit);
-INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1);
diff --git a/doc/database/sql/postgresql/drop.sql b/doc/database/sql/postgresql/drop.sql
@@ -1,19 +0,0 @@
--- Drop all OpenRat tables 
---
-DROP TABLE or_acl;
-DROP TABLE or_value;
-DROP TABLE or_usergroup;
-DROP TABLE or_templatemodel;
-DROP TABLE or_name;
-DROP TABLE or_link;
-DROP TABLE or_folder;
-DROP TABLE or_file;
-DROP TABLE or_element;
-DROP TABLE or_projectmodel;
-DROP TABLE or_page;
-DROP TABLE or_language;
-DROP TABLE or_template;
-DROP TABLE or_object;
-DROP TABLE or_group;
-DROP TABLE or_user;
-DROP TABLE or_project;-
\ No newline at end of file
diff --git a/doc/database/sql/postgresql/grant.sql b/doc/database/sql/postgresql/grant.sql
@@ -1,22 +0,0 @@
--- Grant rights on all OpenRat tables 
---
--- Make sure to replace the word "username" with the real database username
--- On MySql this grants are mostly unnecessary.
-
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_acl           TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_value         TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_usergroup     TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_templatemodel TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_name          TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_link          TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_folder        TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_file          TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_element       TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_projectmodel  TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_page          TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_language      TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_template      TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_object        TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_group         TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_user          TO username;
-GRANT SELECT,INSERT,UPDATE,DELETE ON or_project       TO username;-
\ No newline at end of file
diff --git a/doc/database/sql/sqlite/create.sql b/doc/database/sql/sqlite/create.sql
@@ -1,393 +0,0 @@
--- DDL-Script for sqlite
-
--- Table project
-CREATE TABLE or_project(
-   id INTEGER NOT NULL
-  ,name VARCHAR(128) NOT NULL
-  ,target_dir VARCHAR(255) NOT NULL
-  ,ftp_url VARCHAR(255) NOT NULL
-  ,ftp_passive INTEGER(1) NOT NULL DEFAULT 0
-  ,cmd_after_publish VARCHAR(255) NOT NULL
-  ,content_negotiation INTEGER(1) NOT NULL DEFAULT 0
-  ,cut_index INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_project_name
-                 ON or_project (name);
-
--- Table user
-CREATE TABLE or_user(
-   id INTEGER NOT NULL
-  ,name VARCHAR(128) NOT NULL
-  ,password VARCHAR(50) NOT NULL
-  ,ldap_dn VARCHAR(255) NOT NULL
-  ,fullname VARCHAR(128) NOT NULL
-  ,tel VARCHAR(128) NOT NULL
-  ,mail VARCHAR(255) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,style VARCHAR(64) NOT NULL
-  ,is_admin INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_user_name
-                 ON or_user (name);
-
--- Table group
-CREATE TABLE or_group(
-   id INTEGER NOT NULL
-  ,name VARCHAR(100) NOT NULL
-  ,PRIMARY KEY (id)
-);
-CREATE UNIQUE INDEX or_uidx_group_name
-                 ON or_group (name);
-
--- Table object
-CREATE TABLE or_object(
-   id INTEGER NOT NULL
-  ,parentid INTEGER NULL
-  ,projectid INTEGER NOT NULL DEFAULT 0
-  ,filename VARCHAR(255) NOT NULL
-  ,orderid INTEGER NOT NULL DEFAULT 0
-  ,create_date INTEGER NOT NULL DEFAULT 0
-  ,create_userid INTEGER NULL DEFAULT 0
-  ,lastchange_date INTEGER NOT NULL DEFAULT 0
-  ,lastchange_userid INTEGER NULL DEFAULT 0
-  ,is_folder INTEGER(1) NOT NULL
-  ,is_file INTEGER(1) NOT NULL
-  ,is_page INTEGER(1) NOT NULL
-  ,is_link INTEGER(1) NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_object_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_object_lastchange_userid
-     FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_object_create_userid
-     FOREIGN KEY (create_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_object_parentid
-          ON or_object (parentid);
-CREATE INDEX or_idx_object_projectid
-          ON or_object (projectid);
-CREATE INDEX or_idx_object_is_folder
-          ON or_object (is_folder);
-CREATE INDEX or_idx_object_is_file
-          ON or_object (is_file);
-CREATE INDEX or_idx_object_is_page
-          ON or_object (is_page);
-CREATE INDEX or_idx_object_is_link
-          ON or_object (is_link);
-CREATE INDEX or_idx_object_orderid
-          ON or_object (orderid);
-CREATE INDEX or_idx_object_create_userid
-          ON or_object (create_userid);
-CREATE INDEX or_idx_object_lastchange_userid
-          ON or_object (lastchange_userid);
-CREATE UNIQUE INDEX or_uidx_object_parentid_filename
-                 ON or_object (parentid,filename);
-
--- Table template
-CREATE TABLE or_template(
-   id INTEGER NOT NULL
-  ,projectid INTEGER NOT NULL
-  ,name VARCHAR(50) NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_template_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_template_projectid
-          ON or_template (projectid);
-CREATE INDEX or_idx_template_name
-          ON or_template (name);
-CREATE UNIQUE INDEX or_uidx_template_projectid_name
-                 ON or_template (projectid,name);
-
--- Table language
-CREATE TABLE or_language(
-   id INTEGER NOT NULL
-  ,projectid INTEGER NOT NULL DEFAULT 0
-  ,isocode VARCHAR(10) NOT NULL
-  ,name VARCHAR(50) NOT NULL
-  ,is_default INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_language_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_language_projectid_isocode
-                 ON or_language (projectid,isocode);
-
--- Table page
-CREATE TABLE or_page(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,templateid INTEGER NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_page_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_page_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_page_objectid
-                 ON or_page (objectid);
-CREATE INDEX or_idx_page_templateid
-          ON or_page (templateid);
-
--- Table projectmodel
-CREATE TABLE or_projectmodel(
-   id INTEGER NOT NULL
-  ,projectid INTEGER NOT NULL DEFAULT 0
-  ,name VARCHAR(50) NOT NULL
-  ,extension VARCHAR(10) NULL
-  ,is_default INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_projectmodel_projectid
-     FOREIGN KEY (projectid) REFERENCES or_project (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_projectmodel_projectid
-          ON or_projectmodel (projectid);
-CREATE UNIQUE INDEX or_uidx_projectmodel_projectid_name
-                 ON or_projectmodel (projectid,name);
-
--- Table element
-CREATE TABLE or_element(
-   id INTEGER NOT NULL
-  ,templateid INTEGER NOT NULL DEFAULT 0
-  ,name VARCHAR(50) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,type VARCHAR(20) NOT NULL
-  ,subtype VARCHAR(20) NULL
-  ,with_icon INTEGER(1) NOT NULL DEFAULT 0
-  ,dateformat VARCHAR(100) NULL
-  ,wiki INTEGER(1) NULL DEFAULT 0
-  ,html INTEGER(1) NULL DEFAULT 0
-  ,all_languages INTEGER(1) NOT NULL DEFAULT 0
-  ,writable INTEGER(1) NOT NULL DEFAULT 0
-  ,decimals INTEGER NULL DEFAULT 0
-  ,dec_point VARCHAR(5) NULL
-  ,thousand_sep VARCHAR(1) NULL
-  ,code TEXT NULL
-  ,default_text TEXT NULL
-  ,folderobjectid INTEGER NULL
-  ,default_objectid INTEGER NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_element_default_objectid
-     FOREIGN KEY (default_objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_element_folderobjectid
-     FOREIGN KEY (folderobjectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_element_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_element_templateid
-          ON or_element (templateid);
-CREATE INDEX or_idx_element_name
-          ON or_element (name);
-CREATE UNIQUE INDEX or_uidx_element_templateid_name
-                 ON or_element (templateid,name);
-
--- Table file
-CREATE TABLE or_file(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,extension VARCHAR(10) NOT NULL
-  ,size INTEGER NOT NULL DEFAULT 0
-  ,value TEXT NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_file_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_file_objectid
-                 ON or_file (objectid);
-
--- Table folder
-CREATE TABLE or_folder(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_folder_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_folder_objectid
-                 ON or_folder (objectid);
-
--- Table link
-CREATE TABLE or_link(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,link_objectid INTEGER NULL
-  ,url VARCHAR(255) NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_link_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_link_link_objectid
-     FOREIGN KEY (link_objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE UNIQUE INDEX or_uidx_link_objectid
-                 ON or_link (objectid);
-CREATE INDEX or_idx_link_link_objectid
-          ON or_link (link_objectid);
-
--- Table name
-CREATE TABLE or_name(
-   id INTEGER NOT NULL
-  ,objectid INTEGER NOT NULL DEFAULT 0
-  ,name VARCHAR(255) NOT NULL
-  ,descr VARCHAR(255) NOT NULL
-  ,languageid INTEGER NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_name_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_name_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_name_objectid
-          ON or_name (objectid);
-CREATE INDEX or_idx_name_languageid
-          ON or_name (languageid);
-CREATE UNIQUE INDEX or_uidx_name_objectid_languageid
-                 ON or_name (objectid,languageid);
-
--- Table templatemodel
-CREATE TABLE or_templatemodel(
-   id INTEGER NOT NULL
-  ,templateid INTEGER NOT NULL DEFAULT 0
-  ,projectmodelid INTEGER NOT NULL DEFAULT 0
-  ,extension VARCHAR(10) NULL
-  ,text TEXT NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_templatemodel_templateid
-     FOREIGN KEY (templateid) REFERENCES or_template (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_templatemodel_projectmodelid
-     FOREIGN KEY (projectmodelid) REFERENCES or_projectmodel (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_templatemodel_templateid
-          ON or_templatemodel (templateid);
-CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_extension
-                 ON or_templatemodel (templateid,extension);
-CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_projectmodelid
-                 ON or_templatemodel (templateid,projectmodelid);
-
--- Table usergroup
-CREATE TABLE or_usergroup(
-   id INTEGER NOT NULL
-  ,userid INTEGER NOT NULL
-  ,groupid INTEGER NOT NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_usergroup_groupid
-     FOREIGN KEY (groupid) REFERENCES or_group (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_usergroup_userid
-     FOREIGN KEY (userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_usergroup_groupid
-          ON or_usergroup (groupid);
-CREATE INDEX or_idx_usergroup_userid
-          ON or_usergroup (userid);
-CREATE UNIQUE INDEX or_uidx_usergroup_userid_groupid
-                 ON or_usergroup (userid,groupid);
-
--- Table value
-CREATE TABLE or_value(
-   id INTEGER NOT NULL
-  ,pageid INTEGER NOT NULL DEFAULT 0
-  ,languageid INTEGER NOT NULL
-  ,elementid INTEGER NOT NULL DEFAULT 0
-  ,linkobjectid INTEGER NULL
-  ,text TEXT NULL
-  ,number INTEGER NULL
-  ,date INTEGER NULL
-  ,active INTEGER NOT NULL DEFAULT 0
-  ,publish INTEGER NOT NULL
-  ,lastchange_date INTEGER NOT NULL DEFAULT 0
-  ,lastchange_userid INTEGER NULL
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_value_pageid
-     FOREIGN KEY (pageid) REFERENCES or_page (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_elementid
-     FOREIGN KEY (elementid) REFERENCES or_element (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_lastchange_userid
-     FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_value_linkobjectid
-     FOREIGN KEY (linkobjectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_value_pageid
-          ON or_value (pageid);
-CREATE INDEX or_idx_value_languageid
-          ON or_value (languageid);
-CREATE INDEX or_idx_value_elementid
-          ON or_value (elementid);
-CREATE INDEX or_idx_value_active
-          ON or_value (active);
-CREATE INDEX or_idx_value_lastchange_date
-          ON or_value (lastchange_date);
-CREATE INDEX or_idx_value_publish
-          ON or_value (publish);
-
--- Table acl
-CREATE TABLE or_acl(
-   id INTEGER NOT NULL
-  ,userid INTEGER NULL
-  ,groupid INTEGER NULL
-  ,objectid INTEGER NOT NULL
-  ,languageid INTEGER NULL DEFAULT 0
-  ,is_write INTEGER(1) NOT NULL DEFAULT 0
-  ,is_prop INTEGER(1) NOT NULL DEFAULT 0
-  ,is_create_folder INTEGER(1) NOT NULL DEFAULT 0
-  ,is_create_file INTEGER(1) NOT NULL DEFAULT 0
-  ,is_create_link INTEGER(1) NOT NULL DEFAULT 0
-  ,is_create_page INTEGER(1) NOT NULL DEFAULT 0
-  ,is_delete INTEGER(1) NOT NULL DEFAULT 0
-  ,is_release INTEGER(1) NOT NULL DEFAULT 0
-  ,is_publish INTEGER(1) NOT NULL DEFAULT 0
-  ,is_grant INTEGER(1) NOT NULL DEFAULT 0
-  ,is_transmit INTEGER(1) NOT NULL DEFAULT 0
-  ,PRIMARY KEY (id)
-  ,CONSTRAINT or_fk_acl_groupid
-     FOREIGN KEY (groupid) REFERENCES or_group (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_userid
-     FOREIGN KEY (userid) REFERENCES or_user (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_objectid
-     FOREIGN KEY (objectid) REFERENCES or_object (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,CONSTRAINT or_fk_acl_languageid
-     FOREIGN KEY (languageid) REFERENCES or_language (id)
-     ON DELETE RESTRICT ON UPDATE RESTRICT
-);
-CREATE INDEX or_idx_acl_userid
-          ON or_acl (userid);
-CREATE INDEX or_idx_acl_groupid
-          ON or_acl (groupid);
-CREATE INDEX or_idx_acl_languageid
-          ON or_acl (languageid);
-CREATE INDEX or_idx_acl_objectid
-          ON or_acl (objectid);
-CREATE INDEX or_idx_acl_is_transmit
-          ON or_acl (is_transmit);
-INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1);

	openrat-cms Unnamed repository; edit this file 'description' to name the repository.
	Log \| Files \| Refs

doc/database/sql/create.sh	\|	548	-------------------------------------------------------------------------------
doc/database/sql/mysql/create.sql	\|	393	-------------------------------------------------------------------------------
doc/database/sql/mysql/demo.sql	\|	65	-----------------------------------------------------------------
doc/database/sql/mysql/drop.sql	\|	20	--------------------
doc/database/sql/mysql/truncate.sql	\|	20	--------------------
doc/database/sql/oracle/create.sql	\|	363	-------------------------------------------------------------------------------
doc/database/sql/postgresql/create.sql	\|	393	-------------------------------------------------------------------------------
doc/database/sql/postgresql/drop.sql	\|	20	--------------------
doc/database/sql/postgresql/grant.sql	\|	23	-----------------------
doc/database/sql/sqlite/create.sql	\|	393	-------------------------------------------------------------------------------