a:2:{i:0;a:1:{i:0;a:2:{s:5:"Table";s:12:"tbl_settings";s:12:"Create Table";s:818:"CREATE TABLE `tbl_settings` (
  `name` int NOT NULL AUTO_INCREMENT,
  `shift_start_time` varchar(20) DEFAULT NULL,
  `shift_end_time` varchar(20) DEFAULT NULL,
  `reporting_day` int DEFAULT NULL,
  `sort_items_default` varchar(20) DEFAULT NULL,
  `discount_their` json DEFAULT NULL,
  `shop` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `balanced` tinyint(1) DEFAULT NULL,
  `broadcast` tinyint DEFAULT NULL,
  PRIMARY KEY (`name`),
  KEY `FK-settings-shop` (`shop`),
  KEY `fk-settings-cities` (`city_id`),
  CONSTRAINT `fk-settings-cities` FOREIGN KEY (`city_id`) REFERENCES `tbl_cities` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT `FK-settings-shop` FOREIGN KEY (`shop`) REFERENCES `tbl_shop` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb3";}}i:1;N;}