[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=