BEGIN TRANSACTION;
CREATE TABLE HttpTestResults (Description TEXT, ParamSet INTEGER, ContentType TEXT, Result BLOB);
INSERT INTO "HttpTestResults" VALUES('Enumerate user', 1, 'text/xml; charset=utf-8', X'0A20203C557365724C6973743E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722057465320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E57465320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576673557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F7220574D5320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E574D5320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576D73557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722061646D696E6973746572696E672074686520736974653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E536974652041646D696E6973747261746F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E41646D696E6973747261746F723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722067756573747320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E416E6F6E796D6F757320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E416E6F6E796D6F75733C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F72207573657273207769746820417574686F7220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E4D617020417574686F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E417574686F723C2F4E616D653E0A202020203C2F557365723E0A20203C2F557365724C6973743E');
INSERT INTO "HttpTestResults" VALUES('Enumerate groups', 12, 'text/xml', X'0A20203C47726F75704C6973743E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E4275696C742D696E2067726F757020746F20696E636C75646520616C6C2075736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E45766572796F6E653C2F4E616D653E0A202020203C2F47726F75703E3C2F47726F75704C6973743E');
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('Enumearate User', 1, 'text/xml', X'0A20203C557365724C6973743E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722057465320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E57465320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576673557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F7220574D5320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E574D5320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576D73557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722061646D696E6973746572696E672074686520736974653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E536974652041646D696E6973747261746F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E41646D696E6973747261746F723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722067756573747320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E416E6F6E796D6F757320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E416E6F6E796D6F75733C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F72207573657273207769746820417574686F7220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E4D617020417574686F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E417574686F723C2F4E616D653E0A202020203C2F557365723E0A20203C2F557365724C6973743E');
INSERT INTO "ApiTestResults" VALUES('Add a user', 2, '', '');
INSERT INTO "ApiTestResults" VALUES('Add a user', 3, '', '');
INSERT INTO "ApiTestResults" VALUES('Enumerate users', 4, 'text/xml', X'0A20203C557365724C6973743E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722057465320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E57465320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576673557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F7220574D5320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E574D5320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576D73557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722061646D696E6973746572696E672074686520736974653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E536974652041646D696E6973747261746F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E41646D696E6973747261746F723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722067756573747320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E416E6F6E796D6F757320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E416E6F6E796D6F75733C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F72207573657273207769746820417574686F7220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E4D617020417574686F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E417574686F723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E546869732069732061207465737420757365723C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E6B6D616E3C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E757365723C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E4E696B6F6C6F763C2F46756C6C4E616D653E0A2020202020203C4E616D653E6B6F6E7374616E74696E3C2F4E616D653E0A202020203C2F557365723E0A20203C2F557365724C6973743E');
INSERT INTO "ApiTestResults" VALUES('Add a user', 5, 'text/plain', X'6D676475706C696361746575736572657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Update user', 6, '', '');
INSERT INTO "ApiTestResults" VALUES('Update user', 7, 'text/plain', X'6D67757365726E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Update user', 8, 'text/plain', X'6D676475706C696361746575736572657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Enumerate users', 9, 'text/xml', X'0A20203C557365724C6973743E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722057465320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E57465320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576673557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F7220574D5320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E574D5320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576D73557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722061646D696E6973746572696E672074686520736974653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E536974652041646D696E6973747261746F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E41646D696E6973747261746F723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722067756573747320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E416E6F6E796D6F757320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E416E6F6E796D6F75733C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F72207573657273207769746820417574686F7220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E4D617020417574686F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E417574686F723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E75706461746564207465737420757365723C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E55706461746564557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E646D616E3C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E757365723C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E4E696B6F6C6F763C2F46756C6C4E616D653E0A2020202020203C4E616D653E6B6F6E7374616E74696E3C2F4E616D653E0A202020203C2F557365723E0A20203C2F557365724C6973743E');
INSERT INTO "ApiTestResults" VALUES('Delete users', 10, '', '');
INSERT INTO "ApiTestResults" VALUES('Enumerate users', 11, 'text/xml', X'0A20203C557365724C6973743E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722057465320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E57465320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576673557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F7220574D5320757365727320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E574D5320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E576D73557365723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722061646D696E6973746572696E672074686520736974653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E536974652041646D696E6973747261746F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E41646D696E6973747261746F723C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F722067756573747320776974682056696577657220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E416E6F6E796D6F757320557365723C2F46756C6C4E616D653E0A2020202020203C4E616D653E416E6F6E796D6F75733C2F4E616D653E0A202020203C2F557365723E0A202020203C557365723E0A2020202020203C4465736372697074696F6E3E4275696C742D696E206163636F756E7420666F72207573657273207769746820417574686F7220726F6C653C2F4465736372697074696F6E3E0A2020202020203C46756C6C4E616D653E4D617020417574686F723C2F46756C6C4E616D653E0A2020202020203C4E616D653E417574686F723C2F4E616D653E0A202020203C2F557365723E0A20203C2F557365724C6973743E');
INSERT INTO "ApiTestResults" VALUES('Enumerate groups', 12, 'text/xml', X'0A20203C47726F75704C6973743E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E4275696C742D696E2067726F757020746F20696E636C75646520616C6C2075736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E45766572796F6E653C2F4E616D653E0A202020203C2F47726F75703E3C2F47726F75704C6973743E');
INSERT INTO "ApiTestResults" VALUES('Add a group', 13, '', X'');
INSERT INTO "ApiTestResults" VALUES('Add a group', 14, '', X'');
INSERT INTO "ApiTestResults" VALUES('Enumerate froups', 15, 'text/xml', X'0A20203C47726F75704C6973743E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E41646D696E2067726F75703C2F4465736372697074696F6E3E0A2020202020203C4E616D653E61646D696E3C2F4E616D653E0A202020203C2F47726F75703E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E4275696C742D696E2067726F757020746F20696E636C75646520616C6C2075736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E45766572796F6E653C2F4E616D653E0A202020203C2F47726F75703E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E47726F7570206F66205475782055736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E54757855736572733C2F4E616D653E0A202020203C2F47726F75703E0A20203C2F47726F75704C6973743E');
INSERT INTO "ApiTestResults" VALUES('Add a group', 16, 'text/plain', X'6D676475706C696361746567726F7570657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Update a group', 17, '', X'');
INSERT INTO "ApiTestResults" VALUES('Update a group', 18, 'text/plain', X'6D6767726F75706E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Update user', 19, 'text/plain', X'6D676475706C696361746567726F7570657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Enumerate groups', 20, 'text/xml', X'0A20203C47726F75704C6973743E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E3C2F4465736372697074696F6E3E0A2020202020203C4E616D653E5570646174656454757855736572733C2F4E616D653E0A202020203C2F47726F75703E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E41646D696E2067726F75703C2F4465736372697074696F6E3E0A2020202020203C4E616D653E61646D696E3C2F4E616D653E0A202020203C2F47726F75703E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E4275696C742D696E2067726F757020746F20696E636C75646520616C6C2075736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E45766572796F6E653C2F4E616D653E0A202020203C2F47726F75703E0A20203C2F47726F75704C6973743E');
INSERT INTO "ApiTestResults" VALUES('Delete groups', 21, '', X'');
INSERT INTO "ApiTestResults" VALUES('Enumerate groups', 22, 'text/xml', X'0A20203C47726F75704C6973743E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E4275696C742D696E2067726F757020746F20696E636C75646520616C6C2075736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E45766572796F6E653C2F4E616D653E0A202020203C2F47726F75703E3C2F47726F75704C6973743E');
INSERT INTO "ApiTestResults" VALUES('Adds a valid user', 1001, '', '');
INSERT INTO "ApiTestResults" VALUES('Adds a valid user', 1002, '', '');
INSERT INTO "ApiTestResults" VALUES('Adds a valid user', 1003, '', '');
INSERT INTO "ApiTestResults" VALUES('Adds a valid group', 1004, '', '');
INSERT INTO "ApiTestResults" VALUES('Adds a valid group', 1005, '', '');
INSERT INTO "ApiTestResults" VALUES('Adds a valid group', 1006, '', '');
INSERT INTO "ApiTestResults" VALUES('Deletes users', 2001, '', '');
INSERT INTO "ApiTestResults" VALUES('Deletes groups', 2002, '', '');
INSERT INTO "ApiTestResults" VALUES('GrantGroupMembershipsToUsers using valid parameters', 3001, '', '');
INSERT INTO "ApiTestResults" VALUES('GrantGroupMembershipsToUsers when the specified group does not exist', 3002, 'text/plain', X'6D6767726F75706E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantGroupMembershipsToUsers when the list of groups contains invalid group', 3003, 'text/plain', X'6D6767726F75706E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantGroupMembershipsToUsers when the list of users contains invalid user', 3004, 'text/plain', X'6D67757365726E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Add a valid user', 4001, '', '');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipToUsers when user does not exist', 4002, 'text/plain', X'6D67696E76616C69647265736F757263656E616D65657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipToUsers when user is blank', 4003, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipToUsers when role is blank', 4004, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipToUsers with valid parameters', 4005, '', '');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipToUsers when the user has that role already', 4006, '', '');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipToUsers when role does not exist', 4007, 'text/plain', X'6D67696E76616C69647265736F757263656E616D65657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipToUsers - granting admin role', 4008, '', '');
INSERT INTO "ApiTestResults" VALUES('Delete the user', 4009, '', '');
INSERT INTO "ApiTestResults" VALUES('Add valid user', 5001, '', '');
INSERT INTO "ApiTestResults" VALUES('Add valid group', 5002, '', '');
INSERT INTO "ApiTestResults" VALUES('Grant membership for that group to that user', 5003, '', '');
INSERT INTO "ApiTestResults" VALUES('RevokeGroupMembershipsFromUser with blank group', 5004, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeGroupMembershipsFromUser  when group does not exist', 5005, 'text/plain', X'6D6767726F75706E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeGroupMembershipsFromUsers when one of the groups in the list does not exist', 5006, 'text/plain', X'6D6767726F75706E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeGroupMembershipsFromUser when one of the users in the list does not exist', 5007, 'text/plain', X'6D67696E76616C69647265736F757263656E616D65657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeGroupMembershipsFromUser when user is blank', 5008, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeGroupMembershipsFromUser with valid parameters', 5009, '', '');
INSERT INTO "ApiTestResults" VALUES('Delete the user', 5010, '', '');
INSERT INTO "ApiTestResults" VALUES('Delete the group', 5011, '', '');
INSERT INTO "ApiTestResults" VALUES('Add a user', 6001, '', '');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipsToUsers - grant Administrator role', 6002, '', '');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromUsers - role does not exist', 6003, 'text/plain', X'6D67696E76616C69647265736F757263656E616D65657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromUsers - role is blank', 6004, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromUsers - user does not exist', 6005, 'text/plain', X'6D67757365726E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromUsers - user is blank', 6006, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromUsers -revoke  Author role', 6007, '', '');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromUsers - revoke Administrator role', 6008, '', '');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromUsers - revoke Administrator role again', 6009, '', '');
INSERT INTO "ApiTestResults" VALUES('Delete user', 6010, '', '');
INSERT INTO "ApiTestResults" VALUES('Add a group', 7001, '', '');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipsToGroups - role does not exist', 7002, 'text/plain', X'6D67696E76616C69647265736F757263656E616D65657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipsToGroups - role is blank', 7003, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipsToGroups - group does not exist', 7004, 'text/plain', X'6D6767726F75706E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipsToGroups  - group is blank', 7005, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipsToGroups - grant Administrator role to TestGroup', 7006, '', '');
INSERT INTO "ApiTestResults" VALUES('GrantRoleMembershipsToGroups - grant 2 roles to TestGroup', 7007, '', '');
INSERT INTO "ApiTestResults" VALUES('Delete TestGroup', 7008, '', '');
INSERT INTO "ApiTestResults" VALUES('Add a group', 8001, '', '');
INSERT INTO "ApiTestResults" VALUES('Grant Author role to TestGroup', 8002, '', '');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromGroups role does not exist', 8003, 'text/plain', X'6D67696E76616C69647265736F757263656E616D65657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromGroups - role is blank', 8004, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromGroups - group does not exist', 8005, 'text/plain', X'6D6767726F75706E6F74666F756E64657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromGroups - group is blank', 8006, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromGroups - revoke Administrator role from TestGroup', 8007, '', '');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromGroups - revoke Author role from TestGroup', 8008, '', '');
INSERT INTO "ApiTestResults" VALUES('RevokeRoleMembershipsFromGroups - revoke Author role from TestGroup again', 8009, '', '');
INSERT INTO "ApiTestResults" VALUES('Delete testGroup', 8010, '', '');
INSERT INTO "ApiTestResults" VALUES('Add a user', 9001, '', '');
INSERT INTO "ApiTestResults" VALUES('Add a group', 9002, '', '');
INSERT INTO "ApiTestResults" VALUES('Grant t_konsn membership to TestGroup', 9003, '', '');
INSERT INTO "ApiTestResults" VALUES('Grant t_konsn Author role', 9004, '', '');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles - with blank rgroup and t_konsn user', 9005, 'text/plain', 'Author,');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles with no user an existing group', 9006, 'text/plain', '');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles with existing user and no group', 9007, 'text/plain', 'Administrator,');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles when the user does not belong to the group', 9009, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles when the user does not belong to the group', 9010, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles with valid group and no user specified', 9011, 'text/plain', 'Viewer,');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles with blank user and group', 9012, 'text/plain', 'Administrator,Author,Viewer,');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles when the user does not exist', 9013, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles when the user does not exist and group is specified', 9014, 'text/plain', '');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles when the group does not exist', 9015, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('EnumerateRoles when the group does not exist and a valid user is specified', 9016, 'text/plain', '');
INSERT INTO "ApiTestResults" VALUES('Delete t_konsn', 9017, '', '');
INSERT INTO "ApiTestResults" VALUES('Delete TestGroup', 9018, '', '');
INSERT INTO "ApiTestResults" VALUES('', 10001, 'text/plain', 'mginvalidargumentexception');
INSERT INTO "ApiTestResults" VALUES('', 10002, '', '');
INSERT INTO "ApiTestResults" VALUES('', 10003, 'text/plain', 'Administrator');
INSERT INTO "ApiTestResults" VALUES('', 10004, 'text/xml', X'0A20203C47726F75704C6973743E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E4275696C742D696E2067726F757020746F20696E636C75646520616C6C2075736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E45766572796F6E653C2F4E616D653E0A202020203C2F47726F75703E3C2F47726F75704C6973743E');
INSERT INTO "ApiTestResults" VALUES('', 10005, 'text/xml', X'0A20203C47726F75704C6973743E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E4275696C742D696E2067726F757020746F20696E636C75646520616C6C2075736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E45766572796F6E653C2F4E616D653E0A202020203C2F47726F75703E3C2F47726F75704C6973743E');
INSERT INTO "ApiTestResults" VALUES('', 10006, 'text/plain', X'41646D696E6973747261746F722C');
INSERT INTO "ApiTestResults" VALUES('', 10007, 'text/plain', X'5669657765722C');
INSERT INTO "ApiTestResults" VALUES('', 10008, 'text/xml', X'0A20203C47726F75704C6973743E0A202020203C47726F75703E0A2020202020203C4465736372697074696F6E3E4275696C742D696E2067726F757020746F20696E636C75646520616C6C2075736572733C2F4465736372697074696F6E3E0A2020202020203C4E616D653E45766572796F6E653C2F4E616D653E0A202020203C2F47726F75703E3C2F47726F75704C6973743E');
INSERT INTO "ApiTestResults" VALUES('', 10009, 'text/plain', X'6D67756E617574686F72697A6564616363657373657863657074696F6E');
CREATE TABLE Params (ParamSet INTEGER, ParamName TEXT, ParamValue TEXT);
INSERT INTO "Params" VALUES(1, 'OPERATION', 'ENUMERATEUSERS');
INSERT INTO "Params" VALUES(2, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(2, 'USERID', 'kman');
INSERT INTO "Params" VALUES(2, 'USERNAME', 'User');
INSERT INTO "Params" VALUES(2, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(2, 'DESCRIPTION', 'This is a test user');
INSERT INTO "Params" VALUES(3, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(3, 'USERID', 'konstantin');
INSERT INTO "Params" VALUES(3, 'USERNAME', 'Nikolov');
INSERT INTO "Params" VALUES(3, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(3, 'DESCRIPTION', 'user');
INSERT INTO "Params" VALUES(4, 'OPERATION', 'ENUMERATEUSERS');
INSERT INTO "Params" VALUES(5, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(5, 'USERID', 'kman');
INSERT INTO "Params" VALUES(5, 'USERNAME', 'AnotherUser');
INSERT INTO "Params" VALUES(5, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(5, 'DESCRIPTION', 'This user should not be added because it already exists');
INSERT INTO "Params" VALUES(6, 'OPERATION', 'UPDATEUSER');
INSERT INTO "Params" VALUES(6, 'USERID', 'kman');
INSERT INTO "Params" VALUES(6, 'NEWUSERID', 'dman');
INSERT INTO "Params" VALUES(6, 'NEWUSERNAME', 'UpdatedUser');
INSERT INTO "Params" VALUES(6, 'NEWPASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(6, 'NEWDESCRIPTION', 'updated test user');
INSERT INTO "Params" VALUES(7, 'USERID', 'boo');
INSERT INTO "Params" VALUES(7, 'NEWUSERID', 'newuser');
INSERT INTO "Params" VALUES(7, 'NEWUSERNAME', 'Jack');
INSERT INTO "Params" VALUES(7, 'NEWPASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(7, 'NEWDESCRIPTION', 'The original user does not exist.');
INSERT INTO "Params" VALUES(7, 'OPERATION', 'UPDATEUSER');
INSERT INTO "Params" VALUES(8, 'OPERATION', 'UPDATEUSER');
INSERT INTO "Params" VALUES(8, 'USERID', 'konstantin');
INSERT INTO "Params" VALUES(8, 'NEWUSERID', 'dman');
INSERT INTO "Params" VALUES(8, 'NEWUSERNAME', 'DuplicateUser');
INSERT INTO "Params" VALUES(8, 'NEWPASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(8, 'NEWDESCRIPTION', 'User dman already exist so update should fail');
INSERT INTO "Params" VALUES(9, 'OPERATION', 'ENUMERATEUSERS');
INSERT INTO "Params" VALUES(10, 'OPERATION', 'DELETEUSERS');
INSERT INTO "Params" VALUES(10, 'USERS', 'dman,konstantin');
INSERT INTO "Params" VALUES(11, 'OPERATION', 'ENUMERATEUSERS');
INSERT INTO "Params" VALUES(12, 'OPERATION', 'ENUMERATEGROUPS');
INSERT INTO "Params" VALUES(13, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(13, 'GROUP', 'admin');
INSERT INTO "Params" VALUES(13, 'DESCRIPTION', 'Admin group');
INSERT INTO "Params" VALUES(14, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(14, 'GROUP', 'TuxUsers');
INSERT INTO "Params" VALUES(14, 'DESCRIPTION', 'Group of Tux Users');
INSERT INTO "Params" VALUES(15, 'OPERATION', 'ENUMERATEGROUPS');
INSERT INTO "Params" VALUES(16, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(16, 'GROUP', 'TuxUsers');
INSERT INTO "Params" VALUES(16, 'DESCRIPTION', 'Group Already Exists');
INSERT INTO "Params" VALUES(17, 'OPERATION', 'UPDATEGROUP');
INSERT INTO "Params" VALUES(17, 'GROUP', 'TuxUsers');
INSERT INTO "Params" VALUES(17, 'NEWGROUP', 'UpdatedTuxUsers');
INSERT INTO "Params" VALUES(17, 'DESCRIPTION', '');
INSERT INTO "Params" VALUES(18, 'OPERATION', 'UPDATEGROUP');
INSERT INTO "Params" VALUES(18, 'GROUP', 'UserGroup');
INSERT INTO "Params" VALUES(18, 'NEWGROUP', 'UpdatedUserGroup');
INSERT INTO "Params" VALUES(18, 'DESCRIPTION', 'Original group does not exist');
INSERT INTO "Params" VALUES(19, 'OPERATION', 'UPDATEGROUP');
INSERT INTO "Params" VALUES(19, 'GROUP', 'admin');
INSERT INTO "Params" VALUES(19, 'NEWGROUP', 'UpdatedTuxUsers');
INSERT INTO "Params" VALUES(19, 'DESCRIPTION', 'UpdatedTuxUsers already exists the update should fail');
INSERT INTO "Params" VALUES(20, 'OPERATION', 'ENUMERATEGROUPS');
INSERT INTO "Params" VALUES(21, 'OPERATION', 'DELETEGROUPS');
INSERT INTO "Params" VALUES(21, 'GROUPS', 'admin,UpdatedTuxUsers');
INSERT INTO "Params" VALUES(22, 'OPERATION', 'ENUMERATEGROUPS');
INSERT INTO "Params" VALUES(1001, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(1001, 'USERID', 'user1');
INSERT INTO "Params" VALUES(1001, 'USERNAME', 'user1');
INSERT INTO "Params" VALUES(1001, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(1001, 'DESCRIPTION', '');
INSERT INTO "Params" VALUES(1002, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(1002, 'USERID', 'user2');
INSERT INTO "Params" VALUES(1002, 'USERNAME', 'user2');
INSERT INTO "Params" VALUES(1002, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(1002, 'DESCRIPTION', '');
INSERT INTO "Params" VALUES(1003, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(1003, 'USERID', 'user3');
INSERT INTO "Params" VALUES(1003, 'USERNAME', 'user3');
INSERT INTO "Params" VALUES(1003, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(1003, 'DESCRIPTION', '');
INSERT INTO "Params" VALUES(1004, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(1004, 'GROUP', 'AdminGroup');
INSERT INTO "Params" VALUES(1004, 'DESCRIPTION', '');
INSERT INTO "Params" VALUES(1005, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(1005, 'GROUP', 'UserGroup');
INSERT INTO "Params" VALUES(1005, 'DESCRIPTION', '');
INSERT INTO "Params" VALUES(1006, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(1006, 'GROUP', 'TestGroup');
INSERT INTO "Params" VALUES(1006, 'DESCRIPTION', '');
INSERT INTO "Params" VALUES(2001, 'OPERATION', 'DELETEUSERS');
INSERT INTO "Params" VALUES(2001, 'USERS', 'user1,user2,user3');
INSERT INTO "Params" VALUES(2002, 'OPERATION', 'DELETEGROUPS');
INSERT INTO "Params" VALUES(2002, 'GROUPS', 'AdminGroup,UserGroup,TestGroup');
INSERT INTO "Params" VALUES(3001, 'OPERATION', 'GRANTGROUPMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(3001, 'GROUPS', 'AdminGroup,TestGroup');
INSERT INTO "Params" VALUES(3001, 'USERS', 'user1');
INSERT INTO "Params" VALUES(3002, 'OPERATION', 'GRANTGROUPMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(3002, 'GROUPS', 'FakeGroup');
INSERT INTO "Params" VALUES(3002, 'USERS', 'user2,user3');
INSERT INTO "Params" VALUES(3003, 'OPERATION', 'GRANTGROUPMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(3003, 'GROUPS', 'TestGroup,FakeGroup');
INSERT INTO "Params" VALUES(3003, 'USERS', 'user3');
INSERT INTO "Params" VALUES(3004, 'OPERATION', 'GRANTGROUPMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(3004, 'GROUPS', 'UserGroup,TestGroup');
INSERT INTO "Params" VALUES(3004, 'USERS', 'user2,user4,user5');
INSERT INTO "Params" VALUES(3005, 'OPERATION', 'GRANTGROUPMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(3005, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(3005, 'USERS', 'user3');
INSERT INTO "Params" VALUES(3006, 'OPERATION', 'GRANTGROUPMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(3006, 'GROUPS', 'UserGroup,TestGroup');
INSERT INTO "Params" VALUES(3006, 'USERS', 'user2');
INSERT INTO "Params" VALUES(4001, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(4001, 'USERID', 't_konsn');
INSERT INTO "Params" VALUES(4001, 'USERNAME', 'Konstantin');
INSERT INTO "Params" VALUES(4001, 'DESCRIPTION', 'Test user');
INSERT INTO "Params" VALUES(4002, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(4002, 'USERS', 't_konsn, hacker');
INSERT INTO "Params" VALUES(4002, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(4003, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(4003, 'USERS', '');
INSERT INTO "Params" VALUES(4003, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(4004, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(4004, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(4004, 'ROLES', '');
INSERT INTO "Params" VALUES(4005, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(4005, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(4005, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(4006, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(4006, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(4006, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(4007, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(4007, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(4007, 'ROLES', 'FakeRole');
INSERT INTO "Params" VALUES(4008, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(4008, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(4008, 'ROLES', 'Administrator');
INSERT INTO "Params" VALUES(4001, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(4009, 'OPERATION', 'DELETEUSERS');
INSERT INTO "Params" VALUES(4009, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(5001, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(5001, 'USERID', 't_konsn');
INSERT INTO "Params" VALUES(5001, 'USERNAME', 'Konstantin');
INSERT INTO "Params" VALUES(5001, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(5001, 'DESCRIPTION', 'Test User');
INSERT INTO "Params" VALUES(5002, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(5002, 'GROUP', 'TestGroup');
INSERT INTO "Params" VALUES(5002, 'DESCRIPTION', 'Test group');
INSERT INTO "Params" VALUES(5003, 'OPERATION', 'GRANTGROUPMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(5003, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(5003, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(5004, 'OPERATION', 'REVOKEGROUPMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(5004, 'GROUPS', '');
INSERT INTO "Params" VALUES(5004, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(5005, 'OPERATION', 'REVOKEGROUPMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(5005, 'GROUPS', 'Hackers');
INSERT INTO "Params" VALUES(5005, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(5006, 'OPERATION', 'REVOKEGROUPMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(5006, 'GROUPS', 'TestGroup,Hackers');
INSERT INTO "Params" VALUES(5006, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(5007, 'OPERATION', 'REVOKEGROUPMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(5007, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(5007, 'USERS', 't_konsn, Joe');
INSERT INTO "Params" VALUES(5008, 'OPERATION', 'REVOKEGROUPMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(5008, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(5008, 'USERS', '');
INSERT INTO "Params" VALUES(5009, 'OPERATION', 'REVOKEGROUPMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(5009, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(5009, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(5010, 'OPERATION', 'DELETEUSERS');
INSERT INTO "Params" VALUES(5010, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(5011, 'OPERATION', 'DELETEGROUPS');
INSERT INTO "Params" VALUES(5011, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(6001, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(6001, 'USERID', 't_konsn');
INSERT INTO "Params" VALUES(6001, 'USERNAME', 'Konstantin');
INSERT INTO "Params" VALUES(6001, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(6001, 'DESCRIPTION', 'Test User');
INSERT INTO "Params" VALUES(6002, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(6002, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(6002, 'ROLES', 'Administrator');
INSERT INTO "Params" VALUES(6003, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(6003, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(6003, 'ROLES', 'SuperRole');
INSERT INTO "Params" VALUES(6004, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(6004, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(6004, 'ROLES', '');
INSERT INTO "Params" VALUES(6005, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(6005, 'USERS', 'Hacker');
INSERT INTO "Params" VALUES(6005, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(6006, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(6006, 'USERS', '');
INSERT INTO "Params" VALUES(6006, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(6007, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(6007, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(6007, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(6008, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(6008, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(6008, 'ROLES', 'Administrator');
INSERT INTO "Params" VALUES(6009, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMUSERS');
INSERT INTO "Params" VALUES(6009, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(6009, 'ROLES', 'Administrator');
INSERT INTO "Params" VALUES(6010, 'OPERATION', 'DELETEUSERS');
INSERT INTO "Params" VALUES(6010, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(7001, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(7001, 'GROUP', 'TestGroup');
INSERT INTO "Params" VALUES(7002, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOGROUPS');
INSERT INTO "Params" VALUES(7002, 'ROLES', 'Hackers');
INSERT INTO "Params" VALUES(7002, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(7003, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOGROUPS');
INSERT INTO "Params" VALUES(7003, 'ROLES', '');
INSERT INTO "Params" VALUES(7003, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(7004, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOGROUPS');
INSERT INTO "Params" VALUES(7004, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(7004, 'GROUPS', 'ISD');
INSERT INTO "Params" VALUES(7005, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOGROUPS');
INSERT INTO "Params" VALUES(7005, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(7005, 'GROUPS', '');
INSERT INTO "Params" VALUES(7006, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOGROUPS');
INSERT INTO "Params" VALUES(7006, 'ROLES', 'Administrator');
INSERT INTO "Params" VALUES(7006, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(7007, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOGROUPS');
INSERT INTO "Params" VALUES(7007, 'ROLES', 'Administrator,Author');
INSERT INTO "Params" VALUES(7007, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(7008, 'OPERATION', 'DELETEGROUPS');
INSERT INTO "Params" VALUES(7008, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(8001, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(8001, 'GROUP', 'TestGroup');
INSERT INTO "Params" VALUES(8002, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOGROUPS');
INSERT INTO "Params" VALUES(8002, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(8002, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(8003, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMGROUPS');
INSERT INTO "Params" VALUES(8003, 'ROLES', 'Hacker');
INSERT INTO "Params" VALUES(8003, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(8004, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMGROUPS');
INSERT INTO "Params" VALUES(8004, 'ROLES', '');
INSERT INTO "Params" VALUES(8004, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(8005, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMGROUPS');
INSERT INTO "Params" VALUES(8005, 'ROLES', 'Administrator');
INSERT INTO "Params" VALUES(8005, 'GROUPS', 'Hackers');
INSERT INTO "Params" VALUES(8006, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMGROUPS');
INSERT INTO "Params" VALUES(8006, 'ROLES', 'Administrator');
INSERT INTO "Params" VALUES(8006, 'GROUPS', '');
INSERT INTO "Params" VALUES(8007, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMGROUPS');
INSERT INTO "Params" VALUES(8007, 'ROLES', 'Administrator');
INSERT INTO "Params" VALUES(8007, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(8008, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMGROUPS');
INSERT INTO "Params" VALUES(8008, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(8008, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(8009, 'OPERATION', 'REVOKEROLEMEMBERSHIPSFROMGROUPS');
INSERT INTO "Params" VALUES(8009, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(8009, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(8010, 'OPERATION', 'DELETEGROUPS');
INSERT INTO "Params" VALUES(8010, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(9001, 'OPERATION', 'ADDUSER');
INSERT INTO "Params" VALUES(9001, 'USERID', 't_konsn');
INSERT INTO "Params" VALUES(9001, 'USERNAME', 'Konstantin');
INSERT INTO "Params" VALUES(9001, 'PASSWORD', 'AFD64E12ABABABAB');
INSERT INTO "Params" VALUES(9001, 'DESCRIPTION', 'Test user');
INSERT INTO "Params" VALUES(9002, 'OPERATION', 'ADDGROUP');
INSERT INTO "Params" VALUES(9002, 'GROUP', 'TestGroup');
INSERT INTO "Params" VALUES(9003, 'OPERATION', 'GRANTGROUPMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(9003, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(9003, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(9004, 'OPERATION', 'GRANTROLEMEMBERSHIPSTOUSERS');
INSERT INTO "Params" VALUES(9004, 'ROLES', 'Author');
INSERT INTO "Params" VALUES(9004, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(9005, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9005, 'USER', 't_konsn');
INSERT INTO "Params" VALUES(9005, 'GROUP', '');
INSERT INTO "Params" VALUES(9006, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9006, 'USER', '');
INSERT INTO "Params" VALUES(9006, 'GROUP', 'TestGroup');
INSERT INTO "Params" VALUES(9007, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9007, 'USER', 'Administrator');
INSERT INTO "Params" VALUES(9007, 'GROUP', '');
INSERT INTO "Params" VALUES(9009, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9009, 'USER', 'Administrator');
INSERT INTO "Params" VALUES(9009, 'GROUP', 'TestGroup');
INSERT INTO "Params" VALUES(9010, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9010, 'USER', 't_konsn');
INSERT INTO "Params" VALUES(9010, 'GROUP', 'Everyone');
INSERT INTO "Params" VALUES(9011, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9011, 'USER', '');
INSERT INTO "Params" VALUES(9011, 'GROUP', 'Everyone');
INSERT INTO "Params" VALUES(9012, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9012, 'USER', '');
INSERT INTO "Params" VALUES(9012, 'GROUP', '');
INSERT INTO "Params" VALUES(9013, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9013, 'USER', 'Hacker');
INSERT INTO "Params" VALUES(9013, 'GROUP', 'TestGroup');
INSERT INTO "Params" VALUES(9014, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9014, 'USER', 'Hacker');
INSERT INTO "Params" VALUES(9014, 'GROUP', '');
INSERT INTO "Params" VALUES(9015, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9015, 'USER', 't_konsn');
INSERT INTO "Params" VALUES(9015, 'GROUP', 'ISD');
INSERT INTO "Params" VALUES(9016, 'OPERATION', 'ENUMERATEROLES');
INSERT INTO "Params" VALUES(9016, 'USER', '');
INSERT INTO "Params" VALUES(9016, 'GROUP', 'ISD');
INSERT INTO "Params" VALUES(9017, 'OPERATION', 'DELETEUSERS');
INSERT INTO "Params" VALUES(9017, 'USERS', 't_konsn');
INSERT INTO "Params" VALUES(9018, 'OPERATION', 'DELETEGROUPS');
INSERT INTO "Params" VALUES(9018, 'GROUPS', 'TestGroup');
INSERT INTO "Params" VALUES(10001, 'OPERATION', 'GETUSERFORSESSION');
INSERT INTO "Params" VALUES(10002, 'OPERATION', 'CREATESESSION');
INSERT INTO "Params" VALUES(10003, 'OPERATION', 'GETUSERFORSESSION');
INSERT INTO "Params" VALUES(10002, 'ALWAYSPASS', 'TRUE');
INSERT INTO "Params" VALUES(10004, 'OPERATION', 'ENUMERATEGROUPS2');
INSERT INTO "Params" VALUES(10004, 'USER', 'Administrator');
INSERT INTO "Params" VALUES(10004, 'LOGIN', 'Administrator');
INSERT INTO "Params" VALUES(10004, 'PASSWORD', 'admin');
INSERT INTO "Params" VALUES(10005, 'OPERATION', 'ENUMERATEGROUPS2');
INSERT INTO "Params" VALUES(10005, 'USER', 'Anonymous');
INSERT INTO "Params" VALUES(10005, 'PASSWORD', '');
INSERT INTO "Params" VALUES(10005, 'LOGIN', 'Anonymous');
INSERT INTO "Params" VALUES(10006, 'OPERATION', 'ENUMERATEROLES2');
INSERT INTO "Params" VALUES(10006, 'USER', 'Administrator');
INSERT INTO "Params" VALUES(10006, 'PASSWORD', 'admin');
INSERT INTO "Params" VALUES(10006, 'LOGIN', 'Administrator');
INSERT INTO "Params" VALUES(10007, 'OPERATION', 'ENUMERATEROLES2');
INSERT INTO "Params" VALUES(10007, 'USER', 'Anonymous');
INSERT INTO "Params" VALUES(10007, 'PASSWORD', '');
INSERT INTO "Params" VALUES(10007, 'LOGIN', 'Anonymous');
INSERT INTO "Params" VALUES(10008, 'OPERATION', 'ENUMERATEGROUPS2');
INSERT INTO "Params" VALUES(10008, 'USER', 'Anonymous');
INSERT INTO "Params" VALUES(10008, 'PASSWORD', 'admin');
INSERT INTO "Params" VALUES(10008, 'LOGIN', 'Administrator');
INSERT INTO "Params" VALUES(10009, 'OPERATION', 'ENUMERATEROLES2');
INSERT INTO "Params" VALUES(10009, 'USER', 'Administrator');
INSERT INTO "Params" VALUES(10009, 'PASSWORD', '');
INSERT INTO "Params" VALUES(10009, 'LOGIN', 'Anonymous');
CREATE TABLE TestCase (ExecuteSequence INTEGER, TestName TEXT, ParamSets TEXT, Description TEXT, TestType TEXT, Prerequisite TEXT);
INSERT INTO "TestCase" VALUES(1, 'SiteService_MasterApiTest', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,', 'Runs all tests in Params table', 'Api', 'None');
INSERT INTO "TestCase" VALUES(2, 'SiteService_MasterHttpTest', '1,12', 'Runs Enumerate Users/Groups', 'Http', 'None');
INSERT INTO "TestCase" VALUES(3, 'SiteService_AddUsers/Groups', '1001,1002,1003,1004,1005,1006', 'Adds users and groups that are used by the other tests in the list', 'Api', 'None');
INSERT INTO "TestCase" VALUES(5, 'SiteService_DeleteUsers', '2001,2002', 'Deletes users and groups added by SiteService:AddUsers/Groups', 'Api', 'None');
INSERT INTO "TestCase" VALUES(4, 'SiteService_GrantGroupMembershipsToUsersBranchTest', '3001,3002,3003,3004,3005,3006', 'Tests cover branches of GrantGroupMembershipsToUsers', 'Api', 'Run SiteService:AddUsers/Groups to add users and groups that are used in the test');
INSERT INTO "TestCase" VALUES(6, 'SiteService_GrantRoleMembershipsToUsersApiBranchTest', '4001,4002,4003,4004,4005,4006,4007,4008,4009', 'Branch tests for GrantRoleMembershipsToUsers', 'Api', 'None');
INSERT INTO "TestCase" VALUES(7, 'SiteService_RevokeGroupMembershipsFromUsersApiBranchTest', '5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011', 'Branch tests for RevokeGroupMembershipsFromUsers', 'Api', 'None');
INSERT INTO "TestCase" VALUES(8, 'SiteService_RevokeRoleMembershipsFromUsersApiBranchTest', '6001,6002,6003,6004,6005,6006,6007,6008,6009,6010', 'BranchTest for RevokeRoleMembershipsFromUsers', 'Api', 'None');
INSERT INTO "TestCase" VALUES(9, 'SiteService_GrantRoleMembershipsToGroupsApiBranchTest', '7001,7002,7003,7004,7005,7006,7007,7008', 'Branch Test for GrantRoleMembershipsToGroups', 'Api', 'None');
INSERT INTO "TestCase" VALUES(10, 'SiteService_RevokeRoleMembershipsFromGroupsApiBranchTest', '8001,8002,8003,8004,8005,8006,8007,8008,8009,8010', 'Branch Test for RevokeRoleMembershipsFromGroups', 'Api', 'None');
INSERT INTO "TestCase" VALUES(11, 'SiteService_EnumerateRolesApiBranchTest', '9001,9002,9003,9004,9005,9006,9007,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,', 'BranchTest for EnumerateRoles', 'Api', 'None');
INSERT INTO "TestCase" VALUES(12, 'SiteService_GetUserForSessionTest', '10001,10002,10003,10004,10005,10006,10007,10008,10009,', 'Test for GetUserForSession', 'Api', 'none');
COMMIT;