DROP TABLE IF EXISTS `shops`;
CREATE TABLE `shops` (
                         `id` int NOT NULL AUTO_INCREMENT,
                         `name` varchar(50) NOT NULL,
                         `logo` varchar(255) NOT NULL,
                         `address` varchar(200) NOT NULL,
                         `site_template` varchar(150) NOT NULL,
                         `admin_template` varchar(150) NOT NULL,
                         `shop_type` varchar(15) NOT NULL,
                         `shop` varchar(10) NOT NULL,
                         `date_added` datetime NOT NULL,
                         `status` tinyint(1) NOT NULL,
                         'sub_type' varchar(255) NOT NULL,
                         'dbname' varchar(255) NOT NULL,
                         'dbuser' varchar(255) NOT NULL,
                         'dbpass' varchar(255) NOT NULL,
                         'mysqlsrv' varchar(255) NOT NULL,
                         'host' varchar(255) NOT NULL,
                         `mobile_template` varchar(150) NOT NULL,
                         `mobil_logo` varchar(150) NOT NULL,
                         `footer_logo` varchar(150) NOT NULL,
                         `favicon` varchar(150) NOT NULL,
                         `shop_style` varchar(5) NOT NULL DEFAULT 'b2c' COMMENT 'Mağaza türü: b2b,b2c,c2c',
                         `multiple` int NOT NULL DEFAULT '0',
                         `default_lang` varchar(5) NOT NULL DEFAULT 'tr',
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;