RX7294Bc

1-- =============================================================================
2-- Diagram Name: Noname2
3-- Created on: 27/10/2011 02:43:49 p.m.
4-- Diagram Version: 
5-- =============================================================================
6SET FOREIGN_KEY_CHECKS=0;
7
8-- Drop table Table_01
9DROP TABLE IF EXISTS `Table_01`;
10
11CREATE TABLE `Table_01` (
12  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
13  `xxx` varchar(50),
14  PRIMARY KEY(`id`)
15)
16ENGINE=INNODB;
17
18-- Drop table Table_02
19DROP TABLE IF EXISTS `Table_02`;
20
21CREATE TABLE `Table_02` (
22  `ffff` varchar(50),
23  `id_FK` int(11) UNSIGNED NOT NULL DEFAULT '0',
24  CONSTRAINT `Ref_01` FOREIGN KEY (`id_FK`)
25    REFERENCES `Table_01`(`id`)
26    ON DELETE CASCADE
27    ON UPDATE CASCADE
28)
29ENGINE=INNODB;
30
31SET FOREIGN_KEY_CHECKS=1;