FcWunxs0

1/*
2 Navicat MySQL Data Transfer
3
4 Source Server         : local mysql
5 Source Server Version : 50519
6 Source Host           : localhost
7 Source Database       : hamsters
8
9 Target Server Version : 50519
10 File Encoding         : utf-8
11
12 Date: 05/21/2012 22:04:40 PM
13*/
14
15SET NAMES utf8;
16SET FOREIGN_KEY_CHECKS = 0;
17
18-- ----------------------------
19--  Table structure for `hamsters`
20-- ----------------------------
21DROP TABLE IF EXISTS `hamsters`;
22CREATE TABLE `hamsters` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `name` varchar(255) NOT NULL,
25  PRIMARY KEY (`id`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27
28-- ----------------------------
29--  Table structure for `weights`
30-- ----------------------------
31DROP TABLE IF EXISTS `weights`;
32CREATE TABLE `weights` (
33  `id` int(11) NOT NULL,
34  `weight` int(11) NOT NULL,
35  PRIMARY KEY (`id`),
36  CONSTRAINT `hamster_fk` FOREIGN KEY (`id`) REFERENCES `hamsters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38
39SET FOREIGN_KEY_CHECKS = 1;