Produced by Araxis Merge on 5/10/2018 8:40:09 AM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | Thu May 10 13:40:09 2018 UTC | ||
2 | MHED_APPS_CIF.zip\VAR v4.2.7\var-resources-4.2.7@54bdc2933ef.zip\var-db\liquibase\build-lib\liquibase.jar\liquibase\parser\core\xml | dbchangelog-2.0.xsd | Wed May 2 11:37:12 2012 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 0 | 0 |
Changed | 0 | 0 |
Inserted | 1 | 1068 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | <?xml vers ion="1.0" encoding=" UTF-8"?> | |||||
2 | ||||||
3 | <xsd:schem a xmlns:xs d="http:// www.w3.org /2001/XMLS chema" | |||||
4 | ta rgetNamesp ace="http: //www.liqu ibase.org/ xml/ns/dbc hangelog" xmlns="htt p://www.li quibase.or g/xml/ns/d bchangelog " | |||||
5 | el ementFormD efault="qu alified"> | |||||
6 | ||||||
7 | <x sd:simpleT ype name=" propertyEx pression" id="proper tyExpressi on"> | |||||
8 | <x sd:restric tion base= "xsd:strin g"> | |||||
9 | <xsd :pattern v alue="\$\{ [\w\.]+\}" /> | |||||
10 | </xsd:re striction> | |||||
11 | </xsd: simpleType > | |||||
12 | ||||||
13 | <xsd:s impleType name="bool eanExp" id ="booleanE xp"> | |||||
14 | <x sd:annotat ion> | |||||
15 | <xsd:app info> | |||||
16 | <xsd :documenta tion>Exten sion to st andard XSD boolean t ype to all ow ${} par ameters</x sd:documen tation> | |||||
17 | </xsd:ap pinfo> | |||||
18 | </ xsd:annota tion> | |||||
19 | <x sd:union> | |||||
20 | <xsd:sim pleType> | |||||
21 | <xsd :restricti on base="x sd:boolean "/> | |||||
22 | </xsd:si mpleType> | |||||
23 | <xsd:sim pleType> | |||||
24 | <xsd :restricti on base="p ropertyExp ression"/> | |||||
25 | </xsd:si mpleType> | |||||
26 | </ xsd:union> | |||||
27 | </xsd: simpleType > | |||||
28 | ||||||
29 | <xsd:s impleType name="inte gerExp" id ="integerE xp"> | |||||
30 | <x sd:annotat ion> | |||||
31 | <xsd:app info> | |||||
32 | <xsd :documenta tion>Exten sion to st andard XSD integer t ype to all ow ${} par ameters</x sd:documen tation> | |||||
33 | </xsd:ap pinfo> | |||||
34 | </ xsd:annota tion> | |||||
35 | <x sd:union> | |||||
36 | <xsd:sim pleType> | |||||
37 | <xsd :restricti on base="x sd:integer "/> | |||||
38 | </xsd:si mpleType> | |||||
39 | <xsd:sim pleType> | |||||
40 | <xsd :restricti on base="p ropertyExp ression"/> | |||||
41 | </xsd:si mpleType> | |||||
42 | </ xsd:union> | |||||
43 | </xsd: simpleType > | |||||
44 | ||||||
45 | <x sd:simpleT ype name=" onChangeSe tPrecondit ionErrorOr Fail"> | |||||
46 | <xsd :restricti on base="x sd:string" > | |||||
47 | <xsd:e numeration value="HA LT" /> | |||||
48 | <xsd:e numeration value="WA RN" /> | |||||
49 | <xsd:e numeration value="CO NTINUE" /> | |||||
50 | <xsd:e numeration value="MA RK_RAN" /> | |||||
51 | </xs d:restrict ion> | |||||
52 | </ xsd:simple Type> | |||||
53 | ||||||
54 | <x sd:simpleT ype name=" onChangeLo gPrecondit ionErrorOr Fail"> | |||||
55 | <xsd :restricti on base="x sd:string" > | |||||
56 | <xsd:e numeration value="HA LT" /> | |||||
57 | <xsd:e numeration value="WA RN" /> | |||||
58 | </xs d:restrict ion> | |||||
59 | </ xsd:simple Type> | |||||
60 | ||||||
61 | <x sd:simpleT ype name=" onChangeLo gPrecondit ionOnSqlOu tput"> | |||||
62 | <xsd :restricti on base="x sd:string" > | |||||
63 | <xsd:e numeration value="TE ST" /> | |||||
64 | <xsd:e numeration value="FA IL" /> | |||||
65 | <xsd:e numeration value="IG NORE" /> | |||||
66 | </xs d:restrict ion> | |||||
67 | </ xsd:simple Type> | |||||
68 | ||||||
69 | <xsd:s impleType name="onCh angeSetVal idationFai l"> | |||||
70 | <x sd:restric tion base= "xsd:strin g"> | |||||
71 | <xsd:enu meration v alue="HALT " /> | |||||
72 | <xsd:enu meration v alue="MARK _RAN" /> | |||||
73 | </ xsd:restri ction> | |||||
74 | </xsd: simpleType > | |||||
75 | ||||||
76 | <! -- This is the main (root) par t of the x sd --> | |||||
77 | <x sd:element name="dat abaseChang eLog"> | |||||
78 | <xsd :complexTy pe> | |||||
79 | <xsd:s equence> | |||||
80 | <xsd:ele ment name= "property" minOccurs ="0" maxOc curs="unbo unded"> | |||||
81 | <xsd:compl exType> | |||||
82 | <x sd:attribu te name="f ile" type= "xsd:strin g" /> | |||||
83 | <x sd:attribu te name="n ame" type= "xsd:strin g" /> | |||||
84 | <x sd:attribu te name="v alue" type ="xsd:stri ng" /> | |||||
85 | <x sd:attribu te name="d bms" type= "xsd:strin g" /> | |||||
86 | <x sd:attribu te name="c ontext" ty pe="xsd:st ring" /> | |||||
87 | </xsd:comp lexType> | |||||
88 | </xsd:el ement> | |||||
89 | ||||||
90 | <xsd:ele ment name= "preCondit ions" minO ccurs="0" | |||||
91 | maxOccurs= "1"> | |||||
92 | <xsd:compl exType> | |||||
93 | <x sd:choice> | |||||
94 | <xsd :group ref ="PreCondi tionChildr en" maxOcc urs="unbou nded" /> | |||||
95 | </ xsd:choice > | |||||
96 | <x sd:attribu te name="o nFailMessa ge" type=" xsd:string " /> | |||||
97 | <x sd:attribu te name="o nErrorMess age" type= "xsd:strin g" /> | |||||
98 | <x sd:attribu te name="o nFail" | |||||
99 | type ="onChange LogPrecond itionError OrFail" /> | |||||
100 | <x sd:attribu te name="o nError" | |||||
101 | type ="onChange LogPrecond itionError OrFail" /> | |||||
102 | <x sd:attribu te name="o nSqlOutput " | |||||
103 | type ="onChange LogPrecond itionOnSql Output" /> | |||||
104 | </xsd:comp lexType> | |||||
105 | </xsd:el ement> | |||||
106 | ||||||
107 | <xsd:cho ice minOcc urs="0" ma xOccurs="u nbounded"> | |||||
108 | <xsd:eleme nt name="c hangeSet" minOccurs= "0" maxOcc urs="unbou nded"> | |||||
109 | <x sd:complex Type> | |||||
110 | <xsd :sequence> | |||||
111 | <xsd:e lement nam e="validCh eckSum" mi nOccurs="0 " | |||||
112 | maxOccur s="unbound ed"> | |||||
113 | <xsd:com plexType m ixed="true "> | |||||
114 | <xsd:seque nce> | |||||
115 | <x sd:element ref="comm ent" minOc curs="0" | |||||
116 | maxO ccurs="1" /> | |||||
117 | </xsd:sequ ence> | |||||
118 | </xsd:co mplexType> | |||||
119 | </xsd: element> | |||||
120 | <xsd:e lement nam e="preCond itions" mi nOccurs="0 " | |||||
121 | maxOccur s="1"> | |||||
122 | <xsd :annotatio n> | |||||
123 | <xsd:appin fo> | |||||
124 | <xsd:d ocumentati on>onChang eLogPrecon ditionOnSq lOutput de termines w hat should happen wh en evaluat ing this p reconditio n in updat eSQL mode. TEST: Ru n precondi tion, FAIL : Fail pre condition, IGNORE: S kip precon dition che ck [DEFAUL T]</xsd:do cumentatio n> | |||||
125 | </xsd:appi nfo> | |||||
126 | </xs d:annotati on> | |||||
127 | <xsd:com plexType> | |||||
128 | <xsd:choic e> | |||||
129 | <x sd:group r ef="PreCon ditionChil dren" maxO ccurs="unb ounded" /> | |||||
130 | </xsd:choi ce> | |||||
131 | <xsd:attri bute name= "onFailMes sage" type ="xsd:stri ng" /> | |||||
132 | <xsd:attri bute name= "onErrorMe ssage" typ e="xsd:str ing" /> | |||||
133 | <xsd:attri bute name= "onFail" | |||||
134 | ty pe="onChan geSetPreco nditionErr orOrFail" /> | |||||
135 | <xsd:attri bute name= "onError" | |||||
136 | ty pe="onChan geSetPreco nditionErr orOrFail" /> | |||||
137 | <xsd:attri bute name= "onSqlOutp ut" | |||||
138 | ty pe="onChan geLogPreco nditionOnS qlOutput" /> | |||||
139 | </xsd:co mplexType> | |||||
140 | </xsd: element> | |||||
141 | <xsd:c hoice> | |||||
142 | <xsd:ele ment ref=" tagDatabas e" maxOccu rs="1" /> | |||||
143 | <xsd:gro up ref="ch angeSetChi ldren" min Occurs="0" | |||||
144 | maxOccurs= "unbounded " /> | |||||
145 | </xsd: choice> | |||||
146 | ||||||
147 | <xsd:e lement nam e="modifyS ql" minOcc urs="0" | |||||
148 | maxOccur s="unbound ed"> | |||||
149 | <xsd:com plexType> | |||||
150 | <xsd:choic e> | |||||
151 | <x sd:group r ef="modify SqlChildre n" minOccu rs="1" | |||||
152 | maxO ccurs="unb ounded" /> | |||||
153 | </xsd:choi ce> | |||||
154 | <xsd:attri bute name= "dbms" typ e="xsd:str ing" /> | |||||
155 | <xsd:attri bute name= "context" type="xsd: string" /> | |||||
156 | <xsd:attri bute name= "applyToRo llback" ty pe="boolea nExp" /> | |||||
157 | </xsd:co mplexType> | |||||
158 | </xsd: element> | |||||
159 | ||||||
160 | </xs d:sequence > | |||||
161 | <xsd :attribute Group ref= "changeSet Attributes " /> | |||||
162 | </ xsd:comple xType> | |||||
163 | </xsd:elem ent> | |||||
164 | ||||||
165 | <!-- inclu de --> | |||||
166 | <xsd:eleme nt name="i nclude" mi nOccurs="0 " maxOccur s="unbound ed"> | |||||
167 | <x sd:complex Type> | |||||
168 | <xsd :attribute name="fil e" type="x sd:string" use="requ ired" /> | |||||
169 | <xsd :attribute name="rel ativeToCha ngelogFile " type="bo oleanExp" /> | |||||
170 | </ xsd:comple xType> | |||||
171 | </xsd:elem ent> | |||||
172 | <xsd:eleme nt name="i ncludeAll" minOccurs ="0" maxOc curs="unbo unded"> | |||||
173 | <x sd:complex Type> | |||||
174 | <xsd :attribute name="pat h" type="x sd:string" use="requ ired" /> | |||||
175 | <xsd :attribute name="rel ativeToCha ngelogFile " type="bo oleanExp" /> | |||||
176 | </ xsd:comple xType> | |||||
177 | </xsd:elem ent> | |||||
178 | </xsd:ch oice> | |||||
179 | </xsd: sequence> | |||||
180 | <xsd:a ttributeGr oup ref="c hangeLogAt tributes" /> | |||||
181 | </xs d:complexT ype> | |||||
182 | </ xsd:elemen t> | |||||
183 | ||||||
184 | <x sd:group n ame="modif ySqlChildr en"> | |||||
185 | <xsd :choice> | |||||
186 | <xsd:e lement nam e="replace " minOccur s="0" maxO ccurs="unb ounded"> | |||||
187 | <xsd:com plexType> | |||||
188 | <xsd:attri bute name= "replace" type="xsd: string" us e="require d" /> | |||||
189 | <xsd:attri bute name= "with" typ e="xsd:str ing" use=" required" /> | |||||
190 | </xsd:co mplexType> | |||||
191 | </xsd: element> | |||||
192 | <xsd:e lement nam e="regExpR eplace" mi nOccurs="0 " | |||||
193 | maxOccur s="unbound ed"> | |||||
194 | <xsd:com plexType> | |||||
195 | <xsd:attri bute name= "replace" type="xsd: string" us e="require d" /> | |||||
196 | <xsd:attri bute name= "with" typ e="xsd:str ing" use=" required" /> | |||||
197 | </xsd:co mplexType> | |||||
198 | </xsd: element> | |||||
199 | <xsd:e lement nam e="prepend " minOccur s="0" maxO ccurs="unb ounded"> | |||||
200 | <xsd:com plexType> | |||||
201 | <xsd:attri bute name= "value" ty pe="xsd:st ring" use= "required" /> | |||||
202 | </xsd:co mplexType> | |||||
203 | </xsd: element> | |||||
204 | <xsd:e lement nam e="append" minOccurs ="0" maxOc curs="unbo unded"> | |||||
205 | <xsd:com plexType> | |||||
206 | <xsd:attri bute name= "value" ty pe="xsd:st ring" use= "required" /> | |||||
207 | </xsd:co mplexType> | |||||
208 | </xsd: element> | |||||
209 | </xs d:choice> | |||||
210 | </ xsd:group> | |||||
211 | ||||||
212 | <! -- Attribu tes for Da tabaseInfo --> | |||||
213 | <x sd:attribu teGroup na me="Databa seInfoAttr ibutes"> | |||||
214 | <xsd :attribute name="typ e" type="x sd:string" /> | |||||
215 | <xsd :attribute name="ver sion" type ="xsd:stri ng" /> | |||||
216 | <xsd :attribute name="use rname" typ e="xsd:str ing" /> | |||||
217 | <xsd :attribute name="pas sword" typ e="xsd:str ing" /> | |||||
218 | <xsd :attribute name="por t" type="i ntegerExp" /> | |||||
219 | <xsd :attribute name="hos t" type="x sd:string" /> | |||||
220 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
221 | <xsd :attribute name="dri verName" t ype="xsd:s tring" /> | |||||
222 | </ xsd:attrib uteGroup> | |||||
223 | ||||||
224 | <! -- Attribu tes for ch angeSet -- > | |||||
225 | <x sd:attribu teGroup na me="change LogAttribu tes"> | |||||
226 | <xsd :attribute name="log icalFilePa th" type=" xsd:string " /> | |||||
227 | </ xsd:attrib uteGroup> | |||||
228 | ||||||
229 | <! -- Attribu tes for ch angeSet -- > | |||||
230 | <x sd:attribu teGroup na me="change SetAttribu tes"> | |||||
231 | <xsd :attribute name="id" type="xsd :string" u se="requir ed" /> | |||||
232 | <xsd :attribute name="aut hor" type= "xsd:strin g" use="re quired" /> | |||||
233 | <xsd :attribute name="con text" type ="xsd:stri ng" /> | |||||
234 | <xsd :attribute name="dbm s" type="x sd:string" /> | |||||
235 | <xsd :attribute name="run OnChange" type="bool eanExp" /> | |||||
236 | <xsd :attribute name="run Always" ty pe="boolea nExp" /> | |||||
237 | <xsd :attribute name="fai lOnError" type="bool eanExp" /> | |||||
238 | <x sd:attribu te name="o nValidatio nFail" typ e="onChang eSetValida tionFail" /> | |||||
239 | <xsd :attribute name="run InTransact ion" type= "booleanEx p" default ="true" /> | |||||
240 | <xsd :attribute name="log icalFilePa th" type=" xsd:string " /> | |||||
241 | </ xsd:attrib uteGroup> | |||||
242 | ||||||
243 | <! -- Attribu tes for co nstraints --> | |||||
244 | <x sd:attribu teGroup na me="constr aintsAttri butes"> | |||||
245 | <xsd :attribute name="nul lable" typ e="boolean Exp" /> | |||||
246 | <xsd :attribute name="pri maryKey" t ype="boole anExp" /> | |||||
247 | <xsd :attribute name="pri maryKeyNam e" type="x sd:string" /> | |||||
248 | <x sd:attribu te name="p rimaryKeyT ablespace" type="xsd :string" / > | |||||
249 | <xsd :attribute name="uni que" type= "booleanEx p" /> | |||||
250 | <xsd :attribute name="uni queConstra intName" t ype="xsd:s tring" /> | |||||
251 | <xsd :attribute name="ref erences" t ype="xsd:s tring" /> | |||||
252 | <xsd :attribute name="for eignKeyNam e" type="x sd:string" /> | |||||
253 | <xsd :attribute name="del eteCascade " type="bo oleanExp" /> | |||||
254 | <xsd :attribute name="def errable" t ype="boole anExp" /> | |||||
255 | <xsd :attribute name="ini tiallyDefe rred" type ="booleanE xp" /> | |||||
256 | </ xsd:attrib uteGroup> | |||||
257 | ||||||
258 | <x sd:attribu teGroup na me="column "> | |||||
259 | <xsd :attribute name="nam e" type="x sd:string" use="requ ired" /> | |||||
260 | <xsd :attribute name="typ e" type="x sd:string" /> | |||||
261 | <xsd :attribute name="val ue" type=" xsd:string " /> | |||||
262 | <xsd :attribute name="val ueNumeric" type="xsd :string" / > | |||||
263 | <xsd :attribute name="val ueBoolean" type="xsd :string" / > | |||||
264 | <xsd :attribute name="val ueDate" ty pe="xsd:st ring" /> | |||||
265 | <xsd :attribute name="val ueComputed " type="xs d:string" /> | |||||
266 | <xsd :attribute name="def aultValue" type="xsd :string" / > | |||||
267 | <xsd :attribute name="def aultValueN umeric" ty pe="xsd:st ring" /> | |||||
268 | <xsd :attribute name="def aultValueD ate" type= "xsd:strin g" /> | |||||
269 | <xsd :attribute name="def aultValueB oolean" ty pe="boolea nExp" /> | |||||
270 | <xsd :attribute name="def aultValueC omputed" t ype="xsd:s tring" /> | |||||
271 | <xsd :attribute name="aut oIncrement " type="bo oleanExp" /> | |||||
272 | <xsd :attribute name="sta rtWith" ty pe="xsd:lo ng" /> | |||||
273 | <xsd :attribute name="inc rementBy" type="xsd: long" /> | |||||
274 | <xsd :attribute name="rem arks" type ="xsd:stri ng" /> | |||||
275 | </ xsd:attrib uteGroup> | |||||
276 | ||||||
277 | <x sd:attribu teGroup na me="dropTa bleAttribu tes"> | |||||
278 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
279 | <xsd :attribute name="tab leName" ty pe="xsd:st ring" use= "required" /> | |||||
280 | <xsd :attribute name="cas cadeConstr aints" typ e="boolean Exp" /> | |||||
281 | </ xsd:attrib uteGroup> | |||||
282 | ||||||
283 | <x sd:attribu teGroup na me="rename TableAttri butes"> | |||||
284 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
285 | <xsd :attribute name="old TableName" type="xsd :string" | |||||
286 | use="r equired" / > | |||||
287 | <xsd :attribute name="new TableName" type="xsd :string" | |||||
288 | use="r equired" / > | |||||
289 | </ xsd:attrib uteGroup> | |||||
290 | ||||||
291 | <x sd:attribu teGroup na me="rename ViewAttrib utes"> | |||||
292 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
293 | <xsd :attribute name="old ViewName" type="xsd: string" us e="require d" /> | |||||
294 | <xsd :attribute name="new ViewName" type="xsd: string" us e="require d" /> | |||||
295 | </ xsd:attrib uteGroup> | |||||
296 | ||||||
297 | <x sd:attribu teGroup na me="tableN ameAttribu te"> | |||||
298 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
299 | <xsd :attribute name="tab leName" ty pe="xsd:st ring" use= "required" /> | |||||
300 | </ xsd:attrib uteGroup> | |||||
301 | ||||||
302 | <x sd:attribu teGroup na me="rename ColumnAttr ibutes"> | |||||
303 | <xsd :attribute Group ref= "tableName Attribute" /> | |||||
304 | <xsd :attribute name="old ColumnName " type="xs d:string" | |||||
305 | use="r equired" / > | |||||
306 | <xsd :attribute name="new ColumnName " type="xs d:string" | |||||
307 | use="r equired" / > | |||||
308 | <xsd :attribute name="col umnDataTyp e" type="x sd:string" /> | |||||
309 | </ xsd:attrib uteGroup> | |||||
310 | ||||||
311 | <x sd:attribu teGroup na me="dropCo lumnAttrib utes"> | |||||
312 | <xsd :attribute Group ref= "tableName Attribute" /> | |||||
313 | <xsd :attribute name="col umnName" t ype="xsd:s tring" use ="required " /> | |||||
314 | </ xsd:attrib uteGroup> | |||||
315 | ||||||
316 | <x sd:attribu teGroup na me="sequen ceAttribut es"> | |||||
317 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
318 | <xsd :attribute name="seq uenceName" type="xsd :string" | |||||
319 | use="r equired" / > | |||||
320 | <xsd :attribute name="sta rtValue" t ype="xsd:s tring" /> | |||||
321 | <xsd :attribute name="inc rementBy" type="xsd: string" /> | |||||
322 | <xsd :attribute name="max Value" typ e="xsd:str ing" /> | |||||
323 | <xsd :attribute name="min Value" typ e="xsd:str ing" /> | |||||
324 | <xsd :attribute name="ord ered" type ="booleanE xp" /> | |||||
325 | </ xsd:attrib uteGroup> | |||||
326 | ||||||
327 | <x sd:attribu teGroup na me="indexN ame"> | |||||
328 | <xsd :attribute name="ind exName" ty pe="xsd:st ring" use= "required" /> | |||||
329 | </ xsd:attrib uteGroup> | |||||
330 | ||||||
331 | <x sd:attribu teGroup na me="create Index"> | |||||
332 | <xsd :attribute Group ref= "tableName Attribute" /> | |||||
333 | <xsd :attribute Group ref= "indexName " /> | |||||
334 | <xsd :attribute name="ass ociatedWit h" type="x sd:string" use="opti onal" /> | |||||
335 | <xsd :attribute name="uni que" type= "booleanEx p" /> | |||||
336 | <x sd:attribu te name="t ablespace" type="xsd :string" / > | |||||
337 | </ xsd:attrib uteGroup> | |||||
338 | ||||||
339 | ||||||
340 | <x sd:element name="add PrimaryKey "> | |||||
341 | <xsd :complexTy pe> | |||||
342 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
343 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
344 | <xsd:a ttribute n ame="colum nNames" ty pe="xsd:st ring" | |||||
345 | use="req uired" /> | |||||
346 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
347 | <xsd:a ttribute n ame="table space" typ e="xsd:str ing" /> | |||||
348 | </xs d:complexT ype> | |||||
349 | </ xsd:elemen t> | |||||
350 | ||||||
351 | <x sd:element name="dro pPrimaryKe y"> | |||||
352 | <xsd :complexTy pe> | |||||
353 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
354 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
355 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
356 | </xs d:complexT ype> | |||||
357 | </ xsd:elemen t> | |||||
358 | ||||||
359 | <x sd:element name="add UniqueCons traint"> | |||||
360 | <xsd :complexTy pe> | |||||
361 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
362 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
363 | <xsd:a ttribute n ame="colum nNames" ty pe="xsd:st ring" | |||||
364 | use="req uired" /> | |||||
365 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
366 | <xsd:a ttribute n ame="table space" typ e="xsd:str ing" /> | |||||
367 | <xsd:a ttribute n ame="disab led" type= "booleanEx p" /> | |||||
368 | <xsd:a ttribute n ame="defer rable" typ e="boolean Exp" /> | |||||
369 | <xsd:a ttribute n ame="initi allyDeferr ed" type=" booleanExp " /> | |||||
370 | </xs d:complexT ype> | |||||
371 | </ xsd:elemen t> | |||||
372 | ||||||
373 | <x sd:element name="dro pUniqueCon straint"> | |||||
374 | <xsd :complexTy pe> | |||||
375 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
376 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
377 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
378 | <xsd:a ttribute n ame="uniqu eColumns" type="xsd: string" /> | |||||
379 | </xs d:complexT ype> | |||||
380 | </ xsd:elemen t> | |||||
381 | ||||||
382 | <x sd:element name="mod ifyDataTyp e"> | |||||
383 | <xsd :complexTy pe> | |||||
384 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
385 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
386 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
387 | <xsd:a ttribute n ame="newDa taType" ty pe="xsd:st ring" use= "required" /> | |||||
388 | </xs d:complexT ype> | |||||
389 | </ xsd:elemen t> | |||||
390 | ||||||
391 | <x sd:element name="add LookupTabl e"> | |||||
392 | <xsd :complexTy pe> | |||||
393 | <xsd:a ttribute n ame="exist ingTableSc hemaName" type="xsd: string" /> | |||||
394 | <xsd:a ttribute n ame="exist ingTableNa me" type=" xsd:string " | |||||
395 | use="req uired" /> | |||||
396 | <xsd:a ttribute n ame="exist ingColumnN ame" type= "xsd:strin g" | |||||
397 | use="req uired" /> | |||||
398 | <xsd:a ttribute n ame="newTa bleSchemaN ame" type= "xsd:strin g" /> | |||||
399 | <xsd:a ttribute n ame="newTa bleName" t ype="xsd:s tring" | |||||
400 | use="req uired" /> | |||||
401 | <xsd:a ttribute n ame="newCo lumnName" type="xsd: string" | |||||
402 | use="req uired" /> | |||||
403 | <xsd:a ttribute n ame="newCo lumnDataTy pe" type=" xsd:string " /> | |||||
404 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
405 | </xs d:complexT ype> | |||||
406 | </ xsd:elemen t> | |||||
407 | ||||||
408 | <x sd:element name="add AutoIncrem ent"> | |||||
409 | <xsd :complexTy pe> | |||||
410 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
411 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
412 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
413 | <xsd:a ttribute n ame="colum nDataType" type="xsd :string" / > | |||||
414 | <xsd:a ttribute n ame="start With" type ="xsd:long " /> | |||||
415 | <xsd:a ttribute n ame="incre mentBy" ty pe="xsd:lo ng" /> | |||||
416 | </xs d:complexT ype> | |||||
417 | </ xsd:elemen t> | |||||
418 | ||||||
419 | <x sd:element name="add DefaultVal ue"> | |||||
420 | <xsd :complexTy pe> | |||||
421 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
422 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
423 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
424 | <xsd:a ttribute n ame="colum nDataType" type="xsd :string" / > | |||||
425 | <xsd:a ttribute n ame="defau ltValue" t ype="xsd:s tring" /> | |||||
426 | <xsd:a ttribute n ame="defau ltValueNum eric" type ="xsd:stri ng" /> | |||||
427 | <xsd:a ttribute n ame="defau ltValueDat e" type="x sd:string" /> | |||||
428 | <xsd:a ttribute n ame="defau ltValueBoo lean" type ="xsd:stri ng" /> | |||||
429 | <xsd:a ttribute n ame="defau ltValueCom puted" typ e="xsd:str ing" /> | |||||
430 | </xs d:complexT ype> | |||||
431 | </ xsd:elemen t> | |||||
432 | ||||||
433 | <x sd:element name="dro pDefaultVa lue"> | |||||
434 | <xsd :complexTy pe> | |||||
435 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
436 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
437 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
438 | <xsd:a ttribute n ame="colum nDataType" type="xsd :string" / > | |||||
439 | </xs d:complexT ype> | |||||
440 | </ xsd:elemen t> | |||||
441 | ||||||
442 | <x sd:element name="loa dData"> | |||||
443 | <xsd :complexTy pe mixed=" true"> | |||||
444 | <xsd:s equence> | |||||
445 | <xsd:ele ment name= "column" m inOccurs=" 0" maxOccu rs="unboun ded"> | |||||
446 | <xsd:compl exType> | |||||
447 | <x sd:attribu te name="i ndex" type ="integerE xp" /> | |||||
448 | <x sd:attribu te name="h eader" typ e="xsd:str ing" /> | |||||
449 | <x sd:attribu te name="n ame" type= "xsd:strin g" /> | |||||
450 | <x sd:attribu te name="t ype" type= "xsd:strin g" /> | |||||
451 | <x sd:attribu te name="d efaultValu e" type="x sd:string" /> | |||||
452 | <x sd:attribu te name="d efaultValu eNumeric" type="xsd: string" /> | |||||
453 | <x sd:attribu te name="d efaultValu eDate" typ e="xsd:str ing" /> | |||||
454 | <x sd:attribu te name="d efaultValu eBoolean" type="bool eanExp" /> | |||||
455 | <x sd:attribu te name="d efaultValu eComputed" type="xsd :string" / > | |||||
456 | </xsd:comp lexType> | |||||
457 | </xsd:el ement> | |||||
458 | </xsd: sequence> | |||||
459 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
460 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
461 | <xsd:a ttribute n ame="file" type="xsd :string" / > | |||||
462 | <xsd:a ttribute n ame="encod ing" type= "xsd:strin g" default ="UTF-8"/> | |||||
463 | <xsd:a ttribute n ame="separ ator" type ="xsd:stri ng" defaul t=","/> | |||||
464 | <xsd:a ttribute n ame="quotc har" type= "xsd:strin g" default ="""/ > | |||||
465 | </xs d:complexT ype> | |||||
466 | </ xsd:elemen t> | |||||
467 | ||||||
468 | <x sd:element name="loa dUpdateDat a"> | |||||
469 | <xsd :complexTy pe mixed=" true"> | |||||
470 | <xsd:s equence> | |||||
471 | <xsd:ele ment name= "column" m inOccurs=" 0" maxOccu rs="unboun ded"> | |||||
472 | <xsd:compl exType> | |||||
473 | <x sd:attribu te name="i ndex" type ="integerE xp" /> | |||||
474 | <x sd:attribu te name="h eader" typ e="xsd:str ing" /> | |||||
475 | <x sd:attribu te name="n ame" type= "xsd:strin g" /> | |||||
476 | <x sd:attribu te name="t ype" type= "xsd:strin g" /> | |||||
477 | <x sd:attribu te name="d efaultValu e" type="x sd:string" /> | |||||
478 | <x sd:attribu te name="d efaultValu eNumeric" type="xsd: string" /> | |||||
479 | <x sd:attribu te name="d efaultValu eDate" typ e="xsd:str ing" /> | |||||
480 | <x sd:attribu te name="d efaultValu eBoolean" type="bool eanExp" /> | |||||
481 | <x sd:attribu te name="d efaultValu eComputed" type="xsd :string" / > | |||||
482 | </xsd:comp lexType> | |||||
483 | </xsd:el ement> | |||||
484 | </xsd: sequence> | |||||
485 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
486 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
487 | <xsd:a ttribute n ame="file" type="xsd :string" / > | |||||
488 | <xsd:a ttribute n ame="encod ing" type= "xsd:strin g" default ="UTF-8"/> | |||||
489 | <xsd:a ttribute n ame="prima ryKey" typ e="xsd:str ing" use=" required" /> | |||||
490 | <xsd:a ttribute n ame="separ ator" type ="xsd:stri ng" defaul t=","/> | |||||
491 | <xsd:a ttribute n ame="quotc har" type= "xsd:strin g" default ="""/ > | |||||
492 | </xs d:complexT ype> | |||||
493 | </ xsd:elemen t> | |||||
494 | ||||||
495 | <x sd:simpleT ype name=" fkCascadeA ctionOptio ns"> | |||||
496 | <xsd :restricti on base="x sd:token"> | |||||
497 | <xsd:e numeration value="CA SCADE"></x sd:enumera tion> | |||||
498 | <xsd:e numeration value="SE T NULL"></ xsd:enumer ation> | |||||
499 | <xsd:e numeration value="SE T DEFAULT" ></xsd:enu meration> | |||||
500 | <xsd:e numeration value="RE STRICT"></ xsd:enumer ation> | |||||
501 | <xsd:e numeration value="NO ACTION">< /xsd:enume ration> | |||||
502 | </xs d:restrict ion> | |||||
503 | </ xsd:simple Type> | |||||
504 | ||||||
505 | <x sd:attribu teGroup na me="addFor eignKeyCon straintAtt rib"> | |||||
506 | <xsd :attribute name="bas eTableSche maName" ty pe="xsd:st ring" /> | |||||
507 | <xsd :attribute name="bas eTableName " type="xs d:string" | |||||
508 | use="r equired" / > | |||||
509 | <xsd :attribute name="bas eColumnNam es" type=" xsd:string " | |||||
510 | use="r equired" / > | |||||
511 | <xsd :attribute name="con straintNam e" type="x sd:string" | |||||
512 | use="r equired" / > | |||||
513 | <xsd :attribute name="ref erencedTab leSchemaNa me" type=" xsd:string " /> | |||||
514 | <xsd :attribute name="ref erencedTab leName" ty pe="xsd:st ring" | |||||
515 | use="r equired" / > | |||||
516 | <xsd :attribute name="ref erencedCol umnNames" type="xsd: string" | |||||
517 | use="r equired" / > | |||||
518 | <xsd :attribute name="def errable" t ype="boole anExp" /> | |||||
519 | <xsd :attribute name="ini tiallyDefe rred" type ="booleanE xp" /> | |||||
520 | <xsd :attribute name="del eteCascade " type="bo oleanExp" /> | |||||
521 | <xsd :attribute name="onD elete" typ e="fkCasca deActionOp tions" /> | |||||
522 | <xsd :attribute name="onU pdate" typ e="fkCasca deActionOp tions" /> | |||||
523 | <xsd :attribute name="ref erencesUni queColumn" type="boo leanExp" / > | |||||
524 | </ xsd:attrib uteGroup> | |||||
525 | ||||||
526 | <x sd:attribu teGroup na me="addNot NullConstr aintAttrib "> | |||||
527 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
528 | <xsd :attribute name="tab leName" ty pe="xsd:st ring" use= "required" /> | |||||
529 | <xsd :attribute name="col umnName" t ype="xsd:s tring" use ="required " /> | |||||
530 | <xsd :attribute name="def aultNullVa lue" type= "xsd:strin g" /> | |||||
531 | <xsd :attribute name="col umnDataTyp e" type="x sd:string" /> | |||||
532 | </ xsd:attrib uteGroup> | |||||
533 | ||||||
534 | ||||||
535 | <x sd:element name="add NotNullCon straint"> | |||||
536 | <xsd :complexTy pe> | |||||
537 | <xsd:a ttributeGr oup ref="a ddNotNullC onstraintA ttrib" /> | |||||
538 | </xs d:complexT ype> | |||||
539 | </ xsd:elemen t> | |||||
540 | ||||||
541 | <x sd:element name="add ForeignKey Constraint "> | |||||
542 | <xsd :complexTy pe> | |||||
543 | <xsd:a ttributeGr oup ref="a ddForeignK eyConstrai ntAttrib" /> | |||||
544 | </xs d:complexT ype> | |||||
545 | </ xsd:elemen t> | |||||
546 | ||||||
547 | <x sd:attribu teGroup na me="dbmsAt trib"> | |||||
548 | <xsd :attribute name="typ e" type="x sd:string" use="requ ired" /> | |||||
549 | </ xsd:attrib uteGroup> | |||||
550 | ||||||
551 | <x sd:element name="dbm s"> | |||||
552 | <xsd :complexTy pe> | |||||
553 | <xsd:a ttributeGr oup ref="d bmsAttrib" /> | |||||
554 | </xs d:complexT ype> | |||||
555 | </ xsd:elemen t> | |||||
556 | ||||||
557 | <x sd:element name="cha ngeSetExec uted"> | |||||
558 | <xsd :complexTy pe> | |||||
559 | <xsd:a ttribute n ame="id" t ype="xsd:s tring" use ="required " /> | |||||
560 | <xsd:a ttribute n ame="autho r" type="x sd:string" use="requ ired" /> | |||||
561 | <xsd:a ttribute n ame="chang eLogFile" type="xsd: string" | |||||
562 | use="req uired" /> | |||||
563 | </xs d:complexT ype> | |||||
564 | </ xsd:elemen t> | |||||
565 | ||||||
566 | <x sd:element name="tab leExists"> | |||||
567 | <xsd :complexTy pe> | |||||
568 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
569 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
570 | </xs d:complexT ype> | |||||
571 | </ xsd:elemen t> | |||||
572 | ||||||
573 | <x sd:element name="col umnExists" > | |||||
574 | <xsd :complexTy pe> | |||||
575 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
576 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
577 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
578 | </xs d:complexT ype> | |||||
579 | </ xsd:elemen t> | |||||
580 | ||||||
581 | <x sd:element name="seq uenceExist s"> | |||||
582 | <xsd :complexTy pe> | |||||
583 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
584 | <xsd:a ttribute n ame="seque nceName" t ype="xsd:s tring" | |||||
585 | use="req uired" /> | |||||
586 | </xs d:complexT ype> | |||||
587 | </ xsd:elemen t> | |||||
588 | ||||||
589 | <x sd:element name="for eignKeyCon straintExi sts"> | |||||
590 | <xsd :complexTy pe> | |||||
591 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
592 | <xsd:a ttribute n ame="forei gnKeyTable Name" type ="xsd:stri ng" /> | |||||
593 | <xsd:a ttribute n ame="forei gnKeyName" type="xsd :string" | |||||
594 | use="req uired" /> | |||||
595 | </xs d:complexT ype> | |||||
596 | </ xsd:elemen t> | |||||
597 | ||||||
598 | <x sd:element name="ind exExists"> | |||||
599 | <xsd :complexTy pe> | |||||
600 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
601 | <xsd:a ttribute n ame="index Name" type ="xsd:stri ng"/> | |||||
602 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " /> | |||||
603 | <xsd:att ribute nam e="columnN ames" type ="xsd:stri ng" /> | |||||
604 | </xs d:complexT ype> | |||||
605 | </ xsd:elemen t> | |||||
606 | ||||||
607 | <x sd:element name="cha ngeLogProp ertyDefine d"> | |||||
608 | <xsd :complexTy pe> | |||||
609 | <xsd:a ttribute n ame="prope rty" type= "xsd:strin g" use="re quired" /> | |||||
610 | <xsd:a ttribute n ame="value " type="xs d:string" /> | |||||
611 | </xs d:complexT ype> | |||||
612 | </ xsd:elemen t> | |||||
613 | ||||||
614 | <x sd:element name="pri maryKeyExi sts"> | |||||
615 | <xsd :complexTy pe> | |||||
616 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
617 | <xsd:a ttribute n ame="prima ryKeyName" type="xsd :string" / > | |||||
618 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" /> | |||||
619 | </xs d:complexT ype> | |||||
620 | </ xsd:elemen t> | |||||
621 | ||||||
622 | <x sd:element name="vie wExists"> | |||||
623 | <xsd :complexTy pe> | |||||
624 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
625 | <xsd:a ttribute n ame="viewN ame" type= "xsd:strin g" use="re quired" /> | |||||
626 | </xs d:complexT ype> | |||||
627 | </ xsd:elemen t> | |||||
628 | ||||||
629 | <x sd:element name="sql Check"> | |||||
630 | <xsd :complexTy pe mixed=" true"> | |||||
631 | <xsd:a ttribute n ame="expec tedResult" type="xsd :string" | |||||
632 | use="req uired" /> | |||||
633 | </xs d:complexT ype> | |||||
634 | </ xsd:elemen t> | |||||
635 | ||||||
636 | <x sd:element name="cus tomPrecond ition"> | |||||
637 | <xsd :complexTy pe> | |||||
638 | <xsd:s equence> | |||||
639 | <xsd:ele ment name= "param" mi nOccurs="0 " maxOccur s="unbound ed"> | |||||
640 | <xsd:compl exType> | |||||
641 | <x sd:attribu te name="n ame" type= "xsd:strin g" use="re quired" /> | |||||
642 | <x sd:attribu te name="v alue" type ="xsd:stri ng" use="r equired" / > | |||||
643 | </xsd:comp lexType> | |||||
644 | </xsd:el ement> | |||||
645 | </xsd: sequence> | |||||
646 | <xsd:a ttribute n ame="class Name" type ="xsd:stri ng" use="r equired" / > | |||||
647 | </xs d:complexT ype> | |||||
648 | </ xsd:elemen t> | |||||
649 | ||||||
650 | <x sd:element name="and "> | |||||
651 | <xsd :complexTy pe> | |||||
652 | <xsd:c hoice> | |||||
653 | <xsd:gro up ref="Pr eCondition Children" minOccurs= "1" | |||||
654 | maxOccurs= "unbounded " /> | |||||
655 | </xsd: choice> | |||||
656 | </xs d:complexT ype> | |||||
657 | </ xsd:elemen t> | |||||
658 | ||||||
659 | <x sd:element name="or" > | |||||
660 | <xsd :complexTy pe> | |||||
661 | <xsd:c hoice> | |||||
662 | <xsd:gro up ref="Pr eCondition Children" minOccurs= "1" | |||||
663 | maxOccurs= "unbounded " /> | |||||
664 | </xsd: choice> | |||||
665 | </xs d:complexT ype> | |||||
666 | </ xsd:elemen t> | |||||
667 | ||||||
668 | <x sd:element name="not "> | |||||
669 | <xsd :complexTy pe> | |||||
670 | <xsd:c hoice> | |||||
671 | <xsd:gro up ref="Pr eCondition Children" minOccurs= "1" | |||||
672 | maxOccurs= "unbounded " /> | |||||
673 | </xsd: choice> | |||||
674 | </xs d:complexT ype> | |||||
675 | </ xsd:elemen t> | |||||
676 | ||||||
677 | <x sd:attribu teGroup na me="runnin gAsAttrib" > | |||||
678 | <xsd :attribute name="use rname" typ e="xsd:str ing" use=" required" /> | |||||
679 | </ xsd:attrib uteGroup> | |||||
680 | ||||||
681 | <x sd:element name="run ningAs"> | |||||
682 | <xsd :complexTy pe> | |||||
683 | <xsd:a ttributeGr oup ref="r unningAsAt trib" /> | |||||
684 | </xs d:complexT ype> | |||||
685 | </ xsd:elemen t> | |||||
686 | ||||||
687 | <x sd:attribu teGroup na me="dropFo reignKeyCo nstraintAt trib"> | |||||
688 | <xsd :attribute name="bas eTableSche maName" ty pe="xsd:st ring" /> | |||||
689 | <xsd :attribute name="bas eTableName " type="xs d:string" | |||||
690 | use="r equired" / > | |||||
691 | <xsd :attribute name="con straintNam e" type="x sd:string" /> | |||||
692 | </ xsd:attrib uteGroup> | |||||
693 | ||||||
694 | <x sd:element name="dro pForeignKe yConstrain t"> | |||||
695 | <xsd :complexTy pe> | |||||
696 | <xsd:a ttributeGr oup ref="d ropForeign KeyConstra intAttrib" /> | |||||
697 | </xs d:complexT ype> | |||||
698 | </ xsd:elemen t> | |||||
699 | ||||||
700 | <x sd:attribu teGroup na me="dropAl lForeignKe yConstrain tsAttrib"> | |||||
701 | <xsd :attribute name="bas eTableSche maName" ty pe="xsd:st ring" /> | |||||
702 | <xsd :attribute name="bas eTableName " type="xs d:string" | |||||
703 | use="r equired" / > | |||||
704 | </ xsd:attrib uteGroup> | |||||
705 | ||||||
706 | <x sd:element name="dro pAllForeig nKeyConstr aints"> | |||||
707 | <xsd :complexTy pe> | |||||
708 | <xsd:a ttributeGr oup ref="d ropAllFore ignKeyCons traintsAtt rib" /> | |||||
709 | </xs d:complexT ype> | |||||
710 | </ xsd:elemen t> | |||||
711 | ||||||
712 | <x sd:element name="dro pNotNullCo nstraint"> | |||||
713 | <xsd :complexTy pe> | |||||
714 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
715 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
716 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
717 | <xsd:a ttribute n ame="colum nDataType" type="xsd :string" / > | |||||
718 | </xs d:complexT ype> | |||||
719 | </ xsd:elemen t> | |||||
720 | ||||||
721 | ||||||
722 | <x sd:element name="con straints"> | |||||
723 | <xsd :complexTy pe> | |||||
724 | <xsd:a ttributeGr oup ref="c onstraints Attributes " /> | |||||
725 | </xs d:complexT ype> | |||||
726 | </ xsd:elemen t> | |||||
727 | ||||||
728 | ||||||
729 | <x sd:element name="col umn"> | |||||
730 | <xsd :complexTy pe mixed=" true"> | |||||
731 | <xsd:s equence> | |||||
732 | <xsd:ele ment ref=" constraint s" minOccu rs="0" /> | |||||
733 | </xsd: sequence> | |||||
734 | <xsd:a ttributeGr oup ref="c olumn" /> | |||||
735 | </xs d:complexT ype> | |||||
736 | </ xsd:elemen t> | |||||
737 | ||||||
738 | <! -- Childre n for crea teTable -- > | |||||
739 | <x sd:element name="cre ateTable"> | |||||
740 | <xsd :complexTy pe> | |||||
741 | <xsd:s equence> | |||||
742 | <xsd:ele ment ref=" column" mi nOccurs="1 " maxOccur s="unbound ed" /> | |||||
743 | </xsd: sequence> | |||||
744 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
745 | <xsd:att ribute nam e="tablesp ace" type= "xsd:strin g" /> | |||||
746 | <xsd:a ttribute n ame="remar ks" type=" xsd:string " /> | |||||
747 | </xs d:complexT ype> | |||||
748 | </ xsd:elemen t> | |||||
749 | ||||||
750 | <! -- Childre n for crea teView --> | |||||
751 | <x sd:element name="cre ateView"> | |||||
752 | <xsd :complexTy pe> | |||||
753 | <xsd:s impleConte nt> | |||||
754 | <xsd:ext ension bas e="xsd:str ing"> | |||||
755 | <xsd:attri bute name= "schemaNam e" type="x sd:string" /> | |||||
756 | <xsd:attri bute name= "viewName" type="xsd :string" u se="requir ed" /> | |||||
757 | <xsd:attri bute name= "replaceIf Exists" ty pe="boolea nExp" /> | |||||
758 | </xsd:ex tension> | |||||
759 | </xsd: simpleCont ent> | |||||
760 | </xs d:complexT ype> | |||||
761 | </ xsd:elemen t> | |||||
762 | ||||||
763 | <! -- Childre n for inse rt --> | |||||
764 | <x sd:element name="ins ert"> | |||||
765 | <xsd :complexTy pe> | |||||
766 | <xsd:s equence> | |||||
767 | <xsd:ele ment ref=" column" ma xOccurs="u nbounded" /> | |||||
768 | </xsd: sequence> | |||||
769 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
770 | </xs d:complexT ype> | |||||
771 | </ xsd:elemen t> | |||||
772 | ||||||
773 | <x sd:element name="upd ate"> | |||||
774 | <xsd :complexTy pe mixed=" true"> | |||||
775 | <xsd:s equence> | |||||
776 | <xsd:ele ment ref=" column" mi nOccurs="1 " maxOccur s="unbound ed" /> | |||||
777 | <xsd:ele ment name= "where" mi nOccurs="0 " maxOccur s="1" /> | |||||
778 | </xsd: sequence> | |||||
779 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
780 | </xs d:complexT ype> | |||||
781 | </ xsd:elemen t> | |||||
782 | ||||||
783 | <x sd:element name="del ete"> | |||||
784 | <xsd :complexTy pe mixed=" true"> | |||||
785 | <xsd:s equence> | |||||
786 | <xsd:ele ment name= "where" mi nOccurs="0 " maxOccur s="1" /> | |||||
787 | </xsd: sequence> | |||||
788 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
789 | </xs d:complexT ype> | |||||
790 | </ xsd:elemen t> | |||||
791 | ||||||
792 | <! -- Childre n for addC olum --> | |||||
793 | <x sd:element name="add Column"> | |||||
794 | <xsd :complexTy pe> | |||||
795 | <xsd:s equence> | |||||
796 | <xsd:ele ment ref=" column" mi nOccurs="1 " maxOccur s="unbound ed" /> | |||||
797 | </xsd: sequence> | |||||
798 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
799 | </xs d:complexT ype> | |||||
800 | </ xsd:elemen t> | |||||
801 | ||||||
802 | <x sd:element name="rol lback"> | |||||
803 | <xsd :complexTy pe mixed=" true"> | |||||
804 | <xsd:c hoice> | |||||
805 | <xsd:gro up ref="ch angeSetChi ldren" min Occurs="0" | |||||
806 | maxOccurs= "unbounded " /> | |||||
807 | </xsd: choice> | |||||
808 | <xsd:a ttribute n ame="chang eSetPath" type="xsd: string" /> | |||||
809 | <xsd:a ttribute n ame="chang eSetAuthor " type="xs d:string" /> | |||||
810 | <xsd:a ttribute n ame="chang eSetId" ty pe="xsd:st ring" /> | |||||
811 | </xs d:complexT ype> | |||||
812 | </ xsd:elemen t> | |||||
813 | ||||||
814 | <! -- comment --> | |||||
815 | <x sd:element name="com ment" type ="xsd:stri ng" /> | |||||
816 | ||||||
817 | <! -- sql --> | |||||
818 | <x sd:element name="sql "> | |||||
819 | <xsd :complexTy pe mixed=" true"> | |||||
820 | <xsd:s equence> | |||||
821 | <xsd:ele ment ref=" comment" m inOccurs=" 0" maxOccu rs="1" /> | |||||
822 | </xsd: sequence> | |||||
823 | <xsd:a ttribute n ame="strip Comments" type="bool eanExp" /> | |||||
824 | <xsd:a ttribute n ame="split Statements " type="bo oleanExp" /> | |||||
825 | <xsd:a ttribute n ame="endDe limiter" t ype="xsd:s tring" /> | |||||
826 | </xs d:complexT ype> | |||||
827 | </ xsd:elemen t> | |||||
828 | ||||||
829 | <x sd:element name="cre ateProcedu re"> | |||||
830 | <xsd :complexTy pe mixed=" true"> | |||||
831 | <xsd:s equence> | |||||
832 | <xsd:ele ment ref=" comment" m inOccurs=" 0" maxOccu rs="1" /> | |||||
833 | </xsd: sequence> | |||||
834 | </xs d:complexT ype> | |||||
835 | </ xsd:elemen t> | |||||
836 | ||||||
837 | <x sd:element name="exe cuteComman d"> | |||||
838 | <xsd :complexTy pe> | |||||
839 | <xsd:s equence> | |||||
840 | <xsd:ele ment name= "arg" minO ccurs="0" maxOccurs= "unbounded "> | |||||
841 | <xsd:compl exType> | |||||
842 | <x sd:attribu te name="v alue" type ="xsd:stri ng" use="r equired" / > | |||||
843 | </xsd:comp lexType> | |||||
844 | </xsd:el ement> | |||||
845 | </xsd: sequence> | |||||
846 | <xsd:a ttribute n ame="execu table" typ e="xsd:str ing" use=" required" /> | |||||
847 | <xsd:a ttribute n ame="os" t ype="xsd:s tring" /> | |||||
848 | </xs d:complexT ype> | |||||
849 | </ xsd:elemen t> | |||||
850 | ||||||
851 | <x sd:element name="sql File"> | |||||
852 | <xsd :complexTy pe> | |||||
853 | <xsd:a ttribute n ame="path" type="xsd :string" u se="requir ed" /> | |||||
854 | <xsd:a ttribute n ame="strip Comments" type="bool eanExp" /> | |||||
855 | <xsd:a ttribute n ame="split Statements " type="bo oleanExp" /> | |||||
856 | <xsd:a ttribute n ame="encod ing" type= "xsd:strin g" default ="UTF-8"/> | |||||
857 | <xsd:a ttribute n ame="endDe limiter" t ype="xsd:s tring" /> | |||||
858 | <xsd:att ribute nam e="relativ eToChangel ogFile" ty pe="boolea nExp" /> | |||||
859 | </xs d:complexT ype> | |||||
860 | </ xsd:elemen t> | |||||
861 | ||||||
862 | <x sd:element name="tag Database"> | |||||
863 | <xsd :complexTy pe> | |||||
864 | <xsd:a ttribute n ame="tag" type="xsd: string" us e="require d" /> | |||||
865 | </xs d:complexT ype> | |||||
866 | </ xsd:elemen t> | |||||
867 | ||||||
868 | <x sd:element name="sto p"> | |||||
869 | <xsd :complexTy pe mixed=" true" /> | |||||
870 | </ xsd:elemen t> | |||||
871 | ||||||
872 | <! -- renameT able --> | |||||
873 | <x sd:element name="ren ameTable"> | |||||
874 | <xsd :complexTy pe> | |||||
875 | <xsd:a ttributeGr oup ref="r enameTable Attributes " /> | |||||
876 | </xs d:complexT ype> | |||||
877 | </ xsd:elemen t> | |||||
878 | ||||||
879 | <x sd:element name="ren ameView"> | |||||
880 | <xsd :complexTy pe> | |||||
881 | <xsd:a ttributeGr oup ref="r enameViewA ttributes" /> | |||||
882 | </xs d:complexT ype> | |||||
883 | </ xsd:elemen t> | |||||
884 | ||||||
885 | <! -- dropTab le --> | |||||
886 | <x sd:element name="dro pTable"> | |||||
887 | <xsd :complexTy pe> | |||||
888 | <xsd:a ttributeGr oup ref="d ropTableAt tributes" /> | |||||
889 | </xs d:complexT ype> | |||||
890 | </ xsd:elemen t> | |||||
891 | ||||||
892 | <x sd:element name="dro pView"> | |||||
893 | <xsd :complexTy pe> | |||||
894 | <xsd:a ttribute n ame="viewN ame" type= "xsd:strin g" use="re quired" /> | |||||
895 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
896 | </xs d:complexT ype> | |||||
897 | </ xsd:elemen t> | |||||
898 | ||||||
899 | <! -- renameC olumn --> | |||||
900 | <x sd:element name="ren ameColumn" > | |||||
901 | <xsd :complexTy pe> | |||||
902 | <xsd:a ttributeGr oup ref="r enameColum nAttribute s" /> | |||||
903 | </xs d:complexT ype> | |||||
904 | </ xsd:elemen t> | |||||
905 | ||||||
906 | <x sd:element name="dro pColumn"> | |||||
907 | <xsd :complexTy pe> | |||||
908 | <xsd:a ttributeGr oup ref="d ropColumnA ttributes" /> | |||||
909 | </xs d:complexT ype> | |||||
910 | </ xsd:elemen t> | |||||
911 | ||||||
912 | <x sd:element name="mer geColumns" > | |||||
913 | <xsd :complexTy pe> | |||||
914 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
915 | <xsd:a ttribute n ame="colum n1Name" ty pe="xsd:st ring" | |||||
916 | use="req uired" /> | |||||
917 | <xsd:a ttribute n ame="joinS tring" typ e="xsd:str ing" use=" required" /> | |||||
918 | <xsd:a ttribute n ame="colum n2Name" ty pe="xsd:st ring" | |||||
919 | use="req uired" /> | |||||
920 | <xsd:a ttribute n ame="final ColumnName " type="xs d:string" | |||||
921 | use="req uired" /> | |||||
922 | <xsd:a ttribute n ame="final ColumnType " type="xs d:string" | |||||
923 | use="req uired" /> | |||||
924 | </xs d:complexT ype> | |||||
925 | </ xsd:elemen t> | |||||
926 | ||||||
927 | <x sd:group n ame="where Clause"> | |||||
928 | <xsd :sequence> | |||||
929 | <xsd:e lement nam e="whereCl ause" type ="xsd:stri ng" | |||||
930 | minOccur s="0" maxO ccurs="unb ounded" /> | |||||
931 | </xs d:sequence > | |||||
932 | </ xsd:group> | |||||
933 | ||||||
934 | <x sd:element name="cre ateSequenc e"> | |||||
935 | <xsd :complexTy pe> | |||||
936 | <xsd:a ttributeGr oup ref="s equenceAtt ributes" / > | |||||
937 | <xsd:att ribute nam e="cycle" type="bool eanExp"> | |||||
938 | <xsd :annotatio n> | |||||
939 | <xsd:docum entation> | |||||
940 | true f or a cycli ng sequenc e, false f or a non-c ycling seq uence. | |||||
941 | Defaul t is false . | |||||
942 | </xsd:docu mentation> | |||||
943 | </xs d:annotati on> | |||||
944 | </xsd:at tribute> | |||||
945 | </xs d:complexT ype> | |||||
946 | </ xsd:elemen t> | |||||
947 | ||||||
948 | <x sd:element name="alt erSequence "> | |||||
949 | <xsd :complexTy pe> | |||||
950 | <xsd:a ttributeGr oup ref="s equenceAtt ributes" / > | |||||
951 | </xs d:complexT ype> | |||||
952 | </ xsd:elemen t> | |||||
953 | ||||||
954 | <x sd:element name="dro pSequence" > | |||||
955 | <xsd :complexTy pe> | |||||
956 | <xsd:a ttributeGr oup ref="s equenceAtt ributes" / > | |||||
957 | </xs d:complexT ype> | |||||
958 | </ xsd:elemen t> | |||||
959 | ||||||
960 | <x sd:element name="cre ateIndex"> | |||||
961 | <xsd :complexTy pe> | |||||
962 | <xsd:s equence> | |||||
963 | <xsd:ele ment ref=" column" ma xOccurs="u nbounded" /> | |||||
964 | </xsd: sequence> | |||||
965 | <xsd:a ttributeGr oup ref="c reateIndex " /> | |||||
966 | </xs d:complexT ype> | |||||
967 | </ xsd:elemen t> | |||||
968 | ||||||
969 | <x sd:element name="dro pIndex"> | |||||
970 | <xsd :complexTy pe> | |||||
971 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
972 | <xsd:a ttributeGr oup ref="i ndexName" /> | |||||
973 | <xsd:att ribute nam e="associa tedWith" t ype="xsd:s tring" use ="optional " /> | |||||
974 | </xs d:complexT ype> | |||||
975 | </ xsd:elemen t> | |||||
976 | ||||||
977 | <x sd:element name="cus tomChange" > | |||||
978 | <xsd :complexTy pe> | |||||
979 | <xsd:s equence> | |||||
980 | <xsd:ele ment name= "param" mi nOccurs="0 " maxOccur s="unbound ed"> | |||||
981 | <xsd:compl exType mix ed="true"> | |||||
982 | <x sd:attribu te name="n ame" type= "xsd:strin g" use="re quired" /> | |||||
983 | <x sd:attribu te name="v alue" type ="xsd:stri ng" /> | |||||
984 | </xsd:comp lexType> | |||||
985 | </xsd:el ement> | |||||
986 | </xsd: sequence> | |||||
987 | <xsd:a ttribute n ame="class " type="xs d:string" use="requi red" /> | |||||
988 | <xsd:a nyAttribut e processC ontents="l ax" /> | |||||
989 | </xs d:complexT ype> | |||||
990 | </ xsd:elemen t> | |||||
991 | ||||||
992 | ||||||
993 | <! -- Childre n for chan geSet --> | |||||
994 | <x sd:group n ame="chang eSetChildr en"> | |||||
995 | <xsd :choice> | |||||
996 | <xsd:e lement ref ="comment" maxOccurs ="1" /> | |||||
997 | <xsd:e lement ref ="createTa ble" maxOc curs="unbo unded" /> | |||||
998 | <xsd:e lement ref ="dropTabl e" maxOccu rs="unboun ded" /> | |||||
999 | <xsd:e lement ref ="createVi ew" maxOcc urs="unbou nded" /> | |||||
1000 | <xsd:e lement ref ="renameVi ew" maxOcc urs="unbou nded" /> | |||||
1001 | <xsd:e lement ref ="dropView " maxOccur s="unbound ed" /> | |||||
1002 | <xsd:e lement ref ="insert" maxOccurs= "unbounded " /> | |||||
1003 | <xsd:e lement ref ="addColum n" maxOccu rs="unboun ded" /> | |||||
1004 | <xsd:e lement ref ="sql" max Occurs="un bounded" / > | |||||
1005 | <xsd:e lement ref ="createPr ocedure" m axOccurs=" unbounded" /> | |||||
1006 | <xsd:e lement ref ="sqlFile" maxOccurs ="unbounde d" /> | |||||
1007 | <xsd:e lement ref ="renameTa ble" maxOc curs="unbo unded" /> | |||||
1008 | <xsd:e lement ref ="renameCo lumn" maxO ccurs="unb ounded" /> | |||||
1009 | <xsd:e lement ref ="dropColu mn" maxOcc urs="unbou nded" /> | |||||
1010 | <xsd:e lement ref ="mergeCol umns" maxO ccurs="unb ounded" /> | |||||
1011 | <xsd:e lement ref ="modifyDa taType" ma xOccurs="u nbounded" /> | |||||
1012 | <xsd:e lement ref ="createSe quence" ma xOccurs="u nbounded" /> | |||||
1013 | <xsd:e lement ref ="alterSeq uence" max Occurs="un bounded" / > | |||||
1014 | <xsd:e lement ref ="dropSequ ence" maxO ccurs="unb ounded" /> | |||||
1015 | <xsd:e lement ref ="createIn dex" maxOc curs="unbo unded" /> | |||||
1016 | <xsd:e lement ref ="dropInde x" maxOccu rs="unboun ded" /> | |||||
1017 | <xsd:e lement ref ="addNotNu llConstrai nt" maxOcc urs="unbou nded" /> | |||||
1018 | <xsd:e lement ref ="dropNotN ullConstra int" maxOc curs="unbo unded" /> | |||||
1019 | <xsd:e lement ref ="addForei gnKeyConst raint" max Occurs="un bounded" / > | |||||
1020 | <xsd:e lement ref ="dropFore ignKeyCons traint" ma xOccurs="u nbounded" /> | |||||
1021 | <xsd:e lement ref ="dropAllF oreignKeyC onstraints " | |||||
1022 | maxOccur s="unbound ed" /> | |||||
1023 | <xsd:e lement ref ="addPrima ryKey" max Occurs="un bounded" / > | |||||
1024 | <xsd:e lement ref ="dropPrim aryKey" ma xOccurs="u nbounded" /> | |||||
1025 | <xsd:e lement ref ="addLooku pTable" ma xOccurs="u nbounded" /> | |||||
1026 | <xsd:e lement ref ="addAutoI ncrement" maxOccurs= "unbounded " /> | |||||
1027 | <xsd:e lement ref ="addDefau ltValue" m axOccurs=" unbounded" /> | |||||
1028 | <xsd:e lement ref ="dropDefa ultValue" maxOccurs= "unbounded " /> | |||||
1029 | <xsd:e lement ref ="addUniqu eConstrain t" maxOccu rs="unboun ded" /> | |||||
1030 | <xsd:e lement ref ="dropUniq ueConstrai nt" maxOcc urs="unbou nded" /> | |||||
1031 | <xsd:e lement ref ="customCh ange" maxO ccurs="unb ounded" /> | |||||
1032 | <xsd:e lement ref ="update" maxOccurs= "unbounded " /> | |||||
1033 | <xsd:e lement ref ="delete" maxOccurs= "unbounded " /> | |||||
1034 | <xsd:e lement ref ="loadData " maxOccur s="unbound ed" /> | |||||
1035 | <xsd:e lement ref ="loadUpda teData" ma xOccurs="u nbounded" /> | |||||
1036 | <xsd:e lement ref ="executeC ommand" ma xOccurs="u nbounded" /> | |||||
1037 | <xsd:e lement ref ="stop" ma xOccurs="u nbounded" /> | |||||
1038 | <xsd:e lement ref ="rollback " maxOccur s="1" /> | |||||
1039 | <xsd:a ny namespa ce="##othe r" process Contents=" lax" minOc curs="0" | |||||
1040 | maxOccur s="unbound ed" /> | |||||
1041 | </xs d:choice> | |||||
1042 | </ xsd:group> | |||||
1043 | ||||||
1044 | <! -- Childre n for Prec ondition - -> | |||||
1045 | <x sd:group n ame="PreCo nditionChi ldren"> | |||||
1046 | <xsd :sequence> | |||||
1047 | <xsd:c hoice> | |||||
1048 | <xsd:ele ment ref=" and" maxOc curs="unbo unded" /> | |||||
1049 | <xsd:ele ment ref=" or" maxOcc urs="unbou nded" /> | |||||
1050 | <xsd:ele ment ref=" not" maxOc curs="unbo unded" /> | |||||
1051 | <xsd:ele ment ref=" dbms" maxO ccurs="unb ounded" /> | |||||
1052 | <xsd:ele ment ref=" runningAs" maxOccurs ="unbounde d" /> | |||||
1053 | <xsd:ele ment ref=" changeSetE xecuted" m axOccurs=" unbounded" /> | |||||
1054 | <xsd:ele ment ref=" tableExist s" maxOccu rs="unboun ded" /> | |||||
1055 | <xsd:ele ment ref=" columnExis ts" maxOcc urs="unbou nded" /> | |||||
1056 | <xsd:ele ment ref=" sequenceEx ists" maxO ccurs="unb ounded" /> | |||||
1057 | <xsd:ele ment ref=" foreignKey Constraint Exists" ma xOccurs="u nbounded" /> | |||||
1058 | <xsd:ele ment ref=" indexExist s" maxOccu rs="unboun ded" /> | |||||
1059 | <xsd:ele ment ref=" primaryKey Exists" ma xOccurs="u nbounded" /> | |||||
1060 | <xsd:ele ment ref=" viewExists " maxOccur s="unbound ed" /> | |||||
1061 | <xsd:ele ment ref=" sqlCheck" maxOccurs= "unbounded " /> | |||||
1062 | <xsd:ele ment ref=" changeLogP ropertyDef ined" maxO ccurs="unb ounded" /> | |||||
1063 | <xsd:ele ment ref=" customPrec ondition" maxOccurs= "unbounded " /> | |||||
1064 | </xsd: choice> | |||||
1065 | </xs d:sequence > | |||||
1066 | ||||||
1067 | </ xsd:group> | |||||
1068 | </xsd:sche ma> |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.