[MySQL] Adding New Preference Values to User Table if Not Exist

• Kimai

  8 581 1.3 PHP

  Discontinued Kimai v1 open source time-tracking - please switch to Kimai v2

  

I 'm working with the opensource Kimai time tracking software, there is a table called kimai2_user_preferences that stores user preferences in a key/value pair. I'd ideally like to create four value/key pairs when a new row is added to the kimai2_users table in order to set default required values used by a plugin. I haven't put thought into the automation part of it, still trying to work out the SQL code to add the required values if they do not already exist.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project