9 lines
263 B
SQL
9 lines
263 B
SQL
CREATE TABLE IF NOT EXISTS `settings` (
|
|
`key` VARCHAR(64) PRIMARY KEY,
|
|
`value` VARCHAR(255) NOT NULL
|
|
);
|
|
|
|
INSERT INTO `settings` (`key`, `value`)
|
|
SELECT 'pln_to_eur_rate', '0.23'
|
|
WHERE NOT EXISTS (SELECT 1 FROM `settings` WHERE `key` = 'pln_to_eur_rate');
|