23 lines
898 B
SQL
23 lines
898 B
SQL
# opendrs-update.sql
|
|
|
|
# ---------- version 1.1.0 -------------
|
|
# Update version number
|
|
update config set name="drs_version" where name="mts_version";
|
|
update config set value="1.1.0",defaultvalue="1.1.0" where name="drs_version";
|
|
|
|
# Add period_eff_help_txt to config table
|
|
insert into config(name,value,defaultvalue)
|
|
select * from
|
|
(select 'period_eff_help_txt',
|
|
'If maintenance issues prevented the training objectives from being achieved and you will have to come back and redo the same training, answer Non-effective. Otherwise, answer Effective.' as wval,
|
|
'If maintenance issues prevented the training objectives from being achieved and you will have to come back and redo the same training, answer Non-effective. Otherwise, answer Effective.' as dval
|
|
)
|
|
as tmp
|
|
where not exists
|
|
(
|
|
select name from config where name = 'period_eff_help_txt'
|
|
) limit 1
|
|
;
|
|
# ---------------------------------------
|
|
|