CREATE TABLE `user_settings` (
  `user_id` int(11) NOT NULL,
  `date_format` varchar(255) DEFAULT 'MM/DD/YYYY',
  `time_format` varchar(3) DEFAULT '12h',
  `lang` varchar(10) DEFAULT 'en',
  PRIMARY KEY (`user_id`),
  CONSTRAINT `user_settings_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
