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

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `servicetype`
-- ----------------------------
DROP TABLE IF EXISTS `servicetype`;
CREATE TABLE `servicetype` (
  `id` bigint(20) NOT NULL,
  `sname` varchar(255) default NULL,
  `txt` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `servicetype`
-- ----------------------------
BEGIN;
INSERT INTO `servicetype` VALUES ('1', 'information', 'Information service'), ('2', 'logg', 'Logging service'), ('3', 'wfi', 'Wotkflow Interpreter service'), ('4', 'wfs', 'Workflow Storage service'), ('5', 'storage', 'Local file storage service'), ('6', 'submitter', 'Resource handler service'), ('7', 'portal', 'User interface'), ('8', 'repository', 'Workflow repository'), ('9', 'gemlcaquery', 'Gemlca information system'), ('10', 'serviceadmin', 'gUSE service admin'), ('11', 'resourceconfigure', 'gUSE DCI-Bridge resource admin'), ('12', 'statistics', 'for Statistics components');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;