· 10 years ago · Sep 26, 2016, 08:12 AM
1create table if not exists
2`VoedingsSchema`.`VoedingsTussen`
3(
4 `Item_id` INT NOT NULL auto_increment comment 'id item',
5
6 constraint `fkVoedingsSchema_Item`
7 foreign key (`idItem`)
8 references `VoedingsSchema`.`VoedinsItems` (`Item_id`)
9 on delete cascade
10 on update cascade
11);
12
13
14
15
16
17create table if not exists
18`VoedingsSchema`.`Dieren`
19(
20 `idDieren` INT NOT NULL auto_increment comment 'id dier',
21 primary key (`idDieren`)
22);