m2u-upass-admin / DBScript / ib_sequence.sql @ 25:0b6451c2b158
History | View | Annotate | Download (3.42 KB)
| 1 | 0:ea666cc7880e | hadi | Rem ===================================================================== |
|---|---|---|---|
| 2 | Rem NAME |
||
| 3 | Rem <ib_sequence.sql> |
||
| 4 | Rem DESCRIPTION |
||
| 5 | Rem <IB Sequence> |
||
| 6 | Rem MODULE |
||
| 7 | Rem <IB Module> |
||
| 8 | Rem MODIFIED (MM/DD/YYYY) |
||
| 9 | Rem Danniell 19/10/2010 - Creation |
||
| 10 | Rem xxxxxx mm/dd/yyyy - Modify |
||
| 11 | Rem ===================================================================== |
||
| 12 | |||
| 13 | CREATE SEQUENCE IB_SEQ_LOGIN_HISTORY
|
||
| 14 | START WITH 5104
|
||
| 15 | MAXVALUE 999999999
|
||
| 16 | MINVALUE 1
|
||
| 17 | NOCYCLE |
||
| 18 | NOCACHE |
||
| 19 | NOORDER; |
||
| 20 | |||
| 21 | CREATE SEQUENCE IB_SEQ_SESS
|
||
| 22 | MINVALUE 1
|
||
| 23 | MAXVALUE 999999
|
||
| 24 | INCREMENT BY 1 |
||
| 25 | START WITH 4092
|
||
| 26 | NOCACHE |
||
| 27 | NOORDER |
||
| 28 | CYCLE; |
||
| 29 | |||
| 30 | CREATE SEQUENCE IB_SEQ_TRNX
|
||
| 31 | MINVALUE 1
|
||
| 32 | MAXVALUE 9999999999
|
||
| 33 | INCREMENT BY 1 |
||
| 34 | START WITH 7086
|
||
| 35 | NOCACHE |
||
| 36 | NOORDER |
||
| 37 | NOCYCLE; |
||
| 38 | |||
| 39 | CREATE SEQUENCE SQ_ADMIN_GROUP
|
||
| 40 | START WITH 20
|
||
| 41 | MAXVALUE 999999999999999999999999999
|
||
| 42 | MINVALUE 1
|
||
| 43 | NOCYCLE |
||
| 44 | NOCACHE |
||
| 45 | NOORDER; |
||
| 46 | |||
| 47 | CREATE SEQUENCE SQ_ADMIN_NAVIGATION
|
||
| 48 | START WITH 20
|
||
| 49 | MAXVALUE 999999999999999999999999999
|
||
| 50 | MINVALUE 1
|
||
| 51 | NOCYCLE |
||
| 52 | NOCACHE |
||
| 53 | NOORDER; |
||
| 54 | |||
| 55 | CREATE SEQUENCE SQ_ADMIN_ROLE
|
||
| 56 | START WITH 10
|
||
| 57 | MAXVALUE 999999999999999999999999999
|
||
| 58 | MINVALUE 1
|
||
| 59 | NOCYCLE |
||
| 60 | NOCACHE |
||
| 61 | NOORDER; |
||
| 62 | |||
| 63 | CREATE SEQUENCE SQ_AUDIT_LOG
|
||
| 64 | START WITH 1967
|
||
| 65 | MAXVALUE 999999999999999999999999999
|
||
| 66 | MINVALUE 1
|
||
| 67 | NOCYCLE |
||
| 68 | NOCACHE |
||
| 69 | NOORDER; |
||
| 70 | |||
| 71 | CREATE SEQUENCE SQ_BANCNET_LIST
|
||
| 72 | START WITH 109
|
||
| 73 | MAXVALUE 999999999999999999999999999
|
||
| 74 | MINVALUE 1
|
||
| 75 | NOCYCLE |
||
| 76 | NOCACHE |
||
| 77 | NOORDER; |
||
| 78 | |||
| 79 | CREATE SEQUENCE SQ_BANK_BRANCH
|
||
| 80 | START WITH 1
|
||
| 81 | MAXVALUE 999999999999999999999999999
|
||
| 82 | MINVALUE 1
|
||
| 83 | NOCYCLE |
||
| 84 | NOCACHE |
||
| 85 | NOORDER; |
||
| 86 | |||
| 87 | CREATE SEQUENCE SQ_CONTENT_CATEGORY
|
||
| 88 | START WITH 53
|
||
| 89 | MAXVALUE 999999999999999999999999999
|
||
| 90 | MINVALUE 1
|
||
| 91 | NOCYCLE |
||
| 92 | NOCACHE |
||
| 93 | NOORDER; |
||
| 94 | |||
| 95 | CREATE SEQUENCE SQ_CONTENT_TYPE
|
||
| 96 | START WITH 10
|
||
| 97 | MAXVALUE 999999999999999999999999999
|
||
| 98 | MINVALUE 1
|
||
| 99 | NOCYCLE |
||
| 100 | NOCACHE |
||
| 101 | NOORDER; |
||
| 102 | |||
| 103 | CREATE SEQUENCE SQ_CURRENCY_CODE
|
||
| 104 | START WITH 1
|
||
| 105 | MAXVALUE 999999999999999999999999999
|
||
| 106 | MINVALUE 1
|
||
| 107 | NOCYCLE |
||
| 108 | NOCACHE |
||
| 109 | NOORDER; |
||
| 110 | |||
| 111 | CREATE SEQUENCE SQ_IB_GROUP
|
||
| 112 | START WITH 3
|
||
| 113 | MAXVALUE 999999999999999999999999999
|
||
| 114 | MINVALUE 1
|
||
| 115 | NOCYCLE |
||
| 116 | NOCACHE |
||
| 117 | NOORDER; |
||
| 118 | |||
| 119 | CREATE SEQUENCE SQ_IB_NAVIGATION
|
||
| 120 | START WITH 3
|
||
| 121 | MAXVALUE 999999999999999999999999999
|
||
| 122 | MINVALUE 1
|
||
| 123 | NOCYCLE |
||
| 124 | NOCACHE |
||
| 125 | NOORDER; |
||
| 126 | |||
| 127 | CREATE SEQUENCE SQ_IB_ORGANIZATION
|
||
| 128 | START WITH 53
|
||
| 129 | MAXVALUE 999999999999999999999999999
|
||
| 130 | MINVALUE 1
|
||
| 131 | NOCYCLE |
||
| 132 | NOCACHE |
||
| 133 | NOORDER; |
||
| 134 | |||
| 135 | CREATE SEQUENCE SQ_IB_ROLE
|
||
| 136 | START WITH 5
|
||
| 137 | MAXVALUE 999999999999999999999999999
|
||
| 138 | MINVALUE 1
|
||
| 139 | NOCYCLE |
||
| 140 | NOCACHE |
||
| 141 | NOORDER; |
||
| 142 | |||
| 143 | CREATE SEQUENCE SQ_IB_USER
|
||
| 144 | START WITH 243
|
||
| 145 | MAXVALUE 999999999999999999999999999
|
||
| 146 | MINVALUE 1
|
||
| 147 | NOCYCLE |
||
| 148 | NOCACHE |
||
| 149 | NOORDER; |
||
| 150 | |||
| 151 | CREATE SEQUENCE SQ_PAYEE
|
||
| 152 | START WITH 113
|
||
| 153 | MAXVALUE 999999999999999999999999999
|
||
| 154 | MINVALUE 1
|
||
| 155 | NOCYCLE |
||
| 156 | NOCACHE |
||
| 157 | NOORDER; |
||
| 158 | |||
| 159 | CREATE SEQUENCE SQ_PRODUCT_TYPE
|
||
| 160 | START WITH 50
|
||
| 161 | MAXVALUE 999999999999999999999999999
|
||
| 162 | MINVALUE 1
|
||
| 163 | NOCYCLE |
||
| 164 | NOCACHE |
||
| 165 | NOORDER; |
||
| 166 | |||
| 167 | CREATE SEQUENCE SQ_SERVICE_INFO
|
||
| 168 | START WITH 1
|
||
| 169 | MAXVALUE 999999999999999999999999999
|
||
| 170 | MINVALUE 1
|
||
| 171 | NOCYCLE |
||
| 172 | NOCACHE |
||
| 173 | NOORDER; |
||
| 174 | |||
| 175 | CREATE SEQUENCE SQ_SERVICE_LIST
|
||
| 176 | START WITH 649
|
||
| 177 | MAXVALUE 999999999999999999999999999
|
||
| 178 | MINVALUE 1
|
||
| 179 | NOCYCLE |
||
| 180 | NOCACHE |
||
| 181 | NOORDER; |
||
| 182 | |||
| 183 | CREATE SEQUENCE SQ_SERVICE_NOTE
|
||
| 184 | START WITH 7
|
||
| 185 | MAXVALUE 999999999999999999999999999
|
||
| 186 | MINVALUE 1
|
||
| 187 | NOCYCLE |
||
| 188 | NOCACHE |
||
| 189 | NOORDER; |
||
| 190 | |||
| 191 | CREATE SEQUENCE SQ_TD_TERM
|
||
| 192 | START WITH 1
|
||
| 193 | MAXVALUE 999999999999999999999999999
|
||
| 194 | MINVALUE 1
|
||
| 195 | NOCYCLE |
||
| 196 | NOCACHE |
||
| 197 | NOORDER; |
||
| 198 | |||
| 199 | CREATE SEQUENCE SQ_TRNX_HISTORY
|
||
| 200 | START WITH 1
|
||
| 201 | MAXVALUE 999999999999999999999999999
|
||
| 202 | MINVALUE 1
|
||
| 203 | NOCYCLE |
||
| 204 | NOCACHE |
||
| 205 | NOORDER; |