Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE aktor (
- aktor_id INT NOT NULL AUTO_INCREMENT,
- imie VARCHAR(45) NULL,
- nazwisko VARCHAR(45) NULL,
- PRIMARY KEY(aktor_id)
- );
- CREATE TABLE film (
- film_id INT NOT NULL AUTO_INCREMENT,
- kategoria_id INT NULL,
- tytul VARCHAR(255) NULL,
- rok DATE NULL,
- PRIMARY KEY(film_id),
- INDEX film_FKIndex1(kategoria_id)
- );
- CREATE TABLE film_has_aktor (
- film_id INT NOT NULL,
- aktor_id INT NOT NULL,
- PRIMARY KEY(film_id, aktor_id),
- INDEX film_has_aktor_FKIndex1(film_id),
- INDEX film_has_aktor_FKIndex2(aktor_id)
- );
- CREATE TABLE kategoria (
- kategoria_id INT NOT NULL AUTO_INCREMENT,
- nazwa VARCHAR(255) NULL,
- PRIMARY KEY(kategoria_id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement