Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET NAMES utf8;
- SET foreign_key_checks = 0;
- SET time_zone = '+02:00';
- SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
- CREATE TABLE `question` (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) COLLATE utf8_czech_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
- INSERT INTO `question` (`id`, `name`) VALUES
- (1, 'First question'),
- (2, 'Second question'),
- (3, 'Third question');
- CREATE TABLE `vote` (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `question_id` INT(10) UNSIGNED NOT NULL,
- `value` tinyint(4) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `question_id` (`question_id`),
- CONSTRAINT `vote_ibfk_2` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
- INSERT INTO `vote` (`id`, `question_id`, `value`) VALUES
- (1, 1, 1),
- (2, 1, 1),
- (3, 1, -1),
- (4, 2, -1),
- (5, 2, -1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement