INSERT INTO `ref` (`cat`, `code`, `descr`, `descr_en`, `sort`, `param1`, `icon_name`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted_at`) VALUES
('UIUX_ELEMENT_TYPE', 'text', 'Text', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'image', 'Image', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'audio', 'Audio', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'video', 'Video', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'googlemap', 'Google Map', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'footer', 'Footer', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'header', 'Header', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'menu', 'Menu', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'slider', 'Slider', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('UIUX_ELEMENT_TYPE', 'column', 'Column', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

CREATE TABLE IF NOT EXISTS `uiux_templates` (
  `element_id` int(11) NOT NULL,
  `element_title` varchar(255) DEFAULT NULL,
  `element_type` varchar(255) DEFAULT NULL,
  `element_descr` text,
  `element_img` varchar(255) DEFAULT NULL,
  `element_content` longtext,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `uiux_templates`
  ADD PRIMARY KEY (`element_id`);

ALTER TABLE `uiux_templates`
  MODIFY `element_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;