Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `owners` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `firstName` VARCHAR(30) NOT NULL, `lastName` VARCHAR(30) NOT NULL, PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
- INSERT INTO `owners` (`id`, `firstName`, `lastName`) VALUES (1, 'grant', 'carlisle'),
- (2, 'john', 'thoma'),
- (3, 'james', 'brown'),
- (4, 'joe', 'bloggs');
- CREATE TABLE IF NOT EXISTS `pets` (
- `id` INT(11) NOT NULL AUTO_INCREMENT, `ownerId` INT(11) NOT NULL,
- `petTypeId` INT(11) NOT NULL,
- `age` INT(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
- INSERT INTO `pets` (`id`, `ownerId`, `petTypeId`, `age`) VALUES (1, 1, 2, 2),
- (2, 2, 2, 2),
- (3, 1, 2, 3),
- (4, 3, 2, 1), (5, 3, 3, 20), (6, 1, 4, 1), (7, 4, 2, 2), (8, 4, 2, 3);
- CREATE TABLE IF NOT EXISTS `petTypes` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(30) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
- INSERT INTO `petTypes` (`id`, `name`) VALUES (1, 'dog'),
- (2, 'cat'),
- (3, 'hamster'),
- (4, 'horse'),
- (5, 'snake'),
- (6, 'guinea pig');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement