 ALTER TRIGGER A2_BERELATIONTYPE_INSERT ENABLE;
 
 --------------------------------------------------------
---  MAPPING SOURCE
---------------------------------------------------------
-  CREATE SEQUENCE  "A2_SOFTWARE_SEQ"
-    MINVALUE 1 MAXVALUE 1.00000000000000E+27
-    INCREMENT BY 1 START WITH 1 CACHE 20
-    NOORDER  NOCYCLE;
-
-
-  CREATE TABLE "A2_SOFTWARE" (
-    "SOFTWAREID" NUMBER(22,0) CONSTRAINT NN_SOFTWARE_ID NOT NULL
-  , "NAME" VARCHAR2(255) CONSTRAINT NN_SOFTWARE_NAME NOT NULL
-  , "VERSION" VARCHAR2(255));
-
-
-  ALTER TABLE "A2_SOFTWARE"
-  ADD CONSTRAINT "PK_SOFTWARE"
-    PRIMARY KEY ("SOFTWAREID")
-    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
-    STORAGE(INITIAL 1048576
-            NEXT 1048576
-            MINEXTENTS 1
-            MAXEXTENTS 2147483645
-            PCTINCREASE 0
-            FREELISTS 1
-            FREELIST GROUPS 1
-            BUFFER_POOL DEFAULT)
-  /*INDEX_TABLESPACE*/
-  ENABLE;
-
-
-  ALTER TABLE "A2_SOFTWARE"
-  ADD CONSTRAINT "UQ_SOFTWARE_NAME_VERSION"
-    UNIQUE("NAME", "VERSION")
-    ENABLE;
-
-
-CREATE OR REPLACE TRIGGER "A2_SOFTWARE_INSERT"
-before insert on A2_SOFTWARE
-for each row
-begin
-if(:new.SOFTWAREID is null) then
-select A2_SOFTWARE_seq.nextval into :new.SOFTWAREID from dual;
-end if;
-end;
-/
-
-ALTER TRIGGER "A2_SOFTWARE_INSERT" ENABLE;
-
---------------------------------------------------------
 -- BIOENTITY2BIOENTITY
 --------------------------------------------------------
  CREATE SEQUENCE  "A2_BIOENTITY2BIOENTITY_SEQ"


 ALTER TABLE "A2_BIOENTITY2BIOENTITY"
  ADD CONSTRAINT "UQ_BE2BE_FROM_TO_RELATION"
    UNIQUE("BIOENTITYIDFROM", "BIOENTITYIDTO", "BERELATIONTYPEID")
    ENABLE;

 ALTER TABLE "A2_BIOENTITY2BIOENTITY"

  , "NAME" VARCHAR2(255) CONSTRAINT NN_ARRAYDESIGN_NAME NOT NULL
  , "PROVIDER" VARCHAR2(255)
  , "LOADDATE" DATE
  , "MAPPINGSWID" NUMBER(22,0) /*CONSTRAINT NN_ARRAYDESIGN_MAPPINGSW NOT NULL*/) ;


  ALTER TABLE "A2_ARRAYDESIGN" 
