xmall_item_detail

-- phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Inang: localhost
-- Waktu pembuatan: 18 Jan 2018 pada 06.10
-- Versi Server: 5.6.14
-- Versi PHP: 5.5.6

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

--
-- Basis data: `scring`
--

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

--
-- Struktur dari tabel `xmall_item_detail`
--

CREATE TABLE IF NOT EXISTS `xmall_item_detail` (
  `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 untuk tabel `xmall_item_product`
--

INSERT INTO `xmall_item_detail` (`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);