Annexes

<< Click to Display Table of Contents >>

Navigation:  Technical Informations > ABC8 Database Structure >

Annexes

Updates

This section describe updates from database version 8.0 and version 8.2.

 

Deleted logs

Table T_AIRLOG

 

Added

Table T_ACTIVITY_CONF

Table T_ACTIVITY

T_AUDIO_FORMAT:XML_FORMAT

T_AUDIO_FORMAT:XML_TYPE_FORMAT

Used by MediaAssist.

T_COMPONENT:DEFAULT_VALUE

Used by TabEditor

T_CONF_VALUE :GUID_CONF

Used by  sql replication

T_FED_EXCEPTION_DAY: GUID_CHANNEL

Used by Federall.

T_FED_LOG :RO_ID

Used by Federall.

T_FED_SCREEN: RO_ID

T_FED_SCREEN: STORY_ID

T_FED_SCREEN: GUID_ITEM

Used by Federall.

T_ITEM : STRING_11 à T_ITEM : STRING_20

T_ITEM:OBJ_ID

T_ITEM:TIMEZONE

Used by RadioAssist.

T_ITEM_SYNC

Used by NewsLink v3.

T_LOC_GROUPS

T_LOC_GROUPS_STATIONS

T_LOC_GROUPSTATION_PROG

T_LOC_SCHEDULES

T_LOC_STATIONS

T_LOC_TEMPLATES

T_LOC_TIMESLOT

T_LOC_TIMESLOT_ITEMS

Used by LocAdmin of RadioAssist.

T_REMOTEDB :CONNECTION_TYPE

T_REMOTEDB :EXT_ID

T_REMOTEDB :LAUNCHABLE

Used by RadioAssist Setup.

T_TAB: ICON_BASE64

Used by TabEditor.

T_ADGROUPMAPPING

Used by TabEditor.

T_ADGROUPMAPPING :GROUP_SID

T_ADGROUPMAPPING :GROUP_GUID

Used by Administrator.

T_ASSET

T_BASKET

T_ACTIVITY :IS_ACTIVITY_READ

Used by NWE.

T_BASKET :GUID_WORKFLOW

Used by MediaAssist.

T_EXPORT_XSLT

T_EXPORT_TARGET

T_EXPORT_PROFILE

Used by MediaAssist.

T_RTF : EXT_RUN_ID

T_RTF : MOS_ITEM_ID

T_LAST_USER_CHOICE :ORDER_TAB

T_LAST_USER_CHOICE :HIDDEN_TAB

Used by RadioAssist..

T_Playout_Ressources

T_FLAG

T_PLAYOUTRESSOURCES

Used by TabEditor.

T_CONF_VALUES : GUID_CONFIG

Becomes primary key

 

Modification

T_EDIT :LIST_FADE

T_EDIT :PARAMS_CLIP

T_FED_EMISSION:ASSOCIATED_FILES        

T_FED_EMISSION:GUID_IMPORT

T_FED_EMISSION:GUID_EVENT_START        

T_FED_EMISSION:GUID_EVENT_END

T_FED_EMISSION:PRESENTATION

T_FED_EMISSION:INTERVENANTS        

T_FED_EMISSION:EQUIPE

T_FED_EMISSION:CHANNELS

T_FED_EMISSION:DESCRIPTION_1

T_FED_EMISSION:DESCRIPTION_2

T_FED_EMISSION:DESCRIPTION_3

T_FED_IMPORT:DATA

T_FED_RUN:LIST_FADE

T_FED_RUN:ASSOCIATED_FILES

T_FED_RUN:NUMREF1

T_FED_RUN:NUMREF2

T_FED_RUN:NUMREF3

T_FED_RUN:NUMREF4

T_FED_RUN:NUMREF5

T_FED_RUN:NUMREF6

T_FED_SCREEN: GUID_EVENT_START

T_FED_SCREEN: GUID_EVENT_END

T_FED_SCREEN:ASSOCIATED_FILES

T_GEST_CART:GUID_GESTCART

T_ITEM:ITEM_REMARKS

T_ITEM:LIST_MARK

T_RTF:TEXT_HEAD

T_RTF:TEXT_BODY

T_RTF:TEXT_FOOT

T_TAB : DEFAULT_REQUEST

T_TAB :WRITE_REQUEST

T_TAB:ICON