mip/Schema at master - mip

AssociateSchema.sql

Altered install scripts so that UAT and LIVE do not look for the apua.ctl file (this is now handled in seed data directory). Also fixed for ticket #517 AssociateSchema.sql and SetSubstitution.sql scripts so that they only update the current application rather than all the applications in the current workspace.

2008-06-17 15:17:02 +00:00

drop_user_objects.sql

Modify mip_quotation_document and f155.sql to use new signature on

2010-08-10 16:45:56 +00:00

ext_base.pdc

Bulk Load: Latest version of POSTCODES.csv.

2008-02-04 10:49:50 +00:00

ext_caveat.pdc

Bulk Load: Latest version of POSTCODES.csv.

2008-02-04 10:49:50 +00:00

ext_cost.pdc

Initial changes to mip_quotation.pck and mip_bulk_load.pck to support PhaseII purging requirements.

2009-09-04 16:29:42 +00:00

ext_dataitem_role.pdc

Changes to 'mandatory' processing to address #270 . Ext_dataitem_role.pdc and DATAITEM_ROLES referreed to enquiry type 'CAPACITY CHANGE' rather than 'CHANGE CAPACITY' which caused gen_mandatory not to create mandatory conditions for the 'CHANGE CAPACITY' enquiry type.

2008-02-20 10:19:00 +00:00

ext_housing.pdc

Bulk Load: Latest version of POSTCODES.csv.

2008-02-04 10:49:50 +00:00

ext_leadtime.pdc

Bulk Load: Changes to default values for 'unknown' items, inclusion of LeadTimes.csv

2008-02-15 18:01:40 +00:00

ext_meter.pdc

Changes made for bulk load and 'flange size' (MESC_CODE on meters).

2008-02-29 17:27:39 +00:00

ext_module.pdc

Changes made for bulk load and 'flange size' (MESC_CODE on meters).

2008-02-29 17:27:39 +00:00

ext_postcode.pdc

Bulk Load: Latest version of POSTCODES.csv.

2008-02-04 10:49:50 +00:00

gtt_dir_list.pdc

Bulk Load: Latest version of POSTCODES.csv.

2008-02-04 10:49:50 +00:00

InstallAssociateSchema.sql

Changes made for bulk load and 'flange size' (MESC_CODE on meters).

2008-02-29 17:27:39 +00:00

InstallMIP.cmd

New tables:

2007-11-12 12:07:25 +00:00

InstallMIP.sql

Modify mip_quotation_document and f155.sql to use new signature on

2010-08-10 16:45:56 +00:00

InstallSetSubstitution.sql

Addresses #269 , #280 , #306 .

2008-03-04 12:03:03 +00:00

mip.con

Include further error logging (backtrace, call_stack, etc.) to error_logs table through updated cout_err.pck.

2009-09-08 13:16:26 +00:00

mip.ind

Include further error logging (backtrace, call_stack, etc.) to error_logs table through updated cout_err.pck.

2009-09-08 13:16:26 +00:00

mip.sql

Include further error logging (backtrace, call_stack, etc.) to error_logs table through updated cout_err.pck.

2009-09-08 13:16:26 +00:00

mip.sqs

Include further error logging (backtrace, call_stack, etc.) to error_logs table through updated cout_err.pck.

2009-09-08 13:16:26 +00:00

mip.tab

Include further error logging (backtrace, call_stack, etc.) to error_logs table through updated cout_err.pck.

2009-09-08 13:16:26 +00:00

mipDirectories.sql

Modules/mip_helper_special_cases.pck - correction to rule OM-4

2008-01-23 18:24:40 +00:00

mipExtTables.sql

Bulk Load: Changes to default values for 'unknown' items, inclusion of LeadTimes.csv

2008-02-15 18:01:40 +00:00

mipLibraries.sql

Add support for system calls (ticket #77 ).

2008-02-05 10:28:17 +00:00

mipViews.sql

Bulk Load: Changes to default values for 'unknown' items, inclusion of LeadTimes.csv

2008-02-15 18:01:40 +00:00

SetSubstitution.sql

Altered install scripts so that UAT and LIVE do not look for the apua.ctl file (this is now handled in seed data directory). Also fixed for ticket #517 AssociateSchema.sql and SetSubstitution.sql scripts so that they only update the current application rather than all the applications in the current workspace.

2008-06-17 15:17:02 +00:00

UpgradeMIP.sql

Add Upgrade Scripts to convert release 1.0.6 to current version.

2009-10-12 12:05:47 +00:00

V_AICO.vw

Initial changes to mip_quotation.pck and mip_bulk_load.pck to support PhaseII purging requirements.

2009-09-04 16:29:42 +00:00

V_BACO.vw

Schema changes

2007-12-21 11:29:21 +00:00

v_current_contact_mechanisms.vw

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3030 248e525c-4dfb-0310-94bc-949c084e9493

2007-12-19 17:08:09 +00:00

V_CURRENT_DOCUMENT_STATUS.vw

changed view back to use the sequence id to report the most current document status

2008-02-26 13:43:24 +00:00

v_current_enquiry_status.vw

Include missing '/'

2008-02-07 17:09:34 +00:00

V_CURRENT_PARTY_ADDRESSES.vw

Created new view to display the current address for each party in the system.

2007-12-18 17:27:54 +00:00

v_current_quote_status.vw

Include missing '/'

2008-02-07 17:09:34 +00:00

v_enquiry_prty_supp.vw

New views added for new user management screens.

2007-12-11 18:05:45 +00:00

V_HOCO.vw

Schema changes

2007-12-21 11:29:21 +00:00

V_LACO.vw

Add V_LACO.vw - shows labour costs

2008-01-07 17:29:06 +00:00

V_LAST_ENQUIRY_UPDATE.vw

New views added for new user management screens.

2007-12-11 18:05:45 +00:00

V_LATEST_RT_CODE_FOR_ENRO.vw

Scheme Changes:

2007-11-27 11:48:13 +00:00

v_lead_times.vw

Bulk Load: Changes to default values for 'unknown' items, inclusion of LeadTimes.csv

2008-02-15 18:01:40 +00:00

V_MECO.vw

Schema changes

2007-12-21 11:29:21 +00:00

V_MOCO.vw

Schema changes

2007-12-21 11:29:21 +00:00

v_party_addresses.vw

we only need the id of the party in the party_addresses view, not the names username etc.

2007-12-18 15:30:14 +00:00

V_PARTY_RELATIONSHIPS.vw

Scheme Changes:

2007-11-27 11:48:13 +00:00

V_PROFILE_RT_CODE_FOR_ENRO.vw

Scheme Changes:

2007-11-27 11:48:13 +00:00

V_PRTY_ID_FOR_ENQUIRIES.vw

New views added for new user management screens.

2007-12-11 18:05:45 +00:00

V_QUOTE_DETAILS.vw

Initial changes to mip_quotation.pck and mip_bulk_load.pck to support PhaseII purging requirements.

2009-09-04 16:29:42 +00:00

v_supplier_administrators.vw

changed some column names to fit in with the schema.

2007-12-06 16:28:33 +00:00