   `site_name` varchar(200) DEFAULT NULL,
   `site_moto` varchar(200) DEFAULT NULL,
   `site_description` text,
+  `site_address` text NOT NULL,
+  `site_contact` varchar(40) NOT NULL,
+  `site_email` varchar(200) NOT NULL,
   `site_logo` text,
   `update_at` varchar(45) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- phpMyAdmin SQL Dump
-- version 4.4.15.8
-- https://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 04, 2017 at 02:06 AM
-- Server version: 5.6.31
-- PHP Version: 7.0.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `site_name`, `site_moto`, `site_description`, `site_address`, `site_contact`, `site_email`, `site_logo`, `update_at`) VALUES
(0, 'Depousaha.com', 'moto', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 'Lowokwaru, Malang. ', '089623131213', 'depousaha@gmail.com', 'TnDQXS.png', '25-06-2017 0505:0606');

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

--
-- Table structure for table `site_socmed`
--

CREATE TABLE IF NOT EXISTS `site_socmed` (
  `id` int(11) NOT NULL,
  `role` char(1) NOT NULL DEFAULT 'A',
  `socmed_id` int(11) NOT NULL,
  `url` text NOT NULL,
  `update_at` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `site_socmed`
--

INSERT INTO `site_socmed` (`id`, `role`, `socmed_id`, `url`, `update_at`) VALUES
(10, 'A', 1, 'fb.com', '25-06-2017 05:06'),
(11, 'A', 2, 'tw.com', '25-06-2017 05:06'),
(12, 'A', 3, 'ig.com', '25-06-2017 05:06'),
(13, 'A', 4, 'ytb.com', '25-06-2017 05:06');

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

--
-- Table structure for table `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `image` text NOT NULL,
  `update_at` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `name`, `image`, `update_at`) VALUES
(1, 'test3', 'QnT4be.png', '20-06-2017 08:06'),
(2, 'Test Slider', 'wxTKW2.png', '20-06-2017 08:06'),
(3, 'Test Slider', 'iK4SZR.jpg', '20-06-2017 08:06');

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

--
-- Table structure for table `socmed`
--

CREATE TABLE IF NOT EXISTS `socmed` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `logo` text NOT NULL,
  `icon` varchar(40) NOT NULL,
  `update_at` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `socmed`
--

INSERT INTO `socmed` (`id`, `name`, `logo`, `icon`, `update_at`) VALUES
(1, 'facebook', 'cv6FKu.png', 'fa fa-facebook', '24-06-2017 06:06'),
(2, 'twitter', 'SkJwwn.PNG', 'fa fa-twitter', '24-06-2017 06:06'),
(3, 'instagram', 'MKBXln.png', 'fa fa-instagram', '24-06-2017 06:06'),
(4, 'youtube', 'fkY0F8.png', 'fa fa-youtube', '24-06-2017 06:06');

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

--
-- Table structure for table `testimoni`
--

CREATE TABLE IF NOT EXISTS `testimoni` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `comment` text NOT NULL,
  `image` text NOT NULL,
  `update_at` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimoni`
--

INSERT INTO `testimoni` (`id`, `name`, `comment`, `image`, `update_at`) VALUES
(1, 'Facebook', 'pinter', 'i1SpAM.png', '14-06-2017 04:06'),
(2, 'Merchant x', 'oke123', '', '20-06-2017 07:06'),
(3, 'TOtok', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '', '20-06-2017 08:06');

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

