Changeset 17947

Timestamp:

08/25/08 16:10:11 (3 months ago)

Author:

puno

Message:

Database scripts are fixed. Table creationg moved to update part of scripts.

Files:

• trunk/core/db/oracle/create-scripts/versions/8.5.0/new/synonyms/create_private_table_synonyms.sql (modified) (1 diff)
• trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/data.sql (modified) (2 diffs)
• trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/tables.sql (modified) (2 diffs)
• trunk/core/db/oracle/create-scripts/versions/8.5.0/prm_db_patch_8.5.0.sql (modified) (1 diff)
• trunk/core/db/oracle/create-scripts/versions/8.5.0/tables/cr_pn_project_space_meta_combo.sql (added)

trunk/core/db/oracle/create-scripts/versions/8.5.0/new/synonyms/create_private_table_synonyms.sql

@@ -1019 +1019 @@
-CREATE OR REPLACE SYNONYM TMP_PN_PROPERTY FOR PNET.TMP_PN_PROPERTY;     
-
-
-
+-- 
+-- 

trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/data.sql

@@ -5972 +5972 @@
-alter table PN_NOTIFICATION_OBJECT_TYPE enable constraint NOTIFICATION_OBJECT_TYPE_FK1;
-
+/*
-prompt
-prompt Inserting combo value for project space properties
@@ -5994 +5995 @@
-values (6, 'RD', 'RD');
-
+*/
-prompt 
-prompt Inserting resource module permission to existing users

trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/tables.sql

@@ -7212 +7212 @@
-create index TIMELOG_IDX2 on PN_TIMELOG (OBJECT_ID) TABLESPACE INDEX01;
-
+/*
-prompt
-prompt Creating table PN_PROJECT_SPACE_META_COMBO
@@ -7225 +7226 @@
-alter table PN_PROJECT_SPACE_META_COMBO
-  add constraint PN_PROJECT_SPACE_META_COMBO_PK primary key (PROPERTY_ID, COMBO_VALUE);
+*/

trunk/core/db/oracle/create-scripts/versions/8.5.0/prm_db_patch_8.5.0.sql

@@ -27 +27 @@
-@versions/8.5.0/tables/alter_pn_person_profile.sql
-COMMIT;
+
+PROMPT Creating PN_PROJECT_SPACE_META_COMBO table
+@versions/8.5.0/tables/cr_pn_project_space_meta_combo.sql
+COMMIT;
+
-
-PROMPT ================================================================================