[bur]
BackupDir=c:\BackupArchive\
IsPartial=1
BaseOnly=1
DriveList=c
IDs=102827c7

[bur2]
BackupDir=c:\BackupArchive\
IsPartial=1
BaseOnly=1
DriveList=c
IDs=102827c7, 102827c8

[setup]
SPCreate0=
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
CreateSP2=c:[102827c7]bur.db
SPClose3=
Exec4=create table names(pkey int, fname text, lname text, ref int);
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
Close10=
EndBlock11=

[check]
Open0=c:[102827c7]bur.db
//check the number of records is correct firstly
Prepare1=select count(*) from names;
ColumnIndex2=
Next3=
ColumnInt4=0,5
St_Close5=
//now check the data
Prepare6=select * from names;
ColumnIndex7=pkey
ColumnIndex8=fname
ColumnIndex9=lname
ColumnIndex10=ref
Next11=
ColumnInt12=0,1
ColumnTextL13=1,tom
ColumnTextL14=2,jones
ColumnInt15=3,2
Next16=
ColumnInt17=0,2
ColumnTextL18=1,jim
ColumnTextL19=2,davies
ColumnInt20=3,1
Next21=
ColumnInt22=0,3
ColumnTextL23=1,bob
ColumnTextL24=2,smith
ColumnInt25=3,1
Next26=
ColumnInt27=0,4
ColumnTextL28=1,dave
ColumnTextL29=2,house
ColumnInt30=3,3
Next31=
ColumnInt32=0,5
ColumnTextL33=1,jane
ColumnTextL34=2,hobbs
ColumnInt35=3,4
Next36=
St_Close37=
Close38=
EndBlock39=

[modify]
Open0=c:[102827c7]bur.db
Exec1=insert into names(pkey, fname, lname, ref) values(6, "extra1", "another", 4);
Exec2=insert into names(pkey, fname, lname, ref) values(7, "extra2", "another", 4);
Close3=
EndBlock4=

[setup2]
SPCreate0=
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
CreateSP2=c:[102827c8]bur.db
SPClose3=
Exec4=create table names(pkey int, fname text, lname text, ref int);
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
Close10=
EndBlock11=

[check2]
Open0=c:[102827c8]bur.db
//check the number of records is correct firstly
Prepare1=select count(*) from names;
ColumnIndex2=
Next3=
ColumnInt4=0,5
St_Close5=
//now check the data
Prepare6=select * from names;
ColumnIndex7=pkey
ColumnIndex8=fname
ColumnIndex9=lname
ColumnIndex10=ref
Next11=
ColumnInt12=0,1
ColumnTextL13=1,tom
ColumnTextL14=2,jones
ColumnInt15=3,2
Next16=
ColumnInt17=0,2
ColumnTextL18=1,jim
ColumnTextL19=2,davies
ColumnInt20=3,1
Next21=
ColumnInt22=0,3
ColumnTextL23=1,bob
ColumnTextL24=2,smith
ColumnInt25=3,1
Next26=
ColumnInt27=0,4
ColumnTextL28=1,dave
ColumnTextL29=2,house
ColumnInt30=3,3
Next31=
ColumnInt32=0,5
ColumnTextL33=1,jane
ColumnTextL34=2,hobbs
ColumnInt35=3,4
Next36=
St_Close37=
Close38=
EndBlock39=

[setup3]
SPCreate0=
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
CreateSP2=c:[102827c7]bur1.db
SPClose3=
Exec4=create table nums(pkey int);
Exec5=insert into nums(pkey) values(1);
Exec6=insert into nums(pkey) values(2);
Exec7=insert into nums(pkey) values(3);
Exec8=insert into nums(pkey) values(4);
Exec9=insert into nums(pkey) values(5);
Close10=
SPCreate11=
SetDBPolicy12=ESchemaPolicy,ECapabilityWriteUserData
CreateSP13=c:[102827c7]bur2.db
SPClose14=
Exec15=create table nums(pkey int);
Exec16=insert into nums(pkey) values(6);
Exec17=insert into nums(pkey) values(7);
Exec18=insert into nums(pkey) values(8);
Exec19=insert into nums(pkey) values(9);
Exec20=insert into nums(pkey) values(10);
Close21=
SPCreate22=
SetDBPolicy23=ESchemaPolicy,ECapabilityWriteUserData
CreateSP24=c:[102827c7]bur3.db
SPClose25=
Exec26=create table nums(pkey int);
Exec27=insert into nums(pkey) values(11);
Exec28=insert into nums(pkey) values(12);
Exec29=insert into nums(pkey) values(13);
Exec30=insert into nums(pkey) values(14);
Exec31=insert into nums(pkey) values(15);
Close32=
EndBlock33=

[check3]
Open0=c:[102827c7]bur1.db
//check the number of records is correct firstly
Prepare1=select count(*) from nums;
ColumnIndex2=
Next3=
ColumnInt4=0,5
St_Close5=
//now check the data
Prepare6=select * from nums;
ColumnIndex7=pkey
Next8=
ColumnInt9=0,1
Next10=
ColumnInt11=0,2
Next12=
ColumnInt13=0,3
Next14=
ColumnInt15=0,4
Next16=
ColumnInt17=0,5
Next18=
St_Close19=
Close20=
Open21=c:[102827c7]bur2.db
//check the number of records is correct firstly
Prepare22=select count(*) from nums;
ColumnIndex23=
Next24=
ColumnInt25=0,5
St_Close26=
//now check the data
Prepare27=select * from nums;
ColumnIndex28=pkey
Next29=
ColumnInt30=0,6
Next31=
ColumnInt32=0,7
Next33=
ColumnInt34=0,8
Next35=
ColumnInt36=0,9
Next37=
ColumnInt38=0,10
Next39=
St_Close40=
Close41=
Open42=c:[102827c7]bur3.db
//check the number of records is correct firstly
Prepare43=select count(*) from nums;
ColumnIndex44=
Next45=
ColumnInt46=0,5
St_Close47=
//now check the data
Prepare48=select * from nums;
ColumnIndex49=pkey
Next50=
ColumnInt51=0,11
Next52=
ColumnInt53=0,12
Next54=
ColumnInt55=0,13
Next56=
ColumnInt57=0,14
Next58=
ColumnInt59=0,15
Next60=
St_Close61=
Close62=
EndBlock63=

[setup4]
SPCreate0=
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
CreateSP2=c:[102827c7]118192
SPClose3=
Exec4=create table names(pkey int, fname text, lname text, ref int);
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
Close10=
EndBlock11=

[check4]
Open0=c:[102827c7]118192
//check the number of records is correct firstly
Prepare1=select count(*) from names;
ColumnIndex2=
Next3=
ColumnInt4=0,5
St_Close5=
//now check the data
Prepare6=select * from names;
ColumnIndex7=pkey
ColumnIndex8=fname
ColumnIndex9=lname
ColumnIndex10=ref
Next11=
ColumnInt12=0,1
ColumnTextL13=1,tom
ColumnTextL14=2,jones
ColumnInt15=3,2
Next16=
ColumnInt17=0,2
ColumnTextL18=1,jim
ColumnTextL19=2,davies
ColumnInt20=3,1
Next21=
ColumnInt22=0,3
ColumnTextL23=1,bob
ColumnTextL24=2,smith
ColumnInt25=3,1
Next26=
ColumnInt27=0,4
ColumnTextL28=1,dave
ColumnTextL29=2,house
ColumnInt30=3,3
Next31=
ColumnInt32=0,5
ColumnTextL33=1,jane
ColumnTextL34=2,hobbs
ColumnInt35=3,4
Next36=
St_Close37=
Close38=
EndBlock39=



