Changes between Version 2 and Version 3 of ippToPspsSchemaChangePlan201207

Timestamp:

Aug 1, 2012, 4:48:18 PM (14 years ago)

Author:

chenx

Comment:

--

ippToPspsSchemaChangePlan201207

@@ -77 +77 @@
   no Object found.
 
-- ''' Conclusion: The only changed places are in ODM\Workflow and psps_schema: ''' [[br]]
-  psps_schema\PanSTARRS.Testing.Common.sql [[br]]
-  psps_schema\20Q\The20Queries_4Pan-rev-2012-7-31-Zones.sql [[br]]
+- ''' Conclusion: The places to change are in ODM\Workflow and psps_schema: ''' [[br]]
+  psps_schema\PanSTARRS.Testing.Common.sql - change testing script [[br]]
+  psps_schema\20Q\The20Queries_4Pan-rev-2012-7-31-Zones.sql - change script to create table Object [[br]]
 
-  ODM\Workflows\Scripts\Admin\WMD.Reference.Scripts.OB.sql [[br]]
-  ODM\Workflows\Scripts\Admin\WMD.Reference.Scripts.ST.sql [[br]]
-  ODM\Workflows\Scripts\Admin\WMD.Reference.Scripts.P2.sql [[br]]
+  ODM\Workflows\Scripts\Admin\WMD.Reference.Scripts.OB.sql - change script to create table Object [[br]]
+  ODM\Workflows\Scripts\Admin\WMD.Reference.Scripts.ST.sql - change script to create table Object [[br]]
+  ODM\Workflows\Scripts\Admin\WMD.Reference.Scripts.P2.sql - change script to create table Object [[br]]
 
-  ODM\Workflows\Scripts\Admin\WMD.Reference.sql [[br]]
+  ODM\Workflows\Scripts\Admin\WMD.Reference.sql - change script to make table Reference.ColumnValidation [[br]]
 
-  ODM\Workflows\Scripts\LoadMerge\Load.PanSTARRS.Workflow.Common.State.sql
+  ODM\Workflows\Scripts\LoadMerge\Load.PanSTARRS.Workflow.Common.State.sql - change script to make stored procedure PanSTARRS_Workflow_Common_State.LoadObject_LoadDerivedTables_OB.
 
 ''' 2. Change of database '''
 
-''' These database objects should be changed: '''
+''' Conclusion: These database objects should be changed: '''
 
       - Stored procedure  PanSTARRS_Workflow_Common_State.LoadObject_LoadDerivedTables_OB [[br]]