· 8 years ago · Jan 18, 2018, 05:34 AM
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.31
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 `xmall_item_tags`
21--
22
23CREATE TABLE IF NOT EXISTS `xmall_item_tags` (
24 `id` int(50) NOT NULL AUTO_INCREMENT,
25 `id_item` int(50) DEFAULT NULL,
26 `id_category` int(50) DEFAULT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
29
30--
31-- Dumping data untuk tabel `xproduct_item_tags`
32--
33
34INSERT INTO `xmall_item_tags` (`id`, `id_item`, `id_category`) VALUES
35(1, 1, 3),
36(2, 2, 3),
37(3, 3, 1),
38(4, 4, 1),
39(5, 5, 1),
40(6, 7, 14);