BEGIN
   EXECUTE IMMEDIATE 'DROP TABLE velocity_template_varchar';
EXCEPTION
   WHEN OTHERS THEN
      IF SQLCODE != -942 THEN
         RAISE;
      END IF;
END;

create table velocity_template_varchar
(
	vt_id VARCHAR(64) not null,
	vt_timestamp TIMESTAMP,
	vt_def VARCHAR(255) not null
);

insert into velocity_template_varchar (vt_id, vt_timestamp, vt_def) VALUES
	( 'testTemplate1', current_timestamp, 'I am a test through the data loader');

insert into velocity_template_varchar (vt_id, vt_timestamp, vt_def) VALUES
	( 'testTemplate2', current_timestamp, '$tool.message $tool.add(23, 19)');

insert into velocity_template_varchar (vt_id, vt_def) VALUES
	( 'testTemplate3', 'This is a template with a null timestamp');

insert into velocity_template_varchar (vt_id, vt_timestamp, vt_def) VALUES
	( 'testTemplate4', current_timestamp, '#testMacro("foo")');

insert into velocity_template_varchar (vt_id, vt_timestamp, vt_def) VALUES
	( 'VM_global_library.vm', current_timestamp, '#macro (testMacro $param) I am a macro using $param #end');


-- same templates as clob

BEGIN
   EXECUTE IMMEDIATE 'DROP TABLE velocity_template_clob';
EXCEPTION
   WHEN OTHERS THEN
      IF SQLCODE != -942 THEN
         RAISE;
      END IF;
END;

create table velocity_template_clob
(
	vt_id VARCHAR(64) not null primary key,
	vt_timestamp TIMESTAMP,
	vt_def CLOB not null
);

insert into velocity_template_clob select * from velocity_template_varchar;
