-- 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;



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

--
-- 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;



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

--
-- 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;



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

--
-- 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;

