/src/test/java/com/t11e/discovery/datatool/IntegrationTestCreate.sql
SQL | 39 lines | 33 code | 6 blank | 0 comment | 0 complexity | 3a37b3bc92f484e4451c620913628b8e MD5 | raw file
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';