m2u-upass-admin / DBScript / ib_sequence.sql @ 70:2d8ed17e0fed
History | View | Annotate | Download (3.42 KB)
1 |
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; |