Changeset 20542

Show
Ignore:
Timestamp:
03/09/10 00:22:11 (5 months ago)
Author:
ritesh
Message:

- new database tables for charge-code.
- and some other database changes

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

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

    r20535 r20542  
    8282COMMIT; 
    8383 
     84PROMPT creating pn_charge_code table 
     85@versions/9.2.0/tables/create_pn_charge_code.sql 
     86COMMIT; 
     87 
     88PROMPT creating pn_object_has_charge_code table 
     89@versions/9.2.0/tables/create_pn_object_has_charge_code.sql 
     90COMMIT; 
     91 
     92PROMPT insert pn_object_type 
     93@versions/9.2.0/tables/insert_pn_object_type.sql 
     94COMMIT; 
     95 
    8496PROMPT ================================================================================ 
    8597PROMPT == Packages 

  • trunk/core/db/oracle/create-scripts/versions/9.2.0/synonyms/create_private_synonyms.sql

    r20358 r20542  
    77PROMPT creating synonym for PN_BUSINESS_HAS_VIEW table. 
    88CREATE OR REPLACE SYNONYM PN_BUSINESS_HAS_VIEW FOR PNET.PN_BUSINESS_HAS_VIEW; 
     9 
     10PROMPT creating synonym for PN_CHARGE_CODE table. 
     11CREATE OR REPLACE SYNONYM PN_CHARGE_CODE FOR PNET.PN_CHARGE_CODE; 
     12 
     13PROMPT creating synonym for PN_OBJECT_HAS_CHARGE_CODE table. 
     14CREATE OR REPLACE SYNONYM PN_OBJECT_HAS_CHARGE_CODE FOR PNET.PN_OBJECT_HAS_CHARGE_CODE;