xmall_user_shop

-- phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Inang: localhost
-- Waktu pembuatan: 18 Jan 2018 pada 06.14
-- Versi Server: 5.6.14
-- Versi PHP: 5.5.6

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

--
-- Basis data: `scring`
--

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

--
-- Struktur dari tabel `user_shop`
--

CREATE TABLE IF NOT EXISTS `xmall_user_shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` varchar(120) NOT NULL,
  `shop_name` varchar(120) NOT NULL,
  `description` varchar(120) NOT NULL,
  `tagline` varchar(120) NOT NULL,
  `photo` varchar(120) DEFAULT NULL,
  `courier_origin` varchar(120) NOT NULL,
  `post_code` varchar(120) NOT NULL,
  `pickup_address` varchar(120) DEFAULT NULL,
  `delivery_service1` tinyint(1) DEFAULT NULL,
  `delivery_service2` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data untuk tabel `xmall_user_shop`
--

INSERT INTO `xmall_user_shop` (`id`, `id_user`, `shop_name`, `description`, `tagline`, `photo`, `courier_origin`, `post_code`, `pickup_address`, `delivery_service1`, `delivery_service2`) VALUES
(8, '005bbd52113c0ce302a3e3bdcd0418ff', 'Bembeng', 'Jualan motor', 'Motor kridit', '1513072267457.jpg', 'Bekasi', '838_8_8', 'Kp kambing utara', 1, 1);