· 8 years ago · Dec 20, 2017, 11:08 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.9
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 20, 2017 at 12:05 PM
7-- Server version: 5.6.14
8-- PHP Version: 5.5.6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `scring`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `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 for table `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);