qTEiPCD9

1-- Adminer 3.2.2 MySQL dump
2
3SET NAMES utf8;
4SET foreign_key_checks = 0;
5SET time_zone = 'SYSTEM';
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `movie`;
9CREATE TABLE `movie` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `title` varchar(100) COLLATE utf8_czech_ci NOT NULL,
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
14
15
16DROP TABLE IF EXISTS `rating`;
17CREATE TABLE `rating` (
18  `user_id` int(11) NOT NULL,
19  `movie_id` int(11) NOT NULL,
20  `rating` tinyint(4) NOT NULL,
21  UNIQUE KEY `user_id` (`user_id`,`movie_id`),
22  KEY `movie_id` (`movie_id`),
23  CONSTRAINT `rating_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
24  CONSTRAINT `rating_ibfk_2` FOREIGN KEY (`movie_id`) REFERENCES `movie` (`id`) ON DELETE CASCADE
25) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
26
27
28DROP TABLE IF EXISTS `user`;
29CREATE TABLE `user` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `name` varchar(100) COLLATE utf8_czech_ci NOT NULL,
32  `password` char(32) COLLATE utf8_czech_ci NOT NULL,
33  `created` datetime NOT NULL,
34  PRIMARY KEY (`id`),
35  UNIQUE KEY `name` (`name`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
37
38
39-- 2012-06-15 13:32:03