INSERT INTO `api_role` VALUES (1,0,1,0,'G',0,'API Full Access'),(3,1,2,0,'U',1,'soap');

INSERT INTO `api_rule` VALUES (125,1,'directory','',0,'G','deny'),(126,1,'directory/country','',0,'G','deny'),(127,1,'directory/region','',0,'G','deny'),(128,1,'customer','',0,'G','deny'),(129,1,'customer/create','',0,'G','deny'),(130,1,'customer/update','',0,'G','deny'),(131,1,'customer/delete','',0,'G','deny'),(132,1,'customer/info','',0,'G','deny'),(133,1,'customer/address','',0,'G','deny'),(134,1,'customer/address/create','',0,'G','deny'),(135,1,'customer/address/update','',0,'G','deny'),(136,1,'customer/address/delete','',0,'G','deny'),(137,1,'customer/address/info','',0,'G','deny'),(138,1,'catalog','',0,'G','deny'),(139,1,'catalog/category','',0,'G','deny'),(140,1,'catalog/category/create','',0,'G','deny'),(141,1,'catalog/category/update','',0,'G','deny'),(142,1,'catalog/category/move','',0,'G','deny'),(143,1,'catalog/category/delete','',0,'G','deny'),(144,1,'catalog/category/tree','',0,'G','deny'),(145,1,'catalog/category/info','',0,'G','deny'),(146,1,'catalog/category/product','',0,'G','deny'),(147,1,'catalog/category/product/assign','',0,'G','deny'),(148,1,'catalog/category/product/update','',0,'G','deny'),(149,1,'catalog/category/product/remove','',0,'G','deny'),(150,1,'catalog/product','',0,'G','deny'),(151,1,'catalog/product/create','',0,'G','deny'),(152,1,'catalog/product/update','',0,'G','deny'),(153,1,'catalog/product/delete','',0,'G','deny'),(154,1,'catalog/product/update_tier_price','',0,'G','deny'),(155,1,'catalog/product/info','',0,'G','deny'),(156,1,'catalog/product/attribute','',0,'G','deny'),(157,1,'catalog/product/attribute/read','',0,'G','deny'),(158,1,'catalog/product/attribute/write','',0,'G','deny'),(159,1,'catalog/product/link','',0,'G','deny'),(160,1,'catalog/product/link/assign','',0,'G','deny'),(161,1,'catalog/product/link/update','',0,'G','deny'),(162,1,'catalog/product/link/remove','',0,'G','deny'),(163,1,'catalog/product/media','',0,'G','deny'),(164,1,'catalog/product/media/create','',0,'G','deny'),(165,1,'catalog/product/media/update','',0,'G','deny'),(166,1,'catalog/product/media/remove','',0,'G','deny'),(167,1,'sales','',0,'G','deny'),(168,1,'sales/order','',0,'G','deny'),(169,1,'sales/order/change','',0,'G','deny'),(170,1,'sales/order/info','',0,'G','deny'),(171,1,'sales/order/shipment','',0,'G','deny'),(172,1,'sales/order/shipment/create','',0,'G','deny'),(173,1,'sales/order/shipment/comment','',0,'G','deny'),(174,1,'sales/order/shipment/track','',0,'G','deny'),(175,1,'sales/order/shipment/info','',0,'G','deny'),(176,1,'sales/order/invoice','',0,'G','deny'),(177,1,'sales/order/invoice/create','',0,'G','deny'),(178,1,'sales/order/invoice/comment','',0,'G','deny'),(179,1,'sales/order/invoice/capture','',0,'G','deny'),(180,1,'sales/order/invoice/void','',0,'G','deny'),(181,1,'sales/order/invoice/cancel','',0,'G','deny'),(182,1,'sales/order/invoice/info','',0,'G','deny'),(183,1,'cataloginventory','',0,'G','deny'),(184,1,'cataloginventory/update','',0,'G','deny'),(185,1,'cataloginventory/info','',0,'G','deny'),(186,1,'all','',0,'G','allow');

INSERT INTO `api_user` VALUES (1,'soap','soap','soap@soap.com','soap','dbf065beea017dd7cfe8cde1b12a3b84:Gk','2010-01-01 00:00:00','2010-01-02 00:00:00',0,1,1);