pwLskrYL

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               10.4.6-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win64
5-- HeidiSQL Version:             10.2.0.5599
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table posts.post
15CREATE TABLE IF NOT EXISTS `post` (
16  `id` int(11) NOT NULL AUTO_INCREMENT,
17  `title` varchar(255) NOT NULL DEFAULT '0',
18  `description` text DEFAULT '0',
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
21
22-- Dumping data for table posts.post: ~0 rows (approximately)
23/*!40000 ALTER TABLE `post` DISABLE KEYS */;
24INSERT INTO `post` (`id`, `title`, `description`) VALUES
25	(1, 'Post 1', 'Desription 1'),
26	(2, 'Post 2', 'Descroption 2'),
27	(3, 'Post 3', 'Description 3');
28/*!40000 ALTER TABLE `post` ENABLE KEYS */;
29
30-- Dumping structure for table posts.tag
31CREATE TABLE IF NOT EXISTS `tag` (
32  `id` int(11) NOT NULL AUTO_INCREMENT,
33  `name` varchar(50) NOT NULL DEFAULT 'tag',
34  PRIMARY KEY (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
36
37-- Dumping data for table posts.tag: ~0 rows (approximately)
38/*!40000 ALTER TABLE `tag` DISABLE KEYS */;
39INSERT INTO `tag` (`id`, `name`) VALUES
40	(1, 'Tag 1'),
41	(2, 'Tag 2'),
42	(3, 'Tag 3'),
43	(4, 'Teg 4');
44/*!40000 ALTER TABLE `tag` ENABLE KEYS */;
45
46-- Dumping structure for table posts.xref
47CREATE TABLE IF NOT EXISTS `xref` (
48  `id` int(11) NOT NULL AUTO_INCREMENT,
49  `post_id` int(11) NOT NULL,
50  `tag_id` int(11) NOT NULL,
51  PRIMARY KEY (`id`),
52  KEY `FK_xref_post` (`post_id`),
53  KEY `FK_xref_tag` (`tag_id`),
54  CONSTRAINT `FK_xref_post` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
55  CONSTRAINT `FK_xref_tag` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
56) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
57
58-- Dumping data for table posts.xref: ~0 rows (approximately)
59/*!40000 ALTER TABLE `xref` DISABLE KEYS */;
60INSERT INTO `xref` (`id`, `post_id`, `tag_id`) VALUES
61	(1, 1, 1),
62	(3, 1, 2),
63	(4, 1, 3),
64	(6, 2, 4),
65	(7, 3, 3),
66	(8, 3, 4);
67/*!40000 ALTER TABLE `xref` ENABLE KEYS */;
68
69/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
70/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
71/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;