/*
 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:49 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `serviceproperties`
-- ----------------------------
DROP TABLE IF EXISTS `serviceproperties`;
CREATE TABLE `serviceproperties` (
  `id` bigint(20) NOT NULL,
  `propkey` varchar(255) default NULL,
  `propvalue` varchar(255) default NULL,
  `service_id` bigint(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `I_SRVCRTS_SERVICE` (`service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `serviceproperties`
-- ----------------------------
BEGIN;
INSERT INTO `serviceproperties` VALUES ('101', 'cache.time.msec', '3000000', '51'), ('102', 'repeat.submit.workflow', '1', '51'), ('103', 'notify.quota.time.in.hour', '1', '51'), ('104', 'notify.quota.max.percent', '95', '51'), ('105', 'gemlcacache.refreshintervall_min', '30', '51'), ('106', 'wspgrade.maxulpoadfilesize', '100', '51'), ('107', 'guse.wspgrade.suportedwfengines', 'zen', '51'), ('109', 'guse.logdir', '/guselogg', '51'), ('110', 'service.loglevel', '6', '51'), ('111', 'service.logtrace', 'false', '51'), ('112', 'guse.wfi.zen.sendinitstatus', 'true', '52'), ('113', 'wfi.zen.activeingjobs.max', '500000', '52'), ('114', 'wfi.zen.waiting.getjobcount', '60000', '52'), ('115', 'wfi.zen.loggfile', 'guselogg/wfi', '52'), ('116', 'wfi.incomingpoll.waiting', '1000', '52'), ('117', 'wfi.incomingpoll.sendcount', '100', '52'), ('118', 'guse.logdir', '/guselogg', '52'), ('119', 'service.loglevel', '6', '52'), ('120', 'system.id', 'guse3.4', '52'), ('121', 'tt.wsdl', 'http://portal.italiangrid.it:8080/management/TesterService?wsdl', '52'), ('122', 'history.max', '200', '53'), ('123', 'noproxy', 'DesktopGrid,Local,Unibroker', '53'), ('124', 'guse.wfs.system.defaultworkflowtype', 'zen', '53'), ('125', 'guse.wfs.system.savestatus', 'true', '53'), ('126', 'guse.wfs.system.sleepsavetime', '2000', '53'), ('127', 'guse.wfs.wfiplugin.zen', 'hu.sztaki.lpds.wfs.service.angie.plugins.wfi.ZenImpl', '53'), ('128', 'guse.wfs.system.savevisualizerdata', 'true', '53'), ('129', 'guse.wfs.system.saveonlyendstatus', 'false', '53'), ('130', 'guse.storageclient.localmode.sendquota', 'true', '55'), ('131', 'guse.storage.importid.type', 'date', '55'), ('132', 'guse.storage.system.defaultworkflowtype', 'zen', '55'), ('133', 'rootuser', 'root', '56'), ('134', 'quotamax', '2000', '56'), ('135', 'guse.storage.importid.type', 'date', '56'), ('136', 'jobinstancetimeout', '1', '60'), ('137', 'statrunningtimeout', '1', '60'), ('138', 'aggregatejoblimit', '250', '60'), ('139', 'sleeptime', '100', '60'), ('140', 'language', 'hu', '61'), ('141', 'country', 'HU', '61'), ('142', 'portal.url', 'http://portal.italiangrid.it:8080/wspgrade', '61'), ('143', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '51'), ('144', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '51'), ('145', 'guse.system.database.user', 'guse', '51'), ('146', 'guse.system.database.password', 'gusepass', '51'), ('147', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '52'), ('148', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '52'), ('149', 'guse.system.database.user', 'guse', '52'), ('150', 'guse.system.database.password', 'gusepass', '52'), ('251', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '53'), ('252', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '53'), ('253', 'guse.system.database.user', 'guse', '53'), ('254', 'guse.system.database.password', 'gusepass', '53'), ('255', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '54'), ('256', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '54'), ('257', 'guse.system.database.user', 'guse', '54'), ('258', 'guse.system.database.password', 'gusepass', '54'), ('259', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '55'), ('260', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '55'), ('261', 'guse.system.database.user', 'guse', '55'), ('262', 'guse.system.database.password', 'gusepass', '55'), ('263', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '56'), ('264', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '56'), ('265', 'guse.system.database.user', 'guse', '56'), ('266', 'guse.system.database.password', 'gusepass', '56'), ('267', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '57'), ('268', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '57'), ('269', 'guse.system.database.user', 'guse', '57'), ('270', 'guse.system.database.password', 'gusepass', '57'), ('271', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '58'), ('272', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '58'), ('273', 'guse.system.database.user', 'guse', '58'), ('274', 'guse.system.database.password', 'gusepass', '58'), ('275', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '59'), ('276', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '59'), ('277', 'guse.system.database.user', 'guse', '59'), ('278', 'guse.system.database.password', 'gusepass', '59'), ('279', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '60'), ('280', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '60'), ('281', 'guse.system.database.user', 'guse', '60'), ('282', 'guse.system.database.password', 'gusepass', '60'), ('283', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '61'), ('284', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '61'), ('285', 'guse.system.database.user', 'guse', '61'), ('286', 'guse.system.database.password', 'gusepass', '61'), ('701', 'notify.smtp.host', 'localhost', '51'), ('1751', 'cache.time.msec', '3000000', '1701'), ('1752', 'repeat.submit.workflow', '1', '1701'), ('1753', 'notify.quota.time.in.hour', '1', '1701'), ('1754', 'notify.quota.max.percent', '95', '1701'), ('1755', 'gemlcacache.refreshintervall_min', '30', '1701'), ('1756', 'wspgrade.maxulpoadfilesize', '100', '1701'), ('1757', 'guse.wspgrade.suportedwfengines', 'zen', '1701'), ('1758', 'guse.logdir', '/guselogg', '1701'), ('1759', 'service.loglevel', '6', '1701'), ('1760', 'service.logtrace', 'false', '1701'), ('1765', 'notify.smtp.host', 'localhost', '1701'), ('1766', 'guse.system.database.driver', 'com.mysql.jdbc.Driver', '1701'), ('1767', 'guse.system.database.url', 'jdbc:mysql://localhost:3306/guse', '1701'), ('1768', 'guse.system.database.user', 'guse', '1701'), ('1769', 'guse.system.database.password', 'gusepass', '1701');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;