--------------------------------------------------------
--  File created - Mittwoch-Februar-20-2008   
--------------------------------------------------------


--------------------------------------------------------
--  DDL for Sequence REGIONS_SEQ
--------------------------------------------------------
  DROP SEQUENCE "REGIONS_SEQ";

  CREATE SEQUENCE  "REGIONS_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
   

--------------------------------------------------------
--  DDL for Table REGIONS
--------------------------------------------------------
  DROP TABLE "REGIONS";

  CREATE TABLE "REGIONS" 
   (	"REGION_ID" NUMBER CONSTRAINT "REGION_ID_NN" NOT NULL ENABLE, 
	"REGION_NAME" VARCHAR2(25), 
	 CONSTRAINT "REG_ID_PK" PRIMARY KEY ("REGION_ID") ENABLE
   ) ;
 
 
--------------------------------------------------------
--  DDL for Trigger REGIONS_TRIG
--------------------------------------------------------
DROP TRIGGER "REGIONS_TRIG";
   
CREATE OR REPLACE TRIGGER REGIONS_TRIG
BEFORE INSERT
ON REGIONS
FOR EACH ROW
BEGIN
  SELECT REGIONS_SEQ.NEXTVAL INTO :NEW.REGION_ID FROM DUAL;
END;
/

ALTER TRIGGER "REGIONS_TRIG" ENABLE;
-- ALTER TRIGGER "REGIONS_TRIG" DISABLE;

---------------------------------------------------
--   DATA FOR TABLE REGIONS
--   FILTER = none used
---------------------------------------------------
-- INSERTING into REGIONS

Insert into REGIONS (REGION_ID,REGION_NAME) values (REGIONS_SEQ.NEXTVAL,'Europe');
Insert into REGIONS (REGION_ID,REGION_NAME) values (REGIONS_SEQ.NEXTVAL,'Americas');
Insert into REGIONS (REGION_ID,REGION_NAME) values (REGIONS_SEQ.NEXTVAL,'Asia');
Insert into REGIONS (REGION_ID,REGION_NAME) values (REGIONS_SEQ.NEXTVAL,'Middle East and Africa');

---------------------------------------------------
--   END DATA FOR TABLE REGIONS
---------------------------------------------------