Skip to content

Instantly share code, notes, and snippets.

@erickertz

erickertz/country config

Created July 13, 2018 20:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save erickertz/0113c47c4fc417fec11d94d82fac00ef to your computer and use it in GitHub Desktop.
Save erickertz/0113c47c4fc417fec11d94d82fac00ef to your computer and use it in GitHub Desktop.
Download ZIP
Raw
country config
--------------------------------------------------------
-- File created - Friday-July-13-2018
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Table BRAND
--------------------------------------------------------
CREATE TABLE "MCPDEV"."BRAND"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_COUNTRY
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_COUNTRY"
( "IS_BILLING" NUMBER DEFAULT 1,
"GROUP_TYPE_ID" NUMBER,
"IS_SHIPPING" NUMBER DEFAULT 1,
"NAME" VARCHAR2(100 BYTE),
"COUNTRY_CODE" VARCHAR2(100 BYTE),
"CREATED_DATE" VARCHAR2(100 BYTE),
"LAST_MODIFIED_DATE" TIMESTAMP (6),
"ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_COUNTRY_CNF_COUNTRY_REGION
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_COUNTRY_CNF_COUNTRY_REGION"
( "CNF_COUNTRY_ID" NUMBER(11,0),
"CNF_COUNTRY_REGION_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_COUNTRY_GRP_TYPE
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_COUNTRY_GRP_TYPE"
( "ID" NUMBER,
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_COUNTRY_REGION
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_COUNTRY_REGION"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_CREDIT_CARD
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_CREDIT_CARD"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_DEF_COUNTRY_CNF_PAYMENT
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_DEF_COUNTRY_CNF_PAYMENT"
( "CNF_DEFAULT_COUNTRY_ID" NUMBER(11,0),
"CNF_PAYMENT_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_DEFAULT_COUNTRY
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY"
( "ID" NUMBER(11,0),
"SITE_ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE),
"CNF_COUNTRY_ID" NUMBER(11,0),
"CONVIENENCE_CURRENCY_ID" NUMBER(11,0),
"LANGUAGE_ID" NUMBER(11,0),
"TRANSACTIONAL_CURRENCY_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_DEFAULT_COUNTRY_CURRENCY
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_CURRENCY"
( "CNF_DEFAULT_COUNTRY_ID" NUMBER(11,0),
"CURRENCY_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_DEFAULT_COUNTRY_LANGUAGE
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_LANGUAGE"
( "CNF_DEFAULT_COUNTRY_ID" NUMBER(11,0),
"LANGUAGE_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_GIFT_WRAP_SKU
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE),
"SKU_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_GIFT_WRAP_SKU_CURRENCY
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU_CURRENCY"
( "CNF_GIFT_WRAP_SKU_ID" NUMBER(11,0),
"CURRENCY_ID" NUMBER(11,0),
"PRICE" NUMBER(10,4)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_INVENTORY_POOL
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_INVENTORY_POOL"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE),
"INVENTORY_POOL_TYPE_ID" NUMBER(11,0),
"CNF_COUNTRY_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_INVENTORY_POOL_CNF_COUNTRY
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_INVENTORY_POOL_CNF_COUNTRY"
( "CNF_INVENTORY_POOL_ID" NUMBER(11,0),
"CNF_COUNTRY_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_INVENTORY_POOL_TYPE
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_INVENTORY_POOL_TYPE"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_PAYMENT
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_PAYMENT"
( "ID" NUMBER(11,0),
"CNF_PAYMENT_TYPE_ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_PAYMENT_CNF_CREDIT_CARDS
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_PAYMENT_CNF_CREDIT_CARDS"
( "CNF_PAYMENT_ID" NUMBER(11,0),
"CNF_CREDIT_CARD_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_PAYMENT_CNF_CURRENCY
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_PAYMENT_CNF_CURRENCY"
( "CNF_PAYMENT_ID" NUMBER(11,0),
"CNF_CURRENCY_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_PAYMENT_TYPE
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_PAYMENT_TYPE"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_SITE
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_SITE"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE),
"CONF_INVENTORY_POOL_ID" NUMBER(11,0),
"SITE_ID" NUMBER(11,0),
"CONF_SITE_GROUP_ID" NUMBER(11,0),
"CONF_DEFAULT_COUNTRY_ID" NUMBER(11,0),
"CURRENCY_ID" NUMBER(11,0),
"BACKORDER_PADDING_DAYS" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_SITE_CNF_COUNTRY
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY"
( "CNF_SITE_ID" NUMBER(11,0),
"CNF_COUNTRY_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_SITE_CNF_COUNTRY_PICKUP
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY_PICKUP"
( "CNF_SITE_ID" NUMBER(11,0),
"CNF_COUNTRY_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_SITE_CNF_GIFT_WRAP_SKU
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_SITE_CNF_GIFT_WRAP_SKU"
( "CNF_SITE_ID" NUMBER(11,0),
"CNF_GIFT_WRAP_SKU_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_SITE_CNF_INVENTORY_POOL
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_SITE_CNF_INVENTORY_POOL"
( "CNF_SITE_ID" NUMBER(11,0),
"CNF_INVENTORY_POOL_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_SITE_GROUP
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_SITE_GROUP"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE),
"SITE_ID" NUMBER(11,0),
"BRAND_ID" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CNF_SITE_GROUP_CNF_CREDIT_CARD
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CNF_SITE_GROUP_CNF_CREDIT_CARD"
( "CONF_SITE_GROUP_ID" NUMBER(11,0),
"CONF_CREDIT_CARD" NUMBER(11,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CURRENCY
--------------------------------------------------------
CREATE TABLE "MCPDEV"."CURRENCY"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table LANGUAGE
--------------------------------------------------------
CREATE TABLE "MCPDEV"."LANGUAGE"
( "ID" NUMBER,
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table SITE
--------------------------------------------------------
CREATE TABLE "MCPDEV"."SITE"
( "ID" NUMBER,
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table SKU
--------------------------------------------------------
CREATE TABLE "MCPDEV"."SKU"
( "ID" NUMBER(11,0),
"NAME" VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
REM INSERTING into MCPDEV.BRAND
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_COUNTRY
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_COUNTRY_CNF_COUNTRY_REGION
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_COUNTRY_GRP_TYPE
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_COUNTRY_REGION
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_CREDIT_CARD
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_DEF_COUNTRY_CNF_PAYMENT
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_DEFAULT_COUNTRY
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_DEFAULT_COUNTRY_CURRENCY
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_DEFAULT_COUNTRY_LANGUAGE
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_GIFT_WRAP_SKU
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_GIFT_WRAP_SKU_CURRENCY
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_INVENTORY_POOL
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_INVENTORY_POOL_CNF_COUNTRY
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_INVENTORY_POOL_TYPE
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_PAYMENT
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_PAYMENT_CNF_CREDIT_CARDS
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_PAYMENT_CNF_CURRENCY
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_PAYMENT_TYPE
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_SITE
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_SITE_CNF_COUNTRY
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_SITE_CNF_COUNTRY_PICKUP
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_SITE_CNF_GIFT_WRAP_SKU
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_SITE_CNF_INVENTORY_POOL
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_SITE_GROUP
SET DEFINE OFF;
REM INSERTING into MCPDEV.CNF_SITE_GROUP_CNF_CREDIT_CARD
SET DEFINE OFF;
REM INSERTING into MCPDEV.CURRENCY
SET DEFINE OFF;
REM INSERTING into MCPDEV.LANGUAGE
SET DEFINE OFF;
REM INSERTING into MCPDEV.SITE
SET DEFINE OFF;
REM INSERTING into MCPDEV.SKU
SET DEFINE OFF;
--------------------------------------------------------
-- DDL for Index BRAND_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."BRAND_PK" ON "MCPDEV"."BRAND" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index BRAND_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."BRAND_UK1" ON "MCPDEV"."BRAND" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_COUNTRY_IDX
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_COUNTRY_IDX" ON "MCPDEV"."CNF_COUNTRY" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index INDEX2
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."INDEX2" ON "MCPDEV"."CNF_COUNTRY_CNF_COUNTRY_REGION" ("CNF_COUNTRY_ID", "CNF_COUNTRY_REGION_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index INDEX1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."INDEX1" ON "MCPDEV"."CNF_COUNTRY_GRP_TYPE" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index UC_CNF_COUNTRY_REGION_INDEX1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."UC_CNF_COUNTRY_REGION_INDEX1" ON "MCPDEV"."CNF_COUNTRY_REGION" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index UC_CNF_COUNTRY_REGION_INDEX2
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."UC_CNF_COUNTRY_REGION_INDEX2" ON "MCPDEV"."CNF_COUNTRY_REGION" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_CREDIT_CARD_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_CREDIT_CARD_PK" ON "MCPDEV"."CNF_CREDIT_CARD" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_CREDIT_CARD_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_CREDIT_CARD_UK1" ON "MCPDEV"."CNF_CREDIT_CARD" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_DEFAULT_COUNTRY_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_DEFAULT_COUNTRY_PK" ON "MCPDEV"."CNF_DEFAULT_COUNTRY" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_DEFAULT_COUNTRY_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_DEFAULT_COUNTRY_UK1" ON "MCPDEV"."CNF_DEFAULT_COUNTRY" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_GIFT_WRAP_SKU_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_GIFT_WRAP_SKU_PK" ON "MCPDEV"."CNF_GIFT_WRAP_SKU" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_GIFT_WRAP_SKU_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_GIFT_WRAP_SKU_UK1" ON "MCPDEV"."CNF_GIFT_WRAP_SKU" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_INVENTORY_POOL_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_INVENTORY_POOL_PK" ON "MCPDEV"."CNF_INVENTORY_POOL" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_INVENTORY_POOL_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_INVENTORY_POOL_UK1" ON "MCPDEV"."CNF_INVENTORY_POOL" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_INVENTORY_POOL_TYPE_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_INVENTORY_POOL_TYPE_PK" ON "MCPDEV"."CNF_INVENTORY_POOL_TYPE" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_INVENTORY_POOL_TYPE_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_INVENTORY_POOL_TYPE_UK1" ON "MCPDEV"."CNF_INVENTORY_POOL_TYPE" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_PAYMENT_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_PAYMENT_PK" ON "MCPDEV"."CNF_PAYMENT" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_PAYMENT_INDEX1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_PAYMENT_INDEX1" ON "MCPDEV"."CNF_PAYMENT" ("ID", "NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_PAYMENT_TYPE_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_PAYMENT_TYPE_PK" ON "MCPDEV"."CNF_PAYMENT_TYPE" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_PAYMENT_TYPE_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_PAYMENT_TYPE_UK1" ON "MCPDEV"."CNF_PAYMENT_TYPE" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_SITE_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_SITE_PK" ON "MCPDEV"."CNF_SITE" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_SITE_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_SITE_UK1" ON "MCPDEV"."CNF_SITE" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_SITE_GROUP_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_SITE_GROUP_PK" ON "MCPDEV"."CNF_SITE_GROUP" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index CNF_SITE_GROUP_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."CNF_SITE_GROUP_UK1" ON "MCPDEV"."CNF_SITE_GROUP" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index UC_CURRENCY_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."UC_CURRENCY_PK" ON "MCPDEV"."CURRENCY" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index UC_CURRENCY_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."UC_CURRENCY_UK1" ON "MCPDEV"."CURRENCY" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index LANGUAGE_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."LANGUAGE_PK" ON "MCPDEV"."LANGUAGE" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index LANGUAGE_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."LANGUAGE_UK1" ON "MCPDEV"."LANGUAGE" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index SITE_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."SITE_PK" ON "MCPDEV"."SITE" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index SITE_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."SITE_UK1" ON "MCPDEV"."SITE" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index SKU_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."SKU_PK" ON "MCPDEV"."SKU" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index SKU_UK1
--------------------------------------------------------
CREATE UNIQUE INDEX "MCPDEV"."SKU_UK1" ON "MCPDEV"."SKU" ("NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- Constraints for Table BRAND
--------------------------------------------------------
ALTER TABLE "MCPDEV"."BRAND" ADD CONSTRAINT "BRAND_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."BRAND" ADD CONSTRAINT "BRAND_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."BRAND" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."BRAND" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_COUNTRY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_COUNTRY" ADD CONSTRAINT "CNF_COUNTRY_IDX" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_COUNTRY" MODIFY ("LAST_MODIFIED_DATE" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_COUNTRY" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_COUNTRY" MODIFY ("COUNTRY_CODE" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_COUNTRY" MODIFY ("NAME" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_COUNTRY_CNF_COUNTRY_REGION
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_COUNTRY_CNF_COUNTRY_REGION" MODIFY ("CNF_COUNTRY_REGION_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_COUNTRY_CNF_COUNTRY_REGION" MODIFY ("CNF_COUNTRY_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_COUNTRY_GRP_TYPE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_COUNTRY_GRP_TYPE" ADD CONSTRAINT "UC_CNF_COUNTRY_GRP_TYPE_IDX" PRIMARY KEY ("ID")
USING INDEX (CREATE UNIQUE INDEX "MCPDEV"."INDEX1" ON "MCPDEV"."CNF_COUNTRY_GRP_TYPE" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ) ENABLE;
ALTER TABLE "MCPDEV"."CNF_COUNTRY_GRP_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_COUNTRY_GRP_TYPE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_COUNTRY_REGION
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_COUNTRY_REGION" ADD CONSTRAINT "CNF_COUNTRY_REGION_PRI" PRIMARY KEY ("ID")
USING INDEX (CREATE UNIQUE INDEX "MCPDEV"."UC_CNF_COUNTRY_REGION_INDEX1" ON "MCPDEV"."CNF_COUNTRY_REGION" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ) ENABLE;
ALTER TABLE "MCPDEV"."CNF_COUNTRY_REGION" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_COUNTRY_REGION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_CREDIT_CARD
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_CREDIT_CARD" ADD CONSTRAINT "CNF_CREDIT_CARD_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_CREDIT_CARD" ADD CONSTRAINT "CNF_CREDIT_CARD_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_CREDIT_CARD" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_CREDIT_CARD" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_DEF_COUNTRY_CNF_PAYMENT
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_DEF_COUNTRY_CNF_PAYMENT" MODIFY ("CNF_PAYMENT_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEF_COUNTRY_CNF_PAYMENT" MODIFY ("CNF_DEFAULT_COUNTRY_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_DEFAULT_COUNTRY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" MODIFY ("TRANSACTIONAL_CURRENCY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" MODIFY ("LANGUAGE_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" MODIFY ("CONVIENENCE_CURRENCY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" MODIFY ("CNF_COUNTRY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" MODIFY ("SITE_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_DEFAULT_COUNTRY_CURRENCY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_CURRENCY" MODIFY ("CURRENCY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_CURRENCY" MODIFY ("CNF_DEFAULT_COUNTRY_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_DEFAULT_COUNTRY_LANGUAGE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_LANGUAGE" MODIFY ("LANGUAGE_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_LANGUAGE" MODIFY ("CNF_DEFAULT_COUNTRY_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_GIFT_WRAP_SKU
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU" ADD CONSTRAINT "CNF_GIFT_WRAP_SKU_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU" ADD CONSTRAINT "CNF_GIFT_WRAP_SKU_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU" MODIFY ("SKU_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_GIFT_WRAP_SKU_CURRENCY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU_CURRENCY" MODIFY ("PRICE" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU_CURRENCY" MODIFY ("CURRENCY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU_CURRENCY" MODIFY ("CNF_GIFT_WRAP_SKU_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_INVENTORY_POOL
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL" ADD CONSTRAINT "CNF_INVENTORY_POOL_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL" ADD CONSTRAINT "CNF_INVENTORY_POOL_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL" MODIFY ("CNF_COUNTRY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL" MODIFY ("INVENTORY_POOL_TYPE_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_INVENTORY_POOL_CNF_COUNTRY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL_CNF_COUNTRY" MODIFY ("CNF_COUNTRY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL_CNF_COUNTRY" MODIFY ("CNF_INVENTORY_POOL_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_INVENTORY_POOL_TYPE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL_TYPE" ADD CONSTRAINT "CNF_INVENTORY_POOL_TYPE_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL_TYPE" ADD CONSTRAINT "CNF_INVENTORY_POOL_TYPE_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL_TYPE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_PAYMENT
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_PAYMENT" ADD CONSTRAINT "CNF_PAYMENT_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_PAYMENT" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_PAYMENT" MODIFY ("CNF_PAYMENT_TYPE_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_PAYMENT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_PAYMENT_CNF_CREDIT_CARDS
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_PAYMENT_CNF_CREDIT_CARDS" MODIFY ("CNF_CREDIT_CARD_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_PAYMENT_CNF_CREDIT_CARDS" MODIFY ("CNF_PAYMENT_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_PAYMENT_CNF_CURRENCY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_PAYMENT_CNF_CURRENCY" MODIFY ("CNF_CURRENCY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_PAYMENT_CNF_CURRENCY" MODIFY ("CNF_PAYMENT_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_PAYMENT_TYPE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_PAYMENT_TYPE" ADD CONSTRAINT "CNF_PAYMENT_TYPE_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_PAYMENT_TYPE" ADD CONSTRAINT "CNF_PAYMENT_TYPE_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_PAYMENT_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_PAYMENT_TYPE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_SITE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE" ADD CONSTRAINT "CNF_SITE_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE" ADD CONSTRAINT "CNF_SITE_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE" MODIFY ("BACKORDER_PADDING_DAYS" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE" MODIFY ("CURRENCY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE" MODIFY ("CONF_DEFAULT_COUNTRY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE" MODIFY ("CONF_SITE_GROUP_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE" MODIFY ("SITE_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE" MODIFY ("CONF_INVENTORY_POOL_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_SITE_CNF_COUNTRY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY" MODIFY ("CNF_COUNTRY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY" MODIFY ("CNF_SITE_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_SITE_CNF_COUNTRY_PICKUP
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY_PICKUP" MODIFY ("CNF_COUNTRY_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY_PICKUP" MODIFY ("CNF_SITE_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_SITE_CNF_GIFT_WRAP_SKU
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_GIFT_WRAP_SKU" MODIFY ("CNF_GIFT_WRAP_SKU_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_GIFT_WRAP_SKU" MODIFY ("CNF_SITE_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_SITE_CNF_INVENTORY_POOL
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_INVENTORY_POOL" MODIFY ("CNF_INVENTORY_POOL_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_INVENTORY_POOL" MODIFY ("CNF_SITE_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_SITE_GROUP
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP" ADD CONSTRAINT "CNF_SITE_GROUP_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP" ADD CONSTRAINT "CNF_SITE_GROUP_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP" MODIFY ("BRAND_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP" MODIFY ("SITE_ID" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CNF_SITE_GROUP_CNF_CREDIT_CARD
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP_CNF_CREDIT_CARD" MODIFY ("CONF_CREDIT_CARD" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP_CNF_CREDIT_CARD" MODIFY ("CONF_SITE_GROUP_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CURRENCY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CURRENCY" ADD CONSTRAINT "UC_CURRENCY_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CURRENCY" ADD CONSTRAINT "UC_CURRENCY_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."CURRENCY" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."CURRENCY" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table LANGUAGE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."LANGUAGE" ADD CONSTRAINT "LANGUAGE_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."LANGUAGE" ADD CONSTRAINT "LANGUAGE_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."LANGUAGE" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."LANGUAGE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table SITE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."SITE" ADD CONSTRAINT "SITE_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."SITE" ADD CONSTRAINT "SITE_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."SITE" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."SITE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table SKU
--------------------------------------------------------
ALTER TABLE "MCPDEV"."SKU" ADD CONSTRAINT "SKU_UK1" UNIQUE ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."SKU" ADD CONSTRAINT "SKU_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "MCPDEV"."SKU" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "MCPDEV"."SKU" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Ref Constraints for Table CNF_COUNTRY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_COUNTRY" ADD CONSTRAINT "UC_CNF_COUNTRY_GRP_IDX" FOREIGN KEY ("GROUP_TYPE_ID")
REFERENCES "MCPDEV"."CNF_COUNTRY_GRP_TYPE" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_COUNTRY_CNF_COUNTRY_REGION
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_COUNTRY_CNF_COUNTRY_REGION" ADD CONSTRAINT "CNF_COUNTRY_REGION" FOREIGN KEY ("CNF_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_COUNTRY" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_COUNTRY_CNF_COUNTRY_REGION" ADD CONSTRAINT "CNF_REGION_COUNTRY" FOREIGN KEY ("CNF_COUNTRY_REGION_ID")
REFERENCES "MCPDEV"."CNF_COUNTRY_REGION" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_DEF_COUNTRY_CNF_PAYMENT
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_DEF_COUNTRY_CNF_PAYMENT" ADD CONSTRAINT "CNF_DEF_COUNTRY_CNF_PAYME_FK1" FOREIGN KEY ("CNF_DEFAULT_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_DEFAULT_COUNTRY" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEF_COUNTRY_CNF_PAYMENT" ADD CONSTRAINT "CNF_DEF_COUNTRY_CNF_PAYME_FK2" FOREIGN KEY ("CNF_PAYMENT_ID")
REFERENCES "MCPDEV"."CNF_PAYMENT" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_DEFAULT_COUNTRY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_FK1" FOREIGN KEY ("SITE_ID")
REFERENCES "MCPDEV"."SITE" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_FK2" FOREIGN KEY ("CNF_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_COUNTRY" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_FK3" FOREIGN KEY ("CONVIENENCE_CURRENCY_ID")
REFERENCES "MCPDEV"."CURRENCY" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_FK4" FOREIGN KEY ("LANGUAGE_ID")
REFERENCES "MCPDEV"."LANGUAGE" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_FK5" FOREIGN KEY ("TRANSACTIONAL_CURRENCY_ID")
REFERENCES "MCPDEV"."CURRENCY" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_DEFAULT_COUNTRY_CURRENCY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_CURRENCY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_CURRE_FK1" FOREIGN KEY ("CNF_DEFAULT_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_DEFAULT_COUNTRY" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_CURRENCY" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_CURRE_FK2" FOREIGN KEY ("CURRENCY_ID")
REFERENCES "MCPDEV"."CURRENCY" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_DEFAULT_COUNTRY_LANGUAGE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_LANGUAGE" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_LANGU_FK1" FOREIGN KEY ("CNF_DEFAULT_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_DEFAULT_COUNTRY" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_DEFAULT_COUNTRY_LANGUAGE" ADD CONSTRAINT "CNF_DEFAULT_COUNTRY_LANGU_FK2" FOREIGN KEY ("LANGUAGE_ID")
REFERENCES "MCPDEV"."LANGUAGE" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_GIFT_WRAP_SKU
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU" ADD CONSTRAINT "SKU_ID" FOREIGN KEY ("SKU_ID")
REFERENCES "MCPDEV"."SKU" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_GIFT_WRAP_SKU_CURRENCY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU_CURRENCY" ADD CONSTRAINT "CNF_GIFT_WRAP_SKU_CURRENC_FK1" FOREIGN KEY ("CNF_GIFT_WRAP_SKU_ID")
REFERENCES "MCPDEV"."CNF_GIFT_WRAP_SKU" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_GIFT_WRAP_SKU_CURRENCY" ADD CONSTRAINT "CNF_GIFT_WRAP_SKU_CURRENC_FK2" FOREIGN KEY ("CURRENCY_ID")
REFERENCES "MCPDEV"."CURRENCY" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_INVENTORY_POOL
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL" ADD CONSTRAINT "CNF_INVENTORY_POOL_FK1" FOREIGN KEY ("CNF_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_COUNTRY" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL" ADD CONSTRAINT "CNF_INVENTORY_POOL_TYPE_ID" FOREIGN KEY ("INVENTORY_POOL_TYPE_ID")
REFERENCES "MCPDEV"."CNF_INVENTORY_POOL_TYPE" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_INVENTORY_POOL_CNF_COUNTRY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL_CNF_COUNTRY" ADD CONSTRAINT "CNF_INVENTORY_POOL_CNF_CO_FK1" FOREIGN KEY ("CNF_INVENTORY_POOL_ID")
REFERENCES "MCPDEV"."CNF_INVENTORY_POOL" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_INVENTORY_POOL_CNF_COUNTRY" ADD CONSTRAINT "CNF_INVENTORY_POOL_CNF_CO_FK2" FOREIGN KEY ("CNF_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_COUNTRY" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_PAYMENT
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_PAYMENT" ADD CONSTRAINT "CNF_PAYMENT_TYPE" FOREIGN KEY ("CNF_PAYMENT_TYPE_ID")
REFERENCES "MCPDEV"."CNF_PAYMENT_TYPE" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_PAYMENT_CNF_CREDIT_CARDS
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_PAYMENT_CNF_CREDIT_CARDS" ADD CONSTRAINT "CNF_PAYMENT_CNF_CREDIT_CA_FK1" FOREIGN KEY ("CNF_PAYMENT_ID")
REFERENCES "MCPDEV"."CNF_PAYMENT" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_PAYMENT_CNF_CREDIT_CARDS" ADD CONSTRAINT "CNF_PAYMENT_CNF_CREDIT_CA_FK2" FOREIGN KEY ("CNF_CREDIT_CARD_ID")
REFERENCES "MCPDEV"."CNF_CREDIT_CARD" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_PAYMENT_CNF_CURRENCY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_PAYMENT_CNF_CURRENCY" ADD CONSTRAINT "CNF_PAYMENT_CNF_CURRENCY_FK1" FOREIGN KEY ("CNF_PAYMENT_ID")
REFERENCES "MCPDEV"."CNF_PAYMENT" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_PAYMENT_CNF_CURRENCY" ADD CONSTRAINT "CNF_PAYMENT_CNF_CURRENCY_FK2" FOREIGN KEY ("CNF_CURRENCY_ID")
REFERENCES "MCPDEV"."CURRENCY" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_SITE
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE" ADD CONSTRAINT "CNF_SITE_FK1" FOREIGN KEY ("CONF_INVENTORY_POOL_ID")
REFERENCES "MCPDEV"."CNF_INVENTORY_POOL" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE" ADD CONSTRAINT "CNF_SITE_FK2" FOREIGN KEY ("SITE_ID")
REFERENCES "MCPDEV"."SITE" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE" ADD CONSTRAINT "CNF_SITE_FK3" FOREIGN KEY ("CONF_SITE_GROUP_ID")
REFERENCES "MCPDEV"."CNF_SITE_GROUP" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE" ADD CONSTRAINT "CNF_SITE_FK4" FOREIGN KEY ("CURRENCY_ID")
REFERENCES "MCPDEV"."CURRENCY" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE" ADD CONSTRAINT "CNF_SITE_FK5" FOREIGN KEY ("CONF_DEFAULT_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_DEFAULT_COUNTRY" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_SITE_CNF_COUNTRY
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY" ADD CONSTRAINT "CNF_SITE_CNF_COUNTRY_FK1" FOREIGN KEY ("CNF_SITE_ID")
REFERENCES "MCPDEV"."CNF_SITE" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY" ADD CONSTRAINT "CNF_SITE_CNF_COUNTRY_FK2" FOREIGN KEY ("CNF_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_COUNTRY" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_SITE_CNF_COUNTRY_PICKUP
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY_PICKUP" ADD CONSTRAINT "CNF_SITE_CNF_COUNTRY_PICK_FK1" FOREIGN KEY ("CNF_SITE_ID")
REFERENCES "MCPDEV"."SITE" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_COUNTRY_PICKUP" ADD CONSTRAINT "CNF_SITE_CNF_COUNTRY_PICK_FK2" FOREIGN KEY ("CNF_COUNTRY_ID")
REFERENCES "MCPDEV"."CNF_COUNTRY" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_SITE_CNF_GIFT_WRAP_SKU
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_GIFT_WRAP_SKU" ADD CONSTRAINT "CNF_SITE_CNF_GIFT_WRAP_SK_FK1" FOREIGN KEY ("CNF_SITE_ID")
REFERENCES "MCPDEV"."SITE" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_GIFT_WRAP_SKU" ADD CONSTRAINT "CNF_SITE_CNF_GIFT_WRAP_SK_FK2" FOREIGN KEY ("CNF_GIFT_WRAP_SKU_ID")
REFERENCES "MCPDEV"."CNF_GIFT_WRAP_SKU" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_SITE_CNF_INVENTORY_POOL
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_INVENTORY_POOL" ADD CONSTRAINT "CNF_SITE_CNF_INVENTORY_PO_FK1" FOREIGN KEY ("CNF_SITE_ID")
REFERENCES "MCPDEV"."SITE" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE_CNF_INVENTORY_POOL" ADD CONSTRAINT "CNF_SITE_CNF_INVENTORY_PO_FK2" FOREIGN KEY ("CNF_INVENTORY_POOL_ID")
REFERENCES "MCPDEV"."CNF_INVENTORY_POOL" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_SITE_GROUP
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP" ADD CONSTRAINT "CNF_SITE_GROUP_BRAND_ID" FOREIGN KEY ("BRAND_ID")
REFERENCES "MCPDEV"."BRAND" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP" ADD CONSTRAINT "CNF_SITE_GROUP_FK1" FOREIGN KEY ("SITE_ID")
REFERENCES "MCPDEV"."SITE" ("ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CNF_SITE_GROUP_CNF_CREDIT_CARD
--------------------------------------------------------
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP_CNF_CREDIT_CARD" ADD CONSTRAINT "CNF_SITE_GROUP_CNF_CREDIT_FK1" FOREIGN KEY ("CONF_SITE_GROUP_ID")
REFERENCES "MCPDEV"."CNF_SITE_GROUP" ("ID") ENABLE;
ALTER TABLE "MCPDEV"."CNF_SITE_GROUP_CNF_CREDIT_CARD" ADD CONSTRAINT "CNF_SITE_GROUP_CNF_CREDIT_FK2" FOREIGN KEY ("CONF_CREDIT_CARD")
REFERENCES "MCPDEV"."CNF_CREDIT_CARD" ("ID") ENABLE;
--------------------------------------------------------
-- DDL for Trigger UC_CNF_COUNTRY_REGION_TRG
--------------------------------------------------------
CREATE OR REPLACE EDITIONABLE TRIGGER "MCPDEV"."UC_CNF_COUNTRY_REGION_TRG"
BEFORE INSERT ON "CNF_COUNTRY_REGION"
FOR EACH ROW
BEGIN
<<COLUMN_SEQUENCES>>
BEGIN
IF INSERTING AND :NEW.NAME IS NULL THEN
SELECT UC_CNF_COUNTRY_REGION_SEQ.NEXTVAL INTO :NEW.NAME FROM SYS.DUAL;
END IF;
END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "MCPDEV"."UC_CNF_COUNTRY_REGION_TRG" ENABLE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment