Produced by Araxis Merge on 5/10/2018 8:40:08 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:08 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-1.2.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 | 560 |
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 | targetNa mespace="h ttp://www. liquibase. org/xml/ns /dbchangel og/1.2" | |||||
5 | xmlns="h ttp://www. liquibase. org/xml/ns /dbchangel og/1.2" | |||||
6 | elementF ormDefault ="qualifie d"> | |||||
7 | ||||||
8 | <!-- T his is the main (roo t) part of the xsd - -> | |||||
9 | <xsd:e lement nam e="databas eChangeLog "> | |||||
10 | <x sd:complex Type> | |||||
11 | <xsd:seq uence minO ccurs="0" maxOccurs= "unbounded "> | |||||
12 | <xsd :choice> | |||||
13 | <xsd:eleme nt name="p reConditio ns" minOcc urs="0" ma xOccurs="1 "> | |||||
14 | <xsd:c omplexType > | |||||
15 | <x sd:choice> | |||||
16 | <xsd:gro up ref="Pr eCondition Children"/ > | |||||
17 | </ xsd:choice > | |||||
18 | </xsd: complexTyp e> | |||||
19 | </xsd:elem ent> | |||||
20 | ||||||
21 | <!-- chang eSet --> | |||||
22 | <xsd:eleme nt name="c hangeSet" minOccurs= "0" maxOcc urs="1"> | |||||
23 | <xsd:c omplexType > | |||||
24 | <x sd:choice> | |||||
25 | <xsd:gro up ref="ch angeSetChi ldren" max Occurs="un bounded"/> | |||||
26 | </ xsd:choice > | |||||
27 | <x sd:attribu teGroup re f="changeS etAttribut es"/> | |||||
28 | </xsd: complexTyp e> | |||||
29 | </xsd:elem ent> | |||||
30 | ||||||
31 | <!-- inclu de --> | |||||
32 | <xsd:eleme nt name="i nclude" mi nOccurs="0 " maxOccur s="1"> | |||||
33 | <xsd:c omplexType > | |||||
34 | <x sd:attribu te name="f ile" type= "xsd:strin g"/> | |||||
35 | </xsd: complexTyp e> | |||||
36 | </xsd:elem ent> | |||||
37 | </xs d:choice> | |||||
38 | </xsd:se quence> | |||||
39 | <xsd:att ributeGrou p ref="cha ngeLogAttr ibutes"/> | |||||
40 | </ xsd:comple xType> | |||||
41 | </xsd: element> | |||||
42 | ||||||
43 | <!-- A ttributes for Databa seInfo --> | |||||
44 | <xsd:a ttributeGr oup name=" DatabaseIn foAttribut es"> | |||||
45 | <x sd:attribu te name="t ype" type= "xsd:strin g"/> | |||||
46 | <x sd:attribu te name="v ersion" ty pe="xsd:st ring"/> | |||||
47 | <x sd:attribu te name="u sername" t ype="xsd:s tring"/> | |||||
48 | <x sd:attribu te name="p assword" t ype="xsd:s tring"/> | |||||
49 | <x sd:attribu te name="p ort" type= "xsd:integ er"/> | |||||
50 | <x sd:attribu te name="h ost" type= "xsd:strin g"/> | |||||
51 | <x sd:attribu te name="s chemaName" type="xsd :string"/> | |||||
52 | <x sd:attribu te name="d riverName" type="xsd :string"/> | |||||
53 | </xsd: attributeG roup> | |||||
54 | ||||||
55 | <!-- A ttributes for change Set --> | |||||
56 | <xsd:a ttributeGr oup name=" changeLogA ttributes" > | |||||
57 | <x sd:attribu te name="l ogicalFile Path" type ="xsd:stri ng"/> | |||||
58 | </xsd: attributeG roup> | |||||
59 | ||||||
60 | <!-- A ttributes for change Set --> | |||||
61 | <xsd:a ttributeGr oup name=" changeSetA ttributes" > | |||||
62 | <x sd:attribu te name="i d" type="x sd:string" /> | |||||
63 | <x sd:attribu te name="a uthor" typ e="xsd:str ing"/> | |||||
64 | <x sd:attribu te name="c ontext" ty pe="xsd:st ring"/> | |||||
65 | <x sd:attribu te name="d bms" type= "xsd:strin g"/> | |||||
66 | <x sd:attribu te name="r unOnChange " type="xs d:boolean" /> | |||||
67 | <x sd:attribu te name="r unAlways" type="xsd: boolean"/> | |||||
68 | </xsd: attributeG roup> | |||||
69 | ||||||
70 | <!-- A ttributes for constr aints --> | |||||
71 | <xsd:a ttributeGr oup name=" constraint sAttribute s"> | |||||
72 | <x sd:attribu te name="n ullable" t ype="xsd:b oolean"/> | |||||
73 | <x sd:attribu te name="p rimaryKey" type="xsd :boolean"/ > | |||||
74 | <x sd:attribu te name="u nique" typ e="xsd:boo lean"/> | |||||
75 | <x sd:attribu te name="r eferences" type="xsd :string"/> | |||||
76 | <x sd:attribu te name="f oreignKeyN ame" type= "xsd:strin g"/> | |||||
77 | <x sd:attribu te name="d eleteCasca de" type=" xsd:boolea n"/> | |||||
78 | <x sd:attribu te name="d eferrable" type="xsd :boolean"/ > | |||||
79 | <x sd:attribu te name="i nitiallyDe ferred" ty pe="xsd:bo olean"/> | |||||
80 | </xsd: attributeG roup> | |||||
81 | ||||||
82 | <xsd:a ttributeGr oup name=" column"> | |||||
83 | <x sd:attribu te name="n ame" type= "xsd:strin g"/> | |||||
84 | <x sd:attribu te name="t ype" type= "xsd:strin g"/> | |||||
85 | <x sd:attribu te name="v alue" type ="xsd:stri ng"/> | |||||
86 | <x sd:attribu te name="v alueNumeri c" type="x sd:string" /> | |||||
87 | <x sd:attribu te name="v alueBoolea n" type="x sd:string" /> | |||||
88 | <x sd:attribu te name="v alueDate" type="xsd: string"/> | |||||
89 | <x sd:attribu te name="d efaultValu e" type="x sd:string" /> | |||||
90 | <x sd:attribu te name="d efaultValu eNumeric" type="xsd: string"/> | |||||
91 | <x sd:attribu te name="d efaultValu eDate" typ e="xsd:str ing"/> | |||||
92 | <x sd:attribu te name="d efaultValu eBoolean" type="xsd: boolean"/> | |||||
93 | <x sd:attribu te name="a utoIncreme nt" type=" xsd:boolea n"/> | |||||
94 | </xsd: attributeG roup> | |||||
95 | ||||||
96 | <xsd:a ttributeGr oup name=" dropTableA ttributes" > | |||||
97 | <x sd:attribu te name="t ableName" type="xsd: string"/> | |||||
98 | <x sd:attribu te name="c ascadeCons traints" t ype="xsd:b oolean"/> | |||||
99 | </xsd: attributeG roup> | |||||
100 | ||||||
101 | <xsd:a ttributeGr oup name=" renameTabl eAttribute s"> | |||||
102 | <x sd:attribu te name="o ldTableNam e" type="x sd:string" /> | |||||
103 | <x sd:attribu te name="n ewTableNam e" type="x sd:string" /> | |||||
104 | </xsd: attributeG roup> | |||||
105 | ||||||
106 | <xsd:a ttributeGr oup name=" renameView Attributes "> | |||||
107 | <x sd:attribu te name="o ldViewName " type="xs d:string"/ > | |||||
108 | <x sd:attribu te name="n ewViewName " type="xs d:string"/ > | |||||
109 | </xsd: attributeG roup> | |||||
110 | ||||||
111 | <xsd:a ttributeGr oup name=" tableNameA ttribute"> | |||||
112 | <x sd:attribu te name="t ableName" type="xsd: string"/> | |||||
113 | </xsd: attributeG roup> | |||||
114 | ||||||
115 | <xsd:a ttributeGr oup name=" renameColu mnAttribut es"> | |||||
116 | <x sd:attribu teGroup re f="tableNa meAttribut e"/> | |||||
117 | <x sd:attribu te name="o ldColumnNa me" type=" xsd:string "/> | |||||
118 | <x sd:attribu te name="n ewColumnNa me" type=" xsd:string "/> | |||||
119 | <x sd:attribu te name="c olumnDataT ype" type= "xsd:strin g"/> | |||||
120 | </xsd: attributeG roup> | |||||
121 | ||||||
122 | <xsd:a ttributeGr oup name=" dropColumn Attributes "> | |||||
123 | <x sd:attribu teGroup re f="tableNa meAttribut e"/> | |||||
124 | <x sd:attribu te name="c olumnName" type="xsd :string"/> | |||||
125 | </xsd: attributeG roup> | |||||
126 | ||||||
127 | <xsd:a ttributeGr oup name=" sequenceAt tributes"> | |||||
128 | <x sd:attribu te name="s equenceNam e" type="x sd:string" /> | |||||
129 | <x sd:attribu te name="s tartValue" type="xsd :string"/> | |||||
130 | <x sd:attribu te name="i ncrementBy " type="xs d:string"/ > | |||||
131 | <x sd:attribu te name="m axValue" t ype="xsd:s tring"/> | |||||
132 | <x sd:attribu te name="m inValue" t ype="xsd:s tring"/> | |||||
133 | <x sd:attribu te name="o rdered" ty pe="xsd:bo olean"/> | |||||
134 | </xsd: attributeG roup> | |||||
135 | ||||||
136 | <xsd:a ttributeGr oup name=" indexName" > | |||||
137 | <x sd:attribu te name="i ndexName" type="xsd: string"/> | |||||
138 | </xsd: attributeG roup> | |||||
139 | ||||||
140 | <xsd:a ttributeGr oup name=" createInde x"> | |||||
141 | <x sd:attribu teGroup re f="tableNa meAttribut e"/> | |||||
142 | <x sd:attribu teGroup re f="indexNa me"/> | |||||
143 | </xsd: attributeG roup> | |||||
144 | ||||||
145 | ||||||
146 | <xsd:e lement nam e="addPrim aryKey"> | |||||
147 | <x sd:complex Type> | |||||
148 | <xsd:att ribute nam e="tableNa me" type=" xsd:string "/> | |||||
149 | <xsd:att ribute nam e="columnN ames" type ="xsd:stri ng"/> | |||||
150 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
151 | </ xsd:comple xType> | |||||
152 | </xsd: element> | |||||
153 | ||||||
154 | <xsd:e lement nam e="dropPri maryKey"> | |||||
155 | <x sd:complex Type> | |||||
156 | <xsd:att ribute nam e="tableNa me" type=" xsd:string "/> | |||||
157 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
158 | </ xsd:comple xType> | |||||
159 | </xsd: element> | |||||
160 | ||||||
161 | <xsd:e lement nam e="addUniq ueConstrai nt"> | |||||
162 | <x sd:complex Type> | |||||
163 | <xsd:att ribute nam e="tableNa me" type=" xsd:string "/> | |||||
164 | <xsd:att ribute nam e="columnN ames" type ="xsd:stri ng"/> | |||||
165 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
166 | </ xsd:comple xType> | |||||
167 | </xsd: element> | |||||
168 | ||||||
169 | <xsd:e lement nam e="dropUni queConstra int"> | |||||
170 | <x sd:complex Type> | |||||
171 | <xsd:att ribute nam e="tableNa me" type=" xsd:string "/> | |||||
172 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
173 | </ xsd:comple xType> | |||||
174 | </xsd: element> | |||||
175 | ||||||
176 | <xsd:e lement nam e="addLook upTable"> | |||||
177 | <x sd:complex Type> | |||||
178 | <xsd:att ribute nam e="existin gTableName " type="xs d:string"/ > | |||||
179 | <xsd:att ribute nam e="existin gColumnNam e" type="x sd:string" /> | |||||
180 | <xsd:att ribute nam e="newTabl eName" typ e="xsd:str ing"/> | |||||
181 | <xsd:att ribute nam e="newColu mnName" ty pe="xsd:st ring"/> | |||||
182 | <xsd:att ribute nam e="newColu mnDataType " type="xs d:string"/ > | |||||
183 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
184 | </ xsd:comple xType> | |||||
185 | </xsd: element> | |||||
186 | ||||||
187 | <xsd:e lement nam e="addAuto Increment" > | |||||
188 | <x sd:complex Type> | |||||
189 | <xsd:att ribute nam e="tableNa me" type=" xsd:string "/> | |||||
190 | <xsd:att ribute nam e="columnN ame" type= "xsd:strin g"/> | |||||
191 | <xsd:att ribute nam e="columnD ataType" t ype="xsd:s tring"/> | |||||
192 | </ xsd:comple xType> | |||||
193 | </xsd: element> | |||||
194 | ||||||
195 | <xsd:e lement nam e="addDefa ultValue"> | |||||
196 | <x sd:complex Type> | |||||
197 | <xsd:att ribute nam e="tableNa me" type=" xsd:string "/> | |||||
198 | <xsd:att ribute nam e="columnN ame" type= "xsd:strin g"/> | |||||
199 | <xsd:att ribute nam e="default Value" typ e="xsd:str ing"/> | |||||
200 | <xsd:att ribute nam e="default ValueNumer ic" type=" xsd:string "/> | |||||
201 | <xsd:att ribute nam e="default ValueDate" type="xsd :string"/> | |||||
202 | <xsd:att ribute nam e="default ValueBoole an" type=" xsd:string "/> | |||||
203 | </ xsd:comple xType> | |||||
204 | </xsd: element> | |||||
205 | ||||||
206 | <xsd:e lement nam e="dropDef aultValue" > | |||||
207 | <x sd:complex Type> | |||||
208 | <xsd:att ribute nam e="tableNa me" type=" xsd:string "/> | |||||
209 | <xsd:att ribute nam e="columnN ame" type= "xsd:strin g"/> | |||||
210 | </ xsd:comple xType> | |||||
211 | </xsd: element> | |||||
212 | ||||||
213 | <xsd:a ttributeGr oup name=" addForeign KeyConstra intAttrib" > | |||||
214 | <x sd:attribu te name="b aseTableNa me" type=" xsd:string "/> | |||||
215 | <x sd:attribu te name="b aseColumnN ames" type ="xsd:stri ng"/> | |||||
216 | <x sd:attribu te name="c onstraintN ame" type= "xsd:strin g"/> | |||||
217 | <x sd:attribu te name="r eferencedT ableName" type="xsd: string"/> | |||||
218 | <x sd:attribu te name="r eferencedC olumnNames " type="xs d:string"/ > | |||||
219 | <x sd:attribu te name="d eferrable" type="xsd :boolean"/ > | |||||
220 | <x sd:attribu te name="i nitiallyDe ferred" ty pe="xsd:bo olean"/> | |||||
221 | </xsd: attributeG roup> | |||||
222 | ||||||
223 | <xsd:a ttributeGr oup name=" addNotNull Constraint Attrib"> | |||||
224 | <x sd:attribu te name="t ableName" type="xsd: string"/> | |||||
225 | <x sd:attribu te name="c olumnName" type="xsd :string"/> | |||||
226 | <x sd:attribu te name="d efaultNull Value" typ e="xsd:str ing"/> | |||||
227 | <x sd:attribu te name="c olumnDataT ype" type= "xsd:strin g"/> | |||||
228 | </xsd: attributeG roup> | |||||
229 | ||||||
230 | ||||||
231 | <xsd:e lement nam e="addNotN ullConstra int"> | |||||
232 | <x sd:complex Type> | |||||
233 | <xsd:att ributeGrou p ref="add NotNullCon straintAtt rib"/> | |||||
234 | </ xsd:comple xType> | |||||
235 | </xsd: element> | |||||
236 | ||||||
237 | <xsd:e lement nam e="addFore ignKeyCons traint"> | |||||
238 | <x sd:complex Type> | |||||
239 | <xsd:att ributeGrou p ref="add ForeignKey Constraint Attrib"/> | |||||
240 | </ xsd:comple xType> | |||||
241 | </xsd: element> | |||||
242 | ||||||
243 | <xsd:a ttributeGr oup name=" dbmsAttrib "> | |||||
244 | <x sd:attribu te name="t ype" type= "xsd:strin g"/> | |||||
245 | </xsd: attributeG roup> | |||||
246 | ||||||
247 | <xsd:e lement nam e="dbms"> | |||||
248 | <x sd:complex Type> | |||||
249 | <xsd:att ributeGrou p ref="dbm sAttrib"/> | |||||
250 | </ xsd:comple xType> | |||||
251 | </xsd: element> | |||||
252 | ||||||
253 | <xsd:e lement nam e="or"> | |||||
254 | <x sd:complex Type> | |||||
255 | <xsd:seq uence> | |||||
256 | <xsd :element r ef="dbms" minOccurs= "0" maxOcc urs="unbou nded"/> | |||||
257 | </xsd:se quence> | |||||
258 | </ xsd:comple xType> | |||||
259 | </xsd: element> | |||||
260 | ||||||
261 | <xsd:e lement nam e="not"> | |||||
262 | <x sd:complex Type> | |||||
263 | ||||||
264 | <xsd:cho ice> | |||||
265 | <xsd :group ref ="NotPreCo nditionChi ldren" max Occurs="un bounded"/> | |||||
266 | </xsd:ch oice> | |||||
267 | ||||||
268 | </ xsd:comple xType> | |||||
269 | </xsd: element> | |||||
270 | ||||||
271 | <xsd:a ttributeGr oup name=" runningAsA ttrib"> | |||||
272 | <x sd:attribu te name="u sername" t ype="xsd:s tring"/> | |||||
273 | </xsd: attributeG roup> | |||||
274 | ||||||
275 | <xsd:e lement nam e="running As"> | |||||
276 | <x sd:complex Type> | |||||
277 | <xsd:att ributeGrou p ref="run ningAsAttr ib"/> | |||||
278 | </ xsd:comple xType> | |||||
279 | </xsd: element> | |||||
280 | ||||||
281 | <xsd:e lement nam e="preCond itions"> | |||||
282 | <x sd:complex Type> | |||||
283 | <xsd:seq uence> | |||||
284 | <xsd :element r ef="dbms" minOccurs= "0"/> | |||||
285 | </xsd:se quence> | |||||
286 | </ xsd:comple xType> | |||||
287 | </xsd: element> | |||||
288 | ||||||
289 | ||||||
290 | <xsd:a ttributeGr oup name=" dropForeig nKeyConstr aintAttrib "> | |||||
291 | <x sd:attribu te name="b aseTableNa me" type=" xsd:string "/> | |||||
292 | <x sd:attribu te name="c onstraintN ame" type= "xsd:strin g"/> | |||||
293 | </xsd: attributeG roup> | |||||
294 | ||||||
295 | <xsd:e lement nam e="dropFor eignKeyCon straint"> | |||||
296 | <x sd:complex Type> | |||||
297 | <xsd:att ributeGrou p ref="dro pForeignKe yConstrain tAttrib"/> | |||||
298 | </ xsd:comple xType> | |||||
299 | </xsd: element> | |||||
300 | ||||||
301 | <xsd:a ttributeGr oup name=" dropNotNul lConstrain tAttrib"> | |||||
302 | <x sd:attribu te name="t ableName" type="xsd: string"/> | |||||
303 | <x sd:attribu te name="c olumnName" type="xsd :string"/> | |||||
304 | <x sd:attribu te name="c olumnDataT ype" type= "xsd:strin g"/> | |||||
305 | </xsd: attributeG roup> | |||||
306 | ||||||
307 | ||||||
308 | <xsd:e lement nam e="dropNot NullConstr aint"> | |||||
309 | <x sd:complex Type> | |||||
310 | <xsd:att ributeGrou p ref="dro pNotNullCo nstraintAt trib"/> | |||||
311 | </ xsd:comple xType> | |||||
312 | </xsd: element> | |||||
313 | ||||||
314 | ||||||
315 | <xsd:e lement nam e="constra ints"> | |||||
316 | <x sd:complex Type> | |||||
317 | <xsd:att ributeGrou p ref="con straintsAt tributes"/ > | |||||
318 | </ xsd:comple xType> | |||||
319 | </xsd: element> | |||||
320 | ||||||
321 | ||||||
322 | <xsd:e lement nam e="column" > | |||||
323 | <x sd:complex Type mixed ="true"> | |||||
324 | <xsd:seq uence> | |||||
325 | <xsd :element r ef="constr aints" min Occurs="0" /> | |||||
326 | </xsd:se quence> | |||||
327 | <xsd:att ributeGrou p ref="col umn"/> | |||||
328 | </ xsd:comple xType> | |||||
329 | </xsd: element> | |||||
330 | ||||||
331 | <!-- C hildren fo r createTa ble --> | |||||
332 | <xsd:e lement nam e="createT able"> | |||||
333 | <x sd:complex Type> | |||||
334 | <xsd:seq uence> | |||||
335 | <xsd :element r ef="column " maxOccur s="unbound ed"/> | |||||
336 | </xsd:se quence> | |||||
337 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
338 | </ xsd:comple xType> | |||||
339 | </xsd: element> | |||||
340 | ||||||
341 | <!-- C hildren fo r createVi ew --> | |||||
342 | <xsd:e lement nam e="createV iew"> | |||||
343 | <x sd:complex Type> | |||||
344 | <xsd:sim pleContent > | |||||
345 | <xsd :extension base="xsd :string"> | |||||
346 | <xsd:attri bute name= "viewName" type="xsd :string"/> | |||||
347 | </xs d:extensio n> | |||||
348 | </xsd:si mpleConten t> | |||||
349 | </ xsd:comple xType> | |||||
350 | </xsd: element> | |||||
351 | ||||||
352 | <!-- C hildren fo r insert - -> | |||||
353 | <xsd:e lement nam e="insert" > | |||||
354 | <x sd:complex Type> | |||||
355 | <xsd:seq uence> | |||||
356 | <xsd :element r ef="column " maxOccur s="unbound ed"/> | |||||
357 | </xsd:se quence> | |||||
358 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
359 | </ xsd:comple xType> | |||||
360 | </xsd: element> | |||||
361 | ||||||
362 | <!-- C hildren fo r addColum --> | |||||
363 | <xsd:e lement nam e="addColu mn"> | |||||
364 | <x sd:complex Type> | |||||
365 | <xsd:seq uence> | |||||
366 | <xsd :element r ef="column " maxOccur s="unbound ed"/> | |||||
367 | </xsd:se quence> | |||||
368 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
369 | </ xsd:comple xType> | |||||
370 | </xsd: element> | |||||
371 | ||||||
372 | <xsd:e lement nam e="rollbac k" type="x sd:string" /> | |||||
373 | ||||||
374 | <!-- c omment -- > | |||||
375 | <xsd:e lement nam e="comment " type="xs d:string"/ > | |||||
376 | ||||||
377 | <!-- s ql --> | |||||
378 | <xsd:e lement nam e="sql"> | |||||
379 | <x sd:complex Type mixed ="true"> | |||||
380 | <xsd:seq uence> | |||||
381 | <xsd :element r ef="commen t" minOccu rs="0" max Occurs="1" /> | |||||
382 | </xsd:se quence> | |||||
383 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
384 | </ xsd:comple xType> | |||||
385 | </xsd: element> | |||||
386 | ||||||
387 | <xsd:e lement nam e="sqlFile "> | |||||
388 | <x sd:complex Type> | |||||
389 | <xsd:att ribute nam e="path" t ype="xsd:s tring"/> | |||||
390 | </ xsd:comple xType> | |||||
391 | </xsd: element> | |||||
392 | ||||||
393 | <!-- r enameTable --> | |||||
394 | <xsd:e lement nam e="renameT able"> | |||||
395 | <x sd:complex Type> | |||||
396 | <xsd:att ributeGrou p ref="ren ameTableAt tributes"/ > | |||||
397 | </ xsd:comple xType> | |||||
398 | </xsd: element> | |||||
399 | ||||||
400 | <xsd:e lement nam e="renameV iew"> | |||||
401 | <x sd:complex Type> | |||||
402 | <xsd:att ributeGrou p ref="ren ameViewAtt ributes"/> | |||||
403 | </ xsd:comple xType> | |||||
404 | </xsd: element> | |||||
405 | ||||||
406 | <!-- d ropTable - -> | |||||
407 | <xsd:e lement nam e="dropTab le"> | |||||
408 | <x sd:complex Type> | |||||
409 | <xsd:att ributeGrou p ref="dro pTableAttr ibutes"/> | |||||
410 | </ xsd:comple xType> | |||||
411 | </xsd: element> | |||||
412 | ||||||
413 | <xsd:e lement nam e="dropVie w"> | |||||
414 | <x sd:complex Type> | |||||
415 | <xsd:att ribute nam e="viewNam e" type="x sd:string" /> | |||||
416 | </ xsd:comple xType> | |||||
417 | </xsd: element> | |||||
418 | ||||||
419 | <!-- r enameColum n --> | |||||
420 | <xsd:e lement nam e="renameC olumn"> | |||||
421 | <x sd:complex Type> | |||||
422 | <xsd:att ributeGrou p ref="ren ameColumnA ttributes" /> | |||||
423 | </ xsd:comple xType> | |||||
424 | </xsd: element> | |||||
425 | ||||||
426 | <xsd:e lement nam e="dropCol umn"> | |||||
427 | <x sd:complex Type> | |||||
428 | <xsd:att ributeGrou p ref="dro pColumnAtt ributes"/> | |||||
429 | </ xsd:comple xType> | |||||
430 | </xsd: element> | |||||
431 | ||||||
432 | <xsd:e lement nam e="modifyC olumn"> | |||||
433 | <x sd:complex Type> | |||||
434 | <xsd:seq uence> | |||||
435 | <xsd :element r ef="column " maxOccur s="unbound ed"/> | |||||
436 | </xsd:se quence> | |||||
437 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
438 | </ xsd:comple xType> | |||||
439 | </xsd: element> | |||||
440 | ||||||
441 | <xsd:e lement nam e="mergeCo lumns"> | |||||
442 | <x sd:complex Type> | |||||
443 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
444 | <xsd:att ribute nam e="column1 Name" type ="xsd:stri ng"/> | |||||
445 | <xsd:att ribute nam e="joinStr ing" type= "xsd:strin g"/> | |||||
446 | <xsd:att ribute nam e="column2 Name" type ="xsd:stri ng"/> | |||||
447 | <xsd:att ribute nam e="finalCo lumnName" type="xsd: string"/> | |||||
448 | <xsd:att ribute nam e="finalCo lumnType" type="xsd: string"/> | |||||
449 | </ xsd:comple xType> | |||||
450 | </xsd: element> | |||||
451 | ||||||
452 | <xsd:g roup name= "whereClau se"> | |||||
453 | <x sd:sequenc e> | |||||
454 | <xsd:ele ment name= "whereClau se" type=" xsd:string " minOccur s="0" maxO ccurs="unb ounded"/> | |||||
455 | </ xsd:sequen ce> | |||||
456 | </xsd: group> | |||||
457 | ||||||
458 | <xsd:e lement nam e="createS equence"> | |||||
459 | <x sd:complex Type> | |||||
460 | <xsd:att ributeGrou p ref="seq uenceAttri butes"/> | |||||
461 | </ xsd:comple xType> | |||||
462 | </xsd: element> | |||||
463 | ||||||
464 | <xsd:e lement nam e="alterSe quence"> | |||||
465 | <x sd:complex Type> | |||||
466 | <xsd:att ributeGrou p ref="seq uenceAttri butes"/> | |||||
467 | </ xsd:comple xType> | |||||
468 | </xsd: element> | |||||
469 | ||||||
470 | <xsd:e lement nam e="dropSeq uence"> | |||||
471 | <x sd:complex Type> | |||||
472 | <xsd:att ributeGrou p ref="seq uenceAttri butes"/> | |||||
473 | </ xsd:comple xType> | |||||
474 | </xsd: element> | |||||
475 | ||||||
476 | <xsd:e lement nam e="createI ndex"> | |||||
477 | <x sd:complex Type> | |||||
478 | <xsd:seq uence> | |||||
479 | <xsd :element r ef="column " maxOccur s="unbound ed"/> | |||||
480 | </xsd:se quence> | |||||
481 | <xsd:att ributeGrou p ref="cre ateIndex"/ > | |||||
482 | </ xsd:comple xType> | |||||
483 | </xsd: element> | |||||
484 | ||||||
485 | <xsd:e lement nam e="dropInd ex"> | |||||
486 | <x sd:complex Type> | |||||
487 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
488 | <xsd:att ributeGrou p ref="ind exName"/> | |||||
489 | </ xsd:comple xType> | |||||
490 | </xsd: element> | |||||
491 | ||||||
492 | <!-- C hildren fo r changeSe t --> | |||||
493 | <xsd:g roup name= "changeSet Children"> | |||||
494 | <x sd:choice> | |||||
495 | <xsd:ele ment ref=" comment" m axOccurs=" 1"/> | |||||
496 | <xsd:ele ment ref=" createTabl e" maxOccu rs="unboun ded"/> | |||||
497 | <xsd:ele ment ref=" dropTable" maxOccurs ="unbounde d"/> | |||||
498 | <xsd:ele ment ref=" createView " maxOccur s="unbound ed"/> | |||||
499 | <xsd:ele ment ref=" renameView " maxOccur s="unbound ed"/> | |||||
500 | <xsd:ele ment ref=" dropView" maxOccurs= "unbounded "/> | |||||
501 | <xsd:ele ment ref=" insert" ma xOccurs="u nbounded"/ > | |||||
502 | <xsd:ele ment ref=" addColumn" maxOccurs ="unbounde d"/> | |||||
503 | <xsd:ele ment ref=" sql" maxOc curs="unbo unded"/> | |||||
504 | <xsd:ele ment ref=" sqlFile" m axOccurs=" unbounded" /> | |||||
505 | <xsd:ele ment ref=" renameTabl e" maxOccu rs="unboun ded"/> | |||||
506 | <xsd:ele ment ref=" renameColu mn" maxOcc urs="unbou nded"/> | |||||
507 | <xsd:ele ment ref=" dropColumn " maxOccur s="unbound ed"/> | |||||
508 | <xsd:ele ment ref=" modifyColu mn" maxOcc urs="unbou nded"/> | |||||
509 | <xsd:ele ment ref=" mergeColum ns" maxOcc urs="unbou nded"/> | |||||
510 | <xsd:ele ment ref=" createSequ ence" maxO ccurs="unb ounded"/> | |||||
511 | <xsd:ele ment ref=" alterSeque nce" maxOc curs="unbo unded"/> | |||||
512 | <xsd:ele ment ref=" dropSequen ce" maxOcc urs="unbou nded"/> | |||||
513 | <xsd:ele ment ref=" createInde x" maxOccu rs="unboun ded"/> | |||||
514 | <xsd:ele ment ref=" dropIndex" maxOccurs ="unbounde d"/> | |||||
515 | <xsd:ele ment ref=" addNotNull Constraint " maxOccur s="unbound ed"/> | |||||
516 | <xsd:ele ment ref=" dropNotNul lConstrain t" maxOccu rs="unboun ded"/> | |||||
517 | <xsd:ele ment ref=" addForeign KeyConstra int" maxOc curs="unbo unded"/> | |||||
518 | <xsd:ele ment ref=" dropForeig nKeyConstr aint" maxO ccurs="unb ounded"/> | |||||
519 | <xsd:ele ment ref=" addPrimary Key" maxOc curs="unbo unded"/> | |||||
520 | <xsd:ele ment ref=" dropPrimar yKey" maxO ccurs="unb ounded"/> | |||||
521 | <xsd:ele ment ref=" addLookupT able" maxO ccurs="unb ounded"/> | |||||
522 | <xsd:ele ment ref=" addAutoInc rement" ma xOccurs="u nbounded"/ > | |||||
523 | <xsd:ele ment ref=" addDefault Value" max Occurs="un bounded"/> | |||||
524 | <xsd:ele ment ref=" dropDefaul tValue" ma xOccurs="u nbounded"/ > | |||||
525 | <xsd:ele ment ref=" addUniqueC onstraint" maxOccurs ="unbounde d"/> | |||||
526 | <xsd:ele ment ref=" dropUnique Constraint " maxOccur s="unbound ed"/> | |||||
527 | <xsd:ele ment ref=" rollback" maxOccurs= "1"/> | |||||
528 | ||||||
529 | </ xsd:choice > | |||||
530 | </xsd: group> | |||||
531 | ||||||
532 | <!-- C hildren fo r Precondi tion --> | |||||
533 | <xsd:g roup name= "PreCondit ionChildre n"> | |||||
534 | <x sd:sequenc e> | |||||
535 | <xsd:cho ice> | |||||
536 | <xsd :element r ef="dbms" minOccurs= "0" maxOcc urs="unbou nded"/> | |||||
537 | <xsd :element r ef="or" mi nOccurs="0 " maxOccur s="1"/> | |||||
538 | <xsd :element r ef="not" m inOccurs=" 0" maxOccu rs="1"/> | |||||
539 | </xsd:ch oice> | |||||
540 | <xsd:ele ment ref=" runningAs" minOccurs ="0" maxOc curs="1"/> | |||||
541 | </ xsd:sequen ce> | |||||
542 | ||||||
543 | </xsd: group> | |||||
544 | ||||||
545 | ||||||
546 | <!-- C hildren fo r Not Prec ondition - -> | |||||
547 | <xsd:g roup name= "NotPreCon ditionChil dren"> | |||||
548 | <x sd:sequenc e> | |||||
549 | <xsd:cho ice> | |||||
550 | <xsd :element r ef="dbms" minOccurs= "0" maxOcc urs="unbou nded"/> | |||||
551 | <xsd :element r ef="or" mi nOccurs="0 " maxOccur s="1"/> | |||||
552 | ||||||
553 | </xsd:ch oice> | |||||
554 | ||||||
555 | </ xsd:sequen ce> | |||||
556 | ||||||
557 | </xsd: group> | |||||
558 | ||||||
559 | ||||||
560 | </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.