5SacLKfp

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:07 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 `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 for table `item_data_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);