=====================================
Viz Content Pilot DB Schema Changelog
=====================================

5.1.10
======
* Changes to the VCP_Content circumvent a bug in Oracle 10.2.0.4 (# )
* Added two new procedures in vcp_export package to handle insert of element to a concept/variant based on the concept id and not. (#12518)
* vcp_content function GET_MSE_TEMPLATES_BY_EXTID would return in the default variant in the default concept regardless of what variant the exernal_id was put on. Added function GET_MSE_TEMPLATE_BY_EXTID that gets the correct control_scene based on the variants external_id. (#12519)

5.2.0
=====
* Dropped triggers used by the old notifications systems (#8431)
* Forces a change to AQ as the messaging protocol if old variants still used. (#8431)
* Added table SavedAGLS
* Added table Plakat_Data_Thumbnail_Variants
* Added column Custom_Logic(sys.XmlType) to table Generated_Templates
* Added foreign key to t_image_additional_fields field_id -> t_additional_fields.field_id, note this does some cleanup, before creating, when upgrading (#11785)
* Dropped unused AQ Exception Queue (#9515)
* VizAdmin scripts is now moved out of the main scripts and into it's own scripts
* The scripts are no longer meant to be run through sqlplus, only with VCP DBA.

5.3.0
=====
* Restructured the scripts
* Removed all obsolete notification objects in schema(#14268)
* Altered the length of the following columns (#13201)
    VARIANT.NAME VARCHAR2(200 BYTE)
    PLAKAT_INFO.NAVN VARCHAR2(200 BYTE)
    GENERATED_TEMPLATES.NAVN VARCHAR2(200 BYTE)
    KONSEPT.NAVN VARCHAR2(200 BYTE)
    T_PERSON.ETTERNAVN VARCHAR2(200 BYTE)
    T_PERSON.FORNAVN VARCHAR2(200 BYTE)
    T_PERSON.MELLOMNAVN VARCHAR2(200 BYTE)
    T_PERSON.TITTEL VARCHAR2(400 BYTE)
    T_PERSON.TV_NAVN VARCHAR2(400 BYTE)
    T_PERSON.KOMMENTAR VARCHAR2(2000 BYTE)
    T_STILLBILDE.BILDEBESKRIVELSE VARCHAR2(4000 BYTE)
    T_STILLBILDE.LANG_BESKRIVELSE VARCHAR2(4000 BYTE)
    T_EMNE.EMNEORD VARCHAR2(240 BYTE)
    T_EMNE.BESKRIVELSE VARCHAR2(240 BYTE)
	
5.6.0
=====
* Added table search_providers

TRUNK
=====
*