Changeset 20371

Timestamp:

02/04/10 10:08:58 (3 years ago)

Author:

ritesh

Message:

• changes for adding new tokens.

File:

• 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/update_system_properties.sql

@@ -1044 +1044 @@
 
 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', 'boolean', 'prm.global.view.visibility.isenabled', '1', 'A', 0, 0, null);
+values (2000, 'en', 'boolean', 'prm.global.view.visibility.isenabled', '1', 'A', 1, 0, null);
+
+update pn_property p set
+          p.property_value = 'Customer'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.properties.sponsor.label';
+
+update pn_property p set
+          p.property_value = 'Priority'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.properties.priority.label';
+
+update pn_property p set
+          p.property_value = 'Risk Rating'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.properties.risk.label';
+
+update pn_property p set
+          p.property_value = 'Budgeted Total Cost'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.properties.budgetedtotalcost.label';
+
+update pn_property p set
+          p.property_value = 'Budgeted Total Cost Currency'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.portfolio.finder.column.budgetedtotalcostcurrency';
+
+update pn_property p set
+          p.property_value = 'Current Estimated Total Cost'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.properties.currentestimatedtotalcost.label';
+
+update pn_property p set
+          p.property_value = 'Actual Cost To Date'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.properties.actualcosttodate.label';    
+
+update pn_property p set
+          p.property_value = 'Estimated ROI'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.properties.estimatedroi.label';    
+
+update pn_property p set
+          p.property_value = 'Cost Center'
+where 
+          p.context_id = 2000 and
+          p.language = 'en' and
+      p.property = 'prm.project.properties.costcenter.label'; 
+  
+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.project.portfolio.error.viewmodified.message', 'Current view has been changed', '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.project.portfolio.manageview.deletionnotallowed.message', 'Sorry! You do not have permission to delete this view', '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.project.portfolio.manageview.error.viewnotavailabletodelete.message', 'Shared views are not available in this business to delete', '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.project.portfolio.manageview.deleteview.label', 'Delete View', '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.project.portfolio.column.templateapplied.lable', 'Template Applied', 'A', 0, 1, null);
 
 prompt Enabling foreign key constraints for PN_PROPERTY...