2q8Z58YC

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.10
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 `item_data_product`
21--
22
23CREATE TABLE IF NOT EXISTS `item_data_product` (
24  `id` int(10) NOT NULL AUTO_INCREMENT,
25  `id_user_shop` int(20) DEFAULT NULL,
26  `item_type` text,
27  `item_name` varchar(30) DEFAULT NULL,
28  `price` int(15) NOT NULL,
29  `total_price` int(100) DEFAULT NULL,
30  `type_price` varchar(5) DEFAULT NULL,
31  `weight` int(10) NOT NULL,
32  `type_weight` varchar(15) DEFAULT NULL,
33  `condition` varchar(10) DEFAULT NULL,
34  `information` text,
35  `note` varchar(100) DEFAULT NULL,
36  `qty` int(100) DEFAULT NULL,
37  `minimum` int(15) NOT NULL,
38  `stock_item` int(10) NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
41
42--
43-- Dumping data untuk tabel `xmall_item_product`
44--
45
46INSERT INTO `item_data_product` (`id`, `id_user_shop`, `item_type`, `item_name`, `price`, `total_price`, `type_price`, `weight`, `type_weight`, `condition`, `information`, `note`, `qty`, `minimum`, `stock_item`) VALUES
47(7, 8, 'Laptop & Accessorie', 'Electronik', 393939, NULL, 'Rupia', 90, 'kilogram', 'new', 'Bembeng jualan', NULL, 0, 1, 10),
48(1, 8, 'Moslem Fashion', 'Baju cewe lebaran', 1234, NULL, 'Rupia', 10, 'gram', 'new', 'Baju ukuran apa aja ada', NULL, 0, 1, 10),
49(2, 8, 'Moslem Fashion', 'Baju muslim cwe', 12124, NULL, 'Rupia', 12, 'gram', 'new', 'ukuran apa aja ada', NULL, 0, 1, 10),
50(3, 8, 'Female Fashion', 'Baju cewe keren', 1245, NULL, 'Rupia', 10, 'gram', 'new', 'ukuran apa aja ada ', NULL, 0, 1, 5),
51(4, 8, 'Female Fashion', 'Baju  cewe sexy', 9855, NULL, 'Rupia', 10, 'gram', 'new', 'ukuran apa aja ada ', NULL, 0, 1, 10),
52(5, 8, 'Female Fashion', 'Baju cewe fashionable', 7890, NULL, 'Rupia', 3, 'gram', 'new', 'ukuran apa aja ada', NULL, 0, 1, 12);