File: test_25_1.sql

package info (click to toggle)
mysql-gui-tools 5.0r12-1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 105,540 kB
  • ctags: 50,897
  • sloc: sql: 348,439; pascal: 285,780; cpp: 94,578; ansic: 90,768; objc: 33,761; sh: 25,629; xml: 10,924; yacc: 10,755; java: 9,986; php: 2,806; python: 2,068; makefile: 1,945; perl: 3
file content (19 lines) | stat: -rw-r--r-- 929 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 

CREATE DATABASE IF NOT EXISTS `ma_tests` /*!40100 DEFAULT CHARACTER SET utf8 */;
CREATE DATABASE IF NOT EXISTS `ma_tests2` /*!40100 DEFAULT CHARACTER SET utf8 */;

DROP TABLE IF EXISTS `ma_tests`.`r`;
DROP TABLE IF EXISTS `ma_tests`.`f`;
DROP TABLE IF EXISTS `ma_tests2`.`r2`;


CREATE TABLE `ma_tests`.`r` (`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `ma_tests2`.`r2` (`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `ma_tests`.`f` (`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, 
	`rid` INTEGER UNSIGNED NOT NULL,  
	`r2id` INTEGER UNSIGNED NOT NULL,  
	PRIMARY KEY(`id`),  
	CONSTRAINT `FK_f_1` FOREIGN KEY `FK_f_1` (`rid`)    REFERENCES `r` (`id`), 
	CONSTRAINT `FK_f_2` FOREIGN KEY `FK_f_2` (`r2id`)    REFERENCES `ma_tests2`.`r2` (`id`)
) ENGINE = InnoDB;