kettle7不显示资源库

最新推荐文章于 2022-08-11 21:50:25 发布
千里草竹
最新推荐文章于 2022-08-11 21:50:25 发布
阅读量2.1k
点赞数 1
分类专栏： kettle
本文链接：https://blog.csdn.net/u012848709/article/details/83664126
版权
kettle 专栏收录该内容
21 篇文章 6 订阅
订阅专栏
楔子

使用kettle7 数据库资源库时，不显示资源库的连接，升级IE8为IE9后显示出来。
kettle6 基于MySQL创建资源库执行脚本报错，它使用了boolean值为Y 和N 但是在kettle7同样基于MySQL创建资源库，没报错正常执行的
在这里插入图片描述
之前使用浏览器是IE8,升级为IE9后显示出来
在这里插入图片描述
界面实现不正常

如果界面实现不太正常，设置语言如下
kettle6基于MySQL创建资源库脚本

-- Repository creation/upgrade DDL: 
--
-- Nothing was created nor modified in the target repository database.
-- Hit the OK button to execute the generated SQL or Close to reject the changes.
-- Please note that it is possible to change/edit the generated SQL before execution.
--
 
CREATE TABLE R_VERSION
(
  ID_VERSION BIGINT NOT NULL PRIMARY KEY
, MAJOR_VERSION INT
, MINOR_VERSION INT
, UPGRADE_DATE DATETIME
, IS_UPGRADE BOOLEAN
)
;

INSERT INTO R_VERSION(ID_VERSION, MAJOR_VERSION, MINOR_VERSION, UPGRADE_DATE, IS_UPGRADE) VALUES (1,5,0,'2018/11/02 22:44:22.120','0');

CREATE TABLE R_DATABASE_TYPE
(
  ID_DATABASE_TYPE BIGINT NOT NULL PRIMARY KEY
, CODE VARCHAR(255)
, DESCRIPTION VARCHAR(255)
)
;

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (1,'INGRES','Ingres');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (2,'INTERBASE','Borland Interbase');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (3,'INFOBRIGHT','Infobright');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (4,'ORACLE','Oracle');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (5,'EXTENDB','ExtenDB');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (6,'MSACCESS','MS Access');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (7,'SYBASE','Sybase');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (8,'PALO','Palo MOLAP Server');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (9,'INFORMIX','Informix');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (10,'LucidDB','LucidDB');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (11,'TERADATA','Teradata');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (12,'UNIVERSE','UniVerse database');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (13,'MONETDB','MonetDB');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (14,'CACHE','Intersystems Cache');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (15,'MSSQL','MS SQL Server');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (16,'GREENPLUM','Greenplum');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (17,'KettleThin','Pentaho Data Services');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (18,'GENERIC','Generic database');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (19,'SQLITE','SQLite');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (20,'REMEDY-AR-SYSTEM','Remedy Action Request System');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (21,'MONDRIAN','Native Mondrian');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (22,'NETEZZA','Netezza');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (23,'VERTICA5','Vertica 5+');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (24,'IMPALA','Impala');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (25,'POSTGRESQL','PostgreSQL');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (26,'EXASOL4','Exasol 4');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (27,'HYPERSONIC','Hypersonic');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (28,'AS/400','AS/400');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (29,'ORACLERDB','Oracle RDB');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (30,'DBASE','dBase III, IV or 5');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (31,'KINGBASEES','KingbaseES');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (32,'HIVE','Hadoop Hive');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (33,'SAPR3','SAP ERP System');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (34,'SQLBASE','Gupta SQL Base');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (35,'DERBY','Apache Derby');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (36,'VERTICA','Vertica');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (37,'INFINIDB','Calpont InfiniDB');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (38,'HIVE2','Hadoop Hive 2');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (39,'MYSQL','MySQL');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (40,'MSSQLNATIVE','MS SQL Server (Native)');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (41,'H2','H2');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (42,'SAPDB','MaxDB (SAP DB)');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (43,'VECTORWISE','Ingres VectorWise');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (44,'DB2','IBM DB2');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (45,'NEOVIEW','Neoview');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (46,'IMPALASIMBA','Cloudera Impala');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (47,'SYBASEIQ','SybaseIQ');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (48,'REDSHIFT','Redshift');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (49,'FIREBIRD','Firebird SQL');

INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (50,'OpenERPDatabaseMeta','OpenERP Server');

CREATE TABLE R_DATABASE_CONTYPE
(
  ID_DATABASE_CONTYPE BIGINT NOT NULL PRIMARY KEY
, CODE VARCHAR(255)
, DESCRIPTION VARCHAR(255)
)
;

INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (1,'Native','Native (JDBC)');

INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (2,'ODBC','ODBC');

INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (3,'OCI','OCI');

INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (4,'Plugin','Plugin specific access method');

INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (5,'JNDI','JNDI');

INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (6,',','Custom');

CREATE TABLE R_NOTE
(
  ID_NOTE BIGINT NOT NULL PRIMARY KEY
, VALUE_STR MEDIUMTEXT
, GUI_LOCATION_X INT
, GUI_LOCATION_Y INT
, GUI_LOCATION_WIDTH INT
, GUI_LOCATION_HEIGHT INT
, FONT_NAME MEDIUMTEXT
, FONT_SIZE INT
, FONT_BOLD BOOLEAN
, FONT_ITALIC BOOLEAN
, FONT_COLOR_RED INT
, FONT_COLOR_GREEN INT
, FONT_COLOR_BLUE INT
, FONT_BACK_GROUND_COLOR_RED INT
, FONT_BACK_GROUND_COLOR_GREEN INT
, FONT_BACK_GROUND_COLOR_BLUE INT
, FONT_BORDER_COLOR_RED INT
, FONT_BORDER_COLOR_GREEN INT
, FONT_BORDER_COLOR_BLUE INT
, DRAW_SHADOW BOOLEAN
)
;

CREATE TABLE R_DATABASE
(
  ID_DATABASE BIGINT NOT NULL PRIMARY KEY
, NAME VARCHAR(255)
, ID_DATABASE_TYPE INT
, ID_DATABASE_CONTYPE INT
, HOST_NAME VARCHAR(255)
, DATABASE_NAME MEDIUMTEXT
, PORT INT
, USERNAME VARCHAR(255)
, PASSWORD VARCHAR(255)
, SERVERNAME VARCHAR(255)
, DATA_TBS VARCHAR(255)
, INDEX_TBS VARCHAR(255)
)
;

CREATE TABLE R_DATABASE_ATTRIBUTE
(
  ID_DATABASE_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
, ID_DATABASE INT
, CODE VARCHAR(255)
, VALUE_STR MEDIUMTEXT
)
;

CREATE UNIQUE INDEX IDX_RDAT ON R_DATABASE_ATTRIBUTE(ID_DATABASE, CODE)
;

CREATE TABLE R_DIRECTORY
(
  ID_DIRECTORY BIGINT NOT NULL PRIMARY KEY
, ID_DIRECTORY_PARENT INT
, DIRECTORY_NAME VARCHAR(255)
)
;

CREATE UNIQUE INDEX IDX_RDIR ON R_DIRECTORY(ID_DIRECTORY_PARENT, DIRECTORY_NAME)
;

CREATE TABLE R_TRANSFORMATION
(
  ID_TRANSFORMATION BIGINT NOT NULL PRIMARY KEY
, ID_DIRECTORY INT
, NAME VARCHAR(255)
, DESCRIPTION MEDIUMTEXT
, EXTENDED_DESCRIPTION MEDIUMTEXT
, TRANS_VERSION VARCHAR(255)
, TRANS_STATUS INT
, ID_STEP_READ INT
, ID_STEP_WRITE INT
, ID_STEP_INPUT INT
, ID_STEP_OUTPUT INT
, ID_STEP_UPDATE INT
, ID_DATABASE_LOG INT
, TABLE_NAME_LOG VARCHAR(255)
, USE_BATCHID BOOLEAN
, USE_LOGFIELD BOOLEAN
, ID_DATABASE_MAXDATE INT
, TABLE_NAME_MAXDATE VARCHAR(255)
, FIELD_NAME_MAXDATE VARCHAR(255)
, OFFSET_MAXDATE DOUBLE
, DIFF_MAXDATE DOUBLE
, CREATED_USER VARCHAR(255)
, CREATED_DATE DATETIME
, MODIFIED_USER VARCHAR(255)
, MODIFIED_DATE DATETIME
, SIZE_ROWSET INT
)
;

CREATE TABLE R_TRANS_ATTRIBUTE
(
  ID_TRANS_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, NR INT
, CODE VARCHAR(255)
, VALUE_NUM BIGINT
, VALUE_STR MEDIUMTEXT
)
;

CREATE UNIQUE INDEX IDX_TATT ON R_TRANS_ATTRIBUTE(ID_TRANSFORMATION, CODE, NR)
;

CREATE TABLE R_JOB_ATTRIBUTE
(
  ID_JOB_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
, ID_JOB INT
, NR INT
, CODE VARCHAR(255)
, VALUE_NUM BIGINT
, VALUE_STR MEDIUMTEXT
)
;

CREATE UNIQUE INDEX IDX_JATT ON R_JOB_ATTRIBUTE(ID_JOB, CODE, NR)
;

CREATE TABLE R_DEPENDENCY
(
  ID_DEPENDENCY BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, ID_DATABASE INT
, TABLE_NAME VARCHAR(255)
, FIELD_NAME VARCHAR(255)
)
;

CREATE TABLE R_PARTITION_SCHEMA
(
  ID_PARTITION_SCHEMA BIGINT NOT NULL PRIMARY KEY
, NAME VARCHAR(255)
, DYNAMIC_DEFINITION BOOLEAN
, PARTITIONS_PER_SLAVE VARCHAR(255)
)
;

CREATE TABLE R_PARTITION
(
  ID_PARTITION BIGINT NOT NULL PRIMARY KEY
, ID_PARTITION_SCHEMA INT
, PARTITION_ID VARCHAR(255)
)
;

CREATE TABLE R_TRANS_PARTITION_SCHEMA
(
  ID_TRANS_PARTITION_SCHEMA BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, ID_PARTITION_SCHEMA INT
)
;

CREATE TABLE R_CLUSTER
(
  ID_CLUSTER BIGINT NOT NULL PRIMARY KEY
, NAME VARCHAR(255)
, BASE_PORT VARCHAR(255)
, SOCKETS_BUFFER_SIZE VARCHAR(255)
, SOCKETS_FLUSH_INTERVAL VARCHAR(255)
, SOCKETS_COMPRESSED BOOLEAN
, DYNAMIC_CLUSTER BOOLEAN
)
;

CREATE TABLE R_SLAVE
(
  ID_SLAVE BIGINT NOT NULL PRIMARY KEY
, NAME VARCHAR(255)
, HOST_NAME VARCHAR(255)
, PORT VARCHAR(255)
, WEB_APP_NAME VARCHAR(255)
, USERNAME VARCHAR(255)
, PASSWORD VARCHAR(255)
, PROXY_HOST_NAME VARCHAR(255)
, PROXY_PORT VARCHAR(255)
, NON_PROXY_HOSTS VARCHAR(255)
, MASTER BOOLEAN
)
;

CREATE TABLE R_CLUSTER_SLAVE
(
  ID_CLUSTER_SLAVE BIGINT NOT NULL PRIMARY KEY
, ID_CLUSTER INT
, ID_SLAVE INT
)
;

CREATE TABLE R_TRANS_SLAVE
(
  ID_TRANS_SLAVE BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, ID_SLAVE INT
)
;

CREATE TABLE R_TRANS_CLUSTER
(
  ID_TRANS_CLUSTER BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, ID_CLUSTER INT
)
;

CREATE TABLE R_TRANS_HOP
(
  ID_TRANS_HOP BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, ID_STEP_FROM INT
, ID_STEP_TO INT
, ENABLED BOOLEAN
)
;

CREATE TABLE R_TRANS_STEP_CONDITION
(
  ID_TRANSFORMATION INT
, ID_STEP INT
, ID_CONDITION INT
)
;

CREATE TABLE R_CONDITION
(
  ID_CONDITION BIGINT NOT NULL PRIMARY KEY
, ID_CONDITION_PARENT INT
, NEGATED BOOLEAN
, OPERATOR VARCHAR(255)
, LEFT_NAME VARCHAR(255)
, CONDITION_FUNCTION VARCHAR(255)
, RIGHT_NAME VARCHAR(255)
, ID_VALUE_RIGHT INT
)
;

CREATE TABLE R_VALUE
(
  ID_VALUE BIGINT NOT NULL PRIMARY KEY
, NAME VARCHAR(255)
, VALUE_TYPE VARCHAR(255)
, VALUE_STR VARCHAR(255)
, IS_NULL BOOLEAN
)
;

CREATE TABLE R_STEP_TYPE
(
  ID_STEP_TYPE BIGINT NOT NULL PRIMARY KEY
, CODE VARCHAR(255)
, DESCRIPTION VARCHAR(255)
, HELPTEXT VARCHAR(255)
)
;

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (1,'Delete','删除','基于关键字删除记录');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (2,'WriteToLog','写日志','!BaseStep.TypeTooltipDesc.WriteToLog!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (3,'SyslogMessage','发送信息至Syslog','!BaseStep.TypeTooltipDesc.SyslogMessage!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (4,'TextFileOutput','文本文件输出','写记录到一个文本文件.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (5,'MultiwayMergeJoin','Multiway Merge Join','!BaseStep.TypeTooltipDesc.MultiwayMergeJoin!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (6,'LDAPOutput','LDAP 输出','!BaseStep.TypeTooltipDesc.LDAPOutput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (7,'AccessInput','Access 输入','!BaseStep.TypeTooltipDesc.AccessInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (8,'JoinRows','记录关联 (笛卡尔输出)','这个步骤的输出是输入流的笛卡尔的结果.{0} 输出结果的记录数是输入流记录之间的乘积.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (9,'JsonInput','!JsonInput.name!','!JsonInput.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (10,'TableOutput','表输出','写信息到一个数据库表');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (11,'MySQLBulkLoader','MySQL 批量加载','!BaseStep.TypeTooltipDesc.MySQLBulkLoader!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (12,'SingleThreader','Single Threader','!BaseStep.TypeTooltipDesc.SingleThreader!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (13,'HL7Input','!HL7Input.Name!','!HL7Input.TooltipDesc!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (14,'RandomCCNumberGenerator','生成随机的信用卡号','!BaseStep.TypeTooltipDesc.RandomCCNumberGenerator!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (15,'RegexEval','正则表达式','!BaseStep.TypeTooltipDesc.RegexEval!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (16,'PaloDimOutput','!PaloDimOutput.TransName!','!PaloDimOutput.TransDescription!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (17,'S3FileOutputPlugin','!S3FileOutput.Name!','!S3FileOutput.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (18,'IfNull','替换NULL值','!BaseStep.TypeTooltipDesc.IfNull!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (19,'ColumnExists','检查表里的列是否存在','!BaseStep.TypeTooltipDesc.ColumnExists!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (20,'FileLocked','检查文件是否已被锁定','!BaseStep.TypeTooltipDesc.FileLocked!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (21,'SocketWriter','Socket 写','!BaseStep.TypeTooltipDesc.SocketWriter!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (22,'ExcelInput','Excel输入','从一个微软的Excel文件里读取数据. 兼容Excel 95, 97 and 2000.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (23,'TeraFast','Teradata Fastload 批量加载','!BaseStep.TypeTooltipDesc.TeraFast!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (24,'DataGrid','自定义常量数据','!BaseStep.TypeTooltipDesc.DataGrid!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (25,'DetectLastRow','识别流的最后一行','!BaseStep.TypeTooltipDesc.DetectLastRow!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (26,'TypeExitEdi2XmlStep','!BaseStep.TypeLongDesc.Edi2Xml!','!BaseStep.TypeTooltipDesc.Edi2Xml!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (27,'SortRows','排序记录','基于字段值把记录排序(升序或降序)');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (28,'FieldsChangeSequence','根据字段值来改变序列','!BaseStep.TypeTooltipDesc.FieldsChangeSequence!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (29,'RowsFromResult','从结果获取记录','这个允许你从同一个任务的前一个条目里读取记录.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (30,'JobExecutor','执行作业','!BaseStep.TypeTooltipDesc.JobExecutor!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (31,'BlockUntilStepsFinish','阻塞数据直到步骤都完成','!BaseStep.TypeTooltipDesc.BlockUntilStepsFinish!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (32,'AutoDoc','自动文档输出','!BaseStep.TypeTooltipDesc.AutoDoc!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (33,'SFTPPut','!BaseStep.TypeLongDesc.SFTPPut!','!BaseStep.TypeTooltipDesc.SFTPPut!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (34,'ProcessFiles','处理文件','!BaseStep.TypeTooltipDesc.ProcessFiles!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (35,'RuleAccumulator','!RulesAccumulator.StepConfigruationDialog.Title!','!RulesAccumulator.StepConfigruationDialog.TooltipDesc!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (36,'DimensionLookup','维度查询/更新','在一个数据仓库里更新一个渐变维 {0} 或者在这个维里查询信息.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (37,'TypeExitGoogleAnalyticsInputStep','!GoogleAnalytics.TypeLongDesc.GoogleAnalyticsStep!','!GoogleAnalytics.TypeTooltipDesc.GoogleAnalyticsStep!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (38,'PaloCellInput','!PaloCellInput.TransName!','!PaloCellInput.TransDescription!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (39,'HadoopExitPlugin','!HadoopExitPlugin.Name!','!HadoopExitPlugin.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (40,'Append','追加流','!BaseStep.TypeTooltipDesc.Append!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (41,'ZipFile','Zip 文件','!BaseStep.TypeTooltipDesc.ZipFile!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (42,'StringCut','剪切字符串','!BaseStep.TypeTooltipDesc.StringCut!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (43,'MergeRows','合并记录','合并两个数据流, 并根据某个关键字排序.  这两个数据流被比较，以标识相等的、变更的、删除的和新建的记录.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (44,'Validator','数据检验','!BaseStep.TypeTooltipDesc.Validator!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (45,'SSTableOutput','SSTable Output','Writes to a filesystem directory as a Cassandra SSTable');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (46,'HBaseOutput','!HBaseOutput.Name!','!HBaseOutput.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (47,'MemoryGroupBy','在内存中分组','!BaseStep.TypeTooltipDesc.MemoryGroupby!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (48,'SystemInfo','获取系统信息','获取系统信息，例如时间、日期.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (49,'Denormaliser','列转行','Denormalises rows by looking up key-value pairs and by assigning them to new fields in the输出 rows.{0}This method aggregates and needs the输入 rows to be sorted on the grouping fields');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (50,'ExcelOutput','Excel输出','!BaseStep.TypeTooltipDesc.ExcelOutput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (51,'OlapInput','OLAP 输入','!BaseStep.TypeTooltipDesc.OlapInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (52,'Delay','延迟行','!BaseStep.TypeTooltipDesc.Delay!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (53,'NullIf','设置值为NULL','如果一个字段值等于某个固定值，那么把这个字段值设置成null');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (54,'SalesforceInput','!SalesforceInput.TypeLongDesc.SalesforceInput!','!SalesforceInput.TypeTooltipDesc.SalesforceInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (55,'CallEndpointStep','!CallEndpointMeta.Name!','!CallEndpointMeta.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (56,'SocketReader','Socket 读','!BaseStep.TypeTooltipDesc.SocketReader!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (57,'CombinationLookup','联合查询/更新','更新数据仓库里的一个junk维 {0} 可选的, 科研查询维里的信息.{1}junk维的主键是所有的字段.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (58,'FilesToResult','复制文件到结果','!BaseStep.TypeTooltipDesc.FilesToResult!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (59,'GPBulkLoader','!GPBulkLoaderMeta.Name!','!GPBulkLoaderMeta.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (60,'VerticaBulkLoader','!VerticaBulkLoaderMeta.TypeLongDesc!','!VerticaBulkLoaderMeta.TypeTooltipDesc!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (61,'SalesforceDelete','!SalesforceDelete.TypeLongDesc.SalesforceDelete!','!SalesforceDelete.TypeTooltipDesc.SalesforceDelete!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (62,'HTTP','HTTP client','!BaseStep.TypeTooltipDesc.HTTP!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (63,'XSDValidator','!XSDValidator.name!','!XSDValidator.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (64,'SetValueConstant','将字段值设置为常量','!BaseStep.TypeTooltipDesc.SetValueConstant!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (65,'ScriptValueMod','JavaScript代码','!BaseStep.TypeTooltipDesc.JavaScriptValueMod!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (66,'CassandraInput','Cassandra Input','Reads data from a Cassandra table');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (67,'SwitchCase','Switch / Case','!BaseStep.TypeTooltipDesc.SwitchCase!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (68,'DBLookup','数据库查询','使用字段值在数据库里查询值');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (69,'FuzzyMatch','模糊匹配','!BaseStep.TypeTooltipDesc.FuzzyMatch!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (70,'TeraDataBulkLoader','Teradata TPT Bulk Loader','Teradata TPT bulkloader, using tbuild command');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (71,'TextFileInput','文本文件输入','从一个文本文件（几种格式）里读取数据{0}这些数据可以被传递到下一个步骤里...');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (72,'SalesforceInsert','!SalesforceInsert.TypeLongDesc.SalesforceInsert!','!SalesforceInsert.TypeTooltipDesc.SalesforceInsert!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (73,'CouchDbInput','!CouchDbInput.Name!','!CouchDbInput.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (74,'ShapeFileReader','!ShapeFileReader.Step.Name!','!ShapeFileReader.Step.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (75,'RssInput','RSS 输入','!BaseStep.TypeTooltipDesc.RssInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (76,'Unique','去除重复记录','去除重复的记录行，保持记录唯一{0}这个仅仅基于一个已经排好序的输入.{1}如果输入没有排序, 仅仅两个连续的记录行被正确处理.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (77,'InfobrightOutput','Infobright 批量加载','!BaseStep.TypeTooltipDesc.InfobrightOutput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (78,'UserDefinedJavaClass','Java 代码','!BaseStep.TypeTooltipDesc.UserDefinedJavaClass!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (79,'OraBulkLoader','Oracle 批量加载','!BaseStep.TypeTooltipDesc.OraBulkLoader!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (80,'StepsMetrics','转换步骤信息统计','!BaseStep.TypeTooltipDesc.StepsMetrics!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (81,'AvroInput','!AvroInput.Name!','!AvroInput.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (82,'GetTableNames','获取表名','!BaseStep.TypeTooltipDesc.GetTableNames!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (83,'SetSessionVariableStep','!SetSessionVariableMeta.Name!','!SetSessionVariableMeta.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (84,'MappingInput','映射输入规范','指定一个映射的字段输入');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (85,'Abort','中止','!BaseStep.TypeTooltipDesc.Abort!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (86,'PropertyOutput','配置文件输出','!BaseStep.TypeTooltipDesc.PropertyOutput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (87,'JsonOutput','!JsonOutput.name!','!JsonOutput.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (88,'TableExists','检查表是否存在','!BaseStep.TypeTooltipDesc.TableExists!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (89,'DetectEmptyStream','检测空流','!BaseStep.TypeTooltipDesc.DetectEmptyStream!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (90,'GPLoad','!GPLoad.TypeLongDesc!','!GPLoad.TypeLongDesc!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (91,'PaloDimInput','!PaloDimInput.TransName!','!PaloDimInput.TransDescription!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (92,'Normaliser','行转列','De-normalised information can be normalised using this step type.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (93,'SelectValues','字段选择','选择或移除记录里的字。{0}此外，可以设置字段的元数据: 类型, 长度和精度.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (94,'XMLInputStream','!XMLInputStream.name!','!XMLInputStream.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (95,'Flattener','行扁平化','Flattens consequetive rows based on the order in which they appear in the输入 stream');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (96,'InsertUpdate','插入 / 更新','基于关键字更新或插入记录到数据库.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (97,'MondrianInput','Mondrian 输入','!BaseStep.TypeTooltipDesc.MondrianInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (98,'SQLFileOutput','SQL 文件输出','!BaseStep.TypeTooltipDesc.SQLFileOutput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (99,'ReplaceString','字符串替换','!BaseStep.TypeTooltipDesc.ReplaceString!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (100,'CubeInput','Cube 文件输入','从一个cube读取记录.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (101,'WebServiceLookup','Web 服务查询','使用 Web 服务查询信息');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (102,'TableCompare','比较表','!BaseStep.TypeTooltipDesc.TableCompare!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (103,'MailValidator','检验邮件地址','!BaseStep.TypeTooltipDesc.MailValidator!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (104,'OpenERPObjectOutputImport','!OpenERPObjectOutput.TransName!','!OpenERPObjectOutput.TransDescription!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (105,'RowGenerator','生成记录','产生一些空记录或相等的行.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (106,'HBaseInput','!HBaseInput.Name!','!HBaseInput.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (107,'DBJoin','数据库连接','使用数据流里的值作为参数执行一个数据库查询');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (108,'RuleExecutor','!RulesExecutor.StepConfigruationDialog.Title!','!RulesExecutor.StepConfigruationDialog.TooltipDesc!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (109,'MergeJoin','记录集连接','!BaseStep.TypeTooltipDesc.MergeJoin!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (110,'OpenERPObjectInput','!OpenERPObjectInput.TransName!','!OpenERPObjectInput.TransDescription!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (111,'HadoopFileInputPlugin','!HadoopFileInputPlugin.Name!','!HadoopFileInputPlugin.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (112,'SalesforceUpdate','!SalesforceUpdate.TypeLongDesc.SalesforceUpdate!','!SalesforceUpdate.TypeTooltipDesc.SalesforceUpdate!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (113,'XMLJoin','!XMLJoin.name!','!XMLJoin.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (114,'GetVariable','获取变量','!BaseStep.TypeTooltipDesc.GetVariable!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (115,'HadoopFileOutputPlugin','!HadoopFileOutputPlugin.Name!','!HadoopFileOutputPlugin.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (116,'DBProc','调用DB存储过程','通过调用数据库存储过程获得返回值.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (117,'RssOutput','RSS 输出','!BaseStep.TypeTooltipDesc.RssOutput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (118,'S3CSVINPUT','!S3CsvInput.Step.Name!','!S3CsvInput.Step.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (119,'SimpleMapping','!BaseStep.TypeLongDesc.SimpleMappingSubTransformation!','!BaseStep.TypeTooltipDesc.SimpleMappingSubTransformation!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (120,'OpenERPObjectDelete','!OpenERPObjectDelete.TransName!','!OpenERPObjectDelete.TransDescription!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (121,'LDAPInput','LDAP 输入','!BaseStep.TypeTooltipDesc.LDAPInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (122,'XBaseInput','XBase输入','从一个XBase类型的文件(DBF)读取记录');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (123,'CheckSum','增加校验列','!BaseStep.TypeTooltipDesc.CheckSum!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (124,'MetaInject','ETL元数据注入','!BaseStep.TypeTooltipDesc.MetaInject!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (125,'ParallelGzipCsvInput','GZIP CSV Input','!BaseStep.TypeTooltipDesc.ParallelGzipCsvInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (126,'SortedMerge','排序合并','!BaseStep.TypeTooltipDesc.SortedMerge!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (127,'ChangeFileEncoding','改变文件编码','!BaseStep.TypeTooltipDesc.ChangeFileEncoding!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (128,'CreateSharedDimensions','!SharedDimension.TransName!','!SharedDimension.TransDescription!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (129,'LoadFileInput','文件内容加载至内存','!BaseStep.TypeTooltipDesc.LoadFileInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (130,'Janino','利用Janino计算Java表达式','!BaseStep.TypeTooltipDesc.Janino!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (131,'getXMLData','!GetXMLData.name!','!GetXMLData.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (132,'HBaseRowDecoder','!HBaseRowDecoder.Name!','!HBaseRowDecoder.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (133,'LDIFInput','LDIF 输入','!BaseStep.TypeTooltipDesc.LDIFInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (134,'PGBulkLoader','PostgreSQL 批量加载','!BaseStep.TypeTooltipDesc.PGBulkLoader!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (135,'CubeOutput','Cube输出','把数据写入一个cube');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (136,'SymmetricCryptoTrans','对称加密','!BaseStep.TypeTooltipDesc.SymmetricCryptography!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (137,'AddXML','!AddXML.name!','!AddXML.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (138,'TableInput','表输入','从数据库表里读取信息.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (139,'SASInput','SAS 输入','!BaseStep.TypeTooltipDesc.SASInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (140,'AccessOutput','Access 输出','!BaseStep.TypeTooltipDesc.AccessOutput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (141,'ElasticSearchBulk','!ElasticSearchBulk.TypeLongDesc.ElasticSearchBulk!','!ElasticSearchBulk.TypeTooltipDesc.ElasticSearchBulk!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (142,'GetFileNames','获取文件名','!BaseStep.TypeTooltipDesc.GetFileNames!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (143,'StringOperations','字符串操作','!BaseStep.TypeTooltipDesc.StringOperations!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (144,'HadoopEnterPlugin','!HadoopEnterPlugin.Name!','!HadoopEnterPlugin.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (145,'SetVariable','设置变量','!BaseStep.TypeTooltipDesc.SetVariable!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (146,'RandomValue','生成随机数','!BaseStep.TypeTooltipDesc.RandomValue!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (147,'GetSessionVariableStep','!GetSessionVariableMeta.Name!','!GetSessionVariableMeta.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (148,'FieldSplitter','拆分字段','当你想把一个字段拆分成多个时，使用这个类型.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (149,'BlockingStep','阻塞数据','!BaseStep.TypeTooltipDesc.BlockingStep!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (150,'CsvInput','CSV文件输入','!BaseStep.TypeTooltipDesc.CsvInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (151,'MongoDbInput','MongoDB Input','Reads from a Mongo DB collection');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (152,'PropertyInput','配置文件输入','!BaseStep.TypeTooltipDesc.PropertyInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (153,'SynchronizeAfterMerge','数据同步','!BaseStep.TypeTooltipDesc.SynchronizeAfterMerge!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (154,'StreamLookup','流查询','从转换中的其它流里查询值.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (155,'Dummy','空操作 (什么也不做)','这个步骤类型什么都不作.{0} 当你想测试或拆分数据流的时候有用.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (156,'PGPEncryptStream','!BaseStep.TypeLongDesc.PGPEncryptStream!','!BaseStep.TypeTooltipDesc.PGPEncryptStream!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (157,'GetFilesRowsCount','获取文件行数','!BaseStep.TypeTooltipDesc.GetFilesRowsCount!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (158,'SetValueField','设置字段值','!BaseStep.TypeTooltipDesc.SetValueField!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (159,'PGPDecryptStream','!BaseStep.TypeLongDesc.PGPDecryptStream!','!BaseStep.TypeTooltipDesc.PGPDecryptStream!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (160,'Mapping','映射 (子转换)','运行一个映射 (子转换), 使用MappingInput和MappingOutput来指定接口的字段');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (161,'DynamicSQLRow','执行Dynamic SQL','!BaseStep.TypeTooltipDesc.DynamicSQLRow!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (162,'Update','更新','基于关键字更新记录到数据库');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (163,'UniqueRowsByHashSet','唯一行 (哈希值)','!BaseStep.TypeTooltipDesc.UniqueRowsByHashSet!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (164,'Formula','公式','使用 Pentaho 的公式库来计算公式');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (165,'WebServiceAvailable','检查web服务是否可用','!BaseStep.TypeTooltipDesc.WebServiceAvailable!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (166,'ExecProcess','启动一个进程','!BaseStep.TypeTooltipDesc.ExecProcess!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (167,'Injector','记录注射','!BaseStep.TypeTooltipDesc.Injector!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (168,'SampleRows','样本行','!BaseStep.TypeTooltipDesc.SampleRows!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (169,'DummyStep','!DummyPlugin.Step.Name!','!DummyPlugin.Step.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (170,'GetSlaveSequence','Get ID from slave server','!BaseStep.TypeTooltipDesc.GetSlavesequence!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (171,'MongoDbOutput','MongoDB Output','Writes to a Mongo DB collection');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (172,'MappingOutput','映射输出规范','指定一个映射的字段输出');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (173,'FileExists','检查文件是否存在','!BaseStep.TypeTooltipDesc.FileExists!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (174,'Script','Script','!BaseStep.TypeTooltipDesc.Script!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (175,'GroupBy','分组','以分组的形式创建聚合.{0}这个仅仅在一个已经排好序的输入有效.{1}如果输入没有排序, 仅仅两个连续的记录行被正确处理.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (176,'GetRepositoryNames','获取资源库配置','!BaseStep.TypeTooltipDesc.GetRepositoryNames!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (177,'PaloCellOutput','!PaloCellOutput.TransName!','!PaloCellOutput.TransDescription!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (178,'ClosureGenerator','Closure Generator','!BaseStep.TypeTooltipDesc.ClosureGenerator!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (179,'Sequence','增加序列','从序列获取下一个值');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (180,'FilterRows','过滤记录','使用简单的相等来过滤记录');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (181,'VectorWiseBulkLoader','Ingres VectorWise 批量加载','!BaseStep.TypeTooltipDesc.VectorWiseBulkLoader!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (182,'ConcatFields','!BaseStep.TypeLongDesc.ConcatFields!','!BaseStep.TypeTooltipDesc.ConcatFields!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (183,'OldTextFileInput','!BaseStep.TypeLongDesc.OldTextFileInput!','从一个文本文件（几种格式）里读取数据{0}这些数据可以被传递到下一个步骤里...');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (184,'TypeExitExcelWriterStep','Microsoft Excel 输出','!BaseStep.TypeTooltipDesc.TypeExitExcelWriterStep!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (185,'AnalyticQuery','分析查询','!BaseStep.TypeTooltipDesc.AnalyticQuery!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (186,'FixedInput','固定宽度文件输入','!BaseStep.TypeTooltipDesc.FixedInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (187,'SapInput','SAP 输入','!BaseStep.TypeTooltipDesc.SapInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (188,'PrioritizeStreams','数据流优先级排序','!BaseStep.TypeTooltipDesc.PrioritizeStreams!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (189,'CassandraOutput','Cassandra Output','Writes to a Cassandra table');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (190,'ValueMapper','值映射','Maps values of a certain field from one value to another');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (191,'Constant','增加常量','给记录增加一到多个常量');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (192,'ExecSQLRow','执行SQL脚本(字段流替换)','!BaseStep.TypeTooltipDesc.ExecSQLRow!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (193,'JavaFilter','根据Java代码过滤记录','!BaseStep.TypeTooltipDesc.JavaFilter!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (194,'XMLOutput','!XMLOutput.name!','!XMLOutput.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (195,'ReservoirSampling','数据采样','!BaseStep.TypeTooltipDesc.ReservoirSampling!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (196,'SalesforceUpsert','!SalesforceUpsert.TypeLongDesc.SalesforceUpsert!','!SalesforceUpsert.TypeTooltipDesc.SalesforceUpsert!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (197,'RowsToResult','复制记录到结果','使用这个步骤把记录写到正在执行的任务.{0}信息将会被传递给同一个任务里的下一个条目.');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (198,'MonetDBAgileMart','!BaseStep.TypeLongDesc.MonetDBAgileMart!','!BaseStep.TypeTooltipDesc.MonetDBAgileMart!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (199,'ExecSQL','执行SQL脚本','执行一个SQL脚本, 另外，可以使用输入的记录作为参数');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (200,'Rest','REST Client','!BaseStep.TypeTooltipDesc.Rest!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (201,'TransExecutor','!BaseStep.TypeLongDesc.TransExecutor!','!BaseStep.TypeTooltipDesc.TransExecutor!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (202,'LucidDBStreamingLoader','!LucidDBStreamingLoaderMeta.Name!','!LucidDBStreamingLoaderMeta.Description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (203,'StepMetastructure','流的元数据','!BaseStep.TypeTooltipDesc.StepMetastructure!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (204,'Calculator','计算器','通过执行简单的计算创建一个新字段');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (205,'SplitFieldToRows3','列拆分为多行','!BaseStep.TypeTooltipDesc.SplitFieldToRows3!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (206,'YamlInput','Yaml 输入','!BaseStep.TypeTooltipDesc.YamlInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (207,'FilesFromResult','从结果获取文件','!BaseStep.TypeTooltipDesc.FilesFromResult!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (208,'UnivariateStats','单变量统计','!BaseStep.TypeTooltipDesc.UnivariateStats!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (209,'SSH','运行SSH命令','!BaseStep.TypeTooltipDesc.SSH!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (210,'XSLT','!XSLT.name!','!XSLT.description!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (211,'MailInput','邮件信息输入','!BaseStep.TypeTooltipDesc.MailInput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (212,'CloneRow','克隆行','!BaseStep.TypeTooltipDesc.CloneRow!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (213,'TableAgileMart','!BaseStep.TypeLongDesc.TableAgileMart!','!BaseStep.TypeTooltipDesc.TableAgileMart!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (214,'HTTPPOST','HTTP Post','!BaseStep.TypeTooltipDesc.HTTPPOST!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (215,'GetSubFolders','获取子目录名','!BaseStep.TypeTooltipDesc.GetSubFolders!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (216,'NumberRange','数值范围','!BaseStep.TypeTooltipDesc.NumberRange!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (217,'CreditCardValidator','检验信用卡号码是否有效','!BaseStep.TypeTooltipDesc.CreditCardValidator!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (218,'MonetDBBulkLoader','MonetDB 批量加载','!BaseStep.TypeTooltipDesc.MonetDBBulkLoader!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (219,'Mail','发送邮件','!BaseStep.TypeTooltipDesc.Mail!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (220,'SecretKeyGenerator','生成密钥','!BaseStep.TypeTooltipDesc.SecretKeyGenerator!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (221,'PentahoReportingOutput','Pentaho 报表输出','!BaseStep.TypeTooltipDesc.PentahoReportingOutput!');

INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (222,'FieldMetadataAnnotation','!ModelAnnotation.TransName!','!ModelAnnotation.TransDescription!');

CREATE TABLE R_STEP
(
  ID_STEP BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, NAME VARCHAR(255)
, DESCRIPTION MEDIUMTEXT
, ID_STEP_TYPE INT
, DISTRIBUTE BOOLEAN
, COPIES INT
, GUI_LOCATION_X INT
, GUI_LOCATION_Y INT
, GUI_DRAW BOOLEAN
, COPIES_STRING VARCHAR(255)
)
;

CREATE TABLE R_STEP_ATTRIBUTE
(
  ID_STEP_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, ID_STEP INT
, NR INT
, CODE VARCHAR(255)
, VALUE_NUM BIGINT
, VALUE_STR MEDIUMTEXT
)
;

CREATE UNIQUE INDEX IDX_RSAT ON R_STEP_ATTRIBUTE(ID_STEP, CODE, NR)
;

CREATE TABLE R_STEP_DATABASE
(
  ID_TRANSFORMATION INT
, ID_STEP INT
, ID_DATABASE INT
)
;

CREATE INDEX IDX_RSD1 ON R_STEP_DATABASE(ID_TRANSFORMATION)
;

CREATE INDEX IDX_RSD2 ON R_STEP_DATABASE(ID_DATABASE)
;

CREATE TABLE R_TRANS_NOTE
(
  ID_TRANSFORMATION INT
, ID_NOTE INT
)
;

CREATE TABLE R_LOGLEVEL
(
  ID_LOGLEVEL BIGINT NOT NULL PRIMARY KEY
, CODE VARCHAR(255)
, DESCRIPTION VARCHAR(255)
)
;

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (1,'Error','错误日志');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (2,'Minimal','最小日志');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (3,'Basic','基本日志');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (4,'Detailed','详细日志');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (5,'Debug','调试');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (6,'Rowlevel','行级日志(非常详细)');

CREATE TABLE R_LOG
(
  ID_LOG BIGINT NOT NULL PRIMARY KEY
, NAME VARCHAR(255)
, ID_LOGLEVEL INT
, LOGTYPE VARCHAR(255)
, FILENAME VARCHAR(255)
, FILEEXTENTION VARCHAR(255)
, ADD_DATE BOOLEAN
, ADD_TIME BOOLEAN
, ID_DATABASE_LOG INT
, TABLE_NAME_LOG VARCHAR(255)
)
;

CREATE TABLE R_JOB
(
  ID_JOB BIGINT NOT NULL PRIMARY KEY
, ID_DIRECTORY INT
, NAME VARCHAR(255)
, DESCRIPTION MEDIUMTEXT
, EXTENDED_DESCRIPTION MEDIUMTEXT
, JOB_VERSION VARCHAR(255)
, JOB_STATUS INT
, ID_DATABASE_LOG INT
, TABLE_NAME_LOG VARCHAR(255)
, CREATED_USER VARCHAR(255)
, CREATED_DATE DATETIME
, MODIFIED_USER VARCHAR(255)
, MODIFIED_DATE DATETIME
, USE_BATCH_ID BOOLEAN
, PASS_BATCH_ID BOOLEAN
, USE_LOGFIELD BOOLEAN
, SHARED_FILE VARCHAR(255)
)
;

CREATE TABLE R_JOBENTRY_DATABASE
(
  ID_JOB INT
, ID_JOBENTRY INT
, ID_DATABASE INT
)
;

CREATE INDEX IDX_RJD1 ON R_JOBENTRY_DATABASE(ID_JOB)
;

CREATE INDEX IDX_RJD2 ON R_JOBENTRY_DATABASE(ID_DATABASE)
;

CREATE TABLE R_JOBENTRY_TYPE
(
  ID_JOBENTRY_TYPE BIGINT NOT NULL PRIMARY KEY
, CODE VARCHAR(255)
, DESCRIPTION VARCHAR(255)
)
;

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (1,'SqoopExport','!Sqoop.Export.PluginName!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (2,'WEBSERVICE_AVAILABLE','检查web服务是否可用');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (3,'MYSQL_BULK_FILE','从 Mysql 批量导出到文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (4,'COPY_MOVE_RESULT_FILENAMES','复制/移动结果文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (5,'HadoopCopyFilesPlugin','!HadoopCopyFilesPlugin.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (6,'XSD_VALIDATOR','!XSD_VALIDATOR.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (7,'SPECIAL','特殊作业项');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (8,'FILE_COMPARE','比较文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (9,'CREATE_FOLDER','创建一个目录');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (10,'MAIL_VALIDATOR','邮件验证');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (11,'PALO_CUBE_DELETE','!PaloCubeDelete.JobName!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (12,'MAIL','发送邮件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (13,'TRUNCATE_TABLES','清空表');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (14,'MSGBOX_INFO','显示消息对话框');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (15,'WAIT_FOR_SQL','等待SQL');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (16,'SqoopImport','!Sqoop.Import.PluginName!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (17,'FTPS_GET','FTPS 下载');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (18,'FTP_DELETE','FTP 删除');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (19,'COLUMNS_EXIST','检查列是否存在');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (20,'CHECK_FILES_LOCKED','检查文件是否被锁');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (21,'UNZIP','解压缩文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (22,'JOB','作业');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (23,'HadoopJobExecutorPlugin','!HadoopJobExecutorPlugin.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (24,'DELETE_FILE','删除一个文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (25,'SHELL','Shell');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (26,'ABORT','中止作业');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (27,'HiveJobExecutorPlugin','!HiveJobExecutorPlugin.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (28,'XML_WELL_FORMED','!XML_WELL_FORMED.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (29,'SFTP','SFTP 下载');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (30,'HTTP','HTTP');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (31,'FTP_PUT','FTP 上传');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (32,'SQL','SQL');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (33,'WRITE_TO_FILE','写入文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (34,'DATASOURCE_PUBLISH','!JobEntryDatasourcePublish.JobName!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (35,'PGP_VERIFY_FILES','用PGP验证文件签名');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (36,'DOS_UNIX_CONVERTER','DOS和UNIX之间的文本转换');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (37,'PGP_DECRYPT_FILES','用PGP解密文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (38,'TALEND_JOB_EXEC','Talend 作业执行');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (39,'EVAL','使用 JavaScript 脚本验证');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (40,'DELAY','等待');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (41,'HL7MLLPAcknowledge','!HL7MLLPAcknowledge.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (42,'PALO_CUBE_CREATE','!PaloCubeCreate.JobName!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (43,'SparkSubmit','!JobEntrySparkSubmit.Title!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (44,'FTP','FTP 下载');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (45,'OozieJobExecutor','!Oozie.JobExecutor.PluginName!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (46,'FOLDERS_COMPARE','比较目录');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (47,'ZIP_FILE','Zip 压缩文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (48,'GET_POP','POP 收信');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (49,'TRANS','转换');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (50,'HadoopTransJobExecutorPlugin','!HadoopTransJobExecutorPlugin.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (51,'SEND_NAGIOS_PASSIVE_CHECK','发送Nagios 被动检查');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (52,'SET_VARIABLES','设置变量');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (53,'MS_ACCESS_BULK_LOAD','!JobEntryMSAccessBulkLoad.Name.Default!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (54,'DummyJob','!DummyPlugin.Job.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (55,'COPY_FILES','复制文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (56,'EVAL_FILES_METRICS','计算文件大小或个数');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (57,'PING','Ping 一台主机');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (58,'ADD_RESULT_FILENAMES','添加文件到结果文件中');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (59,'DELETE_FOLDERS','删除目录');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (60,'CHECK_DB_CONNECTIONS','检查数据库连接');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (61,'FILE_EXISTS','检查一个文件是否存在');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (62,'EVAL_TABLE_CONTENT','计算表中的记录数');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (63,'FILES_EXIST','检查多个文件是否存在');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (64,'SFTPPUT','SFTP 上传');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (65,'FTPS_PUT','FTPS 上传');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (66,'DELETE_RESULT_FILENAMES','从结果文件中删除文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (67,'DELETE_FILES','删除多个文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (68,'PGP_ENCRYPT_FILES','用PGP加密文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (69,'HadoopPigScriptExecutorPlugin','!HadoopPigScriptExecutorPlugin.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (70,'WRITE_TO_LOG','写日志');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (71,'SUCCESS','成功');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (72,'WAIT_FOR_FILE','等待文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (73,'MSSQL_BULK_LOAD','SQLServer 批量加载');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (74,'TELNET','远程登录一台主机');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (75,'MOVE_FILES','移动文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (76,'XSLT','!XSLT.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (77,'DataRefineryBuildModel','!BuildModelJob.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (78,'EMRJobExecutorPlugin','!EMRJobExecutorPlugin.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (79,'DTD_VALIDATOR','!DTD_VALIDATOR.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (80,'HL7MLLPInput','!HL7MLLPInput.Name!');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (81,'FOLDER_IS_EMPTY','检查目录是否为空');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (82,'SIMPLE_EVAL','检验字段的值');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (83,'EXPORT_REPOSITORY','导出资源库到XML文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (84,'TABLE_EXISTS','检查表是否存在');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (85,'SYSLOG','用 Syslog 发送信息');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (86,'MYSQL_BULK_LOAD','Mysql 批量加载');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (87,'CREATE_FILE','创建文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (88,'SNMP_TRAP','发送 SNMP 自陷');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (89,'CONNECTED_TO_REPOSITORY','检查是否连接到资源库');

CREATE TABLE R_JOBENTRY
(
  ID_JOBENTRY BIGINT NOT NULL PRIMARY KEY
, ID_JOB INT
, ID_JOBENTRY_TYPE INT
, NAME VARCHAR(255)
, DESCRIPTION MEDIUMTEXT
)
;

CREATE TABLE R_JOBENTRY_COPY
(
  ID_JOBENTRY_COPY BIGINT NOT NULL PRIMARY KEY
, ID_JOBENTRY INT
, ID_JOB INT
, ID_JOBENTRY_TYPE INT
, NR INT
, GUI_LOCATION_X INT
, GUI_LOCATION_Y INT
, GUI_DRAW BOOLEAN
, PARALLEL BOOLEAN
)
;

CREATE TABLE R_JOBENTRY_ATTRIBUTE
(
  ID_JOBENTRY_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
, ID_JOB INT
, ID_JOBENTRY INT
, NR INT
, CODE VARCHAR(255)
, VALUE_NUM DOUBLE
, VALUE_STR MEDIUMTEXT
)
;

CREATE UNIQUE INDEX IDX_RJEA ON R_JOBENTRY_ATTRIBUTE(ID_JOBENTRY_ATTRIBUTE, CODE, NR)
;

CREATE TABLE R_JOB_HOP
(
  ID_JOB_HOP BIGINT NOT NULL PRIMARY KEY
, ID_JOB INT
, ID_JOBENTRY_COPY_FROM INT
, ID_JOBENTRY_COPY_TO INT
, ENABLED BOOLEAN
, EVALUATION BOOLEAN
, UNCONDITIONAL BOOLEAN
)
;

CREATE TABLE R_JOB_NOTE
(
  ID_JOB INT
, ID_NOTE INT
)
;

CREATE TABLE R_TRANS_LOCK
(
  ID_TRANS_LOCK BIGINT NOT NULL PRIMARY KEY
, ID_TRANSFORMATION INT
, ID_USER INT
, LOCK_MESSAGE MEDIUMTEXT
, LOCK_DATE DATETIME
)
;

CREATE TABLE R_JOB_LOCK
(
  ID_JOB_LOCK BIGINT NOT NULL PRIMARY KEY
, ID_JOB INT
, ID_USER INT
, LOCK_MESSAGE MEDIUMTEXT
, LOCK_DATE DATETIME
)
;

CREATE TABLE R_NAMESPACE
(
  ID_NAMESPACE BIGINT NOT NULL PRIMARY KEY
, NAME MEDIUMTEXT
)
;

CREATE TABLE R_ELEMENT_TYPE
(
  ID_ELEMENT_TYPE BIGINT NOT NULL PRIMARY KEY
, ID_NAMESPACE INT
, NAME MEDIUMTEXT
, DESCRIPTION MEDIUMTEXT
)
;

CREATE TABLE R_ELEMENT
(
  ID_ELEMENT BIGINT NOT NULL PRIMARY KEY
, ID_ELEMENT_TYPE INT
, NAME MEDIUMTEXT
)
;

CREATE TABLE R_ELEMENT_ATTRIBUTE
(
  ID_ELEMENT_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
, ID_ELEMENT INT
, ID_ELEMENT_ATTRIBUTE_PARENT INT
, ATTR_KEY VARCHAR(255)
, ATTR_VALUE MEDIUMTEXT
)
;

CREATE TABLE R_USER
(
  ID_USER BIGINT NOT NULL PRIMARY KEY
, LOGIN VARCHAR(255)
, PASSWORD VARCHAR(255)
, NAME VARCHAR(255)
, DESCRIPTION VARCHAR(255)
, ENABLED BOOLEAN
)
;

INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (1,'admin','2be98afc86aa7f2e4cb79ce71da9fa6d4','Administrator','User manager','1');

INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (2,'guest','2be98afc86aa7f2e4cb79ce77cb97bcce','Guest account','Read-only guest account','1');