· 8 years ago · Dec 20, 2017, 11:10 AM
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:08 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 `xproduct_item_tags`
21--
22
23CREATE TABLE IF NOT EXISTS `xproduct_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 for table `xproduct_item_tags`
32--
33
34INSERT INTO `xproduct_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);