/*
 Navicat Premium Data Transfer

 Source Server         : Portal
 Source Server Type    : MySQL
 Source Server Version : 50095
 Source Host           : portal.italiangrid.it
 Source Database       : guse

 Target Server Type    : MySQL
 Target Server Version : 50095
 File Encoding         : utf-8

 Date: 07/13/2012 14:00:39 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `serviceresource`
-- ----------------------------
DROP TABLE IF EXISTS `serviceresource`;
CREATE TABLE `serviceresource` (
  `id` bigint(20) NOT NULL,
  `caller` varchar(255) default NULL,
  `res` varchar(255) default NULL,
  `com_id` bigint(20) default NULL,
  `dst_id` bigint(20) default NULL,
  `src_id` bigint(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `I_SRVCSRC_COM` (`com_id`),
  KEY `I_SRVCSRC_DST` (`dst_id`),
  KEY `I_SRVCSRC_SRC` (`src_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `serviceresource`
-- ----------------------------
BEGIN;
INSERT INTO `serviceresource` VALUES ('201', 'hu.sztaki.lpds.portal.net.wsaxis13.WfsPortalClientImpl', '/services/urn:portalwfsservice', '151', '7', '4'), ('202', 'hu.sztaki.lpds.portal.net.wsaxis13.StoragePortalClientImpl', '/services/urn:portalstorageservice', '151', '7', '5'), ('203', 'hu.sztaki.lpds.portal.net.wsaxis13.WfsPortalClientImpl', '/services/urn:portalwfsservice', '151', '7', '3'), ('204', '', '/services/urn:portalwfsservice', '151', '7', '7'), ('205', 'hu.sztaki.lpds.wfs.net.wsaxis13.PortalWfsClientImpl', '/services/urn:wfsportalservice', null, '4', '7'), ('206', 'hu.sztaki.lpds.wfs.net.wsaxis13.WfiWfsClientImpl', '/services/urn:wfswfiservice', '151', '4', '3'), ('207', 'hu.sztaki.lpds.wfs.net.wsaxis13.SubmitterWfsClientImpl', '/services/urn:wfssubmitterservice', '151', '4', '6'), ('208', 'hu.sztaki.lpds.wfs.net.wsaxis13.StorageWfsClientImpl', '/services/urn:wfsstorageservice', '151', '4', '5'), ('209', 'hu.sztaki.lpds.wfs.net.wsaxis13.RepositoryWfsClientImpl', '/services/urn:wfsrepositoryservice', '151', '4', '8'), ('210', 'hu.sztaki.lpds.wfi.net.wsaxis13.PortalWfiClientImpl', '/services/urn:wfiportalservice', '151', '3', '7'), ('211', 'hu.sztaki.lpds.storage.net.wsaxis13.PortalStorageClientImpl', '/services/urn:storageportalservice', null, '5', '7'), ('212', 'hu.sztaki.lpds.storage.net.http.SubmitterStorageClientImpl', '/receiver', '151', '5', '6'), ('213', 'hu.sztaki.lpds.repository.net.wsaxis13.PortalRepositoryClientImpl', '/services/urn:repositoryportalservice', '151', '8', '7'), ('214', 'hu.sztaki.lpds.logging.net.wsaxis13.LogClientImpl', '/services/urn:loggservice', '151', '2', '1'), ('215', 'hu.sztaki.lpds.logging.net.wsaxis13.LogClientImpl', '/services/urn:loggservice', '151', '2', '3'), ('216', 'hu.sztaki.lpds.logging.net.wsaxis13.LogClientImpl', '/services/urn:loggservice', '151', '2', '4'), ('217', 'hu.sztaki.lpds.logging.net.wsaxis13.LogClientImpl', '/services/urn:loggservice', '151', '2', '5'), ('218', 'hu.sztaki.lpds.logging.net.wsaxis13.LogClientImpl', '/services/urn:loggservice', '151', '2', '6'), ('219', 'hu.sztaki.lpds.logging.net.wsaxis13.LogClientImpl', '/services/urn:loggservice', '151', '2', '7'), ('220', 'hu.sztaki.lpds.logging.net.wsaxis13.LogClientImpl', '/services/urn:loggservice', '151', '2', '8'), ('221', 'hu.sztaki.lpds.logging.net.wsaxis13.LogClientImpl', '/services/urn:loggservice', '151', '2', '9'), ('222', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '2'), ('223', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '3'), ('224', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '4'), ('225', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '5'), ('226', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '6'), ('227', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '7'), ('228', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '8'), ('229', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '9'), ('230', 'hu.sztaki.lpds.gemlcaquery.net.wsaxis13.PortalGemlcaqueryClientImpl', '/services/urn:gemlcaqueryportalservice', '151', '9', '7'), ('231', 'hu.sztaki.lpds.information.net.wsaxis13.ServiceAdminClientImpl', '/services/urn:serviceadmin', null, '10', '7'), ('232', 'hu.sztaki.lpds.information.net.wsaxis13.ResourceConfigurationClientImpl', '/services/urn:resourceadmin', '151', '11', '6'), ('233', 'hu.sztaki.lpds.storage.net.wsaxis13.WFIStorageClientImpl', '/services/urn:storagewfiservice', '151', '5', '3'), ('234', 'hu.sztaki.lpds.dcibridge.client.SubbmitterJaxWSIMPL', '/BESFactoryService?wsdl', '151', '6', '3'), ('235', 'hu.sztaki.lpds.dcibridge.client.ResourceConfigJaxWsIMPL', '/ResourceConfiguration?wsdl', null, '11', '7'), ('236', '', '/CredentialProvider?wsdl', '151', '7', '6'), ('237', '', '/JobStatusService?wsdl', '151', '3', '6'), ('238', '', '', '151', '3', '3'), ('239', 'hu.sztaki.lpds.information.net.wsaxis13.InformationClientImpl', '/services/urn:infoservice', '151', '1', '12');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;