/*
    MySQL schema change script to create settings table
    Required for EMDT-787 and EMDT-599
    Paul Barratt
    10 Mar 2020
 */
CREATE TABLE `settings` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `description` varchar(256) DEFAULT NULL,
    `Property_key` varchar(256) NOT NULL,
    `Property_value` varchar(1024) DEFAULT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4