Item_data_product

-- phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 20, 2017 at 12:07 PM
-- Server version: 5.6.14
-- PHP Version: 5.5.6

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

--
-- Database: `scring`
--

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

--
-- Table structure for table `item_data_product`
--

CREATE TABLE IF NOT EXISTS `item_data_product` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `id_user_shop` int(20) DEFAULT NULL,
  `item_type` text,
  `item_name` varchar(30) DEFAULT NULL,
  `price` int(15) NOT NULL,
  `total_price` int(100) DEFAULT NULL,
  `type_price` varchar(5) DEFAULT NULL,
  `weight` int(10) NOT NULL,
  `type_weight` varchar(15) DEFAULT NULL,
  `condition` varchar(10) DEFAULT NULL,
  `information` text,
  `note` varchar(100) DEFAULT NULL,
  `qty` int(100) DEFAULT NULL,
  `minimum` int(15) NOT NULL,
  `stock_item` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `item_data_product`
--

INSERT 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
(7, 8, 'Laptop & Accessorie', 'Electronik', 393939, NULL, 'Rupia', 90, 'kilogram', 'new', 'Bembeng jualan', NULL, 0, 1, 10),
(1, 8, 'Moslem Fashion', 'Baju cewe lebaran', 1234, NULL, 'Rupia', 10, 'gram', 'new', 'Baju ukuran apa aja ada', NULL, 0, 1, 10),
(2, 8, 'Moslem Fashion', 'Baju muslim cwe', 12124, NULL, 'Rupia', 12, 'gram', 'new', 'ukuran apa aja ada', NULL, 0, 1, 10),
(3, 8, 'Female Fashion', 'Baju cewe keren', 1245, NULL, 'Rupia', 10, 'gram', 'new', 'ukuran apa aja ada ', NULL, 0, 1, 5),
(4, 8, 'Female Fashion', 'Baju  cewe sexy', 9855, NULL, 'Rupia', 10, 'gram', 'new', 'ukuran apa aja ada ', NULL, 0, 1, 10),
(5, 8, 'Female Fashion', 'Baju cewe fashionable', 7890, NULL, 'Rupia', 3, 'gram', 'new', 'ukuran apa aja ada', NULL, 0, 1, 12);