|
sl@0
|
1 |
[wait]
|
|
sl@0
|
2 |
Sleep0=5000000
|
|
sl@0
|
3 |
EndBlock1=
|
|
sl@0
|
4 |
|
|
sl@0
|
5 |
[bur]
|
|
sl@0
|
6 |
BackupDir=c:\BackupArchive\
|
|
sl@0
|
7 |
IsPartial=1
|
|
sl@0
|
8 |
BaseOnly=1
|
|
sl@0
|
9 |
DriveList=c
|
|
sl@0
|
10 |
IDs=102827c7
|
|
sl@0
|
11 |
|
|
sl@0
|
12 |
[bur2]
|
|
sl@0
|
13 |
BackupDir=c:\BackupArchive\
|
|
sl@0
|
14 |
IsPartial=1
|
|
sl@0
|
15 |
BaseOnly=1
|
|
sl@0
|
16 |
DriveList=c
|
|
sl@0
|
17 |
IDs=102827c7, 102827c8
|
|
sl@0
|
18 |
|
|
sl@0
|
19 |
[setup]
|
|
sl@0
|
20 |
SPCreate0=
|
|
sl@0
|
21 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
22 |
CreateSP2=c:[102827c7]bur.db
|
|
sl@0
|
23 |
SPClose3=
|
|
sl@0
|
24 |
Exec4=create table names(pkey int, fname text, lname text, ref int);
|
|
sl@0
|
25 |
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
26 |
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
27 |
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
28 |
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
29 |
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
30 |
Close10=
|
|
sl@0
|
31 |
EndBlock11=
|
|
sl@0
|
32 |
|
|
sl@0
|
33 |
[check]
|
|
sl@0
|
34 |
Open0=c:[102827c7]bur.db
|
|
sl@0
|
35 |
//check the number of records is correct firstly
|
|
sl@0
|
36 |
Prepare1=select count(*) from names;
|
|
sl@0
|
37 |
ColumnIndex2=
|
|
sl@0
|
38 |
Next3=
|
|
sl@0
|
39 |
ColumnInt4=0,5
|
|
sl@0
|
40 |
St_Close5=
|
|
sl@0
|
41 |
//now check the data
|
|
sl@0
|
42 |
Prepare6=select * from names;
|
|
sl@0
|
43 |
ColumnIndex7=pkey
|
|
sl@0
|
44 |
ColumnIndex8=fname
|
|
sl@0
|
45 |
ColumnIndex9=lname
|
|
sl@0
|
46 |
ColumnIndex10=ref
|
|
sl@0
|
47 |
Next11=
|
|
sl@0
|
48 |
ColumnInt12=0,1
|
|
sl@0
|
49 |
ColumnTextL13=1,tom
|
|
sl@0
|
50 |
ColumnTextL14=2,jones
|
|
sl@0
|
51 |
ColumnInt15=3,2
|
|
sl@0
|
52 |
Next16=
|
|
sl@0
|
53 |
ColumnInt17=0,2
|
|
sl@0
|
54 |
ColumnTextL18=1,jim
|
|
sl@0
|
55 |
ColumnTextL19=2,davies
|
|
sl@0
|
56 |
ColumnInt20=3,1
|
|
sl@0
|
57 |
Next21=
|
|
sl@0
|
58 |
ColumnInt22=0,3
|
|
sl@0
|
59 |
ColumnTextL23=1,bob
|
|
sl@0
|
60 |
ColumnTextL24=2,smith
|
|
sl@0
|
61 |
ColumnInt25=3,1
|
|
sl@0
|
62 |
Next26=
|
|
sl@0
|
63 |
ColumnInt27=0,4
|
|
sl@0
|
64 |
ColumnTextL28=1,dave
|
|
sl@0
|
65 |
ColumnTextL29=2,house
|
|
sl@0
|
66 |
ColumnInt30=3,3
|
|
sl@0
|
67 |
Next31=
|
|
sl@0
|
68 |
ColumnInt32=0,5
|
|
sl@0
|
69 |
ColumnTextL33=1,jane
|
|
sl@0
|
70 |
ColumnTextL34=2,hobbs
|
|
sl@0
|
71 |
ColumnInt35=3,4
|
|
sl@0
|
72 |
Next36=
|
|
sl@0
|
73 |
St_Close37=
|
|
sl@0
|
74 |
Close38=
|
|
sl@0
|
75 |
EndBlock39=
|
|
sl@0
|
76 |
|
|
sl@0
|
77 |
[modify]
|
|
sl@0
|
78 |
Open0=c:[102827c7]bur.db
|
|
sl@0
|
79 |
Exec1=insert into names(pkey, fname, lname, ref) values(6, "extra1", "another", 4);
|
|
sl@0
|
80 |
Exec2=insert into names(pkey, fname, lname, ref) values(7, "extra2", "another", 4);
|
|
sl@0
|
81 |
Close3=
|
|
sl@0
|
82 |
EndBlock4=
|
|
sl@0
|
83 |
|
|
sl@0
|
84 |
[setup2]
|
|
sl@0
|
85 |
SPCreate0=
|
|
sl@0
|
86 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
87 |
CreateSP2=c:[102827c8]bur.db
|
|
sl@0
|
88 |
SPClose3=
|
|
sl@0
|
89 |
Exec4=create table names(pkey int, fname text, lname text, ref int);
|
|
sl@0
|
90 |
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
91 |
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
92 |
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
93 |
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
94 |
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
95 |
Close10=
|
|
sl@0
|
96 |
EndBlock11=
|
|
sl@0
|
97 |
|
|
sl@0
|
98 |
[check2]
|
|
sl@0
|
99 |
Open0=c:[102827c8]bur.db
|
|
sl@0
|
100 |
//check the number of records is correct firstly
|
|
sl@0
|
101 |
Prepare1=select count(*) from names;
|
|
sl@0
|
102 |
ColumnIndex2=
|
|
sl@0
|
103 |
Next3=
|
|
sl@0
|
104 |
ColumnInt4=0,5
|
|
sl@0
|
105 |
St_Close5=
|
|
sl@0
|
106 |
//now check the data
|
|
sl@0
|
107 |
Prepare6=select * from names;
|
|
sl@0
|
108 |
ColumnIndex7=pkey
|
|
sl@0
|
109 |
ColumnIndex8=fname
|
|
sl@0
|
110 |
ColumnIndex9=lname
|
|
sl@0
|
111 |
ColumnIndex10=ref
|
|
sl@0
|
112 |
Next11=
|
|
sl@0
|
113 |
ColumnInt12=0,1
|
|
sl@0
|
114 |
ColumnTextL13=1,tom
|
|
sl@0
|
115 |
ColumnTextL14=2,jones
|
|
sl@0
|
116 |
ColumnInt15=3,2
|
|
sl@0
|
117 |
Next16=
|
|
sl@0
|
118 |
ColumnInt17=0,2
|
|
sl@0
|
119 |
ColumnTextL18=1,jim
|
|
sl@0
|
120 |
ColumnTextL19=2,davies
|
|
sl@0
|
121 |
ColumnInt20=3,1
|
|
sl@0
|
122 |
Next21=
|
|
sl@0
|
123 |
ColumnInt22=0,3
|
|
sl@0
|
124 |
ColumnTextL23=1,bob
|
|
sl@0
|
125 |
ColumnTextL24=2,smith
|
|
sl@0
|
126 |
ColumnInt25=3,1
|
|
sl@0
|
127 |
Next26=
|
|
sl@0
|
128 |
ColumnInt27=0,4
|
|
sl@0
|
129 |
ColumnTextL28=1,dave
|
|
sl@0
|
130 |
ColumnTextL29=2,house
|
|
sl@0
|
131 |
ColumnInt30=3,3
|
|
sl@0
|
132 |
Next31=
|
|
sl@0
|
133 |
ColumnInt32=0,5
|
|
sl@0
|
134 |
ColumnTextL33=1,jane
|
|
sl@0
|
135 |
ColumnTextL34=2,hobbs
|
|
sl@0
|
136 |
ColumnInt35=3,4
|
|
sl@0
|
137 |
Next36=
|
|
sl@0
|
138 |
St_Close37=
|
|
sl@0
|
139 |
Close38=
|
|
sl@0
|
140 |
EndBlock39=
|
|
sl@0
|
141 |
|
|
sl@0
|
142 |
[setup3]
|
|
sl@0
|
143 |
SPCreate0=
|
|
sl@0
|
144 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
145 |
CreateSP2=c:[102827c7]bur1.db
|
|
sl@0
|
146 |
SPClose3=
|
|
sl@0
|
147 |
Exec4=create table nums(pkey int);
|
|
sl@0
|
148 |
Exec5=insert into nums(pkey) values(1);
|
|
sl@0
|
149 |
Exec6=insert into nums(pkey) values(2);
|
|
sl@0
|
150 |
Exec7=insert into nums(pkey) values(3);
|
|
sl@0
|
151 |
Exec8=insert into nums(pkey) values(4);
|
|
sl@0
|
152 |
Exec9=insert into nums(pkey) values(5);
|
|
sl@0
|
153 |
Close10=
|
|
sl@0
|
154 |
SPCreate11=
|
|
sl@0
|
155 |
SetDBPolicy12=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
156 |
CreateSP13=c:[102827c7]bur2.db
|
|
sl@0
|
157 |
SPClose14=
|
|
sl@0
|
158 |
Exec15=create table nums(pkey int);
|
|
sl@0
|
159 |
Exec16=insert into nums(pkey) values(6);
|
|
sl@0
|
160 |
Exec17=insert into nums(pkey) values(7);
|
|
sl@0
|
161 |
Exec18=insert into nums(pkey) values(8);
|
|
sl@0
|
162 |
Exec19=insert into nums(pkey) values(9);
|
|
sl@0
|
163 |
Exec20=insert into nums(pkey) values(10);
|
|
sl@0
|
164 |
Close21=
|
|
sl@0
|
165 |
SPCreate22=
|
|
sl@0
|
166 |
SetDBPolicy23=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
167 |
CreateSP24=c:[102827c7]bur3.db
|
|
sl@0
|
168 |
SPClose25=
|
|
sl@0
|
169 |
Exec26=create table nums(pkey int);
|
|
sl@0
|
170 |
Exec27=insert into nums(pkey) values(11);
|
|
sl@0
|
171 |
Exec28=insert into nums(pkey) values(12);
|
|
sl@0
|
172 |
Exec29=insert into nums(pkey) values(13);
|
|
sl@0
|
173 |
Exec30=insert into nums(pkey) values(14);
|
|
sl@0
|
174 |
Exec31=insert into nums(pkey) values(15);
|
|
sl@0
|
175 |
Close32=
|
|
sl@0
|
176 |
EndBlock33=
|
|
sl@0
|
177 |
|
|
sl@0
|
178 |
[check3]
|
|
sl@0
|
179 |
Open0=c:[102827c7]bur1.db
|
|
sl@0
|
180 |
//check the number of records is correct firstly
|
|
sl@0
|
181 |
Prepare1=select count(*) from nums;
|
|
sl@0
|
182 |
ColumnIndex2=
|
|
sl@0
|
183 |
Next3=
|
|
sl@0
|
184 |
ColumnInt4=0,5
|
|
sl@0
|
185 |
St_Close5=
|
|
sl@0
|
186 |
//now check the data
|
|
sl@0
|
187 |
Prepare6=select * from nums;
|
|
sl@0
|
188 |
ColumnIndex7=pkey
|
|
sl@0
|
189 |
Next8=
|
|
sl@0
|
190 |
ColumnInt9=0,1
|
|
sl@0
|
191 |
Next10=
|
|
sl@0
|
192 |
ColumnInt11=0,2
|
|
sl@0
|
193 |
Next12=
|
|
sl@0
|
194 |
ColumnInt13=0,3
|
|
sl@0
|
195 |
Next14=
|
|
sl@0
|
196 |
ColumnInt15=0,4
|
|
sl@0
|
197 |
Next16=
|
|
sl@0
|
198 |
ColumnInt17=0,5
|
|
sl@0
|
199 |
Next18=
|
|
sl@0
|
200 |
St_Close19=
|
|
sl@0
|
201 |
Close20=
|
|
sl@0
|
202 |
Open21=c:[102827c7]bur2.db
|
|
sl@0
|
203 |
//check the number of records is correct firstly
|
|
sl@0
|
204 |
Prepare22=select count(*) from nums;
|
|
sl@0
|
205 |
ColumnIndex23=
|
|
sl@0
|
206 |
Next24=
|
|
sl@0
|
207 |
ColumnInt25=0,5
|
|
sl@0
|
208 |
St_Close26=
|
|
sl@0
|
209 |
//now check the data
|
|
sl@0
|
210 |
Prepare27=select * from nums;
|
|
sl@0
|
211 |
ColumnIndex28=pkey
|
|
sl@0
|
212 |
Next29=
|
|
sl@0
|
213 |
ColumnInt30=0,6
|
|
sl@0
|
214 |
Next31=
|
|
sl@0
|
215 |
ColumnInt32=0,7
|
|
sl@0
|
216 |
Next33=
|
|
sl@0
|
217 |
ColumnInt34=0,8
|
|
sl@0
|
218 |
Next35=
|
|
sl@0
|
219 |
ColumnInt36=0,9
|
|
sl@0
|
220 |
Next37=
|
|
sl@0
|
221 |
ColumnInt38=0,10
|
|
sl@0
|
222 |
Next39=
|
|
sl@0
|
223 |
St_Close40=
|
|
sl@0
|
224 |
Close41=
|
|
sl@0
|
225 |
Open42=c:[102827c7]bur3.db
|
|
sl@0
|
226 |
//check the number of records is correct firstly
|
|
sl@0
|
227 |
Prepare43=select count(*) from nums;
|
|
sl@0
|
228 |
ColumnIndex44=
|
|
sl@0
|
229 |
Next45=
|
|
sl@0
|
230 |
ColumnInt46=0,5
|
|
sl@0
|
231 |
St_Close47=
|
|
sl@0
|
232 |
//now check the data
|
|
sl@0
|
233 |
Prepare48=select * from nums;
|
|
sl@0
|
234 |
ColumnIndex49=pkey
|
|
sl@0
|
235 |
Next50=
|
|
sl@0
|
236 |
ColumnInt51=0,11
|
|
sl@0
|
237 |
Next52=
|
|
sl@0
|
238 |
ColumnInt53=0,12
|
|
sl@0
|
239 |
Next54=
|
|
sl@0
|
240 |
ColumnInt55=0,13
|
|
sl@0
|
241 |
Next56=
|
|
sl@0
|
242 |
ColumnInt57=0,14
|
|
sl@0
|
243 |
Next58=
|
|
sl@0
|
244 |
ColumnInt59=0,15
|
|
sl@0
|
245 |
Next60=
|
|
sl@0
|
246 |
St_Close61=
|
|
sl@0
|
247 |
Close62=
|
|
sl@0
|
248 |
EndBlock63=
|
|
sl@0
|
249 |
|
|
sl@0
|
250 |
[setup4]
|
|
sl@0
|
251 |
SPCreate0=
|
|
sl@0
|
252 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
253 |
CreateSP2=c:[102827c7]118192
|
|
sl@0
|
254 |
SPClose3=
|
|
sl@0
|
255 |
Exec4=create table names(pkey int, fname text, lname text, ref int);
|
|
sl@0
|
256 |
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
257 |
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
258 |
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
259 |
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
260 |
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
261 |
Close10=
|
|
sl@0
|
262 |
EndBlock11=
|
|
sl@0
|
263 |
|
|
sl@0
|
264 |
[check4]
|
|
sl@0
|
265 |
Open0=c:[102827c7]118192
|
|
sl@0
|
266 |
//check the number of records is correct firstly
|
|
sl@0
|
267 |
Prepare1=select count(*) from names;
|
|
sl@0
|
268 |
ColumnIndex2=
|
|
sl@0
|
269 |
Next3=
|
|
sl@0
|
270 |
ColumnInt4=0,5
|
|
sl@0
|
271 |
St_Close5=
|
|
sl@0
|
272 |
//now check the data
|
|
sl@0
|
273 |
Prepare6=select * from names;
|
|
sl@0
|
274 |
ColumnIndex7=pkey
|
|
sl@0
|
275 |
ColumnIndex8=fname
|
|
sl@0
|
276 |
ColumnIndex9=lname
|
|
sl@0
|
277 |
ColumnIndex10=ref
|
|
sl@0
|
278 |
Next11=
|
|
sl@0
|
279 |
ColumnInt12=0,1
|
|
sl@0
|
280 |
ColumnTextL13=1,tom
|
|
sl@0
|
281 |
ColumnTextL14=2,jones
|
|
sl@0
|
282 |
ColumnInt15=3,2
|
|
sl@0
|
283 |
Next16=
|
|
sl@0
|
284 |
ColumnInt17=0,2
|
|
sl@0
|
285 |
ColumnTextL18=1,jim
|
|
sl@0
|
286 |
ColumnTextL19=2,davies
|
|
sl@0
|
287 |
ColumnInt20=3,1
|
|
sl@0
|
288 |
Next21=
|
|
sl@0
|
289 |
ColumnInt22=0,3
|
|
sl@0
|
290 |
ColumnTextL23=1,bob
|
|
sl@0
|
291 |
ColumnTextL24=2,smith
|
|
sl@0
|
292 |
ColumnInt25=3,1
|
|
sl@0
|
293 |
Next26=
|
|
sl@0
|
294 |
ColumnInt27=0,4
|
|
sl@0
|
295 |
ColumnTextL28=1,dave
|
|
sl@0
|
296 |
ColumnTextL29=2,house
|
|
sl@0
|
297 |
ColumnInt30=3,3
|
|
sl@0
|
298 |
Next31=
|
|
sl@0
|
299 |
ColumnInt32=0,5
|
|
sl@0
|
300 |
ColumnTextL33=1,jane
|
|
sl@0
|
301 |
ColumnTextL34=2,hobbs
|
|
sl@0
|
302 |
ColumnInt35=3,4
|
|
sl@0
|
303 |
Next36=
|
|
sl@0
|
304 |
St_Close37=
|
|
sl@0
|
305 |
Close38=
|
|
sl@0
|
306 |
EndBlock39=
|
|
sl@0
|
307 |
|
|
sl@0
|
308 |
|
|
sl@0
|
309 |
|