text: #
  # TABLE STRUCTURE FOR: dynamic_menu
  #
  
  DROP TABLE IF EXISTS `dynamic_menu`;
  
  CREATE TABLE `dynamic_menu` (
    `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `title` varchar(100) NOT NULL DEFAULT '',
    `url` varchar(100) NOT NULL DEFAULT '',
    `menu_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `status` tinyint(1) DEFAULT '1',
    `level` tinyint(1) DEFAULT NULL,
    `icon` varchar(100) DEFAULT NULL,
    `description` varchar(150) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  #
  # TABLE STRUCTURE FOR: groups
  #
  
  DROP TABLE IF EXISTS `groups`;
  
  CREATE TABLE `groups` (
    `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(20) NOT NULL,
    `description` varchar(100) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  INSERT INTO `groups` (`id`, `name`, `description`) VALUES ('1', 'admin', 'Administrator');
  INSERT INTO `groups` (`id`, `name`, `description`) VALUES ('2', 'members', 'General User');
  INSERT INTO `groups` (`id`, `name`, `description`) VALUES ('3', 'IT-Support', 'IT-Support');
  
  
  #
  # TABLE STRUCTURE FOR: login_attempts
  #
  
  DROP TABLE IF EXISTS `login_attempts`;
  
  CREATE TABLE `login_attempts` (
    `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    `ip_address` varchar(16) NOT NULL,
    `login` varchar(100) DEFAULT NULL,
    `time` int(11) unsigned DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  #
  # TABLE STRUCTURE FOR: migrations
  #
  
  DROP TABLE IF EXISTS `migrations`;
  
  CREATE TABLE `migrations` (
    `version` bigint(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `migrations` (`version`) VALUES ('20170202131929');
  
  
  #
  # TABLE STRUCTURE FOR: plugin_module
  #
  
  DROP TABLE IF EXISTS `plugin_module`;
  
  CREATE TABLE `plugin_module` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name_modules` varchar(100) NOT NULL,
    `status_modules` int(1) NOT NULL,
    `plug_id_dynamic_menu` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
  
  INSERT INTO `plugin_module` (`id`, `name_modules`, `status_modules`, `plug_id_dynamic_menu`) VALUES ('23', 'welcome', '1', '0');
  INSERT INTO `plugin_module` (`id`, `name_modules`, `status_modules`, `plug_id_dynamic_menu`) VALUES ('24', 'users', '1', '0');
  
  
  #
  # TABLE STRUCTURE FOR: posts
  #
  
  DROP TABLE IF EXISTS `posts`;
  
  CREATE TABLE `posts` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `body` text COLLATE utf8_unicode_ci NOT NULL,
    `created_at_post` date NOT NULL,
    `Penulis` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  #
  # TABLE STRUCTURE FOR: products
  #
  
  DROP TABLE IF EXISTS `products`;
  
  CREATE TABLE `products` (
    `id_product` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name_product` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `details` text COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id_product`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  #
  # TABLE STRUCTURE FOR: test
  #
  
  DROP TABLE IF EXISTS `test`;
  
  CREATE TABLE `test` (
    `blog_id` int(5) unsigned NOT NULL AUTO_INCREMENT,
    `blog_title` varchar(100) NOT NULL,
    `blog_description` text,
    PRIMARY KEY (`blog_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  #
  # TABLE STRUCTURE FOR: users
  #
  
  DROP TABLE IF EXISTS `users`;
  
  CREATE TABLE `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `username` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
    `jabatan` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  