--
-- $Header: bdemobld.sql 1.1 94/10/19 09:22:46 gdudey Osd<desktop/netware> $ Copyr (c) 1994 Oracle
--
--   NAZWA
--     bdemobld.sql - Build Oracle Data Browser Demonstration Tables
--   OPIS
--     This SQL script builds the Oracle Data Browser demonstration tables
--     used in the Oracle Data Browser documentation.
--   NOTES
--     Do not run this script in the same account where you have run 
--     demobld.sql.  Creating a separate account called BROWSER is 
--     recommended.
--     Constraints created with this script are not NAZWAd so that the
--     script will run under both ORACLE Version 6 and ORACLE7 untouched.
--   MODIFIED   (MM/DD/YY)
--    gpancha    02/23/94 -  Changed CHAR to VARCHAR2. 
--    spao       09/02/93 -  Recreated missing INSERT STANments for
--                           POZIOMY_PENSJI table.
--    spao       08/10/93 -  Changed nonunique indexes to unique indexes and
--                           corrected CENY table to meet check constraints.
--    spao       02/24/93 -  Changed date inputs to be language/territory
--                           independent; changed number inputs to be
--                           territory independent; separated constraint
--                           definitions from table definitions; added
--                           indexes for SIEDZIBY, WYDZIALY, ETATY,
--                           PRACOWNICY, and POZIOMY_PENSJI tables.
--    spao       05/02/91 -  Creation

-- Drop old datasources

begin
  for t in (select table_name n from user_tables) loop
    DBMS_OUTPUT.PUT_LINE('usuwam ' || t.n);
    execute immediate 'drop table ' || t.n || ' cascade constraints';
  end loop;
  execute immediate  'PURGE recyclebin';
end;
/

drop sequence siedziby_seq;
drop sequence WYDZIALY_seq;
drop sequence etaty_seq;
drop sequence pracownicy_seq;


create sequence WYDZIALY_seq start with 200;
create sequence siedziby_seq start with 200;
create sequence etaty_seq start with 700;
create sequence pracownicy_seq start with 800;


-- Create new datasources

CREATE TABLE SIEDZIBY (
        ID_SIEDZIBY             NUMBER(3),
        REGION          VARCHAR2(20));



CREATE TABLE WYDZIALY (
        ID_WYDZIALU           NUMBER(2),
        NAZWA                    VARCHAR2(14),
        ID_SIEDZIBY             NUMBER(3));

CREATE TABLE ETATY (
        ID_ETATU                  NUMBER(3),
        ETAT                VARCHAR2(30));

CREATE TABLE PRACOWNICY (
        ID_PRACOWNIKA             NUMBER(4),
        NAZWISKO               VARCHAR2(15),
        IMIE              VARCHAR2(15),
        DRUGIE_IMIE          VARCHAR2(1),
        ID_ETATU                  NUMBER(3),
        ID_SZEFA              NUMBER(4),
        DATA_ZATRUDNIENIA               DATE,
        PENSJA                  NUMBER(7,2),
        PROWIZJA              NUMBER(7,2),
        ID_WYDZIALU           NUMBER(2));

CREATE TABLE POZIOMY_PENSJI (
        ID_POZIOMU                NUMBER(3),
        DOLNA_GRANICA             NUMBER(7,2),
        GORNA_GRANICA             NUMBER(7,2));

CREATE TABLE WYROBY (
        ID_PRODUKTU              NUMBER (6),
        OPIS             VARCHAR2 (30));
 
CREATE TABLE CENY (
        ID_PRODUKTU              NUMBER (6),
        CENA_CENNIKOWA              NUMBER (8,2),
        CENA_MINIMALNA               NUMBER (8,2),
        DATA_OBWIAZYWANIA              DATE,
        DATA_WYCOFANIA                DATE);

CREATE TABLE KLIENCI (
        ID_KLIENTA             NUMBER (6),
        NAZWA                    VARCHAR2 (45),
        ADRES                 VARCHAR2 (40),
        MIASTO                    VARCHAR2 (30),
        STAN                   VARCHAR2 (2),
        KOD_POCZTOWY                VARCHAR2 (9),
        NR_KIERUNKOWY               NUMBER (3),
        TELEFON            NUMBER (7),
        ID_PRACOWNIKA          NUMBER (4),
        LIMIT_KREDYTOWY            NUMBER (9,2),
        KOMENTARZ                LONG);

CREATE TABLE ZAMOWIENIA  (
        ID_ZAMOWIENIA                NUMBER (4),
        DATA_ZAMOWIENIA              DATE,
        ID_KLIENTA             NUMBER (6),
        DATA_WYSYLKI               DATE,
        WARTOSC                   NUMBER (8,2));

CREATE TABLE WIERSZE_ZAMOWIEN  (
        ID_ZAMOWIENIA                NUMBER (4),
        ID_WIERSZA_ZAM                 NUMBER (4),
        ID_PRODUKTU              NUMBER (6),
        CENA            NUMBER (8,2),
        ILOSC                NUMBER (8),
        WARTOSC                   NUMBER (8,2));


-- Grant SELECT privileges to PUBLIC on the datasources

GRANT SELECT ON SIEDZIBY TO PUBLIC;
GRANT SELECT ON WYDZIALY TO PUBLIC;
GRANT SELECT ON ETATY TO PUBLIC;
GRANT SELECT ON PRACOWNICY TO PUBLIC;
GRANT SELECT ON POZIOMY_PENSJI TO PUBLIC;
GRANT SELECT ON WYROBY TO PUBLIC;
GRANT SELECT ON CENY TO PUBLIC;
GRANT SELECT ON KLIENCI TO PUBLIC;
GRANT SELECT ON ZAMOWIENIA TO PUBLIC;
GRANT SELECT ON WIERSZE_ZAMOWIEN TO PUBLIC;
 
-- Comment the datasources and their columns

COMMENT ON TABLE PRACOWNICY IS 'General information on all corporate PRACOWNICYs.';
COMMENT ON COLUMN PRACOWNICY.ID_PRACOWNIKA IS 'PRACOWNICY Number: Unique 4-digit identification number assigned to every PRACOWNICY.';
COMMENT ON COLUMN PRACOWNICY.NAZWISKO IS 'Last NAZWA of PRACOWNICY.  Stored in all caps.';
COMMENT ON COLUMN PRACOWNICY.IMIE IS 'First NAZWA of PRACOWNICY.  Stored in all caps.';
COMMENT ON COLUMN PRACOWNICY.DRUGIE_IMIE IS 'Middle initial (one character only).  Stored in all caps.';
COMMENT ON COLUMN PRACOWNICY.ID_ETATU IS 'ETATY identification number.  See ETATY for OPISs.';
COMMENT ON COLUMN PRACOWNICY.ID_SZEFA IS 'Manager: The PRACOWNICY number of this PRACOWNICY''s manager.  If PRACOWNICY has no manager, value should be NULL.';
COMMENT ON COLUMN PRACOWNICY.DATA_ZATRUDNIENIA IS 'Date the PRACOWNICY was HIRED, not necessarily the day the PRACOWNICY STARTED.';
COMMENT ON COLUMN PRACOWNICY.PENSJA IS 'Monthly PENSJA for the PRACOWNICY in U.S. dollars.  PENSJA grade information can be found in the table POZIOMY_PENSJI.';
COMMENT ON COLUMN PRACOWNICY.PROWIZJA IS 'PROWIZJA (in U.S. dollars) earned last month.  This field should be NULL for non-PROWIZJAed PRACOWNICYs.';
COMMENT ON COLUMN PRACOWNICY.ID_WYDZIALU IS 'PRACOWNICY''s WYDZIALY number.  Further WYDZIALY information is available in the table DEPT.';

COMMENT ON TABLE ETATY IS 'All valid ETATY categories for personnel information.';
COMMENT ON COLUMN ETATY.ID_ETATU IS 'Unique 3-digit code for ETATY ETAT and title.';
COMMENT ON COLUMN ETATY.ETAT IS 'Generic ETAT class of ETATY.';

COMMENT ON TABLE WYDZIALY IS 'WYDZIALY information for all U.S. operations.';
COMMENT ON COLUMN WYDZIALY.ID_WYDZIALU IS 'WYDZIALY number: Unique 2-digit WYDZIALY number assigned to each WYDZIALY.';
COMMENT ON COLUMN WYDZIALY.NAZWA IS 'WYDZIALY NAZWA: Only the first 14 characters of a WYDZIALY NAZWA can be stored in the database.  Storing NAZWAs in all caps is recommended but not required.';
COMMENT ON COLUMN WYDZIALY.ID_SIEDZIBY IS 'WYDZIALY SIEDZIBY: The code for where the WYDZIALY''s central office is located.  (SIEDZIBY)';

COMMENT ON TABLE SIEDZIBY IS 'SIEDZIBY information for all U.S. WYDZIALYs and warehouses.';
COMMENT ON COLUMN SIEDZIBY.ID_SIEDZIBY IS 'Central SIEDZIBY corporate SIEDZIBY code.';
COMMENT ON COLUMN SIEDZIBY.REGION IS 'Metropolitan center closest to SIEDZIBY.';

COMMENT ON TABLE POZIOMY_PENSJI IS 'PENSJA grade levels.  Used to classify monthly PENSJA information in U.S. dollars, as found in EMP.SAL.';
COMMENT ON COLUMN POZIOMY_PENSJI.ID_POZIOMU IS 'Number used to grade salaries.  Higher PENSJA grade numbers denote higher salaries.';
COMMENT ON COLUMN POZIOMY_PENSJI.DOLNA_GRANICA IS 'The lowest monthly PENSJA (rounded to the nearest U.S. dollar) that applies to a particular PENSJA grade. (i.e. the condition ROUND(EMP.SAL) >= DOLNA_GRANICA must be met.)';
COMMENT ON COLUMN POZIOMY_PENSJI.GORNA_GRANICA IS 'The highest monthly PENSJA (rounded to the nearest U.S. dollar) that applies to a particular PENSJA grade. (i.e. the condition ROUND(EMP.SAL) <= GORNA_GRANICA must be met.)';

COMMENT ON TABLE WYROBY IS 'WYROBYs in catalog.  Pricing information can be found in table CENY.';
COMMENT ON COLUMN WYROBY.ID_PRODUKTU IS 'Unique 6 digit number assigned to all WYROBYs.  Number generated by sequence ID_PRODUKTU.';
COMMENT ON COLUMN WYROBY.OPIS IS 'Full WYROBY NAZWA (up to 30 characters).  Storing WYROBY NAZWAs in all caps is recommended but not required.';

COMMENT ON TABLE CENY IS 'CENYs (both standard and minimum) of WYROBYs.  Database tracks both effective dates and expiration dates for CENYs.';
COMMENT ON COLUMN CENY.ID_PRODUKTU IS 'WYROBY number to which CENY applies.  WYROBY NAZWA found in table CENY.';
COMMENT ON COLUMN CENY.CENA_CENNIKOWA IS 'Undiscounted CENY (in U.S. dollars).';
COMMENT ON COLUMN CENY.CENA_MINIMALNA IS 'Lowest CENY (in U.S. dollars) that can be offered.';
COMMENT ON COLUMN CENY.DATA_OBWIAZYWANIA IS 'Date which standard and minimum CENYs go into effect.';
COMMENT ON COLUMN CENY.DATA_WYCOFANIA IS 'Date which standard and minimum CENY expire.  This value can be left NULL.';

COMMENT ON TABLE KLIENCI IS 'Information on all U.S. KLIENCIs and prospective KLIENCIs.';
COMMENT ON COLUMN KLIENCI.ID_KLIENTA IS 'Unique 6 digit number assigned to all KLIENCIs.  Number generated by the sequence ID_KLIENTA.';
COMMENT ON COLUMN KLIENCI.NAZWA IS 'Full store NAZWA of every KLIENCI (up to 45 characters).  Storing NAZWAs in all caps is recommended but not required.';
COMMENT ON COLUMN KLIENCI.ADRES IS 'Street ADRES of KLIENCI.  MIASTO, STAN, and KOD_POCZTOWY make up the rest of the ADRES.';
COMMENT ON COLUMN KLIENCI.MIASTO IS 'MIASTO NAZWA for ADRES of KLIENCI.  Storing MIASTO NAZWAs in all caps is recommended, but not required.';
COMMENT ON COLUMN KLIENCI.STAN IS 'Two letter abbreviation for STAN NAZWA for ADRES of KLIENCI.  Must be entered in all caps.';
COMMENT ON COLUMN KLIENCI.KOD_POCZTOWY IS 'Zip code of KLIENCI.  Supports both 5 and 9 digit zip codes.  Dashes should be omitted from 9 digit zips.';
COMMENT ON COLUMN KLIENCI.NR_KIERUNKOWY IS 'Area code of phone number for KLIENCI.';
COMMENT ON COLUMN KLIENCI.TELEFON IS 'Phone number of KLIENCI.  This field does not supports letters and spaces for mnemonics (7 numeric digits only).';
COMMENT ON COLUMN KLIENCI.ID_PRACOWNIKA IS 'PRACOWNICY number of WYNIKI_SPRZEDAZY representative handling KLIENCI''s account.  PRACOWNICY information can be found in the PRACOWNICY table.';
COMMENT ON COLUMN KLIENCI.LIMIT_KREDYTOWY IS 'Credit limit of KLIENCI or prospective KLIENCI in U.S. dollars.';
COMMENT ON COLUMN KLIENCI.KOMENTARZ IS 'Field can be used flexibly.  Suggestions for use include lists of action WIERSZE_ZAMOWIENs or special considerations when dealing with the particular KLIENCI.';

COMMENT ON TABLE ZAMOWIENIA IS 'WYNIKI_SPRZEDAZY order for a KLIENCI.  WIERSZE_ZAMOWIENs in the order can be found in the table WIERSZE_ZAMOWIEN.';
COMMENT ON COLUMN ZAMOWIENIA.ID_ZAMOWIENIA IS 'Unique 4 digit number assigned to all orders.  Number generated by sequence ID_ZAMOWIENIA.';
COMMENT ON COLUMN ZAMOWIENIA.DATA_ZAMOWIENIA IS 'Date WYNIKI_SPRZEDAZY order logged (not necessarily when order was fulfilled.)';
COMMENT ON COLUMN ZAMOWIENIA.ID_KLIENTA IS 'KLIENCI ordering the goods.  Further information can be found in the table KLIENCI.';
COMMENT ON COLUMN ZAMOWIENIA.DATA_WYSYLKI IS 'Date order fulfilled and invoice sent (not necessarily date payment received).';
COMMENT ON COLUMN ZAMOWIENIA.WARTOSC IS 'WARTOSC of all WIERSZE_ZAMOWIENs WARTOSCs in the order.  (i.e. the value of WARTOSC for order N should contain: SELECT SUM(WARTOSC) FROM WIERSZE_ZAMOWIEN WHERE ID_ZAMOWIENIA=N)';

COMMENT ON TABLE WIERSZE_ZAMOWIEN IS 'WIERSZE_ZAMOWIENs listed in WYNIKI_SPRZEDAZY orders.  WYROBY information can be found in table WYROBY.  WYNIKI_SPRZEDAZY order information can be found in table ZAMOWIENIA.';
COMMENT ON COLUMN WIERSZE_ZAMOWIEN.ID_ZAMOWIENIA IS 'WYNIKI_SPRZEDAZY order in which this WIERSZE_ZAMOWIEN appears.  WYNIKI_SPRZEDAZY order information can be found in table ZAMOWIENIA.';
COMMENT ON COLUMN WIERSZE_ZAMOWIEN.ID_WIERSZA_ZAM IS 'Number of WIERSZE_ZAMOWIEN within the WYNIKI_SPRZEDAZY order.';
COMMENT ON COLUMN WIERSZE_ZAMOWIEN.ID_PRODUKTU IS 'Number of WYROBY (described in WYROBY) that pertains to the line WIERSZE_ZAMOWIEN.';
COMMENT ON COLUMN WIERSZE_ZAMOWIEN.CENA IS 'CENY to be paid by the KLIENCI in U.S. dollars.  The standard CENY is CENY.STANDARD_CENY, but in some instances, discounts are given to as low as CENY.MINIMUM_CENY.';
COMMENT ON COLUMN WIERSZE_ZAMOWIEN.ILOSC IS 'The amount of WYROBY to be ordered in this line WIERSZE_ZAMOWIEN.';
COMMENT ON COLUMN WIERSZE_ZAMOWIEN.WARTOSC IS 'The WARTOSC CENY (in U.S. dollars) of this line WIERSZE_ZAMOWIEN.  WARTOSC = CENA * ILOSC.';

-- Insert Data

INSERT INTO SIEDZIBY VALUES (122, 'NEW YORK');
INSERT INTO SIEDZIBY VALUES (124, 'DALLAS');
INSERT INTO SIEDZIBY VALUES (123, 'CHICAGO');
INSERT INTO SIEDZIBY VALUES (167, 'BOSTON');

INSERT INTO WYDZIALY VALUES (10,'ACCOUNTING','122');
INSERT INTO WYDZIALY VALUES (20,'RESEARCH','124');
INSERT INTO WYDZIALY VALUES (30,'SALES','123');
INSERT INTO WYDZIALY VALUES (40,'OPERATIONS','167');

INSERT INTO WYDZIALY VALUES
  ( 12 , 'RESEARCH', '122');

INSERT INTO WYDZIALY VALUES
  ( 13 , 'SALES', '122');

INSERT INTO WYDZIALY VALUES
  ( 14 , 'OPERATIONS', '122');

INSERT INTO WYDZIALY VALUES
  ( 23 , 'SALES', '124');

INSERT INTO WYDZIALY VALUES
  ( 24 , 'OPERATIONS', '124');

INSERT INTO WYDZIALY VALUES
  ( 34 , 'OPERATIONS', '123');

INSERT INTO WYDZIALY VALUES
  ( 43 , 'SALES', '167');

INSERT INTO ETATY VALUES (667, 'CLERK');
INSERT INTO ETATY VALUES (668, 'STAFF');
INSERT INTO ETATY VALUES (669, 'ANALYST');
INSERT INTO ETATY VALUES (670, 'SALESPERSON');
INSERT INTO ETATY VALUES (671, 'MANAGER');
INSERT INTO ETATY VALUES (672, 'PRESIDENT');

INSERT INTO POZIOMY_PENSJI VALUES (1,700,1200);
INSERT INTO POZIOMY_PENSJI VALUES (2,1201,1400);
INSERT INTO POZIOMY_PENSJI VALUES (3,1401,2000);
INSERT INTO POZIOMY_PENSJI VALUES (4,2001,3000);
INSERT INTO POZIOMY_PENSJI VALUES (5,3001,9999);

INSERT INTO PRACOWNICY VALUES
    (7369,'SMITH','JOHN','Q',667,7902,TO_DATE(2446052,'J'),800,NULL,20);
INSERT INTO PRACOWNICY VALUES
    (7499,'ALLEN','KEVIN','J',670,7698,TO_DATE(2446117,'J'),1600,300,30);
INSERT INTO PRACOWNICY VALUES
    (7505,'DOYLE','JEAN','K',671,7839,TO_DATE(2446160,'J'),2850,NULL,13);
INSERT INTO PRACOWNICY VALUES
    (7506,'DENNIS','LYNN','S',671,7839,TO_DATE(2446201,'J'),2750,NULL,23);
INSERT INTO PRACOWNICY VALUES
    (7507,'BAKER','LESLIE','D',671,7839,TO_DATE(2446227,'J'),2200,NULL,14);
INSERT INTO PRACOWNICY VALUES
    (7521,'WARD','CYNTHIA','D',670,7698,TO_DATE(2446119,'J'),1250,500,30);
INSERT INTO PRACOWNICY VALUES
    (7555,'PETERS','DANIEL','T',670,7505,TO_DATE(2446156,'J'),1250,300,13);
INSERT INTO PRACOWNICY VALUES
    (7557,'SHAW','KAREN','P',670,7505,TO_DATE(2446158,'J'),1250,1200,13);
INSERT INTO PRACOWNICY VALUES
    (7560,'DUNCAN','SARAH','S',670,7506,TO_DATE(2446217,'J'),1250,NULL,23);
INSERT INTO PRACOWNICY VALUES
    (7564,'LANGE','GREGORY','J',670,7506,TO_DATE(2446218,'J'),1250,300,23);
INSERT INTO PRACOWNICY VALUES
    (7566,'JONES','TERRY','M',671,7839,TO_DATE(2446158,'J'),2975,NULL,20);
INSERT INTO PRACOWNICY VALUES
    (7569,'ALBERTS','CHRIS','L',671,7839,TO_DATE(2446162,'J'),3000,NULL,12);
INSERT INTO PRACOWNICY VALUES
    (7600,'PORTER','RAYMOND','Y',670,7505,TO_DATE(2446171,'J'),1250,900,13);
INSERT INTO PRACOWNICY VALUES
    (7609,'LEWIS','RICHARD','M',668,7507,TO_DATE(2446172,'J'),1800,NULL,24);
INSERT INTO PRACOWNICY VALUES
    (7654,'MARTIN','KENNETH','J',670,7698,TO_DATE(2446337,'J'),1250,1400,30);
INSERT INTO PRACOWNICY VALUES
    (7676,'SOMMERS','DENISE','D',668,7507,TO_DATE(2446175,'J'),1850,NULL,34);
INSERT INTO PRACOWNICY VALUES
    (7698,'BLAKE','MARION','S',671,7839,TO_DATE(2446187,'J'),2850,NULL,30);
INSERT INTO PRACOWNICY VALUES
    (7782,'CLARK','CAROL','F',671,7839,TO_DATE(2446226,'J'),2450,NULL,10);
INSERT INTO PRACOWNICY VALUES
    (7788,'SCOTT','DONALD','T',669,7566,TO_DATE(2446774,'J'),3000,NULL,20);
INSERT INTO PRACOWNICY VALUES
    (7789,'WEST','LIVIA','N',670,7506,TO_DATE(2446160,'J'),1500,1000,23);
INSERT INTO PRACOWNICY VALUES
    (7799,'FISHER','MATTHEW','G',669,7569,TO_DATE(2446777,'J'),3000,NULL,12);
INSERT INTO PRACOWNICY VALUES
    (7820,'ROSS','PAUL','S',670,7505,TO_DATE(2446218,'J'),1300,800,43);
INSERT INTO PRACOWNICY VALUES
    (7839,'KING','FRANCIS','A',672,NULL,TO_DATE(2446387,'J'),5000,NULL,10);
INSERT INTO PRACOWNICY VALUES
    (7844,'TURNER','MARY','A',670,7698,TO_DATE(2446317,'J'),1500,0,30);
INSERT INTO PRACOWNICY VALUES
    (7876,'ADAMS','DIANE','G',667,7788,TO_DATE(2446808,'J'),1100,NULL,20);
INSERT INTO PRACOWNICY VALUES
    (7900,'JAMES','FRED','S',667,7698,TO_DATE(2446403,'J'),950,NULL,30);
INSERT INTO PRACOWNICY VALUES
    (7902,'FORD','JENNIFER','D',669,7566,TO_DATE(2446403,'J'),3000,NULL,20);
INSERT INTO PRACOWNICY VALUES
    (7916,'ROBERTS','GRACE','M',669,7569,TO_DATE(2446800,'J'),2875,NULL,12);
INSERT INTO PRACOWNICY VALUES
    (7919,'DOUGLAS','MICHAEL','A',667,7799,TO_DATE(2446800,'J'),800,NULL,12);
INSERT INTO PRACOWNICY VALUES
    (7934,'MILLER','BARBARA','M',667,7782,TO_DATE(2446454,'J'),1300,NULL,10);
INSERT INTO PRACOWNICY VALUES
    (7950,'JENSEN','ALICE','B',667,7505,TO_DATE(2446811,'J'),750,NULL,13);
INSERT INTO PRACOWNICY VALUES
    (7954,'MURRAY','JAMES','T',667,7506,TO_DATE(2446812,'J'),750,NULL,23);

INSERT INTO CENY VALUES
   (100871,4.8,3.2,TO_DATE(2447528,'J'),TO_DATE(2447862,'J'));
INSERT INTO CENY VALUES
   (100890,58,46.4,TO_DATE(2447528,'J'),NULL);
INSERT INTO CENY VALUES
   (100890,54,40.5,TO_DATE(2447314,'J'),TO_DATE(2447527,'J'));
INSERT INTO CENY VALUES
   (100860,35,28,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (100860,32,25.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (100860,30,24,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (100861,45,36,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (100861,42,33.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (100861,39,31.2,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (100870,2.8,2.4,TO_DATE(2447893,'J'),NULL);
INSERT INTO CENY VALUES
   (100870,2.4,1.9,TO_DATE(2447528,'J'),TO_DATE(2447862,'J'));
INSERT INTO CENY VALUES
   (100871,5.6,4.8,TO_DATE(2447893,'J'),NULL);
INSERT INTO CENY VALUES
   (101860,24,18,TO_DATE(2447573,'J'),NULL);
INSERT INTO CENY VALUES
   (101863,12.5,9.4,TO_DATE(2447573,'J'),NULL);
INSERT INTO CENY VALUES
   (102130,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO CENY VALUES
   (200376,2.4,1.75,TO_DATE(2448211,'J'),NULL);
INSERT INTO CENY VALUES
   (200380,4,3.2,TO_DATE(2448211,'J'),NULL);
INSERT INTO CENY VALUES
   (103120,23.2,18.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (103120,24,19.2,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (103120,25,20,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (103121,27.8,22.3,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (103121,28.8,23,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (103121,30,24,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (103130,4,3.5,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (103130,4.2,3.6,TO_DATE(2447893,'J'),NULL);
INSERT INTO CENY VALUES
   (103131,4.2,3.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (103131,4.5,3.9,TO_DATE(2447893,'J'),NULL);
INSERT INTO CENY VALUES
   (103140,20,15,TO_DATE(2447573,'J'),NULL);
INSERT INTO CENY VALUES
   (103141,20,15,TO_DATE(2447573,'J'),NULL);
INSERT INTO CENY VALUES
   (102132,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO CENY VALUES
   (104350,40,32,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (104350,42,33.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (104350,44,35.3,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (104351,23.6,18.9,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (104351,24.8,19.8,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (104351,26,20.8,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (104352,50,35,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (104352,54,37.8,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (104352,58.3,40.8,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (104360,36,29.5,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (104360,39,32,TO_DATE(2447893,'J'),NULL);
INSERT INTO CENY VALUES
   (104361,47,33,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (104361,50,35,TO_DATE(2447893,'J'),NULL);
INSERT INTO CENY VALUES
   (104362,5,4,TO_DATE(2447573,'J'),NULL);
INSERT INTO CENY VALUES
   (102134,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO CENY VALUES
   (105123,36.3,29,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (105123,37.7,32,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (105123,40,34,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (105124,10,7.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (105124,12,9,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO CENY VALUES
   (105124,15,10,TO_DATE(2448044,'J'),NULL);
INSERT INTO CENY VALUES
   (105125,2,1.7,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (105125,3,2.6,TO_DATE(2447893,'J'),NULL);
INSERT INTO CENY VALUES
   (105126,5,4.3,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO CENY VALUES
   (105126,6,5,TO_DATE(2447893,'J'),NULL);
INSERT INTO CENY VALUES
   (105127,6,5,TO_DATE(2448211,'J'),NULL);
INSERT INTO CENY VALUES
   (105128,10,8,TO_DATE(2448211,'J'),NULL);
INSERT INTO CENY VALUES
   (102136,3.4,2.8,TO_DATE(2447757,'J'),NULL);

INSERT INTO WYROBY VALUES ('100860', 'ACE TENNIS RACKET I');
INSERT INTO WYROBY VALUES ('100861', 'ACE TENNIS RACKET II');
INSERT INTO WYROBY VALUES ('100870', 'ACE TENNIS BALLS-3 PACK');
INSERT INTO WYROBY VALUES ('100871', 'ACE TENNIS BALLS-6 PACK');
INSERT INTO WYROBY VALUES ('100890', 'ACE TENNIS NET');
INSERT INTO WYROBY VALUES ('101860', 'SP TENNIS RACKET');
INSERT INTO WYROBY VALUES ('101863', 'SP JUNIOR RACKET');
INSERT INTO WYROBY VALUES ('102130', 'RH: "GUIDE TO TENNIS"');
INSERT INTO WYROBY VALUES ('200376', 'SB ENERGY BAR-6 PACK');
INSERT INTO WYROBY VALUES ('200380', 'SB VITA SNACK-6 PACK');
INSERT INTO WYROBY VALUES ( 103120 , 'WIFF SOFTBALL BAT I');
INSERT INTO WYROBY VALUES ( 103121 , 'WIFF SOFTBALL BAT II');
INSERT INTO WYROBY VALUES ( 103130 , 'WIFF SOFTBALL, SMALL');
INSERT INTO WYROBY VALUES ( 103131 , 'WIFF SOFTBALL, LARGE');
INSERT INTO WYROBY VALUES ( 103140 , 'WIFF SOFTBALL MITT (LH)');
INSERT INTO WYROBY VALUES ( 103141 , 'WIFF SOFTBALL MITT (RH)');
INSERT INTO WYROBY VALUES ( 102132 , 'RH: "GUIDE TO SOFTBALL"');
INSERT INTO WYROBY VALUES ( 104350 , 'DUNK BASKETBALL INDOOR');
INSERT INTO WYROBY VALUES ( 104351 , 'DUNK BASKETBALL OUTDOOR');
INSERT INTO WYROBY VALUES ( 104352 , 'DUNK BASKETBALL PROFESSIONAL');
INSERT INTO WYROBY VALUES ( 104360 , 'DUNK HOOP');
INSERT INTO WYROBY VALUES ( 104361 , 'DUNK HOOP W/FIBERGLASS BOARD');
INSERT INTO WYROBY VALUES ( 104362 , 'DUNK NETS - RAINBOW');
INSERT INTO WYROBY VALUES ( 102134 , 'RH: "GUIDE TO BASKETBALL"');
INSERT INTO WYROBY VALUES ( 105123 , 'YELLOW JERSEY BICYCLE HELMET');
INSERT INTO WYROBY VALUES ( 105124 , 'YELLOW JERSEY BICYCLE GLOVES');
INSERT INTO WYROBY VALUES ( 105125 , 'YELLOW JERSEY WATER BOTTLE');
INSERT INTO WYROBY VALUES ( 105126 , 'YELLOW JERSEY BOTTLE CAGE');
INSERT INTO WYROBY VALUES ( 105127 , 'YELLOW JERSEY FRAME PUMP');
INSERT INTO WYROBY VALUES ( 105128 , 'YELLOW JERSEY SADDLE PACK');
INSERT INTO WYROBY VALUES ( 102136 , 'RH: "GUIDE TO CYCLING"');

INSERT INTO ZAMOWIENIA VALUES
   (610,TO_DATE(2448264,'J'),101,TO_DATE(2448265,'J'),101.4);
INSERT INTO ZAMOWIENIA VALUES
   (611,TO_DATE(2448268,'J'),102,TO_DATE(2448268,'J'),45);
INSERT INTO ZAMOWIENIA VALUES
   (612,TO_DATE(2448272,'J'),104,TO_DATE(2448277,'J'),5860);
INSERT INTO ZAMOWIENIA VALUES
   (601,TO_DATE(2448013,'J'),106,TO_DATE(2448042,'J'),60.8);
INSERT INTO ZAMOWIENIA VALUES
   (602,TO_DATE(2448048,'J'),102,TO_DATE(2448063,'J'),56);
INSERT INTO ZAMOWIENIA VALUES
   (600,TO_DATE(2448013,'J'),103,TO_DATE(2448041,'J'),42);
INSERT INTO ZAMOWIENIA VALUES
   (604,TO_DATE(2448058,'J'),106,TO_DATE(2448073,'J'),642);
INSERT INTO ZAMOWIENIA VALUES
   (605,TO_DATE(2448087,'J'),106,TO_DATE(2448103,'J'),8374);
INSERT INTO ZAMOWIENIA VALUES
   (606,TO_DATE(2448087,'J'),100,TO_DATE(2448103,'J'),3.4);
INSERT INTO ZAMOWIENIA VALUES
   (609,TO_DATE(2448105,'J'),100,TO_DATE(2448119,'J'),102.5);
INSERT INTO ZAMOWIENIA VALUES
   (607,TO_DATE(2448091,'J'),104,TO_DATE(2448091,'J'),5.6);
INSERT INTO ZAMOWIENIA VALUES
   (608,TO_DATE(2448098,'J'),104,TO_DATE(2448098,'J'),35.2);
INSERT INTO ZAMOWIENIA VALUES
   (603,TO_DATE(2448048,'J'),102,TO_DATE(2448048,'J'),224);
INSERT INTO ZAMOWIENIA VALUES
   (620,TO_DATE(2448328,'J'),100,TO_DATE(2448328,'J'),4450);
INSERT INTO ZAMOWIENIA VALUES
   (613,TO_DATE(2448289,'J'),108,TO_DATE(2448289,'J'),6400);
INSERT INTO ZAMOWIENIA VALUES
   (614,TO_DATE(2448289,'J'),102,TO_DATE(2448293,'J'),23940);
INSERT INTO ZAMOWIENIA VALUES
   (616,TO_DATE(2448291,'J'),103,TO_DATE(2448298,'J'),764);
INSERT INTO ZAMOWIENIA VALUES
   (619,TO_DATE(2448310,'J'),104,TO_DATE(2448320,'J'),1260);
INSERT INTO ZAMOWIENIA VALUES
   (617,TO_DATE(2448293,'J'),105,TO_DATE(2448319,'J'),46370);
INSERT INTO ZAMOWIENIA VALUES
   (615,TO_DATE(2448289,'J'),107,TO_DATE(2448294,'J'),710);
INSERT INTO ZAMOWIENIA VALUES
   (618,TO_DATE(2448303,'J'),102,TO_DATE(2448322,'J'),3083);
INSERT INTO ZAMOWIENIA VALUES
   (621,TO_DATE(2448331,'J'),100,TO_DATE(2448348,'J'),730);
INSERT INTO ZAMOWIENIA VALUES
   (509,TO_DATE(2447682,'J'),226,TO_DATE(2447688,'J'),1174);
INSERT INTO ZAMOWIENIA VALUES
   (523,TO_DATE(2447936,'J'),226,TO_DATE(2447936,'J'),1165);
INSERT INTO ZAMOWIENIA VALUES
   (549,TO_DATE(2448253,'J'),226,TO_DATE(2448271,'J'),1620);
INSERT INTO ZAMOWIENIA VALUES
   (507,TO_DATE(2447673,'J'),228,TO_DATE(2447674,'J'),886);
INSERT INTO ZAMOWIENIA VALUES
   (516,TO_DATE(2447800,'J'),228,TO_DATE(2447803,'J'),1815);
INSERT INTO ZAMOWIENIA VALUES
   (553,TO_DATE(2448290,'J'),228,TO_DATE(2448301,'J'),4400);
INSERT INTO ZAMOWIENIA VALUES
   (526,TO_DATE(2447955,'J'),221,TO_DATE(2447958,'J'),7700);
INSERT INTO ZAMOWIENIA VALUES
   (543,TO_DATE(2448139,'J'),221,TO_DATE(2448142,'J'),8400);
INSERT INTO ZAMOWIENIA VALUES
   (555,TO_DATE(2448320,'J'),221,TO_DATE(2448323,'J'),8540);
INSERT INTO ZAMOWIENIA VALUES
   (559,TO_DATE(2448212,'J'),222,TO_DATE(2448370,'J'),387.2);
INSERT INTO ZAMOWIENIA VALUES
   (528,TO_DATE(2447975,'J'),224,TO_DATE(2447975,'J'),3770);
INSERT INTO ZAMOWIENIA VALUES
   (531,TO_DATE(2447982,'J'),224,TO_DATE(2447984,'J'),1400);
INSERT INTO ZAMOWIENIA VALUES
   (558,TO_DATE(2448347,'J'),224,TO_DATE(2448349,'J'),1700);
INSERT INTO ZAMOWIENIA VALUES
   (525,TO_DATE(2447951,'J'),225,TO_DATE(2447954,'J'),377);
INSERT INTO ZAMOWIENIA VALUES
   (552,TO_DATE(2448290,'J'),223,TO_DATE(2448295,'J'),555.8);
INSERT INTO ZAMOWIENIA VALUES
   (556,TO_DATE(2448326,'J'),223,TO_DATE(2448328,'J'),85);
INSERT INTO ZAMOWIENIA VALUES
   (560,TO_DATE(2448372,'J'),223,TO_DATE(2448372,'J'),72);
INSERT INTO ZAMOWIENIA VALUES
   (565,TO_DATE(2448409,'J'),227,TO_DATE(2448411,'J'),4900);
INSERT INTO ZAMOWIENIA VALUES
   (574,TO_DATE(2448540,'J'),201,TO_DATE(2448542,'J'),1685);
INSERT INTO ZAMOWIENIA VALUES
   (576,TO_DATE(2448543,'J'),201,TO_DATE(2448548,'J'),2058.9);
INSERT INTO ZAMOWIENIA VALUES
   (503,TO_DATE(2447611,'J'),201,TO_DATE(2447623,'J'),1876);
INSERT INTO ZAMOWIENIA VALUES
   (518,TO_DATE(2447820,'J'),201,TO_DATE(2447836,'J'),2932.5);
INSERT INTO ZAMOWIENIA VALUES
   (517,TO_DATE(2447823,'J'),201,TO_DATE(2447838,'J'),784);
INSERT INTO ZAMOWIENIA VALUES
   (544,TO_DATE(2448146,'J'),202,TO_DATE(2448150,'J'),2358);
INSERT INTO ZAMOWIENIA VALUES
   (524,TO_DATE(2447945,'J'),202,TO_DATE(2447955,'J'),1979);
INSERT INTO ZAMOWIENIA VALUES
   (502,TO_DATE(2447568,'J'),202,TO_DATE(2447581,'J'),500);
INSERT INTO ZAMOWIENIA VALUES
   (539,TO_DATE(2448069,'J'),202,TO_DATE(2448076,'J'),1300);
INSERT INTO ZAMOWIENIA VALUES
   (511,TO_DATE(2447756,'J'),202,TO_DATE(2447760,'J'),647);
INSERT INTO ZAMOWIENIA VALUES
   (512,TO_DATE(2447767,'J'),203,TO_DATE(2447783,'J'),428);
INSERT INTO ZAMOWIENIA VALUES
   (562,TO_DATE(2448381,'J'),203,TO_DATE(2448396,'J'),2044.5);
INSERT INTO ZAMOWIENIA VALUES
   (529,TO_DATE(2447984,'J'),203,TO_DATE(2447987,'J'),1264.7);
INSERT INTO ZAMOWIENIA VALUES
   (563,TO_DATE(2448402,'J'),204,TO_DATE(2448403,'J'),889);
INSERT INTO ZAMOWIENIA VALUES
   (568,TO_DATE(2448451,'J'),204,TO_DATE(2448459,'J'),1217.4);
INSERT INTO ZAMOWIENIA VALUES
   (504,TO_DATE(2447628,'J'),204,TO_DATE(2447629,'J'),1434.7);
INSERT INTO ZAMOWIENIA VALUES
   (538,TO_DATE(2448066,'J'),204,TO_DATE(2448069,'J'),741);
INSERT INTO ZAMOWIENIA VALUES
   (535,TO_DATE(2448040,'J'),204,TO_DATE(2448052,'J'),810);
INSERT INTO ZAMOWIENIA VALUES
   (578,TO_DATE(2448580,'J'),204,TO_DATE(2448595,'J'),2275.6);
INSERT INTO ZAMOWIENIA VALUES
   (534,TO_DATE(2448023,'J'),206,TO_DATE(2448027,'J'),420);
INSERT INTO ZAMOWIENIA VALUES
   (536,TO_DATE(2448033,'J'),206,TO_DATE(2448049,'J'),2135.6);
INSERT INTO ZAMOWIENIA VALUES
   (572,TO_DATE(2448488,'J'),206,TO_DATE(2448493,'J'),1200.5);
INSERT INTO ZAMOWIENIA VALUES
   (514,TO_DATE(2447775,'J'),207,TO_DATE(2447786,'J'),1140);
INSERT INTO ZAMOWIENIA VALUES
   (521,TO_DATE(2447851,'J'),207,TO_DATE(2447854,'J'),896.9);
INSERT INTO ZAMOWIENIA VALUES
   (551,TO_DATE(2448279,'J'),208,TO_DATE(2448294,'J'),1142);
INSERT INTO ZAMOWIENIA VALUES
   (513,TO_DATE(2447776,'J'),208,TO_DATE(2447784,'J'),1497);
INSERT INTO ZAMOWIENIA VALUES
   (508,TO_DATE(2447673,'J'),208,TO_DATE(2447686,'J'),1080);
INSERT INTO ZAMOWIENIA VALUES
   (515,TO_DATE(2447789,'J'),208,TO_DATE(2447796,'J'),1428.5);
INSERT INTO ZAMOWIENIA VALUES
   (542,TO_DATE(2448115,'J'),208,TO_DATE(2448127,'J'),2409);
INSERT INTO ZAMOWIENIA VALUES
   (573,TO_DATE(2448540,'J'),201,TO_DATE(2448542,'J'),1627);
INSERT INTO ZAMOWIENIA VALUES
   (566,TO_DATE(2448417,'J'),201,TO_DATE(2448420,'J'),3389.2);
INSERT INTO ZAMOWIENIA VALUES
   (520,TO_DATE(2447847,'J'),201,TO_DATE(2447850,'J'),341.6);
INSERT INTO ZAMOWIENIA VALUES
   (519,TO_DATE(2447820,'J'),201,TO_DATE(2447836,'J'),955);
INSERT INTO ZAMOWIENIA VALUES
   (575,TO_DATE(2448534,'J'),201,TO_DATE(2448547,'J'),684);
INSERT INTO ZAMOWIENIA VALUES
   (547,TO_DATE(2448181,'J'),202,TO_DATE(2448192,'J'),984.4);
INSERT INTO ZAMOWIENIA VALUES
   (540,TO_DATE(2448088,'J'),202,TO_DATE(2448090,'J'),861.2);
INSERT INTO ZAMOWIENIA VALUES
   (567,TO_DATE(2448443,'J'),202,TO_DATE(2448445,'J'),200);
INSERT INTO ZAMOWIENIA VALUES
   (570,TO_DATE(2448455,'J'),202,TO_DATE(2448462,'J'),663.6);
INSERT INTO ZAMOWIENIA VALUES
   (571,TO_DATE(2448471,'J'),202,TO_DATE(2448481,'J'),1095.6);
INSERT INTO ZAMOWIENIA VALUES
   (541,TO_DATE(2448112,'J'),203,TO_DATE(2448122,'J'),400);
INSERT INTO ZAMOWIENIA VALUES
   (532,TO_DATE(2447990,'J'),203,TO_DATE(2448003,'J'),1295.4);
INSERT INTO ZAMOWIENIA VALUES
   (527,TO_DATE(2447950,'J'),204,TO_DATE(2447965,'J'),3054.4);
INSERT INTO ZAMOWIENIA VALUES
   (501,TO_DATE(2447533,'J'),204,TO_DATE(2447538,'J'),216);
INSERT INTO ZAMOWIENIA VALUES
   (564,TO_DATE(2448402,'J'),204,TO_DATE(2448403,'J'),898.8);
INSERT INTO ZAMOWIENIA VALUES
   (537,TO_DATE(2448057,'J'),204,TO_DATE(2448069,'J'),672.9);
INSERT INTO ZAMOWIENIA VALUES
   (522,TO_DATE(2447899,'J'),204,TO_DATE(2447902,'J'),2578.8);
INSERT INTO ZAMOWIENIA VALUES
   (554,TO_DATE(2448306,'J'),204,TO_DATE(2448310,'J'),282.8);
INSERT INTO ZAMOWIENIA VALUES
   (569,TO_DATE(2448454,'J'),205,TO_DATE(2448461,'J'),2073);
INSERT INTO ZAMOWIENIA VALUES
   (550,TO_DATE(2448284,'J'),205,TO_DATE(2448295,'J'),2356);
INSERT INTO ZAMOWIENIA VALUES
   (548,TO_DATE(2448222,'J'),205,TO_DATE(2448238,'J'),666.9);
INSERT INTO ZAMOWIENIA VALUES
   (505,TO_DATE(2447624,'J'),206,TO_DATE(2447639,'J'),650);
INSERT INTO ZAMOWIENIA VALUES
   (577,TO_DATE(2448536,'J'),206,TO_DATE(2448550,'J'),1265.75);
INSERT INTO ZAMOWIENIA VALUES
   (533,TO_DATE(2448010,'J'),206,TO_DATE(2448014,'J'),1122.1);
INSERT INTO ZAMOWIENIA VALUES
   (561,TO_DATE(2448367,'J'),207,TO_DATE(2448384,'J'),2558.3);
INSERT INTO ZAMOWIENIA VALUES
   (506,TO_DATE(2447644,'J'),208,TO_DATE(2447657,'J'),2600.4);
INSERT INTO ZAMOWIENIA VALUES
   (530,TO_DATE(2447985,'J'),208,TO_DATE(2447989,'J'),3026.5);
INSERT INTO ZAMOWIENIA VALUES
   (545,TO_DATE(2448171,'J'),208,TO_DATE(2448178,'J'),475);
INSERT INTO ZAMOWIENIA VALUES
   (557,TO_DATE(2448324,'J'),208,TO_DATE(2448328,'J'),2461.8);
INSERT INTO ZAMOWIENIA VALUES
   (546,TO_DATE(2448182,'J'),208,TO_DATE(2448188,'J'),3663);
INSERT INTO ZAMOWIENIA VALUES
   (510,TO_DATE(2447726,'J'),208,TO_DATE(2447729,'J'),1336.6);

INSERT INTO WIERSZE_ZAMOWIEN VALUES (600,1,100861,42,1,42);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (610,3,100890,58,1,58);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (611,1,100861,45,1,45);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (612,1,100860,30,100,3000);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (601,1,200376,2.4,12,28.8);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (601,2,100860,32,1,32);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (602,1,100870,2.8,20,56);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (604,1,100890,58,3,174);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (604,2,100861,42,2,84);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (604,3,100860,32,12,384);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (603,1,100860,32,7,224);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (610,1,100860,35,1,35);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (610,2,100870,2.8,3,8.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (613,4,200376,2.2,200,440);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (614,1,100860,35,444,15540);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (614,2,100870,2.8,1000,2800);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (612,2,100861,40.5,20,810);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (612,3,101863,10,150,1500);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (620,1,100860,35,10,350);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (620,2,200376,2.4,1000,2400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (620,3,102130,3.4,500,1700);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (613,1,100871,5.6,100,560);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (613,2,101860,24,200,4800);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (613,3,200380,4,150,600);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (619,3,102130,3.4,100,340);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,1,100860,35,50,1750);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,2,100861,45,100,4500);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (614,3,100871,5.6,1000,5600);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (616,1,100861,45,10,450);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (616,2,100870,2.8,50,140);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (616,3,100890,58,2,116);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (616,4,102130,3.4,10,34);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (616,5,200376,2.4,10,24);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (619,1,200380,4,100,400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (619,2,200376,2.4,100,240);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (615,1,100861,45,4,180);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (607,1,100871,5.6,1,5.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (615,2,100870,2.8,100,280);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,3,100870,2.8,500,1400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,4,100871,5.6,500,2800);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,5,100890,58,500,29000);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,6,101860,24,100,2400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,7,101863,12.5,200,2500);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,8,102130,3.4,100,340);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,9,200376,2.4,200,480);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (617,10,200380,4,300,1200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (609,2,100870,2.5,5,12.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (609,3,100890,50,1,50);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (618,1,100860,35,23,805);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (618,2,100861,45,50,2250);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (618,3,100870,2.8,10,28);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (621,1,100861,45,10,450);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (621,2,100870,2.8,100,280);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (615,3,100871,5,50,250);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (608,1,101860,24,1,24);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (608,2,100871,5.6,2,11.2);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (609,1,100861,40,1,40);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (606,1,102130,3.4,1,3.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (605,1,100861,45,100,4500);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (605,2,100870,2.8,500,1400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (605,3,100890,58,5,290);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (605,4,101860,24,50,1200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (605,5,101863,9.5,100,950);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (605,6,102130,3.4,10,34);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (612,4,100871,5.5,100,550);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (619,4,100871,5.6,50,280);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (509,1,105123,35,30,1050);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (509,2,105124,9,10,90);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (509,3,102136,3.4,10,34);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (523,1,102136,3.4,10,34);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (523,2,105123,37.7,30,1131);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (549,1,105123,38,5,190);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (549,2,105127,6,30,180);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (549,3,105125,3,200,600);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (549,4,105124,13,50,650);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (507,1,105123,35.3,20,706);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (507,2,105124,9,20,180);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (516,1,105124,9,60,540);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (516,2,102136,3.2,250,800);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (516,3,105125,1.9,250,475);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (553,1,105127,6,500,3000);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (553,2,200376,1.75,800,1400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (526,1,105123,32,100,3200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (526,2,105124,9,500,4500);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (543,1,105123,34,100,3400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (543,2,105124,10,500,5000);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (555,1,105123,34,100,3400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (555,2,105124,10,500,5000);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (555,3,102136,2.8,50,140);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (559,1,105123,40,5,200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (559,2,105124,15,5,75);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (559,3,105127,6,5,30);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (559,4,102136,3.4,3,10.2);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (559,5,200376,2.4,30,72);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (528,1,105123,37.7,100,3770);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (531,1,105124,11,100,1100);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (531,2,102136,3,100,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (558,1,105124,14,100,1400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (558,2,102136,3,100,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (525,1,105123,37.7,10,377);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (552,1,105123,40,10,400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (552,2,105124,15,10,150);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (552,3,102136,3.4,1,3.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (552,4,200376,2.4,1,2.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (556,1,102136,3.4,25,85);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (560,1,200376,2.4,30,72);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (565,1,105123,37,100,3700);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (565,2,105124,12,100,1200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (574,1,104350,41.8,25,1045);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (574,2,200380,3.2,200,640);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (576,1,104350,44,10,440);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (576,2,104351,26,10,260);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (576,3,104362,4.25,170,722.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (576,4,200376,2.16,90,194.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (576,5,200380,3.4,130,442);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (503,1,104350,38,30,1140);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (503,2,104351,23.6,10,236);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (503,3,104352,50,10,500);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (518,1,104350,38,25,950);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (518,2,104351,23.6,20,472);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (518,3,104360,36,20,720);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (518,4,104362,4.25,170,722.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (518,5,102134,3.4,20,68);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (517,1,104352,50,15,750);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (517,2,102134,3.4,10,34);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (544,1,104350,44,15,660);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (544,2,104351,26,15,390);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (544,3,104352,58.3,10,583);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (544,4,104361,50,10,500);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (544,5,104362,4.5,50,225);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (524,1,104350,42,10,420);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (524,2,104351,23.56,35,824.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (524,3,104362,4.25,150,637.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (524,4,102134,3.23,30,96.9);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (502,1,104352,50,10,500);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (539,1,104351,26,20,520);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (539,2,104360,39,20,780);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (511,1,104351,23.6,15,354);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (511,2,104362,4.5,50,225);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (511,3,102134,3.4,20,68);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (512,1,104360,36,10,360);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (512,2,102134,3.4,20,68);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (562,1,104351,24.7,25,617.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (562,2,104352,58.3,15,874.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (562,3,104362,4.25,130,552.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (529,1,104350,39.89,30,1196.7);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (529,2,102134,3.4,20,68);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (563,1,104352,58.3,10,583);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (563,2,200376,2.04,150,306);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (568,1,104351,24.7,30,741);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (568,2,200376,2.04,110,224.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (568,3,200380,3.6,70,252);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (504,1,104350,40,10,400);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (504,2,104351,22.42,35,784.7);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (504,3,104352,50,5,250);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (538,1,104351,24.7,30,741);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (535,1,104352,54,15,810);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (578,1,104350,41.8,40,1672);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (578,2,200376,2.04,190,387.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (578,3,200380,3.6,60,216);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (534,1,104350,42,10,420);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (536,1,104350,39.89,40,1595.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (536,2,104352,54,10,540);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (572,1,104351,24.7,25,617.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (572,2,104352,58.3,10,583);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (514,1,104350,38,30,1140);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (521,1,104350,40,20,800);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (521,2,102134,3.23,30,96.9);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (551,1,104350,44,10,440);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (551,2,104361,50,5,250);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (551,3,102134,3.4,20,68);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (551,4,200376,1.92,200,384);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (513,1,104350,40,15,600);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (513,2,104351,23.6,20,472);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (513,3,104362,4.25,100,425);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (508,1,104360,36,20,720);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (508,2,104362,4.5,80,360);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (515,1,104350,40,20,800);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (515,2,104351,22.42,25,560.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (515,3,102134,3.4,20,68);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (542,1,104350,41.8,25,1045);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (542,2,104360,39,20,780);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (542,3,104361,50,11,550);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (542,4,102134,3.4,10,34);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (573,1,103120,22.5,50,1125);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (573,2,103131,4.04,50,202);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (573,3,103141,20,15,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (566,1,103120,23.75,40,950);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (566,2,103121,27,50,1350);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (566,3,103130,3.77,60,226.2);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (566,4,103131,3.9,170,663);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (566,5,103141,20,10,200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (520,1,103130,4,10,40);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (520,2,103131,3.77,80,301.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (519,1,103130,3.5,110,385);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (519,2,103140,19,30,570);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (575,1,103140,19,30,570);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (575,2,200380,3.8,30,114);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (547,1,103130,3.77,80,301.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (547,2,103131,4.04,70,282.8);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (547,3,103140,20,15,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (547,4,103141,20,5,100);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (540,1,103130,3.98,40,159.2);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (540,2,103131,3.9,180,702);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (567,1,103140,20,10,200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (570,1,103131,4.04,90,363.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (570,2,103140,20,15,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (571,1,103131,4.04,70,282.8);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (571,2,103140,19,25,475);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (571,3,102132,3.4,15,51);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (571,4,200376,2.16,80,172.8);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (571,5,200380,3.8,30,114);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (541,1,103140,20,10,200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (541,2,103141,20,10,200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (532,1,103120,21.59,60,1295.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (527,1,103120,21.59,60,1295.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (527,2,103121,27.35,40,1094);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (527,3,103140,19,35,665);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (501,1,103130,3.6,60,216);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (564,1,103130,3.77,80,301.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (564,2,103131,3.9,120,468);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (564,3,102132,3.23,40,129.2);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (537,1,103130,3.6,160,576);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (537,2,102132,3.23,30,96.9);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (522,1,103120,21.59,80,1727.2);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (522,2,103121,28.8,10,288);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (522,3,103131,4.04,90,363.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (522,4,103141,20,10,200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (554,1,103131,4.04,70,282.8);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (569,1,103120,22.5,50,1125);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (569,2,103130,3.6,180,648);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (569,3,103141,20,15,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (550,1,103120,22.5,60,1350);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (550,2,103140,19,45,855);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (550,3,103141,20,5,100);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (550,4,102132,3.4,15,51);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (548,1,103140,19,30,570);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (548,2,102132,3.23,30,96.9);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (505,1,103130,3.5,100,350);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (505,2,103140,20,15,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (577,1,103121,30,20,600);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (577,2,103131,3.9,150,585);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (577,3,102132,3.23,25,80.75);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (533,1,103121,27.35,30,820.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (533,2,103130,3.77,80,301.6);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (561,1,103120,22.5,80,1800);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (561,2,103130,3.77,70,263.9);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (561,3,103141,20,15,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (561,4,200376,2.16,90,194.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (506,1,103120,20.88,80,1670.4);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (506,2,103130,3.5,180,630);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (506,3,103141,20,15,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (530,1,103121,25.91,50,1295.5);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (530,2,103130,3.6,200,720);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (530,3,103140,19,40,760);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (530,4,103141,20,10,200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (530,5,102132,3.4,15,51);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (545,1,103140,19,25,475);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (557,1,103120,23.75,40,950);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (557,2,103121,30,10,300);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (557,3,103140,19,35,665);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (557,4,200376,2.16,80,172.8);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (557,5,200380,3.4,110,374);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (546,1,103120,22.5,50,1125);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (546,2,103121,30,20,600);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (546,3,103130,3.6,120,432);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (546,4,103131,3.9,140,546);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (546,5,103140,19,40,760);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (546,6,103141,20,10,200);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (510,1,103120,20.88,60,1252.8);
INSERT INTO WIERSZE_ZAMOWIEN VALUES (510,2,103131,4.19,20,83.8);

INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('96711', 'CA', '7844', '5986609', 
  'JOCKSPORTS',
  '100', '5000', 'BELMONT', '415', '345 VIEWRIDGE', 
  'Very friendly people to work with -- WYNIKI_SPRZEDAZY rep likes to be called Mike.');
 
INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('94061', 'CA', '7521', '3681223',
  'TKB SPORT SHOP',
  '101', '10000', 'REDWOOD MIASTO', '415', '490 BOLI RD.', 
  'Rep called 5/8 about change in order - contact shipping.');
                                                              
INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('95133', 'CA', '7654', '6443341', 
  'VOLLYRITE',
  '102', '7000', 'BURLINGAME', '415', '9722 HAMILTON', 
  'Company doing heavy promotion beginning 10/89. Prepare for large orders during winter.');
 
INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('97544', 'CA', '7521', '6779312',
  'JUST TENNIS',
  '103', '3000', 'BURLINGAME', '415', 'HILLVIEW MALL', 
  'Contact rep about new line of tennis rackets.');
                                                             
INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('93301', 'CA', '7499', '9962323',
  'EVERY MOUNTAIN',
  '104', '10000', 'CUPERTINO', '408', '574 SURRY RD.', 
  'KLIENCI with high market share (23%) due to aggressive advertising.');
                                                      
INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('91003', 'CA', '7844', '3769966',
  'K + T SPORTS',
  '105', '5000', 'SANTA CLARA', '408', '3476 EL PASEO', 
  'Tends to order large amounts of merchandise at once. Accounting is considering raising their credit limit. Usually pays on time.');
                                                      
INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('94301', 'CA', '7521', '3649777',
  'SHAPE UP',
  '106', '6000', 'PALO ALTO', '415', '908 SEQUOIA', 
  'Support intensive. Orders small amounts (< 800) of merchandise at a time.');
 
INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('93301', 'CA', '7499', '9674398',
  'WOMENS SPORTS',
  '107', '10000', 'SUNNYVALE', '408', 'VALCO VILLAGE', 
  'First sporting goods store geared exclusively towards women. Unusual promotional style and very willing to take chances towards new WYROBYs!');
            
INSERT INTO KLIENCI
  (KOD_POCZTOWY, STAN, ID_PRACOWNIKA, TELEFON, 
  NAZWA, 
  ID_KLIENTA, LIMIT_KREDYTOWY, MIASTO, NR_KIERUNKOWY, ADRES, 
  KOMENTARZ)
  VALUES ('55649', 'MN', '7844', '5669123',
  'NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER',
  '108', '8000', 'HIBBING', '612', '98 LONE PINE WAY', '');

INSERT INTO KLIENCI VALUES
  ( 201 , 'STADIUM SPORTS', '47 IRVING PL.',
  'NEW YORK', 'NY', '10003',
  '212', '5555335',  7557 ,  10000 ,
  'Large general-purpose sports store with an affluent KLIENCI base.');

INSERT INTO KLIENCI VALUES
  ( 202 , 'HOOPS', '2345 ADAMS AVE.',
  'LEICESTER', 'MA', '01524',
  '508', '5557542',  7820 ,  5000 ,
  'Specializes in basketball equipment.');

INSERT INTO KLIENCI VALUES
  ( 203 , 'REBOUND SPORTS', '2 E. 14TH ST.',
  'NEW YORK', 'NY', '10009',
  '212', '5555989',  7557 ,  10000 ,
  'Follow up on the promotion proposal.');

INSERT INTO KLIENCI VALUES
  ( 204 , 'THE POWER FORWARD', '1 KNOTS LANDING',
  'DALLAS', 'TX', '75248',
  '214', '5550505',  7560 ,  12000 ,
  'Large floorspace.  Prefers maintaining large amounts of inventory on hand.');

INSERT INTO KLIENCI VALUES
  ( 205 , 'POINT GUARD', '20 THURSTON ST.',
  'YONKERS', 'NY', '10956',
  '914', '5554766',  7557 ,  3000 ,
  'Tremendous potential for an exclusive agreement.');

INSERT INTO KLIENCI VALUES
  ( 206 , 'THE COLISEUM', '5678 WILBUR PL.',
  'SCARSDALE', 'NY', '10583',
  '914', '5550217',  7557 ,  6000 ,
  'Contact rep. about new WYROBY lines.');

INSERT INTO KLIENCI VALUES
  ( 207 , 'FAST BREAK', '1000 HERBERT LN.',
  'CONCORD', 'MA', '01742',
  '508', '5551298',  7820 ,  7000 ,
  'KLIENCI requires written CENY quotes before making purchase requisitions.');

INSERT INTO KLIENCI VALUES
  ( 208 , 'AL AND BOB''S SPORTS', '260 YORKTOWN CT.',
  'AUSTIN', 'TX', '78731',
  '512', '5557631',  7560 ,  4000 ,
  'Very personal purchasing agents -- Sharon and Scott.');

INSERT INTO KLIENCI VALUES
  ( 211 , 'AT BAT', '234 BEACHEM ST.',
  'BROOKLINE', 'MA', '02146',
  '617', '5557385',  7820 ,  8000 ,
  'Have an open purchase order for $3000.  Ship immediately on request.');

INSERT INTO KLIENCI VALUES
  ( 212 , 'ALL SPORT', '1000 38TH ST.',
  'BROOKLYN', 'NY', '11210',
  '718', '5551739',  7600 ,  6000 ,
  'Pursue a contract -- possible candidate for volume purchasing agreements.');

INSERT INTO KLIENCI VALUES
  ( 213 , 'GOOD SPORT', '400 46TH ST.',
  'SUNNYSIDE', 'NY', '11104',
  '718', '5553771',  7600 ,  5000 ,
  'May be moving to a larger SIEDZIBY.');

INSERT INTO KLIENCI VALUES
  ( 214 , 'AL''S PRO SHOP', '45 SPRUCE ST.',
  'SPRING', 'TX', '77388',
  '713', '5555172',  7564 ,  8000 ,
  'Target market is serious athletes.');

INSERT INTO KLIENCI VALUES
  ( 215 , 'BOB''S FAMILY SPORTS', '400 E. 23RD',
  'HOUSTON', 'TX', '77026',
  '713', '5558015',  7654 ,  8000 ,
  'Target market is casual and weekend athletes.  Offers a large selection.');

INSERT INTO KLIENCI VALUES
  ( 216 , 'THE ALL AMERICAN', '547 PRENTICE RD.',
  'CHELSEA', 'MA', '02150',
  '617', '5553047',  7820 ,  5000 ,
  'KLIENCI prefers to be called between 10 and 12.');

INSERT INTO KLIENCI VALUES
  ( 217 , 'HIT, THROW, AND RUN', '333 WOOD COURT',
  'GRAPEVINE', 'TX', '76051',
  '817', '5552352',  7564 ,  6000 ,
  'General purpose sports store.');

INSERT INTO KLIENCI VALUES
  ( 218 , 'THE OUTFIELD', '346 GARDEN BLVD.',
  'FLUSHING', 'NY', '11355',
  '718', '5552131',  7820 ,  4000 ,
  'Store does not open until 11am and does not have an answering service.');

INSERT INTO KLIENCI VALUES
  ( 221 , 'WHEELS AND DEALS', '2 MEMORIAL DRIVE',
  'HOUSTON', 'TX', '77007',
  '713', '5554139',  7789 ,  10000 ,
  'Discount bicycle and sporting good store.');

INSERT INTO KLIENCI VALUES
  ( 222 , 'JUST BIKES', '4000 PARKRIDGE BLVD.',
  'DALLAS', 'TX', '75205',
  '214', '5558735',  7789 ,  4000 ,
  'Exclusive bicycle dealer.');

INSERT INTO KLIENCI VALUES
  ( 223 , 'VELO SPORTS', '23 WHITE ST.',
  'MALDEN', 'MA', '02148',
  '617', '5554983',  7820 ,  5000 ,
  'Clerk answers all phone lines.  Ask for Mike.');

INSERT INTO KLIENCI VALUES
  ( 224 , 'JOE''S BIKE SHOP', '4500 FOX COURT',
  'GRAND PRARIE', 'TX', '75051',
  '214', '5559834',  7789 ,  6000 ,
  'Call Joe to make sure last shipment was complete.');

INSERT INTO KLIENCI VALUES
  ( 225 , 'BOB''S SWIM, CYCLE, AND RUN', '300 HORSECREEK CIRCLE',
  'IRVING', 'TX', '75039',
  '214', '5558388',  7789 ,  7000 ,
  'Store catering to triathletes.');

INSERT INTO KLIENCI VALUES
  ( 226 , 'CENTURY SHOP', '8 DAGMAR DR.',
  'HUNTINGTON', 'NY', '11743',
  '516', '5553006',  7555 ,  4000 ,
  'KLIENCI in the midst of a cost-cutting program.');

INSERT INTO KLIENCI VALUES
  ( 227 , 'THE TOUR', '2500 GARDNER RD.',
  'SOMERVILLE', 'MA', '02144',
  '617', '5556673',  7820 ,  5000 ,
  'KLIENCI referred to us by The All American.');

INSERT INTO KLIENCI VALUES
  ( 228 , 'FITNESS FIRST', '5000 85TH ST.',
  'JACKSON HEIGHTS', 'NY', '11372',
  '718', '5558710',  7555 ,  4000 ,
  'Recently acquired another sporting goods store.  Expect higher volume in the future.');

COMMIT;

-- Create indexes

CREATE UNIQUE INDEX I_SIEDZIBY$ID_SIEDZIBY ON SIEDZIBY (ID_SIEDZIBY);
CREATE UNIQUE INDEX I_WYDZIALY$ID_WYDZIALU ON WYDZIALY (ID_WYDZIALU);
CREATE UNIQUE INDEX I_ETATY$ID_ETATU ON ETATY (ID_ETATU);
CREATE UNIQUE INDEX I_PRACOWNICY$ID_PRACOWNIKA ON PRACOWNICY (ID_PRACOWNIKA);
CREATE UNIQUE INDEX I_POZIOMY_PENSJI$ID_POZIOMU ON POZIOMY_PENSJI (ID_POZIOMU);
CREATE UNIQUE INDEX I_WYROBY$ID_PRODUKTU ON WYROBY (ID_PRODUKTU);
CREATE UNIQUE INDEX I_CENY ON CENY (ID_PRODUKTU, DATA_OBWIAZYWANIA);
CREATE UNIQUE INDEX I_KLIENCI$ID_KLIENTA ON KLIENCI (ID_KLIENTA);
CREATE UNIQUE INDEX I_ZAMOWIENIA$ID_ZAMOWIENIA ON ZAMOWIENIA (ID_ZAMOWIENIA);
CREATE UNIQUE INDEX I_WIERSZE_ZAMOWIEN ON WIERSZE_ZAMOWIEN (ID_ZAMOWIENIA, ID_WIERSZA_ZAM);

-- Add constraints

ALTER TABLE KLIENCI ADD /* CONSTRAINT ID_KLIENTA_NN */
   CHECK (ID_KLIENTA IS NOT NULL);
ALTER TABLE KLIENCI ADD /* CONSTRAINT WYNIKI_SPRZEDAZYPERSON_ID_NN */
   CHECK (ID_PRACOWNIKA IS NOT NULL);
ALTER TABLE KLIENCI ADD /* CONSTRAINT ID_KLIENTA_ZERO */
   CHECK (ID_KLIENTA > 0);
ALTER TABLE KLIENCI ADD /* CONSTRAINT STAN_ALL_CAPS */
   CHECK (STAN = UPPER(STAN));
ALTER TABLE KLIENCI ADD /* CONSTRAINT KOD_POCZTOWY_FULL */
   CHECK (LENGTH(NVL(KOD_POCZTOWY, '99999')) IN (5, 9));
ALTER TABLE WYDZIALY ADD /* CONSTRAINT DEPTNO_NN */
   CHECK (ID_WYDZIALU IS NOT NULL);
ALTER TABLE PRACOWNICY ADD /* CONSTRAINT EMPNO_NN */
   CHECK (ID_PRACOWNIKA IS NOT NULL);
ALTER TABLE PRACOWNICY ADD /* CONSTRAINT PRACOWNICY$DEPTNO_NN */
   CHECK (ID_WYDZIALU IS NOT NULL);
ALTER TABLE WIERSZE_ZAMOWIEN ADD /* CONSTRAINT WIERSZE_ZAMOWIEN$ID_ZAMOWIENIA_NN */
   CHECK (ID_ZAMOWIENIA IS NOT NULL);
ALTER TABLE WIERSZE_ZAMOWIEN ADD /* CONSTRAINT ID_WIERSZA_ZAM_NN */
   CHECK (ID_WIERSZA_ZAM IS NOT NULL);
ALTER TABLE ETATY ADD /* CONSTRAINT ETATYID_NN */
   CHECK (ID_ETATU IS NOT NULL);
ALTER TABLE ETATY ADD /* CONSTRAINT ETATYFN_NN */
   CHECK (ETAT IS NOT NULL);
ALTER TABLE SIEDZIBY ADD /* CONSTRAINT LOC_NN */
   CHECK (ID_SIEDZIBY IS NOT NULL);
ALTER TABLE CENY ADD /* CONSTRAINT CENY$ID_PRODUKTU_NN */
   CHECK (ID_PRODUKTU IS NOT NULL);
ALTER TABLE CENY ADD /* CONSTRAINT DATA_OBWIAZYWANIA_NN */
   CHECK (DATA_OBWIAZYWANIA IS NOT NULL);
ALTER TABLE CENY ADD /* CONSTRAINT CENA_MINIMALNA_LESS */
   CHECK (CENA_CENNIKOWA IS NULL OR CENA_MINIMALNA IS NULL OR CENA_MINIMALNA <= CENA_CENNIKOWA);
ALTER TABLE CENY ADD /* CONSTRAINT DATA_OBWIAZYWANIA_LESS */
   CHECK (DATA_WYCOFANIA IS NULL OR DATA_OBWIAZYWANIA <= DATA_WYCOFANIA);
ALTER TABLE WYROBY ADD /* CONSTRAINT ID_PRODUKTU_NN */
   CHECK (ID_PRODUKTU IS NOT NULL);
ALTER TABLE POZIOMY_PENSJI ADD /* CONSTRAINT ID_POZIOMU_NN */
   CHECK (ID_POZIOMU IS NOT NULL);
ALTER TABLE POZIOMY_PENSJI ADD /* CONSTRAINT DOLNA_GRANICA_LESS */
   CHECK ((DOLNA_GRANICA IS NULL AND GORNA_GRANICA IS NOT NULL) OR (DOLNA_GRANICA IS NOT NULL AND GORNA_GRANICA IS NULL) OR (DOLNA_GRANICA <= GORNA_GRANICA));
ALTER TABLE ZAMOWIENIA ADD /* CONSTRAINT ID_ZAMOWIENIA_NN */
   CHECK (ID_ZAMOWIENIA IS NOT NULL);
ALTER TABLE ZAMOWIENIA ADD /* CONSTRAINT ORDER$ID_KLIENTA_NN */
   CHECK (ID_KLIENTA IS NOT NULL);
ALTER TABLE ZAMOWIENIA ADD /* CONSTRAINT WYNIKI_SPRZEDAZY_WARTOSC_ZERO */
   CHECK (WARTOSC >= 0);

ALTER TABLE KLIENCI ADD /* CONSTRAINT KLIENCI_PRIMARY_KEY */
   PRIMARY KEY (ID_KLIENTA);
ALTER TABLE WYDZIALY ADD /* CONSTRAINT DEPT_PRIMARY_KEY */
   PRIMARY KEY (ID_WYDZIALU);
ALTER TABLE PRACOWNICY ADD /* CONSTRAINT EMP_PRIMARY_KEY */
   PRIMARY KEY (ID_PRACOWNIKA);
ALTER TABLE WIERSZE_ZAMOWIEN ADD /* CONSTRAINT WIERSZE_ZAMOWIEN_PRIMARY_KEY */
   PRIMARY KEY (ID_ZAMOWIENIA, ID_WIERSZA_ZAM);
ALTER TABLE ETATY ADD /* CONSTRAINT ETATY_PRIMARY_KEY */
   PRIMARY KEY (ID_ETATU);
ALTER TABLE SIEDZIBY ADD /* CONSTRAINT LOC_PRIMARY_KEY */
   PRIMARY KEY (ID_SIEDZIBY);
ALTER TABLE CENY ADD /* CONSTRAINT CENY_PRIMARY_KEY */
   PRIMARY KEY (ID_PRODUKTU, DATA_OBWIAZYWANIA);
ALTER TABLE WYROBY ADD /* CONSTRAINT WYROBY_PRIMARY_KEY */
   PRIMARY KEY (ID_PRODUKTU);
ALTER TABLE POZIOMY_PENSJI ADD /* CONSTRAINT POZIOMY_PENSJI_PRIMARY_KEY */
   PRIMARY KEY (ID_POZIOMU);
ALTER TABLE ZAMOWIENIA ADD /* CONSTRAINT ZAMOWIENIA_PRIMARY_KEY */
   PRIMARY KEY (ID_ZAMOWIENIA);

ALTER TABLE KLIENCI ADD /* CONSTRAINT KLIENCI_FOREIGN_KEY  */
   FOREIGN KEY (ID_PRACOWNIKA) REFERENCES PRACOWNICY;
ALTER TABLE WYDZIALY ADD /* CONSTRAINT DEPT_FOREIGN_KEY  */
   FOREIGN KEY (ID_SIEDZIBY) REFERENCES SIEDZIBY;
ALTER TABLE PRACOWNICY ADD /* CONSTRAINT EMP_FOREIGN_KEY_2  */
   FOREIGN KEY (ID_ETATU) REFERENCES ETATY;
ALTER TABLE PRACOWNICY ADD /* CONSTRAINT EMP_SELF_KEY  */
   FOREIGN KEY (ID_SZEFA) REFERENCES PRACOWNICY;
ALTER TABLE PRACOWNICY ADD /* CONSTRAINT EMP_FOREIGN_KEY_1  */
   FOREIGN KEY (ID_WYDZIALU) REFERENCES WYDZIALY;
ALTER TABLE WIERSZE_ZAMOWIEN ADD /* CONSTRAINT WIERSZE_ZAMOWIEN_ORDER_FOREIGN_KEY  */
   FOREIGN KEY (ID_ZAMOWIENIA) REFERENCES ZAMOWIENIA;
ALTER TABLE WIERSZE_ZAMOWIEN ADD /* CONSTRAINT WIERSZE_ZAMOWIEN_WYROBY_FOREIGN_KEY  */
   FOREIGN KEY (ID_PRODUKTU) REFERENCES WYROBY;
ALTER TABLE CENY ADD /* CONSTRAINT CENY_FOREIGN_KEY  */
   FOREIGN KEY (ID_PRODUKTU) REFERENCES WYROBY;
ALTER TABLE ZAMOWIENIA ADD /* CONSTRAINT ZAMOWIENIA_FOREIGN_KEY  */
   FOREIGN KEY (ID_KLIENTA) REFERENCES KLIENCI;

