m2u-upass-admin / DBScript / ib_sequence.sql @ 8:db99a2b14677
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; |