DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
                           `id` int NOT NULL AUTO_INCREMENT,
                           `presenter` varchar(155) NOT NULL DEFAULT 'all' COMMENT 'all - tüm presenterlerde çalışır',
                           `code` varchar(155) NOT NULL,
                           `key_code` varchar(50) NOT NULL,
                           `value` text NOT NULL,
                           `is_serialize` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 - serialized, 0 - not serialized',
                           `model` varchar(20) NOT NULL DEFAULT 'catalog' COMMENT 'admin, catalog',
                           `status` tinyint(1) NOT NULL DEFAULT '1',
                           `shop_id` int DEFAULT NULL,
                           `date_added` datetime NOT NULL,
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;