Changeset 20516

Timestamp:

03/02/10 08:28:43 (5 months ago)

Author:

nilesh

Message:

data base changes for implementing schedule configuration for warning messages and work capture to an un-assigned task.

Files:

• trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/schedule.bdy (added)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/schedule.spc (added)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/prm_db_patch_9.2.0.sql (modified) (2 diffs)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/tables/alter_pn_plan.sql (added)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/update_system_properties.sql (modified) (1 diff)

trunk/core/db/oracle/create-scripts/versions/9.2.0/prm_db_patch_9.2.0.sql

@@ -74 +74 @@
-COMMIT;
-
+PROMPT Altering pn_plan table
+@versions/9.2.0/tables/alter_pn_plan.sql
+COMMIT;
+
-PROMPT ================================================================================
-PROMPT == Packages
@@ -86 +90 @@
-@versions/9.2.0/packages/methodology.spc
-@versions/9.2.0/packages/methodology.bdy
+COMMIT;
+
+PROMPT Executing schedule package
+@versions/9.2.0/packages/schedule.spc
+@versions/9.2.0/packages/schedule.bdy
-COMMIT;
-

trunk/core/db/oracle/create-scripts/versions/9.2.0/update_system_properties.sql

@@ -1329 +1329 @@
-values (2000, 'en', 'text', 'prm.schedule.taskedit.warning.warning.title', 'Workplan Warning', 'A', 0, 1, null);
-
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.inlineeditwarning.label', 'Enable inline editing warning message', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.unassignedworkcapture.label', 'Enable Un-assigned task work capture', 'A', 0, 1, null);
+
-
-prompt Enabling foreign key constraints for PN_PROPERTY...