text: /*
  SQLyog Ultimate v8.8 
  MySQL - 5.7.26 : Database - gebang
  *********************************************************************
  */
  
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  -- CREATE DATABASE /*!32312 IF NOT EXISTS*/`gebang` /*!40100 DEFAULT CHARACTER SET latin1 */;
  
  -- USE `gebang`;
  
  /*Table structure for table `about` */
  
  DROP TABLE IF EXISTS `about`;
  
  CREATE TABLE `about` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `about` text,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  /*Table structure for table `blogs` */
  
  DROP TABLE IF EXISTS `blogs`;
  
  CREATE TABLE `blogs` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(255) DEFAULT NULL,
    `content` text,
    `id_user` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  /*Table structure for table `configurations` */
  
  DROP TABLE IF EXISTS `configurations`;
  
  CREATE TABLE `configurations` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(255) NOT NULL,
    `short_title` varchar(255) NOT NULL,
    `image` text NOT NULL,
    `address` text NOT NULL,
    `telp` varchar(15) NOT NULL,
    `email` varchar(255) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  /*Table structure for table `contacts` */
  
  DROP TABLE IF EXISTS `contacts`;
  
  CREATE TABLE `contacts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `email` varchar(100) DEFAULT NULL,
    `telp` varchar(20) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  /*Table structure for table `galleries` */
  
  DROP TABLE IF EXISTS `galleries`;
  
  CREATE TABLE `galleries` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(255) DEFAULT NULL,
    `image` varchar(255) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
  
  /*Table structure for table `intro` */
  
  DROP TABLE IF EXISTS `intro`;
  
  CREATE TABLE `intro` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `intro` text,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  /*Table structure for table `logs` */
  
  DROP TABLE IF EXISTS `logs`;
  
  CREATE TABLE `logs` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_user` int(11) DEFAULT NULL,
    `ip` varchar(15) DEFAULT NULL,
    `user_agent` varchar(255) DEFAULT NULL,
    `url` varchar(255) DEFAULT NULL,
    `jenis` varchar(50) DEFAULT NULL,
    `jenis_data` varchar(255) DEFAULT NULL,
    `keterangan` text,
    `is_success` int(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
  
  /*Table structure for table `products` */
  
  DROP TABLE IF EXISTS `products`;
  
  CREATE TABLE `products` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(255) DEFAULT NULL,
    `description` text,
    `image` varchar(255) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  /*Table structure for table `users` */
  
  DROP TABLE IF EXISTS `users`;
  
  CREATE TABLE `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL DEFAULT 'UNIQUE',
    `username` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `image` text,
    `role` tinyint(1) NOT NULL COMMENT '1 = admin 0 = user',
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `unique_username` (`username`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  /*Data for the table `configurations` */
  
  insert  into `configurations`(`id`,`title`,`short_title`,`image`,`address`,`telp`,`email`,`created_at`,`updated_at`) values (1,'Website Gebang','Gebang Berkreasi','logo.png','Gebang, Girisuko','0274123456446','admin_gebang@gmail.com','2020-05-05 09:31:59','2020-05-05 02:31:59');
  
  /*Data for the table `users` */
  
  insert  into `users`(`id`,`name`,`email`,`username`,`password`,`image`,`role`,`created_at`,`updated_at`) values (1,'Administrator','admin_gebang@gmail.com','admin','$2y$10$OIz1w2FhRbPgevbMZM/NsOjSdMww.8jjuK.y8bBD9Mu7T.tuQKEoO','a1.jpg',1,'2020-05-06 04:12:49','2020-05-05 21:12:49'),(3,'Lulu','lulu@lulu.com','lulu','$2y$10$e73.Ekk9SYAsCpW78l3k.egUi/OKUTbvIBi01U/4zDNaEZiRykd0K','a6.jpg',0,'2020-05-06 06:02:26','2020-05-05 21:12:39');
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  