sBr3erCS

1DROP DATABASE IF EXISTS `kontakty`;
2CREATE SCHEMA IF NOT EXISTS `kontakty`;
3CREATE TABLE `klient` (
4	pk_id_klient INT(2) AUTO_INCREMENT PRIMARY KEY,
5    imie VARCHAR(25),
6    nazwisko VARCHAR(25));
7CREATE TABLE `kontakt`(
8	pk_numer_tel INT(9) PRIMARY KEY,
9    fk_id_klient INT(2));
10ALTER TABLE `kontakt`
11ADD FOREIGN KEY (`fk_id_klient`) REFERENCES `klient`(`pk_id_klient`);