Wb6xyrg4

1ALTER TABLE sira_no 
2    ADD CONSTRAINT METAL_KODU FOREIGN KEY(METAL_KODU) 
3    REFERENCES metal_kod(METAL_KODU) 
4    ON DELETE SET NULL 
5    ON UPDATE SET NULL ;
6	
7Error Code: 1005. Can't create table 'ebs.#sql-f48_1a3' (errno: 150)
8	
9CREATE INDEX METAL_KODU_INDEX ON metal_kod (METAL_KODU);
10	
11METAL_KODU  varchar(4)  NO  PRI     
12DURUM   bit(1)  NO          
13METAL_ISMI  varchar(30) NO          
14AYAR_YOGUNLUK   smallint(6) YES     100
15	
16SET FOREIGN_KEY_CHECKS=0;
17	
18CREATE TABLE IF NOT EXISTS `country` (`id` INT(11) NOT NULL AUTO_INCREMENT,...) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8;
19	
20ALTER TABLE `Window` ADD CONSTRAINT `Windows_ibfk_1` FOREIGN KEY (`WallId`) REFERENCES `Wall` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
21	
22CREATE TABLE IF NOT EXISTS `tablename` (
23  `key` bigint(20) NOT NULL AUTO_INCREMENT,
24  FOREIGN KEY `key` (`key`) REFERENCES `othertable`(`id`)
25) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
26	
27ALTER TABLE `users` ADD FOREIGN KEY (country_id) REFERENCES country (id);
28	
29ALTER TABLE `users` ADD FOREIGN KEY (country_id) REFERENCES countries (id);
30	
31CREATE TABLE employees(
32id_empl INT UNSIGNED NOT NULL AUTO_INCREMENT,
33PRIMARY KEY(id)
34);
35CREATE TABLE offices(
36id_office INT UNSIGNED NOT NULL AUTO_INCREMENT,
37id_empl INT UNSIGNED NOT NULL,
38PRIMARY KEY(id),
39CONSTRAINT `constraint1` FOREIGN KEY (`id_empl`) REFERENCES `employees` (`id_empl`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='my offices';