Hrxw8L5Z

1-- phpMyAdmin SQL Dump
2-- version 4.6.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Dec 14, 2016 at 01:05 PM
7-- Server version: 5.6.33
8-- PHP Version: 7.0.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `main`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `tag`
21--
22
23DROP TABLE IF EXISTS `tag`;
24CREATE TABLE `tag` (
25  `id` int(10) UNSIGNED NOT NULL,
26  `questionId` int(11) NOT NULL,
27  `tagValueId` int(11) NOT NULL,
28  `dateCreated` datetime NOT NULL
29) ENGINE=InnoDB DEFAULT CHARSET=utf8;
30
31--
32-- Dumping data for table `tag`
33--
34
35INSERT INTO `tag` (`id`, `questionId`, `tagValueId`, `dateCreated`) VALUES
36(1, 9, 4, '2016-12-13 21:14:41'),
37(2, 10, 4, '2016-12-13 21:14:41'),
38(3, 9, 10, '2016-12-13 21:16:28'),
39(4, 9, 11, '2016-12-13 21:16:28'),
40(5, 11, 21, '2016-12-13 21:19:17'),
41(6, 10, 21, '2016-12-13 21:19:17'),
42(7, 9, 21, '2016-12-13 21:19:17'),
43(8, 8, 21, '2016-12-13 21:19:17'),
44(9, 2, 21, '2016-12-13 21:19:17'),
45(10, 2, 16, '2016-12-13 21:19:17'),
46(11, 8, 16, '2016-12-13 21:19:17'),
47(12, 9, 16, '2016-12-13 21:19:17'),
48(13, 10, 16, '2016-12-13 21:19:17');
49
50--
51-- Indexes for dumped tables
52--
53
54--
55-- Indexes for table `tag`
56--
57ALTER TABLE `tag`
58  ADD PRIMARY KEY (`id`);
59
60--
61-- AUTO_INCREMENT for dumped tables
62--
63
64--
65-- AUTO_INCREMENT for table `tag`
66--
67ALTER TABLE `tag`
68  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;