Pitel

DROP TABLE "TYP_TRANSAKCE";DROP TABLE "ZAMESTNANEC";DROP TABLE "UCET";DROP TABLE "TRANSAKCE";DROP TABLE "UCET_DISPONENT";DROP TABLE "ZAKAZNIK";DROP SEQUENCE "ZAM_ZAM_ID_SEQ";DROP SEQUENCE "ZAKAZNIK_ZAKAZNIK_ID_SEQ";DROP SEQUENCE "UCET_UCET_ID_SEQ";DROP SEQUENCE "TRANSAKCE_TRANSAKCE_ID_SEQ";DROP SEQUENCE "TYP_TRAN_TYP_TRAN_ID_SEQ";DROP SEQUENCE "UCET_DISPT_UCET_DISP_ID_SEQ";CREATE SEQUENCE "ZAM_ZAM_ID_SEQ";CREATE SEQUENCE "ZAKAZNIK_ZAKAZNIK_ID_SEQ";CREATE SEQUENCE "UCET_UCET_ID_SEQ";CREATE SEQUENCE "TRANSAKCE_TRANSAKCE_ID_SEQ";CREATE SEQUENCE "TYP_TRAN_TYP_TRAN_ID_SEQ";CREATE SEQUENCE "UCET_DISPT_UCET_DISP_ID_SEQ";CREATE TABLE "TYP_TRANSAKCE" (	"TYP_TRANSAKCE_ID" NUMBER(38) NOT NULL PRIMARY KEY DEFAULT TYP_TRAN_TYP_TRAN_ID_SEQ.NEXTVAL,	"JMENO" VARCHAR(100) NOT NULL);CREATE TABLE "ZAMESTNANEC" (	"ZAMESTNANEC_ID" INT NOT NULL PRIMARY KEY DEFAULT ZAM_ZAM_ID_SEQ.NEXTVAL,	"RC" NUMERIC(10) NOT NULL,	"JMENO" VARCHAR NOT NULL,	"PRIJMENI" VARCHAR NOT NULL);CREATE TABLE "UCET" (	"UCET_ID" INT NOT NULL PRIMARY KEY DEFAULT UCET_UCET_ID_SEQ.NEXTVAL,	"FREKVENCE_VYPISU" INT NOT NULL,	"ZUSTATEK" INT NOT NULL DEFAULT 0,	"CISLO_UCTU" NUMERIC(20) NOT NULL,	"ZAMESTNANEC_ID" INT,	"ZAKAZNIK_ID" INT);CREATE TABLE "TRANSAKCE" (	"TRANSAKCE_ID" INT NOT NULL PRIMARY KEY DEFAULT TRANSAKCE_TRANSAKCE_ID_SEQ.NEXTVAL,	"CASTKA" INT NOT NULL,	"DATUM" DATE NOT NULL,	"UCET_PROTISTRANA" NUMERIC(20) NOT NULL,	"VYRIZENO" INT NOT NULL,	"ZDROJ_UCET_ID" INT,	"CIL_UCET_ID" INT,	"TYP_TRANSAKCE_ID" INT,	"ZAMESTNANEC_ID" INT,	"ZAKAZNIK_ID" INT);CREATE TABLE "UCET_DISPONENT" (	"UCET_DISPONENT_ID" INT NOT NULL PRIMARY KEY DEFAULT UCET_DISPT_UCET_DISP_ID_SEQ.NEXTVAL,	"UCET_ID" INT NOT NULL,	"ZAKAZNIK_ID" INT NOT NULL);CREATE TABLE "ZAKAZNIK" (	"ZAKAZNIK_ID" INT NOT NULL PRIMARY KEY DEFAULT ZAKAZNIK_ZAKAZNIK_ID_SEQ.NEXTVAL,	"RC" NUMERIC(10) NOT NULL,	"JMENO" VARCHAR NOT NULL,	"PRIJMENI" VARCHAR NOT NULL,	"ADRESA" VARCHAR NOT NULL,	"KONTAKT" VARCHAR NOT NULL);CREATE UNIQUE INDEX "UCET_DISPONENT_UIX" ON "UCET_DISPONENT" ("ZAKAZNIK_ID", "UCET_ID");ALTER TABLE "TRANSAKCE" ADD CONSTRAINT "TRANSAKCE_CIL_UCET_ID_FK" FOREIGN KEY ("CIL_UCET_ID") REFERENCES "UCET" ("UCET_ID") ENABLE;ALTER TABLE "TRANSAKCE" ADD CONSTRAINT "TRANSAKCE_TYP_TRANSAKCE_ID_FK" FOREIGN KEY ("TYP_TRANSAKCE_ID") REFERENCES "TYP_TRANSAKCE" ("TYP_TRANSAKCE_ID") ENABLE;ALTER TABLE "TRANSAKCE" ADD CONSTRAINT "TRANSAKCE_ZAKAZNIK_ID_FK" FOREIGN KEY ("ZAKAZNIK_ID") REFERENCES "ZAKAZNIK" ("ZAKAZNIK_ID") ENABLE;ALTER TABLE "TRANSAKCE" ADD CONSTRAINT "TRANSAKCE_ZAMESTNANEC_ID_FK" FOREIGN KEY ("ZAMESTNANEC_ID") REFERENCES "ZAMESTNANEC" ("ZAMESTNANEC_ID") ENABLE;ALTER TABLE "TRANSAKCE" ADD CONSTRAINT "TRANSAKCE_ZDROJ_UCET_ID_FK" FOREIGN KEY ("ZDROJ_UCET_ID") REFERENCES "UCET" ("UCET_ID") ENABLE;ALTER TABLE "UCET" ADD CONSTRAINT "UCET_ZAKAZNIK_ID_FK" FOREIGN KEY ("ZAKAZNIK_ID") REFERENCES "ZAKAZNIK" ("ZAKAZNIK_ID") ENABLE;ALTER TABLE "UCET" ADD CONSTRAINT "UCET_ZAMESTNANEC_ID_FK" FOREIGN KEY ("ZAMESTNANEC_ID") REFERENCES "ZAMESTNANEC" ("ZAMESTNANEC_ID") ENABLE;ALTER TABLE "UCET_DISPONENT" ADD CONSTRAINT "UCET_DISPONENT_UCET_ID_FK" FOREIGN KEY ("UCET_ID") REFERENCES "UCET" ("UCET_ID") ENABLE;ALTER TABLE "UCET_DISPONENT" ADD CONSTRAINT "UCET_DISPONENT_ZAKAZNIK_ID_FK" FOREIGN KEY ("ZAKAZNIK_ID") REFERENCES "ZAKAZNIK" ("ZAKAZNIK_ID") ENABLE;INSERT INTO "ZAKAZNIK" ("JMENO", "PRIJMENI", "RC", "ADRESA", "KONTAKT") VALUES ('Karel', 'Skocdopole', 8702214362, 'Pole 1', 'skacu@pole.cz');INSERT INTO "ZAMESTNANEC" ("JMENO", "PRIJMENI", "RC") VALUES ('Petra', 'Zazobana', 4307086540);INSERT INTO "UCET" ("FREKVENCE_VYPISU", "ZUSTATEK", "ZAMESTNANEC_ID", "ZAKAZNIK_ID") VALUES (1, 5345, ZAM_ZAM_ID_SEQ.CURRVAL, ZAKAZNIK_ZAKAZNIK_ID_SEQ.CURRVAL);INSERT INTO "ZAKAZNIK" ("JMENO", "PRIJMENI", "RC", "ADRESA", "KONTAKT") VALUES ('Frantisek', 'Pferdwurstesser', 541221856, 'Bahnhof 12a', 'franta@megamail.net');INSERT INTO "ZAMESTNANEC" ("JMENO", "PRIJMENI", "RC") VALUES ('Zdenek', 'Zkrachovaly', 6804219869);INSERT INTO "UCET" ("FREKVENCE_VYPISU", "ZUSTATEK", "ZAMESTNANEC_ID", "ZAKAZNIK_ID") VALUES (2, 9070, ZAM_ZAM_ID_SEQ.CURRVAL, ZAKAZNIK_ZAKAZNIK_ID_SEQ.CURRVAL);INSERT INTO "ZAKAZNIK" ("JMENO", "PRIJMENI", "RC", "ADRESA", "KONTAKT") VALUES ('Klotylda', 'Hladova', 6521016543, 'Domaci 65', 'mam@hlad.cz');INSERT INTO "ZAMESTNANEC" ("JMENO", "PRIJMENI", "RC") VALUES ('Dmitrij', 'Bezpenezowski', 5609096483);INSERT INTO "UCET" ("FREKVENCE_VYPISU", "ZUSTATEK", "ZAMESTNANEC_ID", "ZAKAZNIK_ID") VALUES (3, 8979879, ZAM_ZAM_ID_SEQ.CURRVAL, ZAKAZNIK_ZAKAZNIK_ID_SEQ.CURRVAL);INSERT INTO "ZAKAZNIK" ("JMENO", "PRIJMENI", "RC", "ADRESA", "KONTAKT") VALUES ('Petr', 'Kucera', 5603076723, 'Ulicni 13', 'petrik@kucera.org');INSERT INTO "UCET_DISPONENT" ("UCET_ID", "ZAKAZNIK_ID") VALUES (UCET_UCET_ID_SEQ.CURRVAL, ZAKAZNIK_ZAKAZNIK_ID_SEQ.CURRVAL);INSERT INTO "TYP_TRANSAKCE" ("JMENO") VALUES ('Bezhotovostni');INSERT INTO "TRANSAKCE" ("CASTKA", "DATUM", "UCET_PROTISTRANA", "VYRIZENO", "TYP_TRANSAKCE_ID") VALUES (5, to_date('2008/03/25', 'yyyy/mm/dd'), 987983469080100, 1, TYP_TRAN_TYP_TRAN_ID_SEQ.CURRVAL);