m2u-upass-admin / DBScript / ib_group.sql @ 18:f6f916c1b907
History | View | Annotate | Download (2.91 KB)
| 1 | 0:ea666cc7880e | hadi | Rem ===================================================================== |
|---|---|---|---|
| 2 | Rem NAME |
||
| 3 | Rem <ib_group.sql> |
||
| 4 | Rem DESCRIPTION |
||
| 5 | Rem <IB Group 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_GROUP |
||
| 14 | ( |
||
| 15 | GROUP_ID NUMBER NOT NULL, |
||
| 16 | GROUP_NAME VARCHAR2(64 BYTE) NOT NULL, |
||
| 17 | GROUP_DESCRIPTION VARCHAR2(356 BYTE), |
||
| 18 | GROUP_CREATED_BY NUMBER, |
||
| 19 | GROUP_UPDATED_BY NUMBER, |
||
| 20 | GROUP_CREATION_DATE TIMESTAMP(2) DEFAULT SYSDATE NOT NULL, |
||
| 21 | GROUP_UPDATED_DATE TIMESTAMP(2), |
||
| 22 | CATEGORY NUMBER, |
||
| 23 | USER_TYPE VARCHAR2(2 BYTE) |
||
| 24 | ) |
||
| 25 | TABLESPACE USERS |
||
| 26 | PCTUSED 0
|
||
| 27 | PCTFREE 10
|
||
| 28 | INITRANS 1
|
||
| 29 | MAXTRANS 255
|
||
| 30 | STORAGE ( |
||
| 31 | INITIAL 64K
|
||
| 32 | NEXT 128K
|
||
| 33 | MINEXTENTS 1
|
||
| 34 | MAXEXTENTS UNLIMITED |
||
| 35 | PCTINCREASE 0
|
||
| 36 | FREELISTS 1
|
||
| 37 | FREELIST GROUPS 1
|
||
| 38 | BUFFER_POOL DEFAULT
|
||
| 39 | ) |
||
| 40 | LOGGING |
||
| 41 | NOCOMPRESS |
||
| 42 | NOCACHE |
||
| 43 | NOPARALLEL |
||
| 44 | MONITORING; |
||
| 45 | |||
| 46 | |||
| 47 | CREATE UNIQUE INDEX IB_GROUP_PK ON IB_GROUP |
||
| 48 | (GROUP_ID) |
||
| 49 | LOGGING |
||
| 50 | TABLESPACE USERS |
||
| 51 | PCTFREE 10
|
||
| 52 | INITRANS 2
|
||
| 53 | MAXTRANS 255
|
||
| 54 | STORAGE ( |
||
| 55 | INITIAL 64K
|
||
| 56 | NEXT 128K
|
||
| 57 | MINEXTENTS 1
|
||
| 58 | MAXEXTENTS UNLIMITED |
||
| 59 | PCTINCREASE 0
|
||
| 60 | FREELISTS 1
|
||
| 61 | FREELIST GROUPS 1
|
||
| 62 | BUFFER_POOL DEFAULT
|
||
| 63 | ) |
||
| 64 | NOPARALLEL; |
||
| 65 | |||
| 66 | |||
| 67 | CREATE UNIQUE INDEX IB_GROUP_U01 ON IB_GROUP |
||
| 68 | (USER_TYPE) |
||
| 69 | LOGGING |
||
| 70 | TABLESPACE USERS |
||
| 71 | PCTFREE 10
|
||
| 72 | INITRANS 2
|
||
| 73 | MAXTRANS 255
|
||
| 74 | STORAGE ( |
||
| 75 | INITIAL 64K
|
||
| 76 | NEXT 64K
|
||
| 77 | MINEXTENTS 1
|
||
| 78 | MAXEXTENTS UNLIMITED |
||
| 79 | PCTINCREASE 50
|
||
| 80 | FREELISTS 1
|
||
| 81 | FREELIST GROUPS 1
|
||
| 82 | BUFFER_POOL DEFAULT
|
||
| 83 | ) |
||
| 84 | NOPARALLEL; |
||
| 85 | |||
| 86 | |||
| 87 | ALTER TABLE IB_GROUP ADD ( |
||
| 88 | CONSTRAINT IB_GROUP_PK
|
||
| 89 | PRIMARY KEY |
||
| 90 | (GROUP_ID) |
||
| 91 | USING INDEX |
||
| 92 | TABLESPACE USERS |
||
| 93 | PCTFREE 10
|
||
| 94 | INITRANS 2
|
||
| 95 | MAXTRANS 255
|
||
| 96 | STORAGE ( |
||
| 97 | INITIAL 64K
|
||
| 98 | NEXT 128K
|
||
| 99 | MINEXTENTS 1
|
||
| 100 | MAXEXTENTS UNLIMITED |
||
| 101 | PCTINCREASE 0
|
||
| 102 | FREELISTS 1
|
||
| 103 | FREELIST GROUPS 1
|
||
| 104 | ), |
||
| 105 | CONSTRAINT IB_GROUP_U01
|
||
| 106 | UNIQUE (USER_TYPE)
|
||
| 107 | USING INDEX |
||
| 108 | TABLESPACE USERS |
||
| 109 | PCTFREE 10
|
||
| 110 | INITRANS 2
|
||
| 111 | MAXTRANS 255
|
||
| 112 | STORAGE ( |
||
| 113 | INITIAL 64K
|
||
| 114 | NEXT 64K
|
||
| 115 | MINEXTENTS 1
|
||
| 116 | MAXEXTENTS UNLIMITED |
||
| 117 | PCTINCREASE 50
|
||
| 118 | FREELISTS 1
|
||
| 119 | FREELIST GROUPS 1
|
||
| 120 | )); |