ALTER TABLE `users` ADD `is_active` TINYINT(1) NOT NULL AFTER `is_admin`;

CREATE TABLE `slider_images` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `slider_desc` text NOT NULL,
  `image` varchar(300) NOT NULL,
  `image_order` int(3) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `url` varchar(300) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `slider_images`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `slider_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `slider_images` CHANGE `slider_desc` `slider_desc` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
CHANGE `url` `url` VARCHAR(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `site_name` varchar(200) NOT NULL,
  `slider_image_height` float NOT NULL,
  `slider_image_width` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;