yMG2S6B2

1-- phpMyAdmin SQL Dump
2-- version 4.0.9
3-- http://www.phpmyadmin.net
4--
5-- Inang: localhost
6-- Waktu pembuatan: 18 Jan 2018 pada 06.14
7-- Versi Server: 5.6.14
8-- Versi PHP: 5.5.6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Basis data: `scring`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Struktur dari tabel `user_shop`
21--
22
23CREATE TABLE IF NOT EXISTS `user_shop` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `id_user` varchar(120) NOT NULL,
26  `shop_name` varchar(120) NOT NULL,
27  `description` varchar(120) NOT NULL,
28  `tagline` varchar(120) NOT NULL,
29  `photo` varchar(120) DEFAULT NULL,
30  `courier_origin` varchar(120) NOT NULL,
31  `post_code` varchar(120) NOT NULL,
32  `pickup_address` varchar(120) DEFAULT NULL,
33  `delivery_service1` tinyint(1) DEFAULT NULL,
34  `delivery_service2` tinyint(1) DEFAULT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
37
38--
39-- Dumping data untuk tabel `xmall_user_shop`
40--
41
42INSERT INTO `user_shop` (`id`, `id_user`, `shop_name`, `description`, `tagline`, `photo`, `courier_origin`, `post_code`, `pickup_address`, `delivery_service1`, `delivery_service2`) VALUES
43(8, '005bbd52113c0ce302a3e3bdcd0418ff', 'Bembeng', 'Jualan motor', 'Motor kridit', '1513072267457.jpg', 'Bekasi', '838_8_8', 'Kp kambing utara', 1, 1);