CREATE DATABASE Lekcja;
USE Lekcja;
CREATE TABLE Logowanie
(
	id int AUTO_INCREMENT NOT NULL,
    nick varchar(25) NOT NULL,
    haslo varchar(25) NOT NULL,
    e_mail varchar(30) NOT NULL,
    PRIMARY KEY(id)
) ENGINE=INNODB CHARSET=utf-8_unicode_ci;

CREATE TABLE Dane
(
	id int AUTO_INCREMENT NOT NULL,
    wojewudztwo varchar(35) NOT NULL,
    kraj varchar(25) NOT NULL,
    pesel int(9) NOT NULL,
    data_ur DATE NOT NULL,
    id int,
    PRIMARY KEY(id_Dane),
    FOREIGN KEY (id) REFERENCES logowanie(id)
    )
ENGINE=INNODB CHARSET=utf-8_unicode_ci;

CREATE TABLE ulubione
(
	id_ulubione int AUTO_INCREMENT NOT NULL,
    kolor varchar(35) NOT NULL,
    film varchar(25) NOT NULL,
    muzyka varchar(30) NOT NULL,
    id int,
    PRIMARY KEY(id_ulubione),
    FOREIGN KEY(id)REFERENCES logowanie(id)
    )
ENGINE=INNODB CHARSET=utf-8_unicode_ci;

INSERT INTO Logowanie(nick,haslo,e_mail)
VALUES('Konrad','Taki','[email protected]');

INSERT INTO dane(wojewudztwo,kraj,pesel,data_ur,id)
VALUES('Podkarpacie','Polska','987654321','1999','1');

INSERT INTO ulubione(kolor,film,muzyka,id)
VALUES('Czerwony','Nie_mam','mam','1');