ClearDataBuilder sample database for Oracle

init_db.sql

-- http://jen.fluxcapacitor.net/geek/autoincr.html

drop sequence company_id_seq;

create sequence company_id_seq 
start with 10 
increment by 1 
nomaxvalue; 

-- select company_id_seq.nextval from dual;

drop sequence associate_id_seq ;

create sequence associate_id_seq 
start with 10 
increment by 1 
nomaxvalue; 

-- select associate_id_seq.nextval from dual;

drop TABLE COMPANY_ASSOCIATE;
drop TABLE COMPANY;

CREATE TABLE COMPANY(ID INTEGER NOT NULL PRIMARY KEY,COMPANY VARCHAR(255));

CREATE TABLE COMPANY_ASSOCIATE(ID INTEGER NOT NULL PRIMARY KEY,ASSOCIATE VARCHAR(255),COMPANY_ID INTEGER);

-- foreingn key constraint

--alter table COMPANY_ASSOCIATE drop constraint FK_COMPANY_ID_IN_ASSOCIATE;

alter table COMPANY_ASSOCIATE
   add constraint FK_COMPANY_ID_IN_ASSOCIATE foreign key (COMPANY_ID)
      references COMPANY (ID)
      -- remove company and all associates
      on delete cascade;
/

-- initial data

  INSERT INTO COMPANY (ID,COMPANY) values (1,'Citi');
  INSERT INTO COMPANY (ID,COMPANY) values (2,'Microsoft');
  INSERT INTO COMPANY (ID,COMPANY) values (3,'IBM');
  INSERT INTO COMPANY (ID,COMPANY) values (4,'Goldman and Sachs');
  INSERT INTO COMPANY (ID,COMPANY) values (5,'Oracle');
  INSERT INTO COMPANY (ID,COMPANY) values (6,'Apple');
  INSERT INTO COMPANY (ID,COMPANY) values (7,'Google');
  
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (1,'Michael Corbat',1);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (2,'John Gerspach',1);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (3,'Bill Gates',2);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (4,'Steve Balmer',2);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (5,'Tim Cook',6);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (6,'Johny Ive',6);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (7,'Larry Ellison',5);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (8,'Lloyd Blankfein',4);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (9,'Virginia M. Rometty',3);
  INSERT INTO COMPANY_ASSOCIATE (ID,ASSOCIATE,COMPANY_ID) values (10,'Sergey Brin',7);