Rivendellaudio/docs/tables/importer_lines.txt
Fred Gleason 7c8fbeacb8 2022-10-14 Fred Gleason <fredg@paravelsystems.com>
* Added a 'SERVICES.BYPASS_MODE' field to the database.
	* Added a 'SERVICES.MUS_TRANS_TYPE_OFFSET' field to the database.
	* Added a 'SERVICES.MUS_TRANS_TYPE_LENGTH' field to the database.
	* Added a 'SERVICES.MUS_TIME_TYPE_OFFSET' field to the database.
	* Added a 'SERVICES.MUS_TIME_TYPE_LENGTH' field to the database.
	* Added a 'IMPORT_TEMPLATES.TRANS_TYPE_OFFSET' field to the database.
	* Added a 'IMPORT_TEMPLATES.TRANS_TYPE_LENGTH' field to the database.
	* Added a 'IMPORT_TEMPLATES.TIME_TYPE_OFFSET' field to the database.
	* Added a 'IMPORT_TEMPLATES.TIME_TYPE_LENGTH' field to the database.
	* Added a 'IMPORTER_LINES.TRANS_TYPE' field to the database.
	* Added a 'IMPORTER_LINES.TIME_TYPE' field to the database.
	* Added a 'IMPORTER_LINES.GRACE_TIME' field to the database.
	* Incremented the database schema to 363.
	* Added a 'Bypass Grid Processing' dropdown to the 'Edit Service'
	dialog in rdadmin(1).
	* Added 'Transition Type' and 'Time Type' parameters to the music
	import parameters in the 'Edit Service' dialog in rdadmin(1).

Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
2022-10-14 18:45:38 -04:00

29 lines
1.1 KiB
Plaintext

IMPORTER_LINES Layout for Rivendell
The IMPORTER_LINES table holds ephemeral data use for log
importation.
FIELD NAME TYPE REMARKS
----------------------------------------------------------------
ID int(10) unsigned Primary key, auto increment
STATION_NAME varchar(64) From STATIONS.NAME
PROCESS_ID int(10) unsigned
FILE_LINE int(10) unsigned
LINE_ID int(10) unsigned
TYPE int(10) unsigned RDLogLine::Type
START_HOUR int(11) signed
START_SECS int(11) signed
CART_NUMBER int(10) unsigned
TITLE varchar(191)
LENGTH int(11) signed
TRANS_TYPE int(11) signed RDLogLine::TransType
TIME_TYPE int(11) signed RDLogLine::TimeType
GRACE_TIME int(11) signed
EXT_DATA varchar(32)
EXT_EVENT_ID varchar(32)
EXT_ANNC_TYPE varchar(8)
EXT_CART_NAME varchar(32)
LINK_START_TIME time
LINK_LENGTH int(11)
EVENT_USED enum('N','Y')