/src/test/java/com/t11e/discovery/datatool/IntegrationTestCreate.sql

 1create table IntegrationContent (
 2  id bigint generated by default as identity,
 3  lastUpdated timestamp
 4);
 5
 6insert into IntegrationContent (id, lastUpdated) values
 7  (1, '2010-01-01-00.00.00.000000'),
 8  (2, '2010-01-01-00.00.00.000000'),
 9  (3, '2010-01-01-00.00.00.000000');
10
11create table IntegrationProfile (
12  name varchar(20) not null unique,
13  lastRun timestamp
14);
15insert into IntegrationProfile (name, lastRun) values
16  ('test', NULL);
17
18create table IntegrationDeleted (
19  id bigint primary key,
20  lastUpdated timestamp
21);
22insert into IntegrationDeleted (id, lastUpdated) values
23  (4, '2010-01-01-00.00.00.000000'),
24  (5, '2010-01-01-00.00.00.000000');
25
26  create table IntegrationTextContent (
27  id bigint generated by default as identity,
28  text_content clob
29);
30
31insert into IntegrationTextContent (id, text_content) values
32  (1, 'Hello & < > " '' goodbye');
33
34create procedure IntegrationContentSP(startTime timestamp, endTime timestamp)
35parameter style java
36language java
37reads sql data
38dynamic result sets 1
39external name 'com.t11e.discovery.datatool.IntegrationTestBase.integrationContentSP';