sl@0: [wait] sl@0: Sleep0=5000000 sl@0: EndBlock1= sl@0: sl@0: [bur] sl@0: BackupDir=c:\BackupArchive\ sl@0: IsPartial=1 sl@0: BaseOnly=1 sl@0: DriveList=c sl@0: IDs=102827c7 sl@0: sl@0: [bur2] sl@0: BackupDir=c:\BackupArchive\ sl@0: IsPartial=1 sl@0: BaseOnly=1 sl@0: DriveList=c sl@0: IDs=102827c7, 102827c8 sl@0: sl@0: [setup] sl@0: SPCreate0= sl@0: SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData sl@0: CreateSP2=c:[102827c7]bur.db sl@0: SPClose3= sl@0: Exec4=create table names(pkey int, fname text, lname text, ref int); sl@0: Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2); sl@0: Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1); sl@0: Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1); sl@0: Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3); sl@0: Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4); sl@0: Close10= sl@0: EndBlock11= sl@0: sl@0: [check] sl@0: Open0=c:[102827c7]bur.db sl@0: //check the number of records is correct firstly sl@0: Prepare1=select count(*) from names; sl@0: ColumnIndex2= sl@0: Next3= sl@0: ColumnInt4=0,5 sl@0: St_Close5= sl@0: //now check the data sl@0: Prepare6=select * from names; sl@0: ColumnIndex7=pkey sl@0: ColumnIndex8=fname sl@0: ColumnIndex9=lname sl@0: ColumnIndex10=ref sl@0: Next11= sl@0: ColumnInt12=0,1 sl@0: ColumnTextL13=1,tom sl@0: ColumnTextL14=2,jones sl@0: ColumnInt15=3,2 sl@0: Next16= sl@0: ColumnInt17=0,2 sl@0: ColumnTextL18=1,jim sl@0: ColumnTextL19=2,davies sl@0: ColumnInt20=3,1 sl@0: Next21= sl@0: ColumnInt22=0,3 sl@0: ColumnTextL23=1,bob sl@0: ColumnTextL24=2,smith sl@0: ColumnInt25=3,1 sl@0: Next26= sl@0: ColumnInt27=0,4 sl@0: ColumnTextL28=1,dave sl@0: ColumnTextL29=2,house sl@0: ColumnInt30=3,3 sl@0: Next31= sl@0: ColumnInt32=0,5 sl@0: ColumnTextL33=1,jane sl@0: ColumnTextL34=2,hobbs sl@0: ColumnInt35=3,4 sl@0: Next36= sl@0: St_Close37= sl@0: Close38= sl@0: EndBlock39= sl@0: sl@0: [modify] sl@0: Open0=c:[102827c7]bur.db sl@0: Exec1=insert into names(pkey, fname, lname, ref) values(6, "extra1", "another", 4); sl@0: Exec2=insert into names(pkey, fname, lname, ref) values(7, "extra2", "another", 4); sl@0: Close3= sl@0: EndBlock4= sl@0: sl@0: [setup2] sl@0: SPCreate0= sl@0: SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData sl@0: CreateSP2=c:[102827c8]bur.db sl@0: SPClose3= sl@0: Exec4=create table names(pkey int, fname text, lname text, ref int); sl@0: Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2); sl@0: Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1); sl@0: Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1); sl@0: Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3); sl@0: Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4); sl@0: Close10= sl@0: EndBlock11= sl@0: sl@0: [check2] sl@0: Open0=c:[102827c8]bur.db sl@0: //check the number of records is correct firstly sl@0: Prepare1=select count(*) from names; sl@0: ColumnIndex2= sl@0: Next3= sl@0: ColumnInt4=0,5 sl@0: St_Close5= sl@0: //now check the data sl@0: Prepare6=select * from names; sl@0: ColumnIndex7=pkey sl@0: ColumnIndex8=fname sl@0: ColumnIndex9=lname sl@0: ColumnIndex10=ref sl@0: Next11= sl@0: ColumnInt12=0,1 sl@0: ColumnTextL13=1,tom sl@0: ColumnTextL14=2,jones sl@0: ColumnInt15=3,2 sl@0: Next16= sl@0: ColumnInt17=0,2 sl@0: ColumnTextL18=1,jim sl@0: ColumnTextL19=2,davies sl@0: ColumnInt20=3,1 sl@0: Next21= sl@0: ColumnInt22=0,3 sl@0: ColumnTextL23=1,bob sl@0: ColumnTextL24=2,smith sl@0: ColumnInt25=3,1 sl@0: Next26= sl@0: ColumnInt27=0,4 sl@0: ColumnTextL28=1,dave sl@0: ColumnTextL29=2,house sl@0: ColumnInt30=3,3 sl@0: Next31= sl@0: ColumnInt32=0,5 sl@0: ColumnTextL33=1,jane sl@0: ColumnTextL34=2,hobbs sl@0: ColumnInt35=3,4 sl@0: Next36= sl@0: St_Close37= sl@0: Close38= sl@0: EndBlock39= sl@0: sl@0: [setup3] sl@0: SPCreate0= sl@0: SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData sl@0: CreateSP2=c:[102827c7]bur1.db sl@0: SPClose3= sl@0: Exec4=create table nums(pkey int); sl@0: Exec5=insert into nums(pkey) values(1); sl@0: Exec6=insert into nums(pkey) values(2); sl@0: Exec7=insert into nums(pkey) values(3); sl@0: Exec8=insert into nums(pkey) values(4); sl@0: Exec9=insert into nums(pkey) values(5); sl@0: Close10= sl@0: SPCreate11= sl@0: SetDBPolicy12=ESchemaPolicy,ECapabilityWriteUserData sl@0: CreateSP13=c:[102827c7]bur2.db sl@0: SPClose14= sl@0: Exec15=create table nums(pkey int); sl@0: Exec16=insert into nums(pkey) values(6); sl@0: Exec17=insert into nums(pkey) values(7); sl@0: Exec18=insert into nums(pkey) values(8); sl@0: Exec19=insert into nums(pkey) values(9); sl@0: Exec20=insert into nums(pkey) values(10); sl@0: Close21= sl@0: SPCreate22= sl@0: SetDBPolicy23=ESchemaPolicy,ECapabilityWriteUserData sl@0: CreateSP24=c:[102827c7]bur3.db sl@0: SPClose25= sl@0: Exec26=create table nums(pkey int); sl@0: Exec27=insert into nums(pkey) values(11); sl@0: Exec28=insert into nums(pkey) values(12); sl@0: Exec29=insert into nums(pkey) values(13); sl@0: Exec30=insert into nums(pkey) values(14); sl@0: Exec31=insert into nums(pkey) values(15); sl@0: Close32= sl@0: EndBlock33= sl@0: sl@0: [check3] sl@0: Open0=c:[102827c7]bur1.db sl@0: //check the number of records is correct firstly sl@0: Prepare1=select count(*) from nums; sl@0: ColumnIndex2= sl@0: Next3= sl@0: ColumnInt4=0,5 sl@0: St_Close5= sl@0: //now check the data sl@0: Prepare6=select * from nums; sl@0: ColumnIndex7=pkey sl@0: Next8= sl@0: ColumnInt9=0,1 sl@0: Next10= sl@0: ColumnInt11=0,2 sl@0: Next12= sl@0: ColumnInt13=0,3 sl@0: Next14= sl@0: ColumnInt15=0,4 sl@0: Next16= sl@0: ColumnInt17=0,5 sl@0: Next18= sl@0: St_Close19= sl@0: Close20= sl@0: Open21=c:[102827c7]bur2.db sl@0: //check the number of records is correct firstly sl@0: Prepare22=select count(*) from nums; sl@0: ColumnIndex23= sl@0: Next24= sl@0: ColumnInt25=0,5 sl@0: St_Close26= sl@0: //now check the data sl@0: Prepare27=select * from nums; sl@0: ColumnIndex28=pkey sl@0: Next29= sl@0: ColumnInt30=0,6 sl@0: Next31= sl@0: ColumnInt32=0,7 sl@0: Next33= sl@0: ColumnInt34=0,8 sl@0: Next35= sl@0: ColumnInt36=0,9 sl@0: Next37= sl@0: ColumnInt38=0,10 sl@0: Next39= sl@0: St_Close40= sl@0: Close41= sl@0: Open42=c:[102827c7]bur3.db sl@0: //check the number of records is correct firstly sl@0: Prepare43=select count(*) from nums; sl@0: ColumnIndex44= sl@0: Next45= sl@0: ColumnInt46=0,5 sl@0: St_Close47= sl@0: //now check the data sl@0: Prepare48=select * from nums; sl@0: ColumnIndex49=pkey sl@0: Next50= sl@0: ColumnInt51=0,11 sl@0: Next52= sl@0: ColumnInt53=0,12 sl@0: Next54= sl@0: ColumnInt55=0,13 sl@0: Next56= sl@0: ColumnInt57=0,14 sl@0: Next58= sl@0: ColumnInt59=0,15 sl@0: Next60= sl@0: St_Close61= sl@0: Close62= sl@0: EndBlock63= sl@0: sl@0: [setup4] sl@0: SPCreate0= sl@0: SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData sl@0: CreateSP2=c:[102827c7]118192 sl@0: SPClose3= sl@0: Exec4=create table names(pkey int, fname text, lname text, ref int); sl@0: Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2); sl@0: Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1); sl@0: Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1); sl@0: Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3); sl@0: Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4); sl@0: Close10= sl@0: EndBlock11= sl@0: sl@0: [check4] sl@0: Open0=c:[102827c7]118192 sl@0: //check the number of records is correct firstly sl@0: Prepare1=select count(*) from names; sl@0: ColumnIndex2= sl@0: Next3= sl@0: ColumnInt4=0,5 sl@0: St_Close5= sl@0: //now check the data sl@0: Prepare6=select * from names; sl@0: ColumnIndex7=pkey sl@0: ColumnIndex8=fname sl@0: ColumnIndex9=lname sl@0: ColumnIndex10=ref sl@0: Next11= sl@0: ColumnInt12=0,1 sl@0: ColumnTextL13=1,tom sl@0: ColumnTextL14=2,jones sl@0: ColumnInt15=3,2 sl@0: Next16= sl@0: ColumnInt17=0,2 sl@0: ColumnTextL18=1,jim sl@0: ColumnTextL19=2,davies sl@0: ColumnInt20=3,1 sl@0: Next21= sl@0: ColumnInt22=0,3 sl@0: ColumnTextL23=1,bob sl@0: ColumnTextL24=2,smith sl@0: ColumnInt25=3,1 sl@0: Next26= sl@0: ColumnInt27=0,4 sl@0: ColumnTextL28=1,dave sl@0: ColumnTextL29=2,house sl@0: ColumnInt30=3,3 sl@0: Next31= sl@0: ColumnInt32=0,5 sl@0: ColumnTextL33=1,jane sl@0: ColumnTextL34=2,hobbs sl@0: ColumnInt35=3,4 sl@0: Next36= sl@0: St_Close37= sl@0: Close38= sl@0: EndBlock39= sl@0: sl@0: sl@0: