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.1.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 | 1072 |
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 :anyAttrib ute namesp ace="##oth er" /> | |||||
163 | </ xsd:comple xType> | |||||
164 | </xsd:elem ent> | |||||
165 | ||||||
166 | <!-- inclu de --> | |||||
167 | <xsd:eleme nt name="i nclude" mi nOccurs="0 " maxOccur s="unbound ed"> | |||||
168 | <x sd:complex Type> | |||||
169 | <xsd :attribute name="fil e" type="x sd:string" use="requ ired" /> | |||||
170 | <xsd :attribute name="rel ativeToCha ngelogFile " type="bo oleanExp" /> | |||||
171 | <xsd :anyAttrib ute namesp ace="##oth er" /> | |||||
172 | </ xsd:comple xType> | |||||
173 | </xsd:elem ent> | |||||
174 | <xsd:eleme nt name="i ncludeAll" minOccurs ="0" maxOc curs="unbo unded"> | |||||
175 | <x sd:complex Type> | |||||
176 | <xsd :attribute name="pat h" type="x sd:string" use="requ ired" /> | |||||
177 | <xsd :attribute name="rel ativeToCha ngelogFile " type="bo oleanExp" /> | |||||
178 | <xsd :anyAttrib ute namesp ace="##oth er" /> | |||||
179 | </ xsd:comple xType> | |||||
180 | </xsd:elem ent> | |||||
181 | </xsd:ch oice> | |||||
182 | </xsd: sequence> | |||||
183 | <xsd:a ttributeGr oup ref="c hangeLogAt tributes" /> | |||||
184 | <xsd:a nyAttribut e namespac e="##other " /> | |||||
185 | </xs d:complexT ype> | |||||
186 | </ xsd:elemen t> | |||||
187 | ||||||
188 | <x sd:group n ame="modif ySqlChildr en"> | |||||
189 | <xsd :choice> | |||||
190 | <xsd:e lement nam e="replace " minOccur s="0" maxO ccurs="unb ounded"> | |||||
191 | <xsd:com plexType> | |||||
192 | <xsd:attri bute name= "replace" type="xsd: string" us e="require d" /> | |||||
193 | <xsd:attri bute name= "with" typ e="xsd:str ing" use=" required" /> | |||||
194 | </xsd:co mplexType> | |||||
195 | </xsd: element> | |||||
196 | <xsd:e lement nam e="regExpR eplace" mi nOccurs="0 " | |||||
197 | maxOccur s="unbound ed"> | |||||
198 | <xsd:com plexType> | |||||
199 | <xsd:attri bute name= "replace" type="xsd: string" us e="require d" /> | |||||
200 | <xsd:attri bute name= "with" typ e="xsd:str ing" use=" required" /> | |||||
201 | </xsd:co mplexType> | |||||
202 | </xsd: element> | |||||
203 | <xsd:e lement nam e="prepend " minOccur s="0" maxO ccurs="unb ounded"> | |||||
204 | <xsd:com plexType> | |||||
205 | <xsd:attri bute name= "value" ty pe="xsd:st ring" use= "required" /> | |||||
206 | </xsd:co mplexType> | |||||
207 | </xsd: element> | |||||
208 | <xsd:e lement nam e="append" minOccurs ="0" maxOc curs="unbo unded"> | |||||
209 | <xsd:com plexType> | |||||
210 | <xsd:attri bute name= "value" ty pe="xsd:st ring" use= "required" /> | |||||
211 | </xsd:co mplexType> | |||||
212 | </xsd: element> | |||||
213 | </xs d:choice> | |||||
214 | </ xsd:group> | |||||
215 | ||||||
216 | <! -- Attribu tes for Da tabaseInfo --> | |||||
217 | <x sd:attribu teGroup na me="Databa seInfoAttr ibutes"> | |||||
218 | <xsd :attribute name="typ e" type="x sd:string" /> | |||||
219 | <xsd :attribute name="ver sion" type ="xsd:stri ng" /> | |||||
220 | <xsd :attribute name="use rname" typ e="xsd:str ing" /> | |||||
221 | <xsd :attribute name="pas sword" typ e="xsd:str ing" /> | |||||
222 | <xsd :attribute name="por t" type="i ntegerExp" /> | |||||
223 | <xsd :attribute name="hos t" type="x sd:string" /> | |||||
224 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
225 | <xsd :attribute name="dri verName" t ype="xsd:s tring" /> | |||||
226 | </ xsd:attrib uteGroup> | |||||
227 | ||||||
228 | <! -- Attribu tes for ch angeSet -- > | |||||
229 | <x sd:attribu teGroup na me="change LogAttribu tes"> | |||||
230 | <xsd :attribute name="log icalFilePa th" type=" xsd:string " /> | |||||
231 | </ xsd:attrib uteGroup> | |||||
232 | ||||||
233 | <! -- Attribu tes for ch angeSet -- > | |||||
234 | <x sd:attribu teGroup na me="change SetAttribu tes"> | |||||
235 | <xsd :attribute name="id" type="xsd :string" u se="requir ed" /> | |||||
236 | <xsd :attribute name="aut hor" type= "xsd:strin g" use="re quired" /> | |||||
237 | <xsd :attribute name="con text" type ="xsd:stri ng" /> | |||||
238 | <xsd :attribute name="dbm s" type="x sd:string" /> | |||||
239 | <xsd :attribute name="run OnChange" type="bool eanExp" /> | |||||
240 | <xsd :attribute name="run Always" ty pe="boolea nExp" /> | |||||
241 | <xsd :attribute name="fai lOnError" type="bool eanExp" /> | |||||
242 | <x sd:attribu te name="o nValidatio nFail" typ e="onChang eSetValida tionFail" /> | |||||
243 | <xsd :attribute name="run InTransact ion" type= "booleanEx p" default ="true" /> | |||||
244 | <xsd :attribute name="log icalFilePa th" type=" xsd:string " /> | |||||
245 | </ xsd:attrib uteGroup> | |||||
246 | ||||||
247 | <! -- Attribu tes for co nstraints --> | |||||
248 | <x sd:attribu teGroup na me="constr aintsAttri butes"> | |||||
249 | <xsd :attribute name="nul lable" typ e="boolean Exp" /> | |||||
250 | <xsd :attribute name="pri maryKey" t ype="boole anExp" /> | |||||
251 | <xsd :attribute name="pri maryKeyNam e" type="x sd:string" /> | |||||
252 | <x sd:attribu te name="p rimaryKeyT ablespace" type="xsd :string" / > | |||||
253 | <xsd :attribute name="uni que" type= "booleanEx p" /> | |||||
254 | <xsd :attribute name="uni queConstra intName" t ype="xsd:s tring" /> | |||||
255 | <xsd :attribute name="ref erences" t ype="xsd:s tring" /> | |||||
256 | <xsd :attribute name="for eignKeyNam e" type="x sd:string" /> | |||||
257 | <xsd :attribute name="del eteCascade " type="bo oleanExp" /> | |||||
258 | <xsd :attribute name="def errable" t ype="boole anExp" /> | |||||
259 | <xsd :attribute name="ini tiallyDefe rred" type ="booleanE xp" /> | |||||
260 | </ xsd:attrib uteGroup> | |||||
261 | ||||||
262 | <x sd:attribu teGroup na me="column "> | |||||
263 | <xsd :attribute name="nam e" type="x sd:string" use="requ ired" /> | |||||
264 | <xsd :attribute name="typ e" type="x sd:string" /> | |||||
265 | <xsd :attribute name="val ue" type=" xsd:string " /> | |||||
266 | <xsd :attribute name="val ueNumeric" type="xsd :string" / > | |||||
267 | <xsd :attribute name="val ueBoolean" type="xsd :string" / > | |||||
268 | <xsd :attribute name="val ueDate" ty pe="xsd:st ring" /> | |||||
269 | <xsd :attribute name="val ueComputed " type="xs d:string" /> | |||||
270 | <xsd :attribute name="def aultValue" type="xsd :string" / > | |||||
271 | <xsd :attribute name="def aultValueN umeric" ty pe="xsd:st ring" /> | |||||
272 | <xsd :attribute name="def aultValueD ate" type= "xsd:strin g" /> | |||||
273 | <xsd :attribute name="def aultValueB oolean" ty pe="boolea nExp" /> | |||||
274 | <xsd :attribute name="def aultValueC omputed" t ype="xsd:s tring" /> | |||||
275 | <xsd :attribute name="aut oIncrement " type="bo oleanExp" /> | |||||
276 | <xsd :attribute name="sta rtWith" ty pe="xsd:lo ng" /> | |||||
277 | <xsd :attribute name="inc rementBy" type="xsd: long" /> | |||||
278 | <xsd :attribute name="rem arks" type ="xsd:stri ng" /> | |||||
279 | </ xsd:attrib uteGroup> | |||||
280 | ||||||
281 | <x sd:attribu teGroup na me="dropTa bleAttribu tes"> | |||||
282 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
283 | <xsd :attribute name="tab leName" ty pe="xsd:st ring" use= "required" /> | |||||
284 | <xsd :attribute name="cas cadeConstr aints" typ e="boolean Exp" /> | |||||
285 | </ xsd:attrib uteGroup> | |||||
286 | ||||||
287 | <x sd:attribu teGroup na me="rename TableAttri butes"> | |||||
288 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
289 | <xsd :attribute name="old TableName" type="xsd :string" | |||||
290 | use="r equired" / > | |||||
291 | <xsd :attribute name="new TableName" type="xsd :string" | |||||
292 | use="r equired" / > | |||||
293 | </ xsd:attrib uteGroup> | |||||
294 | ||||||
295 | <x sd:attribu teGroup na me="rename ViewAttrib utes"> | |||||
296 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
297 | <xsd :attribute name="old ViewName" type="xsd: string" us e="require d" /> | |||||
298 | <xsd :attribute name="new ViewName" type="xsd: string" us e="require d" /> | |||||
299 | </ xsd:attrib uteGroup> | |||||
300 | ||||||
301 | <x sd:attribu teGroup na me="tableN ameAttribu te"> | |||||
302 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
303 | <xsd :attribute name="tab leName" ty pe="xsd:st ring" use= "required" /> | |||||
304 | </ xsd:attrib uteGroup> | |||||
305 | ||||||
306 | <x sd:attribu teGroup na me="rename ColumnAttr ibutes"> | |||||
307 | <xsd :attribute Group ref= "tableName Attribute" /> | |||||
308 | <xsd :attribute name="old ColumnName " type="xs d:string" | |||||
309 | use="r equired" / > | |||||
310 | <xsd :attribute name="new ColumnName " type="xs d:string" | |||||
311 | use="r equired" / > | |||||
312 | <xsd :attribute name="col umnDataTyp e" type="x sd:string" /> | |||||
313 | </ xsd:attrib uteGroup> | |||||
314 | ||||||
315 | <x sd:attribu teGroup na me="dropCo lumnAttrib utes"> | |||||
316 | <xsd :attribute Group ref= "tableName Attribute" /> | |||||
317 | <xsd :attribute name="col umnName" t ype="xsd:s tring" use ="required " /> | |||||
318 | </ xsd:attrib uteGroup> | |||||
319 | ||||||
320 | <x sd:attribu teGroup na me="sequen ceAttribut es"> | |||||
321 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
322 | <xsd :attribute name="seq uenceName" type="xsd :string" | |||||
323 | use="r equired" / > | |||||
324 | <xsd :attribute name="sta rtValue" t ype="xsd:s tring" /> | |||||
325 | <xsd :attribute name="inc rementBy" type="xsd: string" /> | |||||
326 | <xsd :attribute name="max Value" typ e="xsd:str ing" /> | |||||
327 | <xsd :attribute name="min Value" typ e="xsd:str ing" /> | |||||
328 | <xsd :attribute name="ord ered" type ="booleanE xp" /> | |||||
329 | </ xsd:attrib uteGroup> | |||||
330 | ||||||
331 | <x sd:attribu teGroup na me="indexN ame"> | |||||
332 | <xsd :attribute name="ind exName" ty pe="xsd:st ring" use= "required" /> | |||||
333 | </ xsd:attrib uteGroup> | |||||
334 | ||||||
335 | <x sd:attribu teGroup na me="create Index"> | |||||
336 | <xsd :attribute Group ref= "tableName Attribute" /> | |||||
337 | <xsd :attribute Group ref= "indexName " /> | |||||
338 | <xsd :attribute name="ass ociatedWit h" type="x sd:string" use="opti onal" /> | |||||
339 | <xsd :attribute name="uni que" type= "booleanEx p" /> | |||||
340 | <x sd:attribu te name="t ablespace" type="xsd :string" / > | |||||
341 | </ xsd:attrib uteGroup> | |||||
342 | ||||||
343 | ||||||
344 | <x sd:element name="add PrimaryKey "> | |||||
345 | <xsd :complexTy pe> | |||||
346 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
347 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
348 | <xsd:a ttribute n ame="colum nNames" ty pe="xsd:st ring" | |||||
349 | use="req uired" /> | |||||
350 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
351 | <xsd:a ttribute n ame="table space" typ e="xsd:str ing" /> | |||||
352 | </xs d:complexT ype> | |||||
353 | </ xsd:elemen t> | |||||
354 | ||||||
355 | <x sd:element name="dro pPrimaryKe y"> | |||||
356 | <xsd :complexTy pe> | |||||
357 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
358 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
359 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
360 | </xs d:complexT ype> | |||||
361 | </ xsd:elemen t> | |||||
362 | ||||||
363 | <x sd:element name="add UniqueCons traint"> | |||||
364 | <xsd :complexTy pe> | |||||
365 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
366 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
367 | <xsd:a ttribute n ame="colum nNames" ty pe="xsd:st ring" | |||||
368 | use="req uired" /> | |||||
369 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
370 | <xsd:a ttribute n ame="table space" typ e="xsd:str ing" /> | |||||
371 | <xsd:a ttribute n ame="disab led" type= "booleanEx p" /> | |||||
372 | <xsd:a ttribute n ame="defer rable" typ e="boolean Exp" /> | |||||
373 | <xsd:a ttribute n ame="initi allyDeferr ed" type=" booleanExp " /> | |||||
374 | </xs d:complexT ype> | |||||
375 | </ xsd:elemen t> | |||||
376 | ||||||
377 | <x sd:element name="dro pUniqueCon straint"> | |||||
378 | <xsd :complexTy pe> | |||||
379 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
380 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
381 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
382 | <xsd:a ttribute n ame="uniqu eColumns" type="xsd: string" /> | |||||
383 | </xs d:complexT ype> | |||||
384 | </ xsd:elemen t> | |||||
385 | ||||||
386 | <x sd:element name="mod ifyDataTyp e"> | |||||
387 | <xsd :complexTy pe> | |||||
388 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
389 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
390 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
391 | <xsd:a ttribute n ame="newDa taType" ty pe="xsd:st ring" use= "required" /> | |||||
392 | </xs d:complexT ype> | |||||
393 | </ xsd:elemen t> | |||||
394 | ||||||
395 | <x sd:element name="add LookupTabl e"> | |||||
396 | <xsd :complexTy pe> | |||||
397 | <xsd:a ttribute n ame="exist ingTableSc hemaName" type="xsd: string" /> | |||||
398 | <xsd:a ttribute n ame="exist ingTableNa me" type=" xsd:string " | |||||
399 | use="req uired" /> | |||||
400 | <xsd:a ttribute n ame="exist ingColumnN ame" type= "xsd:strin g" | |||||
401 | use="req uired" /> | |||||
402 | <xsd:a ttribute n ame="newTa bleSchemaN ame" type= "xsd:strin g" /> | |||||
403 | <xsd:a ttribute n ame="newTa bleName" t ype="xsd:s tring" | |||||
404 | use="req uired" /> | |||||
405 | <xsd:a ttribute n ame="newCo lumnName" type="xsd: string" | |||||
406 | use="req uired" /> | |||||
407 | <xsd:a ttribute n ame="newCo lumnDataTy pe" type=" xsd:string " /> | |||||
408 | <xsd:a ttribute n ame="const raintName" type="xsd :string" / > | |||||
409 | </xs d:complexT ype> | |||||
410 | </ xsd:elemen t> | |||||
411 | ||||||
412 | <x sd:element name="add AutoIncrem ent"> | |||||
413 | <xsd :complexTy pe> | |||||
414 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
415 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
416 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
417 | <xsd:a ttribute n ame="colum nDataType" type="xsd :string" / > | |||||
418 | <xsd:a ttribute n ame="start With" type ="xsd:long " /> | |||||
419 | <xsd:a ttribute n ame="incre mentBy" ty pe="xsd:lo ng" /> | |||||
420 | </xs d:complexT ype> | |||||
421 | </ xsd:elemen t> | |||||
422 | ||||||
423 | <x sd:element name="add DefaultVal ue"> | |||||
424 | <xsd :complexTy pe> | |||||
425 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
426 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
427 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
428 | <xsd:a ttribute n ame="colum nDataType" type="xsd :string" / > | |||||
429 | <xsd:a ttribute n ame="defau ltValue" t ype="xsd:s tring" /> | |||||
430 | <xsd:a ttribute n ame="defau ltValueNum eric" type ="xsd:stri ng" /> | |||||
431 | <xsd:a ttribute n ame="defau ltValueDat e" type="x sd:string" /> | |||||
432 | <xsd:a ttribute n ame="defau ltValueBoo lean" type ="xsd:stri ng" /> | |||||
433 | <xsd:a ttribute n ame="defau ltValueCom puted" typ e="xsd:str ing" /> | |||||
434 | </xs d:complexT ype> | |||||
435 | </ xsd:elemen t> | |||||
436 | ||||||
437 | <x sd:element name="dro pDefaultVa lue"> | |||||
438 | <xsd :complexTy pe> | |||||
439 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
440 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
441 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
442 | <xsd:a ttribute n ame="colum nDataType" type="xsd :string" / > | |||||
443 | </xs d:complexT ype> | |||||
444 | </ xsd:elemen t> | |||||
445 | ||||||
446 | <x sd:element name="loa dData"> | |||||
447 | <xsd :complexTy pe mixed=" true"> | |||||
448 | <xsd:s equence> | |||||
449 | <xsd:ele ment name= "column" m inOccurs=" 0" maxOccu rs="unboun ded"> | |||||
450 | <xsd:compl exType> | |||||
451 | <x sd:attribu te name="i ndex" type ="integerE xp" /> | |||||
452 | <x sd:attribu te name="h eader" typ e="xsd:str ing" /> | |||||
453 | <x sd:attribu te name="n ame" type= "xsd:strin g" /> | |||||
454 | <x sd:attribu te name="t ype" type= "xsd:strin g" /> | |||||
455 | <x sd:attribu te name="d efaultValu e" type="x sd:string" /> | |||||
456 | <x sd:attribu te name="d efaultValu eNumeric" type="xsd: string" /> | |||||
457 | <x sd:attribu te name="d efaultValu eDate" typ e="xsd:str ing" /> | |||||
458 | <x sd:attribu te name="d efaultValu eBoolean" type="bool eanExp" /> | |||||
459 | <x sd:attribu te name="d efaultValu eComputed" type="xsd :string" / > | |||||
460 | </xsd:comp lexType> | |||||
461 | </xsd:el ement> | |||||
462 | </xsd: sequence> | |||||
463 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
464 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
465 | <xsd:a ttribute n ame="file" type="xsd :string" / > | |||||
466 | <xsd:a ttribute n ame="encod ing" type= "xsd:strin g" default ="UTF-8"/> | |||||
467 | <xsd:a ttribute n ame="separ ator" type ="xsd:stri ng" defaul t=","/> | |||||
468 | <xsd:a ttribute n ame="quotc har" type= "xsd:strin g" default ="""/ > | |||||
469 | </xs d:complexT ype> | |||||
470 | </ xsd:elemen t> | |||||
471 | ||||||
472 | <x sd:element name="loa dUpdateDat a"> | |||||
473 | <xsd :complexTy pe mixed=" true"> | |||||
474 | <xsd:s equence> | |||||
475 | <xsd:ele ment name= "column" m inOccurs=" 0" maxOccu rs="unboun ded"> | |||||
476 | <xsd:compl exType> | |||||
477 | <x sd:attribu te name="i ndex" type ="integerE xp" /> | |||||
478 | <x sd:attribu te name="h eader" typ e="xsd:str ing" /> | |||||
479 | <x sd:attribu te name="n ame" type= "xsd:strin g" /> | |||||
480 | <x sd:attribu te name="t ype" type= "xsd:strin g" /> | |||||
481 | <x sd:attribu te name="d efaultValu e" type="x sd:string" /> | |||||
482 | <x sd:attribu te name="d efaultValu eNumeric" type="xsd: string" /> | |||||
483 | <x sd:attribu te name="d efaultValu eDate" typ e="xsd:str ing" /> | |||||
484 | <x sd:attribu te name="d efaultValu eBoolean" type="bool eanExp" /> | |||||
485 | <x sd:attribu te name="d efaultValu eComputed" type="xsd :string" / > | |||||
486 | </xsd:comp lexType> | |||||
487 | </xsd:el ement> | |||||
488 | </xsd: sequence> | |||||
489 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
490 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
491 | <xsd:a ttribute n ame="file" type="xsd :string" / > | |||||
492 | <xsd:a ttribute n ame="encod ing" type= "xsd:strin g" default ="UTF-8"/> | |||||
493 | <xsd:a ttribute n ame="prima ryKey" typ e="xsd:str ing" use=" required" /> | |||||
494 | <xsd:a ttribute n ame="separ ator" type ="xsd:stri ng" defaul t=","/> | |||||
495 | <xsd:a ttribute n ame="quotc har" type= "xsd:strin g" default ="""/ > | |||||
496 | </xs d:complexT ype> | |||||
497 | </ xsd:elemen t> | |||||
498 | ||||||
499 | <x sd:simpleT ype name=" fkCascadeA ctionOptio ns"> | |||||
500 | <xsd :restricti on base="x sd:token"> | |||||
501 | <xsd:e numeration value="CA SCADE"></x sd:enumera tion> | |||||
502 | <xsd:e numeration value="SE T NULL"></ xsd:enumer ation> | |||||
503 | <xsd:e numeration value="SE T DEFAULT" ></xsd:enu meration> | |||||
504 | <xsd:e numeration value="RE STRICT"></ xsd:enumer ation> | |||||
505 | <xsd:e numeration value="NO ACTION">< /xsd:enume ration> | |||||
506 | </xs d:restrict ion> | |||||
507 | </ xsd:simple Type> | |||||
508 | ||||||
509 | <x sd:attribu teGroup na me="addFor eignKeyCon straintAtt rib"> | |||||
510 | <xsd :attribute name="bas eTableSche maName" ty pe="xsd:st ring" /> | |||||
511 | <xsd :attribute name="bas eTableName " type="xs d:string" | |||||
512 | use="r equired" / > | |||||
513 | <xsd :attribute name="bas eColumnNam es" type=" xsd:string " | |||||
514 | use="r equired" / > | |||||
515 | <xsd :attribute name="con straintNam e" type="x sd:string" | |||||
516 | use="r equired" / > | |||||
517 | <xsd :attribute name="ref erencedTab leSchemaNa me" type=" xsd:string " /> | |||||
518 | <xsd :attribute name="ref erencedTab leName" ty pe="xsd:st ring" | |||||
519 | use="r equired" / > | |||||
520 | <xsd :attribute name="ref erencedCol umnNames" type="xsd: string" | |||||
521 | use="r equired" / > | |||||
522 | <xsd :attribute name="def errable" t ype="boole anExp" /> | |||||
523 | <xsd :attribute name="ini tiallyDefe rred" type ="booleanE xp" /> | |||||
524 | <xsd :attribute name="del eteCascade " type="bo oleanExp" /> | |||||
525 | <xsd :attribute name="onD elete" typ e="fkCasca deActionOp tions" /> | |||||
526 | <xsd :attribute name="onU pdate" typ e="fkCasca deActionOp tions" /> | |||||
527 | <xsd :attribute name="ref erencesUni queColumn" type="boo leanExp" / > | |||||
528 | </ xsd:attrib uteGroup> | |||||
529 | ||||||
530 | <x sd:attribu teGroup na me="addNot NullConstr aintAttrib "> | |||||
531 | <xsd :attribute name="sch emaName" t ype="xsd:s tring" /> | |||||
532 | <xsd :attribute name="tab leName" ty pe="xsd:st ring" use= "required" /> | |||||
533 | <xsd :attribute name="col umnName" t ype="xsd:s tring" use ="required " /> | |||||
534 | <xsd :attribute name="def aultNullVa lue" type= "xsd:strin g" /> | |||||
535 | <xsd :attribute name="col umnDataTyp e" type="x sd:string" /> | |||||
536 | </ xsd:attrib uteGroup> | |||||
537 | ||||||
538 | ||||||
539 | <x sd:element name="add NotNullCon straint"> | |||||
540 | <xsd :complexTy pe> | |||||
541 | <xsd:a ttributeGr oup ref="a ddNotNullC onstraintA ttrib" /> | |||||
542 | </xs d:complexT ype> | |||||
543 | </ xsd:elemen t> | |||||
544 | ||||||
545 | <x sd:element name="add ForeignKey Constraint "> | |||||
546 | <xsd :complexTy pe> | |||||
547 | <xsd:a ttributeGr oup ref="a ddForeignK eyConstrai ntAttrib" /> | |||||
548 | </xs d:complexT ype> | |||||
549 | </ xsd:elemen t> | |||||
550 | ||||||
551 | <x sd:attribu teGroup na me="dbmsAt trib"> | |||||
552 | <xsd :attribute name="typ e" type="x sd:string" use="requ ired" /> | |||||
553 | </ xsd:attrib uteGroup> | |||||
554 | ||||||
555 | <x sd:element name="dbm s"> | |||||
556 | <xsd :complexTy pe> | |||||
557 | <xsd:a ttributeGr oup ref="d bmsAttrib" /> | |||||
558 | </xs d:complexT ype> | |||||
559 | </ xsd:elemen t> | |||||
560 | ||||||
561 | <x sd:element name="cha ngeSetExec uted"> | |||||
562 | <xsd :complexTy pe> | |||||
563 | <xsd:a ttribute n ame="id" t ype="xsd:s tring" use ="required " /> | |||||
564 | <xsd:a ttribute n ame="autho r" type="x sd:string" use="requ ired" /> | |||||
565 | <xsd:a ttribute n ame="chang eLogFile" type="xsd: string" | |||||
566 | use="req uired" /> | |||||
567 | </xs d:complexT ype> | |||||
568 | </ xsd:elemen t> | |||||
569 | ||||||
570 | <x sd:element name="tab leExists"> | |||||
571 | <xsd :complexTy pe> | |||||
572 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
573 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
574 | </xs d:complexT ype> | |||||
575 | </ xsd:elemen t> | |||||
576 | ||||||
577 | <x sd:element name="col umnExists" > | |||||
578 | <xsd :complexTy pe> | |||||
579 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
580 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
581 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
582 | </xs d:complexT ype> | |||||
583 | </ xsd:elemen t> | |||||
584 | ||||||
585 | <x sd:element name="seq uenceExist s"> | |||||
586 | <xsd :complexTy pe> | |||||
587 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
588 | <xsd:a ttribute n ame="seque nceName" t ype="xsd:s tring" | |||||
589 | use="req uired" /> | |||||
590 | </xs d:complexT ype> | |||||
591 | </ xsd:elemen t> | |||||
592 | ||||||
593 | <x sd:element name="for eignKeyCon straintExi sts"> | |||||
594 | <xsd :complexTy pe> | |||||
595 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
596 | <xsd:a ttribute n ame="forei gnKeyTable Name" type ="xsd:stri ng" /> | |||||
597 | <xsd:a ttribute n ame="forei gnKeyName" type="xsd :string" | |||||
598 | use="req uired" /> | |||||
599 | </xs d:complexT ype> | |||||
600 | </ xsd:elemen t> | |||||
601 | ||||||
602 | <x sd:element name="ind exExists"> | |||||
603 | <xsd :complexTy pe> | |||||
604 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
605 | <xsd:a ttribute n ame="index Name" type ="xsd:stri ng"/> | |||||
606 | <xsd:att ribute nam e="tableNa me" type=" xsd:string " /> | |||||
607 | <xsd:att ribute nam e="columnN ames" type ="xsd:stri ng" /> | |||||
608 | </xs d:complexT ype> | |||||
609 | </ xsd:elemen t> | |||||
610 | ||||||
611 | <x sd:element name="cha ngeLogProp ertyDefine d"> | |||||
612 | <xsd :complexTy pe> | |||||
613 | <xsd:a ttribute n ame="prope rty" type= "xsd:strin g" use="re quired" /> | |||||
614 | <xsd:a ttribute n ame="value " type="xs d:string" /> | |||||
615 | </xs d:complexT ype> | |||||
616 | </ xsd:elemen t> | |||||
617 | ||||||
618 | <x sd:element name="pri maryKeyExi sts"> | |||||
619 | <xsd :complexTy pe> | |||||
620 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
621 | <xsd:a ttribute n ame="prima ryKeyName" type="xsd :string" / > | |||||
622 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" /> | |||||
623 | </xs d:complexT ype> | |||||
624 | </ xsd:elemen t> | |||||
625 | ||||||
626 | <x sd:element name="vie wExists"> | |||||
627 | <xsd :complexTy pe> | |||||
628 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
629 | <xsd:a ttribute n ame="viewN ame" type= "xsd:strin g" use="re quired" /> | |||||
630 | </xs d:complexT ype> | |||||
631 | </ xsd:elemen t> | |||||
632 | ||||||
633 | <x sd:element name="sql Check"> | |||||
634 | <xsd :complexTy pe mixed=" true"> | |||||
635 | <xsd:a ttribute n ame="expec tedResult" type="xsd :string" | |||||
636 | use="req uired" /> | |||||
637 | </xs d:complexT ype> | |||||
638 | </ xsd:elemen t> | |||||
639 | ||||||
640 | <x sd:element name="cus tomPrecond ition"> | |||||
641 | <xsd :complexTy pe> | |||||
642 | <xsd:s equence> | |||||
643 | <xsd:ele ment name= "param" mi nOccurs="0 " maxOccur s="unbound ed"> | |||||
644 | <xsd:compl exType> | |||||
645 | <x sd:attribu te name="n ame" type= "xsd:strin g" use="re quired" /> | |||||
646 | <x sd:attribu te name="v alue" type ="xsd:stri ng" use="r equired" / > | |||||
647 | </xsd:comp lexType> | |||||
648 | </xsd:el ement> | |||||
649 | </xsd: sequence> | |||||
650 | <xsd:a ttribute n ame="class Name" type ="xsd:stri ng" use="r equired" / > | |||||
651 | </xs d:complexT ype> | |||||
652 | </ xsd:elemen t> | |||||
653 | ||||||
654 | <x sd:element name="and "> | |||||
655 | <xsd :complexTy pe> | |||||
656 | <xsd:c hoice> | |||||
657 | <xsd:gro up ref="Pr eCondition Children" minOccurs= "1" | |||||
658 | maxOccurs= "unbounded " /> | |||||
659 | </xsd: choice> | |||||
660 | </xs d:complexT ype> | |||||
661 | </ xsd:elemen t> | |||||
662 | ||||||
663 | <x sd:element name="or" > | |||||
664 | <xsd :complexTy pe> | |||||
665 | <xsd:c hoice> | |||||
666 | <xsd:gro up ref="Pr eCondition Children" minOccurs= "1" | |||||
667 | maxOccurs= "unbounded " /> | |||||
668 | </xsd: choice> | |||||
669 | </xs d:complexT ype> | |||||
670 | </ xsd:elemen t> | |||||
671 | ||||||
672 | <x sd:element name="not "> | |||||
673 | <xsd :complexTy pe> | |||||
674 | <xsd:c hoice> | |||||
675 | <xsd:gro up ref="Pr eCondition Children" minOccurs= "1" | |||||
676 | maxOccurs= "unbounded " /> | |||||
677 | </xsd: choice> | |||||
678 | </xs d:complexT ype> | |||||
679 | </ xsd:elemen t> | |||||
680 | ||||||
681 | <x sd:attribu teGroup na me="runnin gAsAttrib" > | |||||
682 | <xsd :attribute name="use rname" typ e="xsd:str ing" use=" required" /> | |||||
683 | </ xsd:attrib uteGroup> | |||||
684 | ||||||
685 | <x sd:element name="run ningAs"> | |||||
686 | <xsd :complexTy pe> | |||||
687 | <xsd:a ttributeGr oup ref="r unningAsAt trib" /> | |||||
688 | </xs d:complexT ype> | |||||
689 | </ xsd:elemen t> | |||||
690 | ||||||
691 | <x sd:attribu teGroup na me="dropFo reignKeyCo nstraintAt trib"> | |||||
692 | <xsd :attribute name="bas eTableSche maName" ty pe="xsd:st ring" /> | |||||
693 | <xsd :attribute name="bas eTableName " type="xs d:string" | |||||
694 | use="r equired" / > | |||||
695 | <xsd :attribute name="con straintNam e" type="x sd:string" /> | |||||
696 | </ xsd:attrib uteGroup> | |||||
697 | ||||||
698 | <x sd:element name="dro pForeignKe yConstrain t"> | |||||
699 | <xsd :complexTy pe> | |||||
700 | <xsd:a ttributeGr oup ref="d ropForeign KeyConstra intAttrib" /> | |||||
701 | </xs d:complexT ype> | |||||
702 | </ xsd:elemen t> | |||||
703 | ||||||
704 | <x sd:attribu teGroup na me="dropAl lForeignKe yConstrain tsAttrib"> | |||||
705 | <xsd :attribute name="bas eTableSche maName" ty pe="xsd:st ring" /> | |||||
706 | <xsd :attribute name="bas eTableName " type="xs d:string" | |||||
707 | use="r equired" / > | |||||
708 | </ xsd:attrib uteGroup> | |||||
709 | ||||||
710 | <x sd:element name="dro pAllForeig nKeyConstr aints"> | |||||
711 | <xsd :complexTy pe> | |||||
712 | <xsd:a ttributeGr oup ref="d ropAllFore ignKeyCons traintsAtt rib" /> | |||||
713 | </xs d:complexT ype> | |||||
714 | </ xsd:elemen t> | |||||
715 | ||||||
716 | <x sd:element name="dro pNotNullCo nstraint"> | |||||
717 | <xsd :complexTy pe> | |||||
718 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
719 | <xsd:a ttribute n ame="table Name" type ="xsd:stri ng" use="r equired" / > | |||||
720 | <xsd:a ttribute n ame="colum nName" typ e="xsd:str ing" use=" required" /> | |||||
721 | <xsd:a ttribute n ame="colum nDataType" type="xsd :string" / > | |||||
722 | </xs d:complexT ype> | |||||
723 | </ xsd:elemen t> | |||||
724 | ||||||
725 | ||||||
726 | <x sd:element name="con straints"> | |||||
727 | <xsd :complexTy pe> | |||||
728 | <xsd:a ttributeGr oup ref="c onstraints Attributes " /> | |||||
729 | </xs d:complexT ype> | |||||
730 | </ xsd:elemen t> | |||||
731 | ||||||
732 | ||||||
733 | <x sd:element name="col umn"> | |||||
734 | <xsd :complexTy pe mixed=" true"> | |||||
735 | <xsd:s equence> | |||||
736 | <xsd:ele ment ref=" constraint s" minOccu rs="0" /> | |||||
737 | </xsd: sequence> | |||||
738 | <xsd:a ttributeGr oup ref="c olumn" /> | |||||
739 | </xs d:complexT ype> | |||||
740 | </ xsd:elemen t> | |||||
741 | ||||||
742 | <! -- Childre n for crea teTable -- > | |||||
743 | <x sd:element name="cre ateTable"> | |||||
744 | <xsd :complexTy pe> | |||||
745 | <xsd:s equence> | |||||
746 | <xsd:ele ment ref=" column" mi nOccurs="1 " maxOccur s="unbound ed" /> | |||||
747 | </xsd: sequence> | |||||
748 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
749 | <xsd:att ribute nam e="tablesp ace" type= "xsd:strin g" /> | |||||
750 | <xsd:a ttribute n ame="remar ks" type=" xsd:string " /> | |||||
751 | </xs d:complexT ype> | |||||
752 | </ xsd:elemen t> | |||||
753 | ||||||
754 | <! -- Childre n for crea teView --> | |||||
755 | <x sd:element name="cre ateView"> | |||||
756 | <xsd :complexTy pe> | |||||
757 | <xsd:s impleConte nt> | |||||
758 | <xsd:ext ension bas e="xsd:str ing"> | |||||
759 | <xsd:attri bute name= "schemaNam e" type="x sd:string" /> | |||||
760 | <xsd:attri bute name= "viewName" type="xsd :string" u se="requir ed" /> | |||||
761 | <xsd:attri bute name= "replaceIf Exists" ty pe="boolea nExp" /> | |||||
762 | </xsd:ex tension> | |||||
763 | </xsd: simpleCont ent> | |||||
764 | </xs d:complexT ype> | |||||
765 | </ xsd:elemen t> | |||||
766 | ||||||
767 | <! -- Childre n for inse rt --> | |||||
768 | <x sd:element name="ins ert"> | |||||
769 | <xsd :complexTy pe> | |||||
770 | <xsd:s equence> | |||||
771 | <xsd:ele ment ref=" column" ma xOccurs="u nbounded" /> | |||||
772 | </xsd: sequence> | |||||
773 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
774 | </xs d:complexT ype> | |||||
775 | </ xsd:elemen t> | |||||
776 | ||||||
777 | <x sd:element name="upd ate"> | |||||
778 | <xsd :complexTy pe mixed=" true"> | |||||
779 | <xsd:s equence> | |||||
780 | <xsd:ele ment ref=" column" mi nOccurs="1 " maxOccur s="unbound ed" /> | |||||
781 | <xsd:ele ment name= "where" mi nOccurs="0 " maxOccur s="1" /> | |||||
782 | </xsd: sequence> | |||||
783 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
784 | </xs d:complexT ype> | |||||
785 | </ xsd:elemen t> | |||||
786 | ||||||
787 | <x sd:element name="del ete"> | |||||
788 | <xsd :complexTy pe mixed=" true"> | |||||
789 | <xsd:s equence> | |||||
790 | <xsd:ele ment name= "where" mi nOccurs="0 " maxOccur s="1" /> | |||||
791 | </xsd: sequence> | |||||
792 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
793 | </xs d:complexT ype> | |||||
794 | </ xsd:elemen t> | |||||
795 | ||||||
796 | <! -- Childre n for addC olum --> | |||||
797 | <x sd:element name="add Column"> | |||||
798 | <xsd :complexTy pe> | |||||
799 | <xsd:s equence> | |||||
800 | <xsd:ele ment ref=" column" mi nOccurs="1 " maxOccur s="unbound ed" /> | |||||
801 | </xsd: sequence> | |||||
802 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
803 | </xs d:complexT ype> | |||||
804 | </ xsd:elemen t> | |||||
805 | ||||||
806 | <x sd:element name="rol lback"> | |||||
807 | <xsd :complexTy pe mixed=" true"> | |||||
808 | <xsd:c hoice> | |||||
809 | <xsd:gro up ref="ch angeSetChi ldren" min Occurs="0" | |||||
810 | maxOccurs= "unbounded " /> | |||||
811 | </xsd: choice> | |||||
812 | <xsd:a ttribute n ame="chang eSetPath" type="xsd: string" /> | |||||
813 | <xsd:a ttribute n ame="chang eSetAuthor " type="xs d:string" /> | |||||
814 | <xsd:a ttribute n ame="chang eSetId" ty pe="xsd:st ring" /> | |||||
815 | </xs d:complexT ype> | |||||
816 | </ xsd:elemen t> | |||||
817 | ||||||
818 | <! -- comment --> | |||||
819 | <x sd:element name="com ment" type ="xsd:stri ng" /> | |||||
820 | ||||||
821 | <! -- sql --> | |||||
822 | <x sd:element name="sql "> | |||||
823 | <xsd :complexTy pe mixed=" true"> | |||||
824 | <xsd:s equence> | |||||
825 | <xsd:ele ment ref=" comment" m inOccurs=" 0" maxOccu rs="1" /> | |||||
826 | </xsd: sequence> | |||||
827 | <xsd:a ttribute n ame="strip Comments" type="bool eanExp" /> | |||||
828 | <xsd:a ttribute n ame="split Statements " type="bo oleanExp" /> | |||||
829 | <xsd:a ttribute n ame="endDe limiter" t ype="xsd:s tring" /> | |||||
830 | </xs d:complexT ype> | |||||
831 | </ xsd:elemen t> | |||||
832 | ||||||
833 | <x sd:element name="cre ateProcedu re"> | |||||
834 | <xsd :complexTy pe mixed=" true"> | |||||
835 | <xsd:s equence> | |||||
836 | <xsd:ele ment ref=" comment" m inOccurs=" 0" maxOccu rs="1" /> | |||||
837 | </xsd: sequence> | |||||
838 | </xs d:complexT ype> | |||||
839 | </ xsd:elemen t> | |||||
840 | ||||||
841 | <x sd:element name="exe cuteComman d"> | |||||
842 | <xsd :complexTy pe> | |||||
843 | <xsd:s equence> | |||||
844 | <xsd:ele ment name= "arg" minO ccurs="0" maxOccurs= "unbounded "> | |||||
845 | <xsd:compl exType> | |||||
846 | <x sd:attribu te name="v alue" type ="xsd:stri ng" use="r equired" / > | |||||
847 | </xsd:comp lexType> | |||||
848 | </xsd:el ement> | |||||
849 | </xsd: sequence> | |||||
850 | <xsd:a ttribute n ame="execu table" typ e="xsd:str ing" use=" required" /> | |||||
851 | <xsd:a ttribute n ame="os" t ype="xsd:s tring" /> | |||||
852 | </xs d:complexT ype> | |||||
853 | </ xsd:elemen t> | |||||
854 | ||||||
855 | <x sd:element name="sql File"> | |||||
856 | <xsd :complexTy pe> | |||||
857 | <xsd:a ttribute n ame="path" type="xsd :string" u se="requir ed" /> | |||||
858 | <xsd:a ttribute n ame="strip Comments" type="bool eanExp" /> | |||||
859 | <xsd:a ttribute n ame="split Statements " type="bo oleanExp" /> | |||||
860 | <xsd:a ttribute n ame="encod ing" type= "xsd:strin g" default ="UTF-8"/> | |||||
861 | <xsd:a ttribute n ame="endDe limiter" t ype="xsd:s tring" /> | |||||
862 | <xsd:att ribute nam e="relativ eToChangel ogFile" ty pe="boolea nExp" /> | |||||
863 | </xs d:complexT ype> | |||||
864 | </ xsd:elemen t> | |||||
865 | ||||||
866 | <x sd:element name="tag Database"> | |||||
867 | <xsd :complexTy pe> | |||||
868 | <xsd:a ttribute n ame="tag" type="xsd: string" us e="require d" /> | |||||
869 | </xs d:complexT ype> | |||||
870 | </ xsd:elemen t> | |||||
871 | ||||||
872 | <x sd:element name="sto p"> | |||||
873 | <xsd :complexTy pe mixed=" true" /> | |||||
874 | </ xsd:elemen t> | |||||
875 | ||||||
876 | <! -- renameT able --> | |||||
877 | <x sd:element name="ren ameTable"> | |||||
878 | <xsd :complexTy pe> | |||||
879 | <xsd:a ttributeGr oup ref="r enameTable Attributes " /> | |||||
880 | </xs d:complexT ype> | |||||
881 | </ xsd:elemen t> | |||||
882 | ||||||
883 | <x sd:element name="ren ameView"> | |||||
884 | <xsd :complexTy pe> | |||||
885 | <xsd:a ttributeGr oup ref="r enameViewA ttributes" /> | |||||
886 | </xs d:complexT ype> | |||||
887 | </ xsd:elemen t> | |||||
888 | ||||||
889 | <! -- dropTab le --> | |||||
890 | <x sd:element name="dro pTable"> | |||||
891 | <xsd :complexTy pe> | |||||
892 | <xsd:a ttributeGr oup ref="d ropTableAt tributes" /> | |||||
893 | </xs d:complexT ype> | |||||
894 | </ xsd:elemen t> | |||||
895 | ||||||
896 | <x sd:element name="dro pView"> | |||||
897 | <xsd :complexTy pe> | |||||
898 | <xsd:a ttribute n ame="viewN ame" type= "xsd:strin g" use="re quired" /> | |||||
899 | <xsd:a ttribute n ame="schem aName" typ e="xsd:str ing" /> | |||||
900 | </xs d:complexT ype> | |||||
901 | </ xsd:elemen t> | |||||
902 | ||||||
903 | <! -- renameC olumn --> | |||||
904 | <x sd:element name="ren ameColumn" > | |||||
905 | <xsd :complexTy pe> | |||||
906 | <xsd:a ttributeGr oup ref="r enameColum nAttribute s" /> | |||||
907 | </xs d:complexT ype> | |||||
908 | </ xsd:elemen t> | |||||
909 | ||||||
910 | <x sd:element name="dro pColumn"> | |||||
911 | <xsd :complexTy pe> | |||||
912 | <xsd:a ttributeGr oup ref="d ropColumnA ttributes" /> | |||||
913 | </xs d:complexT ype> | |||||
914 | </ xsd:elemen t> | |||||
915 | ||||||
916 | <x sd:element name="mer geColumns" > | |||||
917 | <xsd :complexTy pe> | |||||
918 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
919 | <xsd:a ttribute n ame="colum n1Name" ty pe="xsd:st ring" | |||||
920 | use="req uired" /> | |||||
921 | <xsd:a ttribute n ame="joinS tring" typ e="xsd:str ing" use=" required" /> | |||||
922 | <xsd:a ttribute n ame="colum n2Name" ty pe="xsd:st ring" | |||||
923 | use="req uired" /> | |||||
924 | <xsd:a ttribute n ame="final ColumnName " type="xs d:string" | |||||
925 | use="req uired" /> | |||||
926 | <xsd:a ttribute n ame="final ColumnType " type="xs d:string" | |||||
927 | use="req uired" /> | |||||
928 | </xs d:complexT ype> | |||||
929 | </ xsd:elemen t> | |||||
930 | ||||||
931 | <x sd:group n ame="where Clause"> | |||||
932 | <xsd :sequence> | |||||
933 | <xsd:e lement nam e="whereCl ause" type ="xsd:stri ng" | |||||
934 | minOccur s="0" maxO ccurs="unb ounded" /> | |||||
935 | </xs d:sequence > | |||||
936 | </ xsd:group> | |||||
937 | ||||||
938 | <x sd:element name="cre ateSequenc e"> | |||||
939 | <xsd :complexTy pe> | |||||
940 | <xsd:a ttributeGr oup ref="s equenceAtt ributes" / > | |||||
941 | <xsd:att ribute nam e="cycle" type="bool eanExp"> | |||||
942 | <xsd :annotatio n> | |||||
943 | <xsd:docum entation> | |||||
944 | true f or a cycli ng sequenc e, false f or a non-c ycling seq uence. | |||||
945 | Defaul t is false . | |||||
946 | </xsd:docu mentation> | |||||
947 | </xs d:annotati on> | |||||
948 | </xsd:at tribute> | |||||
949 | </xs d:complexT ype> | |||||
950 | </ xsd:elemen t> | |||||
951 | ||||||
952 | <x sd:element name="alt erSequence "> | |||||
953 | <xsd :complexTy pe> | |||||
954 | <xsd:a ttributeGr oup ref="s equenceAtt ributes" / > | |||||
955 | </xs d:complexT ype> | |||||
956 | </ xsd:elemen t> | |||||
957 | ||||||
958 | <x sd:element name="dro pSequence" > | |||||
959 | <xsd :complexTy pe> | |||||
960 | <xsd:a ttributeGr oup ref="s equenceAtt ributes" / > | |||||
961 | </xs d:complexT ype> | |||||
962 | </ xsd:elemen t> | |||||
963 | ||||||
964 | <x sd:element name="cre ateIndex"> | |||||
965 | <xsd :complexTy pe> | |||||
966 | <xsd:s equence> | |||||
967 | <xsd:ele ment ref=" column" ma xOccurs="u nbounded" /> | |||||
968 | </xsd: sequence> | |||||
969 | <xsd:a ttributeGr oup ref="c reateIndex " /> | |||||
970 | </xs d:complexT ype> | |||||
971 | </ xsd:elemen t> | |||||
972 | ||||||
973 | <x sd:element name="dro pIndex"> | |||||
974 | <xsd :complexTy pe> | |||||
975 | <xsd:a ttributeGr oup ref="t ableNameAt tribute" / > | |||||
976 | <xsd:a ttributeGr oup ref="i ndexName" /> | |||||
977 | <xsd:att ribute nam e="associa tedWith" t ype="xsd:s tring" use ="optional " /> | |||||
978 | </xs d:complexT ype> | |||||
979 | </ xsd:elemen t> | |||||
980 | ||||||
981 | <x sd:element name="cus tomChange" > | |||||
982 | <xsd :complexTy pe> | |||||
983 | <xsd:s equence> | |||||
984 | <xsd:ele ment name= "param" mi nOccurs="0 " maxOccur s="unbound ed"> | |||||
985 | <xsd:compl exType mix ed="true"> | |||||
986 | <x sd:attribu te name="n ame" type= "xsd:strin g" use="re quired" /> | |||||
987 | <x sd:attribu te name="v alue" type ="xsd:stri ng" /> | |||||
988 | </xsd:comp lexType> | |||||
989 | </xsd:el ement> | |||||
990 | </xsd: sequence> | |||||
991 | <xsd:a ttribute n ame="class " type="xs d:string" use="requi red" /> | |||||
992 | <xsd:a nyAttribut e processC ontents="l ax" /> | |||||
993 | </xs d:complexT ype> | |||||
994 | </ xsd:elemen t> | |||||
995 | ||||||
996 | ||||||
997 | <! -- Childre n for chan geSet --> | |||||
998 | <x sd:group n ame="chang eSetChildr en"> | |||||
999 | <xsd :choice> | |||||
1000 | <xsd:e lement ref ="comment" maxOccurs ="1" /> | |||||
1001 | <xsd:e lement ref ="createTa ble" maxOc curs="unbo unded" /> | |||||
1002 | <xsd:e lement ref ="dropTabl e" maxOccu rs="unboun ded" /> | |||||
1003 | <xsd:e lement ref ="createVi ew" maxOcc urs="unbou nded" /> | |||||
1004 | <xsd:e lement ref ="renameVi ew" maxOcc urs="unbou nded" /> | |||||
1005 | <xsd:e lement ref ="dropView " maxOccur s="unbound ed" /> | |||||
1006 | <xsd:e lement ref ="insert" maxOccurs= "unbounded " /> | |||||
1007 | <xsd:e lement ref ="addColum n" maxOccu rs="unboun ded" /> | |||||
1008 | <xsd:e lement ref ="sql" max Occurs="un bounded" / > | |||||
1009 | <xsd:e lement ref ="createPr ocedure" m axOccurs=" unbounded" /> | |||||
1010 | <xsd:e lement ref ="sqlFile" maxOccurs ="unbounde d" /> | |||||
1011 | <xsd:e lement ref ="renameTa ble" maxOc curs="unbo unded" /> | |||||
1012 | <xsd:e lement ref ="renameCo lumn" maxO ccurs="unb ounded" /> | |||||
1013 | <xsd:e lement ref ="dropColu mn" maxOcc urs="unbou nded" /> | |||||
1014 | <xsd:e lement ref ="mergeCol umns" maxO ccurs="unb ounded" /> | |||||
1015 | <xsd:e lement ref ="modifyDa taType" ma xOccurs="u nbounded" /> | |||||
1016 | <xsd:e lement ref ="createSe quence" ma xOccurs="u nbounded" /> | |||||
1017 | <xsd:e lement ref ="alterSeq uence" max Occurs="un bounded" / > | |||||
1018 | <xsd:e lement ref ="dropSequ ence" maxO ccurs="unb ounded" /> | |||||
1019 | <xsd:e lement ref ="createIn dex" maxOc curs="unbo unded" /> | |||||
1020 | <xsd:e lement ref ="dropInde x" maxOccu rs="unboun ded" /> | |||||
1021 | <xsd:e lement ref ="addNotNu llConstrai nt" maxOcc urs="unbou nded" /> | |||||
1022 | <xsd:e lement ref ="dropNotN ullConstra int" maxOc curs="unbo unded" /> | |||||
1023 | <xsd:e lement ref ="addForei gnKeyConst raint" max Occurs="un bounded" / > | |||||
1024 | <xsd:e lement ref ="dropFore ignKeyCons traint" ma xOccurs="u nbounded" /> | |||||
1025 | <xsd:e lement ref ="dropAllF oreignKeyC onstraints " | |||||
1026 | maxOccur s="unbound ed" /> | |||||
1027 | <xsd:e lement ref ="addPrima ryKey" max Occurs="un bounded" / > | |||||
1028 | <xsd:e lement ref ="dropPrim aryKey" ma xOccurs="u nbounded" /> | |||||
1029 | <xsd:e lement ref ="addLooku pTable" ma xOccurs="u nbounded" /> | |||||
1030 | <xsd:e lement ref ="addAutoI ncrement" maxOccurs= "unbounded " /> | |||||
1031 | <xsd:e lement ref ="addDefau ltValue" m axOccurs=" unbounded" /> | |||||
1032 | <xsd:e lement ref ="dropDefa ultValue" maxOccurs= "unbounded " /> | |||||
1033 | <xsd:e lement ref ="addUniqu eConstrain t" maxOccu rs="unboun ded" /> | |||||
1034 | <xsd:e lement ref ="dropUniq ueConstrai nt" maxOcc urs="unbou nded" /> | |||||
1035 | <xsd:e lement ref ="customCh ange" maxO ccurs="unb ounded" /> | |||||
1036 | <xsd:e lement ref ="update" maxOccurs= "unbounded " /> | |||||
1037 | <xsd:e lement ref ="delete" maxOccurs= "unbounded " /> | |||||
1038 | <xsd:e lement ref ="loadData " maxOccur s="unbound ed" /> | |||||
1039 | <xsd:e lement ref ="loadUpda teData" ma xOccurs="u nbounded" /> | |||||
1040 | <xsd:e lement ref ="executeC ommand" ma xOccurs="u nbounded" /> | |||||
1041 | <xsd:e lement ref ="stop" ma xOccurs="u nbounded" /> | |||||
1042 | <xsd:e lement ref ="rollback " maxOccur s="1" /> | |||||
1043 | <xsd:a ny namespa ce="##othe r" process Contents=" lax" minOc curs="0" | |||||
1044 | maxOccur s="unbound ed" /> | |||||
1045 | </xs d:choice> | |||||
1046 | </ xsd:group> | |||||
1047 | ||||||
1048 | <! -- Childre n for Prec ondition - -> | |||||
1049 | <x sd:group n ame="PreCo nditionChi ldren"> | |||||
1050 | <xsd :sequence> | |||||
1051 | <xsd:c hoice> | |||||
1052 | <xsd:ele ment ref=" and" maxOc curs="unbo unded" /> | |||||
1053 | <xsd:ele ment ref=" or" maxOcc urs="unbou nded" /> | |||||
1054 | <xsd:ele ment ref=" not" maxOc curs="unbo unded" /> | |||||
1055 | <xsd:ele ment ref=" dbms" maxO ccurs="unb ounded" /> | |||||
1056 | <xsd:ele ment ref=" runningAs" maxOccurs ="unbounde d" /> | |||||
1057 | <xsd:ele ment ref=" changeSetE xecuted" m axOccurs=" unbounded" /> | |||||
1058 | <xsd:ele ment ref=" tableExist s" maxOccu rs="unboun ded" /> | |||||
1059 | <xsd:ele ment ref=" columnExis ts" maxOcc urs="unbou nded" /> | |||||
1060 | <xsd:ele ment ref=" sequenceEx ists" maxO ccurs="unb ounded" /> | |||||
1061 | <xsd:ele ment ref=" foreignKey Constraint Exists" ma xOccurs="u nbounded" /> | |||||
1062 | <xsd:ele ment ref=" indexExist s" maxOccu rs="unboun ded" /> | |||||
1063 | <xsd:ele ment ref=" primaryKey Exists" ma xOccurs="u nbounded" /> | |||||
1064 | <xsd:ele ment ref=" viewExists " maxOccur s="unbound ed" /> | |||||
1065 | <xsd:ele ment ref=" sqlCheck" maxOccurs= "unbounded " /> | |||||
1066 | <xsd:ele ment ref=" changeLogP ropertyDef ined" maxO ccurs="unb ounded" /> | |||||
1067 | <xsd:ele ment ref=" customPrec ondition" maxOccurs= "unbounded " /> | |||||
1068 | </xsd: choice> | |||||
1069 | </xs d:sequence > | |||||
1070 | ||||||
1071 | </ xsd:group> | |||||
1072 | </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.