mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2026-01-01 05:57:54 -05:00
d4ab56b742
* Fix migration errors Add dropColumnIfExists to migration_helper * Add config key/values if missing (#4282)
36 lines
1.3 KiB
SQL
36 lines
1.3 KiB
SQL
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'msg_msg', ''
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'msg_msg');
|
|
|
|
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'msg_pwd', ''
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'msg_pwd');
|
|
|
|
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'msg_uid', ''
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'msg_uid');
|
|
|
|
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'msg_src', ''
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'msg_src');
|
|
|
|
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'smtp_timeout', 5000
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'smtp_timeout');
|
|
|
|
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'smtp_crypto', 'tls'
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'smtp_crypto');
|
|
|
|
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'smtp_port', 587
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'smtp_port');
|
|
|
|
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'mailpath', '/usr/bin/sendmail'
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'mailpath');
|
|
|
|
INSERT INTO ospos_app_config (`key`, `value`)
|
|
SELECT 'protocol', 'sendmail'
|
|
WHERE NOT EXISTS (SELECT 1 FROM ospos_app_config WHERE `key` = 'protocol');
|