CREATE TABLE `brand` (
  `brand_id` int(11) NOT NULL,
  `brand_name` varchar(255) NOT NULL,
  `brand_image` varchar(255) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `brand_category_id` int(11) DEFAULT NULL,
  `sort_order` int(5) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `brand_info` (
  `brand_id` int(11) NOT NULL,
  `languages_id` int(11) NOT NULL,
  `brand_url` varchar(255) NOT NULL,
  `url_clicked` int(5) NOT NULL DEFAULT 0,
  `date_last_click` datetime DEFAULT NULL,
  `brand_description` text DEFAULT NULL,
  `brand_seo_description` text DEFAULT NULL,
  `brand_seo_title` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `brand`
  ADD PRIMARY KEY (`brand_id`),
  ADD KEY `IDX_BRAND_NAME` (`brand_name`);

ALTER TABLE `brand_info`
  ADD PRIMARY KEY (`brand_id`,`languages_id`);

ALTER TABLE `brand`
  MODIFY `brand_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;