--------------------------------------------------------
-- File created - Wednesday-July-08-2009
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Sequence POPUP_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."POPUP_ID_SEQ" MINVALUE 1 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 56 CACHE 20 NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence OWL_LOGIN_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."OWL_LOGIN_ID_SEQ" MINVALUE 1 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 5 CACHE 10 NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence WORK_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."WORK_ID_SEQ" MINVALUE 0 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 9082 NOCACHE NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence PRINTER_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."PRINTER_ID_SEQ" MINVALUE 1 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 622 CACHE 20 NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence COMPUTER_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."COMPUTER_ID_SEQ" MINVALUE 1 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 22 CACHE 20 NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence TASK_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."TASK_ID_SEQ" MINVALUE 0 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 10755 NOCACHE NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence DEPT_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."DEPT_ID_SEQ" MINVALUE 0 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 212 NOCACHE NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence ORDER_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."ORDER_ID_SEQ" MINVALUE 0 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 7784 NOCACHE NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence CLIENT_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."CLIENT_ID_SEQ" MINVALUE 0 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 1333 NOCACHE NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Sequence BUILD_ID_SEQ
--------------------------------------------------------
CREATE SEQUENCE "JOBTRACKER"."BUILD_ID_SEQ" MINVALUE 0 MAXVALUE 1.00000000000000E+27 INCREMENT BY 1 START WITH 164 NOCACHE NOORDER NOCYCLE ;
--------------------------------------------------------
-- DDL for Table COMPUTER
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."COMPUTER"
( "ID" NUMBER,
"IP" VARCHAR2(15),
"GROUPS_ID" NUMBER
) ;
--------------------------------------------------------
-- DDL for Table GROUPS
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."GROUPS"
( "ID" NUMBER(2,0),
"NAME" VARCHAR2(30)
) ;
--------------------------------------------------------
-- DDL for Table BUILD_TBL
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."BUILD_TBL"
( "BUILD_ID" NUMBER,
"BUILD_NAME" VARCHAR2(30),
"BUILD_ABBR" VARCHAR2(5)
) ;
--------------------------------------------------------
-- DDL for Table TASK_TBL
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."TASK_TBL"
( "TASK_ID" NUMBER,
"TASK_TITLE" VARCHAR2(200),
"TASK_DESC" VARCHAR2(4000),
"TASK_PRIORITY" NUMBER,
"TASK_ORDER" NUMBER,
"TASK_DUE" DATE,
"TASK_COMPLETE" DATE,
"TASK_STATUS" NUMBER,
"TASK_SPENT" NUMBER(5,2),
"TASK_CREATE" DATE,
"TASK_CONSULTANT" NUMBER,
"TASK_CLIENT" NUMBER,
"TASK_BY" NUMBER,
"TASK_DEPT_ID" NUMBER,
"TASK_WORKED_ON" NUMBER,
"TASK_COMPLETED_BY" NUMBER,
"TASK_COMPUTER" VARCHAR2(5),
"TASK_GROUP_ID" NUMBER(2,0)
) ;
--------------------------------------------------------
-- DDL for Table HOLD_TBL
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."HOLD_TBL"
( "HOLD_ID" NUMBER,
"HOLD_AMOUNT" DATE,
"HOLD_REASON" VARCHAR2(4000)
) ;
--------------------------------------------------------
-- DDL for Table TASK_TBL3
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."TASK_TBL3"
( "TASK_ID" NUMBER,
"TASK_TITLE" VARCHAR2(200),
"TASK_DESC" VARCHAR2(1000),
"TASK_PRIORITY" NUMBER,
"TASK_ORDER" NUMBER,
"TASK_DUE" DATE,
"TASK_COMPLETE" DATE,
"TASK_STATUS" NUMBER,
"TASK_SPENT" NUMBER(5,2),
"TASK_CREATE" DATE,
"TASK_CONSULTANT" NUMBER,
"TASK_CLIENT" NUMBER,
"TASK_BY" NUMBER,
"TASK_DEPT_ID" NUMBER,
"TASK_WORKED_ON" NUMBER,
"TASK_COMPLETED_BY" NUMBER,
"TASK_COMPUTER" VARCHAR2(5)
) ;
--------------------------------------------------------
-- DDL for Table TASK_TBL5
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."TASK_TBL5"
( "TASK_ID" NUMBER,
"TASK_TITLE" VARCHAR2(200),
"TASK_DESC" VARCHAR2(1000),
"TASK_PRIORITY" NUMBER,
"TASK_ORDER" NUMBER,
"TASK_DUE" DATE,
"TASK_COMPLETE" DATE,
"TASK_STATUS" NUMBER,
"TASK_SPENT" NUMBER(5,2),
"TASK_CREATE" DATE,
"TASK_CONSULTANT" NUMBER,
"TASK_CLIENT" NUMBER,
"TASK_BY" NUMBER,
"TASK_DEPT_ID" NUMBER,
"TASK_WORKED_ON" NUMBER,
"TASK_COMPLETED_BY" NUMBER,
"TASK_COMPUTER" VARCHAR2(5)
) ;
--------------------------------------------------------
-- DDL for Table CLIENT_TBL
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."CLIENT_TBL"
( "CLIENT_ID" NUMBER,
"CLIENT_LNAME" VARCHAR2(30),
"CLIENT_FNAME" VARCHAR2(30),
"CLIENT_FULL" VARCHAR2(65),
"CLIENT_ROOM" VARCHAR2(10),
"CLIENT_HPHONE" VARCHAR2(15),
"CLIENT_WPHONE" VARCHAR2(15),
"CLIENT_PAGER" VARCHAR2(15),
"CLIENT_CELL" VARCHAR2(15),
"CLIENT_RADIO" VARCHAR2(15),
"CLIENT_EMAIL" VARCHAR2(30),
"CLIENT_CONSULTANT" VARCHAR2(3),
"CLIENT_CHAIR" VARCHAR2(3),
"CLIENT_DEPT_ID" NUMBER,
"CLIENT_BUILD_ID" NUMBER,
"CLIENT_SUPRESS" NUMBER,
"EMAIL_NEW_JOBS" CHAR(1) DEFAULT 'N',
"CLIENT_GROUP_ID" NUMBER DEFAULT 0,
"CLIENT_BACKUP" VARCHAR2(3) DEFAULT 'No',
"DEPT_ID" NUMBER(*,0),
"BUILD_ID" NUMBER(*,0),
"ID" NUMBER(*,0),
"OLD_ID" NUMBER(*,0),
"ROOM_ID" NUMBER(*,0)
) ;
--------------------------------------------------------
-- DDL for Table POPUP
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."POPUP"
( "ID" NUMBER,
"TASK_ID" NUMBER,
"COMPUTER_IP" VARCHAR2(15)
) ;
--------------------------------------------------------
-- DDL for Table PRINTER
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."PRINTER"
( "PRINTER_ID" NUMBER(10,0),
"HOST_NAME" VARCHAR2(40),
"SUP_TCP_IP" VARCHAR2(5),
"SUP_IPX_SPX" VARCHAR2(5),
"SUP_APPLETALK" VARCHAR2(5),
"SUP_DLC_LLC" VARCHAR2(5),
"STAT_TCP_IP" VARCHAR2(5),
"STAT_IPX_SPX" VARCHAR2(5),
"STAT_APPLETALK" VARCHAR2(5),
"STAT_DLC_LLC" VARCHAR2(5),
"COMPLETE" VARCHAR2(5),
"COMMENTS" VARCHAR2(1000),
"IP_ADDRESS" VARCHAR2(20),
"STAT_MDNS" VARCHAR2(5),
"STAT_ETHERTALK" VARCHAR2(5),
"LOCATION" VARCHAR2(15)
) ;
--------------------------------------------------------
-- DDL for Table TASK_TBL6
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."TASK_TBL6"
( "TASK_ID" NUMBER,
"TASK_TITLE" VARCHAR2(200),
"TASK_DESC" VARCHAR2(1000),
"TASK_PRIORITY" NUMBER,
"TASK_ORDER" NUMBER,
"TASK_DUE" DATE,
"TASK_COMPLETE" DATE,
"TASK_STATUS" NUMBER,
"TASK_SPENT" NUMBER(5,2),
"TASK_CREATE" DATE,
"TASK_CONSULTANT" NUMBER,
"TASK_CLIENT" NUMBER,
"TASK_BY" NUMBER,
"TASK_DEPT_ID" NUMBER,
"TASK_WORKED_ON" NUMBER,
"TASK_COMPLETED_BY" NUMBER,
"TASK_COMPUTER" VARCHAR2(5)
) ;
--------------------------------------------------------
-- DDL for Table PRIORITY_TBL
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."PRIORITY_TBL"
( "PRIORITY_ID" NUMBER,
"PRIORITY_NAME" VARCHAR2(30)
) ;
--------------------------------------------------------
-- DDL for Table COUNTCLIENT
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."COUNTCLIENT"
( "HITS" NUMBER
) ;
--------------------------------------------------------
-- DDL for Table TASK_TBL2
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."TASK_TBL2"
( "TASK_ID" NUMBER,
"TASK_TITLE" VARCHAR2(200),
"TASK_DESC" VARCHAR2(1000),
"TASK_PRIORITY" NUMBER,
"TASK_ORDER" NUMBER,
"TASK_DUE" DATE,
"TASK_COMPLETE" DATE,
"TASK_STATUS" NUMBER,
"TASK_SPENT" NUMBER(5,2),
"TASK_CREATE" DATE,
"TASK_CONSULTANT" NUMBER,
"TASK_CLIENT" NUMBER,
"TASK_BY" NUMBER,
"TASK_DEPT_ID" NUMBER,
"TASK_WORKED_ON" NUMBER,
"TASK_COMPLETED_BY" NUMBER,
"TASK_COMPUTER" VARCHAR2(5)
) ;
--------------------------------------------------------
-- DDL for Table DEPT_TBL
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."DEPT_TBL"
( "DEPT_ID" NUMBER,
"DEPT_NAME" VARCHAR2(30)
) ;
--------------------------------------------------------
-- DDL for Table KEYHISTORY
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."KEYHISTORY"
( "ID" NUMBER(4,0),
"NAME" VARCHAR2(30),
"TIME_IN" VARCHAR2(30),
"TIME_OUT" VARCHAR2(30)
) ;
--------------------------------------------------------
-- DDL for Table WORK_TBL
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."WORK_TBL"
( "WORK_ID" NUMBER,
"WORK_DESC" VARCHAR2(1000),
"WORK_TIME" NUMBER,
"WORK_DATE" DATE,
"WORK_CONSULTANT" NUMBER,
"WORK_TASK" NUMBER,
"WORK_MIN" NUMBER
) ;
--------------------------------------------------------
-- DDL for Table STATUS_TBL
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."STATUS_TBL"
( "STATUS_ID" NUMBER,
"STATUS_NAME" VARCHAR2(30)
) ;
--------------------------------------------------------
-- DDL for Table OWL_LOGIN
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."OWL_LOGIN"
( "ID" NUMBER,
"LOGIN" VARCHAR2(20),
"PASSWORD" VARCHAR2(255),
"CREATED" DATE,
"LASTLOGIN" DATE
) ;
--------------------------------------------------------
-- DDL for Table TASK_TBL4
--------------------------------------------------------
CREATE TABLE "JOBTRACKER"."TASK_TBL4"
( "TASK_ID" NUMBER,
"TASK_TITLE" VARCHAR2(200),
"TASK_DESC" VARCHAR2(1000),
"TASK_PRIORITY" NUMBER,
"TASK_ORDER" NUMBER,
"TASK_DUE" DATE,
"TASK_COMPLETE" DATE,
"TASK_STATUS" NUMBER,
"TASK_SPENT" NUMBER(5,2),
"TASK_CREATE" DATE,
"TASK_CONSULTANT" NUMBER,
"TASK_CLIENT" NUMBER,
"TASK_BY" NUMBER,
"TASK_DEPT_ID" NUMBER,
"TASK_WORKED_ON" NUMBER,
"TASK_COMPLETED_BY" NUMBER,
"TASK_COMPUTER" VARCHAR2(5)
) ;
--------------------------------------------------------
-- Constraints for Table COMPUTER
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."COMPUTER" ADD CONSTRAINT "COMPUTER_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table GROUPS
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."GROUPS" ADD CONSTRAINT "GROUPS_ID_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table BUILD_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."BUILD_TBL" ADD PRIMARY KEY ("BUILD_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table TASK_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."TASK_TBL" ADD CONSTRAINT "T_ID" PRIMARY KEY ("TASK_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table HOLD_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."HOLD_TBL" ADD PRIMARY KEY ("HOLD_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table CLIENT_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."CLIENT_TBL" ADD CONSTRAINT "C_ID" PRIMARY KEY ("CLIENT_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table POPUP
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."POPUP" ADD CONSTRAINT "POPUP_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table PRINTER
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."PRINTER" ADD CONSTRAINT "PRINTER_ID_PK" PRIMARY KEY ("PRINTER_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table PRIORITY_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."PRIORITY_TBL" ADD PRIMARY KEY ("PRIORITY_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table TASK_TBL2
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."TASK_TBL2" ADD CONSTRAINT "TASK_ID_PK" PRIMARY KEY ("TASK_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table DEPT_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."DEPT_TBL" ADD PRIMARY KEY ("DEPT_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table WORK_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."WORK_TBL" ADD CONSTRAINT "W_ID" PRIMARY KEY ("WORK_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table STATUS_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."STATUS_TBL" ADD PRIMARY KEY ("STATUS_ID") ENABLE;
--------------------------------------------------------
-- Constraints for Table OWL_LOGIN
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."OWL_LOGIN" ADD CONSTRAINT "OWL_LOGIN_ID_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
-- DDL for Index SYS_C0013208
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."SYS_C0013208" ON "JOBTRACKER"."BUILD_TBL" ("BUILD_ID")
;
--------------------------------------------------------
-- DDL for Index C_ID
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."C_ID" ON "JOBTRACKER"."CLIENT_TBL" ("CLIENT_ID")
;
--------------------------------------------------------
-- DDL for Index SYS_C0013213
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."SYS_C0013213" ON "JOBTRACKER"."DEPT_TBL" ("DEPT_ID")
;
--------------------------------------------------------
-- DDL for Index SYS_C0013215
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."SYS_C0013215" ON "JOBTRACKER"."HOLD_TBL" ("HOLD_ID")
;
--------------------------------------------------------
-- DDL for Index SYS_C0013220
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."SYS_C0013220" ON "JOBTRACKER"."PRIORITY_TBL" ("PRIORITY_ID")
;
--------------------------------------------------------
-- DDL for Index SYS_C0013222
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."SYS_C0013222" ON "JOBTRACKER"."STATUS_TBL" ("STATUS_ID")
;
--------------------------------------------------------
-- DDL for Index T_ID
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."T_ID" ON "JOBTRACKER"."TASK_TBL" ("TASK_ID")
;
--------------------------------------------------------
-- DDL for Index W_ID
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."W_ID" ON "JOBTRACKER"."WORK_TBL" ("WORK_ID")
;
--------------------------------------------------------
-- DDL for Index TASK_TBL_INDEX1
--------------------------------------------------------
CREATE INDEX "JOBTRACKER"."TASK_TBL_INDEX1" ON "JOBTRACKER"."TASK_TBL" ("TASK_ORDER")
;
--------------------------------------------------------
-- DDL for Index BIN$SCvfSIImzHPgQLuABj5Jpw==$0
--------------------------------------------------------
-- Unable to Render DDL with DBMS_METADATA using internal generator.
CREATE UNIQUE INDEX "BIN$SCvfSIImzHPgQLuABj5Jpw==$0" ON "BIN$SCvfSIInzHPgQLuABj5Jpw==$0" (PRINTER_ID ASC) NOPARALLEL;
--------------------------------------------------------
-- DDL for Index OWL_LOGIN_ID_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."OWL_LOGIN_ID_PK" ON "JOBTRACKER"."OWL_LOGIN" ("ID")
;
--------------------------------------------------------
-- DDL for Index GROUPS_ID_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."GROUPS_ID_PK" ON "JOBTRACKER"."GROUPS" ("ID")
;
--------------------------------------------------------
-- DDL for Index TASK_ID_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."TASK_ID_PK" ON "JOBTRACKER"."TASK_TBL2" ("TASK_ID")
;
--------------------------------------------------------
-- DDL for Index POPUP_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."POPUP_PK" ON "JOBTRACKER"."POPUP" ("ID")
;
--------------------------------------------------------
-- DDL for Index COMPUTER_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."COMPUTER_PK" ON "JOBTRACKER"."COMPUTER" ("ID")
;
--------------------------------------------------------
-- DDL for Index PRINTER_ID_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "JOBTRACKER"."PRINTER_ID_PK" ON "JOBTRACKER"."PRINTER" ("PRINTER_ID")
;
--------------------------------------------------------
-- Ref Constraints for Table COMPUTER
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."COMPUTER" ADD CONSTRAINT "COMPUTER_GROUPS_ID" FOREIGN KEY ("GROUPS_ID")
REFERENCES "JOBTRACKER"."GROUPS" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table TASK_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."TASK_TBL" ADD CONSTRAINT "T_DI" FOREIGN KEY ("TASK_DEPT_ID")
REFERENCES "JOBTRACKER"."DEPT_TBL" ("DEPT_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CLIENT_TBL
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."CLIENT_TBL" ADD CONSTRAINT "CB_ID" FOREIGN KEY ("CLIENT_BUILD_ID")
REFERENCES "JOBTRACKER"."BUILD_TBL" ("BUILD_ID") ENABLE;
ALTER TABLE "JOBTRACKER"."CLIENT_TBL" ADD CONSTRAINT "CD_ID" FOREIGN KEY ("CLIENT_DEPT_ID")
REFERENCES "JOBTRACKER"."DEPT_TBL" ("DEPT_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table POPUP
--------------------------------------------------------
ALTER TABLE "JOBTRACKER"."POPUP" ADD CONSTRAINT "POPUP_TASK_ID_FK" FOREIGN KEY ("TASK_ID")
REFERENCES "JOBTRACKER"."TASK_TBL" ("TASK_ID") ENABLE;
--------------------------------------------------------
-- DDL for Trigger COMPUTER_ID_INSERT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "JOBTRACKER"."COMPUTER_ID_INSERT" before insert on COMPUTER
for each row
WHEN (new.ID is null) begin
select COMPUTER_ID_SEQ.nextval into :new.ID from dual;
end;
/
ALTER TRIGGER "JOBTRACKER"."COMPUTER_ID_INSERT" ENABLE;
--------------------------------------------------------
-- DDL for Trigger PRINTER_ID_INSERT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "JOBTRACKER"."PRINTER_ID_INSERT" before insert on printer
for each row
WHEN (new.printer_id is null) begin
select printer_id_seq.nextval into :new.printer_id from dual;
end;
/
ALTER TRIGGER "JOBTRACKER"."PRINTER_ID_INSERT" ENABLE;
--------------------------------------------------------
-- DDL for Trigger POPUP_ID_INSERT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "JOBTRACKER"."POPUP_ID_INSERT" before insert on POPUP
for each row
WHEN (new.ID is null) begin
select POPUP_ID_SEQ.nextval into :new.ID from dual;
end;
/
ALTER TRIGGER "JOBTRACKER"."POPUP_ID_INSERT" ENABLE;
--------------------------------------------------------
-- DDL for Trigger OWL_LOGIN_ID_INSERT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "JOBTRACKER"."OWL_LOGIN_ID_INSERT"
before insert on OWL_LOGIN
for each row
WHEN (new.id is null) begin
select OWL_LOGIN_id_SEQ.nextval into :new.id from dual;
end;
/
ALTER TRIGGER "JOBTRACKER"."OWL_LOGIN_ID_INSERT" ENABLE;
--------------------------------------------------------
-- DDL for Trigger WORK_ID_INSERT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "JOBTRACKER"."WORK_ID_INSERT" BEFORE INSERT ON WORK_TBL
FOR EACH ROW
WHEN (
new.work_id is null
) begin
select work_id_seq.nextval into :new.work_id from dual;
end;
/
ALTER TRIGGER "JOBTRACKER"."WORK_ID_INSERT" ENABLE;
--------------------------------------------------------
-- DDL for Trigger CLIENT_ID_INSERT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "JOBTRACKER"."CLIENT_ID_INSERT" before insert on client_tbl
for each row
WHEN (new.client_id is null) begin
select client_id_seq.nextval into :new.client_id from dual;
end;
/
ALTER TRIGGER "JOBTRACKER"."CLIENT_ID_INSERT" ENABLE;