BEGIN TRANSACTION;
CREATE TABLE HttpTestResults (Description TEXT, ParamSet INTEGER, ContentType TEXT, Result BLOB);
INSERT INTO "HttpTestResults" VALUES('Clear out existing Test/MappingService folder', 1, '', '');
INSERT INTO "HttpTestResults" VALUES('Add Test/MappingService folder', 2, 'text/plain; charset=utf-8', '');
INSERT INTO "HttpTestResults" VALUES('Add World Feature Source', 3, 'text/plain; charset=utf-8', '');
INSERT INTO "HttpTestResults" VALUES('Add World sdf', 4, 'text/plain; charset=utf-8', '');
INSERT INTO "HttpTestResults" VALUES('Add world layer definition', 5, 'text/plain; charset=utf-8', '');
INSERT INTO "HttpTestResults" VALUES('Add world map definition', 6, 'text/plain; charset=utf-8', '');
CREATE TABLE Params(ParamSet INTEGER, ParamName TEXT, ParamValue TEXT);
INSERT INTO "Params" VALUES(1, 'OPERATION', 'DELETERESOURCE');
INSERT INTO "Params" VALUES(1, 'RESOURCEID', 'Library://Test/MappingService/');
INSERT INTO "Params" VALUES(1, 'ALWAYSPASS', 'start from scratch');
INSERT INTO "Params" VALUES(2, 'OPERATION', 'SETRESOURCE');
INSERT INTO "Params" VALUES(2, 'RESOURCEID', 'Library://Test/MappingService/');
INSERT INTO "Params" VALUES(3, 'OPERATION', 'SETRESOURCE');
INSERT INTO "Params" VALUES(3, 'RESOURCEID', 'Library://Test/MappingService/UT_Rail.FeatureSource');
INSERT INTO "Params" VALUES(3, 'CONTENT', '../../TestData/MappingService/UT_Rail.fs');
INSERT INTO "Params" VALUES(4, 'OPERATION', 'SETRESOURCEDATA');
INSERT INTO "Params" VALUES(4, 'RESOURCEID', 'Library://Test/MappingService/UT_Rail.FeatureSource');
INSERT INTO "Params" VALUES(4, 'DATANAME', 'UT_Rail.sdf');
INSERT INTO "Params" VALUES(4, 'DATATYPE', 'File');
INSERT INTO "Params" VALUES(4, 'DATALENGTH', '0');
INSERT INTO "Params" VALUES(4, 'DATA', '../../TestData/MappingService/UT_Rail.sdf');
INSERT INTO "Params" VALUES(5, 'OPERATION', 'SETRESOURCE');
INSERT INTO "Params" VALUES(5, 'RESOURCEID', 'Library://Test/MappingService/UT_Rail.LayerDefinition');
INSERT INTO "Params" VALUES(5, 'CONTENT', '../../TestData/MappingService/UT_Rail_Web.ldf');
INSERT INTO "Params" VALUES(6, 'OPERATION', 'SETRESOURCE');
INSERT INTO "Params" VALUES(6, 'RESOURCEID', 'Library://Test/MappingService/UT_Rail.MapDefinition');
INSERT INTO "Params" VALUES(6, 'CONTENT', '../../TestData/MappingService/UT_Rail_Web.mdf');
CREATE TABLE CommonParams (ParamName text, ParamValue text);
INSERT INTO "CommonParams" VALUES('VERSION', '1.0.0');
INSERT INTO "CommonParams" VALUES('CREDENTIALS', 'qwerty');
INSERT INTO "CommonParams" VALUES('LOCALE', 'en');
CREATE TABLE ApiTestResults (Description TEXT, ParamSet INTEGER, ContentType TEXT, Result TEXT);
INSERT INTO "ApiTestResults" VALUES('Get map extent', 1, 'text/plain', '(-180:-90)-(180:90)');
CREATE TABLE TestCase (ExecuteSequence INTEGER, TestName TEXT, ParamSets TEXT, Description TEXT, TestType TEXT, Prerequisite TEXT);
INSERT INTO "TestCase" VALUES(1, 'MappingService_LoadData', '1,2,3,4,5,6,', 'Load sample world data for Mapping Service Test', 'Http', 'None');
COMMIT;