-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 29 Sep 2022 pada 09.20
-- Versi server: 5.7.34
-- Versi PHP: 7.4.21

START TRANSACTION;



--
-- Database: `ngc_core`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `0pti0n_s3tt1ng`
--

CREATE TABLE `0pti0n_s3tt1ng` (
  `id` int(3) NOT NULL,
  `table_name` varchar(50) NOT NULL,
  `field_name` varchar(50) DEFAULT NULL,
  `class_name` varchar(50) NOT NULL,
  `get_from_table` varchar(50) DEFAULT NULL,
  `input_type` enum('select','radio','text') DEFAULT 'select',
  `show_field` varchar(50) DEFAULT NULL,
  `selected` int(3) DEFAULT '0',
  `clickable` tinyint(1) DEFAULT '1',
  `filter_col_name` varchar(50) DEFAULT NULL,
  `filter_value` varchar(50) DEFAULT NULL,
  `url` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `0pti0n_s3tt1ng`
--

INSERT INTO `0pti0n_s3tt1ng` (`id`, `table_name`, `field_name`, `class_name`, `get_from_table`, `input_type`, `show_field`, `selected`, `clickable`, `filter_col_name`, `filter_value`, `url`) VALUES
(1, 'ngc_routes', 'parent', '', 'ngc_routes', 'select', 'title', 0, 1, NULL, NULL, 'custom-pages'),
(2, 'ngc_routes', 'id_type', '', 'ngc_routes_views', 'select', 'title', 0, 1, NULL, NULL, NULL),
(3, 'ngc_global_posts', 'lang_id', '', 'ngc_languages', 'select', 'url_slug', 0, 0, NULL, NULL, NULL),
(4, 'ngc_global_posts_taxo', 'term_id', '', 'ngc_global_posts_terms', 'select', 'name', 0, 1, NULL, NULL, NULL),
(5, 'ngc_global_posts', 'post_parent', '', 'ngc_global_posts', 'select', 'post_name', 0, 1, NULL, NULL, NULL),
(6, 'ngc_global_images', 'global_post_id', '', 'ngc_global_posts', 'select', 'post_title', 0, 1, 'post_parent', '333', 'prsvc'),
(7, 'ngc_routes_views_details', 'routes_views_id', '', 'ngc_routes_views', 'select', 'title', 0, 1, NULL, NULL, 'custom-pages-dev'),
(8, 'ngc_navigation', 'parent_nav', '', 'ngc_navigation', 'select', 'title', 0, 1, NULL, NULL, ''),
(9, 'ngc_routes_views_details', 'parent', '', 'ngc_routes_views_details', 'select', 'keyword', 0, 1, NULL, NULL, ''),
(12, 'ngc_master_item', 'item_status', '', 'ngc_master_item_status', 'select', 'name', 0, 0, NULL, NULL, NULL),
(13, 'ngc_master_item', 'item_matrix_id', '', 'ngc_master_item_matrix', 'select', 'name', 0, 1, NULL, NULL, NULL),
(14, 'ngc_master_item', 'item_status', '', 'ngc_master_item_status', 'select', 'name', 0, 0, NULL, NULL, NULL),
(15, 'ngc_master_item', 'item_matrix_id', '', 'ngc_master_item_matrix', 'select', 'name', 0, 0, NULL, NULL, NULL),
(16, 'ngc_master_item', 'item_brand_id', '', 'ngc_master_item_brand', 'select', 'name', 0, 0, NULL, NULL, NULL),
(17, 'ngc_master_item_group', 'parent_id', '', 'ngc_master_item_group', 'select', 'name', 0, 0, NULL, NULL, ''),
(18, 'ngc_master_item_matrix_detail', 'id_matrix', '', 'ngc_master_item_matrix', 'select', 'name', 0, 0, NULL, NULL, NULL),
(19, 'ngc_master_item_images', 'item_id', '', 'ngc_master_item', 'select', 'name', 0, 0, NULL, 'master-item-images', 'master-item'),
(21, 'ngc_global_posts', 'post_parent', '', 'ngc_global_posts', 'select', 'post_title', 0, 0, '', 'gallery-gallery-list-image-list-sublevel', 'gallery-gallery-list'),
(23, 'ngc_agent_wanted_inquiry', 'item_id', '', 'ngc_master_item', 'select', 'name', 0, 0, NULL, 'agent-wanted-inquiry-sublevel', 'master-item'),
(24, 'ngc_master_item', 'item_group', '', 'ngc_master_item_group', 'select', 'name', 0, 0, NULL, 'master-item-sublevel', 'master-item-category'),
(25, 'ngc_navigation', 'lang_id', '', 'ngc_languages', 'select', 'url_slug', 0, 0, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `1001ti14_vi3w2014`
--

CREATE TABLE `1001ti14_vi3w2014` (
  `id` mediumint(5) NOT NULL,
  `A10010289` varbinary(100) NOT NULL,
  `B10010289` varbinary(100) NOT NULL,
  `C10010289` varbinary(100) NOT NULL,
  `user_badgedame` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `id_master_privilege` int(5) NOT NULL,
  `image_profile` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `as_store_id` int(6) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data untuk tabel `1001ti14_vi3w2014`
--

INSERT INTO `1001ti14_vi3w2014` (`id`, `A10010289`, `B10010289`, `C10010289`, `user_badgedame`, `id_master_privilege`, `image_profile`, `as_store_id`) VALUES
(1, 0xc0b67b25a8ec5f036586c23cc56410ac19c19e7b7011beea93f958d3b16ce8946392c626008627f2191049b2d18d2b2b, 0x17a47ca0630e860e57985a854619693b340c2164f8c91377d1c74710b6d4e357f00b1eab88eb05e20efe81fb743a394a, 0x299cc1ef8966bd9c3494d84fbeee73fe, 'superadmin', 0, 'avatar/Watermelon.png', 0);

-- --------------------------------------------------------

--
-- Struktur dari tabel `admin_notification`
--

CREATE TABLE `admin_notification` (
  `id` int(10) NOT NULL,
  `link_picture` varchar(200) NOT NULL,
  `initial` varchar(2) NOT NULL,
  `content` varchar(6000) NOT NULL,
  `posted_datetime` datetime DEFAULT NULL,
  `inserted_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `admin_notification_user`
--

CREATE TABLE `admin_notification_user` (
  `id_notification` int(10) NOT NULL,
  `id_admin` int(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `log_admin`
--

CREATE TABLE `log_admin` (
  `id` int(6) NOT NULL,
  `id_admin` int(5) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `login_datetime` datetime DEFAULT NULL,
  `current_location` varchar(6000) DEFAULT NULL,
  `current_datetime` datetime DEFAULT NULL,
  `logout_datetime` datetime DEFAULT NULL,
  `notes` varchar(6000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `log_admin`
--

INSERT INTO `log_admin` (`id`, `id_admin`, `ip`, `login_datetime`, `current_location`, `current_datetime`, `logout_datetime`, `notes`) VALUES
(1, 1, '::1', '2022-08-18 15:49:22', 'http://localhost/klar/public/ngc-cms/web-config.php', '2022-08-18 15:49:22', NULL, NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `m3nu_4dm1n`
--

CREATE TABLE `m3nu_4dm1n` (
  `id` int(3) NOT NULL,
  `url` varchar(50) DEFAULT '',
  `name` varchar(50) DEFAULT '',
  `top_or_left` varchar(20) NOT NULL DEFAULT 'left',
  `top_parent_id` int(3) DEFAULT '0',
  `specific_url` varchar(100) DEFAULT '',
  `menu_description` varchar(6000) NOT NULL,
  `table_name_no_prefix` varchar(50) DEFAULT '',
  `taxo_name` varchar(100) DEFAULT NULL,
  `default_terms` varchar(100) DEFAULT NULL,
  `specific_id` int(3) DEFAULT '0',
  `show_specific_field` varchar(100) DEFAULT '',
  `show_specific_value` varchar(100) DEFAULT '',
  `default_value` varchar(5000) NOT NULL DEFAULT '[]',
  `sortnumber` int(11) DEFAULT '0',
  `publish` tinyint(1) DEFAULT '1',
  `add_button` tinyint(1) DEFAULT '1',
  `edit_button` tinyint(1) DEFAULT '1',
  `delete_button` tinyint(1) DEFAULT '1',
  `searchable_field` varchar(200) DEFAULT '',
  `excluded_view_field` varchar(5000) DEFAULT 'id,sortnumber,modified_datetime,modified_by,urelpage',
  `excluded_input_field` varchar(5000) DEFAULT 'id,sortnumber,modified_datetime,modified_by,urelpage',
  `excluded_input_validation` varchar(5000) DEFAULT 'image',
  `recommended_img_size` varchar(200) DEFAULT '',
  `draggable` tinyint(1) DEFAULT '1',
  `exportable` tinyint(1) DEFAULT '0',
  `importable` tinyint(1) DEFAULT '0',
  `specific_add` varchar(100) DEFAULT '',
  `specific_edit` varchar(100) DEFAULT '',
  `specific_delete` varchar(100) DEFAULT '',
  `post_relation` tinyint(1) NOT NULL,
  `post_relation_value` varchar(500) NOT NULL,
  `left_style_menu` varchar(100) DEFAULT NULL,
  `sort_field_parameter` varchar(50) NOT NULL DEFAULT 'sortnumber',
  `sort_action_parameter` enum('Asc','Desc') NOT NULL DEFAULT 'Asc',
  `flag_summary` enum('1','0') NOT NULL DEFAULT '1',
  `urelpage_status` tinyint(1) NOT NULL,
  `urelpage_field` varchar(100) NOT NULL,
  `auto_croping` tinyint(1) DEFAULT NULL,
  `croping_size` varchar(200) DEFAULT NULL,
  `croping_field` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `m3nu_4dm1n`
--

INSERT INTO `m3nu_4dm1n` (`id`, `url`, `name`, `top_or_left`, `top_parent_id`, `specific_url`, `menu_description`, `table_name_no_prefix`, `taxo_name`, `default_terms`, `specific_id`, `show_specific_field`, `show_specific_value`, `default_value`, `sortnumber`, `publish`, `add_button`, `edit_button`, `delete_button`, `searchable_field`, `excluded_view_field`, `excluded_input_field`, `excluded_input_validation`, `recommended_img_size`, `draggable`, `exportable`, `importable`, `specific_add`, `specific_edit`, `specific_delete`, `post_relation`, `post_relation_value`, `left_style_menu`, `sort_field_parameter`, `sort_action_parameter`, `flag_summary`, `urelpage_status`, `urelpage_field`, `auto_croping`, `croping_size`, `croping_field`) VALUES
(1, 'developer-menu', 'Developer Menu', 'top', 0, '', '', '', '', '', 0, '', '', '[]', 1, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(2, 'menu-admin', 'Menu Admin', 'left', 1, 'admin-view.php', 'This menu will defines all the menu in the CMS', 'm3nu_4dm1n', '', '', 0, '', '', '[]', 2, 1, 1, 1, 1, '', 'id,sortnumber', 'id,sortnumber', 'url,name,top_or_left,top_parent_id,specific_url,menu_description,table_name_no_prefix,taxo_name,default_terms,specific_id,show_specific_field,show_specific_value,default_value,publish,add_button,edit_button,delete_button,searchable_field,excluded_view_field,excluded_input_field,excluded_input_validation,recommended_img_size,draggable,exportable,importable,specific_add,specific_edit,specific_delete,post_relation,post_relation_value,left_style_menu,sort_field_parameter,sort_action_parameter,flag_summary,urelpage_status,urelpage_field,auto_croping,croping_size,croping_field', '476 x 350', 1, 0, 0, 'add-menuadmin.php', 'edit-menuadmin.php', '', 0, '0', 'fa fa-users-cog', 'sortnumber', 'Asc', '0', 0, '', NULL, '', ''),
(3, 'page-management', 'Page Management', 'left', 1, '', '', '', NULL, NULL, 0, '', '', '[]', 3, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-file-code', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(4, 'routes', 'Routes', 'left', 3, '', 'With this menu, user can add another page from the prepared templates', 'ngc_routes', '', '', 0, '', '', '[]', 4, 1, 1, 1, 1, '', 'id,primary_menu_id,dependant_menu,main_post_id,parent,navigation,self_navigation,sortnumber,modified_datetime,modified_by', 'id,primary_menu_id,dependant_menu,main_post_id,parent,full_path,self_navigation,sortnumber,modified_datetime,modified_by', '', '', 1, 0, 0, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(5, 'routes-views', 'Routes Views', 'left', 3, '', 'This menu will define the pages user can add manually', 'ngc_routes_views', NULL, NULL, 0, '', '', '[]', 5, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'image_preview,section_taxo,static_label', '960x1280', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(6, 'routes-views-details', 'Routes Views Details', 'left', 3, '', 'This menu is used to split the inserted routes views into sections and define which attributes and settings are needed', 'ngc_routes_views_details', NULL, NULL, 0, 'cms_menu', 'routes-view-details-main', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"routes-view-details-main\"}]', 6, 1, 1, 1, 1, '', 'id,excluded_view_field,excluded_input_field,excluded_input_validation,sortnumber,modified_datetime,modified_by,excluded_view_field_sublevel,excluded_input_field_sublevel,excluded_input_validation_sublevel,cms_menu,parent', 'id,sortnumber,modified_datetime,modified_by,cms_menu,parent', 'recommended_img_size,recommended_img_size_sublevel', '', 1, 0, 0, 'add-menuroutesviewdetail.php', 'edit-menuroutesviewdetail.php', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(7, 'taxo-terms', 'Taxo Terms', 'left', 1, '', '', '', NULL, NULL, 0, '', '', '[]', 7, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-thumbtack', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(8, 'posts-terms', 'Posts Terms', 'left', 7, '', 'The terms for taxo', 'ngc_global_posts_terms', NULL, NULL, 0, '', '', '[]', 8, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', '', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(9, 'posts-taxo', 'Posts Taxo', 'left', 7, '', 'This menu is for assigning the terms into the needed taxo', 'ngc_global_posts_taxo', NULL, NULL, 0, '', '', '[]', 9, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'description,parent,count', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(10, 'global-post', 'Global Post', 'left', 1, '', 'Global data in website', 'ngc_global_posts', NULL, NULL, 0, '', '', '[]', 10, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'post_id,lang_id,post_date,post_name,post_type,post_parent,post_title,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner_image,post_banner_image_high,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,publish,cms_menu', '476 x 350, 500 x 500, 600 x 600, 600 x 100', 1, 0, 0, '', '', '', 0, '', 'fa fa-globe-asia', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(11, 'global-images', 'Global Images', 'left', 1, '', 'Global images in website', 'ngc_global_images', NULL, NULL, 0, '', '', '[]', 11, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'id,img_id,global_post_id,lang_id,name,type,description,image,image_high,link,link_text,link_target,urlpage,publish,sortnumber,modified_datetime,modified_by,cms_menu', '476 x 350', 1, 0, 0, '', '', '', 0, '', 'fa fa-globe-asia', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(12, 'web-settings', 'Web Settings', 'top', 0, '', '', '', NULL, NULL, 0, '', '', '[]', 12, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(13, 'dashboard', 'Dashboard', 'left', 12, 'dashboard.php', '', '', NULL, NULL, 0, '', '', '[]', 13, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by,urelpage', 'id,sortnumber,modified_datetime,modified_by,urelpage', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-tachometer-alt', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(14, 'web-config', 'Web Config', 'left', 12, 'web-config.php', 'This menu defines the setting of the website', 'web_config', '', '', 0, '', '', '[]', 14, 1, 1, 1, 1, '', 'id,google_analytic,logo_image,favicon_image,sortnumber,modified_datetime,modified_by,auto_cancel_order_time', 'id,auto_cancel_order_time,sortnumber,modified_datetime,modified_by', 'facebook_link,youtube_link,instagram_link,twitter_link,linkedin_link,google_analytic,whitelist_ip', '', 1, 0, 0, '', 'edit-webconfig.php', '', 0, '', 'fa fa-cog', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(15, 'users', 'Users', 'left', 12, '', '', '', NULL, NULL, 0, '', '', '[]', 15, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-users', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(16, 'master-privilege', 'Master Privilege', 'left', 15, 'privilege-view.php', 'This menu is used to assign users\' privileges for accessing CMS', '', NULL, NULL, 0, '', '', '[]', 16, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'image', '', 1, 0, 0, 'privilege-add.php', 'privilege-edit.php', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(17, 'user-list', 'User List', 'left', 15, 'user-view.php', 'This menu lists all the users in CMS', '', NULL, NULL, 0, '', '', '[]', 17, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'image', '', 1, 0, 0, 'user-add.php', 'user-edit-profile.php', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(18, 'change-password', 'Change Password', 'left', 15, 'user-change-password.php', 'Change your account\'s password', '', NULL, NULL, 0, '', '', '[]', 17, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'image', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(19, 'seo', 'Seo', 'left', 12, '', 'This menu lists all the registered seo in website based on the page&#039;s/item&#039;s URL', 'ngc_seo', '', '', 0, '', '', '[]', 18, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', '', '500 x 500', 1, 0, 0, '', '', '', 0, '', 'fa fa-chart-line', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(20, 'navigation-pages', 'Navigation', 'left', 12, '', 'This menu is used to manage the navigation in website', 'ngc_navigation', '', '', 0, '', '', '[]', 19, 1, 1, 1, 1, '', 'id,mega_menu,sub_menu,params,taxo_name,sortnumber,modified_datetime,modified_by', 'id,mega_menu,sub_menu,params,taxo_name,sortnumber,modified_datetime,modified_by', 'nav_id,url', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-sitemap', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(21, 'media-gallery', 'Media Gallery', 'left', 12, '', 'This menu will show all the images that can be copied to our text editor via the provided image\'s url', 'ngc_global_images', NULL, NULL, 0, '', '', '[]', 20, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by,global_post_id,link_text,link_target,urlpage,type,description,link,cms_menu,image_high,publish', 'id,sortnumber,modified_datetime,modified_by,global_post_id,link_text,link_target,urlpage,type,description,link,cms_menu,image_high,publish', 'image', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-images', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(22, 'others', 'Others', 'left', 12, '', '', '', NULL, NULL, 0, '', '', '[]', 21, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-coffee', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(23, 'languages', 'Languages', 'left', 22, '', 'This menu lists the currently available language in the website', 'ngc_languages', NULL, NULL, 0, '', '', '[]', 22, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by,urelpage', 'id,sortnumber,modified_datetime,modified_by,urelpage', 'link_text,link,description,link_target', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(24, 'email-content', 'Email Content', 'left', 22, '', 'This menu consists of all the email template that is used in the website', 'ngc_email_content', '', '', 0, '', '', '[]', 23, 1, 0, 1, 0, '', 'id,publish,sortnumber,modified_datetime,modified_by', 'id,tag,publish,sortnumber,modified_datetime,modified_by', '', '', 1, 0, 0, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(25, 'activites-log', 'Activities Log', 'left', 22, '', 'This menu shows all the activities the users&#039; do in CMS', 'user_activities', '', '', 0, '', '', '[]', 24, 1, 0, 0, 0, '', 'id,publish,sortnumber,modified_datetime,modified_by', 'id,publish,sortnumber,modified_datetime,modified_by', '', '', 1, 0, 0, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(26, 'labels', 'Labels', 'left', 22, '', 'This menu lists all the label which are used in the website', 'ngc_global_posts', NULL, NULL, 0, 'cms_menu', 'label', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"label\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 25, 1, 1, 1, 1, '', 'id,post_date,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner,image,post_banner_image_high,post_image_high,post_file,post_link_text,video_link,urlpage,featured,sortnumber,modified_datetime,modified_by,cms_menu,post_banner_image,post_image,user_defined', 'id,post_date,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner,image,post_banner_image_high,post_image_high,post_file,post_link_text,video_link,urlpage,featured,sortnumber,modified_datetime,modified_by,cms_menu,post_banner_image,post_image,user_defined', 'post_link', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(27, 'forms-labels', 'Forms Labels', 'left', 22, '', 'This menu lists all the forms which are used in the website', 'ngc_global_posts', NULL, NULL, 0, 'cms_menu', 'form-label', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"form-label\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 26, 1, 1, 1, 1, '', 'id,post_date,post_type,post_parent,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner,image,post_banner_image_high,post_image_high,post_file,post_link_text,video_link,urlpage,featured,sortnumber,modified_datetime,modified_by,cms_menu,post_banner_image,post_image,user_defined', 'id,post_date,post_type,post_parent,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner,image,post_banner_image_high,post_image_high,post_file,post_link_text,video_link,urlpage,featured,sortnumber,modified_datetime,modified_by,cms_menu,post_banner_image,post_image,user_defined', 'post_link', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(28, 'buttons', 'Buttons', 'left', 22, '', 'This menu lists all the buttons which are used in the website', 'ngc_global_posts', NULL, NULL, 0, 'cms_menu', 'button', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"button\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 27, 1, 1, 1, 1, '', 'id,post_date,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner,image,post_banner_image_high,post_image_high,post_file,post_link_text,video_link,urlpage,featured,sortnumber,modified_datetime,modified_by,cms_menu,post_banner_image,post_image,user_defined', 'id,post_date,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner,image,post_banner_image_high,post_image_high,post_file,post_link_text,video_link,urlpage,featured,sortnumber,modified_datetime,modified_by,cms_menu,post_banner_image,post_image,user_defined', 'post_link', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(29, 'alert-messages', 'Alert Messages', 'left', 22, '', 'This menu lists all the alert messages in the website', 'ngc_alert_messages', NULL, NULL, 0, 'cms_menu', 'alert_messages', '[]', 28, 1, 1, 1, 1, '', 'id,post_id,post_date,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner,image,post_banner_image_high,post_image_high,post_file,post_link,post_link_text,video_link,urlpage,featured,sortnumber,modified_datetime,modified_by,cms_menu', 'id,post_id,post_date,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner,image,post_banner_image_high,post_image_high,post_file,post_link,post_link_text,video_link,urlpage,featured,sortnumber,modified_datetime,modified_by,cms_menu,name', '', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(30, 'inquiry', 'Databases', 'top', 0, '', '', '', NULL, NULL, 0, '', '', '[]', 29, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(31, 'subscriber-list', 'Subscriber List', 'left', 30, '', 'This menu lists all the subscribers in the website', 'ngc_subscribers', '', '', 0, '', '', '[]', 30, 1, 0, 0, 0, '', 'id,publish,sortnumber,modified_datetime,modified_by', 'id,publish,sortnumber,modified_datetime,modified_by', '', '', 1, 1, 0, '', '', '', 0, '', 'fa fa-address-book', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(32, 'contact-inquiry', 'Inquiry List', 'left', 30, '', 'The menu lists all the contact inquiries', 'ngc_contact_inquiry', '', '', 0, '', '', '[]', 31, 1, 0, 1, 0, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', '', '', 1, 1, 0, '', '', '', 0, '', 'fa fa-envelope-open-text', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(33, 'filler-contents', 'Filler Contents', 'top', 0, '', '', '', NULL, NULL, 0, '', '', '[]', 32, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(34, 'for-entire-website', 'For Entire Website', 'left', 33, '', '', '', NULL, NULL, 0, '', '', '[]', 17, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'image', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-fill', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(35, 'newsletter-pages', 'Newsletter Pages', 'left', 34, '', 'This menu lists the content of the newsletter section in the website ', 'ngc_global_posts', '', '', 0, 'cms_menu', 'subscriber-pages', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"subscriber-pages\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 33, 1, 0, 1, 0, '', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner_image,post_banner_image_high,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,publish,sortnumber,modified_datetime,modified_by,cms_menu', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner_image,post_banner_image_high,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,publish,sortnumber,modified_datetime,modified_by,cms_menu', '', '160 x 158', 1, 0, 0, '', '', '', 0, '', 'fa fa-file-code', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(36, 'search-result', 'Search Result', 'left', 34, '', 'This menu lists the content of the search page in the website ', 'ngc_global_posts', '', '', 0, 'cms_menu', 'search-result-pages', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"search-result-pages\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 34, 1, 0, 1, 0, '', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_content_heading,content,post_banner_image_high,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,publish,sortnumber,modified_datetime,modified_by,cms_menu', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_content_heading,content,post_banner_image_high,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,publish,sortnumber,modified_datetime,modified_by,cms_menu', 'post_banner_image', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-file-code', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(37, 'footer-text', 'Footer Text', 'left', 34, '', 'This menu lists the content of the footer text section in the website ', 'ngc_global_posts', '', '', 0, 'cms_menu', 'footer-intro', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"footer-intro\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 35, 1, 0, 1, 0, '', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner_image,post_banner_image_high,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,publish,sortnumber,modified_datetime,modified_by,cms_menu', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner_image,post_banner_image_high,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,publish,sortnumber,modified_datetime,modified_by,cms_menu', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-file-code', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(38, 'footer-images', 'Footer Images', 'left', 34, '', 'This menu lists the content of the footer images section in the website ', 'ngc_global_posts', '', '', 0, 'cms_menu', 'footer-images-list', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"footer-images-list\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 36, 1, 0, 1, 0, '', 'id,post_date,post_type,post_parent,post_title,post_subtitle,post_intro,post_content_heading,content,post_banner_image,post_banner_image_high,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,sortnumber,modified_datetime,modified_by,cms_menu', 'id,post_date,post_type,post_parent,post_title,post_subtitle,post_intro,post_content_heading,content,post_banner_image,post_banner_image_high,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,sortnumber,modified_datetime,modified_by,cms_menu', 'post_subtitle_heading,post_intro_heading', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-file-code', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(39, '503-pages', '503 Pages', 'left', 34, '', 'This menu lists the content of the Maintenance Page in the website ', 'ngc_global_posts', NULL, NULL, 0, 'cms_menu', '503-pages', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"503-pages\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 37, 1, 1, 1, 1, '', 'id,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner_image,post_banner_image_high,post_image_high,video_link,post_link,featured,sortnumber,modified_datetime,modified_by,cms_menu,urlpage,post_file,user_defined,post_name,post_link_text', 'id,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner_image,post_banner_image_high,post_image_high,video_link,post_link,featured,sortnumber,modified_datetime,modified_by,cms_menu,urlpage,post_file,user_defined,post_name,post_link_text', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-file-code', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(40, '404-pages', '404 Pages', 'left', 34, '', 'This menu lists the content of the Not Found Page in the website ', 'ngc_global_posts', NULL, NULL, 0, 'cms_menu', '404-pages', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"404-pages\"},{\"name\": \"post_type\", \"type\": \"hidden\", \"value\":\"micro-post\"}]', 38, 1, 1, 1, 1, '', 'id,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner_image,post_banner_image_high,video_link,featured,sortnumber,modified_datetime,modified_by,cms_menu,urlpage,post_file,user_defined,post_name,post_image_high', 'id,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_banner_image,post_banner_image_high,video_link,featured,sortnumber,modified_datetime,modified_by,cms_menu,urlpage,post_file,user_defined,post_name,post_image_high', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-file-code', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(41, 'master-items', 'Master Items', 'top', 0, '', '', '', NULL, NULL, 0, '', '', '[]', 39, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(42, 'master-items-settings', 'Master Items Setting', 'left', 41, '', 'This is for master Item/product management. Please fill out all the required fields.', '', NULL, NULL, 0, '', '', '[]', 40, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-boxes', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(43, 'master-item-matrix', 'Master Item Matrix', 'left', 42, '', 'This is for your product master matrix management, it is for creating a header for your matrix variants.', 'ngc_master_item_matrix', NULL, NULL, 0, '', '', '[]', 41, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'dim1,dim2', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(44, 'master-item-matrix-detail', 'Master Item Matrix Detail', 'left', 42, '', 'This is for your product master matrix management, it is for creating the variants of the matrix header you have defined', 'ngc_master_item_matrix_detail', NULL, NULL, 0, '', '', '[]', 42, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,publish,sortnumber,modified_datetime,modified_by', 'dim1,dim2,id_dim', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(45, 'master-items-groups', 'Master Items Groups', 'left', 41, '', '', '', NULL, NULL, 0, '', '', '[]', 43, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-table', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(46, 'master-item-status', 'Master Item Status', 'left', 45, '', 'This is for product status, manage here and assign to product list.', 'ngc_master_item_status', NULL, NULL, 0, '', '', '[]', 44, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'description', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(47, 'master-item-category', 'Master Item Category', 'left', 45, '', 'This is for managing your product item categories. You can add more than you need at this menu. ', 'ngc_master_item_group', NULL, NULL, 0, '', '', '[]', 45, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'description,parent_id,image,urlpage', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(48, 'master-item-brand', 'Master Item Brand', 'left', 45, '', 'This is to add and manage your product brands. It can be filtered on product list later on if user want to see your products based on specific brand.\r\nRecommended Size Brand Image : &gt; 400 px.', 'ngc_master_item_brand', '', '', 0, '', '', '[]', 46, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', 'description,image,urlpage', '', 1, 0, 0, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', NULL, '', ''),
(49, 'master-item', 'Master Items', 'left', 41, '', 'This is to manage your products, add and image, descriptions and other information about your products. Make it informative. ', 'ngc_master_item', '', '', 0, '', '', '[]', 47, 1, 1, 1, 1, '', 'item_matrix_id,price,special_price,image_high,rating,sortnumber,modified_datetime,modified_by', 'id,item_matrix_id,price,special_price,image_high,rating,sortnumber,modified_datetime,modified_by', 'item_status,short_description,image,video_link,urlpage', '800 x 800', 1, 0, 0, '', '', '', 0, '', 'fa fa-box', 'sortnumber', 'Asc', '0', 0, '', NULL, '', ''),
(50, 'master-items-variant', 'Master Items Variant', 'left', 41, '', 'This is to manage, add image, descriptions and other information about your products\' variants. Make it informative. ', 'ngc_master_item_variant', NULL, NULL, 0, '', '', '[]', 48, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by', 'id,sortnumber,modified_datetime,modified_by', '', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-stroopwafel', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(51, 'master-pages', 'Master Pages', 'top', 0, '', '', '', NULL, NULL, 0, '', '', '[]', 49, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(52, 'additional-pages', 'Additional pages', 'top', 0, '', '', '', NULL, NULL, 0, '', '', '[]', 50, 1, 1, 1, 1, '', '', '', '', '', 1, 0, 0, '', '', '', 0, '', NULL, 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(53, 'new-pages', 'Add New Pages', 'left', 52, '', 'With this menu, user can add another page from the prepared templates', 'ngc_routes', NULL, NULL, 0, '', '', '[]', 51, 1, 1, 1, 1, '', 'id,primary_menu_id,dependant_menu,main_post_id,navigation,self_navigation,sortnumber,modified_datetime,modified_by', 'id,primary_menu_id,dependant_menu,main_post_id,full_path,self_navigation,sortnumber,modified_datetime,modified_by', 'parent', '', 1, 0, 0, '', '', '', 0, '', 'fa fa-plus', 'sortnumber', 'Asc', '1', 0, '', NULL, NULL, NULL),
(54, 'routes-view-detail-sublevel', 'Routes View Detail Sublevel', 'left', 3, '', '', 'ngc_routes_views_details', '', '', 0, 'cms_menu', 'routes-view-details-sublevel', '[{\"name\": \"cms_menu\", \"type\": \"hidden\", \"value\":\"routes-view-details-sublevel\"}]', 52, 1, 1, 1, 1, '', 'id,excluded_view_field,excluded_input_field,excluded_input_validation,sortnumber,modified_datetime,modified_by,excluded_view_field_sublevel,excluded_input_field_sublevel,excluded_input_validation_sublevel,cms_menu,taxo,pagination_item', 'id,sortnumber,modified_datetime,modified_by,cms_menu,taxo, pagination_item', 'recommended_img_size,recommended_img_size_sublevel', '', 1, 0, 0, 'add-menuroutesviewdetailsublevel.php', 'edit-menuroutesviewdetailsublevel.php', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', 0, '', ''),
(55, 'master-item-images', 'Master Items Images', 'sub-level', 0, '', '', 'ngc_master_item_images', '', '', 0, '', '', '[]', 53, 1, 1, 1, 1, '', 'id,sortnumber,modified_datetime,modified_by,image_high', 'id,sortnumber,modified_datetime,modified_by,image_high', '', '', 1, 0, 0, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', 0, '', ''),
(56, 'contact-subject-list', 'Contact Subject-list', 'left', 74, '', '', 'ngc_global_posts', '', '', 0, 'cms_menu', 'contact-contact-subject-list', '[{\"name\":\"cms_menu\",\"type\":\"hidden\",\"value\":\"contact-contact-subject-list\"},{\"name\":\"post_type\",\"type\":\"hidden\",\"value\":\"micro-post\"},{\"name\":\"post_parent\",\"type\":\"hidden\",\"value\":153},{\"name\":\"post_name\",\"type\":\"hidden\",\"value\":\"subject-list\"}]', 74, 1, 1, 1, 1, 'name', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner_image,post_banner_image_high,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,urlpage,sortnumber,modified_datetime,modified_by,cms_menu,post_name', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_banner_image,post_banner_image_high,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,urlpage,sortnumber,modified_datetime,modified_by,cms_menu,post_name', '', '', 1, 0, 0, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', 0, '', ''),
(57, 'master-item-sublevel', 'Master Items Sublevel', 'sub-level', 0, '', 'This is to manage your products, add and image, descriptions and other information about your products. Make it informative. ', 'ngc_master_item', NULL, NULL, 0, '', '', '[]', 47, 1, 1, 1, 1, '', 'id,price,special_price,image_high,rating,sortnumber,modified_datetime,modified_by', 'id,price,special_price,image_high,rating,sortnumber,modified_datetime,modified_by,modified_by', 'item_matrix_id,item_status,short_description,image,urlpage,video_link', '800 x 800', 1, 0, 0, '', '', '', 0, '', 'fa fa-box', 'sortnumber', 'Asc', '0', 0, '', NULL, NULL, NULL),
(58, 'splashscreen-primary', 'Splash Screen', 'left', 33, '', '', 'ngc_global_posts', '', '', 0, 'cms_menu', 'splashscreen', '\"\"', 6, 1, 1, 1, 1, 'name', 'id,post_id,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_file,modified_datetime,modified_by,cms_menu,user_defined,featured,sortnumber', 'id,post_id,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,post_file,modified_datetime,modified_by,cms_menu,user_defined,featured,sortnumber', 'post_banner_image,post_banner_image_high,post_image,post_image_high,video_link,post_link,post_link_text', '', 1, 1, 1, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', 0, '', ''),
(59, 'splashscreen-popupcontent', 'Splash Screen Popupcontent', 'left', 60, '', '', 'ngc_global_posts', '', '', 0, 'cms_menu', 'splashscreen-popupcontent', '[{\"name\":\"cms_menu\",\"type\":\"hidden\",\"value\":\"splashscreen-popupcontent\"},{\"name\":\"post_type\",\"type\":\"hidden\",\"value\":\"micro-post\"},{\"name\":\"post_parent\",\"type\":\"hidden\",\"value\":113},{\"name\":\"post_name\",\"type\":\"hidden\",\"value\":\"popupcontent\"}]', 59, 1, 0, 1, 0, 'name', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,sortnumber,modified_datetime,modified_by,cms_menu,post_name', 'id,post_date,post_name,post_type,post_parent,post_subtitle_heading,post_subtitle,post_intro_heading,post_intro,post_content_heading,content,post_image,post_image_high,post_file,video_link,post_link_text,post_link,featured,user_defined,urlpage,sortnumber,modified_datetime,modified_by,cms_menu,post_name', '', '600x750,1600x800', 1, 0, 0, '', '', '', 0, '', '', 'sortnumber', 'Asc', '1', 0, '', 0, '', '');

-- --------------------------------------------------------

--
-- Struktur dari tabel `master_privilege`
--

CREATE TABLE `master_privilege` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `menu` longtext NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(3) DEFAULT NULL,
  `sortnumber` int(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `master_privilege`
--

INSERT INTO `master_privilege` (`id`, `name`, `menu`, `modified_datetime`, `modified_by`, `sortnumber`) VALUES
(1, 'Superadmin', 'custom-pages,custom-pages+list-routes,custom-pages+routes-views,admin-menu,user,user+master-privilage,user+cms-user,dashboard,global-post,global-images,website-setting,website-setting+media,website-setting+web-config-list,website-setting+email-content,website-setting+available-language,website-setting+seo,website-setting+activities-log,website-setting+buttons-labels,website-setting+alert-messages,taxo-settings,taxo-settings+global-posts-terms,taxo-settings+global-posts-taxo,career-primary+career-title,home-primary+home-title,home-primary+home-list-our commitment,contact-primary,contact-primary+contact-list-branch list,page-child,about-2-primary+about-2-title,about-2-primary+about-2-list-our commitments,about-2-primary,about-2-primary+about-2-title,about-2-primary+about-2-list-corporate values,about-2-primary+about-2-list-our commitments,about-2-primary,about-2-primary+about-2-list-corporate values,about-2-primary+about-2-list-the management,about-2-primary+about-2-title,about-2-primary+about-2-list-our commitments,about-2-primary,about-2-primary+about-2-list-corporate values,about-2-primary+about-2-list-the management,about-2-primary+about-2-title,about-2-primary+about-2-list-our commitments,about-2-primary,about-2-primary,about-2-primary,about-2-primary,about-2,about-2-primary,about-2,about-2,about-2-primary,about-2-primary,about-2-primary,about-2-primary+about-2-mission,about-2-primary+about-2-mission,about-detail-primary+about-detail-mission,-primary+-vision,tespage-3-sublevel,tespage-1-sublevel,tespage-t-sublevel,tespage-S-sublevel,tespage-m-sublevel,tespage-i-sublevel,tespage-i-sublevel,tespage--sublevel,tespage--sublevel,tespage-0-sublevel,tespage-0-sublevel,tespage-7-sublevel,tespage-1-sublevel,tespage-r-sublevel,tespage-2-sublevel,tespage-1-sublevel,tespage-i-sublevel,tespage-i-sublevel,tespage--sublevel,tespage--sublevel,tespage-0-sublevel,tespage-0-sublevel,tespage-7-sublevel,tespage-1-sublevel,tespage-r-sublevel,tespage-2-sublevel,tespage-1-sublevel,master-pages+tespage-primary,master-pages+home-primary,home-primary+home-home-slider,home-primary+home-home-brand-intro,home-primary+home-home-about,home-primary+home-home-event-intro,home-primary+home-home-product-intro,home-primary+home-home-gallery-intro,home-primary+home-home-news-intro,home-primary+home-home-news-list,master-pages+about-primary,about-primary+about-about-intro,about-primary+about-about-taiwan-excellence-awards,about-primary+about-about-taiwan-excellence-awards-meaning-intro,about-primary+about-taiwan-excellence-awards-meaning-list,about-primary+about-about-taitra,master-pages+event-primary,event-primary+event-event-intro,event-primary+event-event-list,master-pages+contact-primary,contact-primary+contact-contact-intro,contact-primary+contact-subject-list,master-pages+gallery-primary,gallery-primary+gallery-gallery-intro,gallery-primary+gallery-gallery-list,gallery-gallery-list-image-list-sublevel,gallery-primary+gallery-gallery-others-intro,master-pages+product-primary,product-primary+product-product-category-intro,product-primary+product-product-list-intro,additional-pages+blog-primary,blog-primary+blog-event-intro,blog-primary+blog-event-list,master-pages+journal-list-primary,journal-list-primary+journal-list-intro,master-pages+journal-primary,journal-primary+journal-intro,journal-primary+journal-list,journal-primary+journal-intro,journal-primary+journal-list,master-pages+journal-category-primary,journal-category-primary+journal-category-intro,journal-category-primary+journal-category-list', NULL, NULL, 0),
(5, 'Admin', 'developer-menu,menu-admin,web-settings,web-config,users,master-privilege,user-list,change-password,seo,navigation-pages,others,languages,email-content,activites-log,labels,forms-labels,inquiry,subscriber-list,contact-inquiry,agent-wanted-inquiry,filler-contents,for-entire-website,newsletter-pages,search-result,footer-text,footer-images,master-items,master-items-groups,master-item-status,master-item-category,master-item-brand,master-item,master-pages,home-primary,home-home-slider,home-home-brand-intro,home-home-about,home-home-event-intro,home-home-product-intro,home-home-gallery-intro,home-home-news-intro,home-home-news-list,home-home-brand-list,about-primary,about-about-intro,about-about-taiwan-excellence-awards,about-about-taiwan-excellence-awards-meaning-intro,about-taiwan-excellence-awards-meaning-list,about-about-taitra,event-primary,event-event-intro,event-event-list,contact-primary,contact-contact-intro,contact-subject-list,gallery-primary,gallery-gallery-intro,gallery-gallery-list,gallery-gallery-others-intro,product-primary,product-product-category-intro,product-product-list-intro,additional-pages,new-pages,blog-primary,blog-event-intro,blog-event-list,gallery-gallery-list-image-list-sublevel,agent-wanted-inquiry-sublevel,master-item-sublevel,master-pages+journal-list-primary,journal-list-primary+journal-list-intro,master-pages+journal-primary,journal-primary+journal-intro,journal-primary+journal-list,journal-primary+journal-intro,journal-primary+journal-list,master-pages+journal-category-primary,journal-category-primary+journal-category-intro,journal-category-primary+journal-category-list', NULL, NULL, 1),
(13, 'desaigner', 'web-settings,web-config,users,master-privilege,user-list,change-password,additional-pages+blog-primary,blog-primary+blog-event-intro,blog-primary+blog-event-list,master-pages+journal-list-primary,journal-list-primary+journal-list-intro,master-pages+journal-primary,journal-primary+journal-intro,journal-primary+journal-list,journal-primary+journal-intro,journal-primary+journal-list,master-pages+journal-category-primary,journal-category-primary+journal-category-intro,journal-category-primary+journal-category-list', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2018_06_17_005701_create_ngc_global_posts_table', 1),
(5, '2018_06_17_040931_add_post_banner_images', 2),
(7, '2018_06_17_042538_add_post_lang_id', 3),
(8, '2018_06_17_043402_add_post_date', 4),
(10, '2018_06_17_043802_add_index', 5),
(11, '2018_06_17_075232_create_ngc_languages_table', 6),
(13, '2018_06_18_081026_create_ngc_sliders_table', 7),
(17, '2018_06_18_125040_add_link_to_ngc_slider', 8),
(18, '2013_07_25_145943_create_languages_table', 9),
(19, '2013_07_25_145958_create_translations_table', 9),
(20, '2016_06_02_124154_increase_locale_length', 9);

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_alert_messages`
--

CREATE TABLE `ngc_alert_messages` (
  `id` int(11) UNSIGNED NOT NULL,
  `lang_id` int(11) DEFAULT NULL,
  `post_id` int(20) DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `type` enum('warning','error','success','info') CHARACTER SET utf8 DEFAULT 'info',
  `title` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `content` varchar(6000) CHARACTER SET utf8 DEFAULT NULL,
  `publish` tinyint(1) NOT NULL DEFAULT '1',
  `sortnumber` int(11) NOT NULL DEFAULT '0',
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(11) NOT NULL,
  `cms_menu` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data untuk tabel `ngc_alert_messages`
--

INSERT INTO `ngc_alert_messages` (`id`, `lang_id`, `post_id`, `name`, `type`, `title`, `content`, `publish`, `sortnumber`, `modified_datetime`, `modified_by`, `cms_menu`) VALUES
(1, 1, 1, 'Update Profile Success', 'success', 'Profile Updated', 'Your profile has been successfully updated', 1, 1, '2017-09-12 13:34:26', 1, NULL),
(2, 1, 2, 'Update Profile Failed', 'error', 'Cannot Update Profile', 'Failed to update your profile', 1, 2, '2017-09-12 13:34:38', 1, NULL),
(3, 1, 3, 'Update Password Success', 'success', 'Password Updated', 'Your password has been successfully updated', 1, 3, '2017-09-12 13:35:19', 1, NULL),
(4, 1, 4, 'Update Password Failed', 'error', 'Cannot Update Password ', 'Failed to update your password', 1, 4, '2017-09-12 13:35:30', 1, NULL),
(5, 1, 5, 'Update Billing Address Success', 'success', 'Billing Address Updated', 'Your billing address has been successfully updated', 1, 5, '2017-09-12 13:35:54', 1, NULL),
(6, 1, 6, 'Update Billing Address Failed', 'error', 'Cannot Update Billing Address ', 'Failed to update your billing address', 1, 6, '2017-09-12 13:36:03', 1, NULL),
(7, 1, 7, 'Update Shipping Address Success', 'success', 'Shipping Address Updated', 'Your shipping address has been successfully updated', 1, 7, '2017-09-12 13:36:18', 1, NULL),
(8, 1, 8, 'Update Shipping Address Failed', 'error', 'Cannot Update Shipping Address ', 'Failed to update your shipping address', 1, 8, '2017-09-12 13:36:28', 1, NULL),
(9, 1, 9, 'Insert Shipping Address Success', 'success', 'Shipping Address Inserted', 'Your new shipping address has been successfully added', 1, 9, '2017-09-12 13:37:09', 1, NULL),
(10, 1, 10, 'Insert Shipping Address Failed', 'error', 'Cannot Insert Shipping Address ', 'Failed to add new shipping address', 1, 10, '2017-09-12 13:37:23', 1, NULL),
(11, 1, 11, 'Delete Shipping Address Success', 'success', 'Shipping Address Deleted', 'Your shipping address has been successfully deleted', 1, 11, '2017-09-12 13:38:15', 1, NULL),
(12, 1, 12, 'Delete Shipping Address Failed', 'error', 'Cannot Delete Shipping Address ', 'Failed to delete your shipping address', 1, 12, '2017-09-12 13:38:26', 1, NULL),
(13, 1, 13, 'Insert Review Success', 'success', 'Review Inserted', 'Your review has been successfully submitted', 1, 13, '2017-09-12 13:38:42', 1, NULL),
(14, 1, 14, 'Insert Review Failed', 'error', 'Cannot Insert Review ', 'Failed to submit your review', 1, 14, '2017-09-12 13:38:53', 1, NULL),
(15, 1, 15, 'Payment Confirmation Success', 'success', 'Payment Confirmation Submitted', 'Your payment confirmation has been successfully submitted', 1, 15, '2017-09-12 13:42:07', 1, NULL),
(16, 1, 16, 'Payment Confirmation Failed', 'error', 'Payment Confirmation Failed', 'Failed to submit your payment confirmation', 1, 16, '2017-09-12 13:43:39', 1, NULL),
(17, 1, 17, 'Add to Cart Success', 'success', 'Item Added!', 'Item successfully added to shopping cart', 1, 17, '2017-09-12 13:44:25', 1, NULL),
(18, 1, 18, 'Add to Cart Failed', 'error', 'Cannot Add Item to Cart', 'Failed to add item to shopping cart', 1, 18, '2017-09-12 13:45:14', 1, NULL),
(19, 1, 19, 'Forgot Password Success', 'success', 'Forgot Password Success', 'Your password have been changed', 1, 19, '2017-08-20 18:09:02', 0, NULL),
(20, 1, 20, 'Forgot Password Failed', 'error', 'Forgot Password Failed', 'Your email is not in our database yet,  or you was registered by using social media. Please try to register instead of asking us to remember your password :) ', 1, 20, '2017-08-20 18:09:02', 0, NULL),
(21, 1, 21, 'Invalid Voucher in Progress', 'warning', 'Invalid Voucher', 'This voucher already invalid or out of stock, please input other voucher', 1, 21, '2017-08-31 16:53:45', 0, NULL),
(22, 1, 22, 'Subscribe Success', 'success', 'Subscription Success', 'Thank you for your subscription', 1, 22, '2017-09-12 13:45:49', 1, 'alert_messages'),
(23, 1, 23, 'Subscribe Failed', 'error', 'Subscription Failed', 'Failed to register your email. Please contact our administrator.', 1, 23, '2017-09-12 13:46:06', 1, 'alert_messages'),
(24, 1, 24, 'Subscribe Duplicate', 'warning', 'Duplicate Email Address', 'This email has been used for subscription. Try other email address.', 1, 24, '2017-09-12 13:49:05', 1, 'alert_messages'),
(25, 1, 25, 'Add to Cart Failed Stock', 'error', 'Insufficient stock', 'Please add less amount of item to the shopping cart', 1, 25, '2017-09-12 13:49:47', 1, NULL),
(26, 1, 26, 'Add to Wishlist Success', 'success', 'Item Added to Wishlist', 'Item has been added to your wishlist', 1, 26, '2017-09-12 13:51:15', 1, NULL),
(27, 1, 27, 'Add to Wishlist Failed', 'error', 'Cannot Add Item to Wishlist ', 'Failed to add item to your wishlist', 1, 27, '2017-09-12 13:51:35', 1, NULL),
(28, 1, 28, 'Delete Wishlist Success', 'success', 'Item Removed from Wishlist', 'Item has been removed from your wishlist', 1, 28, '2017-09-12 13:52:06', 1, NULL),
(29, 1, 29, 'Delete Wishlist Failed', 'error', 'Cannot Remove Item from Wishlist ', 'Failed to remove item from your wishlist', 1, 29, '2017-09-12 13:52:31', 1, NULL),
(30, 1, 30, 'Insert Contact Us Success', 'success', 'Message Sent!', 'Your message has been sent. We\'ll contact you back shortly.', 1, 30, '2017-09-12 13:53:24', 1, 'alert_messages'),
(31, 1, 31, 'Insert Contact Us Failed', 'error', 'Message Not Sent', 'Failed to submit your message', 1, 31, '2017-09-12 13:54:38', 1, 'alert_messages'),
(32, 1, 32, 'Insert Compare Success', 'success', 'Item Added to Comparison Page', 'Item has been successfully added to comparison page', 1, 32, '2017-09-12 13:55:28', 1, NULL),
(33, 1, 33, 'Insert Compare Failed', 'error', 'Failed to Add Item', 'Failed to add item to comparison page', 1, 33, '2017-09-12 13:55:51', 1, NULL),
(34, 1, 34, 'Register Success', 'success', 'Register Success!', 'You have successfully registered to our website', 1, 34, '2017-09-12 13:57:26', 1, NULL),
(35, 1, 35, 'Register Failed', 'error', 'Register Failed!', 'There\'s something wrong. Your registration is failed.', 1, 35, '2017-09-12 13:57:56', 1, NULL),
(36, 1, 36, 'Remove Compare Success', 'success', 'Product Remove Success', 'Product Remove Success', 1, 36, '2017-08-20 00:06:16', 1, NULL),
(37, 1, 37, 'Remove Compare Failed', 'error', 'Product Remove Failed', 'Product Remove Failed', 1, 37, '2017-08-20 00:06:16', 1, NULL),
(38, 1, 38, 'Register not Agree', 'error', 'Register not Agree', 'Please indicate that you have read and agree to the Terms and Conditions', 1, 38, '2017-08-20 00:06:16', 1, NULL),
(39, 1, 39, 'Confirmation Delete', 'warning', 'Are you sure?', 'You won\'t be able to revert this!', 1, 39, '2017-09-14 10:39:26', 0, NULL),
(40, 1, 40, 'Checkout Agreement', 'error', 'Agreement Failed', 'Please indicate that you have read and agree to the Terms and Conditions', 1, 40, '2017-09-14 10:39:26', 0, NULL),
(41, 1, 41, 'Redeem Success', 'success', 'Redeem Success', 'Redeem Success', 1, 41, '2017-08-20 00:06:16', 1, NULL),
(42, 1, 42, 'Redeem Failed', 'error', 'Redeem Failed', 'Redeem Failed', 1, 42, '2017-08-20 00:06:16', 1, NULL),
(43, 1, 43, 'Login Success', 'success', 'Welcome Back', 'Enjoy Your visit, let us know if you need anything.', 1, 43, '2017-08-20 00:06:16', 1, NULL),
(44, 1, 44, 'Login Failed', 'error', 'Upss, Try Again', 'Watch your finger mistype the password :)', 1, 44, '2017-08-20 00:06:16', 1, NULL),
(45, 1, 45, 'Logout', 'success', 'See You Again!', 'See you again, don\'t forget to come back', 1, 44, '2017-08-20 00:06:16', 1, NULL),
(46, 1, 46, 'Forgot Password Failed - Socmed\n', 'error', 'Forgot Password Failed', 'We detected that you\'ve been registered via social media channel, reset password is only for manualy registered user. :)', 1, 20, '2017-08-20 18:09:02', 0, NULL),
(47, 1, 47, 'Function not Ready', 'error', 'Upss. Unavailable Functions', 'We are sorry this function is undergoing development.', 1, 48, '2018-07-15 14:22:11', 0, NULL),
(48, 1, 48, 'Add to Wishlist Failed - login', 'error', 'Cannot Add Item to Wishlist ', 'Failed to add item to your wishlist, Please login first :)', 1, 27, '2017-09-12 13:51:35', 1, NULL),
(49, 1, 49, 'Add to Cart Failed Login', 'error', 'Please Login First :)', 'Please login first to add and item to your cart', 1, 25, '2017-09-12 13:49:47', 1, NULL),
(50, 1, 50, 'Download Failed', 'error', 'Download Failed!', 'The file was not found, please try again later or contact the admin', 1, 0, '2018-09-21 16:30:41', 2, 'alert_messages'),
(51, 1, 51, 'Search not Found', 'error', 'The search box is empty', 'Please fill the search box with the page keyword', 1, 0, '2018-08-30 08:45:33', 1, NULL),
(52, 2, 50, 'Download Failed', 'error', 'Download Gagal!', 'File tidak ditemukan. Kontak admin.', 1, 0, '2018-09-21 16:30:41', 2, 'alert_messages'),
(53, 2, 31, 'Insert Contact Us Failed', 'error', 'Pesan Tidak Berhasil Dikirim', 'Pesan gagal dikirim. Silahkan dicoba kembali. ', 1, 31, '2018-09-21 16:59:55', 3, 'alert_messages'),
(54, 2, 30, 'Insert Contact Us Success', 'success', 'Pesan Berhasil Dikirim!', 'Pesan Anda sudah dikirimkan ke admin kami. Admin kami akan menghubungi Anda secepatnya.', 1, 30, '2018-09-21 16:57:26', 3, 'alert_messages'),
(55, 2, 23, 'Subscribe Failed', 'error', 'Gagal Berlangganan', 'Gagal untuk berlangganan. Kontak Admin', 1, 49, '2018-09-21 16:36:39', 2, 'alert_messages'),
(56, 2, 22, 'Subscribe Success', 'success', 'Berhasil Berlangganan', 'Terima kasih telah berlangganan. ', 1, 22, '2018-09-21 16:56:28', 3, 'alert_messages'),
(57, 2, 24, 'Subscribe Duplicate', 'warning', 'Email Sudah Terdaftar', 'Email Anda sudah terdaftar, gunakan email Anda yang lain. ', 1, 24, '2018-09-21 16:56:52', 3, 'alert_messages'),
(59, 2, 59, 'Calculate Failed', 'error', 'Kalkulasi Gagal', 'Anda belum memilih periode perhitungan. ', 1, 2, '2017-09-12 13:34:38', 1, 'alert_messages'),
(60, 1, 59, 'Calculate Failed', 'error', 'Calculate Failed', 'You have not chosen the period. ', 1, 2, '2017-09-12 13:34:38', 1, 'alert_messages'),
(61, 1, 61, 'Form Submit Failed', 'error', 'You have forbidden submission', 'Failed to submit your message. Please try again.', 1, 61, '2019-11-05 13:34:38', 1, 'alert_messages'),
(62, 1, 62, 'Category Not Found', 'error', 'Category is Not Found', 'Unable to find category, please try again or choose other category.', 1, 62, '2018-07-15 14:22:11', 0, NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_contact_inquiry`
--

CREATE TABLE `ngc_contact_inquiry` (
  `id` int(11) UNSIGNED NOT NULL,
  `full_name` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `subject` varchar(50) DEFAULT NULL,
  `message` text,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_email_content`
--

CREATE TABLE `ngc_email_content` (
  `id` int(11) UNSIGNED NOT NULL,
  `lang_id` tinyint(2) DEFAULT NULL,
  `tag` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `subject` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
  `top_text` text CHARACTER SET utf8,
  `bottom_text` text CHARACTER SET utf8,
  `publish` tinyint(1) NOT NULL DEFAULT '1',
  `sortnumber` int(11) DEFAULT '0',
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data untuk tabel `ngc_email_content`
--

INSERT INTO `ngc_email_content` (`id`, `lang_id`, `tag`, `subject`, `title`, `top_text`, `bottom_text`, `publish`, `sortnumber`, `modified_datetime`, `modified_by`) VALUES
(1, 1, 'Notify to Admin - Contact Us', 'New Inquiry from Contact Us!', 'Someone just contacted us!', '<p>Please check CMS, someone just contacted us.</p>\r\n', '<p>Best Regards,</p>\r\n\r\n<p>Taiwan Excellence</p>\r\n', 1, 1, '2020-05-29 15:05:18', 4),
(2, 1, 'Notify to User - Subscribe', 'Thank You for Subscribing Taiwan Excellence Indone', 'Thank you for signing up to our newsletter!', '<p>Welcome to Taiwan Excellence!</p>\r\n\r\n<p>By signing up for our newsletter, you will be the first to get our latest products&nbsp;&amp;&nbsp;events&nbsp;information and exclusive promotion straight to your inbox.&nbsp;</p>\r\n\r\n<p>Explore our Excellence Products from Taiwan and keeping up with our upcoming hot events on our website!</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n', '<p>Best Regards,&nbsp;</p>\r\n\r\n<p><em><strong>TAIWAN EXCELLENCE, EVERYDAY&nbsp;EXCELLENCE</strong></em></p>\r\n', 1, 1, '2020-08-06 18:05:20', 10),
(3, 1, 'Notify to User - Contact Us', 'Thank You for Contacting Taiwan Excellence Homepag', 'Your inquiry has been sent', '<p>Our Excellence team will be in touch with you soon regarding your inquiry&nbsp;</p>\r\n', '<p>Best Regards,</p>\r\n\r\n<p><em><strong>TAIWAN EXCELLENCE, EVERYDAY EXCELLENCE</strong></em></p>\r\n', 1, 1, '2020-08-06 18:06:10', 10),
(4, 1, 'Notify to Admin - Agent Wanted', 'New Inquiry from Agent Wanted!', 'Someone just contacted us', '<p>Please check CMS, someone just contacted us.</p>\r\n', '<p>Best Regards,</p>\r\n\r\n<p>Taiwan Excellence</p>\r\n', 1, 1, '2020-05-29 15:07:11', 4),
(5, 1, 'Notify to User - Agent Wanted', 'Thank You for Sending Your Inquiry to Us!', 'Your inquiry has been sent', '<p>Our Excellence team will be in touch with you soon regarding your inquiry.</p>\r\n', '<p>Best Regards,</p>\r\n\r\n<p><em><strong>TAIWAN EXCELLENCE, EVERYDAY EXCELLENCE&nbsp;</strong></em></p>\r\n', 1, 1, '2020-05-29 15:10:21', 4);

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_global_images`
--

CREATE TABLE `ngc_global_images` (
  `id` int(11) UNSIGNED NOT NULL,
  `img_id` int(11) UNSIGNED NOT NULL,
  `global_post_id` int(11) NOT NULL DEFAULT '0',
  `lang_id` tinyint(2) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `description` varchar(5000) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `image_high` varchar(200) DEFAULT '',
  `link` varchar(200) DEFAULT NULL,
  `link_text` varchar(200) DEFAULT NULL,
  `link_target` varchar(15) DEFAULT NULL,
  `urlpage` varchar(200) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(2) DEFAULT NULL,
  `cms_menu` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_global_posts`
--

CREATE TABLE `ngc_global_posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `post_id` int(20) UNSIGNED NOT NULL,
  `lang_id` smallint(6) NOT NULL,
  `post_date` date NOT NULL,
  `post_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_type` enum('post','page','micro-post') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'micro-post',
  `post_parent` int(10) UNSIGNED NOT NULL,
  `post_title` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `post_subtitle_heading` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_subtitle` text COLLATE utf8mb4_unicode_ci,
  `post_intro_heading` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_intro` text COLLATE utf8mb4_unicode_ci,
  `post_content_heading` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `post_banner_image` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `post_banner_image_high` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_image` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `post_image_high` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_file` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_link` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_link_text` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_link` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `featured` tinyint(1) DEFAULT '0',
  `user_defined` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `urlpage` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `publish` tinyint(1) NOT NULL DEFAULT '1',
  `sortnumber` smallint(6) NOT NULL DEFAULT '0',
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(6) NOT NULL DEFAULT '0',
  `cms_menu` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `ngc_global_posts`
--

INSERT INTO `ngc_global_posts` (`id`, `post_id`, `lang_id`, `post_date`, `post_name`, `post_type`, `post_parent`, `post_title`, `post_subtitle_heading`, `post_subtitle`, `post_intro_heading`, `post_intro`, `post_content_heading`, `content`, `post_banner_image`, `post_banner_image_high`, `post_image`, `post_image_high`, `post_file`, `video_link`, `post_link_text`, `post_link`, `featured`, `user_defined`, `urlpage`, `publish`, `sortnumber`, `modified_datetime`, `modified_by`, `cms_menu`) VALUES
(1, 1, 1, '2019-07-24', '[Label] Search Label', 'micro-post', 0, 'What do you want to search?', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 2, '2019-01-16 11:53:07', 7, 'label'),
(2, 2, 1, '2019-07-25', '[Label] Empty Search Field', 'micro-post', 0, '* This field can\'t be empty', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 1, '2019-01-16 10:57:09', 7, 'label'),
(3, 3, 1, '2019-07-26', '[Label] Change Language', 'micro-post', 0, 'Change Language', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 3, '2019-01-16 10:57:56', 7, 'label'),
(4, 4, 1, '0000-00-00', '[Label] Search Placeholder', 'micro-post', 0, 'Type here......', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 4, '2019-01-16 11:54:08', 7, 'label'),
(5, 5, 1, '0000-00-00', '[Label] Join Our Newsletter', 'micro-post', 0, 'Fixie tote bag ethnic keytar. Neutra vinyl American Apparel kale chips tofu art party, cardigan raw ', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 5, '2019-01-16 13:48:36', 7, 'label'),
(6, 6, 1, '0000-00-00', '[Button] Submit', 'micro-post', 0, 'Submit', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 6, '2019-01-16 13:49:09', 7, 'label'),
(7, 7, 1, '0000-00-00', '[Label] Email Not Valid', 'micro-post', 0, '* This is not a valid email address', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 7, '2019-01-16 13:49:29', 7, 'label'),
(8, 8, 1, '0000-00-00', '[Label] Email Placeholder', 'micro-post', 0, 'Enter email address', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 8, '2019-01-16 13:53:44', 7, 'label'),
(9, 9, 1, '0000-00-00', '[Label] Copyright', 'micro-post', 0, 'Copyright &copy; #date# #company# . All Rights Reserved.', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 9, '2019-01-16 14:09:25', 7, 'label'),
(10, 10, 1, '0000-00-00', '[Label] Office', 'micro-post', 0, 'Office', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 10, '2019-01-16 15:17:51', 7, 'label'),
(11, 11, 1, '0000-00-00', '[Label Follow Us]', 'micro-post', 0, 'Follow Us', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 11, '2019-01-16 14:27:26', 7, 'label'),
(12, 12, 1, '0000-00-00', '[Label] Subject', 'micro-post', 0, 'Subject', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 12, '2019-01-17 09:40:58', 7, 'label'),
(13, 13, 1, '0000-00-00', '[Label] Full Name', 'micro-post', 0, 'Full Name', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 13, '2019-01-17 09:41:19', 7, 'label'),
(14, 14, 1, '0000-00-00', '[Label] Email', 'micro-post', 0, 'Email', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 14, '2019-01-17 09:41:38', 7, 'label'),
(15, 15, 1, '0000-00-00', '[Label] Phone Number', 'micro-post', 0, 'Phone Number', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 15, '2019-01-17 09:41:54', 7, 'label'),
(16, 16, 1, '0000-00-00', '[Label] Message', 'micro-post', 0, 'Message', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 16, '2019-01-17 09:42:05', 7, 'label'),
(17, 17, 1, '0000-00-00', '[Label] Subject', 'micro-post', 0, 'Subject', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 17, '2019-01-17 10:04:18', 7, 'label'),
(18, 18, 1, '0000-00-00', '[Label] Select Your Subject', 'micro-post', 0, 'Select Your Subject', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 18, '2019-01-17 10:15:48', 7, 'label'),
(19, 19, 1, '0000-00-00', '[Label] View Detail', 'micro-post', 0, 'View Detail', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 19, '2019-01-18 10:13:49', 7, 'label'),
(20, 20, 1, '0000-00-00', '[Label] Back to Management', 'micro-post', 0, 'Back to Management', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 20, '2019-01-18 10:45:14', 7, 'label'),
(21, 21, 1, '0000-00-00', '[Label] Date', 'micro-post', 0, 'Date', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 21, '2019-01-18 14:30:29', 7, 'label'),
(22, 22, 1, '0000-00-00', '[Label] Title', 'micro-post', 0, 'Title', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 22, '2019-01-18 14:30:45', 7, 'label'),
(23, 23, 1, '0000-00-00', '[Label] File', 'micro-post', 0, 'File', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 23, '2019-01-18 14:30:58', 7, 'label'),
(24, 24, 1, '0000-00-00', '[Label] Read More', 'micro-post', 0, 'Read More', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 24, '2019-01-21 10:11:43', 7, 'label'),
(25, 25, 1, '0000-00-00', '[Label] Related News & Media', 'micro-post', 0, 'Related News & Media', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 25, '2019-01-21 10:12:09', 7, 'label'),
(26, 26, 1, '0000-00-00', '[Label] More Information', 'micro-post', 0, 'More Information', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 26, '2019-01-21 10:12:28', 7, 'label'),
(27, 27, 1, '0000-00-00', '[Button] Apply', 'micro-post', 0, 'Apply', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 27, '2019-01-21 11:07:11', 7, 'label'),
(28, 28, 1, '0000-00-00', '[Button] Back to Homepage', 'micro-post', 0, 'Back to Homepage', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 28, '2019-01-22 16:56:43', 7, 'label'),
(29, 29, 1, '0000-00-00', '[Label] Result for', 'micro-post', 0, 'Result for', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 29, '2019-01-22 16:57:46', 7, 'label'),
(30, 30, 1, '0000-00-00', '[Label] We have found', 'micro-post', 0, 'We have found', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 30, '2019-01-22 16:58:48', 7, 'label'),
(31, 31, 1, '0000-00-00', '[Label] Result for keywords', 'micro-post', 0, 'results for keyword', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 31, '2019-01-22 16:59:17', 7, 'label'),
(32, 32, 1, '0000-00-00', '[Label] No result for', 'micro-post', 0, 'No result for', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 32, '2019-01-22 17:01:22', 7, 'label'),
(33, 33, 1, '0000-00-00', '[Label] Sorry no result found', 'micro-post', 0, 'Sorry, we can’t find any result for the keyword', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 33, '2019-01-22 17:01:43', 7, 'label'),
(34, 34, 1, '0000-00-00', '[Label] Please try another keyword', 'micro-post', 0, 'Please try another keyword.', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 34, '2019-01-22 17:17:55', 7, 'label'),
(35, 35, 1, '0000-00-00', '[Label] Photo Gallery', 'micro-post', 0, 'Photo Gallery', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 35, '2019-01-24 11:10:59', 7, 'label'),
(36, 36, 1, '0000-00-00', '[Label] VISIT MORE ABOUT', 'micro-post', 0, 'VISIT MORE ABOUT', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 36, '2019-01-25 11:17:10', 7, 'label'),
(37, 37, 1, '0000-00-00', '[Label] Other Products', 'micro-post', 0, 'Other Products', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 37, '2019-01-25 14:27:56', 7, 'label'),
(38, 38, 1, '0000-00-00', '[Label] Other Pages', 'micro-post', 0, 'Other Pages', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 38, '2019-01-25 15:32:50', 7, 'label'),
(39, 39, 1, '2019-03-14', '404 PAGES', 'micro-post', 0, 'Oops! Sorry...', NULL, NULL, NULL, NULL, NULL, '<p>Curabitur lobortis id lorem id bibendum. Ut id consectetur magna. Quisque volutpat augue.</p>\r\n', '', NULL, 'ngc_global_posts/5c89c403345ad_20190314100123-1.png', NULL, NULL, NULL, 'BACK TO HOMEPAGE', '/', 0, NULL, '', 1, 39, '2019-03-14 10:01:23', 3, '404-pages'),
(40, 40, 1, '2019-03-14', '503 PAGES', 'micro-post', 0, 'We\'re Making Few Updates. We\'ll Be Right Back!', NULL, NULL, NULL, NULL, NULL, '<p>Fixie tote bag ethnic keytar. Neutra vinyl Amer.</p>\r\n', '', NULL, 'ngc_global_posts/5c89c46b3e4cb_20190314100307-1.png', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 40, '2019-03-14 10:03:07', 3, '503-pages'),
(41, 41, 1, '2018-10-23', '[Form] Upload Supporting Documents', 'micro-post', 0, 'Upload Supporting Documents', 'What else that we need to know about your event?', NULL, '', NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 41, '0000-00-00 00:00:00', 0, 'form-label'),
(42, 42, 1, '2018-10-23', '[Form] Validation abcval', 'micro-post', 0, '*Input alphabet only', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 42, '0000-00-00 00:00:00', 0, 'form-label'),
(43, 43, 1, '2018-10-23', '[Form] Validation Confirm Password', 'micro-post', 0, '*Confirmation password is different with password', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, 'login', 1, 43, '0000-00-00 00:00:00', 0, 'form-label'),
(44, 44, 1, '2018-10-23', '[Form] Validation Email', 'micro-post', 0, '*Input valid email', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 44, '0000-00-00 00:00:00', 0, 'form-label'),
(45, 45, 1, '2018-10-23', '[Form] Validation Event Date', 'micro-post', 0, '* Not a valid date', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 45, '0000-00-00 00:00:00', 0, 'form-label'),
(46, 46, 1, '2018-10-23', '[Form] Validation Gender', 'micro-post', 0, '*Please check one gender', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 46, '0000-00-00 00:00:00', 0, 'form-label'),
(47, 47, 1, '2018-10-23', '[Form] Validation Max Length', 'micro-post', 0, '*Maximum length ', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 47, '0000-00-00 00:00:00', 0, 'form-label'),
(48, 48, 1, '2018-10-23', '[Form] Validation Min Length', 'micro-post', 0, '*Minimum length ', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 48, '0000-00-00 00:00:00', 0, 'form-label'),
(49, 49, 1, '2018-10-23', '[Form] Validation Required', 'micro-post', 0, '*You must fill this field', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 49, '0000-00-00 00:00:00', 0, 'form-label'),
(50, 50, 1, '2018-10-23', '[Form] Validation Required 2', 'micro-post', 0, '*This field can’t be empty', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 50, '0000-00-00 00:00:00', 0, 'form-label'),
(51, 51, 1, '0000-00-00', '[Label] Max File Size', 'micro-post', 0, '*Maximum file is 2 MB', '', '', '', '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 51, '2019-03-05 17:11:28', 1, 'label'),
(52, 52, 1, '0000-00-00', '[Label] No Item', 'micro-post', 0, 'No Item ', '', NULL, '', '', '', '', '', NULL, '', NULL, NULL, NULL, '', '', 0, '', '', 1, 52, '2019-03-15 16:05:15', 4, 'label'),
(53, 53, 1, '0000-00-00', '[Label] Share:', 'micro-post', 0, 'Share:', NULL, NULL, NULL, '', NULL, '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 53, '2019-01-28 13:22:53', 1, 'label'),
(54, 54, 1, '0000-00-00', '[Label] Download Files', 'micro-post', 0, 'Download Files', NULL, NULL, NULL, '', NULL, '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 54, '2019-03-12 16:02:39', 3, 'label'),
(55, 55, 1, '2018-10-23', '[Form] Address', 'micro-post', 0, 'Address', 'Enter your address', NULL, '', NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 55, '0000-00-00 00:00:00', 0, 'form-label'),
(56, 56, 1, '2018-10-23', '[Form] Apply For', 'micro-post', 0, 'Apply For', 'Choose your desired position', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 56, '0000-00-00 00:00:00', 0, 'form-label'),
(57, 57, 1, '2018-10-23', '[Form] Confirm Change New Password', 'micro-post', 0, 'Confirm New Password', 'Confirm your new password', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 57, '0000-00-00 00:00:00', 0, 'form-label'),
(58, 58, 1, '2018-10-23', '[Form] Confirm Password', 'micro-post', 0, 'Confirm Password', 'Re-type your password', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 58, '0000-00-00 00:00:00', 0, 'form-label'),
(59, 59, 1, '2018-10-23', '[Form] Email', 'micro-post', 0, 'Email', 'Your email', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 59, '2019-03-05 17:27:17', 1, 'form-label'),
(60, 60, 1, '2018-10-23', '[Form] Email Contact Us', 'micro-post', 0, 'Email Address', 'Enter your email address', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 60, '2019-03-05 17:30:30', 1, 'form-label'),
(61, 61, 1, '2018-10-23', '[Form] First Name', 'micro-post', 0, 'First Name', 'Enter your first name', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 61, '2019-03-05 17:26:18', 1, 'form-label'),
(62, 62, 1, '2018-10-23', '[Form] Last Name', 'micro-post', 0, 'Last Name', 'Enter your last name', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 62, '2019-03-05 17:26:40', 1, 'form-label'),
(63, 63, 1, '2018-10-23', '[Form] Message', 'micro-post', 0, 'Message', 'Enter your message', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 63, '0000-00-00 00:00:00', 0, 'form-label'),
(64, 64, 1, '2018-10-23', '[Form] Mobile', 'micro-post', 0, 'Mobile', 'Enter your phone number', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 64, '0000-00-00 00:00:00', 0, 'form-label'),
(65, 65, 1, '2018-10-23', '[Form] Fullname', 'micro-post', 0, 'Fullname', 'Enter your fullname', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 65, '2020-05-13 14:06:13', 1, 'form-label'),
(66, 66, 1, '2018-10-23', '[Form] New Password', 'micro-post', 0, 'New Password', 'Enter your new password', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 66, '0000-00-00 00:00:00', 0, 'form-label'),
(67, 67, 1, '2019-01-22', '[Form] Newsletter Email', 'micro-post', 0, 'Email', 'Enter your email address', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, 'login', 1, 67, '2019-03-05 17:30:53', 1, 'form-label'),
(68, 68, 1, '2018-10-23', '[Form] Upload File', 'micro-post', 0, 'Upload File', 'Upload your project image here', NULL, 'Put your files here...', NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 68, '0000-00-00 00:00:00', 0, 'form-label'),
(69, 69, 1, '2018-10-23', '[Button] Apply', 'micro-post', 0, 'Apply', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 69, '0000-00-00 00:00:00', 0, 'button'),
(70, 70, 1, '2018-10-23', '[Button] Apply Now', 'micro-post', 0, 'APPLY NOW', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 70, '0000-00-00 00:00:00', 0, 'button'),
(71, 71, 1, '2018-07-19', '[Button] Back to Homepage', 'micro-post', 0, 'Back to Homepage', '', '', '', '', '', '', '', NULL, '', NULL, NULL, '.', ',', '', 0, '', '', 1, 71, '2019-01-23 11:08:06', 1, 'button'),
(72, 72, 1, '2018-10-23', '[Button] Cancel', 'micro-post', 0, 'CANCEL', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 72, '0000-00-00 00:00:00', 0, 'button'),
(73, 73, 1, '2018-10-23', '[Button] Change Document', 'micro-post', 0, 'Change Document', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 73, '0000-00-00 00:00:00', 0, 'button'),
(74, 74, 1, '2018-10-23', '[Button] Change File', 'micro-post', 0, 'CHANGE FILE', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 74, '0000-00-00 00:00:00', 0, 'button'),
(75, 75, 1, '2018-10-23', '[Button] Change Password', 'micro-post', 0, 'CHANGE PASSWORD', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 75, '0000-00-00 00:00:00', 0, 'button'),
(76, 76, 1, '2018-10-23', '[Button] Change Photo', 'micro-post', 0, 'CHANGE PHOTO', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 76, '0000-00-00 00:00:00', 0, 'button'),
(77, 77, 1, '2018-10-23', '[Button] Download', 'micro-post', 0, 'DOWNLOAD', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 77, '2019-03-20 10:28:50', 1, 'button'),
(78, 78, 1, '2018-10-23', '[Button] Filter', 'micro-post', 0, 'FILTER', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 78, '0000-00-00 00:00:00', 0, 'button'),
(79, 79, 1, '2018-07-19', '[Button] Home LEARN MORE', 'micro-post', 0, 'LEARN MORE', '', '', '', '', '', '', '', NULL, '', NULL, NULL, '.', ',', '', 0, '', '', 1, 79, '2019-01-23 11:07:53', 1, 'button'),
(80, 80, 1, '2018-07-19', '[Button] Home Login or Register', 'micro-post', 0, 'Login or Register', '', '', '', '', '', '', '', NULL, '', NULL, NULL, '.', ',', ',', 0, '', '', 1, 80, '2018-10-11 10:06:03', 1, 'button'),
(81, 81, 1, '2018-07-19', '[Button] Home MORE INFO', 'micro-post', 0, 'MORE INFORMATION', '', '', '', '', '', '', '', NULL, '', NULL, NULL, '.', ',', '', 0, '', '', 1, 81, '2019-01-23 11:08:06', 1, 'button'),
(82, 82, 1, '2018-10-23', '[Button] Home Submit', 'micro-post', 0, 'SUBMIT', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 82, '0000-00-00 00:00:00', 0, 'button'),
(83, 83, 1, '2018-10-23', '[Button] Register', 'micro-post', 0, 'REGISTER', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 83, '0000-00-00 00:00:00', 0, 'button'),
(84, 84, 1, '2018-10-23', '[Button] Register Now', 'micro-post', 0, 'REGISTER NOW', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 84, '0000-00-00 00:00:00', 0, 'button'),
(85, 85, 1, '2018-10-23', '[Button] Save', 'micro-post', 0, 'Save', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 85, '0000-00-00 00:00:00', 0, 'button'),
(86, 86, 1, '2018-10-23', '[Button] Search', 'micro-post', 0, 'SEARCH', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 86, '0000-00-00 00:00:00', 0, 'button'),
(87, 87, 1, '2018-10-23', '[Button] Sign In', 'micro-post', 0, 'LOG IN', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 87, '0000-00-00 00:00:00', 0, 'button'),
(88, 88, 1, '2018-10-23', '[Button] Sign In FB', 'micro-post', 0, 'SIGN IN WITH FACEBOOK', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 88, '0000-00-00 00:00:00', 0, 'button'),
(89, 89, 1, '2018-10-23', '[Button] Sign In Google', 'micro-post', 0, 'SIGN IN WITH GOOGLE', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 89, '0000-00-00 00:00:00', 0, 'button'),
(90, 90, 1, '2018-10-23', '[Button] Sign In Twitter', 'micro-post', 0, 'SIGN IN WITH TWITTER', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 90, '0000-00-00 00:00:00', 0, 'button'),
(91, 91, 1, '2018-10-23', '[Button] Upload Document', 'micro-post', 0, 'Upload Document', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 91, '0000-00-00 00:00:00', 0, 'button'),
(92, 92, 1, '2018-10-23', '[Button] Upload Photo', 'micro-post', 0, 'UPLOAD PHOTO', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 92, '0000-00-00 00:00:00', 0, 'button'),
(93, 93, 1, '2018-10-23', '[Button] View Detail', 'micro-post', 0, 'View Detail', '', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 93, '0000-00-00 00:00:00', 0, 'button'),
(94, 94, 1, '2018-10-23', '[Label] Search Result', 'micro-post', 0, 'Search Result', '', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 93, '0000-00-00 00:00:00', 0, 'button'),
(95, 95, 1, '2018-10-23', '[Label Filter] Oldest - Newest', 'micro-post', 0, 'Oldest - Newest', '', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 93, '0000-00-00 00:00:00', 0, 'label'),
(96, 96, 1, '2018-10-23', '[Label Filter] Newest - Oldest', 'micro-post', 0, 'Newest - Oldest', '', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 93, '0000-00-00 00:00:00', 0, 'label'),
(97, 97, 1, '2018-10-23', '[Label Filter] A - Z', 'micro-post', 0, 'A - Z', '', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 93, '0000-00-00 00:00:00', 0, 'label'),
(98, 98, 1, '2018-10-23', '[Label Filter] Z - A', 'micro-post', 0, 'Z - A', '', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 93, '0000-00-00 00:00:00', 0, 'label'),
(99, 99, 1, '2018-10-23', '[Label Filter] All Category', 'micro-post', 0, 'All Category', '', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 93, '0000-00-00 00:00:00', 0, 'label'),
(100, 100, 1, '2018-10-23', '[Label Filter] All Sort', 'micro-post', 0, 'All Sort', '', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 93, '0000-00-00 00:00:00', 0, 'label'),
(101, 101, 1, '0000-00-00', '', 'micro-post', 0, 'Stay Connected with Us !', NULL, NULL, NULL, NULL, NULL, '<p>Subscribe and get our latest information, promotion and special events!</p>\r\n', '', NULL, 'ngc_global_posts/5ebb6e4cb8617_20200513104932-1.jpg', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 94, '2020-05-28 17:17:01', 4, 'subscriber-pages'),
(102, 102, 1, '0000-00-00', '', 'micro-post', 0, 'Result for &quot;#keyword#&quot;', 'Search Result', NULL, NULL, '<p class=\"ngc-intro\">We have found <strong class=\"n-primary\">#total# results</strong> for the keyword <strong class=\"n-primary\">&quot;#keyword#&quot;</strong>.</p>\r\n', 'Result for &quot;#searchterm#&quot;', '', '', 'ngc_global_posts/5d2fd0a1f0046_20190718085129-1.jpg', '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 95, '2020-05-13 16:10:41', 1, 'search-result-pages'),
(103, 103, 1, '0000-00-00', '', 'micro-post', 0, 'No Result Found for &quot;#keyword#&quot;', 'Search Result', NULL, NULL, '<p class=\"ngc-intro\">Sorry, we can&#39;t find any result for the keyword <strong>&quot;#keyword#&quot;</strong>. Please try another keyword.</p>\r\n', 'No Result Found for &quot;#searchterm#&quot;', '', '', 'ngc_global_posts/5d2fd0a1f0046_20190718085129-1.jpg', '', NULL, NULL, NULL, 'BACK TO HOMEPAGE', '/', 0, NULL, '', 1, 96, '2020-05-13 16:16:40', 1, 'search-result-pages'),
(104, 104, 1, '0000-00-00', '', 'micro-post', 0, 'Taiwan Excellence', NULL, NULL, NULL, NULL, '', '<p style=\"margin-left:24.0pt; margin:0cm\"><span style=\"font-size:12pt\"><span style=\"line-height:150%\"><span style=\"font-family:Calibri,sans-serif\"><strong><span calibri=\"\" style=\"font-family:\">Taiwan Excellence Offline Store :</span></strong><br />\r\n<strong><span calibri=\"\" style=\"font-family:\">1. Mal Ambassador, Lantai 3 No.62,&nbsp;</span></strong><br />\r\nJl. Prof Doktor Satrio, RT.11/RW.4, Kuningan, Karet Kuningan, Jakarta Selatan, DKI Jakarta 12940 &nbsp;</span></span></span></p>\r\n\r\n<p style=\"margin-left:24.0pt; margin:0cm\"><br />\r\n<span style=\"font-size:12pt\"><span style=\"line-height:150%\"><span style=\"font-family:Calibri,sans-serif\"><strong><span calibri=\"\" style=\"font-family:\">2. Jogjatronik Mall Lt. 2 No. 28, Jogjakarta&nbsp;</span></strong><br />\r\nJl. Brigjen Katamso No.74, Prawirodirjan, Kec. Gondomanan, Kota Yogyakarta 55121</span></span></span></p>\r\n\r\n<p style=\"margin-left:24.0pt; margin:0cm\">&nbsp;</p>\r\n\r\n<p style=\"margin-left:24.0pt; margin:0cm\"><strong><span style=\"font-size:12pt\"><span style=\"line-height:150%\"><span style=\"font-family:Calibri,sans-serif\">3. Taiwan Excellence, Bekasi Cyber Park</span></span></span></strong></p>\r\n\r\n<p style=\"margin-left:24.0pt; margin:0cm\"><span style=\"font-size:12pt\"><span style=\"line-height:150%\"><span style=\"font-family:Calibri,sans-serif\">Lantai 1 Blok B1 No. 06-07, Bekasi - Jawa Barat</span></span></span></p>\r\n', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 97, '2021-04-13 10:32:11', 10, 'footer-intro'),
(105, 105, 1, '0000-00-00', '[Label] Contact Us', 'micro-post', 0, 'Contact Us', NULL, NULL, NULL, NULL, '', '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 98, '2019-05-20 15:55:38', 1, 'form-label'),
(106, 106, 1, '0000-00-00', '[Form] Subject', 'micro-post', 0, 'Select Your Subject', 'Select Your Subject', NULL, NULL, NULL, '', '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 99, '2019-05-20 15:55:38', 1, 'form-label'),
(107, 107, 1, '0000-00-00', '[Form] Google Captcha Required', 'micro-post', 0, 'Captcha has not been checked yet...', 'Google Captcha has not been verified', NULL, NULL, NULL, '', '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, NULL, '', 1, 100, '2019-05-20 15:55:38', 1, 'form-label'),
(108, 108, 1, '0000-00-00', '[Validation Label] Regex Name', 'micro-post', 0, 'Only a-z, A-Z,( . ) , ( , )', '', '', '-', '', NULL, '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 108, '2018-09-21 10:16:49', 1, 'label'),
(109, 109, 1, '0000-00-00', '[Validation Label] Regex Phone', 'micro-post', 0, 'Only 0-9, (), ( - )', '', '', '-', '', NULL, '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 109, '2018-09-21 10:16:49', 1, 'label'),
(110, 110, 1, '0000-00-00', '[Validation Label] Regex Subject ID', 'micro-post', 0, 'Only 0-9', '', '', '-', '', NULL, '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 110, '2018-09-21 10:16:49', 1, 'label'),
(111, 111, 1, '0000-00-00', '[Validation Label] Regex Content Complete', 'micro-post', 0, 'Only a-z, A-Z, 0-9, ( _ ), ( . ) , ( , ), ( - ), ( \' ), (), ( / )', '', '', '-', '', NULL, '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 111, '2018-09-21 10:16:49', 1, 'label'),
(112, 112, 1, '0000-00-00', '[Validation Label] Regex Search ', 'micro-post', 0, 'Only a-z, A-Z, 0-9, ( . ) , ( , ), ( - ), ( / ) ', '', '', '-', '', NULL, '', '', NULL, '', NULL, NULL, NULL, NULL, '', 0, '', '', 1, 112, '2018-09-21 10:16:49', 1, 'label'),
(113, 113, 1, '2019-12-17', '[Validation Label] Regex Date ', 'micro-post', 0, 'Only 0-9, ( \\ ), ( - )', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', 1, 105, '2019-12-17 10:06:16', 1, 'label'),
(114, 114, 1, '2019-12-17', 'popupcontent', 'micro-post', 0, 'Splash Screen popupcontent', '', '', '', '', '', '', 'ngc_global_posts/60940ca38307e_20210506223459-1.jpg', 'ngc_global_posts/60940ca38b516_20210506223459-2.jpg', 'ngc_global_posts/default_image.png', 'ngc_global_posts/default_image.png', '', '', '', '', 0, '', '', 0, 106, '2021-05-06 22:35:01', 12, 'splashscreen-popupcontent');

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_global_posts_relation`
--

CREATE TABLE `ngc_global_posts_relation` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `assigned_post_id` int(11) NOT NULL,
  `publish` tinyint(1) NOT NULL,
  `cms_menu` varchar(200) NOT NULL,
  `sortnumber` int(11) NOT NULL,
  `modified_by` tinyint(1) NOT NULL,
  `modified_datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_global_posts_taxo`
--

CREATE TABLE `ngc_global_posts_taxo` (
  `id` int(11) UNSIGNED NOT NULL,
  `term_id` bigint(20) DEFAULT NULL,
  `taxo` varchar(32) DEFAULT NULL,
  `description` longtext,
  `parent` bigint(20) DEFAULT '0',
  `count` bigint(20) DEFAULT '0',
  `publish` tinyint(1) DEFAULT '1',
  `sortnumber` bigint(20) DEFAULT '0',
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(2) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_global_posts_terms`
--

CREATE TABLE `ngc_global_posts_terms` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `group` bigint(10) DEFAULT '0',
  `publish` tinyint(1) DEFAULT '1',
  `sortnumber` int(11) DEFAULT '0',
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(2) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_global_posts_term_relation`
--

CREATE TABLE `ngc_global_posts_term_relation` (
  `id` int(11) UNSIGNED NOT NULL,
  `post_id` bigint(20) DEFAULT NULL,
  `term_taxo_id` bigint(20) DEFAULT NULL,
  `term_order` int(11) DEFAULT '0',
  `publish` tinyint(1) DEFAULT '1',
  `sortnumber` bigint(20) DEFAULT '0',
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(2) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_languages`
--

CREATE TABLE `ngc_languages` (
  `id` int(10) UNSIGNED NOT NULL,
  `language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url_slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` tinyint(1) NOT NULL DEFAULT '1',
  `sortnumber` smallint(6) NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `ngc_languages`
--

INSERT INTO `ngc_languages` (`id`, `language`, `url_slug`, `image`, `publish`, `sortnumber`, `modified_datetime`, `modified_by`) VALUES
(1, 'english', 'en', 'ngc_languages/5eba3fa178edc_20200512131809-1.png', 1, 1, '2020-05-12 13:18:09', 1),
(2, 'bahasa indonesia', 'id', 'ngc_languages/5eba3fa83f4ce_20200512131816-1.png', 1, 2, '2020-05-12 13:18:16', 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item`
--

CREATE TABLE `ngc_master_item` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `item_group` varchar(200) DEFAULT NULL,
  `item_matrix_id` tinyint(5) DEFAULT '0',
  `item_brand_id` tinyint(2) DEFAULT NULL,
  `item_status` smallint(2) DEFAULT NULL,
  `short_description` text,
  `description` text,
  `price` int(11) UNSIGNED NOT NULL,
  `special_price` int(11) UNSIGNED NOT NULL,
  `image` varchar(200) DEFAULT NULL,
  `image_high` varchar(200) DEFAULT NULL,
  `rating` tinyint(2) DEFAULT NULL,
  `video_link` varchar(200) DEFAULT NULL,
  `urlpage` varchar(200) DEFAULT NULL,
  `featured` tinyint(1) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item_brand`
--

CREATE TABLE `ngc_master_item_brand` (
  `id` int(11) UNSIGNED NOT NULL,
  `matchcode` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` text,
  `image` varchar(200) DEFAULT NULL,
  `urlpage` varchar(50) DEFAULT NULL,
  `featured` tinyint(1) DEFAULT '0',
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item_group`
--

CREATE TABLE `ngc_master_item_group` (
  `id` int(11) UNSIGNED NOT NULL,
  `matchcode` varchar(255) DEFAULT NULL,
  `parent_id` varchar(200) DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  `description` varchar(5000) DEFAULT NULL,
  `featured` tinyint(1) DEFAULT '0',
  `in_nav_link` tinyint(1) DEFAULT '1',
  `image` varchar(200) DEFAULT NULL,
  `urlpage` varchar(50) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item_images`
--

CREATE TABLE `ngc_master_item_images` (
  `id` int(11) UNSIGNED NOT NULL,
  `item_id` int(5) DEFAULT NULL,
  `Name` varchar(200) DEFAULT NULL,
  `image` varchar(400) DEFAULT NULL,
  `image_high` varchar(400) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item_matrix`
--

CREATE TABLE `ngc_master_item_matrix` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `dim0` varchar(100) NOT NULL,
  `dim1` varchar(100) NOT NULL,
  `dim2` varchar(100) NOT NULL,
  `publish` tinyint(1) NOT NULL,
  `sortnumber` int(10) NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item_matrix_detail`
--

CREATE TABLE `ngc_master_item_matrix_detail` (
  `id` int(11) NOT NULL,
  `id_matrix` int(11) DEFAULT NULL,
  `id_dim` int(11) DEFAULT '0',
  `dim_value` varchar(200) DEFAULT '',
  `dim_hex_color` varchar(45) DEFAULT '',
  `publish` tinyint(4) DEFAULT '1',
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item_status`
--

CREATE TABLE `ngc_master_item_status` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `description` varchar(5000) DEFAULT '',
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(5) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item_storage`
--

CREATE TABLE `ngc_master_item_storage` (
  `id` int(11) UNSIGNED NOT NULL,
  `matchcode` varchar(30) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `description` varchar(5000) DEFAULT NULL,
  `address` varchar(5000) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `location` varchar(70) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `price_area` varchar(30) DEFAULT NULL,
  `master_storage` tinyint(1) DEFAULT '0',
  `timezone` varchar(50) NOT NULL,
  `open_time` time NOT NULL,
  `close_time` time NOT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_item_variant`
--

CREATE TABLE `ngc_master_item_variant` (
  `id` int(11) UNSIGNED NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `id_master_product` int(11) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `filter_val` varchar(100) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `stock` int(11) NOT NULL,
  `image` varchar(200) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_master_product`
--

CREATE TABLE `ngc_master_product` (
  `id` int(11) NOT NULL,
  `product_code` varchar(100) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `publish` tinyint(1) NOT NULL,
  `sortnumber` int(11) NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_navigation`
--

CREATE TABLE `ngc_navigation` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nav_id` int(20) UNSIGNED NOT NULL,
  `lang_id` smallint(6) NOT NULL,
  `parent_nav` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mega_menu` tinyint(1) NOT NULL,
  `sub_menu` tinyint(1) NOT NULL DEFAULT '0',
  `params` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taxo_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dynamic_child` tinyint(1) DEFAULT NULL,
  `publish` tinyint(1) NOT NULL DEFAULT '1',
  `sortnumber` int(11) NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(6) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `ngc_navigation`
--

INSERT INTO `ngc_navigation` (`id`, `nav_id`, `lang_id`, `parent_nav`, `title`, `text`, `url`, `mega_menu`, `sub_menu`, `params`, `taxo_name`, `dynamic_child`, `publish`, `sortnumber`, `modified_datetime`, `modified_by`) VALUES
(1, 1, 1, 0, 'Header Nav', 'Header Nav', '', 0, 0, '', NULL, NULL, 1, 1, '2019-04-10 16:50:07', 3),
(2, 2, 1, 0, 'Sitemap', 'Sitemap', '', 0, 0, '', NULL, NULL, 1, 2, '2019-04-10 16:50:07', 3),
(3, 3, 1, 0, 'Business Nav', 'Business Nav', '', 0, 0, '', NULL, NULL, 1, 3, '2019-04-10 16:50:07', 3),
(4, 4, 1, 0, 'Sidebar Nav', 'Sidebar Nav', '', 0, 0, '', NULL, NULL, 1, 4, '2019-04-10 16:50:07', 3),
(5, 5, 1, 0, 'Account Nav', 'Account Nav', '', 0, 0, '', '', NULL, 1, 5, '2019-04-18 14:29:26', 1),
(6, 6, 1, 0, 'Product Nav', 'Product Nav', '', 0, 0, '', '', 1, 1, 6, '2019-04-18 14:29:26', 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_routes`
--

CREATE TABLE `ngc_routes` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  `id_type` int(11) UNSIGNED DEFAULT NULL,
  `primary_menu_id` int(11) UNSIGNED DEFAULT NULL,
  `dependant_menu` varchar(300) NOT NULL,
  `main_post_id` int(11) UNSIGNED DEFAULT NULL,
  `parent` int(11) UNSIGNED DEFAULT NULL,
  `full_path` varchar(200) DEFAULT NULL,
  `navigation` varchar(255) DEFAULT NULL,
  `self_navigation` varchar(255) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_routes_views`
--

CREATE TABLE `ngc_routes_views` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `view` varchar(200) DEFAULT NULL,
  `image_preview` varchar(200) DEFAULT NULL,
  `section_taxo` varchar(200) DEFAULT NULL,
  `static_label` varchar(200) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_routes_views_custom`
--

CREATE TABLE `ngc_routes_views_custom` (
  `id` int(11) NOT NULL,
  `routes_views_id` int(11) DEFAULT NULL,
  `keyword` varchar(200) NOT NULL,
  `custom_table_name` varchar(200) NOT NULL,
  `menu_admin_url` varchar(1000) NOT NULL,
  `menu_admin_custom_url` varchar(500) NOT NULL,
  `add_ons_url` varchar(1000) NOT NULL,
  `publish` tinyint(1) NOT NULL,
  `cms_menu` varchar(200) NOT NULL,
  `sortnumber` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL,
  `modified_datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_routes_views_details`
--

CREATE TABLE `ngc_routes_views_details` (
  `id` int(11) UNSIGNED NOT NULL,
  `routes_views_id` int(11) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `keyword` varchar(200) DEFAULT NULL,
  `page_type` enum('Single','List') DEFAULT NULL,
  `post_type` enum('micro-post','post','page') DEFAULT NULL,
  `excluded_view_field` varchar(2000) DEFAULT NULL,
  `excluded_input_field` varchar(2000) DEFAULT NULL,
  `excluded_input_validation` varchar(2000) DEFAULT NULL,
  `recommended_img_size` varchar(255) NOT NULL,
  `taxo` tinyint(1) DEFAULT '0',
  `pagination_item` int(11) DEFAULT '0',
  `sortnumber` int(3) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `cms_menu` varchar(255) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_seo`
--

CREATE TABLE `ngc_seo` (
  `id` int(11) UNSIGNED NOT NULL,
  `page_url` varchar(3000) DEFAULT NULL,
  `post_id` int(11) NOT NULL,
  `title` varchar(160) DEFAULT 'PT ANTAM Tbk',
  `description` varchar(300) DEFAULT 'ANTAM is a vertically integrated, export-oriented, diversified mining and metals company that spread troughout mineral-rich Indonesian archipelago',
  `keywords` varchar(1000) DEFAULT 'antam,antam gold,logam mulia,tambang,emas,mining investment,mining',
  `publish` tinyint(1) DEFAULT '1',
  `sortnumber` int(11) DEFAULT '0',
  `og_image` varchar(200) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_sliders`
--

CREATE TABLE `ngc_sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `post_id` int(11) DEFAULT NULL,
  `lang_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_title` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slider_content` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_desktop` varchar(2000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_mobile` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(4000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` tinyint(1) NOT NULL DEFAULT '1',
  `sortnumber` int(11) NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ngc_subscribers`
--

CREATE TABLE `ngc_subscribers` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `register_date` datetime NOT NULL,
  `publish` tinyint(1) NOT NULL DEFAULT '1',
  `sortnumber` int(11) NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `users`
--

CREATE TABLE `users` (
  `id` int(11) UNSIGNED NOT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `mobile_phone` varchar(14) DEFAULT NULL,
  `identity_number` varchar(15) DEFAULT NULL,
  `tax_number` varchar(20) DEFAULT '',
  `password` varchar(200) DEFAULT NULL,
  `remember_token` varchar(200) DEFAULT NULL,
  `provider` varchar(50) DEFAULT NULL,
  `provider_id` varchar(50) DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` tinyint(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktur dari tabel `user_activities`
--

CREATE TABLE `user_activities` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `activity_time` datetime NOT NULL,
  `action` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `data` text COLLATE utf8_unicode_ci NOT NULL,
  `result` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `publish` tinyint(1) NOT NULL DEFAULT '1',
  `sortnumber` int(11) NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `web_config`
--

CREATE TABLE `web_config` (
  `id` tinyint(1) NOT NULL,
  `inquiry_email` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `support_email` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `phone` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `whatsapp` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `company` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `name` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `store_operational` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `address` varchar(8000) COLLATE latin1_general_ci NOT NULL,
  `facebook_link` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `youtube_link` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `instagram_link` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `twitter_link` varchar(200) COLLATE latin1_general_ci DEFAULT NULL,
  `linkedin_link` varchar(200) COLLATE latin1_general_ci DEFAULT NULL,
  `google_analytic` varchar(8000) COLLATE latin1_general_ci NOT NULL,
  `google_map_url` varchar(8000) COLLATE latin1_general_ci NOT NULL,
  `google_map_title` varchar(200) COLLATE latin1_general_ci DEFAULT NULL,
  `google_map_lat` varchar(200) COLLATE latin1_general_ci DEFAULT NULL,
  `google_map_lng` varchar(200) COLLATE latin1_general_ci DEFAULT NULL,
  `logo_image` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `logo_image_2` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `favicon_image` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `logo_image_footer` varchar(200) COLLATE latin1_general_ci DEFAULT NULL,
  `logo_image_footer_2` varchar(200) COLLATE latin1_general_ci DEFAULT NULL,
  `captcha_key` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `mailchimp_list_id` varchar(40) COLLATE latin1_general_ci DEFAULT NULL,
  `maintenance_mode` tinyint(1) DEFAULT '0',
  `whitelist_ip` varchar(5000) COLLATE latin1_general_ci DEFAULT NULL,
  `publish` tinyint(1) DEFAULT NULL,
  `sortnumber` int(1) NOT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data untuk tabel `web_config`
--

INSERT INTO `web_config` (`id`, `inquiry_email`, `support_email`, `phone`, `whatsapp`, `company`, `name`, `store_operational`, `address`, `facebook_link`, `youtube_link`, `instagram_link`, `twitter_link`, `linkedin_link`, `google_analytic`, `google_map_url`, `google_map_title`, `google_map_lat`, `google_map_lng`, `logo_image`, `logo_image_2`, `favicon_image`, `logo_image_footer`, `logo_image_footer_2`, `captcha_key`, `mailchimp_list_id`, `maintenance_mode`, `whitelist_ip`, `publish`, `sortnumber`, `modified_datetime`, `modified_by`) VALUES
(1, 'contac@nukegraphic.com', 'support@nukegraphic.com', '+622129009553', '08161478119', 'Nukegraphic Indonesia', 'Nukegraphic Indonesia', '-', 'Ruko Golden 8 Blok D/28-29, Summarecon Serpong', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 1, 1, '2021-01-19 16:42:55', 11);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `0pti0n_s3tt1ng`
--
ALTER TABLE `0pti0n_s3tt1ng`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `1001ti14_vi3w2014`
--
ALTER TABLE `1001ti14_vi3w2014`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `admin_notification`
--
ALTER TABLE `admin_notification`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `admin_notification_user`
--
ALTER TABLE `admin_notification_user`
  ADD PRIMARY KEY (`id_notification`,`id_admin`);

--
-- Indeks untuk tabel `log_admin`
--
ALTER TABLE `log_admin`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `m3nu_4dm1n`
--
ALTER TABLE `m3nu_4dm1n`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `master_privilege`
--
ALTER TABLE `master_privilege`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_alert_messages`
--
ALTER TABLE `ngc_alert_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_contact_inquiry`
--
ALTER TABLE `ngc_contact_inquiry`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_email_content`
--
ALTER TABLE `ngc_email_content`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_global_images`
--
ALTER TABLE `ngc_global_images`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_global_posts`
--
ALTER TABLE `ngc_global_posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ngc_global_posts_post_type_publish_post_date_id_index` (`post_type`,`publish`,`post_date`,`id`),
  ADD KEY `ngc_global_posts_post_parent_index` (`post_parent`),
  ADD KEY `post_id` (`post_id`);

--
-- Indeks untuk tabel `ngc_global_posts_relation`
--
ALTER TABLE `ngc_global_posts_relation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `post_id` (`post_id`);

--
-- Indeks untuk tabel `ngc_global_posts_taxo`
--
ALTER TABLE `ngc_global_posts_taxo`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `term_id_taxo` (`term_id`,`taxo`),
  ADD KEY `taxo` (`taxo`);

--
-- Indeks untuk tabel `ngc_global_posts_terms`
--
ALTER TABLE `ngc_global_posts_terms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `name` (`name`);

--
-- Indeks untuk tabel `ngc_global_posts_term_relation`
--
ALTER TABLE `ngc_global_posts_term_relation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `term_taxo_id` (`term_taxo_id`);

--
-- Indeks untuk tabel `ngc_languages`
--
ALTER TABLE `ngc_languages`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_master_item`
--
ALTER TABLE `ngc_master_item`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_master_item_brand`
--
ALTER TABLE `ngc_master_item_brand`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `match_code` (`matchcode`);

--
-- Indeks untuk tabel `ngc_master_item_group`
--
ALTER TABLE `ngc_master_item_group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `match_code` (`matchcode`);

--
-- Indeks untuk tabel `ngc_master_item_images`
--
ALTER TABLE `ngc_master_item_images`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_master_item_matrix`
--
ALTER TABLE `ngc_master_item_matrix`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_master_item_matrix_detail`
--
ALTER TABLE `ngc_master_item_matrix_detail`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_master_item_status`
--
ALTER TABLE `ngc_master_item_status`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_master_item_storage`
--
ALTER TABLE `ngc_master_item_storage`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `matchcode` (`matchcode`);

--
-- Indeks untuk tabel `ngc_master_item_variant`
--
ALTER TABLE `ngc_master_item_variant`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_master_product`
--
ALTER TABLE `ngc_master_product`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_navigation`
--
ALTER TABLE `ngc_navigation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ngc_global_posts_post_type_publish_post_date_id_index` (`publish`,`id`),
  ADD KEY `ngc_global_posts_post_parent_index` (`parent_nav`),
  ADD KEY `post_id` (`nav_id`);

--
-- Indeks untuk tabel `ngc_routes`
--
ALTER TABLE `ngc_routes`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_routes_views`
--
ALTER TABLE `ngc_routes_views`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_routes_views_custom`
--
ALTER TABLE `ngc_routes_views_custom`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_routes_views_details`
--
ALTER TABLE `ngc_routes_views_details`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_seo`
--
ALTER TABLE `ngc_seo`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_sliders`
--
ALTER TABLE `ngc_sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ngc_subscribers`
--
ALTER TABLE `ngc_subscribers`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indeks untuk tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `user_activities`
--
ALTER TABLE `user_activities`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `web_config`
--
ALTER TABLE `web_config`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `0pti0n_s3tt1ng`
--
ALTER TABLE `0pti0n_s3tt1ng`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT untuk tabel `1001ti14_vi3w2014`
--
ALTER TABLE `1001ti14_vi3w2014`
  MODIFY `id` mediumint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT untuk tabel `admin_notification`
--
ALTER TABLE `admin_notification`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `log_admin`
--
ALTER TABLE `log_admin`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `m3nu_4dm1n`
--
ALTER TABLE `m3nu_4dm1n`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=139;

--
-- AUTO_INCREMENT untuk tabel `master_privilege`
--
ALTER TABLE `master_privilege`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT untuk tabel `ngc_alert_messages`
--
ALTER TABLE `ngc_alert_messages`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT untuk tabel `ngc_contact_inquiry`
--
ALTER TABLE `ngc_contact_inquiry`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_email_content`
--
ALTER TABLE `ngc_email_content`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `ngc_global_images`
--
ALTER TABLE `ngc_global_images`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_global_posts`
--
ALTER TABLE `ngc_global_posts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115;

--
-- AUTO_INCREMENT untuk tabel `ngc_global_posts_relation`
--
ALTER TABLE `ngc_global_posts_relation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_global_posts_taxo`
--
ALTER TABLE `ngc_global_posts_taxo`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_global_posts_terms`
--
ALTER TABLE `ngc_global_posts_terms`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_global_posts_term_relation`
--
ALTER TABLE `ngc_global_posts_term_relation`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_languages`
--
ALTER TABLE `ngc_languages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item`
--
ALTER TABLE `ngc_master_item`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item_brand`
--
ALTER TABLE `ngc_master_item_brand`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item_group`
--
ALTER TABLE `ngc_master_item_group`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item_images`
--
ALTER TABLE `ngc_master_item_images`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item_matrix`
--
ALTER TABLE `ngc_master_item_matrix`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item_matrix_detail`
--
ALTER TABLE `ngc_master_item_matrix_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item_status`
--
ALTER TABLE `ngc_master_item_status`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item_storage`
--
ALTER TABLE `ngc_master_item_storage`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_item_variant`
--
ALTER TABLE `ngc_master_item_variant`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_master_product`
--
ALTER TABLE `ngc_master_product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_navigation`
--
ALTER TABLE `ngc_navigation`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `ngc_routes`
--
ALTER TABLE `ngc_routes`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_routes_views`
--
ALTER TABLE `ngc_routes_views`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_routes_views_custom`
--
ALTER TABLE `ngc_routes_views_custom`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_routes_views_details`
--
ALTER TABLE `ngc_routes_views_details`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_seo`
--
ALTER TABLE `ngc_seo`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_sliders`
--
ALTER TABLE `ngc_sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `ngc_subscribers`
--
ALTER TABLE `ngc_subscribers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `user_activities`
--
ALTER TABLE `user_activities`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `web_config`
--
ALTER TABLE `web_config`
  MODIFY `id` tinyint(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

