atikti darbai CREATE TABLE  "ATLIKTIDARBAI"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"SUMA" BINARY_DOUBLE DEFAULT NULL,
	"NUMATYTIDARBAIID" NUMBER(10,0) DEFAULT NULL,
	"NENUMATYTIDARBAIID" NUMBER(10,0) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "FK_ATLIKTIDARBAI_NENUMATYTIDAR" FOREIGN KEY ("NENUMATYTIDARBAIID")
	  REFERENCES  "NENUMATYTIDARBAI" ("ID") ENABLE,
	 CONSTRAINT "FK_ATLIKTIDARBAI_NUMATYTIDARBA" FOREIGN KEY ("NUMATYTIDARBAIID")
	  REFERENCES  "NUMATYTIDARBAI" ("ID") ENABLE
   )
/

CREATE INDEX  "FK_ATLIKTIDARBAI_NENUMATYTIDAR" ON  "ATLIKTIDARBAI" ("NENUMATYTIDARBAIID")
/

CREATE INDEX  "FK_ATLIKTIDARBAI_NUMATYTIDARBA" ON  "ATLIKTIDARBAI" ("NUMATYTIDARBAIID")
/

CREATE OR REPLACE TRIGGER  "ATLIKTIDARBAI_SEQ_TR"
 BEFORE INSERT ON atliktidarbai FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT atliktidarbai_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "ATLIKTIDARBAI_SEQ_TR" ENABLE
/


CREATE TABLE  "AUTOMOBILIS"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"MARKE" CHAR(20) DEFAULT NULL,
	"MODELIS" VARCHAR2(255) DEFAULT NULL,
	"PAGAMINIMOMETAI" NUMBER(5,0) DEFAULT NULL,
	"RIDA" NUMBER(10,0) DEFAULT NULL,
	"VARTOTOJASID" NUMBER(10,0) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "FK_AUTOMOBILIS_VARTOTOJASID" FOREIGN KEY ("VARTOTOJASID")
	  REFERENCES  "VARTOTOJAS" ("ID") ENABLE
   )
/

CREATE INDEX  "FK_AUTOMOBILIS_VARTOTOJASID" ON  "AUTOMOBILIS" ("VARTOTOJASID")
/

CREATE OR REPLACE TRIGGER  "AUTOMOBILIS_SEQ_TR"
 BEFORE INSERT ON automobilis FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT automobilis_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "AUTOMOBILIS_SEQ_TR" ENABLE
/







CREATE TABLE  "DRAUDIMAS"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"PAVADINIMAS" VARCHAR2(255) DEFAULT NULL,
	"PASIBAIGIMODATA" DATE DEFAULT NULL,
	"AUTOMOBILISID" NUMBER(10,0) DEFAULT NULL,
	"KAINA" NUMBER(10,0) DEFAULT NULL,
	"IMONE" VARCHAR2(255) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "FK_DRAUDIMAS_AUTOMOBILISID" FOREIGN KEY ("AUTOMOBILISID")
	  REFERENCES  "AUTOMOBILIS" ("ID") ENABLE
   )
/

CREATE INDEX  "FK_DRAUDIMAS_AUTOMOBILISID" ON  "DRAUDIMAS" ("AUTOMOBILISID")
/

CREATE OR REPLACE TRIGGER  "DRAUDIMAS_SEQ_TR"
 BEFORE INSERT ON draudimas FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT draudimas_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "DRAUDIMAS_SEQ_TR" ENABLE
/






CREATE TABLE  "GARANTIJA"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"GALIOJIMOLAIKAS" DATE DEFAULT NULL,
	"MEDÞIAGOSID" NUMBER(10,0) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "FK_GARANTIJA_MEDÞIAGOSID" FOREIGN KEY ("MEDÞIAGOSID")
	  REFERENCES  "MEDZIAGOS" ("ID") ENABLE
   )
/

CREATE INDEX  "FK_GARANTIJA_MEDÞIAGOSID" ON  "GARANTIJA" ("MEDÞIAGOSID")
/

CREATE OR REPLACE TRIGGER  "GARANTIJA_SEQ_TR"
 BEFORE INSERT ON garantija FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT garantija_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "GARANTIJA_SEQ_TR" ENABLE
/






CREATE TABLE  "MEDZIAGOS"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"PAVADINIMAS" VARCHAR2(255) DEFAULT NULL,
	"KATEGORIJA" VARCHAR2(255) DEFAULT NULL,
	"KAINA" BINARY_DOUBLE DEFAULT NULL,
	"NUMATYTIDARBAIID" NUMBER(10,0) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "FK_MEDZIAGOS_NUMATYTIDARBAIID" FOREIGN KEY ("NUMATYTIDARBAIID")
	  REFERENCES  "NUMATYTIDARBAI" ("ID") ENABLE
   )
/

CREATE INDEX  "FK_MEDZIAGOS_NUMATYTIDARBAIID" ON  "MEDZIAGOS" ("NUMATYTIDARBAIID")
/

CREATE OR REPLACE TRIGGER  "MEDZIAGOS_SEQ_TR"
 BEFORE INSERT ON medziagos FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT medziagos_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "MEDZIAGOS_SEQ_TR" ENABLE
/






CREATE TABLE  "NENUMATYTIDARBAI"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"PAVADINIMAS" VARCHAR2(255) DEFAULT NULL,
	"DATA" DATE DEFAULT NULL,
	"KATEGORIJA" VARCHAR2(255) DEFAULT NULL,
	"SERVISAS" NUMBER(10,0) DEFAULT NULL,
	"AUTOMOBILISID" NUMBER(10,0) DEFAULT NULL,
	"VARTOTOJASID" NUMBER(10,0) DEFAULT NULL,
	"KAINA" NUMBER(10,0) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "FK_NENUMATYTIDARBAI_AUTOMOBILI" FOREIGN KEY ("AUTOMOBILISID")
	  REFERENCES  "AUTOMOBILIS" ("ID") ENABLE,
	 CONSTRAINT "FK_NENUMATYTIDARBAI_SERVISAS" FOREIGN KEY ("SERVISAS")
	  REFERENCES  "SERVISAS" ("ID") ENABLE
   )
/

CREATE INDEX  "FK_NENUMATYTIDARBAI_AUTOMOBILI" ON  "NENUMATYTIDARBAI" ("AUTOMOBILISID")
/

CREATE INDEX  "FK_NENUMATYTIDARBAI_SERVISAS" ON  "NENUMATYTIDARBAI" ("SERVISAS")
/

CREATE INDEX  "FK_NENUMATYTIDARBAI_VARTOTOJAS" ON  "NENUMATYTIDARBAI" ("VARTOTOJASID")
/

CREATE OR REPLACE TRIGGER  "NENUMATYTIDARBAI_SEQ_TR"
 BEFORE INSERT ON nenumatytidarbai FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT nenumatytidarbai_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "NENUMATYTIDARBAI_SEQ_TR" ENABLE
/





CREATE TABLE  "NUMATYTIDARBAI"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"PAVADINIMAS" VARCHAR2(255) DEFAULT NULL,
	"KATEGORIJA" VARCHAR2(255) DEFAULT NULL,
	"DATA" TIMESTAMP (0) DEFAULT NULL,
	"VARTOTOJASID" NUMBER(10,0) DEFAULT NULL,
	"SERVISAS" NUMBER(10,0) DEFAULT NULL,
	"AUTOMOBILISID" NUMBER(10,0) DEFAULT NULL,
	"KAINA" NUMBER(10,0) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "FK_NUMATYTIDARBAI_AUTOMOBILISI" FOREIGN KEY ("AUTOMOBILISID")
	  REFERENCES  "AUTOMOBILIS" ("ID") ENABLE,
	 CONSTRAINT "FK_NUMATYTIDARBAI_SERVISAS" FOREIGN KEY ("SERVISAS")
	  REFERENCES  "SERVISAS" ("ID") ENABLE
   )
/

CREATE INDEX  "FK_NUMATYTIDARBAI_AUTOMOBILISI" ON  "NUMATYTIDARBAI" ("AUTOMOBILISID")
/

CREATE INDEX  "FK_NUMATYTIDARBAI_SERVISAS" ON  "NUMATYTIDARBAI" ("SERVISAS")
/

CREATE INDEX  "FK_NUMATYTIDARBAI_VARTOTOJASID" ON  "NUMATYTIDARBAI" ("VARTOTOJASID")
/

CREATE OR REPLACE TRIGGER  "NUMATYTIDARBAI_SEQ_TR"
 BEFORE INSERT ON numatytidarbai FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT numatytidarbai_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "NUMATYTIDARBAI_SEQ_TR" ENABLE
/





CREATE TABLE  "PRIMINIMAS"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"PAVADINIMAS" VARCHAR2(255) DEFAULT NULL,
	"DATA" DATE DEFAULT NULL,
	"VARTOTOJASID" NUMBER(10,0) DEFAULT NULL,
	"AUTOMOBILISID" NUMBER(10,0) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "FK_PRIMINIMAS_AUTOMOBILISID" FOREIGN KEY ("AUTOMOBILISID")
	  REFERENCES  "AUTOMOBILIS" ("ID") ENABLE,
	 CONSTRAINT "FK_PRIMINIMAS_VARTOTOJASID" FOREIGN KEY ("VARTOTOJASID")
	  REFERENCES  "VARTOTOJAS" ("ID") ENABLE
   )
/

CREATE INDEX  "FK_PRIMINIMAS_AUTOMOBILISID" ON  "PRIMINIMAS" ("AUTOMOBILISID")
/

CREATE INDEX  "FK_PRIMINIMAS_VARTOTOJASID" ON  "PRIMINIMAS" ("VARTOTOJASID")
/

CREATE OR REPLACE TRIGGER  "PRIMINIMAS_SEQ_TR"
 BEFORE INSERT ON priminimas FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT priminimas_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "PRIMINIMAS_SEQ_TR" ENABLE
/






CREATE TABLE  "SERVISAS"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"PAVADINIMAS" VARCHAR2(255) DEFAULT NULL,
	"IMONESKODAS" NUMBER(10,0) NOT NULL ENABLE,
	"MIESTAS" VARCHAR2(255) DEFAULT NULL,
	"TELEFONONUMERIS" NUMBER(10,0) DEFAULT NULL,
	"ADRESAS" VARCHAR2(255) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "SERVISAS_SEQ_TR"
 BEFORE INSERT ON servisas FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT servisas_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "SERVISAS_SEQ_TR" ENABLE
/






CREATE TABLE  "TECHNIKINEAPZIURA"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"PASIBAIGIMODATA" DATE DEFAULT NULL,
	"AUTOMOBILISID" NUMBER(10,0) DEFAULT NULL,
	 PRIMARY KEY ("ID") ENABLE,
	 CONSTRAINT "AUTOMOBILISID" UNIQUE ("AUTOMOBILISID") ENABLE,
	 CONSTRAINT "FK_TECHNIKINEAPZIURA_AUTOMOBIL" FOREIGN KEY ("AUTOMOBILISID")
	  REFERENCES  "AUTOMOBILIS" ("ID") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "TECHNIKINEAPZIURA_SEQ_TR"
 BEFORE INSERT ON technikineapziura FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT technikineapziura_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "TECHNIKINEAPZIURA_SEQ_TR" ENABLE
/







CREATE TABLE  "VARTOTOJAS"
   (	"ID" NUMBER(10,0) NOT NULL ENABLE,
	"VARDAS" VARCHAR2(255) NOT NULL ENABLE,
	"PAVARDE" VARCHAR2(255) NOT NULL ENABLE,
	"AMZIUS" NUMBER(10,0) NOT NULL ENABLE,
	"MIESTAS" VARCHAR2(255) NOT NULL ENABLE,
	"ELEKTRONINISPASTAS" VARCHAR2(255) NOT NULL ENABLE,
	 PRIMARY KEY ("ID") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "VARTOTOJAS_SEQ_TR"
 BEFORE INSERT ON vartotojas FOR EACH ROW
  WHEN (NEW.ID IS NULL) BEGIN
 SELECT vartotojas_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
ALTER TRIGGER  "VARTOTOJAS_SEQ_TR" ENABLE
/