QuBq0VUX

1drop database if exists mazlikovia;
2create database if not exists mazlikovia;
3use mazlikovia;
4create table if not exists osoba (
5  idO BIGINT NOT NULL PRIMARY KEY auto_increment,
6  meno VARCHAR(15)
7  );
8create table if not exists klobuk (
9  idK bigint not null primary key auto_increment,
10  typ varchar(15),
11  farba varchar(10),
12  idO bigint,
13  CONSTRAINT FKidO FOREIGN KEY (idO) REFERENCES osoba (idO)
14  );
15create table if not exists mazlik (
16  idM bigint not null primary key auto_increment,
17  meno varchar(15),
18  druh varchar(10)
19  );
20create table if not exists cip (
21  datum datetime,
22  idM bigint unique,
23  CONSTRAINT FKidM FOREIGN KEY (idM) REFERENCES mazlik (idM)
24  );
25  
26create table if not exists adopcia (
27	idO bigint,
28    idM bigint,
29    datum datetime,
30    CONSTRAINT FKidOa FOREIGN KEY (idO) REFERENCES osoba (idO),
31    CONSTRAINT FKidMa FOREIGN KEY (idM) REFERENCES mazlik (idM)
32    );
33  
34insert osoba(meno) values ("Romeo");
35ALTER TABLE osoba add COLUMN vztah bigint unique;
36ALTER TABLE osoba ADD CONSTRAINT FKvztah FOREIGN KEY (vztah) REFERENCES osoba(idO);
37insert osoba(meno,vztah) values("Julia", 1);
38SET SQL_SAFE_UPDATES = 1;
39update osoba set vztah =2 where idO = 1 and idO !=2;
40select * from osoba;