m2u-upass-admin / DBScript / ib_currency_code.sql @ 114:e7278deb37ac
History | View | Annotate | Download (3.39 KB)
| 1 | 0:ea666cc7880e | hadi | Rem ===================================================================== |
|---|---|---|---|
| 2 | Rem NAME |
||
| 3 | Rem <ib_currency_code.sql> |
||
| 4 | Rem DESCRIPTION |
||
| 5 | Rem <IB Currency Code Content Table>
|
||
| 6 | Rem MODULE |
||
| 7 | Rem <IB Module> |
||
| 8 | Rem MODIFIED (MM/DD/YYYY) |
||
| 9 | Rem Danniell 03/12/2010 - Creation |
||
| 10 | Rem xxxxxx mm/dd/yyyy - Modify |
||
| 11 | Rem ===================================================================== |
||
| 12 | |||
| 13 | CREATE TABLE IB_CURRENCY_CODE |
||
| 14 | ( |
||
| 15 | OID NUMBER NOT NULL, |
||
| 16 | CONTENT_CATEGORY_ID NUMBER NOT NULL, |
||
| 17 | CURRENCY_CODE VARCHAR2(6 BYTE) NOT NULL, |
||
| 18 | BASE_UNIT VARCHAR2(10 BYTE), |
||
| 19 | IMAGE_URL VARCHAR2(256 BYTE), |
||
| 20 | DISPLAY_ORDER NUMBER, |
||
| 21 | STATUS NUMBER NOT NULL, |
||
| 22 | DELETED NUMBER NOT NULL, |
||
| 23 | CREATION_DATE TIMESTAMP(2) DEFAULT SYSDATE NOT NULL, |
||
| 24 | LAST_MOD_DATE TIMESTAMP(2) |
||
| 25 | ) |
||
| 26 | TABLESPACE USERS |
||
| 27 | PCTUSED 0
|
||
| 28 | PCTFREE 10
|
||
| 29 | INITRANS 1
|
||
| 30 | MAXTRANS 255
|
||
| 31 | STORAGE ( |
||
| 32 | INITIAL 64K
|
||
| 33 | NEXT 128K
|
||
| 34 | MINEXTENTS 1
|
||
| 35 | MAXEXTENTS UNLIMITED |
||
| 36 | PCTINCREASE 0
|
||
| 37 | FREELISTS 1
|
||
| 38 | FREELIST GROUPS 1
|
||
| 39 | BUFFER_POOL DEFAULT
|
||
| 40 | ) |
||
| 41 | LOGGING |
||
| 42 | NOCOMPRESS |
||
| 43 | NOCACHE |
||
| 44 | NOPARALLEL |
||
| 45 | MONITORING; |
||
| 46 | |||
| 47 | |||
| 48 | CREATE UNIQUE INDEX IB_CURRENCY_CODE_PK ON IB_CURRENCY_CODE |
||
| 49 | (OID) |
||
| 50 | LOGGING |
||
| 51 | TABLESPACE USERS |
||
| 52 | PCTFREE 10
|
||
| 53 | INITRANS 2
|
||
| 54 | MAXTRANS 255
|
||
| 55 | STORAGE ( |
||
| 56 | INITIAL 64K
|
||
| 57 | NEXT 128K
|
||
| 58 | MINEXTENTS 1
|
||
| 59 | MAXEXTENTS UNLIMITED |
||
| 60 | PCTINCREASE 0
|
||
| 61 | FREELISTS 1
|
||
| 62 | FREELIST GROUPS 1
|
||
| 63 | BUFFER_POOL DEFAULT
|
||
| 64 | ) |
||
| 65 | NOPARALLEL; |
||
| 66 | |||
| 67 | |||
| 68 | CREATE UNIQUE INDEX IB_CURRENCY_CODE_R02 ON IB_CURRENCY_CODE |
||
| 69 | (CURRENCY_CODE) |
||
| 70 | LOGGING |
||
| 71 | TABLESPACE USERS |
||
| 72 | PCTFREE 10
|
||
| 73 | INITRANS 2
|
||
| 74 | MAXTRANS 255
|
||
| 75 | STORAGE ( |
||
| 76 | INITIAL 64K
|
||
| 77 | NEXT 128K
|
||
| 78 | MINEXTENTS 1
|
||
| 79 | MAXEXTENTS UNLIMITED |
||
| 80 | PCTINCREASE 0
|
||
| 81 | FREELISTS 1
|
||
| 82 | FREELIST GROUPS 1
|
||
| 83 | BUFFER_POOL DEFAULT
|
||
| 84 | ) |
||
| 85 | NOPARALLEL; |
||
| 86 | |||
| 87 | |||
| 88 | ALTER TABLE IB_CURRENCY_CODE ADD ( |
||
| 89 | CONSTRAINT IB_CURRENCY_CODE_PK
|
||
| 90 | PRIMARY KEY |
||
| 91 | (OID) |
||
| 92 | USING INDEX |
||
| 93 | TABLESPACE USERS |
||
| 94 | PCTFREE 10
|
||
| 95 | INITRANS 2
|
||
| 96 | MAXTRANS 255
|
||
| 97 | STORAGE ( |
||
| 98 | INITIAL 64K
|
||
| 99 | NEXT 128K
|
||
| 100 | MINEXTENTS 1
|
||
| 101 | MAXEXTENTS UNLIMITED |
||
| 102 | PCTINCREASE 0
|
||
| 103 | FREELISTS 1
|
||
| 104 | FREELIST GROUPS 1
|
||
| 105 | ), |
||
| 106 | CONSTRAINT IB_CURRENCY_CODE_R02
|
||
| 107 | UNIQUE (CURRENCY_CODE)
|
||
| 108 | USING INDEX |
||
| 109 | TABLESPACE USERS |
||
| 110 | PCTFREE 10
|
||
| 111 | INITRANS 2
|
||
| 112 | MAXTRANS 255
|
||
| 113 | STORAGE ( |
||
| 114 | INITIAL 64K
|
||
| 115 | NEXT 128K
|
||
| 116 | MINEXTENTS 1
|
||
| 117 | MAXEXTENTS UNLIMITED |
||
| 118 | PCTINCREASE 0
|
||
| 119 | FREELISTS 1
|
||
| 120 | FREELIST GROUPS 1
|
||
| 121 | )); |
||
| 122 | |||
| 123 | ALTER TABLE IB_CURRENCY_CODE ADD ( |
||
| 124 | CONSTRAINT IB_CURRENCY_CODE_R01
|
||
| 125 | FOREIGN KEY (CONTENT_CATEGORY_ID) |
||
| 126 | REFERENCES IB_CONTENT_CATEGORY (OID)
|
||
| 127 | ON DELETE CASCADE); |