· 8 years ago · Dec 18, 2017, 04:34 AM
1-- phpMyAdmin SQL Dump
2-- version 3.2.4
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 18, 2017 at 05:30 AM
7-- Server version: 5.1.41
8-- PHP Version: 5.3.1
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Database: `scring`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Table structure for table `item_data_product`
20--
21
22CREATE TABLE IF NOT EXISTS `item_data_product` (
23 `id` int(10) NOT NULL AUTO_INCREMENT,
24 `id_user` varchar(220) DEFAULT NULL,
25 `item_type` text,
26 `item_name` varchar(30) DEFAULT NULL,
27 `price` int(15) NOT NULL,
28 `type_price` varchar(5) DEFAULT NULL,
29 `weight` int(10) NOT NULL,
30 `type_weight` varchar(15) DEFAULT NULL,
31 `condition` varchar(10) DEFAULT NULL,
32 `information` text,
33 `minimum` int(15) NOT NULL,
34 `stock_item` int(10) NOT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
37
38--
39-- Dumping data for table `item_data_product`
40--
41
42INSERT INTO `item_data_product` (`id`, `id_user`, `item_type`, `item_name`, `price`, `type_price`, `weight`, `type_weight`, `condition`, `information`, `minimum`, `stock_item`) VALUES
43(7, '005bbd52113c0ce302a3e3bdcd0418ff', 'Laptop & Accessorie', 'Electronik', 393939, 'Rupia', 90, 'kilogram', 'new', 'Bembeng jualan', 1, 0);