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-1.9.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 | 882 |
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.9" | |||||
5 | xmlns="h ttp://www. liquibase. org/xml/ns /dbchangel og/1.9" | |||||
6 | elementF ormDefault ="qualifie d"> | |||||
7 | ||||||
8 | <xsd:s impleType name="onCh angeSetPre conditionE rrorOrFail "> | |||||
9 | <x sd:restric tion base= "xsd:strin g"> | |||||
10 | <xsd:enu meration v alue="HALT "/> | |||||
11 | <xsd:enu meration v alue="WARN "/> | |||||
12 | <xsd:enu meration v alue="CONT INUE"/> | |||||
13 | <xsd:enu meration v alue="MARK _RAN"/> | |||||
14 | </ xsd:restri ction> | |||||
15 | </xsd: simpleType > | |||||
16 | ||||||
17 | <xsd:s impleType name="onCh angeLogPre conditionE rrorOrFail "> | |||||
18 | <x sd:restric tion base= "xsd:strin g"> | |||||
19 | <xsd:enu meration v alue="HALT "/> | |||||
20 | <xsd:enu meration v alue="WARN "/> | |||||
21 | </ xsd:restri ction> | |||||
22 | </xsd: simpleType > | |||||
23 | ||||||
24 | <!-- T his is the main (roo t) part of the xsd - -> | |||||
25 | <xsd:e lement nam e="databas eChangeLog "> | |||||
26 | <x sd:complex Type> | |||||
27 | <xsd:seq uence> | |||||
28 | <xsd :element n ame="preCo nditions" minOccurs= "0" maxOcc urs="1"> | |||||
29 | <xsd:compl exType> | |||||
30 | <xsd:c hoice> | |||||
31 | <x sd:group r ef="PreCon ditionChil dren" maxO ccurs="unb ounded"/> | |||||
32 | </xsd: choice> | |||||
33 | <xsd:a ttribute n ame="onFai l" type="o nChangeLog Preconditi onErrorOrF ail"/> | |||||
34 | <xsd:a ttribute n ame="onErr or" type=" onChangeLo gPrecondit ionErrorOr Fail"/> | |||||
35 | </xsd:comp lexType> | |||||
36 | </xs d:element> | |||||
37 | ||||||
38 | <xsd :element n ame="prope rty" minOc curs="0" m axOccurs=" unbounded" > | |||||
39 | <xsd:compl exType> | |||||
40 | <xsd:a ttribute n ame="file" type="xsd :string"/> | |||||
41 | <xsd:a ttribute n ame="name" type="xsd :string"/> | |||||
42 | <xsd:a ttribute n ame="value " type="xs d:string"/ > | |||||
43 | </xsd:comp lexType> | |||||
44 | </xs d:element> | |||||
45 | ||||||
46 | <xsd :choice mi nOccurs="0 " maxOccur s="unbound ed"> | |||||
47 | <xsd:eleme nt name="c hangeSet" minOccurs= "0" maxOcc urs="unbou nded"> | |||||
48 | <xsd:c omplexType > | |||||
49 | <x sd:sequenc e> | |||||
50 | <xsd:ele ment name= "validChec kSum" minO ccurs="0" maxOccurs= "unbounded "> | |||||
51 | <xsd :complexTy pe mixed=" true"> | |||||
52 | <xsd:seque nce> | |||||
53 | <xsd:e lement ref ="comment" minOccurs ="0" maxOc curs="1"/> | |||||
54 | </xsd:sequ ence> | |||||
55 | </xs d:complexT ype> | |||||
56 | </xsd:el ement> | |||||
57 | <xsd:ele ment name= "preCondit ions" minO ccurs="0" maxOccurs= "1"> | |||||
58 | <xsd :complexTy pe> | |||||
59 | <xsd:choic e> | |||||
60 | <xsd:g roup ref=" PreConditi onChildren " maxOccur s="unbound ed"/> | |||||
61 | </xsd:choi ce> | |||||
62 | <xsd:attri bute name= "onFail" t ype="onCha ngeSetPrec onditionEr rorOrFail" /> | |||||
63 | <xsd:attri bute name= "onError" type="onCh angeSetPre conditionE rrorOrFail "/> | |||||
64 | </xs d:complexT ype> | |||||
65 | </xsd:el ement> | |||||
66 | <xsd:cho ice> | |||||
67 | <xsd :element r ef="tagDat abase" max Occurs="1" /> | |||||
68 | <xsd :group ref ="changeSe tChildren" minOccurs ="0" maxOc curs="unbo unded"/> | |||||
69 | </xsd:ch oice> | |||||
70 | ||||||
71 | <xsd:ele ment name= "modifySql " minOccur s="0" maxO ccurs="unb ounded"> | |||||
72 | <xsd :complexTy pe> | |||||
73 | <xsd:choic e> | |||||
74 | <xsd:g roup ref=" modifySqlC hildren" m inOccurs=" 1" maxOccu rs="unboun ded"/> | |||||
75 | </xsd:choi ce> | |||||
76 | <xsd:attri bute name= "dbms" typ e="xsd:str ing"/> | |||||
77 | </xs d:complexT ype> | |||||
78 | </xsd:el ement> | |||||
79 | ||||||
80 | </ xsd:sequen ce> | |||||
81 | <x sd:attribu teGroup re f="changeS etAttribut es"/> | |||||
82 | </xsd: complexTyp e> | |||||
83 | </xsd:elem ent> | |||||
84 | ||||||
85 | <!-- inclu de --> | |||||
86 | <xsd:eleme nt name="i nclude" mi nOccurs="0 " maxOccur s="unbound ed"> | |||||
87 | <xsd:c omplexType > | |||||
88 | <x sd:attribu te name="f ile" type= "xsd:strin g" use="re quired"/> | |||||
89 | <x sd:attribu te name="r elativeToC hangelogFi le" type=" xsd:boolea n"/> | |||||
90 | </xsd: complexTyp e> | |||||
91 | </xsd:elem ent> | |||||
92 | <xsd:eleme nt name="i ncludeAll" minOccurs ="0" maxOc curs="unbo unded"> | |||||
93 | <xsd:c omplexType > | |||||
94 | <x sd:attribu te name="p ath" type= "xsd:strin g" use="re quired"/> | |||||
95 | </xsd: complexTyp e> | |||||
96 | </xsd:elem ent> | |||||
97 | </xs d:choice> | |||||
98 | </xsd:se quence> | |||||
99 | <xsd:att ributeGrou p ref="cha ngeLogAttr ibutes"/> | |||||
100 | </ xsd:comple xType> | |||||
101 | </xsd: element> | |||||
102 | ||||||
103 | <xsd:g roup name= "modifySql Children"> | |||||
104 | <x sd:choice> | |||||
105 | <xsd:ele ment name= "replace" minOccurs= "0" maxOcc urs="unbou nded"> | |||||
106 | <xsd :complexTy pe> | |||||
107 | <xsd:attri bute name= "replace" type="xsd: string" us e="require d"/> | |||||
108 | <xsd:attri bute name= "with" typ e="xsd:str ing" use=" required"/ > | |||||
109 | </xs d:complexT ype> | |||||
110 | </xsd:el ement> | |||||
111 | <xsd:ele ment name= "regExpRep lace" minO ccurs="0" maxOccurs= "unbounded "> | |||||
112 | <xsd :complexTy pe> | |||||
113 | <xsd:attri bute name= "replace" type="xsd: string" us e="require d"/> | |||||
114 | <xsd:attri bute name= "with" typ e="xsd:str ing" use=" required"/ > | |||||
115 | </xs d:complexT ype> | |||||
116 | </xsd:el ement> | |||||
117 | <xsd:ele ment name= "prepend" minOccurs= "0" maxOcc urs="unbou nded"> | |||||
118 | <xsd :complexTy pe> | |||||
119 | <xsd:attri bute name= "value" ty pe="xsd:st ring" use= "required" /> | |||||
120 | </xs d:complexT ype> | |||||
121 | </xsd:el ement> | |||||
122 | <xsd:ele ment name= "append" m inOccurs=" 0" maxOccu rs="unboun ded"> | |||||
123 | <xsd :complexTy pe> | |||||
124 | <xsd:attri bute name= "value" ty pe="xsd:st ring" use= "required" /> | |||||
125 | </xs d:complexT ype> | |||||
126 | </xsd:el ement> | |||||
127 | </ xsd:choice > | |||||
128 | </xsd: group> | |||||
129 | ||||||
130 | <!-- A ttributes for Databa seInfo --> | |||||
131 | <xsd:a ttributeGr oup name=" DatabaseIn foAttribut es"> | |||||
132 | <x sd:attribu te name="t ype" type= "xsd:strin g"/> | |||||
133 | <x sd:attribu te name="v ersion" ty pe="xsd:st ring"/> | |||||
134 | <x sd:attribu te name="u sername" t ype="xsd:s tring"/> | |||||
135 | <x sd:attribu te name="p assword" t ype="xsd:s tring"/> | |||||
136 | <x sd:attribu te name="p ort" type= "xsd:integ er"/> | |||||
137 | <x sd:attribu te name="h ost" type= "xsd:strin g"/> | |||||
138 | <x sd:attribu te name="s chemaName" type="xsd :string"/> | |||||
139 | <x sd:attribu te name="d riverName" type="xsd :string"/> | |||||
140 | </xsd: attributeG roup> | |||||
141 | ||||||
142 | <!-- A ttributes for change Set --> | |||||
143 | <xsd:a ttributeGr oup name=" changeLogA ttributes" > | |||||
144 | <x sd:attribu te name="l ogicalFile Path" type ="xsd:stri ng"/> | |||||
145 | </xsd: attributeG roup> | |||||
146 | ||||||
147 | <!-- A ttributes for change Set --> | |||||
148 | <xsd:a ttributeGr oup name=" changeSetA ttributes" > | |||||
149 | <x sd:attribu te name="i d" type="x sd:string" use="requ ired"/> | |||||
150 | <x sd:attribu te name="a uthor" typ e="xsd:str ing" use=" required"/ > | |||||
151 | <x sd:attribu te name="c ontext" ty pe="xsd:st ring"/> | |||||
152 | <x sd:attribu te name="d bms" type= "xsd:strin g"/> | |||||
153 | <x sd:attribu te name="r unOnChange " type="xs d:boolean" /> | |||||
154 | <x sd:attribu te name="r unAlways" type="xsd: boolean"/> | |||||
155 | <x sd:attribu te name="f ailOnError " type="xs d:boolean" /> | |||||
156 | <x sd:attribu te name="r unInTransa ction" typ e="xsd:boo lean" defa ult="true" /> | |||||
157 | </xsd: attributeG roup> | |||||
158 | ||||||
159 | <!-- A ttributes for constr aints --> | |||||
160 | <xsd:a ttributeGr oup name=" constraint sAttribute s"> | |||||
161 | <x sd:attribu te name="n ullable" t ype="xsd:b oolean"/> | |||||
162 | <x sd:attribu te name="p rimaryKey" type="xsd :boolean"/ > | |||||
163 | <x sd:attribu te name="p rimaryKeyN ame" type= "xsd:strin g"/> | |||||
164 | <x sd:attribu te name="u nique" typ e="xsd:boo lean"/> | |||||
165 | <x sd:attribu te name="u niqueConst raintName" type="xsd :string"/> | |||||
166 | <x sd:attribu te name="r eferences" type="xsd :string"/> | |||||
167 | <x sd:attribu te name="f oreignKeyN ame" type= "xsd:strin g"/> | |||||
168 | <x sd:attribu te name="d eleteCasca de" type=" xsd:boolea n"/> | |||||
169 | <x sd:attribu te name="d eferrable" type="xsd :boolean"/ > | |||||
170 | <x sd:attribu te name="i nitiallyDe ferred" ty pe="xsd:bo olean"/> | |||||
171 | </xsd: attributeG roup> | |||||
172 | ||||||
173 | <xsd:a ttributeGr oup name=" column"> | |||||
174 | <x sd:attribu te name="n ame" type= "xsd:strin g" use="re quired"/> | |||||
175 | <x sd:attribu te name="t ype" type= "xsd:strin g"/> | |||||
176 | <x sd:attribu te name="v alue" type ="xsd:stri ng"/> | |||||
177 | <x sd:attribu te name="v alueNumeri c" type="x sd:string" /> | |||||
178 | <x sd:attribu te name="v alueBoolea n" type="x sd:string" /> | |||||
179 | <x sd:attribu te name="v alueDate" type="xsd: string"/> | |||||
180 | <x sd:attribu te name="d efaultValu e" type="x sd:string" /> | |||||
181 | <x sd:attribu te name="d efaultValu eNumeric" type="xsd: string"/> | |||||
182 | <x sd:attribu te name="d efaultValu eDate" typ e="xsd:str ing"/> | |||||
183 | <x sd:attribu te name="d efaultValu eBoolean" type="xsd: boolean"/> | |||||
184 | <x sd:attribu te name="a utoIncreme nt" type=" xsd:boolea n"/> | |||||
185 | <x sd:attribu te name="r emarks" ty pe="xsd:st ring"/> | |||||
186 | </xsd: attributeG roup> | |||||
187 | ||||||
188 | <xsd:a ttributeGr oup name=" dropTableA ttributes" > | |||||
189 | <x sd:attribu te name="s chemaName" type="xsd :string"/> | |||||
190 | <x sd:attribu te name="t ableName" type="xsd: string" us e="require d"/> | |||||
191 | <x sd:attribu te name="c ascadeCons traints" t ype="xsd:b oolean"/> | |||||
192 | </xsd: attributeG roup> | |||||
193 | ||||||
194 | <xsd:a ttributeGr oup name=" renameTabl eAttribute s"> | |||||
195 | <x sd:attribu te name="s chemaName" type="xsd :string"/> | |||||
196 | <x sd:attribu te name="o ldTableNam e" type="x sd:string" use="requ ired"/> | |||||
197 | <x sd:attribu te name="n ewTableNam e" type="x sd:string" use="requ ired"/> | |||||
198 | </xsd: attributeG roup> | |||||
199 | ||||||
200 | <xsd:a ttributeGr oup name=" renameView Attributes "> | |||||
201 | <x sd:attribu te name="s chemaName" type="xsd :string"/> | |||||
202 | <x sd:attribu te name="o ldViewName " type="xs d:string" use="requi red"/> | |||||
203 | <x sd:attribu te name="n ewViewName " type="xs d:string" use="requi red"/> | |||||
204 | </xsd: attributeG roup> | |||||
205 | ||||||
206 | <xsd:a ttributeGr oup name=" tableNameA ttribute"> | |||||
207 | <x sd:attribu te name="s chemaName" type="xsd :string"/> | |||||
208 | <x sd:attribu te name="t ableName" type="xsd: string" us e="require d"/> | |||||
209 | <x sd:attribu te name="t ablespace" type="xsd :string"/> | |||||
210 | </xsd: attributeG roup> | |||||
211 | ||||||
212 | <xsd:a ttributeGr oup name=" renameColu mnAttribut es"> | |||||
213 | <x sd:attribu teGroup re f="tableNa meAttribut e"/> | |||||
214 | <x sd:attribu te name="o ldColumnNa me" type=" xsd:string " use="req uired"/> | |||||
215 | <x sd:attribu te name="n ewColumnNa me" type=" xsd:string " use="req uired"/> | |||||
216 | <x sd:attribu te name="c olumnDataT ype" type= "xsd:strin g"/> | |||||
217 | </xsd: attributeG roup> | |||||
218 | ||||||
219 | <xsd:a ttributeGr oup name=" dropColumn Attributes "> | |||||
220 | <x sd:attribu teGroup re f="tableNa meAttribut e"/> | |||||
221 | <x sd:attribu te name="c olumnName" type="xsd :string" u se="requir ed"/> | |||||
222 | </xsd: attributeG roup> | |||||
223 | ||||||
224 | <xsd:a ttributeGr oup name=" sequenceAt tributes"> | |||||
225 | <x sd:attribu te name="s chemaName" type="xsd :string"/> | |||||
226 | <x sd:attribu te name="s equenceNam e" type="x sd:string" use="requ ired"/> | |||||
227 | <x sd:attribu te name="s tartValue" type="xsd :string"/> | |||||
228 | <x sd:attribu te name="i ncrementBy " type="xs d:string"/ > | |||||
229 | <x sd:attribu te name="m axValue" t ype="xsd:s tring"/> | |||||
230 | <x sd:attribu te name="m inValue" t ype="xsd:s tring"/> | |||||
231 | <x sd:attribu te name="o rdered" ty pe="xsd:bo olean"/> | |||||
232 | </xsd: attributeG roup> | |||||
233 | ||||||
234 | <xsd:a ttributeGr oup name=" indexName" > | |||||
235 | <x sd:attribu te name="i ndexName" type="xsd: string" us e="require d"/> | |||||
236 | </xsd: attributeG roup> | |||||
237 | ||||||
238 | <xsd:a ttributeGr oup name=" createInde x"> | |||||
239 | <x sd:attribu teGroup re f="tableNa meAttribut e"/> | |||||
240 | <x sd:attribu teGroup re f="indexNa me"/> | |||||
241 | <x sd:attribu te name="u nique" typ e="xsd:boo lean"/> | |||||
242 | </xsd: attributeG roup> | |||||
243 | ||||||
244 | ||||||
245 | <xsd:e lement nam e="addPrim aryKey"> | |||||
246 | <x sd:complex Type> | |||||
247 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
248 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
249 | <xsd:att ribute nam e="columnN ames" type ="xsd:stri ng" use="r equired"/> | |||||
250 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
251 | <xsd:att ribute nam e="tablesp ace" type= "xsd:strin g"/> | |||||
252 | </ xsd:comple xType> | |||||
253 | </xsd: element> | |||||
254 | ||||||
255 | <xsd:e lement nam e="dropPri maryKey"> | |||||
256 | <x sd:complex Type> | |||||
257 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
258 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
259 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
260 | </ xsd:comple xType> | |||||
261 | </xsd: element> | |||||
262 | ||||||
263 | <xsd:e lement nam e="addUniq ueConstrai nt"> | |||||
264 | <x sd:complex Type> | |||||
265 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
266 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
267 | <xsd:att ribute nam e="columnN ames" type ="xsd:stri ng" use="r equired"/> | |||||
268 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
269 | <xsd:att ribute nam e="tablesp ace" type= "xsd:strin g"/> | |||||
270 | </ xsd:comple xType> | |||||
271 | </xsd: element> | |||||
272 | ||||||
273 | <xsd:e lement nam e="dropUni queConstra int"> | |||||
274 | <x sd:complex Type> | |||||
275 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
276 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
277 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
278 | <xsd:att ribute nam e="uniqueC olumns" ty pe="xsd:st ring"/> | |||||
279 | </ xsd:comple xType> | |||||
280 | </xsd: element> | |||||
281 | ||||||
282 | <xsd:e lement nam e="addLook upTable"> | |||||
283 | <x sd:complex Type> | |||||
284 | <xsd:att ribute nam e="existin gTableSche maName" ty pe="xsd:st ring"/> | |||||
285 | <xsd:att ribute nam e="existin gTableName " type="xs d:string" use="requi red"/> | |||||
286 | <xsd:att ribute nam e="existin gColumnNam e" type="x sd:string" use="requ ired"/> | |||||
287 | <xsd:att ribute nam e="newTabl eSchemaNam e" type="x sd:string" /> | |||||
288 | <xsd:att ribute nam e="newTabl eName" typ e="xsd:str ing" use=" required"/ > | |||||
289 | <xsd:att ribute nam e="newColu mnName" ty pe="xsd:st ring" use= "required" /> | |||||
290 | <xsd:att ribute nam e="newColu mnDataType " type="xs d:string"/ > | |||||
291 | <xsd:att ribute nam e="constra intName" t ype="xsd:s tring"/> | |||||
292 | </ xsd:comple xType> | |||||
293 | </xsd: element> | |||||
294 | ||||||
295 | <xsd:e lement nam e="addAuto Increment" > | |||||
296 | <x sd:complex Type> | |||||
297 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
298 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
299 | <xsd:att ribute nam e="columnN ame" type= "xsd:strin g" use="re quired"/> | |||||
300 | <xsd:att ribute nam e="columnD ataType" t ype="xsd:s tring"/> | |||||
301 | </ xsd:comple xType> | |||||
302 | </xsd: element> | |||||
303 | ||||||
304 | <xsd:e lement nam e="addDefa ultValue"> | |||||
305 | <x sd:complex Type> | |||||
306 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
307 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
308 | <xsd:att ribute nam e="columnN ame" type= "xsd:strin g" use="re quired"/> | |||||
309 | <xsd:att ribute nam e="default Value" typ e="xsd:str ing"/> | |||||
310 | <xsd:att ribute nam e="default ValueNumer ic" type=" xsd:string "/> | |||||
311 | <xsd:att ribute nam e="default ValueDate" type="xsd :string"/> | |||||
312 | <xsd:att ribute nam e="default ValueBoole an" type=" xsd:string "/> | |||||
313 | </ xsd:comple xType> | |||||
314 | </xsd: element> | |||||
315 | ||||||
316 | <xsd:e lement nam e="dropDef aultValue" > | |||||
317 | <x sd:complex Type> | |||||
318 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
319 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
320 | <xsd:att ribute nam e="columnN ame" type= "xsd:strin g" use="re quired"/> | |||||
321 | </ xsd:comple xType> | |||||
322 | </xsd: element> | |||||
323 | ||||||
324 | <xsd:e lement nam e="loadDat a"> | |||||
325 | <x sd:complex Type mixed ="true"> | |||||
326 | <xsd:seq uence> | |||||
327 | <xsd :element n ame="colum n" minOccu rs="0" max Occurs="un bounded"> | |||||
328 | <xsd:compl exType> | |||||
329 | <xsd:a ttribute n ame="index " type="xs d:integer" /> | |||||
330 | <xsd:a ttribute n ame="heade r" type="x sd:string" /> | |||||
331 | <xsd:a ttribute n ame="name" type="xsd :string"/> | |||||
332 | <xsd:a ttribute n ame="type" type="xsd :string"/> | |||||
333 | <xsd:a ttribute n ame="defau ltValue" t ype="xsd:s tring"/> | |||||
334 | <xsd:a ttribute n ame="defau ltValueNum eric" type ="xsd:stri ng"/> | |||||
335 | <xsd:a ttribute n ame="defau ltValueDat e" type="x sd:string" /> | |||||
336 | <xsd:a ttribute n ame="defau ltValueBoo lean" type ="xsd:bool ean"/> | |||||
337 | </xsd:comp lexType> | |||||
338 | </xs d:element> | |||||
339 | </xsd:se quence> | |||||
340 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
341 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
342 | <xsd:att ribute nam e="file" t ype="xsd:s tring"/> | |||||
343 | <xsd:att ribute nam e="encodin g" type="x sd:string" /> | |||||
344 | </ xsd:comple xType> | |||||
345 | </xsd: element> | |||||
346 | ||||||
347 | <xsd:s impleType name="fkCa scadeActio nOptions"> | |||||
348 | <x sd:restric tion base= "xsd:token "> | |||||
349 | <xsd:enu meration v alue="CASC ADE"></xsd :enumerati on> | |||||
350 | <xsd:enu meration v alue="SET NULL"></xs d:enumerat ion> | |||||
351 | <xsd:enu meration v alue="SET DEFAULT">< /xsd:enume ration> | |||||
352 | <xsd:enu meration v alue="REST RICT"></xs d:enumerat ion> | |||||
353 | <xsd:enu meration v alue="NO A CTION"></x sd:enumera tion> | |||||
354 | </ xsd:restri ction> | |||||
355 | </xsd: simpleType > | |||||
356 | ||||||
357 | <xsd:a ttributeGr oup name=" addForeign KeyConstra intAttrib" > | |||||
358 | <x sd:attribu te name="b aseTableSc hemaName" type="xsd: string"/> | |||||
359 | <x sd:attribu te name="b aseTableNa me" type=" xsd:string " use="req uired"/> | |||||
360 | <x sd:attribu te name="b aseColumnN ames" type ="xsd:stri ng" use="r equired"/> | |||||
361 | <x sd:attribu te name="c onstraintN ame" type= "xsd:strin g" use="re quired"/> | |||||
362 | <x sd:attribu te name="r eferencedT ableSchema Name" type ="xsd:stri ng"/> | |||||
363 | <x sd:attribu te name="r eferencedT ableName" type="xsd: string" us e="require d"/> | |||||
364 | <x sd:attribu te name="r eferencedC olumnNames " type="xs d:string" use="requi red"/> | |||||
365 | <x sd:attribu te name="d eferrable" type="xsd :boolean"/ > | |||||
366 | <x sd:attribu te name="i nitiallyDe ferred" ty pe="xsd:bo olean"/> | |||||
367 | <x sd:attribu te name="d eleteCasca de" type=" xsd:boolea n"/> | |||||
368 | <x sd:attribu te name="o nDelete" t ype="fkCas cadeAction Options"/> | |||||
369 | <x sd:attribu te name="o nUpdate" t ype="fkCas cadeAction Options"/> | |||||
370 | </xsd: attributeG roup> | |||||
371 | ||||||
372 | <xsd:a ttributeGr oup name=" addNotNull Constraint Attrib"> | |||||
373 | <x sd:attribu te name="s chemaName" type="xsd :string"/> | |||||
374 | <x sd:attribu te name="t ableName" type="xsd: string" us e="require d"/> | |||||
375 | <x sd:attribu te name="c olumnName" type="xsd :string" u se="requir ed"/> | |||||
376 | <x sd:attribu te name="d efaultNull Value" typ e="xsd:str ing"/> | |||||
377 | <x sd:attribu te name="c olumnDataT ype" type= "xsd:strin g"/> | |||||
378 | </xsd: attributeG roup> | |||||
379 | ||||||
380 | ||||||
381 | <xsd:e lement nam e="addNotN ullConstra int"> | |||||
382 | <x sd:complex Type> | |||||
383 | <xsd:att ributeGrou p ref="add NotNullCon straintAtt rib"/> | |||||
384 | </ xsd:comple xType> | |||||
385 | </xsd: element> | |||||
386 | ||||||
387 | <xsd:e lement nam e="addFore ignKeyCons traint"> | |||||
388 | <x sd:complex Type> | |||||
389 | <xsd:att ributeGrou p ref="add ForeignKey Constraint Attrib"/> | |||||
390 | </ xsd:comple xType> | |||||
391 | </xsd: element> | |||||
392 | ||||||
393 | <xsd:a ttributeGr oup name=" dbmsAttrib "> | |||||
394 | <x sd:attribu te name="t ype" type= "xsd:strin g" use="re quired"/> | |||||
395 | </xsd: attributeG roup> | |||||
396 | ||||||
397 | <xsd:e lement nam e="dbms"> | |||||
398 | <x sd:complex Type> | |||||
399 | <xsd:att ributeGrou p ref="dbm sAttrib"/> | |||||
400 | </ xsd:comple xType> | |||||
401 | </xsd: element> | |||||
402 | ||||||
403 | <xsd:e lement nam e="changeS etExecuted "> | |||||
404 | <x sd:complex Type> | |||||
405 | <xsd:att ribute nam e="id" typ e="xsd:str ing" use=" required"/ > | |||||
406 | <xsd:att ribute nam e="author" type="xsd :string" u se="requir ed"/> | |||||
407 | <xsd:att ribute nam e="changeL ogFile" ty pe="xsd:st ring" use= "required" /> | |||||
408 | </ xsd:comple xType> | |||||
409 | </xsd: element> | |||||
410 | ||||||
411 | <xsd:e lement nam e="tableEx ists"> | |||||
412 | <x sd:complex Type> | |||||
413 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
414 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
415 | </ xsd:comple xType> | |||||
416 | </xsd: element> | |||||
417 | ||||||
418 | <xsd:e lement nam e="columnE xists"> | |||||
419 | <x sd:complex Type> | |||||
420 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
421 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
422 | <xsd:att ribute nam e="columnN ame" type= "xsd:strin g" use="re quired"/> | |||||
423 | </ xsd:comple xType> | |||||
424 | </xsd: element> | |||||
425 | ||||||
426 | <xsd:e lement nam e="sequenc eExists"> | |||||
427 | <x sd:complex Type> | |||||
428 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
429 | <xsd:att ribute nam e="sequenc eName" typ e="xsd:str ing" use=" required"/ > | |||||
430 | </ xsd:comple xType> | |||||
431 | </xsd: element> | |||||
432 | ||||||
433 | <xsd:e lement nam e="foreign KeyConstra intExists" > | |||||
434 | <x sd:complex Type> | |||||
435 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
436 | <xsd:att ribute nam e="foreign KeyName" t ype="xsd:s tring" use ="required "/> | |||||
437 | </ xsd:comple xType> | |||||
438 | </xsd: element> | |||||
439 | ||||||
440 | <xsd:e lement nam e="indexEx ists"> | |||||
441 | <x sd:complex Type> | |||||
442 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
443 | <xsd:att ribute nam e="indexNa me" type=" xsd:string " use="req uired"/> | |||||
444 | </ xsd:comple xType> | |||||
445 | </xsd: element> | |||||
446 | ||||||
447 | <xsd:e lement nam e="primary KeyExists" > | |||||
448 | <x sd:complex Type> | |||||
449 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
450 | <xsd:att ribute nam e="primary KeyName" t ype="xsd:s tring"/> | |||||
451 | <xsd:att ribute nam e="tableNa me" type=" xsd:string "/> | |||||
452 | </ xsd:comple xType> | |||||
453 | </xsd: element> | |||||
454 | ||||||
455 | <xsd:e lement nam e="viewExi sts"> | |||||
456 | <x sd:complex Type> | |||||
457 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
458 | <xsd:att ribute nam e="viewNam e" type="x sd:string" use="requ ired"/> | |||||
459 | </ xsd:comple xType> | |||||
460 | </xsd: element> | |||||
461 | ||||||
462 | <xsd:e lement nam e="sqlChec k"> | |||||
463 | <x sd:complex Type mixed ="true"> | |||||
464 | <xsd:att ribute nam e="expecte dResult" t ype="xsd:s tring" use ="required "/> | |||||
465 | </ xsd:comple xType> | |||||
466 | </xsd: element> | |||||
467 | ||||||
468 | <xsd:e lement nam e="customP reconditio n"> | |||||
469 | <x sd:complex Type> | |||||
470 | <xsd:seq uence> | |||||
471 | <xsd :element n ame="param " minOccur s="0" maxO ccurs="unb ounded"> | |||||
472 | <xsd:compl exType> | |||||
473 | <xsd:a ttribute n ame="name" type="xsd :string" u se="requir ed"/> | |||||
474 | <xsd:a ttribute n ame="value " type="xs d:string" use="requi red"/> | |||||
475 | </xsd:comp lexType> | |||||
476 | </xs d:element> | |||||
477 | </xsd:se quence> | |||||
478 | <xsd:att ribute nam e="classNa me" type=" xsd:string " use="req uired"/> | |||||
479 | </ xsd:comple xType> | |||||
480 | </xsd: element> | |||||
481 | ||||||
482 | <xsd:e lement nam e="and"> | |||||
483 | <x sd:complex Type> | |||||
484 | <xsd:cho ice> | |||||
485 | <xsd :group ref ="PreCondi tionChildr en" minOcc urs="1" ma xOccurs="u nbounded"/ > | |||||
486 | </xsd:ch oice> | |||||
487 | </ xsd:comple xType> | |||||
488 | </xsd: element> | |||||
489 | ||||||
490 | <xsd:e lement nam e="or"> | |||||
491 | <x sd:complex Type> | |||||
492 | <xsd:cho ice> | |||||
493 | <xsd :group ref ="PreCondi tionChildr en" minOcc urs="1" ma xOccurs="u nbounded"/ > | |||||
494 | </xsd:ch oice> | |||||
495 | </ xsd:comple xType> | |||||
496 | </xsd: element> | |||||
497 | ||||||
498 | <xsd:e lement nam e="not"> | |||||
499 | <x sd:complex Type> | |||||
500 | <xsd:cho ice> | |||||
501 | <xsd :group ref ="PreCondi tionChildr en" minOcc urs="1" ma xOccurs="u nbounded"/ > | |||||
502 | </xsd:ch oice> | |||||
503 | </ xsd:comple xType> | |||||
504 | </xsd: element> | |||||
505 | ||||||
506 | <xsd:a ttributeGr oup name=" runningAsA ttrib"> | |||||
507 | <x sd:attribu te name="u sername" t ype="xsd:s tring" use ="required "/> | |||||
508 | </xsd: attributeG roup> | |||||
509 | ||||||
510 | <xsd:e lement nam e="running As"> | |||||
511 | <x sd:complex Type> | |||||
512 | <xsd:att ributeGrou p ref="run ningAsAttr ib"/> | |||||
513 | </ xsd:comple xType> | |||||
514 | </xsd: element> | |||||
515 | ||||||
516 | <xsd:a ttributeGr oup name=" dropForeig nKeyConstr aintAttrib "> | |||||
517 | <x sd:attribu te name="b aseTableSc hemaName" type="xsd: string"/> | |||||
518 | <x sd:attribu te name="b aseTableNa me" type=" xsd:string " use="req uired"/> | |||||
519 | <x sd:attribu te name="c onstraintN ame" type= "xsd:strin g"/> | |||||
520 | </xsd: attributeG roup> | |||||
521 | ||||||
522 | <xsd:e lement nam e="dropFor eignKeyCon straint"> | |||||
523 | <x sd:complex Type> | |||||
524 | <xsd:att ributeGrou p ref="dro pForeignKe yConstrain tAttrib"/> | |||||
525 | </ xsd:comple xType> | |||||
526 | </xsd: element> | |||||
527 | ||||||
528 | <xsd:a ttributeGr oup name=" dropAllFor eignKeyCon straintsAt trib"> | |||||
529 | <x sd:attribu te name="b aseTableSc hemaName" type="xsd: string"/> | |||||
530 | <x sd:attribu te name="b aseTableNa me" type=" xsd:string " use="req uired"/> | |||||
531 | </xsd: attributeG roup> | |||||
532 | ||||||
533 | <xsd:e lement nam e="dropAll ForeignKey Constraint s"> | |||||
534 | <x sd:complex Type> | |||||
535 | <xsd:att ributeGrou p ref="dro pAllForeig nKeyConstr aintsAttri b"/> | |||||
536 | </ xsd:comple xType> | |||||
537 | </xsd: element> | |||||
538 | ||||||
539 | <xsd:e lement nam e="dropNot NullConstr aint"> | |||||
540 | <x sd:complex Type> | |||||
541 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
542 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " use="req uired"/> | |||||
543 | <xsd:att ribute nam e="columnN ame" type= "xsd:strin g" use="re quired"/> | |||||
544 | <xsd:att ribute nam e="columnD ataType" t ype="xsd:s tring"/> | |||||
545 | </ xsd:comple xType> | |||||
546 | </xsd: element> | |||||
547 | ||||||
548 | ||||||
549 | <xsd:e lement nam e="constra ints"> | |||||
550 | <x sd:complex Type> | |||||
551 | <xsd:att ributeGrou p ref="con straintsAt tributes"/ > | |||||
552 | </ xsd:comple xType> | |||||
553 | </xsd: element> | |||||
554 | ||||||
555 | ||||||
556 | <xsd:e lement nam e="column" > | |||||
557 | <x sd:complex Type mixed ="true"> | |||||
558 | <xsd:seq uence> | |||||
559 | <xsd :element r ef="constr aints" min Occurs="0" /> | |||||
560 | </xsd:se quence> | |||||
561 | <xsd:att ributeGrou p ref="col umn"/> | |||||
562 | </ xsd:comple xType> | |||||
563 | </xsd: element> | |||||
564 | ||||||
565 | <!-- C hildren fo r createTa ble --> | |||||
566 | <xsd:e lement nam e="createT able"> | |||||
567 | <x sd:complex Type> | |||||
568 | <xsd:seq uence> | |||||
569 | <xsd :element r ef="column " minOccur s="1" maxO ccurs="unb ounded"/> | |||||
570 | </xsd:se quence> | |||||
571 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
572 | <xsd:att ribute nam e="remarks " type="xs d:string"/ > | |||||
573 | </ xsd:comple xType> | |||||
574 | </xsd: element> | |||||
575 | ||||||
576 | <!-- C hildren fo r createVi ew --> | |||||
577 | <xsd:e lement nam e="createV iew"> | |||||
578 | <x sd:complex Type> | |||||
579 | <xsd:sim pleContent > | |||||
580 | <xsd :extension base="xsd :string"> | |||||
581 | <xsd:attri bute name= "schemaNam e" type="x sd:string" /> | |||||
582 | <xsd:attri bute name= "viewName" type="xsd :string" u se="requir ed"/> | |||||
583 | <xsd:attri bute name= "replaceIf Exists" ty pe="xsd:bo olean"/> | |||||
584 | </xs d:extensio n> | |||||
585 | </xsd:si mpleConten t> | |||||
586 | </ xsd:comple xType> | |||||
587 | </xsd: element> | |||||
588 | ||||||
589 | <!-- C hildren fo r insert - -> | |||||
590 | <xsd:e lement nam e="insert" > | |||||
591 | <x sd:complex Type> | |||||
592 | <xsd:seq uence> | |||||
593 | <xsd :element r ef="column " maxOccur s="unbound ed"/> | |||||
594 | </xsd:se quence> | |||||
595 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
596 | </ xsd:comple xType> | |||||
597 | </xsd: element> | |||||
598 | ||||||
599 | <xsd:e lement nam e="update" > | |||||
600 | <x sd:complex Type mixed ="true"> | |||||
601 | <xsd:seq uence> | |||||
602 | <xsd :element r ef="column " minOccur s="1" maxO ccurs="unb ounded"/> | |||||
603 | <xsd :element n ame="where " minOccur s="0" maxO ccurs="1"/ > | |||||
604 | </xsd:se quence> | |||||
605 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
606 | </ xsd:comple xType> | |||||
607 | </xsd: element> | |||||
608 | ||||||
609 | <xsd:e lement nam e="delete" > | |||||
610 | <x sd:complex Type mixed ="true"> | |||||
611 | <xsd:seq uence> | |||||
612 | <xsd :element n ame="where " minOccur s="0" maxO ccurs="1"/ > | |||||
613 | </xsd:se quence> | |||||
614 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
615 | </ xsd:comple xType> | |||||
616 | </xsd: element> | |||||
617 | ||||||
618 | <!-- C hildren fo r addColum --> | |||||
619 | <xsd:e lement nam e="addColu mn"> | |||||
620 | <x sd:complex Type> | |||||
621 | <xsd:seq uence> | |||||
622 | <xsd :element r ef="column " minOccur s="1" maxO ccurs="unb ounded"/> | |||||
623 | </xsd:se quence> | |||||
624 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
625 | </ xsd:comple xType> | |||||
626 | </xsd: element> | |||||
627 | ||||||
628 | <xsd:e lement nam e="rollbac k"> | |||||
629 | <x sd:complex Type mixed ="true"> | |||||
630 | <xsd:cho ice> | |||||
631 | <xsd :group ref ="changeSe tChildren" minOccurs ="0" maxOc curs="unbo unded"/> | |||||
632 | </xsd:ch oice> | |||||
633 | <xsd:att ribute nam e="changeS etPath" ty pe="xsd:st ring"/> | |||||
634 | <xsd:att ribute nam e="changeS etAuthor" type="xsd: string"/> | |||||
635 | <xsd:att ribute nam e="changeS etId" type ="xsd:stri ng"/> | |||||
636 | </ xsd:comple xType> | |||||
637 | </xsd: element> | |||||
638 | ||||||
639 | <!-- c omment -- > | |||||
640 | <xsd:e lement nam e="comment " type="xs d:string"/ > | |||||
641 | ||||||
642 | <!-- s ql --> | |||||
643 | <xsd:e lement nam e="sql"> | |||||
644 | <x sd:complex Type mixed ="true"> | |||||
645 | <xsd:seq uence> | |||||
646 | <xsd :element r ef="commen t" minOccu rs="0" max Occurs="1" /> | |||||
647 | </xsd:se quence> | |||||
648 | <xsd:att ribute nam e="stripCo mments" ty pe="xsd:bo olean"/> | |||||
649 | <xsd:att ribute nam e="splitSt atements" type="xsd: boolean"/> | |||||
650 | <xsd:att ribute nam e="endDeli miter" typ e="xsd:str ing"/> | |||||
651 | </ xsd:comple xType> | |||||
652 | </xsd: element> | |||||
653 | ||||||
654 | <xsd:e lement nam e="createP rocedure"> | |||||
655 | <x sd:complex Type mixed ="true"> | |||||
656 | <xsd:seq uence> | |||||
657 | <xsd :element r ef="commen t" minOccu rs="0" max Occurs="1" /> | |||||
658 | </xsd:se quence> | |||||
659 | </ xsd:comple xType> | |||||
660 | </xsd: element> | |||||
661 | ||||||
662 | <xsd:e lement nam e="execute Command"> | |||||
663 | <x sd:complex Type> | |||||
664 | <xsd:seq uence> | |||||
665 | <xsd :element n ame="arg" minOccurs= "0" maxOcc urs="unbou nded"> | |||||
666 | <xsd:compl exType> | |||||
667 | <xsd:a ttribute n ame="value " type="xs d:string" use="requi red"/> | |||||
668 | </xsd:comp lexType> | |||||
669 | </xs d:element> | |||||
670 | </xsd:se quence> | |||||
671 | <xsd:att ribute nam e="executa ble" type= "xsd:strin g" use="re quired"/> | |||||
672 | <xsd:att ribute nam e="os" typ e="xsd:str ing"/> | |||||
673 | </ xsd:comple xType> | |||||
674 | </xsd: element> | |||||
675 | ||||||
676 | <xsd:e lement nam e="sqlFile "> | |||||
677 | <x sd:complex Type> | |||||
678 | <xsd:att ribute nam e="path" t ype="xsd:s tring" use ="required "/> | |||||
679 | <xsd:att ribute nam e="stripCo mments" ty pe="xsd:bo olean"/> | |||||
680 | <xsd:att ribute nam e="splitSt atements" type="xsd: boolean"/> | |||||
681 | <xsd:att ribute nam e="encodin g" type="x sd:string" /> | |||||
682 | <xsd:att ribute nam e="endDeli miter" typ e="xsd:str ing"/> | |||||
683 | </ xsd:comple xType> | |||||
684 | </xsd: element> | |||||
685 | ||||||
686 | <xsd:e lement nam e="tagData base"> | |||||
687 | <x sd:complex Type> | |||||
688 | <xsd:att ribute nam e="tag" ty pe="xsd:st ring" use= "required" /> | |||||
689 | </ xsd:comple xType> | |||||
690 | </xsd: element> | |||||
691 | ||||||
692 | <xsd:e lement nam e="stop"> | |||||
693 | <x sd:complex Type mixed ="true"/> | |||||
694 | </xsd: element> | |||||
695 | ||||||
696 | <!-- r enameTable --> | |||||
697 | <xsd:e lement nam e="renameT able"> | |||||
698 | <x sd:complex Type> | |||||
699 | <xsd:att ributeGrou p ref="ren ameTableAt tributes"/ > | |||||
700 | </ xsd:comple xType> | |||||
701 | </xsd: element> | |||||
702 | ||||||
703 | <xsd:e lement nam e="renameV iew"> | |||||
704 | <x sd:complex Type> | |||||
705 | <xsd:att ributeGrou p ref="ren ameViewAtt ributes"/> | |||||
706 | </ xsd:comple xType> | |||||
707 | </xsd: element> | |||||
708 | ||||||
709 | <!-- d ropTable - -> | |||||
710 | <xsd:e lement nam e="dropTab le"> | |||||
711 | <x sd:complex Type> | |||||
712 | <xsd:att ributeGrou p ref="dro pTableAttr ibutes"/> | |||||
713 | </ xsd:comple xType> | |||||
714 | </xsd: element> | |||||
715 | ||||||
716 | <xsd:e lement nam e="dropVie w"> | |||||
717 | <x sd:complex Type> | |||||
718 | <xsd:att ribute nam e="viewNam e" type="x sd:string" use="requ ired"/> | |||||
719 | <xsd:att ribute nam e="schemaN ame" type= "xsd:strin g"/> | |||||
720 | </ xsd:comple xType> | |||||
721 | </xsd: element> | |||||
722 | ||||||
723 | <!-- r enameColum n --> | |||||
724 | <xsd:e lement nam e="renameC olumn"> | |||||
725 | <x sd:complex Type> | |||||
726 | <xsd:att ributeGrou p ref="ren ameColumnA ttributes" /> | |||||
727 | </ xsd:comple xType> | |||||
728 | </xsd: element> | |||||
729 | ||||||
730 | <xsd:e lement nam e="dropCol umn"> | |||||
731 | <x sd:complex Type> | |||||
732 | <xsd:att ributeGrou p ref="dro pColumnAtt ributes"/> | |||||
733 | </ xsd:comple xType> | |||||
734 | </xsd: element> | |||||
735 | ||||||
736 | <xsd:e lement nam e="modifyC olumn"> | |||||
737 | <x sd:complex Type> | |||||
738 | <xsd:seq uence> | |||||
739 | <xsd :element r ef="column " maxOccur s="unbound ed"/> | |||||
740 | </xsd:se quence> | |||||
741 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
742 | </ xsd:comple xType> | |||||
743 | </xsd: element> | |||||
744 | ||||||
745 | <xsd:e lement nam e="mergeCo lumns"> | |||||
746 | <x sd:complex Type> | |||||
747 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
748 | <xsd:att ribute nam e="column1 Name" type ="xsd:stri ng" use="r equired"/> | |||||
749 | <xsd:att ribute nam e="joinStr ing" type= "xsd:strin g" use="re quired"/> | |||||
750 | <xsd:att ribute nam e="column2 Name" type ="xsd:stri ng" use="r equired"/> | |||||
751 | <xsd:att ribute nam e="finalCo lumnName" type="xsd: string" us e="require d"/> | |||||
752 | <xsd:att ribute nam e="finalCo lumnType" type="xsd: string" us e="require d"/> | |||||
753 | </ xsd:comple xType> | |||||
754 | </xsd: element> | |||||
755 | ||||||
756 | <xsd:g roup name= "whereClau se"> | |||||
757 | <x sd:sequenc e> | |||||
758 | <xsd:ele ment name= "whereClau se" type=" xsd:string " minOccur s="0" maxO ccurs="unb ounded"/> | |||||
759 | </ xsd:sequen ce> | |||||
760 | </xsd: group> | |||||
761 | ||||||
762 | <xsd:e lement nam e="createS equence"> | |||||
763 | <x sd:complex Type> | |||||
764 | <xsd:att ributeGrou p ref="seq uenceAttri butes"/> | |||||
765 | </ xsd:comple xType> | |||||
766 | </xsd: element> | |||||
767 | ||||||
768 | <xsd:e lement nam e="alterSe quence"> | |||||
769 | <x sd:complex Type> | |||||
770 | <xsd:att ributeGrou p ref="seq uenceAttri butes"/> | |||||
771 | </ xsd:comple xType> | |||||
772 | </xsd: element> | |||||
773 | ||||||
774 | <xsd:e lement nam e="dropSeq uence"> | |||||
775 | <x sd:complex Type> | |||||
776 | <xsd:att ributeGrou p ref="seq uenceAttri butes"/> | |||||
777 | </ xsd:comple xType> | |||||
778 | </xsd: element> | |||||
779 | ||||||
780 | <xsd:e lement nam e="createI ndex"> | |||||
781 | <x sd:complex Type> | |||||
782 | <xsd:seq uence> | |||||
783 | <xsd :element r ef="column " maxOccur s="unbound ed"/> | |||||
784 | </xsd:se quence> | |||||
785 | <xsd:att ributeGrou p ref="cre ateIndex"/ > | |||||
786 | </ xsd:comple xType> | |||||
787 | </xsd: element> | |||||
788 | ||||||
789 | <xsd:e lement nam e="dropInd ex"> | |||||
790 | <x sd:complex Type> | |||||
791 | <xsd:att ributeGrou p ref="tab leNameAttr ibute"/> | |||||
792 | <xsd:att ributeGrou p ref="ind exName"/> | |||||
793 | </ xsd:comple xType> | |||||
794 | </xsd: element> | |||||
795 | ||||||
796 | <xsd:e lement nam e="customC hange"> | |||||
797 | <x sd:complex Type> | |||||
798 | <xsd:seq uence> | |||||
799 | <xsd :element n ame="param " minOccur s="0" maxO ccurs="unb ounded"> | |||||
800 | <xsd:compl exType mix ed="true"> | |||||
801 | <xsd:a ttribute n ame="name" type="xsd :string" u se="requir ed"/> | |||||
802 | <xsd:a ttribute n ame="value " type="xs d:string"/ > | |||||
803 | </xsd:comp lexType> | |||||
804 | </xs d:element> | |||||
805 | </xsd:se quence> | |||||
806 | <xsd:att ribute nam e="class" type="xsd: string" us e="require d"/> | |||||
807 | <xsd:any Attribute processCon tents="lax "/> | |||||
808 | </ xsd:comple xType> | |||||
809 | </xsd: element> | |||||
810 | ||||||
811 | ||||||
812 | <!-- C hildren fo r changeSe t --> | |||||
813 | <xsd:g roup name= "changeSet Children"> | |||||
814 | <x sd:choice> | |||||
815 | <xsd:ele ment ref=" comment" m axOccurs=" 1"/> | |||||
816 | <xsd:ele ment ref=" createTabl e" maxOccu rs="unboun ded"/> | |||||
817 | <xsd:ele ment ref=" dropTable" maxOccurs ="unbounde d"/> | |||||
818 | <xsd:ele ment ref=" createView " maxOccur s="unbound ed"/> | |||||
819 | <xsd:ele ment ref=" renameView " maxOccur s="unbound ed"/> | |||||
820 | <xsd:ele ment ref=" dropView" maxOccurs= "unbounded "/> | |||||
821 | <xsd:ele ment ref=" insert" ma xOccurs="u nbounded"/ > | |||||
822 | <xsd:ele ment ref=" addColumn" maxOccurs ="unbounde d"/> | |||||
823 | <xsd:ele ment ref=" sql" maxOc curs="unbo unded"/> | |||||
824 | <xsd:ele ment ref=" createProc edure" max Occurs="un bounded"/> | |||||
825 | <xsd:ele ment ref=" sqlFile" m axOccurs=" unbounded" /> | |||||
826 | <xsd:ele ment ref=" renameTabl e" maxOccu rs="unboun ded"/> | |||||
827 | <xsd:ele ment ref=" renameColu mn" maxOcc urs="unbou nded"/> | |||||
828 | <xsd:ele ment ref=" dropColumn " maxOccur s="unbound ed"/> | |||||
829 | <xsd:ele ment ref=" modifyColu mn" maxOcc urs="unbou nded"/> | |||||
830 | <xsd:ele ment ref=" mergeColum ns" maxOcc urs="unbou nded"/> | |||||
831 | <xsd:ele ment ref=" createSequ ence" maxO ccurs="unb ounded"/> | |||||
832 | <xsd:ele ment ref=" alterSeque nce" maxOc curs="unbo unded"/> | |||||
833 | <xsd:ele ment ref=" dropSequen ce" maxOcc urs="unbou nded"/> | |||||
834 | <xsd:ele ment ref=" createInde x" maxOccu rs="unboun ded"/> | |||||
835 | <xsd:ele ment ref=" dropIndex" maxOccurs ="unbounde d"/> | |||||
836 | <xsd:ele ment ref=" addNotNull Constraint " maxOccur s="unbound ed"/> | |||||
837 | <xsd:ele ment ref=" dropNotNul lConstrain t" maxOccu rs="unboun ded"/> | |||||
838 | <xsd:ele ment ref=" addForeign KeyConstra int" maxOc curs="unbo unded"/> | |||||
839 | <xsd:ele ment ref=" dropForeig nKeyConstr aint" maxO ccurs="unb ounded"/> | |||||
840 | <xsd:ele ment ref=" dropAllFor eignKeyCon straints" maxOccurs= "unbounded "/> | |||||
841 | <xsd:ele ment ref=" addPrimary Key" maxOc curs="unbo unded"/> | |||||
842 | <xsd:ele ment ref=" dropPrimar yKey" maxO ccurs="unb ounded"/> | |||||
843 | <xsd:ele ment ref=" addLookupT able" maxO ccurs="unb ounded"/> | |||||
844 | <xsd:ele ment ref=" addAutoInc rement" ma xOccurs="u nbounded"/ > | |||||
845 | <xsd:ele ment ref=" addDefault Value" max Occurs="un bounded"/> | |||||
846 | <xsd:ele ment ref=" dropDefaul tValue" ma xOccurs="u nbounded"/ > | |||||
847 | <xsd:ele ment ref=" addUniqueC onstraint" maxOccurs ="unbounde d"/> | |||||
848 | <xsd:ele ment ref=" dropUnique Constraint " maxOccur s="unbound ed"/> | |||||
849 | <xsd:ele ment ref=" customChan ge" maxOcc urs="unbou nded"/> | |||||
850 | <xsd:ele ment ref=" update" ma xOccurs="u nbounded"/ > | |||||
851 | <xsd:ele ment ref=" delete" ma xOccurs="u nbounded"/ > | |||||
852 | <xsd:ele ment ref=" loadData" maxOccurs= "unbounded "/> | |||||
853 | <xsd:ele ment ref=" executeCom mand" maxO ccurs="unb ounded"/> | |||||
854 | <xsd:ele ment ref=" stop" maxO ccurs="unb ounded"/> | |||||
855 | <xsd:ele ment ref=" rollback" maxOccurs= "1"/> | |||||
856 | </ xsd:choice > | |||||
857 | </xsd: group> | |||||
858 | ||||||
859 | <!-- C hildren fo r Precondi tion --> | |||||
860 | <xsd:g roup name= "PreCondit ionChildre n"> | |||||
861 | <x sd:sequenc e> | |||||
862 | <xsd:cho ice> | |||||
863 | <xsd :element r ef="and" m axOccurs=" unbounded" /> | |||||
864 | <xsd :element r ef="or" ma xOccurs="u nbounded"/ > | |||||
865 | <xsd :element r ef="not" m axOccurs=" unbounded" /> | |||||
866 | <xsd :element r ef="dbms" maxOccurs= "unbounded "/> | |||||
867 | <xsd :element r ef="runnin gAs" maxOc curs="unbo unded"/> | |||||
868 | <xsd :element r ef="change SetExecute d" maxOccu rs="unboun ded"/> | |||||
869 | <xsd :element r ef="tableE xists" max Occurs="un bounded"/> | |||||
870 | <xsd :element r ef="column Exists" ma xOccurs="u nbounded"/ > | |||||
871 | <xsd :element r ef="sequen ceExists" maxOccurs= "unbounded "/> | |||||
872 | <xsd :element r ef="foreig nKeyConstr aintExists " maxOccur s="unbound ed"/> | |||||
873 | <xsd :element r ef="indexE xists" max Occurs="un bounded"/> | |||||
874 | <xsd :element r ef="primar yKeyExists " maxOccur s="unbound ed"/> | |||||
875 | <xsd :element r ef="viewEx ists" maxO ccurs="unb ounded"/> | |||||
876 | <xsd :element r ef="sqlChe ck" maxOcc urs="unbou nded"/> | |||||
877 | <xsd :element r ef="custom Preconditi on" maxOcc urs="unbou nded"/> | |||||
878 | </xsd:ch oice> | |||||
879 | </ xsd:sequen ce> | |||||
880 | ||||||
881 | </xsd: group> | |||||
882 | </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.