daily pastebin goal
41%
SHARE
TWEET

Untitled

a guest Dec 10th, 2018 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE aktor (
  2.   aktor_id INT NOT NULL AUTO_INCREMENT,
  3.   imie VARCHAR(45) NULL,
  4.   nazwisko VARCHAR(45) NULL,
  5.   PRIMARY KEY(aktor_id)
  6. );
  7.  
  8. CREATE TABLE film (
  9.   film_id INT NOT NULL AUTO_INCREMENT,
  10.   kategoria_id INT NULL,
  11.   tytul VARCHAR(255) NULL,
  12.   rok DATE NULL,
  13.   PRIMARY KEY(film_id),
  14.   INDEX film_FKIndex1(kategoria_id)
  15. );
  16.  
  17. CREATE TABLE film_has_aktor (
  18.   film_id INT NOT NULL,
  19.   aktor_id INT NOT NULL,
  20.   PRIMARY KEY(film_id, aktor_id),
  21.   INDEX film_has_aktor_FKIndex1(film_id),
  22.   INDEX film_has_aktor_FKIndex2(aktor_id)
  23. );
  24.  
  25. CREATE TABLE kategoria (
  26.   kategoria_id INT NOT NULL AUTO_INCREMENT,
  27.   nazwa VARCHAR(255) NULL,
  28.   PRIMARY KEY(kategoria_id)
  29. );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top