Created
July 13, 2018 20:07
-
-
Save erickertz/0113c47c4fc417fec11d94d82fac00ef to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-------------------------------------------------------- | |
-- 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