m2u-upass-admin / DBScript / ib_navigation.sql @ 8:db99a2b14677
History | View | Annotate | Download (3.75 KB)
| 1 | 0:ea666cc7880e | hadi | Rem ===================================================================== |
|---|---|---|---|
| 2 | Rem NAME |
||
| 3 | Rem <ib_navigation.sql> |
||
| 4 | Rem DESCRIPTION |
||
| 5 | Rem <IB Navigation 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_NAVIGATION |
||
| 14 | ( |
||
| 15 | NODE_ID NUMBER NOT NULL, |
||
| 16 | PARENT_ID NUMBER, |
||
| 17 | NODE_NAME VARCHAR2(64 BYTE), |
||
| 18 | NODE_DESCRIPTION VARCHAR2(256 BYTE), |
||
| 19 | NODE_TYPE VARCHAR2(1 BYTE), |
||
| 20 | NODE_STATUS VARCHAR2(1 BYTE), |
||
| 21 | NODE_CODE VARCHAR2(16 BYTE) NOT NULL, |
||
| 22 | NODE_DISPLAY_ORDER NUMBER, |
||
| 23 | PAGE_PATH VARCHAR2(256 BYTE), |
||
| 24 | OPERATION_HOUR NUMBER, |
||
| 25 | OPERATION_START_TIME VARCHAR2(4 BYTE), |
||
| 26 | OPERATION_END_TIME VARCHAR2(4 BYTE), |
||
| 27 | WEEKEND NUMBER DEFAULT 1, |
||
| 28 | OFFLINE_MESSAGE VARCHAR2(256 BYTE), |
||
| 29 | SMS_SERVICE_INDI VARCHAR2(1 BYTE), |
||
| 30 | NAVIGABLE NUMBER DEFAULT 1, |
||
| 31 | QUICK_LINK VARCHAR2(1 BYTE), |
||
| 32 | QUICK_LINK_ORDER NUMBER, |
||
| 33 | NODE_CREATED_BY NUMBER, |
||
| 34 | NODE_UPDATED_BY NUMBER, |
||
| 35 | NODE_CREATION_DATE TIMESTAMP(2), |
||
| 36 | NODE_UPDATED_DATE TIMESTAMP(2), |
||
| 37 | CATEGORY NUMBER, |
||
| 38 | TOP_MENU NUMBER, |
||
| 39 | DISPLAY_CHILD NUMBER, |
||
| 40 | SHORTCUT NUMBER, |
||
| 41 | SP_INSTRUCT VARCHAR2(16 BYTE) |
||
| 42 | ) |
||
| 43 | TABLESPACE USERS |
||
| 44 | PCTUSED 0
|
||
| 45 | PCTFREE 10
|
||
| 46 | INITRANS 1
|
||
| 47 | MAXTRANS 255
|
||
| 48 | STORAGE ( |
||
| 49 | INITIAL 64K
|
||
| 50 | NEXT 128K
|
||
| 51 | MINEXTENTS 1
|
||
| 52 | MAXEXTENTS UNLIMITED |
||
| 53 | PCTINCREASE 0
|
||
| 54 | FREELISTS 1
|
||
| 55 | FREELIST GROUPS 1
|
||
| 56 | BUFFER_POOL DEFAULT
|
||
| 57 | ) |
||
| 58 | LOGGING |
||
| 59 | NOCOMPRESS |
||
| 60 | NOCACHE |
||
| 61 | NOPARALLEL |
||
| 62 | MONITORING; |
||
| 63 | |||
| 64 | |||
| 65 | CREATE UNIQUE INDEX IB_NAVIGATION_PK ON IB_NAVIGATION |
||
| 66 | (NODE_ID) |
||
| 67 | LOGGING |
||
| 68 | TABLESPACE USERS |
||
| 69 | PCTFREE 10
|
||
| 70 | INITRANS 2
|
||
| 71 | MAXTRANS 255
|
||
| 72 | STORAGE ( |
||
| 73 | INITIAL 64K
|
||
| 74 | NEXT 128K
|
||
| 75 | MINEXTENTS 1
|
||
| 76 | MAXEXTENTS UNLIMITED |
||
| 77 | PCTINCREASE 0
|
||
| 78 | FREELISTS 1
|
||
| 79 | FREELIST GROUPS 1
|
||
| 80 | BUFFER_POOL DEFAULT
|
||
| 81 | ) |
||
| 82 | NOPARALLEL; |
||
| 83 | |||
| 84 | |||
| 85 | CREATE UNIQUE INDEX IB_NAVIGATION_R01 ON IB_NAVIGATION |
||
| 86 | (NODE_CODE) |
||
| 87 | LOGGING |
||
| 88 | TABLESPACE USERS |
||
| 89 | PCTFREE 10
|
||
| 90 | INITRANS 2
|
||
| 91 | MAXTRANS 255
|
||
| 92 | STORAGE ( |
||
| 93 | INITIAL 64K
|
||
| 94 | NEXT 128K
|
||
| 95 | MINEXTENTS 1
|
||
| 96 | MAXEXTENTS UNLIMITED |
||
| 97 | PCTINCREASE 0
|
||
| 98 | FREELISTS 1
|
||
| 99 | FREELIST GROUPS 1
|
||
| 100 | BUFFER_POOL DEFAULT
|
||
| 101 | ) |
||
| 102 | NOPARALLEL; |
||
| 103 | |||
| 104 | |||
| 105 | ALTER TABLE IB_NAVIGATION ADD ( |
||
| 106 | CONSTRAINT IB_NAVIGATION_PK
|
||
| 107 | PRIMARY KEY |
||
| 108 | (NODE_ID) |
||
| 109 | USING INDEX |
||
| 110 | TABLESPACE USERS |
||
| 111 | PCTFREE 10
|
||
| 112 | INITRANS 2
|
||
| 113 | MAXTRANS 255
|
||
| 114 | STORAGE ( |
||
| 115 | INITIAL 64K
|
||
| 116 | NEXT 128K
|
||
| 117 | MINEXTENTS 1
|
||
| 118 | MAXEXTENTS UNLIMITED |
||
| 119 | PCTINCREASE 0
|
||
| 120 | FREELISTS 1
|
||
| 121 | FREELIST GROUPS 1
|
||
| 122 | ), |
||
| 123 | CONSTRAINT IB_NAVIGATION_R01
|
||
| 124 | UNIQUE (NODE_CODE)
|
||
| 125 | USING INDEX |
||
| 126 | TABLESPACE USERS |
||
| 127 | PCTFREE 10
|
||
| 128 | INITRANS 2
|
||
| 129 | MAXTRANS 255
|
||
| 130 | STORAGE ( |
||
| 131 | INITIAL 64K
|
||
| 132 | NEXT 128K
|
||
| 133 | MINEXTENTS 1
|
||
| 134 | MAXEXTENTS UNLIMITED |
||
| 135 | PCTINCREASE 0
|
||
| 136 | FREELISTS 1
|
||
| 137 | FREELIST GROUPS 1
|
||
| 138 | )); |