commit addbaf23d01e973961d1dd415ff63b499e2f834c
parent 9bab6e3636f5a07c620f3c6c0ffcf8b0a74df8a8
Author: dankert <devnull@localhost>
Date: Sat, 20 Feb 2010 01:14:10 +0100
Kompatiblität mit MySql 4.x, Oracle-Besonderheiten: Index-Namen max. 30 Zeichen, Text-Spalten nullable.
Diffstat:
3 files changed, 152 insertions(+), 129 deletions(-)
diff --git a/doc/database/sql/create.sh b/doc/database/sql/create.sh
@@ -17,6 +17,7 @@ type=
db=
db_fc=0
table=
+cnt=0
# Creating a new table
# param 1: table name
@@ -36,7 +37,8 @@ close_table()
case "$type" in
mysql)
- echo -n " ENGINE $mysql_engine" >> $outfile
+ #echo -n " ENGINE=$mysql_engine" >> $outfile
+ echo -n " TYPE=$mysql_engine" >> $outfile
;;
*)
;;
@@ -90,7 +92,7 @@ column()
echo -n "MEDIUMTEXT" >> $outfile
elif [ "$type" == "oracle" ]; then
echo -n "CLOB" >> $outfile
- elif [ "$type"=="postgresql" ]; then
+ elif [ "$type" == "postgresql" ]; then
echo -n "TEXT" >> $outfile
else
echo -n "TEXT" >> $outfile
@@ -99,7 +101,11 @@ column()
BLOB)
if [ "$type" == "mysql" ]; then
echo -n "MEDIUMBLOB" >> $outfile
- elif [ "$type"=="postgresql" ]; then
+ 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
@@ -125,7 +131,8 @@ column()
fi
# Nullable?
- if [ "$5" == "J" -o "$5" == "1" ]; then
+ # 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
@@ -163,7 +170,12 @@ primary_key()
# param 1: name of index column. Seperate multiple columns with ','
unique_index()
{
- echo "CREATE UNIQUE INDEX ${prefix}uidx_${table}${suffix}_`echo $1|tr ',' '_'`" >> $outfile
+ 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
}
@@ -171,7 +183,12 @@ unique_index()
# param 1: name of index column. Seperate multiple columns with ','
index()
{
- echo "CREATE INDEX ${prefix}idx_${table}${suffix}_`echo $1|tr ',' '_'`" >> $outfile
+ 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
}
@@ -181,9 +198,15 @@ index()
# param 3: target column name
constraint()
{
- echo " ,CONSTRAINT ${prefix}fk_${table}${suffix}_$1" >> $outfile
+ 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 lucky its the default.
+ # 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
diff --git a/doc/database/sql/mysql/create.sql b/doc/database/sql/mysql/create.sql
@@ -11,7 +11,7 @@ CREATE TABLE or_project(
,content_negotiation TINYINT(1) NOT NULL DEFAULT 0
,cut_index TINYINT(1) NOT NULL DEFAULT 0
,PRIMARY KEY (id)
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE UNIQUE INDEX or_uidx_project_name
ON or_project (name);
@@ -28,7 +28,7 @@ CREATE TABLE or_user(
,style VARCHAR(64) NOT NULL
,is_admin TINYINT(1) NOT NULL DEFAULT 0
,PRIMARY KEY (id)
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE UNIQUE INDEX or_uidx_user_name
ON or_user (name);
@@ -37,7 +37,7 @@ CREATE TABLE or_group(
id INT NOT NULL
,name VARCHAR(100) NOT NULL
,PRIMARY KEY (id)
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE UNIQUE INDEX or_uidx_group_name
ON or_group (name);
@@ -66,7 +66,7 @@ CREATE TABLE or_object(
,CONSTRAINT or_fk_object_create_userid
FOREIGN KEY (create_userid) REFERENCES or_user (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_object_parentid
ON or_object (parentid);
CREATE INDEX or_idx_object_projectid
@@ -97,7 +97,7 @@ CREATE TABLE or_template(
,CONSTRAINT or_fk_template_projectid
FOREIGN KEY (projectid) REFERENCES or_project (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_template_projectid
ON or_template (projectid);
CREATE INDEX or_idx_template_name
@@ -116,7 +116,7 @@ CREATE TABLE or_language(
,CONSTRAINT or_fk_language_projectid
FOREIGN KEY (projectid) REFERENCES or_project (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE UNIQUE INDEX or_uidx_language_projectid_isocode
ON or_language (projectid,isocode);
@@ -132,7 +132,7 @@ CREATE TABLE or_page(
,CONSTRAINT or_fk_page_objectid
FOREIGN KEY (objectid) REFERENCES or_object (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE UNIQUE INDEX or_uidx_page_objectid
ON or_page (objectid);
CREATE INDEX or_idx_page_templateid
@@ -149,7 +149,7 @@ CREATE TABLE or_projectmodel(
,CONSTRAINT or_fk_projectmodel_projectid
FOREIGN KEY (projectid) REFERENCES or_project (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_projectmodel_projectid
ON or_projectmodel (projectid);
CREATE UNIQUE INDEX or_uidx_projectmodel_projectid_name
@@ -186,7 +186,7 @@ CREATE TABLE or_element(
,CONSTRAINT or_fk_element_templateid
FOREIGN KEY (templateid) REFERENCES or_template (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_element_templateid
ON or_element (templateid);
CREATE INDEX or_idx_element_name
@@ -205,7 +205,7 @@ CREATE TABLE or_file(
,CONSTRAINT or_fk_file_objectid
FOREIGN KEY (objectid) REFERENCES or_object (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE UNIQUE INDEX or_uidx_file_objectid
ON or_file (objectid);
@@ -217,7 +217,7 @@ CREATE TABLE or_folder(
,CONSTRAINT or_fk_folder_objectid
FOREIGN KEY (objectid) REFERENCES or_object (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE UNIQUE INDEX or_uidx_folder_objectid
ON or_folder (objectid);
@@ -234,7 +234,7 @@ CREATE TABLE or_link(
,CONSTRAINT or_fk_link_link_objectid
FOREIGN KEY (link_objectid) REFERENCES or_object (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE UNIQUE INDEX or_uidx_link_objectid
ON or_link (objectid);
CREATE INDEX or_idx_link_link_objectid
@@ -254,7 +254,7 @@ CREATE TABLE or_name(
,CONSTRAINT or_fk_name_languageid
FOREIGN KEY (languageid) REFERENCES or_language (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_name_objectid
ON or_name (objectid);
CREATE INDEX or_idx_name_languageid
@@ -276,7 +276,7 @@ CREATE TABLE or_templatemodel(
,CONSTRAINT or_fk_templatemodel_projectmodelid
FOREIGN KEY (projectmodelid) REFERENCES or_projectmodel (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_templatemodel_templateid
ON or_templatemodel (templateid);
CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_extension
@@ -296,7 +296,7 @@ CREATE TABLE or_usergroup(
,CONSTRAINT or_fk_usergroup_userid
FOREIGN KEY (userid) REFERENCES or_user (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_usergroup_groupid
ON or_usergroup (groupid);
CREATE INDEX or_idx_usergroup_userid
@@ -334,7 +334,7 @@ CREATE TABLE or_value(
,CONSTRAINT or_fk_value_linkobjectid
FOREIGN KEY (linkobjectid) REFERENCES or_object (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_value_pageid
ON or_value (pageid);
CREATE INDEX or_idx_value_languageid
@@ -379,7 +379,7 @@ CREATE TABLE or_acl(
,CONSTRAINT or_fk_acl_languageid
FOREIGN KEY (languageid) REFERENCES or_language (id)
ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE InnoDB;
+) TYPE=InnoDB;
CREATE INDEX or_idx_acl_userid
ON or_acl (userid);
CREATE INDEX or_idx_acl_groupid
diff --git a/doc/database/sql/oracle/create.sql b/doc/database/sql/oracle/create.sql
@@ -3,42 +3,42 @@
-- Table project
CREATE TABLE or_project(
"ID" NUMBER NOT NULL
- ,"NAME" VARCHAR(128) NOT NULL
- ,"TARGET_DIR" VARCHAR(255) NOT NULL
- ,"FTP_URL" VARCHAR(255) 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) 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_project_name
+CREATE UNIQUE INDEX or_uidx_1
ON or_project (name);
-- Table user
CREATE TABLE or_user(
"ID" NUMBER 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
+ ,"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_user_name
+CREATE UNIQUE INDEX or_uidx_2
ON or_user (name);
-- Table group
CREATE TABLE or_group(
"ID" NUMBER NOT NULL
- ,"NAME" VARCHAR(100) NOT NULL
+ ,"NAME" VARCHAR(100) NULL
,PRIMARY KEY (id)
);
-CREATE UNIQUE INDEX or_uidx_group_name
+CREATE UNIQUE INDEX or_uidx_3
ON or_group (name);
-- Table object
@@ -46,7 +46,7 @@ CREATE TABLE or_object(
"ID" NUMBER NOT NULL
,"PARENTID" NUMBER NULL
,"PROJECTID" NUMBER DEFAULT 0 NOT NULL
- ,"FILENAME" VARCHAR(255) 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
@@ -57,62 +57,62 @@ CREATE TABLE or_object(
,"IS_PAGE" NUMBER(1) NOT NULL
,"IS_LINK" NUMBER(1) NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_object_projectid
+ ,CONSTRAINT or_fk_4
FOREIGN KEY (projectid) REFERENCES or_project (id)
- ,CONSTRAINT or_fk_object_lastchange_userid
+ ,CONSTRAINT or_fk_5
FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
- ,CONSTRAINT or_fk_object_create_userid
+ ,CONSTRAINT or_fk_6
FOREIGN KEY (create_userid) REFERENCES or_user (id)
);
-CREATE INDEX or_idx_object_parentid
+CREATE INDEX or_idx_7
ON or_object (parentid);
-CREATE INDEX or_idx_object_projectid
+CREATE INDEX or_idx_8
ON or_object (projectid);
-CREATE INDEX or_idx_object_is_folder
+CREATE INDEX or_idx_9
ON or_object (is_folder);
-CREATE INDEX or_idx_object_is_file
+CREATE INDEX or_idx_10
ON or_object (is_file);
-CREATE INDEX or_idx_object_is_page
+CREATE INDEX or_idx_11
ON or_object (is_page);
-CREATE INDEX or_idx_object_is_link
+CREATE INDEX or_idx_12
ON or_object (is_link);
-CREATE INDEX or_idx_object_orderid
+CREATE INDEX or_idx_13
ON or_object (orderid);
-CREATE INDEX or_idx_object_create_userid
+CREATE INDEX or_idx_14
ON or_object (create_userid);
-CREATE INDEX or_idx_object_lastchange_userid
+CREATE INDEX or_idx_15
ON or_object (lastchange_userid);
-CREATE UNIQUE INDEX or_uidx_object_parentid_filename
+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) NOT NULL
+ ,"NAME" VARCHAR(50) NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_template_projectid
+ ,CONSTRAINT or_fk_17
FOREIGN KEY (projectid) REFERENCES or_project (id)
);
-CREATE INDEX or_idx_template_projectid
+CREATE INDEX or_idx_18
ON or_template (projectid);
-CREATE INDEX or_idx_template_name
+CREATE INDEX or_idx_19
ON or_template (name);
-CREATE UNIQUE INDEX or_uidx_template_projectid_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) NOT NULL
- ,"NAME" VARCHAR(50) NOT NULL
+ ,"ISOCODE" VARCHAR(10) NULL
+ ,"NAME" VARCHAR(50) NULL
,"IS_DEFAULT" NUMBER(1) DEFAULT 0 NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_language_projectid
+ ,CONSTRAINT or_fk_21
FOREIGN KEY (projectid) REFERENCES or_project (id)
);
-CREATE UNIQUE INDEX or_uidx_language_projectid_isocode
+CREATE UNIQUE INDEX or_uidx_22
ON or_language (projectid,isocode);
-- Table page
@@ -121,39 +121,39 @@ CREATE TABLE or_page(
,"OBJECTID" NUMBER DEFAULT 0 NOT NULL
,"TEMPLATEID" NUMBER DEFAULT 0 NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_page_templateid
+ ,CONSTRAINT or_fk_23
FOREIGN KEY (templateid) REFERENCES or_template (id)
- ,CONSTRAINT or_fk_page_objectid
+ ,CONSTRAINT or_fk_24
FOREIGN KEY (objectid) REFERENCES or_object (id)
);
-CREATE UNIQUE INDEX or_uidx_page_objectid
+CREATE UNIQUE INDEX or_uidx_25
ON or_page (objectid);
-CREATE INDEX or_idx_page_templateid
+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) NOT NULL
+ ,"NAME" VARCHAR(50) NULL
,"EXTENSION" VARCHAR(10) NULL
,"IS_DEFAULT" NUMBER(1) DEFAULT 0 NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_projectmodel_projectid
+ ,CONSTRAINT or_fk_27
FOREIGN KEY (projectid) REFERENCES or_project (id)
);
-CREATE INDEX or_idx_projectmodel_projectid
+CREATE INDEX or_idx_28
ON or_projectmodel (projectid);
-CREATE UNIQUE INDEX or_uidx_projectmodel_projectid_name
+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) NOT NULL
- ,"DESCR" VARCHAR(255) NOT NULL
- ,"TYPE" VARCHAR(20) 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
@@ -169,32 +169,32 @@ CREATE TABLE or_element(
,"FOLDEROBJECTID" NUMBER NULL
,"DEFAULT_OBJECTID" NUMBER NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_element_default_objectid
+ ,CONSTRAINT or_fk_30
FOREIGN KEY (default_objectid) REFERENCES or_object (id)
- ,CONSTRAINT or_fk_element_folderobjectid
+ ,CONSTRAINT or_fk_31
FOREIGN KEY (folderobjectid) REFERENCES or_object (id)
- ,CONSTRAINT or_fk_element_templateid
+ ,CONSTRAINT or_fk_32
FOREIGN KEY (templateid) REFERENCES or_template (id)
);
-CREATE INDEX or_idx_element_templateid
+CREATE INDEX or_idx_33
ON or_element (templateid);
-CREATE INDEX or_idx_element_name
+CREATE INDEX or_idx_34
ON or_element (name);
-CREATE UNIQUE INDEX or_uidx_element_templateid_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) NOT NULL
+ ,"EXTENSION" VARCHAR(10) NULL
,"SIZE" NUMBER DEFAULT 0 NOT NULL
- ,"VALUE" TEXT NOT NULL
+ ,"VALUE" CLOB NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_file_objectid
+ ,CONSTRAINT or_fk_36
FOREIGN KEY (objectid) REFERENCES or_object (id)
);
-CREATE UNIQUE INDEX or_uidx_file_objectid
+CREATE UNIQUE INDEX or_uidx_37
ON or_file (objectid);
-- Table folder
@@ -202,10 +202,10 @@ CREATE TABLE or_folder(
"ID" NUMBER NOT NULL
,"OBJECTID" NUMBER DEFAULT 0 NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_folder_objectid
+ ,CONSTRAINT or_fk_38
FOREIGN KEY (objectid) REFERENCES or_object (id)
);
-CREATE UNIQUE INDEX or_uidx_folder_objectid
+CREATE UNIQUE INDEX or_uidx_39
ON or_folder (objectid);
-- Table link
@@ -215,34 +215,34 @@ CREATE TABLE or_link(
,"LINK_OBJECTID" NUMBER NULL
,"URL" VARCHAR(255) NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_link_objectid
+ ,CONSTRAINT or_fk_40
FOREIGN KEY (objectid) REFERENCES or_object (id)
- ,CONSTRAINT or_fk_link_link_objectid
+ ,CONSTRAINT or_fk_41
FOREIGN KEY (link_objectid) REFERENCES or_object (id)
);
-CREATE UNIQUE INDEX or_uidx_link_objectid
+CREATE UNIQUE INDEX or_uidx_42
ON or_link (objectid);
-CREATE INDEX or_idx_link_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) NOT NULL
- ,"DESCR" VARCHAR(255) NOT NULL
+ ,"NAME" VARCHAR(255) NULL
+ ,"DESCR" VARCHAR(255) NULL
,"LANGUAGEID" NUMBER DEFAULT 0 NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_name_objectid
+ ,CONSTRAINT or_fk_44
FOREIGN KEY (objectid) REFERENCES or_object (id)
- ,CONSTRAINT or_fk_name_languageid
+ ,CONSTRAINT or_fk_45
FOREIGN KEY (languageid) REFERENCES or_language (id)
);
-CREATE INDEX or_idx_name_objectid
+CREATE INDEX or_idx_46
ON or_name (objectid);
-CREATE INDEX or_idx_name_languageid
+CREATE INDEX or_idx_47
ON or_name (languageid);
-CREATE UNIQUE INDEX or_uidx_name_objectid_languageid
+CREATE UNIQUE INDEX or_uidx_48
ON or_name (objectid,languageid);
-- Table templatemodel
@@ -251,18 +251,18 @@ CREATE TABLE or_templatemodel(
,"TEMPLATEID" NUMBER DEFAULT 0 NOT NULL
,"PROJECTMODELID" NUMBER DEFAULT 0 NOT NULL
,"EXTENSION" VARCHAR(10) NULL
- ,"TEXT" CLOB NOT NULL
+ ,"TEXT" CLOB NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_templatemodel_templateid
+ ,CONSTRAINT or_fk_49
FOREIGN KEY (templateid) REFERENCES or_template (id)
- ,CONSTRAINT or_fk_templatemodel_projectmodelid
+ ,CONSTRAINT or_fk_50
FOREIGN KEY (projectmodelid) REFERENCES or_projectmodel (id)
);
-CREATE INDEX or_idx_templatemodel_templateid
+CREATE INDEX or_idx_51
ON or_templatemodel (templateid);
-CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_extension
+CREATE UNIQUE INDEX or_uidx_52
ON or_templatemodel (templateid,extension);
-CREATE UNIQUE INDEX or_uidx_templatemodel_templateid_projectmodelid
+CREATE UNIQUE INDEX or_uidx_53
ON or_templatemodel (templateid,projectmodelid);
-- Table usergroup
@@ -271,16 +271,16 @@ CREATE TABLE or_usergroup(
,"USERID" NUMBER NOT NULL
,"GROUPID" NUMBER NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_usergroup_groupid
+ ,CONSTRAINT or_fk_54
FOREIGN KEY (groupid) REFERENCES or_group (id)
- ,CONSTRAINT or_fk_usergroup_userid
+ ,CONSTRAINT or_fk_55
FOREIGN KEY (userid) REFERENCES or_user (id)
);
-CREATE INDEX or_idx_usergroup_groupid
+CREATE INDEX or_idx_56
ON or_usergroup (groupid);
-CREATE INDEX or_idx_usergroup_userid
+CREATE INDEX or_idx_57
ON or_usergroup (userid);
-CREATE UNIQUE INDEX or_uidx_usergroup_userid_groupid
+CREATE UNIQUE INDEX or_uidx_58
ON or_usergroup (userid,groupid);
-- Table value
@@ -298,28 +298,28 @@ CREATE TABLE or_value(
,"LASTCHANGE_DATE" NUMBER DEFAULT 0 NOT NULL
,"LASTCHANGE_USERID" NUMBER NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_value_pageid
+ ,CONSTRAINT or_fk_59
FOREIGN KEY (pageid) REFERENCES or_page (id)
- ,CONSTRAINT or_fk_value_elementid
+ ,CONSTRAINT or_fk_60
FOREIGN KEY (elementid) REFERENCES or_element (id)
- ,CONSTRAINT or_fk_value_languageid
+ ,CONSTRAINT or_fk_61
FOREIGN KEY (languageid) REFERENCES or_language (id)
- ,CONSTRAINT or_fk_value_lastchange_userid
+ ,CONSTRAINT or_fk_62
FOREIGN KEY (lastchange_userid) REFERENCES or_user (id)
- ,CONSTRAINT or_fk_value_linkobjectid
+ ,CONSTRAINT or_fk_63
FOREIGN KEY (linkobjectid) REFERENCES or_object (id)
);
-CREATE INDEX or_idx_value_pageid
+CREATE INDEX or_idx_64
ON or_value (pageid);
-CREATE INDEX or_idx_value_languageid
+CREATE INDEX or_idx_65
ON or_value (languageid);
-CREATE INDEX or_idx_value_elementid
+CREATE INDEX or_idx_66
ON or_value (elementid);
-CREATE INDEX or_idx_value_active
+CREATE INDEX or_idx_67
ON or_value (active);
-CREATE INDEX or_idx_value_lastchange_date
+CREATE INDEX or_idx_68
ON or_value (lastchange_date);
-CREATE INDEX or_idx_value_publish
+CREATE INDEX or_idx_69
ON or_value (publish);
-- Table acl
@@ -341,23 +341,23 @@ CREATE TABLE or_acl(
,"IS_GRANT" NUMBER(1) DEFAULT 0 NOT NULL
,"IS_TRANSMIT" NUMBER(1) DEFAULT 0 NOT NULL
,PRIMARY KEY (id)
- ,CONSTRAINT or_fk_acl_groupid
+ ,CONSTRAINT or_fk_70
FOREIGN KEY (groupid) REFERENCES or_group (id)
- ,CONSTRAINT or_fk_acl_userid
+ ,CONSTRAINT or_fk_71
FOREIGN KEY (userid) REFERENCES or_user (id)
- ,CONSTRAINT or_fk_acl_objectid
+ ,CONSTRAINT or_fk_72
FOREIGN KEY (objectid) REFERENCES or_object (id)
- ,CONSTRAINT or_fk_acl_languageid
+ ,CONSTRAINT or_fk_73
FOREIGN KEY (languageid) REFERENCES or_language (id)
);
-CREATE INDEX or_idx_acl_userid
+CREATE INDEX or_idx_74
ON or_acl (userid);
-CREATE INDEX or_idx_acl_groupid
+CREATE INDEX or_idx_75
ON or_acl (groupid);
-CREATE INDEX or_idx_acl_languageid
+CREATE INDEX or_idx_76
ON or_acl (languageid);
-CREATE INDEX or_idx_acl_objectid
+CREATE INDEX or_idx_77
ON or_acl (objectid);
-CREATE INDEX or_idx_acl_is_transmit
+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)