Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Adminer 3.6.1 MySQL dump
- SET NAMES utf8;
- SET foreign_key_checks = 0;
- SET time_zone = 'SYSTEM';
- SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
- DROP TABLE IF EXISTS `article`;
- CREATE TABLE `article` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `author` INT(11) NOT NULL,
- `text` text COLLATE utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`id`),
- KEY `author` (`author`),
- CONSTRAINT `article_ibfk_1` FOREIGN KEY (`author`) REFERENCES `user` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- INSERT INTO `article` (`id`, `author`, `text`) VALUES
- (1, 1, 'Text 1'),
- (2, 1, 'Text 2'),
- (3, 2, 'Text 3');
- DROP TABLE IF EXISTS `comment`;
- CREATE TABLE `comment` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `author` INT(11) NOT NULL,
- `article` INT(11) NOT NULL,
- `text` text COLLATE utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`id`),
- KEY `author` (`author`),
- KEY `article` (`article`),
- CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`author`) REFERENCES `user` (`id`),
- CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`article`) REFERENCES `article` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- INSERT INTO `comment` (`id`, `author`, `article`, `text`) VALUES
- (1, 1, 1, 'Comment 1'),
- (2, 1, 1, 'Comment 2'),
- (3, 2, 1, 'Comment 3'),
- (4, 1, 2, 'Comment 4'),
- (5, 2, 2, 'Comment 5'),
- (6, 2, 3, 'Comment 6');
- DROP TABLE IF EXISTS `user`;
- CREATE TABLE `user` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- INSERT INTO `user` (`id`, `name`) VALUES
- (1, 'Xaver'),
- (2, 'Edmund');
- -- 2012-12-11 14:18:00
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement