
-----------------------------------------------------------
-- Create table EXAMPLEDB.CUSTOMER
-----------------------------------------------------------
CREATE TABLE "EXAMPLEDB"."CUSTOMER" (
      "ID" DECIMAL(10, 0) NOT NULL ,
      "CUST_NAME" VARCHAR(50) WITH DEFAULT NULL ,
      "FIRSTNAME" VARCHAR(50) WITH DEFAULT NULL ,
      "PHONE" VARCHAR(50) WITH DEFAULT NULL ,
      "EMAIL" VARCHAR(50) WITH DEFAULT NULL
   )
   DATA CAPTURE NONE
   COMPRESS NO ;


-----------------------------------------------------------
-- Create index EXAMPLEDB.SQL1405191013103900
-----------------------------------------------------------
CREATE UNIQUE INDEX "EXAMPLEDB"."SQL1405191013103900"
   ON "EXAMPLEDB"."CUSTOMER" (
      "ID" ASC) PCTFREE 10
      ALLOW REVERSE SCANS
      PAGE SPLIT SYMMETRIC COMPRESS NO EXCLUDE NULL KEYS ;


-----------------------------------------------------------
-- Create index EXAMPLEDB.SQL140519101310450
-----------------------------------------------------------
CREATE UNIQUE INDEX "EXAMPLEDB"."SQL140519101310450"
   ON "EXAMPLEDB"."CUSTOMER" (
      "ID" ASC)
      ALLOW REVERSE SCANS
      PAGE SPLIT SYMMETRIC COMPRESS NO ;


-----------------------------------------------------------
-- PRIMARY_KEY SQL140519101310450
-- on EXAMPLEDB.CUSTOMER
-----------------------------------------------------------
ALTER TABLE "EXAMPLEDB"."CUSTOMER"
   ADD CONSTRAINT "SQL140519101310450"
   PRIMARY KEY ("ID") ;

-----------------------------------------------------------
-- Create table TESTEX1.CUSTOMER
-----------------------------------------------------------
CREATE TABLE "TESTEX1"."CUSTOMER" (
      "ID" DECIMAL(10, 0) NOT NULL ,
      "CUST_NAME" CHARACTER(50) WITH DEFAULT NULL ,
      "FIRSTNAME" VARCHAR(50) WITH DEFAULT NULL ,
      "PHONE" VARCHAR(50) WITH DEFAULT NULL ,
      "EMAIL" VARCHAR(150) WITH DEFAULT NULL ,
      "CUST_NR" DECIMAL(9, 0)
   )
   DATA CAPTURE NONE
   COMPRESS NO ;


-----------------------------------------------------------
-- Create index TESTEX1.SQL1405191013103900
-----------------------------------------------------------
CREATE UNIQUE INDEX "TESTEX1"."SQL1405191013103900"
   ON "TESTEX1"."CUSTOMER" (
      "ID" ASC) PCTFREE 10
      ALLOW REVERSE SCANS
      PAGE SPLIT SYMMETRIC COMPRESS NO EXCLUDE NULL KEYS ;


-----------------------------------------------------------
-- Create index TESTEX1.SQL140519101310450
-----------------------------------------------------------
CREATE UNIQUE INDEX "TESTEX1"."SQL140519101310450"
   ON "TESTEX1"."CUSTOMER" (
      "ID" ASC)
      ALLOW REVERSE SCANS
      PAGE SPLIT SYMMETRIC COMPRESS NO ;


-----------------------------------------------------------
-- PRIMARY_KEY SQL140519101310450
-- on TESTEX1.CUSTOMER
-----------------------------------------------------------
ALTER TABLE "TESTEX1"."CUSTOMER"
   ADD CONSTRAINT "SQL140519101310450"
   PRIMARY KEY ("ID") ;


