API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 19th, 2017
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 47.16 KB | None | 0 0
raw download clone embed print report
  1. --------------------------------------------------------
  2. --  File created - poniedziałek-czerwca-19-2017  
  3. --------------------------------------------------------
  4. --------------------------------------------------------
  5. --  DDL for Table CZYTELNIK
  6. --------------------------------------------------------
  7.  
  8.   CREATE TABLE "OMBD_L1617_ZOLICH"."CZYTELNIK"
  9.    (    "ID_CZYTELNIK" NUMBER(5,0),
  10.     "NAZWISKO" VARCHAR2(50 BYTE),
  11.     "IMIE" VARCHAR2(50 BYTE)
  12.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  13.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  14.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  15.   TABLESPACE "USERS" ;
  16. --------------------------------------------------------
  17. --  DDL for Table FILM
  18. --------------------------------------------------------
  19.  
  20.   CREATE TABLE "OMBD_L1617_ZOLICH"."FILM"
  21.    (    "ID_FILM" NUMBER(5,2),
  22.     "TYTUL" VARCHAR2(50 BYTE),
  23.     "REZYSER" VARCHAR2(50 BYTE),
  24.     "ID_CENA" NUMBER(5,2)
  25.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  26.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  27.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  28.   TABLESPACE "USERS" ;
  29. --------------------------------------------------------
  30. --  DDL for Table FILM2
  31. --------------------------------------------------------
  32.  
  33.   CREATE TABLE "OMBD_L1617_ZOLICH"."FILM2"
  34.    (    "ID_FILM" NUMBER(5,0),
  35.     "TYTUL" VARCHAR2(50 BYTE),
  36.     "REZYSER" VARCHAR2(50 BYTE)
  37.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  38.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  39.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  40.   TABLESPACE "USERS" ;
  41. --------------------------------------------------------
  42. --  DDL for Table FILM3
  43. --------------------------------------------------------
  44.  
  45.   CREATE TABLE "OMBD_L1617_ZOLICH"."FILM3"
  46.    (    "ID_FILM" NUMBER(5,0),
  47.     "TYTUL" VARCHAR2(50 BYTE),
  48.     "REZYSER" VARCHAR2(40 BYTE),
  49.     "CENA" NUMBER(5,2)
  50.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  51.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  52.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  53.   TABLESPACE "USERS" ;
  54. --------------------------------------------------------
  55. --  DDL for Table HISTORIA_AWANSU
  56. --------------------------------------------------------
  57.  
  58.   CREATE TABLE "OMBD_L1617_ZOLICH"."HISTORIA_AWANSU"
  59.    (    "ID_PRACOWNIK" NUMBER(5,0),
  60.     "ID_STANOWISKO" NUMBER(5,0),
  61.     "OBJECIE_STANOWISKA" DATE
  62.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  63.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  64.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  65.   TABLESPACE "USERS" ;
  66. --------------------------------------------------------
  67. --  DDL for Table HISTORIA_ZATRUDNIENIA
  68. --------------------------------------------------------
  69.  
  70.   CREATE TABLE "OMBD_L1617_ZOLICH"."HISTORIA_ZATRUDNIENIA"
  71.    (    "DATA_ZATRUDNIENIA" DATE,
  72.     "DATA_ZWOLNIENIA" DATE,
  73.     "ID_HISTORIA" NUMBER(5,0),
  74.     "POPRZEDNIE_STANOWISKA" VARCHAR2(50 BYTE)
  75.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  76.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  77.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  78.   TABLESPACE "USERS" ;
  79. --------------------------------------------------------
  80. --  DDL for Table IMPREZA
  81. --------------------------------------------------------
  82.  
  83.   CREATE TABLE "OMBD_L1617_ZOLICH"."IMPREZA"
  84.    (    "ID_IMPREZA" NUMBER(3,0),
  85.     "NAZWA" VARCHAR2(60 BYTE),
  86.     "MIEJSCE" VARCHAR2(80 BYTE),
  87.     "TERMIN" DATE,
  88.     "ORGANIZATOR" VARCHAR2(50 BYTE),
  89.     "CENA" NUMBER(3,0)
  90.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  91.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  92.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  93.   TABLESPACE "USERS" ;
  94. --------------------------------------------------------
  95. --  DDL for Table KLIENT
  96. --------------------------------------------------------
  97.  
  98.   CREATE TABLE "OMBD_L1617_ZOLICH"."KLIENT"
  99.    (    "ID_KLIENT" NUMBER(5,2),
  100.     "NAZWISKO" VARCHAR2(50 BYTE)
  101.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  102.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  103.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  104.   TABLESPACE "USERS" ;
  105. --------------------------------------------------------
  106. --  DDL for Table KLIENT2
  107. --------------------------------------------------------
  108.  
  109.   CREATE TABLE "OMBD_L1617_ZOLICH"."KLIENT2"
  110.    (    "ID_KLIENT" NUMBER(5,0),
  111.     "NAZWISKO" VARCHAR2(2 BYTE)
  112.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  113.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  114.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  115.   TABLESPACE "USERS" ;
  116. --------------------------------------------------------
  117. --  DDL for Table KLIENT3
  118. --------------------------------------------------------
  119.  
  120.   CREATE TABLE "OMBD_L1617_ZOLICH"."KLIENT3"
  121.    (    "ID_KLIENT" NUMBER(5,0),
  122.     "NAZWISKO" VARCHAR2(50 BYTE)
  123.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  124.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  125.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  126.   TABLESPACE "USERS" ;
  127. --------------------------------------------------------
  128. --  DDL for Table K_PRODUKT
  129. --------------------------------------------------------
  130.  
  131.   CREATE TABLE "OMBD_L1617_ZOLICH"."K_PRODUKT"
  132.    (    "ID_PRODUKT" NUMBER(5,0),
  133.     "NAZWA" VARCHAR2(50 BYTE)
  134.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  135.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  136.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  137.   TABLESPACE "USERS" ;
  138. --------------------------------------------------------
  139. --  DDL for Table K_PRODUKTY
  140. --------------------------------------------------------
  141.  
  142.   CREATE TABLE "OMBD_L1617_ZOLICH"."K_PRODUKTY"
  143.    (    "ID_PRODUKT" NUMBER(5,0),
  144.     "NAZWA" VARCHAR2(50 BYTE),
  145.     "CENA" NUMBER(5,2)
  146.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  147.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  148.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  149.   TABLESPACE "USERS" ;
  150. --------------------------------------------------------
  151. --  DDL for Table KSIAZKA
  152. --------------------------------------------------------
  153.  
  154.   CREATE TABLE "OMBD_L1617_ZOLICH"."KSIAZKA"
  155.    (    "ID_KSIAZKA" NUMBER(5,0),
  156.     "TYTUL" VARCHAR2(200 BYTE),
  157.     "AUTOR" VARCHAR2(300 BYTE)
  158.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  159.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  160.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  161.   TABLESPACE "USERS" ;
  162. --------------------------------------------------------
  163. --  DDL for Table ODDZIALY
  164. --------------------------------------------------------
  165.  
  166.   CREATE TABLE "OMBD_L1617_ZOLICH"."ODDZIALY"
  167.    (    "ID_ODDZIAL" NUMBER(5,0),
  168.     "ULICA" VARCHAR2(20 BYTE),
  169.     "KOD_POCZTOWY" NUMBER(5,0),
  170.     "MIASTO" VARCHAR2(20 BYTE)
  171.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  172.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  173.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  174.   TABLESPACE "USERS" ;
  175. --------------------------------------------------------
  176. --  DDL for Table PRACOWNICY
  177. --------------------------------------------------------
  178.  
  179.   CREATE TABLE "OMBD_L1617_ZOLICH"."PRACOWNICY"
  180.    (    "ID_PRACOWNIK" NUMBER(5,0),
  181.     "NAZWISKO" VARCHAR2(20 BYTE),
  182.     "IMIE" VARCHAR2(20 BYTE),
  183.     "WIEK" NUMBER(5,0),
  184.     "EMAIL" VARCHAR2(20 BYTE),
  185.     "TELEFON" NUMBER(9,0),
  186.     "ID_STANOWISKO" NUMBER(5,0),
  187.     "ID_HISTORIA" NUMBER(5,0),
  188.     "ID_ODDZIAL" NUMBER(5,0)
  189.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  190.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  191.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  192.   TABLESPACE "USERS" ;
  193. --------------------------------------------------------
  194. --  DDL for Table REGIONY
  195. --------------------------------------------------------
  196.  
  197.   CREATE TABLE "OMBD_L1617_ZOLICH"."REGIONY"
  198.    (    "ID_REGION" NUMBER(5,0),
  199.     "NAZWA_REGIONU" VARCHAR2(20 BYTE)
  200.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  201.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  202.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  203.   TABLESPACE "USERS" ;
  204. --------------------------------------------------------
  205. --  DDL for Table SEKTORY_FIRMY
  206. --------------------------------------------------------
  207.  
  208.   CREATE TABLE "OMBD_L1617_ZOLICH"."SEKTORY_FIRMY"
  209.    (    "ID_SEKTOR" NUMBER(5,0),
  210.     "NAZWA_SEKTORA" VARCHAR2(20 BYTE),
  211.     "ID_REGION" NUMBER(5,0),
  212.     "ID_ODDZIAL" NUMBER(5,0)
  213.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  214.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  215.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  216.   TABLESPACE "USERS" ;
  217. --------------------------------------------------------
  218. --  DDL for Table STANOWISKA
  219. --------------------------------------------------------
  220.  
  221.   CREATE TABLE "OMBD_L1617_ZOLICH"."STANOWISKA"
  222.    (    "ID_STANOWISKO" NUMBER(5,0),
  223.     "NAZWA_STANOWISKA" VARCHAR2(20 BYTE),
  224.     "MIN_PENSJA" NUMBER(7,2),
  225.     "MAX_PENSJA" NUMBER(7,2)
  226.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  227.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  228.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  229.   TABLESPACE "USERS" ;
  230. --------------------------------------------------------
  231. --  DDL for Table STUDENCI
  232. --------------------------------------------------------
  233.  
  234.   CREATE TABLE "OMBD_L1617_ZOLICH"."STUDENCI"
  235.    (    "ID_STUDENT" NUMBER(5,0),
  236.     "NAZWISKO" VARCHAR2(50 BYTE),
  237.     "IMIE" VARCHAR2(50 BYTE)
  238.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  239.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  240.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  241.   TABLESPACE "USERS" ;
  242. --------------------------------------------------------
  243. --  DDL for Table SZCZEGOLY_IMPREZY
  244. --------------------------------------------------------
  245.  
  246.   CREATE TABLE "OMBD_L1617_ZOLICH"."SZCZEGOLY_IMPREZY"
  247.    (    "ID_STUDENT" NUMBER(5,0),
  248.     "ID_IMPREZA" NUMBER(3,0)
  249.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  250.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  251.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  252.   TABLESPACE "USERS" ;
  253. --------------------------------------------------------
  254. --  DDL for Table WYP2
  255. --------------------------------------------------------
  256.  
  257.   CREATE TABLE "OMBD_L1617_ZOLICH"."WYP2"
  258.    (    "ID_KLIENT" NUMBER(5,2),
  259.     "ID_FILM" NUMBER(5,2)
  260.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  261.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  262.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  263.   TABLESPACE "USERS" ;
  264. --------------------------------------------------------
  265. --  DDL for Table WYP3
  266. --------------------------------------------------------
  267.  
  268.   CREATE TABLE "OMBD_L1617_ZOLICH"."WYP3"
  269.    (    "ID_FILM" NUMBER(5,0),
  270.     "ID_KLIENT" NUMBER(5,0)
  271.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  272.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  273.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  274.   TABLESPACE "USERS" ;
  275. --------------------------------------------------------
  276. --  DDL for Table WYP4
  277. --------------------------------------------------------
  278.  
  279.   CREATE TABLE "OMBD_L1617_ZOLICH"."WYP4"
  280.    (    "ID_KLIENT" NUMBER(5,0),
  281.     "ID_FILM" NUMBER(5,0)
  282.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  283.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  284.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  285.   TABLESPACE "USERS" ;
  286. --------------------------------------------------------
  287. --  DDL for Table WYPOZYCZENIE
  288. --------------------------------------------------------
  289.  
  290.   CREATE TABLE "OMBD_L1617_ZOLICH"."WYPOZYCZENIE"
  291.    (    "ID_KSIAZKA" NUMBER(5,0),
  292.     "ID_CZYTELNIK" NUMBER(5,0)
  293.    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  294.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  295.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  296.   TABLESPACE "USERS" ;
  297. REM INSERTING INTO OMBD_L1617_ZOLICH.CZYTELNIK
  298. SET DEFINE OFF;
  299. REM INSERTING INTO OMBD_L1617_ZOLICH.FILM
  300. SET DEFINE OFF;
  301. INSERT INTO OMBD_L1617_ZOLICH.FILM (ID_FILM,TYTUL,REZYSER,ID_CENA) VALUES ('1','incpecja','nolan','20');
  302. INSERT INTO OMBD_L1617_ZOLICH.FILM (ID_FILM,TYTUL,REZYSER,ID_CENA) VALUES ('2','zjawa','inaritu','10');
  303. REM INSERTING INTO OMBD_L1617_ZOLICH.FILM2
  304. SET DEFINE OFF;
  305. INSERT INTO OMBD_L1617_ZOLICH.FILM2 (ID_FILM,TYTUL,REZYSER) VALUES ('1','incepcja','nolan');
  306. INSERT INTO OMBD_L1617_ZOLICH.FILM2 (ID_FILM,TYTUL,REZYSER) VALUES ('2','tarzan','scott');
  307. REM INSERTING INTO OMBD_L1617_ZOLICH.FILM3
  308. SET DEFINE OFF;
  309. INSERT INTO OMBD_L1617_ZOLICH.FILM3 (ID_FILM,TYTUL,REZYSER,CENA) VALUES ('1','incepcja','nolan','5,2');
  310. INSERT INTO OMBD_L1617_ZOLICH.FILM3 (ID_FILM,TYTUL,REZYSER,CENA) VALUES ('2','pulp fiction','tarantino','8');
  311. REM INSERTING INTO OMBD_L1617_ZOLICH.HISTORIA_AWANSU
  312. SET DEFINE OFF;
  313. REM INSERTING INTO OMBD_L1617_ZOLICH.HISTORIA_ZATRUDNIENIA
  314. SET DEFINE OFF;
  315. INSERT INTO OMBD_L1617_ZOLICH.HISTORIA_ZATRUDNIENIA (DATA_ZATRUDNIENIA,DATA_ZWOLNIENIA,ID_HISTORIA,POPRZEDNIE_STANOWISKA) VALUES (TO_DATE('08/12/11','RR/MM/DD'),NULL,'1','ksiegowy, manager');
  316. INSERT INTO OMBD_L1617_ZOLICH.HISTORIA_ZATRUDNIENIA (DATA_ZATRUDNIENIA,DATA_ZWOLNIENIA,ID_HISTORIA,POPRZEDNIE_STANOWISKA) VALUES (TO_DATE('12/05/05','RR/MM/DD'),NULL,'2','manager');
  317. INSERT INTO OMBD_L1617_ZOLICH.HISTORIA_ZATRUDNIENIA (DATA_ZATRUDNIENIA,DATA_ZWOLNIENIA,ID_HISTORIA,POPRZEDNIE_STANOWISKA) VALUES (TO_DATE('16/07/25','RR/MM/DD'),NULL,'3',NULL);
  318. INSERT INTO OMBD_L1617_ZOLICH.HISTORIA_ZATRUDNIENIA (DATA_ZATRUDNIENIA,DATA_ZWOLNIENIA,ID_HISTORIA,POPRZEDNIE_STANOWISKA) VALUES (TO_DATE('07/11/30','RR/MM/DD'),TO_DATE('17/03/21','RR/MM/DD'),'4',NULL);
  319. INSERT INTO OMBD_L1617_ZOLICH.HISTORIA_ZATRUDNIENIA (DATA_ZATRUDNIENIA,DATA_ZWOLNIENIA,ID_HISTORIA,POPRZEDNIE_STANOWISKA) VALUES (TO_DATE('15/01/30','RR/MM/DD'),TO_DATE('15/04/30','RR/MM/DD'),'5','analityk');
  320. REM INSERTING INTO OMBD_L1617_ZOLICH.IMPREZA
  321. SET DEFINE OFF;
  322. INSERT INTO OMBD_L1617_ZOLICH.IMPREZA (ID_IMPREZA,NAZWA,MIEJSCE,TERMIN,ORGANIZATOR,CENA) VALUES ('1','wixa','dach',TO_DATE('17/06/16','RR/MM/DD'),'Madzia','300');
  323. INSERT INTO OMBD_L1617_ZOLICH.IMPREZA (ID_IMPREZA,NAZWA,MIEJSCE,TERMIN,ORGANIZATOR,CENA) VALUES ('2','prywatka','mieszkanie',TO_DATE('17/09/08','RR/MM/DD'),'Kasiaczek','50');
  324. INSERT INTO OMBD_L1617_ZOLICH.IMPREZA (ID_IMPREZA,NAZWA,MIEJSCE,TERMIN,ORGANIZATOR,CENA) VALUES ('3','elo melo','in progress',TO_DATE('17/08/16','RR/MM/DD'),'Mroz','100');
  325. REM INSERTING INTO OMBD_L1617_ZOLICH.KLIENT
  326. SET DEFINE OFF;
  327. INSERT INTO OMBD_L1617_ZOLICH.KLIENT (ID_KLIENT,NAZWISKO) VALUES ('1','zolich');
  328. INSERT INTO OMBD_L1617_ZOLICH.KLIENT (ID_KLIENT,NAZWISKO) VALUES ('2','faryniak');
  329. REM INSERTING INTO OMBD_L1617_ZOLICH.KLIENT2
  330. SET DEFINE OFF;
  331. INSERT INTO OMBD_L1617_ZOLICH.KLIENT2 (ID_KLIENT,NAZWISKO) VALUES ('1','zo');
  332. INSERT INTO OMBD_L1617_ZOLICH.KLIENT2 (ID_KLIENT,NAZWISKO) VALUES ('2','fa');
  333. REM INSERTING INTO OMBD_L1617_ZOLICH.KLIENT3
  334. SET DEFINE OFF;
  335. INSERT INTO OMBD_L1617_ZOLICH.KLIENT3 (ID_KLIENT,NAZWISKO) VALUES ('1','zolich');
  336. INSERT INTO OMBD_L1617_ZOLICH.KLIENT3 (ID_KLIENT,NAZWISKO) VALUES ('2','faryniak');
  337. REM INSERTING INTO OMBD_L1617_ZOLICH.K_PRODUKT
  338. SET DEFINE OFF;
  339. REM INSERTING INTO OMBD_L1617_ZOLICH.K_PRODUKTY
  340. SET DEFINE OFF;
  341. REM INSERTING INTO OMBD_L1617_ZOLICH.KSIAZKA
  342. SET DEFINE OFF;
  343. REM INSERTING INTO OMBD_L1617_ZOLICH.ODDZIALY
  344. SET DEFINE OFF;
  345. INSERT INTO OMBD_L1617_ZOLICH.ODDZIALY (ID_ODDZIAL,ULICA,KOD_POCZTOWY,MIASTO) VALUES ('1','Burzej','43518','czechowice-dz');
  346. INSERT INTO OMBD_L1617_ZOLICH.ODDZIALY (ID_ODDZIAL,ULICA,KOD_POCZTOWY,MIASTO) VALUES ('2','pocztowa','53300','wroclaw');
  347. INSERT INTO OMBD_L1617_ZOLICH.ODDZIALY (ID_ODDZIAL,ULICA,KOD_POCZTOWY,MIASTO) VALUES ('3','warszwska','43300','bielsko-biala');
  348. INSERT INTO OMBD_L1617_ZOLICH.ODDZIALY (ID_ODDZIAL,ULICA,KOD_POCZTOWY,MIASTO) VALUES ('4','[rondo onz]','2127','warszawa');
  349. INSERT INTO OMBD_L1617_ZOLICH.ODDZIALY (ID_ODDZIAL,ULICA,KOD_POCZTOWY,MIASTO) VALUES ('5','fiolkowa','32213','poznan');
  350. INSERT INTO OMBD_L1617_ZOLICH.ODDZIALY (ID_ODDZIAL,ULICA,KOD_POCZTOWY,MIASTO) VALUES ('6','majowa','21349','warszawa');
  351. INSERT INTO OMBD_L1617_ZOLICH.ODDZIALY (ID_ODDZIAL,ULICA,KOD_POCZTOWY,MIASTO) VALUES ('7','hallera','53234','wroclaw');
  352. REM INSERTING INTO OMBD_L1617_ZOLICH.PRACOWNICY
  353. SET DEFINE OFF;
  354. INSERT INTO OMBD_L1617_ZOLICH.PRACOWNICY (ID_PRACOWNIK,NAZWISKO,IMIE,WIEK,EMAIL,TELEFON,ID_STANOWISKO,ID_HISTORIA,ID_ODDZIAL) VALUES ('1','faryniak','katarzyna','21','k.faryniak@gmail.com','543743234','5','1','2');
  355. INSERT INTO OMBD_L1617_ZOLICH.PRACOWNICY (ID_PRACOWNIK,NAZWISKO,IMIE,WIEK,EMAIL,TELEFON,ID_STANOWISKO,ID_HISTORIA,ID_ODDZIAL) VALUES ('2','zolich','magdalena','21','m.zolich@gmail.com','523987453','4','4','2');
  356. INSERT INTO OMBD_L1617_ZOLICH.PRACOWNICY (ID_PRACOWNIK,NAZWISKO,IMIE,WIEK,EMAIL,TELEFON,ID_STANOWISKO,ID_HISTORIA,ID_ODDZIAL) VALUES ('3','mroz','aleksandra','21','a.mroz@gmail.com','897234789','1','2','1');
  357. INSERT INTO OMBD_L1617_ZOLICH.PRACOWNICY (ID_PRACOWNIK,NAZWISKO,IMIE,WIEK,EMAIL,TELEFON,ID_STANOWISKO,ID_HISTORIA,ID_ODDZIAL) VALUES ('4','pawelek','patryk','21','p.pawelek@gmail.com','897123989','1','5','4');
  358. INSERT INTO OMBD_L1617_ZOLICH.PRACOWNICY (ID_PRACOWNIK,NAZWISKO,IMIE,WIEK,EMAIL,TELEFON,ID_STANOWISKO,ID_HISTORIA,ID_ODDZIAL) VALUES ('5','zawadzki','mikolaj','21','m.zawadzki@gmail.com','678345897','3','3','2');
  359. REM INSERTING INTO OMBD_L1617_ZOLICH.REGIONY
  360. SET DEFINE OFF;
  361. INSERT INTO OMBD_L1617_ZOLICH.REGIONY (ID_REGION,NAZWA_REGIONU) VALUES ('1','slask');
  362. INSERT INTO OMBD_L1617_ZOLICH.REGIONY (ID_REGION,NAZWA_REGIONU) VALUES ('2','mazowsze');
  363. INSERT INTO OMBD_L1617_ZOLICH.REGIONY (ID_REGION,NAZWA_REGIONU) VALUES ('3','zachod');
  364. INSERT INTO OMBD_L1617_ZOLICH.REGIONY (ID_REGION,NAZWA_REGIONU) VALUES ('4','poludnie');
  365. INSERT INTO OMBD_L1617_ZOLICH.REGIONY (ID_REGION,NAZWA_REGIONU) VALUES ('5','wielkopolska');
  366. REM INSERTING INTO OMBD_L1617_ZOLICH.SEKTORY_FIRMY
  367. SET DEFINE OFF;
  368. INSERT INTO OMBD_L1617_ZOLICH.SEKTORY_FIRMY (ID_SEKTOR,NAZWA_SEKTORA,ID_REGION,ID_ODDZIAL) VALUES ('1','marketing','1','1');
  369. INSERT INTO OMBD_L1617_ZOLICH.SEKTORY_FIRMY (ID_SEKTOR,NAZWA_SEKTORA,ID_REGION,ID_ODDZIAL) VALUES ('2','HR','2','2');
  370. INSERT INTO OMBD_L1617_ZOLICH.SEKTORY_FIRMY (ID_SEKTOR,NAZWA_SEKTORA,ID_REGION,ID_ODDZIAL) VALUES ('3','sales','3','3');
  371. INSERT INTO OMBD_L1617_ZOLICH.SEKTORY_FIRMY (ID_SEKTOR,NAZWA_SEKTORA,ID_REGION,ID_ODDZIAL) VALUES ('4','B+R','4','4');
  372. INSERT INTO OMBD_L1617_ZOLICH.SEKTORY_FIRMY (ID_SEKTOR,NAZWA_SEKTORA,ID_REGION,ID_ODDZIAL) VALUES ('5','administracja','5','5');
  373. REM INSERTING INTO OMBD_L1617_ZOLICH.STANOWISKA
  374. SET DEFINE OFF;
  375. INSERT INTO OMBD_L1617_ZOLICH.STANOWISKA (ID_STANOWISKO,NAZWA_STANOWISKA,MIN_PENSJA,MAX_PENSJA) VALUES ('1','asystent','2500','4500');
  376. INSERT INTO OMBD_L1617_ZOLICH.STANOWISKA (ID_STANOWISKO,NAZWA_STANOWISKA,MIN_PENSJA,MAX_PENSJA) VALUES ('2','analityk','3500','6500');
  377. INSERT INTO OMBD_L1617_ZOLICH.STANOWISKA (ID_STANOWISKO,NAZWA_STANOWISKA,MIN_PENSJA,MAX_PENSJA) VALUES ('3','ksiegowy','3000','6000');
  378. INSERT INTO OMBD_L1617_ZOLICH.STANOWISKA (ID_STANOWISKO,NAZWA_STANOWISKA,MIN_PENSJA,MAX_PENSJA) VALUES ('4','manager','4000','6500');
  379. INSERT INTO OMBD_L1617_ZOLICH.STANOWISKA (ID_STANOWISKO,NAZWA_STANOWISKA,MIN_PENSJA,MAX_PENSJA) VALUES ('5','dyrektor','8000','1500');
  380. REM INSERTING INTO OMBD_L1617_ZOLICH.STUDENCI
  381. SET DEFINE OFF;
  382. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('1','Kowalski','Jan');
  383. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('2','Mroz','Ola');
  384. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('3','Faryniak','Kasia');
  385. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('4','Zolich','Magda');
  386. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('5','Nowak','Adam');
  387. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('6','Kowalski','Jan');
  388. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('7','Kowalski','Jan');
  389. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('8','Kowalski','Jan');
  390. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('9','Stawiarska',NULL);
  391. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('10','Klas',NULL);
  392. INSERT INTO OMBD_L1617_ZOLICH.STUDENCI (ID_STUDENT,NAZWISKO,IMIE) VALUES ('11','Pisarek',NULL);
  393. REM INSERTING INTO OMBD_L1617_ZOLICH.SZCZEGOLY_IMPREZY
  394. SET DEFINE OFF;
  395. INSERT INTO OMBD_L1617_ZOLICH.SZCZEGOLY_IMPREZY (ID_STUDENT,ID_IMPREZA) VALUES ('1','3');
  396. INSERT INTO OMBD_L1617_ZOLICH.SZCZEGOLY_IMPREZY (ID_STUDENT,ID_IMPREZA) VALUES ('3','3');
  397. INSERT INTO OMBD_L1617_ZOLICH.SZCZEGOLY_IMPREZY (ID_STUDENT,ID_IMPREZA) VALUES ('4','2');
  398. INSERT INTO OMBD_L1617_ZOLICH.SZCZEGOLY_IMPREZY (ID_STUDENT,ID_IMPREZA) VALUES ('5','1');
  399. INSERT INTO OMBD_L1617_ZOLICH.SZCZEGOLY_IMPREZY (ID_STUDENT,ID_IMPREZA) VALUES ('8','2');
  400. INSERT INTO OMBD_L1617_ZOLICH.SZCZEGOLY_IMPREZY (ID_STUDENT,ID_IMPREZA) VALUES ('9','1');
  401. INSERT INTO OMBD_L1617_ZOLICH.SZCZEGOLY_IMPREZY (ID_STUDENT,ID_IMPREZA) VALUES ('10','2');
  402. REM INSERTING INTO OMBD_L1617_ZOLICH.WYP2
  403. SET DEFINE OFF;
  404. REM INSERTING INTO OMBD_L1617_ZOLICH.WYP3
  405. SET DEFINE OFF;
  406. REM INSERTING INTO OMBD_L1617_ZOLICH.WYP4
  407. SET DEFINE OFF;
  408. REM INSERTING INTO OMBD_L1617_ZOLICH.WYPOZYCZENIE
  409. SET DEFINE OFF;
  410. --------------------------------------------------------
  411. --  DDL for Index PK_KLIENT
  412. --------------------------------------------------------
  413.  
  414.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_KLIENT" ON "OMBD_L1617_ZOLICH"."KLIENT" ("ID_KLIENT")
  415.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  416.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  417.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  418.   TABLESPACE "USERS" ;
  419. --------------------------------------------------------
  420. --  DDL for Index PK_KSIAZKA
  421. --------------------------------------------------------
  422.  
  423.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_KSIAZKA" ON "OMBD_L1617_ZOLICH"."KSIAZKA" ("ID_KSIAZKA")
  424.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  425.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  426.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  427.   TABLESPACE "USERS" ;
  428. --------------------------------------------------------
  429. --  DDL for Index PK_WYP2
  430. --------------------------------------------------------
  431.  
  432.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_WYP2" ON "OMBD_L1617_ZOLICH"."WYP2" ("ID_KLIENT", "ID_FILM")
  433.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  434.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  435.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  436.   TABLESPACE "USERS" ;
  437. --------------------------------------------------------
  438. --  DDL for Index PK_FILM2
  439. --------------------------------------------------------
  440.  
  441.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_FILM2" ON "OMBD_L1617_ZOLICH"."FILM2" ("ID_FILM")
  442.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  443.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  444.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  445.   TABLESPACE "USERS" ;
  446. --------------------------------------------------------
  447. --  DDL for Index PK_KLIENT2
  448. --------------------------------------------------------
  449.  
  450.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_KLIENT2" ON "OMBD_L1617_ZOLICH"."KLIENT2" ("ID_KLIENT")
  451.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  452.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  453.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  454.   TABLESPACE "USERS" ;
  455. --------------------------------------------------------
  456. --  DDL for Index PK_FILM3
  457. --------------------------------------------------------
  458.  
  459.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_FILM3" ON "OMBD_L1617_ZOLICH"."FILM3" ("ID_FILM")
  460.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  461.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  462.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  463.   TABLESPACE "USERS" ;
  464. --------------------------------------------------------
  465. --  DDL for Index PK_FILM
  466. --------------------------------------------------------
  467.  
  468.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_FILM" ON "OMBD_L1617_ZOLICH"."FILM" ("ID_FILM")
  469.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  470.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  471.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  472.   TABLESPACE "USERS" ;
  473. --------------------------------------------------------
  474. --  DDL for Index PK_STUDENT
  475. --------------------------------------------------------
  476.  
  477.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_STUDENT" ON "OMBD_L1617_ZOLICH"."STUDENCI" ("ID_STUDENT")
  478.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  479.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  480.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  481.   TABLESPACE "USERS" ;
  482. --------------------------------------------------------
  483. --  DDL for Index PK_STANOWISKO
  484. --------------------------------------------------------
  485.  
  486.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_STANOWISKO" ON "OMBD_L1617_ZOLICH"."STANOWISKA" ("ID_STANOWISKO")
  487.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  488.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  489.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  490.   TABLESPACE "USERS" ;
  491. --------------------------------------------------------
  492. --  DDL for Index PK_CZYTELNIK
  493. --------------------------------------------------------
  494.  
  495.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_CZYTELNIK" ON "OMBD_L1617_ZOLICH"."CZYTELNIK" ("ID_CZYTELNIK")
  496.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  497.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  498.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  499.   TABLESPACE "USERS" ;
  500. --------------------------------------------------------
  501. --  DDL for Index PK_KLIENT3
  502. --------------------------------------------------------
  503.  
  504.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_KLIENT3" ON "OMBD_L1617_ZOLICH"."KLIENT3" ("ID_KLIENT")
  505.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  506.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  507.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  508.   TABLESPACE "USERS" ;
  509. --------------------------------------------------------
  510. --  DDL for Index PK_HISTORIA
  511. --------------------------------------------------------
  512.  
  513.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_HISTORIA" ON "OMBD_L1617_ZOLICH"."HISTORIA_ZATRUDNIENIA" ("ID_HISTORIA")
  514.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  515.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  516.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  517.   TABLESPACE "USERS" ;
  518. --------------------------------------------------------
  519. --  DDL for Index PK_IMPREZA
  520. --------------------------------------------------------
  521.  
  522.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_IMPREZA" ON "OMBD_L1617_ZOLICH"."IMPREZA" ("ID_IMPREZA")
  523.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  524.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  525.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  526.   TABLESPACE "USERS" ;
  527. --------------------------------------------------------
  528. --  DDL for Index HISTORIA_AWANSU_PK
  529. --------------------------------------------------------
  530.  
  531.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."HISTORIA_AWANSU_PK" ON "OMBD_L1617_ZOLICH"."HISTORIA_AWANSU" ("ID_PRACOWNIK", "ID_STANOWISKO")
  532.   PCTFREE 10 INITRANS 2 MAXTRANS 255
  533.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  534.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  535.   TABLESPACE "USERS" ;
  536. --------------------------------------------------------
  537. --  DDL for Index PK_PRACOWNICY
  538. --------------------------------------------------------
  539.  
  540.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_PRACOWNICY" ON "OMBD_L1617_ZOLICH"."PRACOWNICY" ("ID_STANOWISKO", "ID_HISTORIA", "ID_ODDZIAL")
  541.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  542.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  543.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  544.   TABLESPACE "USERS" ;
  545. --------------------------------------------------------
  546. --  DDL for Index PK_SZCZ
  547. --------------------------------------------------------
  548.  
  549.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_SZCZ" ON "OMBD_L1617_ZOLICH"."SZCZEGOLY_IMPREZY" ("ID_STUDENT", "ID_IMPREZA")
  550.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  551.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  552.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  553.   TABLESPACE "USERS" ;
  554. --------------------------------------------------------
  555. --  DDL for Index PK_SEKTOR
  556. --------------------------------------------------------
  557.  
  558.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_SEKTOR" ON "OMBD_L1617_ZOLICH"."SEKTORY_FIRMY" ("ID_REGION", "ID_ODDZIAL")
  559.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  560.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  561.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  562.   TABLESPACE "USERS" ;
  563. --------------------------------------------------------
  564. --  DDL for Index PK_ODDZIAL
  565. --------------------------------------------------------
  566.  
  567.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_ODDZIAL" ON "OMBD_L1617_ZOLICH"."ODDZIALY" ("ID_ODDZIAL")
  568.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  569.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  570.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  571.   TABLESPACE "USERS" ;
  572. --------------------------------------------------------
  573. --  DDL for Index PK_WYP3
  574. --------------------------------------------------------
  575.  
  576.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_WYP3" ON "OMBD_L1617_ZOLICH"."WYP3" ("ID_FILM", "ID_KLIENT")
  577.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  578.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  579.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  580.   TABLESPACE "USERS" ;
  581. --------------------------------------------------------
  582. --  DDL for Index PK_REGIONY
  583. --------------------------------------------------------
  584.  
  585.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_REGIONY" ON "OMBD_L1617_ZOLICH"."REGIONY" ("ID_REGION")
  586.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  587.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  588.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  589.   TABLESPACE "USERS" ;
  590. --------------------------------------------------------
  591. --  DDL for Index PK_WYP4
  592. --------------------------------------------------------
  593.  
  594.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_WYP4" ON "OMBD_L1617_ZOLICH"."WYP4" ("ID_KLIENT", "ID_FILM")
  595.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  596.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  597.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  598.   TABLESPACE "USERS" ;
  599. --------------------------------------------------------
  600. --  DDL for Index PK_WYPOZYCZENIE
  601. --------------------------------------------------------
  602.  
  603.   CREATE UNIQUE INDEX "OMBD_L1617_ZOLICH"."PK_WYPOZYCZENIE" ON "OMBD_L1617_ZOLICH"."WYPOZYCZENIE" ("ID_KSIAZKA", "ID_CZYTELNIK")
  604.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  605.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  606.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  607.   TABLESPACE "USERS" ;
  608. --------------------------------------------------------
  609. --  Constraints for Table HISTORIA_ZATRUDNIENIA
  610. --------------------------------------------------------
  611.  
  612.   ALTER TABLE "OMBD_L1617_ZOLICH"."HISTORIA_ZATRUDNIENIA" ADD CONSTRAINT "PK_HISTORIA" PRIMARY KEY ("ID_HISTORIA")
  613.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  614.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  615.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  616.   TABLESPACE "USERS"  ENABLE;
  617. --------------------------------------------------------
  618. --  Constraints for Table SZCZEGOLY_IMPREZY
  619. --------------------------------------------------------
  620.  
  621.   ALTER TABLE "OMBD_L1617_ZOLICH"."SZCZEGOLY_IMPREZY" ADD CONSTRAINT "PK_SZCZ" PRIMARY KEY ("ID_STUDENT", "ID_IMPREZA")
  622.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  623.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  624.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  625.   TABLESPACE "USERS"  ENABLE;
  626. --------------------------------------------------------
  627. --  Constraints for Table KSIAZKA
  628. --------------------------------------------------------
  629.  
  630.   ALTER TABLE "OMBD_L1617_ZOLICH"."KSIAZKA" ADD CONSTRAINT "PK_KSIAZKA" PRIMARY KEY ("ID_KSIAZKA")
  631.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  632.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  633.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  634.   TABLESPACE "USERS"  ENABLE;
  635. --------------------------------------------------------
  636. --  Constraints for Table KLIENT2
  637. --------------------------------------------------------
  638.  
  639.   ALTER TABLE "OMBD_L1617_ZOLICH"."KLIENT2" ADD CONSTRAINT "PK_KLIENT2" PRIMARY KEY ("ID_KLIENT")
  640.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  641.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  642.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  643.   TABLESPACE "USERS"  ENABLE;
  644. --------------------------------------------------------
  645. --  Constraints for Table FILM3
  646. --------------------------------------------------------
  647.  
  648.   ALTER TABLE "OMBD_L1617_ZOLICH"."FILM3" ADD CONSTRAINT "PK_FILM3" PRIMARY KEY ("ID_FILM")
  649.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  650.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  651.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  652.   TABLESPACE "USERS"  ENABLE;
  653. --------------------------------------------------------
  654. --  Constraints for Table STUDENCI
  655. --------------------------------------------------------
  656.  
  657.   ALTER TABLE "OMBD_L1617_ZOLICH"."STUDENCI" ADD CONSTRAINT "PK_STUDENT" PRIMARY KEY ("ID_STUDENT")
  658.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  659.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  660.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  661.   TABLESPACE "USERS"  ENABLE;
  662. --------------------------------------------------------
  663. --  Constraints for Table ODDZIALY
  664. --------------------------------------------------------
  665.  
  666.   ALTER TABLE "OMBD_L1617_ZOLICH"."ODDZIALY" ADD CONSTRAINT "PK_ODDZIAL" PRIMARY KEY ("ID_ODDZIAL")
  667.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  668.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  669.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  670.   TABLESPACE "USERS"  ENABLE;
  671. --------------------------------------------------------
  672. --  Constraints for Table WYP2
  673. --------------------------------------------------------
  674.  
  675.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP2" ADD CONSTRAINT "PK_WYP2" PRIMARY KEY ("ID_KLIENT", "ID_FILM")
  676.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  677.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  678.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  679.   TABLESPACE "USERS"  ENABLE;
  680. --------------------------------------------------------
  681. --  Constraints for Table FILM
  682. --------------------------------------------------------
  683.  
  684.   ALTER TABLE "OMBD_L1617_ZOLICH"."FILM" ADD CONSTRAINT "PK_FILM" PRIMARY KEY ("ID_FILM")
  685.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  686.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  687.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  688.   TABLESPACE "USERS"  ENABLE;
  689. --------------------------------------------------------
  690. --  Constraints for Table KLIENT
  691. --------------------------------------------------------
  692.  
  693.   ALTER TABLE "OMBD_L1617_ZOLICH"."KLIENT" ADD CONSTRAINT "PK_KLIENT" PRIMARY KEY ("ID_KLIENT")
  694.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  695.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  696.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  697.   TABLESPACE "USERS"  ENABLE;
  698. --------------------------------------------------------
  699. --  Constraints for Table CZYTELNIK
  700. --------------------------------------------------------
  701.  
  702.   ALTER TABLE "OMBD_L1617_ZOLICH"."CZYTELNIK" ADD CONSTRAINT "PK_CZYTELNIK" PRIMARY KEY ("ID_CZYTELNIK")
  703.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  704.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  705.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  706.   TABLESPACE "USERS"  ENABLE;
  707. --------------------------------------------------------
  708. --  Constraints for Table WYP4
  709. --------------------------------------------------------
  710.  
  711.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP4" ADD CONSTRAINT "PK_WYP4" PRIMARY KEY ("ID_KLIENT", "ID_FILM")
  712.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  713.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  714.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  715.   TABLESPACE "USERS"  ENABLE;
  716. --------------------------------------------------------
  717. --  Constraints for Table STANOWISKA
  718. --------------------------------------------------------
  719.  
  720.   ALTER TABLE "OMBD_L1617_ZOLICH"."STANOWISKA" ADD CONSTRAINT "PK_STANOWISKO" PRIMARY KEY ("ID_STANOWISKO")
  721.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  722.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  723.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  724.   TABLESPACE "USERS"  ENABLE;
  725. --------------------------------------------------------
  726. --  Constraints for Table FILM2
  727. --------------------------------------------------------
  728.  
  729.   ALTER TABLE "OMBD_L1617_ZOLICH"."FILM2" ADD CONSTRAINT "PK_FILM2" PRIMARY KEY ("ID_FILM")
  730.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  731.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  732.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  733.   TABLESPACE "USERS"  ENABLE;
  734. --------------------------------------------------------
  735. --  Constraints for Table IMPREZA
  736. --------------------------------------------------------
  737.  
  738.   ALTER TABLE "OMBD_L1617_ZOLICH"."IMPREZA" ADD CONSTRAINT "PK_IMPREZA" PRIMARY KEY ("ID_IMPREZA")
  739.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  740.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  741.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  742.   TABLESPACE "USERS"  ENABLE;
  743. --------------------------------------------------------
  744. --  Constraints for Table WYPOZYCZENIE
  745. --------------------------------------------------------
  746.  
  747.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYPOZYCZENIE" ADD CONSTRAINT "PK_WYPOZYCZENIE" PRIMARY KEY ("ID_KSIAZKA", "ID_CZYTELNIK")
  748.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  749.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  750.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  751.   TABLESPACE "USERS"  ENABLE;
  752. --------------------------------------------------------
  753. --  Constraints for Table HISTORIA_AWANSU
  754. --------------------------------------------------------
  755.  
  756.   ALTER TABLE "OMBD_L1617_ZOLICH"."HISTORIA_AWANSU" ADD CONSTRAINT "HISTORIA_AWANSU_PK" PRIMARY KEY ("ID_PRACOWNIK", "ID_STANOWISKO")
  757.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  758.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  759.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  760.   TABLESPACE "USERS"  ENABLE;
  761.  
  762.   ALTER TABLE "OMBD_L1617_ZOLICH"."HISTORIA_AWANSU" MODIFY ("ID_PRACOWNIK" NOT NULL ENABLE);
  763.  
  764.   ALTER TABLE "OMBD_L1617_ZOLICH"."HISTORIA_AWANSU" MODIFY ("ID_STANOWISKO" NOT NULL ENABLE);
  765. --------------------------------------------------------
  766. --  Constraints for Table SEKTORY_FIRMY
  767. --------------------------------------------------------
  768.  
  769.   ALTER TABLE "OMBD_L1617_ZOLICH"."SEKTORY_FIRMY" ADD CONSTRAINT "PK_SEKTOR" PRIMARY KEY ("ID_REGION", "ID_ODDZIAL")
  770.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  771.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  772.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  773.   TABLESPACE "USERS"  ENABLE;
  774. --------------------------------------------------------
  775. --  Constraints for Table REGIONY
  776. --------------------------------------------------------
  777.  
  778.   ALTER TABLE "OMBD_L1617_ZOLICH"."REGIONY" ADD CONSTRAINT "PK_REGIONY" PRIMARY KEY ("ID_REGION")
  779.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  780.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  781.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  782.   TABLESPACE "USERS"  ENABLE;
  783. --------------------------------------------------------
  784. --  Constraints for Table WYP3
  785. --------------------------------------------------------
  786.  
  787.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP3" ADD CONSTRAINT "PK_WYP3" PRIMARY KEY ("ID_FILM", "ID_KLIENT")
  788.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  789.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  790.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  791.   TABLESPACE "USERS"  ENABLE;
  792. --------------------------------------------------------
  793. --  Constraints for Table KLIENT3
  794. --------------------------------------------------------
  795.  
  796.   ALTER TABLE "OMBD_L1617_ZOLICH"."KLIENT3" ADD CONSTRAINT "PK_KLIENT3" PRIMARY KEY ("ID_KLIENT")
  797.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  798.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  799.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  800.   TABLESPACE "USERS"  ENABLE;
  801. --------------------------------------------------------
  802. --  Constraints for Table PRACOWNICY
  803. --------------------------------------------------------
  804.  
  805.   ALTER TABLE "OMBD_L1617_ZOLICH"."PRACOWNICY" ADD CONSTRAINT "PK_PRACOWNICY" PRIMARY KEY ("ID_STANOWISKO", "ID_HISTORIA", "ID_ODDZIAL")
  806.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  807.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  808.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  809.   TABLESPACE "USERS"  ENABLE;
  810. --------------------------------------------------------
  811. --  Ref Constraints for Table HISTORIA_AWANSU
  812. --------------------------------------------------------
  813.  
  814.   ALTER TABLE "OMBD_L1617_ZOLICH"."HISTORIA_AWANSU" ADD CONSTRAINT "HISTORIA_AWANSU_FK1" FOREIGN KEY ("ID_STANOWISKO")
  815.       REFERENCES "OMBD_L1617_ZOLICH"."STANOWISKA" ("ID_STANOWISKO") ENABLE;
  816. --------------------------------------------------------
  817. --  Ref Constraints for Table PRACOWNICY
  818. --------------------------------------------------------
  819.  
  820.   ALTER TABLE "OMBD_L1617_ZOLICH"."PRACOWNICY" ADD CONSTRAINT "FK_HISTORIA" FOREIGN KEY ("ID_HISTORIA")
  821.       REFERENCES "OMBD_L1617_ZOLICH"."HISTORIA_ZATRUDNIENIA" ("ID_HISTORIA") ENABLE;
  822.  
  823.   ALTER TABLE "OMBD_L1617_ZOLICH"."PRACOWNICY" ADD CONSTRAINT "FK_ODDZIALY" FOREIGN KEY ("ID_ODDZIAL")
  824.       REFERENCES "OMBD_L1617_ZOLICH"."ODDZIALY" ("ID_ODDZIAL") ENABLE;
  825.  
  826.   ALTER TABLE "OMBD_L1617_ZOLICH"."PRACOWNICY" ADD CONSTRAINT "FK_STANOWISKO" FOREIGN KEY ("ID_STANOWISKO")
  827.       REFERENCES "OMBD_L1617_ZOLICH"."STANOWISKA" ("ID_STANOWISKO") ENABLE;
  828. --------------------------------------------------------
  829. --  Ref Constraints for Table SEKTORY_FIRMY
  830. --------------------------------------------------------
  831.  
  832.   ALTER TABLE "OMBD_L1617_ZOLICH"."SEKTORY_FIRMY" ADD CONSTRAINT "FK_ODDZIAL" FOREIGN KEY ("ID_ODDZIAL")
  833.       REFERENCES "OMBD_L1617_ZOLICH"."ODDZIALY" ("ID_ODDZIAL") ENABLE;
  834.  
  835.   ALTER TABLE "OMBD_L1617_ZOLICH"."SEKTORY_FIRMY" ADD CONSTRAINT "FK_REGION" FOREIGN KEY ("ID_REGION")
  836.       REFERENCES "OMBD_L1617_ZOLICH"."REGIONY" ("ID_REGION") ENABLE;
  837. --------------------------------------------------------
  838. --  Ref Constraints for Table SZCZEGOLY_IMPREZY
  839. --------------------------------------------------------
  840.  
  841.   ALTER TABLE "OMBD_L1617_ZOLICH"."SZCZEGOLY_IMPREZY" ADD CONSTRAINT "FK_IMPREZA" FOREIGN KEY ("ID_IMPREZA")
  842.       REFERENCES "OMBD_L1617_ZOLICH"."IMPREZA" ("ID_IMPREZA") ENABLE;
  843.  
  844.   ALTER TABLE "OMBD_L1617_ZOLICH"."SZCZEGOLY_IMPREZY" ADD CONSTRAINT "FK_STUDENT" FOREIGN KEY ("ID_STUDENT")
  845.       REFERENCES "OMBD_L1617_ZOLICH"."STUDENCI" ("ID_STUDENT") ENABLE;
  846. --------------------------------------------------------
  847. --  Ref Constraints for Table WYP2
  848. --------------------------------------------------------
  849.  
  850.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP2" ADD CONSTRAINT "FK_FILM" FOREIGN KEY ("ID_FILM")
  851.       REFERENCES "OMBD_L1617_ZOLICH"."FILM" ("ID_FILM") ENABLE;
  852.  
  853.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP2" ADD CONSTRAINT "FK_KLIENT" FOREIGN KEY ("ID_KLIENT")
  854.       REFERENCES "OMBD_L1617_ZOLICH"."KLIENT" ("ID_KLIENT") ENABLE;
  855. --------------------------------------------------------
  856. --  Ref Constraints for Table WYP3
  857. --------------------------------------------------------
  858.  
  859.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP3" ADD CONSTRAINT "FK_FILM2" FOREIGN KEY ("ID_FILM")
  860.       REFERENCES "OMBD_L1617_ZOLICH"."FILM2" ("ID_FILM") ENABLE;
  861.  
  862.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP3" ADD CONSTRAINT "FK_KLIENT2" FOREIGN KEY ("ID_KLIENT")
  863.       REFERENCES "OMBD_L1617_ZOLICH"."KLIENT2" ("ID_KLIENT") ENABLE;
  864. --------------------------------------------------------
  865. --  Ref Constraints for Table WYP4
  866. --------------------------------------------------------
  867.  
  868.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP4" ADD CONSTRAINT "FK_FILM3" FOREIGN KEY ("ID_FILM")
  869.       REFERENCES "OMBD_L1617_ZOLICH"."FILM3" ("ID_FILM") ENABLE;
  870.  
  871.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYP4" ADD CONSTRAINT "FK_KLIENT3" FOREIGN KEY ("ID_KLIENT")
  872.       REFERENCES "OMBD_L1617_ZOLICH"."KLIENT3" ("ID_KLIENT") ENABLE;
  873. --------------------------------------------------------
  874. --  Ref Constraints for Table WYPOZYCZENIE
  875. --------------------------------------------------------
  876.  
  877.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYPOZYCZENIE" ADD CONSTRAINT "FK_CZYTELNIK" FOREIGN KEY ("ID_CZYTELNIK")
  878.       REFERENCES "OMBD_L1617_ZOLICH"."CZYTELNIK" ("ID_CZYTELNIK") ENABLE;
  879.  
  880.   ALTER TABLE "OMBD_L1617_ZOLICH"."WYPOZYCZENIE" ADD CONSTRAINT "FK_KSIAZKA" FOREIGN KEY ("ID_KSIAZKA")
  881.       REFERENCES "OMBD_L1617_ZOLICH"."KSIAZKA" ("ID_KSIAZKA") ENABLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!