-- public_html/lib/sql/options_table.sql
-- This is for EACH PROJECT DATABASE (not the main one)

CREATE TABLE IF NOT EXISTS `options` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `opt_key`   VARCHAR(191) NOT NULL,
    `opt_value` TEXT NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `uniq_opt_key` (`opt_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
