====MySQL/MariaDB Events====

===Information===

Reads entries from a MySQL/MariaDB database table as events.

^Driver Info^Detail^
|Driver Type:|**Event**|
|Platforms:|**All**|

===Driver Settings===

^Option^Description^
|Host|The IP or DNS name of your MySQL/MariaDB server|
|Port|The port number the server is running on|
|Database|The name of the database|
|Username|The username to sign into the database server|
|Password|The password to go along with the username|
|Table|The name of the table to read events from|
|Name Field|The name of the field that contains the event name|
|Start Field|The name of the field that contains the start date/time|
|End Field|The name of the field that contains the end date/time|
|Duration Field|The name of the field that contains the duration of the event|
|Prefix|A prefix to add to the name of the event|
|Timezone|The timezone for the dates in the database|

===Notes===

The driver queries the **table**, and delivers a list of events based on the **Name**, **Start** and (optionally) either the **End** or **Duration** fields.

Both **End** and **Duration** may be empty. The behaviour of the driver will vary.

^Start^End^Duration^Outcome^
|Y|N|N|Event will be instantanious|
|Y|Y|N|Event will start at 'start' and finish at 'end'|
|Y|N|Y|Event will start at 'start' and end 'duration' seconds later|
|Y|Y|Y|Event will start at 'start' and finish at 'end'. Duration is ignored|