Index: lams_build/conf/unix/jboss/service/mysql-ds.xml
===================================================================
diff -u -r9c7d34c2a8c6ddda21eb99fb98541eaf6340a8d2 -rd5e8d7001b9fb1f67ee7216ac92ea3d9012165dd
--- lams_build/conf/unix/jboss/service/mysql-ds.xml	(.../mysql-ds.xml)	(revision 9c7d34c2a8c6ddda21eb99fb98541eaf6340a8d2)
+++ lams_build/conf/unix/jboss/service/mysql-ds.xml	(.../mysql-ds.xml)	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -45,4 +45,21 @@
     <!-- Connections not used after 5 minutes will be closed and removed -->
     <idle-timeout-minutes>5</idle-timeout-minutes>
   </local-tx-datasource>
+  
+  <!-- quartz-ds datasource for use by Quartz -->
+  <local-tx-datasource>
+    <jndi-name>jdbc/quartz-ds</jndi-name>
+    <connection-url>jdbc:mysql://localhost:3306/lams</connection-url>
+    <driver-class>com.mysql.jdbc.Driver</driver-class>
+    <!-- Set transaction isolation level to match db -->
+    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>	
+    <user-name>lams</user-name>
+    <password>lamsdemo</password>
+    <!-- Set minimum adn maximum size of pool -->
+    <max-pool-size>32</max-pool-size>
+    <min-pool-size>0</min-pool-size>
+    <!-- Connections not used after 5 minutes will be closed and removed -->
+    <idle-timeout-minutes>5</idle-timeout-minutes>
+  </local-tx-datasource>
+    
 </datasources>
Index: lams_build/conf/windows/jboss/service/mysql-ds.xml
===================================================================
diff -u -r7dd1151588310d1bcada34ea3441580100a3bd28 -rd5e8d7001b9fb1f67ee7216ac92ea3d9012165dd
--- lams_build/conf/windows/jboss/service/mysql-ds.xml	(.../mysql-ds.xml)	(revision 7dd1151588310d1bcada34ea3441580100a3bd28)
+++ lams_build/conf/windows/jboss/service/mysql-ds.xml	(.../mysql-ds.xml)	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -45,4 +45,20 @@
     <!-- Connections not used after 5 minutes will be closed and removed -->
     <idle-timeout-minutes>5</idle-timeout-minutes>
   </local-tx-datasource>
+  
+  <!-- quartz-ds datasource for use by Quartz -->
+  <local-tx-datasource>
+    <jndi-name>jdbc/quartz-ds</jndi-name>
+    <connection-url>jdbc:mysql://localhost:3306/lams</connection-url>
+    <driver-class>com.mysql.jdbc.Driver</driver-class>
+    <!-- Set transaction isolation level to match db -->
+    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>	
+    <user-name>lams</user-name>
+    <password>lamsdemo</password>
+    <!-- Set minimum adn maximum size of pool -->
+    <max-pool-size>32</max-pool-size>
+    <min-pool-size>0</min-pool-size>
+    <!-- Connections not used after 5 minutes will be closed and removed -->
+    <idle-timeout-minutes>5</idle-timeout-minutes>
+  </local-tx-datasource>
 </datasources>
Index: lams_build/lib/quartz/dbTables/readme.txt
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/readme.txt	(revision 0)
+++ lams_build/lib/quartz/dbTables/readme.txt	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1 @@
+Quartz 1.5.2 persist table for various database. So far, LAMS 1.1 just use mysql database. Please change relative table definition in lams_common/db/create_lams_11_table if adopting different database in the future.
\ No newline at end of file
Index: lams_build/lib/quartz/dbTables/tables_cloudscape.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_cloudscape.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_cloudscape.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,134 @@
+# 
+# Thanks to Srinivas Venkatarangaiah for submitting this file's contents
+#
+# In your Quartz properties file, you'll need to set 
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.CloudscapeDelegate
+#
+# Known to work with Cloudscape 3.6.4 (should work with others)
+#
+
+
+create table qrtz_job_details (
+	job_name varchar(80) not null,
+	job_group varchar(80) not null,
+	description varchar(120) ,
+	job_class_name varchar(128) not null,
+	is_durable varchar(5) not null,
+	is_volatile varchar(5) not null,
+	is_stateful varchar(5) not null,
+	requests_recovery varchar(5) not null,
+	job_data long varbinary,
+primary key (job_name,job_group)
+);
+
+create table qrtz_job_listeners(
+	job_name varchar(80) not null,
+	job_group varchar(80) not null,
+	job_listener varchar(80) not null,
+primary key (job_name,job_group,job_listener),
+foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+);
+
+create table qrtz_triggers(
+	trigger_name varchar(80) not null,
+	trigger_group varchar(80) not null,
+	job_name varchar(80) not null,
+	job_group varchar(80) not null,
+	is_volatile varchar(5) not null,
+	description varchar(120) ,
+	next_fire_time longint,
+	prev_fire_time longint,
+	trigger_state varchar(16) not null,
+	trigger_type varchar(8) not null,
+	start_time longint not null,
+	end_time longint,
+	calendar_name varchar(80),
+	misfire_instr smallint,
+	job_data long varbinary,
+primary key (trigger_name,trigger_group),
+foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+);
+
+create table qrtz_simple_triggers(
+	trigger_name varchar(80) not null,
+	trigger_group varchar(80) not null,
+	repeat_count longint not null,
+	repeat_interval longint not null,
+	times_triggered longint not null,
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_cron_triggers(
+	trigger_name varchar(80) not null,
+	trigger_group varchar(80) not null,
+	cron_expression varchar(80) not null,
+	time_zone_id varchar(80),
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_blob_triggers(
+	trigger_name varchar(80) not null,
+	trigger_group varchar(80) not null,
+	blob_data long varbinary ,
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_trigger_listeners(
+	trigger_name varchar(80) not null,
+	trigger_group varchar(80) not null,
+	trigger_listener varchar(80) not null,
+primary key (trigger_name,trigger_group,trigger_listener),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_calendars(
+	calendar_name varchar(80) not null,
+	calendar long varbinary not null,
+primary key (calendar_name)
+); 
+
+create table qrtz_paused_trigger_grps
+  (
+    trigger_group  varchar(80) not null, 
+primary key (trigger_group)
+);
+
+create table qrtz_fired_triggers(
+	entry_id varchar(95) not null,
+	trigger_name varchar(80) not null,
+	trigger_group varchar(80) not null,
+	is_volatile varchar(5) not null,
+	instance_name varchar(80) not null,
+	fired_time longint not null,
+	state varchar(16) not null,
+	job_name varchar(80) null,
+	job_group varchar(80) null,
+	is_stateful varchar(5) null,
+	requests_recovery varchar(5) null,
+primary key (entry_id)
+);
+
+create table qrtz_scheduler_state 
+  (
+    instance_name varchar(80) not null,
+    last_checkin_time longint not null,
+    checkin_interval longint not null,
+    recoverer varchar(80) null,
+primary key (instance_name)
+);
+
+create table qrtz_locks
+  (
+    lock_name  varchar(40) not null, 
+primary key (lock_name)
+);
+
+insert into qrtz_locks values('TRIGGER_ACCESS');
+insert into qrtz_locks values('JOB_ACCESS');
+insert into qrtz_locks values('CALENDAR_ACCESS');
+insert into qrtz_locks values('STATE_ACCESS');
+insert into qrtz_locks values('MISFIRE_ACCESS');
+
Index: lams_build/lib/quartz/dbTables/tables_db2.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_db2.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_db2.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,140 @@
+#
+# Thanks to Horia Muntean for submitting this....
+#
+# .. known to work with DB2 7.1 and the JDBC driver "COM.ibm.db2.jdbc.net.DB2Driver"
+# .. likely to work with others...
+#
+# In your Quartz properties file, you'll need to set 
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
+#
+# If you're using DB2 6.x you'll want to set this property to
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.DB2v6Delegate
+#
+# Note that the blob column size (e.g. blob(2000)) dictates the amount of data that can be stored in 
+# that blob - i.e. limits the amount of data you can put into your JobDataMap 
+#
+
+
+create table qrtz_job_details (
+  job_name varchar(80) not null,
+  job_group varchar(80) not null,
+  description varchar(120) null,
+  job_class_name varchar(128) not null,
+  is_durable varchar(1) not null,
+  is_volatile varchar(1) not null,
+  is_stateful varchar(1) not null,
+  requests_recovery varchar(1) not null,
+  job_data blob(2000),
+    primary key (job_name,job_group)
+)
+
+create table qrtz_job_listeners(
+  job_name varchar(80) not null,
+  job_group varchar(80) not null,
+  job_listener varchar(80) not null,
+    primary key (job_name,job_group,job_listener),
+    foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+)
+
+create table qrtz_triggers(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  job_name varchar(80) not null,
+  job_group varchar(80) not null,
+  is_volatile varchar(1) not null,
+  description varchar(120) null,
+  next_fire_time bigint,
+  prev_fire_time bigint,
+  trigger_state varchar(16) not null,
+  trigger_type varchar(8) not null,
+  start_time bigint not null,
+  end_time bigint,
+  calendar_name varchar(80),
+  misfire_instr smallint,
+  job_data blob(2000),
+    primary key (trigger_name,trigger_group),
+    foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+)
+
+create table qrtz_simple_triggers(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  repeat_count bigint not null,
+  repeat_interval bigint not null,
+  times_triggered bigint not null,
+    primary key (trigger_name,trigger_group),
+    foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+)
+
+create table qrtz_cron_triggers(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  cron_expression varchar(80) not null,
+  time_zone_id varchar(80),
+    primary key (trigger_name,trigger_group),
+    foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+)
+
+create table qrtz_blob_triggers(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  blob_data blob(2000) null,
+    primary key (trigger_name,trigger_group),
+    foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+)
+
+create table qrtz_trigger_listeners(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  trigger_listener varchar(80) not null,
+    primary key (trigger_name,trigger_group,trigger_listener),
+    foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+)
+
+create table qrtz_calendars(
+  calendar_name varchar(80) not null,
+  calendar blob(2000) not null,
+    primary key (calendar_name)
+)
+
+create table qrtz_fired_triggers(
+  entry_id varchar(95) not null,
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  is_volatile varchar(1) not null,
+  instance_name varchar(80) not null,
+  fired_time bigint not null,
+  state varchar(16) not null,
+  job_name varchar(80) null,
+  job_group varchar(80) null,
+  is_stateful varchar(1) null,
+  requests_recovery varchar(1) null,
+    primary key (entry_id)
+);
+
+
+create table qrtz_paused_trigger_grps(
+  trigger_group  varchar(80) not null, 
+    primary key (trigger_group)
+);
+
+create table qrtz_scheduler_state (
+  instance_name varchar(80) not null,
+  last_checkin_time bigint not null,
+  checkin_interval bigint not null,
+  recoverer varchar(80) null,
+    primary key (instance_name)
+);
+
+create table qrtz_locks
+  (
+    lock_name  varchar(40) not null, 
+      primary key (lock_name)
+);
+
+insert into qrtz_locks values('TRIGGER_ACCESS');
+insert into qrtz_locks values('JOB_ACCESS');
+insert into qrtz_locks values('CALENDAR_ACCESS');
+insert into qrtz_locks values('STATE_ACCESS');
+insert into qrtz_locks values('MISFIRE_ACCESS');
+
Index: lams_build/lib/quartz/dbTables/tables_db2_v72.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_db2_v72.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_db2_v72.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,156 @@
+--
+-- Thanks to Horia Muntean for submitting this, Mikkel Heisterberg for updating it 
+--
+-- .. known to work with DB2 7.2 and the JDBC driver "COM.ibm.db2.jdbc.net.DB2Driver"
+-- .. likely to work with others...
+--
+-- In your Quartz properties file, you'll need to set 
+-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.DB2v7Delegate
+--
+-- or
+--
+-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
+--
+-- If you're using DB2 6.x you'll want to set this property to
+-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.DB2v6Delegate
+--
+-- Note that the blob column size (e.g. blob(2000)) dictates the amount of data that can be stored in 
+-- that blob - i.e. limits the amount of data you can put into your JobDataMap 
+--
+
+DROP TABLE QRTZ_JOB_LISTENERS;
+DROP TABLE QRTZ_TRIGGER_LISTENERS;
+DROP TABLE QRTZ_FIRED_TRIGGERS;
+DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE QRTZ_SCHEDULER_STATE;
+DROP TABLE QRTZ_LOCKS;
+DROP TABLE QRTZ_SIMPLE_TRIGGERS;
+DROP TABLE QRTZ_CRON_TRIGGERS;
+DROP TABLE QRTZ_TRIGGERS;
+DROP TABLE QRTZ_JOB_DETAILS;
+DROP TABLE QRTZ_CALENDARS;
+DROP TABLE QRTZ_BLOB_TRIGGERS;
+
+create table qrtz_job_details (
+  job_name varchar(80) not null,
+  job_group varchar(80) not null,
+  description varchar(120),
+  job_class_name varchar(128) not null,
+  is_durable varchar(1) not null,
+  is_volatile varchar(1) not null,
+  is_stateful varchar(1) not null,
+  requests_recovery varchar(1) not null,
+  job_data blob(2000),
+    primary key (job_name,job_group)
+);
+
+create table qrtz_job_listeners(
+  job_name varchar(80) not null,
+  job_group varchar(80) not null,
+  job_listener varchar(80) not null,
+    primary key (job_name,job_group,job_listener),
+    foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+);
+
+create table qrtz_triggers(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  job_name varchar(80) not null,
+  job_group varchar(80) not null,
+  is_volatile varchar(1) not null,
+  description varchar(120),
+  next_fire_time bigint,
+  prev_fire_time bigint,
+  trigger_state varchar(16) not null,
+  trigger_type varchar(8) not null,
+  start_time bigint not null,
+  end_time bigint,
+  calendar_name varchar(80),
+  misfire_instr smallint,
+  job_data blob(2000),
+    primary key (trigger_name,trigger_group),
+    foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+);
+
+create table qrtz_simple_triggers(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  repeat_count bigint not null,
+  repeat_interval bigint not null,
+  times_triggered bigint not null,
+    primary key (trigger_name,trigger_group),
+    foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_cron_triggers(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  cron_expression varchar(80) not null,
+  time_zone_id varchar(80),
+    primary key (trigger_name,trigger_group),
+    foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_blob_triggers(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  blob_data blob(2000),
+    primary key (trigger_name,trigger_group),
+    foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_trigger_listeners(
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  trigger_listener varchar(80) not null,
+    primary key (trigger_name,trigger_group,trigger_listener),
+    foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_calendars(
+  calendar_name varchar(80) not null,
+  calendar blob(2000) not null,
+    primary key (calendar_name)
+);
+
+create table qrtz_fired_triggers(
+  entry_id varchar(95) not null,
+  trigger_name varchar(80) not null,
+  trigger_group varchar(80) not null,
+  is_volatile varchar(1) not null,
+  instance_name varchar(80) not null,
+  fired_time bigint not null,
+  state varchar(16) not null,
+  job_name varchar(80),
+  job_group varchar(80),
+  is_stateful varchar(1),
+  requests_recovery varchar(1),
+    primary key (entry_id)
+);
+
+
+create table qrtz_paused_trigger_grps(
+  trigger_group  varchar(80) not null, 
+    primary key (trigger_group)
+);
+
+create table qrtz_scheduler_state (
+  instance_name varchar(80) not null,
+  last_checkin_time bigint not null,
+  checkin_interval bigint not null,
+  recoverer varchar(80),
+    primary key (instance_name)
+);
+
+create table qrtz_locks
+  (
+    lock_name  varchar(40) not null, 
+      primary key (lock_name)
+);
+
+insert into qrtz_locks values('TRIGGER_ACCESS');
+insert into qrtz_locks values('JOB_ACCESS');
+insert into qrtz_locks values('CALENDAR_ACCESS');
+insert into qrtz_locks values('STATE_ACCESS');
+insert into qrtz_locks values('MISFIRE_ACCESS');
+
Index: lams_build/lib/quartz/dbTables/tables_db2_v8.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_db2_v8.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_db2_v8.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,143 @@
+#
+# Updated by Claudiu Crisan (claudiu.crisan@schartner.net)
+# SQL scripts for DB2 ver 8.1
+#
+# Changes:
+# - "varchar(1)" replaced with "integer"
+# - "field_name varchar(xxx) not null" replaced with "field_name varchar(xxx)"
+#
+
+
+DROP TABLE QRTZ_JOB_LISTENERS;
+DROP TABLE QRTZ_TRIGGER_LISTENERS;
+DROP TABLE QRTZ_FIRED_TRIGGERS;
+DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE QRTZ_SCHEDULER_STATE;
+DROP TABLE QRTZ_LOCKS;
+DROP TABLE QRTZ_SIMPLE_TRIGGERS;
+DROP TABLE QRTZ_CRON_TRIGGERS;
+DROP TABLE QRTZ_TRIGGERS;
+DROP TABLE QRTZ_JOB_DETAILS;
+DROP TABLE QRTZ_CALENDARS;
+DROP TABLE QRTZ_BLOB_TRIGGERS;
+
+create table qrtz_job_details(
+job_name varchar(80) not null,
+job_group varchar(80) not null,
+description varchar(120),
+job_class_name varchar(128) not null,
+is_durable integer not null,
+is_volatile integer not null,
+is_stateful integer not null,
+requests_recovery integer not null,
+job_data blob(2000),
+primary key (job_name,job_group)
+);
+
+create table qrtz_job_listeners(
+job_name varchar(80) not null,
+job_group varchar(80) not null,
+job_listener varchar(80) not null,
+primary key (job_name,job_group,job_listener),
+foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+);
+
+create table qrtz_triggers(
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+job_name varchar(80) not null,
+job_group varchar(80) not null,
+is_volatile integer not null,
+description varchar(120),
+next_fire_time bigint,
+prev_fire_time bigint,
+trigger_state varchar(16) not null,
+trigger_type varchar(8) not null,
+start_time bigint not null,
+end_time bigint,
+calendar_name varchar(80),
+misfire_instr smallint,
+job_data blob(2000),
+primary key (trigger_name,trigger_group),
+foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+);
+
+create table qrtz_simple_triggers(
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+repeat_count bigint not null,
+repeat_interval bigint not null,
+times_triggered bigint not null,
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_cron_triggers(
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+cron_expression varchar(80) not null,
+time_zone_id varchar(80),
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_blob_triggers(
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+blob_data blob(2000),
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_trigger_listeners(
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+trigger_listener varchar(80) not null,
+primary key (trigger_name,trigger_group,trigger_listener),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_calendars(
+calendar_name varchar(80) not null,
+calendar blob(2000) not null,
+primary key (calendar_name)
+);
+
+create table qrtz_fired_triggers(
+entry_id varchar(95) not null,
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+is_volatile integer not null,
+instance_name varchar(80) not null,
+fired_time bigint not null,
+state varchar(16) not null,
+job_name varchar(80),
+job_group varchar(80),
+is_stateful integer,
+requests_recovery integer,
+primary key (entry_id)
+);
+
+create table qrtz_paused_trigger_grps(
+trigger_group varchar(80) not null,
+primary key (trigger_group)
+);
+
+create table qrtz_scheduler_state(
+instance_name varchar(80) not null,
+last_checkin_time bigint not null,
+checkin_interval bigint not null,
+recoverer varchar(80),
+primary key (instance_name)
+);
+
+create table qrtz_locks(
+lock_name varchar(40) not null,
+primary key (lock_name)
+);
+
+insert into qrtz_locks values('TRIGGER_ACCESS');
+insert into qrtz_locks values('JOB_ACCESS');
+insert into qrtz_locks values('CALENDAR_ACCESS');
+insert into qrtz_locks values('STATE_ACCESS');
+insert into qrtz_locks values('MISFIRE_ACCESS'); 
Index: lams_build/lib/quartz/dbTables/tables_derby.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_derby.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_derby.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,132 @@
+-- 
+-- Apache Derby scripts by Steve Stewart.
+-- Based on Srinivas Venkatarangaiah's file for Cloudscape
+-- 
+-- In your Quartz properties file, you'll need to set
+-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.CloudscapeDelegate
+-- 
+-- Known to work with Apache Derby 10.0.2.1
+-- 
+
+create table qrtz_job_details (
+job_name varchar(80) not null,
+job_group varchar(80) not null,
+description varchar(120) ,
+job_class_name varchar(128) not null,
+is_durable varchar(5) not null,
+is_volatile varchar(5) not null,
+is_stateful varchar(5) not null,
+requests_recovery varchar(5) not null,
+job_data blob,
+primary key (job_name,job_group)
+);
+
+create table qrtz_job_listeners (
+job_name varchar(80) not null,
+job_group varchar(80) not null,
+job_listener varchar(80) not null,
+primary key (job_name,job_group,job_listener),
+foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+);
+
+create table qrtz_triggers (
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+job_name varchar(80) not null,
+job_group varchar(80) not null,
+is_volatile varchar(5) not null,
+description varchar(120) ,
+next_fire_time bigint,
+prev_fire_time bigint,
+trigger_state varchar(16) not null,
+trigger_type varchar(8) not null,
+start_time bigint not null,
+end_time bigint,
+calendar_name varchar(80),
+misfire_instr smallint,
+job_data blob,
+primary key (trigger_name,trigger_group),
+foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
+);
+
+create table qrtz_simple_triggers (
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+repeat_count bigint not null,
+repeat_interval bigint not null,
+times_triggered bigint not null,
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_cron_triggers (
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+cron_expression varchar(80) not null,
+time_zone_id varchar(80),
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_blob_triggers (
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+blob_data blob ,
+primary key (trigger_name,trigger_group),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_trigger_listeners (
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+trigger_listener varchar(80) not null,
+primary key (trigger_name,trigger_group,trigger_listener),
+foreign key (trigger_name,trigger_group) references qrtz_triggers(trigger_name,trigger_group)
+);
+
+create table qrtz_calendars (
+calendar_name varchar(80) not null,
+calendar blob not null,
+primary key (calendar_name)
+);
+
+create table qrtz_paused_trigger_grps (
+trigger_group varchar(80) not null,
+primary key (trigger_group)
+);
+
+create table qrtz_fired_triggers (
+entry_id varchar(95) not null,
+trigger_name varchar(80) not null,
+trigger_group varchar(80) not null,
+is_volatile varchar(5) not null,
+instance_name varchar(80) not null,
+fired_time bigint not null,
+state varchar(16) not null,
+job_name varchar(80),
+job_group varchar(80),
+is_stateful varchar(5),
+requests_recovery varchar(5),
+primary key (entry_id)
+);
+
+create table qrtz_scheduler_state (
+instance_name varchar(80) not null,
+last_checkin_time bigint not null,
+checkin_interval bigint not null,
+recoverer varchar(80),
+primary key (instance_name)
+);
+
+create table qrtz_locks (
+lock_name varchar(40) not null,
+primary key (lock_name)
+);
+
+insert into qrtz_locks values('TRIGGER_ACCESS');
+insert into qrtz_locks values('JOB_ACCESS');
+insert into qrtz_locks values('CALENDAR_ACCESS');
+insert into qrtz_locks values('STATE_ACCESS');
+insert into qrtz_locks values('MISFIRE_ACCESS');
+
+commit;
Index: lams_build/lib/quartz/dbTables/tables_firebird.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_firebird.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_firebird.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,148 @@
+
+--
+-- Thanks to Leonardo Alves
+--
+
+
+DROP TABLE QRTZ_JOB_LISTENERS;
+DROP TABLE QRTZ_TRIGGER_LISTENERS;
+DROP TABLE QRTZ_FIRED_TRIGGERS;
+DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE QRTZ_SCHEDULER_STATE;
+DROP TABLE QRTZ_LOCKS;
+DROP TABLE QRTZ_SIMPLE_TRIGGERS;
+DROP TABLE QRTZ_CRON_TRIGGERS;
+DROP TABLE QRTZ_BLOB_TRIGGERS;
+DROP TABLE QRTZ_TRIGGERS;
+DROP TABLE QRTZ_JOB_DETAILS;
+DROP TABLE QRTZ_CALENDARS;
+
+
+CREATE TABLE QRTZ_JOB_DETAILS (
+    JOB_NAME  VARCHAR(60) NOT NULL,
+    JOB_GROUP VARCHAR(60) NOT NULL,
+    DESCRIPTION VARCHAR(120),
+    JOB_CLASS_NAME   VARCHAR(128) NOT NULL, 
+    IS_DURABLE VARCHAR(1) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    IS_STATEFUL VARCHAR(1) NOT NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
+    JOB_DATA BLOB,
+    CONSTRAINT PK_QRTZ_JOB_DETAILS PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_JOB_LISTENERS (
+    JOB_NAME  VARCHAR(60) NOT NULL, 
+    JOB_GROUP VARCHAR(60) NOT NULL,
+    JOB_LISTENER VARCHAR(60) NOT NULL,
+    CONSTRAINT PK_QRTZ_JOB_LST PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+    CONSTRAINT FK_QRTZ_JOB_LST_1 FOREIGN KEY (JOB_NAME,JOB_GROUP)
+    REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+
+CREATE TABLE QRTZ_TRIGGERS (
+    TRIGGER_NAME VARCHAR(60) NOT NULL,
+    TRIGGER_GROUP VARCHAR(60) NOT NULL,
+    JOB_NAME  VARCHAR(60) NOT NULL, 
+    JOB_GROUP VARCHAR(60) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    DESCRIPTION VARCHAR(120),
+    NEXT_FIRE_TIME BIGINT,
+    PREV_FIRE_TIME BIGINT,
+    TRIGGER_STATE VARCHAR(16) NOT NULL,
+    TRIGGER_TYPE VARCHAR(8) NOT NULL,
+    START_TIME BIGINT NOT NULL,
+    END_TIME BIGINT,
+    CALENDAR_NAME VARCHAR(60),
+    MISFIRE_INSTR SMALLINT,
+    JOB_DATA BLOB,
+    CONSTRAINT PK_QRTZ_TRIGGERS PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    CONSTRAINT FK_QRTZ_TRIGGERS_1 FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+    REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+
+CREATE TABLE QRTZ_SIMPLE_TRIGGERS (
+    TRIGGER_NAME VARCHAR(60) NOT NULL,
+    TRIGGER_GROUP VARCHAR(60) NOT NULL,
+    REPEAT_COUNT BIGINT NOT NULL,
+    REPEAT_INTERVAL BIGINT NOT NULL,
+    TIMES_TRIGGERED BIGINT NOT NULL,
+    CONSTRAINT PK_QRTZ_SIMPLE_TRIGGERS PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_1 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+    REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_CRON_TRIGGERS (
+    TRIGGER_NAME VARCHAR(60) NOT NULL,
+    TRIGGER_GROUP VARCHAR(60) NOT NULL,
+    CRON_EXPRESSION VARCHAR(60) NOT NULL,
+    TIME_ZONE_ID VARCHAR(60),
+    CONSTRAINT PK_QRTZ_SIMPLE_TRG PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    CONSTRAINT FK_QRTZ_SIMPLE_TRG_1 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+    REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_BLOB_TRIGGERS (
+    TRIGGER_NAME VARCHAR(60) NOT NULL,
+    TRIGGER_GROUP VARCHAR(60) NOT NULL,
+    BLOB_DATA BLOB,
+    CONSTRAINT PK_QRTZ_BLOB_TRIGGERS PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    CONSTRAINT FK_QRTZ_BLOB_TRIGGERS_1 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_TRIGGER_LISTENERS (
+    TRIGGER_NAME  VARCHAR(60) NOT NULL, 
+    TRIGGER_GROUP VARCHAR(60) NOT NULL,
+    TRIGGER_LISTENER VARCHAR(60) NOT NULL,
+    CONSTRAINT PK_QRTZ_TRIGGER_LST PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+    CONSTRAINT FK_QRTZ_TRIGGER_LST_1 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+    REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_CALENDARS (
+    CALENDAR_NAME  VARCHAR(60) NOT NULL, 
+    CALENDAR BLOB NOT NULL,
+    CONSTRAINT PK_QRTZ_CALENDARS PRIMARY KEY (CALENDAR_NAME)
+);
+
+CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (
+    TRIGGER_GROUP  VARCHAR(60) NOT NULL, 
+    CONSTRAINT PK_QRTZ_PAUSED_TRIGGER_GRPS PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_FIRED_TRIGGERS (
+    ENTRY_ID VARCHAR(95) NOT NULL,
+    TRIGGER_NAME VARCHAR(60) NOT NULL,
+    TRIGGER_GROUP VARCHAR(60) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    INSTANCE_NAME VARCHAR(60) NOT NULL,
+    FIRED_TIME BIGINT NOT NULL,
+    STATE VARCHAR(16) NOT NULL,
+    JOB_NAME VARCHAR(60),
+    JOB_GROUP VARCHAR(60),
+    IS_STATEFUL VARCHAR(1),
+    REQUESTS_RECOVERY VARCHAR(1),
+    CONSTRAINT PK_QRTZ_FIRED_TRIGGERS PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE QRTZ_SCHEDULER_STATE (
+    INSTANCE_NAME VARCHAR(60) NOT NULL,
+    LAST_CHECKIN_TIME BIGINT NOT NULL,
+    CHECKIN_INTERVAL BIGINT NOT NULL,
+    RECOVERER VARCHAR(60),
+    CONSTRAINT PK_QRTZ_SCHEDULER_STATE PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE QRTZ_LOCKS (
+    LOCK_NAME  VARCHAR(40) NOT NULL, 
+    CONSTRAINT PK_QRTZ_LOCKS PRIMARY KEY (LOCK_NAME)
+);
+
+INSERT INTO QRTZ_LOCKS VALUES('TRIGGER_ACCESS');
+INSERT INTO QRTZ_LOCKS VALUES('JOB_ACCESS');
+INSERT INTO QRTZ_LOCKS VALUES('CALENDAR_ACCESS');
+INSERT INTO QRTZ_LOCKS VALUES('STATE_ACCESS');
+INSERT INTO QRTZ_LOCKS VALUES('MISFIRE_ACCESS');
+
+COMMIT;
Index: lams_build/lib/quartz/dbTables/tables_hsqldb.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_hsqldb.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_hsqldb.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,156 @@
+#
+# In your Quartz properties file, you'll need to set 
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.HSQLDBDelegate
+#
+
+ DROP TABLE qrtz_locks IF EXISTS;
+DROP TABLE qrtz_scheduler_state IF EXISTS;
+DROP TABLE qrtz_fired_triggers IF EXISTS;
+DROP TABLE qrtz_paused_trigger_grps IF EXISTS;
+DROP TABLE qrtz_calendars IF EXISTS;
+DROP TABLE qrtz_trigger_listeners IF EXISTS;
+DROP TABLE qrtz_blob_triggers IF EXISTS;
+DROP TABLE qrtz_cron_triggers IF EXISTS;
+DROP TABLE qrtz_simple_triggers IF EXISTS;
+DROP TABLE qrtz_triggers IF EXISTS;
+DROP TABLE qrtz_job_listeners IF EXISTS;
+DROP TABLE qrtz_job_details IF EXISTS;
+
+CREATE TABLE qrtz_job_details
+(
+JOB_NAME VARCHAR(80) NOT NULL,
+JOB_GROUP VARCHAR(80) NOT NULL,
+DESCRIPTION VARCHAR(120) NULL,
+JOB_CLASS_NAME VARCHAR(128) NOT NULL,
+IS_DURABLE VARCHAR(1) NOT NULL,
+IS_VOLATILE VARCHAR(1) NOT NULL,
+IS_STATEFUL VARCHAR(1) NOT NULL,
+REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
+JOB_DATA BINARY NULL,
+PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_job_listeners
+(
+JOB_NAME VARCHAR(80) NOT NULL,
+JOB_GROUP VARCHAR(80) NOT NULL,
+JOB_LISTENER VARCHAR(80) NOT NULL,
+PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+FOREIGN KEY (JOB_NAME,JOB_GROUP)
+REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_triggers
+(
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+JOB_NAME VARCHAR(80) NOT NULL,
+JOB_GROUP VARCHAR(80) NOT NULL,
+IS_VOLATILE VARCHAR(1) NOT NULL,
+DESCRIPTION VARCHAR(120) NULL,
+NEXT_FIRE_TIME NUMERIC(13) NULL,
+PREV_FIRE_TIME NUMERIC(13) NULL,
+TRIGGER_STATE VARCHAR(16) NOT NULL,
+TRIGGER_TYPE VARCHAR(8) NOT NULL,
+START_TIME NUMERIC(13) NOT NULL,
+END_TIME NUMERIC(13) NULL,
+CALENDAR_NAME VARCHAR(80) NULL,
+MISFIRE_INSTR NUMERIC(2) NULL,
+JOB_DATA BINARY NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+FOREIGN KEY (JOB_NAME,JOB_GROUP)
+REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_simple_triggers
+(
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+REPEAT_COUNT NUMERIC(7) NOT NULL,
+REPEAT_INTERVAL NUMERIC(12) NOT NULL,
+TIMES_TRIGGERED NUMERIC(7) NOT NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_cron_triggers
+(
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+CRON_EXPRESSION VARCHAR(80) NOT NULL,
+TIME_ZONE_ID VARCHAR(80),
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_blob_triggers
+(
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+BLOB_DATA BINARY NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_trigger_listeners
+(
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+TRIGGER_LISTENER VARCHAR(80) NOT NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_calendars
+(
+CALENDAR_NAME VARCHAR(80) NOT NULL,
+CALENDAR BINARY NOT NULL,
+PRIMARY KEY (CALENDAR_NAME)
+);
+
+CREATE TABLE qrtz_paused_trigger_grps
+(
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_fired_triggers
+(
+ENTRY_ID VARCHAR(95) NOT NULL,
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+IS_VOLATILE VARCHAR(1) NOT NULL,
+INSTANCE_NAME VARCHAR(80) NOT NULL,
+FIRED_TIME NUMERIC(13) NOT NULL,
+STATE VARCHAR(16) NOT NULL,
+JOB_NAME VARCHAR(80) NULL,
+JOB_GROUP VARCHAR(80) NULL,
+IS_STATEFUL VARCHAR(1) NULL,
+REQUESTS_RECOVERY VARCHAR(1) NULL,
+PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE qrtz_scheduler_state
+(
+INSTANCE_NAME VARCHAR(80) NOT NULL,
+LAST_CHECKIN_TIME NUMERIC(13) NOT NULL,
+CHECKIN_INTERVAL NUMERIC(13) NOT NULL,
+RECOVERER VARCHAR(80) NULL,
+PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE qrtz_locks
+(
+LOCK_NAME VARCHAR(40) NOT NULL,
+PRIMARY KEY (LOCK_NAME)
+);
+
+INSERT INTO qrtz_locks values('TRIGGER_ACCESS');
+INSERT INTO qrtz_locks values('JOB_ACCESS');
+INSERT INTO qrtz_locks values('CALENDAR_ACCESS');
+INSERT INTO qrtz_locks values('STATE_ACCESS');
+INSERT INTO qrtz_locks values('MISFIRE_ACCESS');
Index: lams_build/lib/quartz/dbTables/tables_hsqldb_old.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_hsqldb_old.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_hsqldb_old.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,152 @@
+# 
+# Thanks to  Joseph Wilkicki for submitting this file's contents
+#
+# In your Quartz properties file, you'll need to set 
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.HSQLDBDelegate
+#
+# Some users report the need to change the fields
+# with datatype "OTHER" to datatype "BINARY" with
+# particular versions (e.g. 1.7.1) of HSQLDB
+#
+
+CREATE TABLE qrtz_job_details
+(
+JOB_NAME LONGVARCHAR(80) NOT NULL,
+JOB_GROUP LONGVARCHAR(80) NOT NULL,
+DESCRIPTION LONGVARCHAR(120) NULL,
+JOB_CLASS_NAME LONGVARCHAR(128) NOT NULL,
+IS_DURABLE LONGVARCHAR(1) NOT NULL,
+IS_VOLATILE LONGVARCHAR(1) NOT NULL,
+IS_STATEFUL LONGVARCHAR(1) NOT NULL,
+REQUESTS_RECOVERY LONGVARCHAR(1) NOT NULL,
+JOB_DATA OTHER NULL,
+PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_job_listeners
+(
+JOB_NAME LONGVARCHAR(80) NOT NULL,
+JOB_GROUP LONGVARCHAR(80) NOT NULL,
+JOB_LISTENER LONGVARCHAR(80) NOT NULL,
+PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+FOREIGN KEY (JOB_NAME,JOB_GROUP)
+REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_triggers
+(
+TRIGGER_NAME LONGVARCHAR(80) NOT NULL,
+TRIGGER_GROUP LONGVARCHAR(80) NOT NULL,
+JOB_NAME LONGVARCHAR(80) NOT NULL,
+JOB_GROUP LONGVARCHAR(80) NOT NULL,
+IS_VOLATILE LONGVARCHAR(1) NOT NULL,
+DESCRIPTION LONGVARCHAR(120) NULL,
+NEXT_FIRE_TIME NUMERIC(13) NULL,
+PREV_FIRE_TIME NUMERIC(13) NULL,
+TRIGGER_STATE LONGVARCHAR(16) NOT NULL,
+TRIGGER_TYPE LONGVARCHAR(8) NOT NULL,
+START_TIME NUMERIC(13) NOT NULL,
+END_TIME NUMERIC(13) NULL,
+CALENDAR_NAME LONGVARCHAR(80) NULL,
+MISFIRE_INSTR NUMERIC(2) NULL,
+JOB_DATA OTHER NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+FOREIGN KEY (JOB_NAME,JOB_GROUP)
+REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_simple_triggers
+(
+TRIGGER_NAME LONGVARCHAR(80) NOT NULL,
+TRIGGER_GROUP LONGVARCHAR(80) NOT NULL,
+REPEAT_COUNT NUMERIC(7) NOT NULL,
+REPEAT_INTERVAL NUMERIC(12) NOT NULL,
+TIMES_TRIGGERED NUMERIC(7) NOT NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_cron_triggers
+(
+TRIGGER_NAME LONGVARCHAR(80) NOT NULL,
+TRIGGER_GROUP LONGVARCHAR(80) NOT NULL,
+CRON_EXPRESSION LONGVARCHAR(80) NOT NULL,
+TIME_ZONE_ID LONGVARCHAR(80),
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_blob_triggers
+(
+TRIGGER_NAME LONGVARCHAR(80) NOT NULL,
+TRIGGER_GROUP LONGVARCHAR(80) NOT NULL,
+BLOB_DATA OTHER NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_trigger_listeners
+(
+TRIGGER_NAME LONGVARCHAR(80) NOT NULL,
+TRIGGER_GROUP LONGVARCHAR(80) NOT NULL,
+TRIGGER_LISTENER LONGVARCHAR(80) NOT NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_calendars
+(
+CALENDAR_NAME LONGVARCHAR(80) NOT NULL,
+CALENDAR OTHER NOT NULL,
+PRIMARY KEY (CALENDAR_NAME)
+); 
+
+CREATE TABLE qrtz_paused_trigger_grps
+  (
+    TRIGGER_GROUP  LONGVARCHAR(80) NOT NULL, 
+    PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_fired_triggers 
+  (
+    ENTRY_ID LONGVARCHAR(95) NOT NULL,
+    TRIGGER_NAME LONGVARCHAR(80) NOT NULL,
+    TRIGGER_GROUP LONGVARCHAR(80) NOT NULL,
+    IS_VOLATILE LONGVARCHAR(1) NOT NULL,
+    INSTANCE_NAME LONGVARCHAR(80) NOT NULL,
+    FIRED_TIME NUMERIC(13) NOT NULL,
+    STATE LONGVARCHAR(16) NOT NULL,
+    JOB_NAME LONGVARCHAR(80) NULL,
+    JOB_GROUP LONGVARCHAR(80) NULL,
+    IS_STATEFUL LONGVARCHAR(1) NULL,
+    REQUESTS_RECOVERY LONGVARCHAR(1) NULL,
+    PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE qrtz_scheduler_state 
+  (
+    INSTANCE_NAME LONGVARCHAR(80) NOT NULL,
+    LAST_CHECKIN_TIME NUMERIC(13) NOT NULL,
+    CHECKIN_INTERVAL NUMERIC(13) NOT NULL,
+    RECOVERER LONGVARCHAR(80) NULL,
+    PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE qrtz_locks
+  (
+    LOCK_NAME  LONGVARCHAR(40) NOT NULL, 
+    PRIMARY KEY (LOCK_NAME)
+);
+
+
+INSERT INTO qrtz_locks values('TRIGGER_ACCESS');
+INSERT INTO qrtz_locks values('JOB_ACCESS');
+INSERT INTO qrtz_locks values('CALENDAR_ACCESS');
+INSERT INTO qrtz_locks values('STATE_ACCESS');
+INSERT INTO qrtz_locks values('MISFIRE_ACCESS');
+
+commit;
Index: lams_build/lib/quartz/dbTables/tables_informix.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_informix.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_informix.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,196 @@
+##
+## Thanks to Keith Chew for submitting this.
+##
+## use the StdJDBCDelegate with Informix.
+##
+## note that Informix has a 18 cahracter limit on the table name, so the prefix had to be shortened to "q" instread of "qrtz_"
+
+CREATE TABLE qblob_triggers (
+TRIGGER_NAME varchar(80) NOT NULL,
+TRIGGER_GROUP varchar(80) NOT NULL,
+BLOB_DATA byte in table
+);
+
+
+ALTER TABLE qblob_triggers
+ADD CONSTRAINT PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP);
+
+
+CREATE TABLE qcalendars (
+CALENDAR_NAME varchar(80) NOT NULL,
+CALENDAR byte in table NOT NULL
+);
+
+
+ALTER TABLE qcalendars
+ADD CONSTRAINT PRIMARY KEY (CALENDAR_NAME);
+
+
+CREATE TABLE qcron_triggers (
+TRIGGER_NAME varchar(80) NOT NULL,
+TRIGGER_GROUP varchar(80) NOT NULL,
+CRON_EXPRESSION varchar(80) NOT NULL,
+TIME_ZONE_ID varchar(80)
+);
+
+
+ALTER TABLE qcron_triggers
+ADD CONSTRAINT PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP);
+
+
+CREATE TABLE qfired_triggers (
+ENTRY_ID varchar(95) NOT NULL,
+TRIGGER_NAME varchar(80) NOT NULL,
+TRIGGER_GROUP varchar(80) NOT NULL,
+IS_VOLATILE varchar(1) NOT NULL,
+INSTANCE_NAME varchar(80) NOT NULL,
+FIRED_TIME numeric(13) NOT NULL,
+STATE varchar(16) NOT NULL,
+JOB_NAME varchar(80),
+JOB_GROUP varchar(80),
+IS_STATEFUL varchar(1),
+REQUESTS_RECOVERY varchar(1) 
+);
+
+
+ALTER TABLE qfired_triggers
+ADD CONSTRAINT PRIMARY KEY (ENTRY_ID);
+
+
+CREATE TABLE qpaused_trigger_grps (
+TRIGGER_GROUP  VARCHAR2(80) NOT NULL, 
+);
+
+ALTER TABLE qpaused_trigger_grps
+ADD CONSTRAINT PRIMARY KEY (TRIGGER_GROUP);
+
+
+CREATE TABLE qscheduler_state (
+INSTANCE_NAME varchar(80) NOT NULL,
+LAST_CHECKIN_TIME numeric(13) NOT NULL,
+CHECKIN_INTERVAL numeric(13) NOT NULL,
+RECOVERER varchar(80)
+);
+
+ALTER TABLE qscheduler_state
+ADD CONSTRAINT PRIMARY KEY (INSTANCE_NAME);
+
+
+CREATE TABLE qlocks (
+LOCK_NAME  varchar(40) NOT NULL, 
+);
+
+ALTER TABLE qlocks
+ADD CONSTRAINT PRIMARY KEY (LOCK_NAME);
+
+INSERT INTO qlocks values('TRIGGER_ACCESS');
+INSERT INTO qlocks values('JOB_ACCESS');
+INSERT INTO qlocks values('CALENDAR_ACCESS');
+INSERT INTO qlocks values('STATE_ACCESS');
+
+
+
+CREATE TABLE qjob_details (
+JOB_NAME varchar(80) NOT NULL,
+JOB_GROUP varchar(80) NOT NULL,
+DESCRIPTION varchar(120),
+JOB_CLASS_NAME varchar(128) NOT NULL,
+IS_DURABLE varchar(1) NOT NULL,
+IS_VOLATILE varchar(1) NOT NULL,
+IS_STATEFUL varchar(1) NOT NULL,
+REQUESTS_RECOVERY varchar(1) NOT NULL,
+JOB_DATA byte in table
+);
+
+
+ALTER TABLE qjob_details
+ADD CONSTRAINT PRIMARY KEY (JOB_NAME, JOB_GROUP);
+
+
+CREATE TABLE qjob_listeners (
+JOB_NAME varchar(80) NOT NULL,
+JOB_GROUP varchar(80) NOT NULL,
+JOB_LISTENER varchar(80) NOT NULL
+);
+
+
+ALTER TABLE qjob_listeners
+ADD CONSTRAINT PRIMARY KEY (JOB_NAME, JOB_GROUP, JOB_LISTENER);
+
+
+CREATE TABLE qsimple_triggers (
+TRIGGER_NAME varchar(80) NOT NULL,
+TRIGGER_GROUP varchar(80) NOT NULL,
+REPEAT_COUNT numeric(7) NOT NULL,
+REPEAT_INTERVAL numeric(12) NOT NULL,
+TIMES_TRIGGERED numeric(7) NOT NULL
+);
+
+
+ALTER TABLE qsimple_triggers
+ADD CONSTRAINT PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP);
+
+
+CREATE TABLE qtrigger_listeners (
+TRIGGER_NAME varchar(80) NOT NULL,
+TRIGGER_GROUP varchar(80) NOT NULL,
+TRIGGER_LISTENER varchar(80) NOT NULL
+);
+
+
+ALTER TABLE qtrigger_listeners
+ADD CONSTRAINT PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP,
+TRIGGER_LISTENER);
+
+
+CREATE TABLE qtriggers (
+TRIGGER_NAME varchar(80) NOT NULL,
+TRIGGER_GROUP varchar(80) NOT NULL,
+JOB_NAME varchar(80) NOT NULL,
+JOB_GROUP varchar(80) NOT NULL,
+IS_VOLATILE varchar(1) NOT NULL,
+DESCRIPTION varchar(120),
+NEXT_FIRE_TIME numeric(13),
+PREV_FIRE_TIME numeric(13),
+TRIGGER_STATE varchar(16) NOT NULL,
+TRIGGER_TYPE varchar(8) NOT NULL,
+START_TIME numeric(13) NOT NULL,
+END_TIME numeric(13),
+CALENDAR_NAME varchar(80),
+MISFIRE_INSTR numeric(2)
+JOB_DATA byte in table
+);
+
+
+ALTER TABLE qtriggers
+ADD CONSTRAINT PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP);
+
+
+ALTER TABLE qblob_triggers
+ADD CONSTRAINT FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP)
+REFERENCES qtriggers;
+
+
+ALTER TABLE qcron_triggers
+ADD CONSTRAINT FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP)
+REFERENCES qtriggers;
+
+
+ALTER TABLE qjob_listeners
+ADD CONSTRAINT FOREIGN KEY (JOB_NAME, JOB_GROUP)
+REFERENCES qjob_details;
+
+
+ALTER TABLE qsimple_triggers
+ADD CONSTRAINT FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP)
+REFERENCES qtriggers;
+
+
+ALTER TABLE qtrigger_listeners
+ADD CONSTRAINT FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP)
+REFERENCES qtriggers;
+
+
+ALTER TABLE qtriggers
+ADD CONSTRAINT FOREIGN KEY (JOB_NAME, JOB_GROUP)
+REFERENCES qjob_details; 
Index: lams_build/lib/quartz/dbTables/tables_mysql.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_mysql.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_mysql.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,166 @@
+#
+# Quartz seems to work best with the driver mm.mysql-2.0.7-bin.jar
+#
+# In your Quartz properties file, you'll need to set 
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
+#
+
+DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;
+DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;
+DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
+DROP TABLE IF EXISTS QRTZ_LOCKS;
+DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;
+DROP TABLE IF EXISTS QRTZ_CALENDARS;
+
+
+CREATE TABLE QRTZ_JOB_DETAILS
+  (
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    JOB_CLASS_NAME   VARCHAR(128) NOT NULL,
+    IS_DURABLE VARCHAR(1) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    IS_STATEFUL VARCHAR(1) NOT NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
+    JOB_DATA BLOB NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_JOB_LISTENERS
+  (
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    JOB_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP)
+        REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_TRIGGERS
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    NEXT_FIRE_TIME BIGINT(13) NULL,
+    PREV_FIRE_TIME BIGINT(13) NULL,
+    TRIGGER_STATE VARCHAR(16) NOT NULL,
+    TRIGGER_TYPE VARCHAR(8) NOT NULL,
+    START_TIME BIGINT(13) NOT NULL,
+    END_TIME BIGINT(13) NULL,
+    CALENDAR_NAME VARCHAR(80) NULL,
+    MISFIRE_INSTR SMALLINT(2) NULL,
+    JOB_DATA BLOB NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP)
+        REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_SIMPLE_TRIGGERS
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    REPEAT_COUNT BIGINT(7) NOT NULL,
+    REPEAT_INTERVAL BIGINT(12) NOT NULL,
+    TIMES_TRIGGERED BIGINT(7) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_CRON_TRIGGERS
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    CRON_EXPRESSION VARCHAR(80) NOT NULL,
+    TIME_ZONE_ID VARCHAR(80),
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_BLOB_TRIGGERS
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    BLOB_DATA BLOB NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_TRIGGER_LISTENERS
+  (
+    TRIGGER_NAME  VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    TRIGGER_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+
+CREATE TABLE QRTZ_CALENDARS
+  (
+    CALENDAR_NAME  VARCHAR(80) NOT NULL,
+    CALENDAR BLOB NOT NULL,
+    PRIMARY KEY (CALENDAR_NAME)
+);
+
+
+
+CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS
+  (
+    TRIGGER_GROUP  VARCHAR(80) NOT NULL, 
+    PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_FIRED_TRIGGERS
+  (
+    ENTRY_ID VARCHAR(95) NOT NULL,
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    FIRED_TIME BIGINT(13) NOT NULL,
+    STATE VARCHAR(16) NOT NULL,
+    JOB_NAME VARCHAR(80) NULL,
+    JOB_GROUP VARCHAR(80) NULL,
+    IS_STATEFUL VARCHAR(1) NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NULL,
+    PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE QRTZ_SCHEDULER_STATE
+  (
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
+    CHECKIN_INTERVAL BIGINT(13) NOT NULL,
+    RECOVERER VARCHAR(80) NULL,
+    PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE QRTZ_LOCKS
+  (
+    LOCK_NAME  VARCHAR(40) NOT NULL, 
+    PRIMARY KEY (LOCK_NAME)
+);
+
+
+INSERT INTO QRTZ_LOCKS values('TRIGGER_ACCESS');
+INSERT INTO QRTZ_LOCKS values('JOB_ACCESS');
+INSERT INTO QRTZ_LOCKS values('CALENDAR_ACCESS');
+INSERT INTO QRTZ_LOCKS values('STATE_ACCESS');
+INSERT INTO QRTZ_LOCKS values('MISFIRE_ACCESS');
+
+
+commit;
\ No newline at end of file
Index: lams_build/lib/quartz/dbTables/tables_mysql_innodb.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_mysql_innodb.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_mysql_innodb.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,153 @@
+#
+# In your Quartz properties file, you'll need to set 
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
+#
+#
+# By: Ron Cordell - roncordell
+#  I didn't see this anywhere, so I thought I'd post it here. This is the script from Quartz to create the tables in a MySQL database, modified to use INNODB instead of MYISAM.
+
+DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;
+DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;
+DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
+DROP TABLE IF EXISTS QRTZ_LOCKS;
+DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_TRIGGERS;
+DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;
+DROP TABLE IF EXISTS QRTZ_CALENDARS;
+CREATE TABLE QRTZ_JOB_DETAILS(
+JOB_NAME VARCHAR(80) NOT NULL,
+JOB_GROUP VARCHAR(80) NOT NULL,
+DESCRIPTION VARCHAR(120) NULL,
+JOB_CLASS_NAME VARCHAR(128) NOT NULL,
+IS_DURABLE VARCHAR(1) NOT NULL,
+IS_VOLATILE VARCHAR(1) NOT NULL,
+IS_STATEFUL VARCHAR(1) NOT NULL,
+REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
+JOB_DATA BLOB NULL,
+PRIMARY KEY (JOB_NAME,JOB_GROUP))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_JOB_LISTENERS (
+JOB_NAME VARCHAR(80) NOT NULL,
+JOB_GROUP VARCHAR(80) NOT NULL,
+JOB_LISTENER VARCHAR(80) NOT NULL,
+PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+INDEX (JOB_NAME, JOB_GROUP),
+FOREIGN KEY (JOB_NAME,JOB_GROUP)
+REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_TRIGGERS (
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+JOB_NAME VARCHAR(80) NOT NULL,
+JOB_GROUP VARCHAR(80) NOT NULL,
+IS_VOLATILE VARCHAR(1) NOT NULL,
+DESCRIPTION VARCHAR(120) NULL,
+NEXT_FIRE_TIME BIGINT(13) NULL,
+PREV_FIRE_TIME BIGINT(13) NULL,
+TRIGGER_STATE VARCHAR(16) NOT NULL,
+TRIGGER_TYPE VARCHAR(8) NOT NULL,
+START_TIME BIGINT(13) NOT NULL,
+END_TIME BIGINT(13) NULL,
+CALENDAR_NAME VARCHAR(80) NULL,
+MISFIRE_INSTR SMALLINT(2) NULL,
+JOB_DATA BLOB NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+INDEX (JOB_NAME, JOB_GROUP),
+FOREIGN KEY (JOB_NAME,JOB_GROUP)
+REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_SIMPLE_TRIGGERS (
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+REPEAT_COUNT BIGINT(7) NOT NULL,
+REPEAT_INTERVAL BIGINT(12) NOT NULL,
+TIMES_TRIGGERED BIGINT(7) NOT NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+INDEX (TRIGGER_NAME, TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_CRON_TRIGGERS (
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+CRON_EXPRESSION VARCHAR(80) NOT NULL,
+TIME_ZONE_ID VARCHAR(80),
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+INDEX (TRIGGER_NAME, TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_BLOB_TRIGGERS (
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+BLOB_DATA BLOB NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+INDEX (TRIGGER_NAME, TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_TRIGGER_LISTENERS (
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+TRIGGER_LISTENER VARCHAR(80) NOT NULL,
+PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+INDEX (TRIGGER_NAME, TRIGGER_GROUP),
+FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_CALENDARS (
+CALENDAR_NAME VARCHAR(80) NOT NULL,
+CALENDAR BLOB NOT NULL,
+PRIMARY KEY (CALENDAR_NAME))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+PRIMARY KEY (TRIGGER_GROUP))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_FIRED_TRIGGERS (
+ENTRY_ID VARCHAR(95) NOT NULL,
+TRIGGER_NAME VARCHAR(80) NOT NULL,
+TRIGGER_GROUP VARCHAR(80) NOT NULL,
+IS_VOLATILE VARCHAR(1) NOT NULL,
+INSTANCE_NAME VARCHAR(80) NOT NULL,
+FIRED_TIME BIGINT(13) NOT NULL,
+STATE VARCHAR(16) NOT NULL,
+JOB_NAME VARCHAR(80) NULL,
+JOB_GROUP VARCHAR(80) NULL,
+IS_STATEFUL VARCHAR(1) NULL,
+REQUESTS_RECOVERY VARCHAR(1) NULL,
+PRIMARY KEY (ENTRY_ID))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_SCHEDULER_STATE (
+INSTANCE_NAME VARCHAR(80) NOT NULL,
+LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
+CHECKIN_INTERVAL BIGINT(13) NOT NULL,
+RECOVERER VARCHAR(80) NULL,
+PRIMARY KEY (INSTANCE_NAME))
+TYPE=InnoDB;
+
+CREATE TABLE QRTZ_LOCKS (
+LOCK_NAME VARCHAR(40) NOT NULL,
+PRIMARY KEY (LOCK_NAME))
+TYPE=InnoDB;
+
+INSERT INTO QRTZ_LOCKS values('TRIGGER_ACCESS');
+INSERT INTO QRTZ_LOCKS values('JOB_ACCESS');
+INSERT INTO QRTZ_LOCKS values('CALENDAR_ACCESS');
+INSERT INTO QRTZ_LOCKS values('STATE_ACCESS');
+INSERT INTO QRTZ_LOCKS values('MISFIRE_ACCESS');
+commit; 
Index: lams_build/lib/quartz/dbTables/tables_oracle.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_oracle.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_oracle.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,178 @@
+--
+-- A hint submitted by a user: Oracle DB MUST be created as "shared" and the 
+-- job_queue_processes parameter  must be greater than 2, otherwise a DB lock 
+-- will happen.   However, these settings are pretty much standard after any
+-- Oracle install, so most users need not worry about this.
+--
+
+delete from qrtz_job_listeners;
+delete from qrtz_trigger_listeners;
+delete from qrtz_fired_triggers;
+delete from qrtz_simple_triggers;
+delete from qrtz_cron_triggers;
+delete from qrtz_blob_triggers;
+delete from qrtz_triggers;
+delete from qrtz_job_details;
+delete from qrtz_calendars;
+delete from qrtz_paused_trigger_grps;
+delete from qrtz_locks;
+delete from qrtz_scheduler_state;
+
+drop table qrtz_calendars;
+drop table qrtz_fired_triggers;
+drop table qrtz_trigger_listeners;
+drop table qrtz_blob_triggers;
+drop table qrtz_cron_triggers;
+drop table qrtz_simple_triggers;
+drop table qrtz_triggers;
+drop table qrtz_job_listeners;
+drop table qrtz_job_details;
+drop table qrtz_paused_trigger_grps;
+drop table qrtz_locks;
+drop table qrtz_scheduler_state;
+
+
+CREATE TABLE qrtz_job_details
+  (
+    JOB_NAME  VARCHAR2(80) NOT NULL,
+    JOB_GROUP VARCHAR2(80) NOT NULL,
+    DESCRIPTION VARCHAR2(120) NULL,
+    JOB_CLASS_NAME   VARCHAR2(128) NOT NULL, 
+    IS_DURABLE VARCHAR2(1) NOT NULL,
+    IS_VOLATILE VARCHAR2(1) NOT NULL,
+    IS_STATEFUL VARCHAR2(1) NOT NULL,
+    REQUESTS_RECOVERY VARCHAR2(1) NOT NULL,
+    JOB_DATA BLOB NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+CREATE TABLE qrtz_job_listeners
+  (
+    JOB_NAME  VARCHAR2(80) NOT NULL, 
+    JOB_GROUP VARCHAR2(80) NOT NULL,
+    JOB_LISTENER VARCHAR2(80) NOT NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+	REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+CREATE TABLE qrtz_triggers
+  (
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    JOB_NAME  VARCHAR2(80) NOT NULL, 
+    JOB_GROUP VARCHAR2(80) NOT NULL,
+    IS_VOLATILE VARCHAR2(1) NOT NULL,
+    DESCRIPTION VARCHAR2(120) NULL,
+    NEXT_FIRE_TIME NUMBER(13) NULL,
+    PREV_FIRE_TIME NUMBER(13) NULL,
+    TRIGGER_STATE VARCHAR2(16) NOT NULL,
+    TRIGGER_TYPE VARCHAR2(8) NOT NULL,
+    START_TIME NUMBER(13) NOT NULL,
+    END_TIME NUMBER(13) NULL,
+    CALENDAR_NAME VARCHAR2(80) NULL,
+    MISFIRE_INSTR NUMBER(2) NULL,
+    JOB_DATA BLOB NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+	REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+CREATE TABLE qrtz_simple_triggers
+  (
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    REPEAT_COUNT NUMBER(7) NOT NULL,
+    REPEAT_INTERVAL NUMBER(12) NOT NULL,
+    TIMES_TRIGGERED NUMBER(7) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+CREATE TABLE qrtz_cron_triggers
+  (
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    CRON_EXPRESSION VARCHAR2(80) NOT NULL,
+    TIME_ZONE_ID VARCHAR2(80),
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+CREATE TABLE qrtz_blob_triggers
+  (
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    BLOB_DATA BLOB NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+CREATE TABLE qrtz_trigger_listeners
+  (
+    TRIGGER_NAME  VARCHAR2(80) NOT NULL, 
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    TRIGGER_LISTENER VARCHAR2(80) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+CREATE TABLE qrtz_calendars
+  (
+    CALENDAR_NAME  VARCHAR2(80) NOT NULL, 
+    CALENDAR BLOB NOT NULL,
+    PRIMARY KEY (CALENDAR_NAME)
+);
+CREATE TABLE qrtz_paused_trigger_grps
+  (
+    TRIGGER_GROUP  VARCHAR2(80) NOT NULL, 
+    PRIMARY KEY (TRIGGER_GROUP)
+);
+CREATE TABLE qrtz_fired_triggers 
+  (
+    ENTRY_ID VARCHAR2(95) NOT NULL,
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    IS_VOLATILE VARCHAR2(1) NOT NULL,
+    INSTANCE_NAME VARCHAR2(80) NOT NULL,
+    FIRED_TIME NUMBER(13) NOT NULL,
+    STATE VARCHAR2(16) NOT NULL,
+    JOB_NAME VARCHAR2(80) NULL,
+    JOB_GROUP VARCHAR2(80) NULL,
+    IS_STATEFUL VARCHAR2(1) NULL,
+    REQUESTS_RECOVERY VARCHAR2(1) NULL,
+    PRIMARY KEY (ENTRY_ID)
+);
+CREATE TABLE qrtz_scheduler_state 
+  (
+    INSTANCE_NAME VARCHAR2(80) NOT NULL,
+    LAST_CHECKIN_TIME NUMBER(13) NOT NULL,
+    CHECKIN_INTERVAL NUMBER(13) NOT NULL,
+    RECOVERER VARCHAR2(80) NULL,
+    PRIMARY KEY (INSTANCE_NAME)
+);
+CREATE TABLE qrtz_locks
+  (
+    LOCK_NAME  VARCHAR2(40) NOT NULL, 
+    PRIMARY KEY (LOCK_NAME)
+);
+INSERT INTO qrtz_locks values('TRIGGER_ACCESS');
+INSERT INTO qrtz_locks values('JOB_ACCESS');
+INSERT INTO qrtz_locks values('CALENDAR_ACCESS');
+INSERT INTO qrtz_locks values('STATE_ACCESS');
+INSERT INTO qrtz_locks values('MISFIRE_ACCESS');
+create index idx_qrtz_j_req_recovery on qrtz_job_details(REQUESTS_RECOVERY);
+create index idx_qrtz_t_next_fire_time on qrtz_triggers(NEXT_FIRE_TIME);
+create index idx_qrtz_t_state on qrtz_triggers(TRIGGER_STATE);
+create index idx_qrtz_t_nft_st on qrtz_triggers(NEXT_FIRE_TIME,TRIGGER_STATE);
+create index idx_qrtz_t_volatile on qrtz_triggers(IS_VOLATILE);
+create index idx_qrtz_ft_trig_name on qrtz_fired_triggers(TRIGGER_NAME);
+create index idx_qrtz_ft_trig_group on qrtz_fired_triggers(TRIGGER_GROUP);
+create index idx_qrtz_ft_trig_nm_gp on qrtz_fired_triggers(TRIGGER_NAME,TRIGGER_GROUP);
+create index idx_qrtz_ft_trig_volatile on qrtz_fired_triggers(IS_VOLATILE);
+create index idx_qrtz_ft_trig_inst_name on qrtz_fired_triggers(INSTANCE_NAME);
+create index idx_qrtz_ft_job_name on qrtz_fired_triggers(JOB_NAME);
+create index idx_qrtz_ft_job_group on qrtz_fired_triggers(JOB_GROUP);
+create index idx_qrtz_ft_job_stateful on qrtz_fired_triggers(IS_STATEFUL);
+create index idx_qrtz_ft_job_req_recovery on qrtz_fired_triggers(REQUESTS_RECOVERY);
+
+
+
+commit;
Index: lams_build/lib/quartz/dbTables/tables_pointbase.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_pointbase.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_pointbase.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,177 @@
+#
+# Thanks to Gregg Freeman
+#
+#
+# ...you may want to change defined the size of the "blob" columns before
+# creating the tables (particularly for the qrtz_job_details.job_data column), 
+# if you will be storing large amounts of data in them
+#
+#
+delete from qrtz_job_listeners;
+delete from qrtz_trigger_listeners;
+delete from qrtz_fired_triggers;
+delete from qrtz_simple_triggers;
+delete from qrtz_cron_triggers;
+delete from qrtz_blob_triggers;
+delete from qrtz_triggers;
+delete from qrtz_job_details;
+delete from qrtz_calendars;
+delete from qrtz_paused_trigger_grps;
+delete from qrtz_locks;
+delete from qrtz_scheduler_state;
+
+drop table qrtz_calendars;
+drop table qrtz_fired_triggers;
+drop table qrtz_trigger_listeners;
+drop table qrtz_blob_triggers;
+drop table qrtz_cron_triggers;
+drop table qrtz_simple_triggers;
+drop table qrtz_triggers;
+drop table qrtz_job_listeners;
+drop table qrtz_job_details;
+drop table qrtz_paused_trigger_grps;
+drop table qrtz_locks;
+drop table qrtz_scheduler_state;
+ 
+
+CREATE TABLE qrtz_job_details
+  (
+    JOB_NAME  VARCHAR2(80) NOT NULL,
+    JOB_GROUP VARCHAR2(80) NOT NULL,
+    DESCRIPTION VARCHAR2(120) NULL,
+    JOB_CLASS_NAME   VARCHAR2(128) NOT NULL, 
+    IS_DURABLE BOOLEAN NOT NULL,
+    IS_VOLATILE BOOLEAN NOT NULL,
+    IS_STATEFUL BOOLEAN NOT NULL,
+    REQUESTS_RECOVERY BOOLEAN NOT NULL,
+    JOB_DATA BLOB(4K) NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_job_listeners
+  (
+    JOB_NAME  VARCHAR2(80) NOT NULL, 
+    JOB_GROUP VARCHAR2(80) NOT NULL,
+    JOB_LISTENER VARCHAR2(80) NOT NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+	REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_triggers
+  (
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    JOB_NAME  VARCHAR2(80) NOT NULL, 
+    JOB_GROUP VARCHAR2(80) NOT NULL,
+    IS_VOLATILE BOOLEAN NOT NULL,
+    DESCRIPTION VARCHAR2(120) NULL,
+    NEXT_FIRE_TIME NUMBER(13) NULL,
+    PREV_FIRE_TIME NUMBER(13) NULL,
+    TRIGGER_STATE VARCHAR2(16) NOT NULL,
+    TRIGGER_TYPE VARCHAR2(8) NOT NULL,
+    START_TIME NUMBER(13) NOT NULL,
+    END_TIME NUMBER(13) NULL,
+    CALENDAR_NAME VARCHAR2(80) NULL,
+    MISFIRE_INSTR NUMBER(2) NULL,
+    JOB_DATA BLOB(4K) NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+	REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+
+CREATE TABLE qrtz_simple_triggers
+  (
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    REPEAT_COUNT NUMBER(7) NOT NULL,
+    REPEAT_INTERVAL NUMBER(12) NOT NULL,
+    TIMES_TRIGGERED NUMBER(7) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_cron_triggers
+  (
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    CRON_EXPRESSION VARCHAR2(80) NOT NULL,
+    TIME_ZONE_ID VARCHAR2(80),
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_blob_triggers
+  (
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    BLOB_DATA BLOB(4K) NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_trigger_listeners
+  (
+    TRIGGER_NAME  VARCHAR2(80) NOT NULL, 
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    TRIGGER_LISTENER VARCHAR2(80) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_calendars
+  (
+    CALENDAR_NAME  VARCHAR2(80) NOT NULL, 
+    CALENDAR BLOB(4K) NOT NULL,
+    PRIMARY KEY (CALENDAR_NAME)
+);
+
+CREATE TABLE qrtz_paused_trigger_grps
+  (
+    TRIGGER_GROUP  VARCHAR2(80) NOT NULL, 
+    PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_fired_triggers 
+  (
+    ENTRY_ID VARCHAR2(95) NOT NULL,
+    TRIGGER_NAME VARCHAR2(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
+    IS_VOLATILE BOOLEAN NOT NULL,
+    INSTANCE_NAME VARCHAR2(80) NOT NULL,
+    FIRED_TIME NUMBER(13) NOT NULL,
+    STATE VARCHAR2(16) NOT NULL,
+    JOB_NAME VARCHAR2(80) NULL,
+    JOB_GROUP VARCHAR2(80) NULL,
+    IS_STATEFUL BOOLEAN NULL,
+    REQUESTS_RECOVERY BOOLEAN NULL,
+    PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE qrtz_scheduler_state 
+  (
+    INSTANCE_NAME VARCHAR2(80) NOT NULL,
+    LAST_CHECKIN_TIME NUMBER(13) NOT NULL,
+    CHECKIN_INTERVAL NUMBER(13) NOT NULL,
+    RECOVERER VARCHAR2(80) NULL,
+    PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE qrtz_locks
+  (
+    LOCK_NAME  VARCHAR2(40) NOT NULL, 
+    PRIMARY KEY (LOCK_NAME)
+);
+
+
+INSERT INTO qrtz_locks values('TRIGGER_ACCESS');
+INSERT INTO qrtz_locks values('JOB_ACCESS');
+INSERT INTO qrtz_locks values('CALENDAR_ACCESS');
+INSERT INTO qrtz_locks values('STATE_ACCESS');
+INSERT INTO qrtz_locks values('MISFIRE_ACCESS');
+
+commit;
Index: lams_build/lib/quartz/dbTables/tables_postgres.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_postgres.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_postgres.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,162 @@
+-- Thanks to Patrick Lightbody for submitting this...
+--
+-- In your Quartz properties file, you'll need to set 
+-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostreSQLDelegate
+
+drop table qrtz_job_listeners;
+drop table qrtz_trigger_listeners;
+drop table qrtz_fired_triggers;
+DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE QRTZ_SCHEDULER_STATE;
+DROP TABLE QRTZ_LOCKS;
+drop table qrtz_simple_triggers;
+drop table qrtz_cron_triggers;
+DROP TABLE QRTZ_BLOB_TRIGGERS;
+drop table qrtz_triggers;
+drop table qrtz_job_details;
+drop table qrtz_calendars;
+
+CREATE TABLE qrtz_job_details
+  (
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    JOB_CLASS_NAME   VARCHAR(128) NOT NULL, 
+    IS_DURABLE BOOL NOT NULL,
+    IS_VOLATILE BOOL NOT NULL,
+    IS_STATEFUL BOOL NOT NULL,
+    REQUESTS_RECOVERY BOOL NOT NULL,
+    JOB_DATA BYTEA NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_job_listeners
+  (
+    JOB_NAME  VARCHAR(80) NOT NULL, 
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    JOB_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+	REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+
+CREATE TABLE qrtz_triggers
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    JOB_NAME  VARCHAR(80) NOT NULL, 
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE BOOL NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    NEXT_FIRE_TIME BIGINT NULL,
+    PREV_FIRE_TIME BIGINT NULL,
+    TRIGGER_STATE VARCHAR(16) NOT NULL,
+    TRIGGER_TYPE VARCHAR(8) NOT NULL,
+    START_TIME BIGINT NOT NULL,
+    END_TIME BIGINT NULL,
+    CALENDAR_NAME VARCHAR(80) NULL,
+    MISFIRE_INSTR SMALLINT NULL,
+    JOB_DATA BYTEA NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+	REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+
+CREATE TABLE qrtz_simple_triggers
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    REPEAT_COUNT BIGINT NOT NULL,
+    REPEAT_INTERVAL BIGINT NOT NULL,
+    TIMES_TRIGGERED BIGINT NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_cron_triggers
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    CRON_EXPRESSION VARCHAR(80) NOT NULL,
+    TIME_ZONE_ID VARCHAR(80),
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_blob_triggers
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    BLOB_DATA BYTEA NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_trigger_listeners
+  (
+    TRIGGER_NAME  VARCHAR(80) NOT NULL, 
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    TRIGGER_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+
+CREATE TABLE qrtz_calendars
+  (
+    CALENDAR_NAME  VARCHAR(80) NOT NULL, 
+    CALENDAR BYTEA NOT NULL,
+    PRIMARY KEY (CALENDAR_NAME)
+);
+
+
+CREATE TABLE qrtz_paused_trigger_grps
+  (
+    TRIGGER_GROUP  VARCHAR(80) NOT NULL, 
+    PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_fired_triggers 
+  (
+    ENTRY_ID VARCHAR(95) NOT NULL,
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE BOOL NOT NULL,
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    FIRED_TIME BIGINT NOT NULL,
+    STATE VARCHAR(16) NOT NULL,
+    JOB_NAME VARCHAR(80) NULL,
+    JOB_GROUP VARCHAR(80) NULL,
+    IS_STATEFUL BOOL NULL,
+    REQUESTS_RECOVERY BOOL NULL,
+    PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE qrtz_scheduler_state 
+  (
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    LAST_CHECKIN_TIME BIGINT NOT NULL,
+    CHECKIN_INTERVAL BIGINT NOT NULL,
+    RECOVERER VARCHAR(80) NULL,
+    PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE qrtz_locks
+  (
+    LOCK_NAME  VARCHAR(40) NOT NULL, 
+    PRIMARY KEY (LOCK_NAME)
+);
+
+
+INSERT INTO qrtz_locks values('TRIGGER_ACCESS');
+INSERT INTO qrtz_locks values('JOB_ACCESS');
+INSERT INTO qrtz_locks values('CALENDAR_ACCESS');
+INSERT INTO qrtz_locks values('STATE_ACCESS');
+INSERT INTO qrtz_locks values('MISFIRE_ACCESS');
+
+commit;
+
Index: lams_build/lib/quartz/dbTables/tables_postgres7.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_postgres7.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_postgres7.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,162 @@
+-- Thanks to Patrick Lightbody for submitting this...
+--
+-- In your Quartz properties file, you'll need to set 
+-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostreSQLDelegate
+
+drop table qrtz_job_listeners;
+drop table qrtz_trigger_listeners;
+drop table qrtz_fired_triggers;
+DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE QRTZ_SCHEDULER_STATE;
+DROP TABLE QRTZ_LOCKS;
+drop table qrtz_simple_triggers;
+drop table qrtz_cron_triggers;
+DROP TABLE QRTZ_BLOB_TRIGGERS;
+drop table qrtz_triggers;
+drop table qrtz_job_details;
+drop table qrtz_calendars;
+
+CREATE TABLE qrtz_job_details
+  (
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    JOB_CLASS_NAME   VARCHAR(128) NOT NULL, 
+    IS_DURABLE VARCHAR(1) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    IS_STATEFUL VARCHAR(1) NOT NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
+    JOB_DATA BYTEA NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE qrtz_job_listeners
+  (
+    JOB_NAME  VARCHAR(80) NOT NULL, 
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    JOB_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+	REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+
+CREATE TABLE qrtz_triggers
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    JOB_NAME  VARCHAR(80) NOT NULL, 
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    NEXT_FIRE_TIME BIGINT NULL,
+    PREV_FIRE_TIME BIGINT NULL,
+    TRIGGER_STATE VARCHAR(16) NOT NULL,
+    TRIGGER_TYPE VARCHAR(8) NOT NULL,
+    START_TIME BIGINT NOT NULL,
+    END_TIME BIGINT NULL,
+    CALENDAR_NAME VARCHAR(80) NULL,
+    MISFIRE_INSTR SMALLINT NULL,
+    JOB_DATA BYTEA NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
+	REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+
+CREATE TABLE qrtz_simple_triggers
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    REPEAT_COUNT BIGINT NOT NULL,
+    REPEAT_INTERVAL BIGINT NOT NULL,
+    TIMES_TRIGGERED BIGINT NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_cron_triggers
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    CRON_EXPRESSION VARCHAR(80) NOT NULL,
+    TIME_ZONE_ID VARCHAR(80),
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_blob_triggers
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    BLOB_DATA BYTEA NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_trigger_listeners
+  (
+    TRIGGER_NAME  VARCHAR(80) NOT NULL, 
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    TRIGGER_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
+	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+
+CREATE TABLE qrtz_calendars
+  (
+    CALENDAR_NAME  VARCHAR(80) NOT NULL, 
+    CALENDAR BYTEA NOT NULL,
+    PRIMARY KEY (CALENDAR_NAME)
+);
+
+
+CREATE TABLE qrtz_paused_trigger_grps
+  (
+    TRIGGER_GROUP  VARCHAR(80) NOT NULL, 
+    PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE qrtz_fired_triggers 
+  (
+    ENTRY_ID VARCHAR(95) NOT NULL,
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    FIRED_TIME BIGINT NOT NULL,
+    STATE VARCHAR(16) NOT NULL,
+    JOB_NAME VARCHAR(80) NULL,
+    JOB_GROUP VARCHAR(80) NULL,
+    IS_STATEFUL VARCHAR(1) NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NULL,
+    PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE qrtz_scheduler_state 
+  (
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    LAST_CHECKIN_TIME BIGINT NOT NULL,
+    CHECKIN_INTERVAL BIGINT NOT NULL,
+    RECOVERER VARCHAR(80) NULL,
+    PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE qrtz_locks
+  (
+    LOCK_NAME  VARCHAR(40) NOT NULL, 
+    PRIMARY KEY (LOCK_NAME)
+);
+
+
+INSERT INTO qrtz_locks values('TRIGGER_ACCESS');
+INSERT INTO qrtz_locks values('JOB_ACCESS');
+INSERT INTO qrtz_locks values('CALENDAR_ACCESS');
+INSERT INTO qrtz_locks values('STATE_ACCESS');
+INSERT INTO qrtz_locks values('MISFIRE_ACCESS');
+
+commit;
+
Index: lams_build/lib/quartz/dbTables/tables_sapdb.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_sapdb.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_sapdb.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,145 @@
+#
+# Thanks to Andrew Perepelytsya for submitting this file.
+#
+# In your Quartz properties file, you'll need to set 
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
+#
+
+CREATE TABLE QRTZ_JOB_DETAILS
+(
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    JOB_CLASS_NAME VARCHAR(128) NOT NULL, 
+    IS_DURABLE VARCHAR(1) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    IS_STATEFUL VARCHAR(1) NOT NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
+    JOB_DATA LONG BYTE NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_JOB_LISTENERS
+(
+    JOB_NAME  VARCHAR(80) NOT NULL, 
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    JOB_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_TRIGGERS
+(
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    JOB_NAME  VARCHAR(80) NOT NULL, 
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    NEXT_FIRE_TIME FIXED(13) NULL,
+    PREV_FIRE_TIME FIXED(13) NULL,
+    TRIGGER_STATE VARCHAR(16) NOT NULL,
+    TRIGGER_TYPE VARCHAR(8) NOT NULL,
+    START_TIME FIXED(13) NOT NULL,
+    END_TIME FIXED(13) NULL,
+    CALENDAR_NAME VARCHAR(80) NULL,
+    MISFIRE_INSTR FIXED(2) NULL,
+    JOB_DATA LONG BYTE NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP) REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
+);
+
+CREATE TABLE QRTZ_SIMPLE_TRIGGERS
+(
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    REPEAT_COUNT FIXED(7) NOT NULL,
+    REPEAT_INTERVAL FIXED(12) NOT NULL,
+    TIMES_TRIGGERED FIXED(7) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_CRON_TRIGGERS
+(
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    CRON_EXPRESSION VARCHAR(80) NOT NULL,
+    TIME_ZONE_ID VARCHAR(80),
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_BLOB_TRIGGERS
+(
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    BLOB_DATA LONG BYTE NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_TRIGGER_LISTENERS
+(
+    TRIGGER_NAME  VARCHAR(80) NOT NULL, 
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    TRIGGER_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_CALENDARS
+(
+    CALENDAR_NAME  VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    CALENDAR LONG BYTE NOT NULL,
+    PRIMARY KEY (CALENDAR_NAME)
+);
+
+
+CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS
+  (
+    TRIGGER_GROUP  VARCHAR(80) NOT NULL, 
+    PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_FIRED_TRIGGERS 
+  (
+    ENTRY_ID VARCHAR(95) NOT NULL,
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    FIRED_TIME FIXED(13) NOT NULL,
+    STATE VARCHAR(16) NOT NULL,
+    JOB_NAME VARCHAR(80) NULL,
+    JOB_GROUP VARCHAR(80) NULL,
+    IS_STATEFUL VARCHAR(1) NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NULL,
+    PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE QRTZ_SCHEDULER_STATE
+  (
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    LAST_CHECKIN_TIME FIXED(13) NOT NULL,
+    CHECKIN_INTERVAL FIXED(13) NOT NULL,
+    RECOVERER VARCHAR(80) NULL,
+    PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE QRTZ_LOCKS
+  (
+    LOCK_NAME  VARCHAR(40) NOT NULL, 
+    PRIMARY KEY (LOCK_NAME)
+);
+
+
+INSERT INTO QRTZ_LOCKS values('TRIGGER_ACCESS');
+INSERT INTO QRTZ_LOCKS values('JOB_ACCESS');
+INSERT INTO QRTZ_LOCKS values('CALENDAR_ACCESS');
+INSERT INTO QRTZ_LOCKS values('STATE_ACCESS');
+INSERT INTO QRTZ_LOCKS values('MISFIRE_ACCESS');
+
+commit;
Index: lams_build/lib/quartz/dbTables/tables_sqlServer.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_sqlServer.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_sqlServer.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,351 @@
+--# thanks to George Papastamatopoulos for submitting this ... and Marko Lahma for
+--# updating it.
+--#
+--# In your Quartz properties file, you'll need to set 
+--# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate
+--#
+--# you shouse enter your DB instance's name on the next line in place of "enter_db_name_here"
+--#
+--#
+--# From a helpful (but anonymous) Quartz user:
+--#
+--# Regarding this error message:  
+--#
+--#     [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
+--#
+--#
+--#     I added "SelectMethod=cursor;" to my Connection URL in the config file. 
+--#     It Seems to work, hopefully no side effects.
+--#
+--#		example:
+--#		"jdbc:microsoft:sqlserver://dbmachine:1433;SelectMethod=cursor"; 
+--#
+--# Another user has pointed out that you will probably need to use the 
+--# JTDS driver
+--#
+
+USE [enter_db_name_here]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] DROP CONSTRAINT FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [dbo].[QRTZ_TRIGGERS] DROP CONSTRAINT FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] DROP CONSTRAINT FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] DROP CONSTRAINT FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_CALENDARS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_CRON_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_CRON_TRIGGERS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_BLOB_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_BLOB_TRIGGERS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_FIRED_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_FIRED_TRIGGERS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_PAUSED_TRIGGER_GRPS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SCHEDULER_STATE]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_SCHEDULER_STATE]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_LOCKS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_LOCKS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_JOB_DETAILS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_JOB_LISTENERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_JOB_LISTENERS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SIMPLE_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGER_LISTENERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_TRIGGER_LISTENERS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [dbo].[QRTZ_TRIGGERS]
+GO
+
+CREATE TABLE [dbo].[QRTZ_CALENDARS] (
+  [CALENDAR_NAME] [VARCHAR] (80)  NOT NULL ,
+  [CALENDAR] [IMAGE] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (
+  [TRIGGER_NAME] [VARCHAR] (80)  NOT NULL ,
+  [TRIGGER_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [CRON_EXPRESSION] [VARCHAR] (80)  NOT NULL ,
+  [TIME_ZONE_ID] [VARCHAR] (80) 
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (
+  [ENTRY_ID] [VARCHAR] (95)  NOT NULL ,
+  [TRIGGER_NAME] [VARCHAR] (80)  NOT NULL ,
+  [TRIGGER_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [IS_VOLATILE] [VARCHAR] (1)  NOT NULL ,
+  [INSTANCE_NAME] [VARCHAR] (80)  NOT NULL ,
+  [FIRED_TIME] [BIGINT] NOT NULL ,
+  [STATE] [VARCHAR] (16)  NOT NULL,
+  [JOB_NAME] [VARCHAR] (80)  NULL ,
+  [JOB_GROUP] [VARCHAR] (80)  NULL ,
+  [IS_STATEFUL] [VARCHAR] (1)  NULL ,
+  [REQUESTS_RECOVERY] [VARCHAR] (1)  NULL 
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (
+  [TRIGGER_GROUP] [VARCHAR] (80)  NOT NULL 
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (
+  [INSTANCE_NAME] [VARCHAR] (80)  NOT NULL ,
+  [LAST_CHECKIN_TIME] [BIGINT] NOT NULL ,
+  [CHECKIN_INTERVAL] [BIGINT] NOT NULL ,
+  [RECOVERER] [VARCHAR] (80)  NULL 
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_LOCKS] (
+  [LOCK_NAME] [VARCHAR] (40)  NOT NULL 
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
+  [JOB_NAME] [VARCHAR] (80)  NOT NULL ,
+  [JOB_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [DESCRIPTION] [VARCHAR] (120) NULL ,
+  [JOB_CLASS_NAME] [VARCHAR] (128)  NOT NULL ,
+  [IS_DURABLE] [VARCHAR] (1)  NOT NULL ,
+  [IS_VOLATILE] [VARCHAR] (1)  NOT NULL ,
+  [IS_STATEFUL] [VARCHAR] (1)  NOT NULL ,
+  [REQUESTS_RECOVERY] [VARCHAR] (1)  NOT NULL ,
+  [JOB_DATA] [IMAGE] NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_JOB_LISTENERS] (
+  [JOB_NAME] [VARCHAR] (80)  NOT NULL ,
+  [JOB_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [JOB_LISTENER] [VARCHAR] (80)  NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (
+  [TRIGGER_NAME] [VARCHAR] (80)  NOT NULL ,
+  [TRIGGER_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [REPEAT_COUNT] [BIGINT] NOT NULL ,
+  [REPEAT_INTERVAL] [BIGINT] NOT NULL ,
+  [TIMES_TRIGGERED] [BIGINT] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (
+  [TRIGGER_NAME] [VARCHAR] (80)  NOT NULL ,
+  [TRIGGER_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [BLOB_DATA] [IMAGE] NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] (
+  [TRIGGER_NAME] [VARCHAR] (80)  NOT NULL ,
+  [TRIGGER_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [TRIGGER_LISTENER] [VARCHAR] (80)  NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
+  [TRIGGER_NAME] [VARCHAR] (80)  NOT NULL ,
+  [TRIGGER_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [JOB_NAME] [VARCHAR] (80)  NOT NULL ,
+  [JOB_GROUP] [VARCHAR] (80)  NOT NULL ,
+  [IS_VOLATILE] [VARCHAR] (1)  NOT NULL ,
+  [DESCRIPTION] [VARCHAR] (120) NULL ,
+  [NEXT_FIRE_TIME] [BIGINT] NULL ,
+  [PREV_FIRE_TIME] [BIGINT] NULL ,
+  [TRIGGER_STATE] [VARCHAR] (16)  NOT NULL ,
+  [TRIGGER_TYPE] [VARCHAR] (8)  NOT NULL ,
+  [START_TIME] [BIGINT] NOT NULL ,
+  [END_TIME] [BIGINT] NULL ,
+  [CALENDAR_NAME] [VARCHAR] (80)  NULL ,
+  [MISFIRE_INSTR] [SMALLINT] NULL ,
+  [JOB_DATA] [IMAGE] NULL
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_CALENDARS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_CALENDARS] PRIMARY KEY  CLUSTERED
+  (
+    [CALENDAR_NAME]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_CRON_TRIGGERS] PRIMARY KEY  CLUSTERED
+  (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_FIRED_TRIGGERS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_FIRED_TRIGGERS] PRIMARY KEY  CLUSTERED
+  (
+    [ENTRY_ID]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_PAUSED_TRIGGER_GRPS] PRIMARY KEY  CLUSTERED
+  (
+    [TRIGGER_GROUP]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_SCHEDULER_STATE] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_SCHEDULER_STATE] PRIMARY KEY  CLUSTERED
+  (
+    [INSTANCE_NAME]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_LOCKS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_LOCKS] PRIMARY KEY  CLUSTERED
+  (
+    [LOCK_NAME]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_JOB_DETAILS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_JOB_DETAILS] PRIMARY KEY  CLUSTERED
+  (
+    [JOB_NAME],
+    [JOB_GROUP]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_JOB_LISTENERS] PRIMARY KEY  CLUSTERED
+  (
+    [JOB_NAME],
+    [JOB_GROUP],
+    [JOB_LISTENER]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_SIMPLE_TRIGGERS] PRIMARY KEY  CLUSTERED
+  (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_TRIGGER_LISTENERS] PRIMARY KEY  CLUSTERED
+  (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP],
+    [TRIGGER_LISTENER]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_TRIGGERS] WITH NOCHECK ADD
+  CONSTRAINT [PK_QRTZ_TRIGGERS] PRIMARY KEY  CLUSTERED
+  (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  )  ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] ADD
+  CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
+  (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  ) ON DELETE CASCADE
+GO
+
+ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] ADD
+  CONSTRAINT [FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS] FOREIGN KEY
+  (
+    [JOB_NAME],
+    [JOB_GROUP]
+  ) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
+    [JOB_NAME],
+    [JOB_GROUP]
+  ) ON DELETE CASCADE
+GO
+
+ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] ADD
+  CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
+  (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  ) ON DELETE CASCADE
+GO
+
+ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] ADD
+  CONSTRAINT [FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS] FOREIGN KEY
+  (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
+    [TRIGGER_NAME],
+    [TRIGGER_GROUP]
+  ) ON DELETE CASCADE
+GO
+
+ALTER TABLE [dbo].[QRTZ_TRIGGERS] ADD
+  CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS] FOREIGN KEY
+  (
+    [JOB_NAME],
+    [JOB_GROUP]
+  ) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
+    [JOB_NAME],
+    [JOB_GROUP]
+  )
+GO
+
+INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('TRIGGER_ACCESS');
+INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('JOB_ACCESS');
+INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('CALENDAR_ACCESS');
+INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('STATE_ACCESS');
+INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('MISFIRE_ACCESS');
Index: lams_build/lib/quartz/dbTables/tables_sybase.sql
===================================================================
diff -u
--- lams_build/lib/quartz/dbTables/tables_sybase.sql	(revision 0)
+++ lams_build/lib/quartz/dbTables/tables_sybase.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,313 @@
+/*==============================================================================================*/
+/* Quartz database tables creation script for Sybase ASE 12.5 */
+/* Written by Pertti Laiho (email: pertti.laiho@deio.net), 9th May 2003 */
+/* */
+/* Compatible with Quartz version 1.1.2 */
+/* */
+/* Sybase ASE works ok with the MSSQL delegate class. That means in your Quartz properties */
+/* file, you'll need to set: */
+/* org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate */
+/*==============================================================================================*/
+
+use your_db_name_here
+go
+
+/*==============================================================================*/
+/* Clear all tables: */
+/*==============================================================================*/
+
+delete from QRTZ_JOB_LISTENERS
+go
+delete from QRTZ_TRIGGER_LISTENERS
+go
+delete from QRTZ_FIRED_TRIGGERS
+go
+delete from QRTZ_PAUSED_TRIGGER_GRPS
+go
+delete from QRTZ_SCHEDULER_STATE
+go
+delete from QRTZ_LOCKS
+go
+delete from QRTZ_SIMPLE_TRIGGERS
+go
+delete from QRTZ_CRON_TRIGGERS
+go
+delete from QRTZ_BLOB_TRIGGERS
+go
+delete from QRTZ_TRIGGERS
+go
+delete from QRTZ_JOB_DETAILS
+go
+delete from QRTZ_CALENDARS
+go
+
+/*==============================================================================*/
+/* Drop constraints: */
+/*==============================================================================*/
+
+alter table QRTZ_JOB_LISTENERS
+drop constraint FK_job_listeners_job_details
+go
+
+alter table QRTZ_TRIGGERS
+drop constraint FK_triggers_job_details
+go
+
+alter table QRTZ_CRON_TRIGGERS
+drop constraint FK_cron_triggers_triggers
+go
+
+alter table QRTZ_SIMPLE_TRIGGERS
+drop constraint FK_simple_triggers_triggers
+go
+
+alter table QRTZ_TRIGGER_LISTENERS
+drop constraint FK_trigger_listeners_triggers
+go
+
+alter table QRTZ_BLOB_TRIGGERS
+drop constraint FK_blob_triggers_triggers
+go
+
+/*==============================================================================*/
+/* Drop tables: */
+/*==============================================================================*/
+
+drop table QRTZ_JOB_LISTENERS
+go
+drop table QRTZ_TRIGGER_LISTENERS
+go
+drop table QRTZ_FIRED_TRIGGERS
+go
+drop table QRTZ_PAUSED_TRIGGER_GRPS
+go
+drop table QRTZ_SCHEDULER_STATE
+go
+drop table QRTZ_LOCKS
+go
+drop table QRTZ_SIMPLE_TRIGGERS
+go
+drop table QRTZ_CRON_TRIGGERS
+go
+drop table QRTZ_BLOB_TRIGGERS
+go
+drop table QRTZ_TRIGGERS
+go
+drop table QRTZ_JOB_DETAILS
+go
+drop table QRTZ_CALENDARS
+go
+
+/*==============================================================================*/
+/* Create tables: */
+/*==============================================================================*/
+
+create table QRTZ_CALENDARS (
+CALENDAR_NAME varchar(80) not null,
+CALENDAR image not null
+)
+go
+
+create table QRTZ_CRON_TRIGGERS (
+TRIGGER_NAME varchar(80) not null,
+TRIGGER_GROUP varchar(80) not null,
+CRON_EXPRESSION varchar(80) not null,
+TIME_ZONE_ID varchar(80) null,
+)
+go
+
+create table QRTZ_PAUSED_TRIGGER_GRPS (
+TRIGGER_GROUP  varchar(80) not null, 
+)
+go
+
+create table QRTZ_FIRED_TRIGGERS(
+ENTRY_ID varchar(95) not null,
+TRIGGER_NAME varchar(80) not null,
+TRIGGER_GROUP varchar(80) not null,
+IS_VOLATILE bit not null,
+INSTANCE_NAME varchar(80) not null,
+FIRED_TIME numeric(13,0) not null,
+STATE varchar(16) not null,
+JOB_NAME varchar(80) null,
+JOB_GROUP varchar(80) null,
+IS_STATEFUL bit not null,
+REQUESTS_RECOVERY bit not null,
+)
+go
+
+create table QRTZ_SCHEDULER_STATE (
+INSTANCE_NAME varchar(80) not null,
+LAST_CHECKIN_TIME numeric(13,0) not null,
+CHECKIN_INTERVAL numeric(13,0) not null,
+RECOVERER varchar(80) null,
+)
+go
+
+create table QRTZ_LOCKS (
+LOCK_NAME  varchar(40) not null, 
+)
+go
+
+insert into QRTZ_LOCKS values('TRIGGER_ACCESS')
+go
+insert into QRTZ_LOCKS values('JOB_ACCESS')
+go
+insert into QRTZ_LOCKS values('CALENDAR_ACCESS')
+go
+insert into QRTZ_LOCKS values('STATE_ACCESS')
+go
+
+
+create table QRTZ_JOB_DETAILS (
+JOB_NAME varchar(80) not null,
+JOB_GROUP varchar(80) not null,
+DESCRIPTION varchar(120) null,
+JOB_CLASS_NAME varchar(128) not null,
+IS_DURABLE bit not null,
+IS_VOLATILE bit not null,
+IS_STATEFUL bit not null,
+REQUESTS_RECOVERY bit not null,
+JOB_DATA image null
+)
+go
+
+create table QRTZ_JOB_LISTENERS (
+JOB_NAME varchar(80) not null,
+JOB_GROUP varchar(80) not null,
+JOB_LISTENER varchar(80) not null
+)
+go
+
+create table QRTZ_SIMPLE_TRIGGERS (
+TRIGGER_NAME varchar(80) not null,
+TRIGGER_GROUP varchar(80) not null,
+REPEAT_COUNT numeric(13,0) not null,
+REPEAT_INTERVAL numeric(13,0) not null,
+TIMES_TRIGGERED numeric(13,0) not null
+)
+go
+
+create table QRTZ_BLOB_TRIGGERS (
+TRIGGER_NAME varchar(80) not null,
+TRIGGER_GROUP varchar(80) not null,
+BLOB_DATA image null
+)
+go
+
+create table QRTZ_TRIGGER_LISTENERS (
+TRIGGER_NAME varchar(80) not null,
+TRIGGER_GROUP varchar(80) not null,
+TRIGGER_LISTENER varchar(80) not null
+)
+go
+
+create table QRTZ_TRIGGERS (
+TRIGGER_NAME varchar(80) not null,
+TRIGGER_GROUP varchar(80) not null,
+JOB_NAME varchar(80) not null,
+JOB_GROUP varchar(80) not null,
+IS_VOLATILE bit not null,
+DESCRIPTION varchar(120) null,
+NEXT_FIRE_TIME numeric(13,0) null,
+PREV_FIRE_TIME numeric(13,0) null,
+TRIGGER_STATE varchar(16) not null,
+TRIGGER_TYPE varchar(8) not null,
+START_TIME numeric(13,0) not null,
+END_TIME numeric(13,0) null,
+CALENDAR_NAME varchar(80) null,
+MISFIRE_INSTR smallint null
+JOB_DATA image null
+)
+go
+
+/*==============================================================================*/
+/* Create primary key constraints: */
+/*==============================================================================*/
+
+alter table QRTZ_CALENDARS
+add constraint PK_qrtz_calendars primary key clustered (CALENDAR_NAME)
+go
+
+alter table QRTZ_CRON_TRIGGERS
+add constraint PK_qrtz_cron_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP)
+go
+
+alter table QRTZ_FIRED_TRIGGERS
+add constraint PK_qrtz_fired_triggers primary key clustered (ENTRY_ID)
+go
+
+alter table QRTZ_PAUSED_TRIGGER_GRPS
+add constraint PK_qrtz_paused_trigger_grps primary key clustered (TRIGGER_GROUP)
+go
+
+alter table QRTZ_SCHEDULER_STATE
+add constraint PK_qrtz_scheduler_state primary key clustered (INSTANCE_NAME)
+go
+
+alter table QRTZ_LOCKS
+add constraint PK_qrtz_locks primary key clustered (LOCK_NAME)
+go
+
+alter table QRTZ_JOB_DETAILS
+add constraint PK_qrtz_job_details primary key clustered (JOB_NAME, JOB_GROUP)
+go
+
+alter table QRTZ_JOB_LISTENERS
+add constraint PK_qrtz_job_listeners primary key clustered (JOB_NAME, JOB_GROUP, JOB_LISTENER)
+go
+
+alter table QRTZ_SIMPLE_TRIGGERS
+add constraint PK_qrtz_simple_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP)
+go
+
+alter table QRTZ_TRIGGER_LISTENERS
+add constraint PK_qrtz_trigger_listeners primary key clustered (TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_LISTENER)
+go
+
+alter table QRTZ_TRIGGERS
+add constraint PK_qrtz_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP)
+go
+
+alter table QRTZ_BLOB_TRIGGERS
+add constraint PK_qrtz_blob_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP)
+go
+
+
+/*==============================================================================*/
+/* Create foreign key constraints: */
+/*==============================================================================*/
+
+alter table QRTZ_CRON_TRIGGERS
+add constraint FK_cron_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP)
+references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP)
+go
+
+alter table QRTZ_JOB_LISTENERS
+add constraint FK_job_listeners_job_details foreign key (JOB_NAME,JOB_GROUP)
+references QRTZ_JOB_DETAILS (JOB_NAME,JOB_GROUP)
+go
+
+alter table QRTZ_SIMPLE_TRIGGERS
+add constraint FK_simple_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP)
+references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP)
+go
+
+alter table QRTZ_TRIGGER_LISTENERS
+add constraint FK_trigger_listeners_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP)
+references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP)
+go
+
+alter table QRTZ_TRIGGERS
+add constraint FK_triggers_job_details foreign key (JOB_NAME,JOB_GROUP)
+references QRTZ_JOB_DETAILS (JOB_NAME,JOB_GROUP)
+go
+
+alter table QRTZ_BLOB_TRIGGERS
+add constraint FK_blob_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP)
+references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP)
+go
+
+/*==============================================================================*/
+/* End of script. */
+/*==============================================================================*/
Index: lams_build/lib/quartz/quartz.jar
===================================================================
diff -u -r29276ae77ec41cd93deff18fc89fd656d2ad3ed2 -rd5e8d7001b9fb1f67ee7216ac92ea3d9012165dd
Binary files differ
Index: lams_common/build.xml
===================================================================
diff -u -r41310179488402699ef1887251aa45691e30c41a -rd5e8d7001b9fb1f67ee7216ac92ea3d9012165dd
--- lams_common/build.xml	(.../build.xml)	(revision 41310179488402699ef1887251aa45691e30c41a)
+++ lams_common/build.xml	(.../build.xml)	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -268,6 +268,20 @@
 			<transaction src="${db.scripts}/insert_types_data.sql"/>
 			<transaction src="${db.scripts}/insert_users.sql"/>
 		</sql>
+		<!-- Create Quartz table --> 
+	    <sql
+	        driver="${db.driver}"
+	        url="${db.url}"
+	        userid="${db.username}"
+	        password="${db.password}">
+	
+	        <classpath>
+	            <pathelement location="${db.driver.jar}"/>
+	        </classpath>
+	    	<transaction src="${db.scripts}/create_quartz_table.sql"/>
+	    </sql>
+		
+		
 		<delete dir="${contentrepository.directory}"/>
 	</target>
 
Index: lams_common/db/sql/create_quartz_table.sql
===================================================================
diff -u
--- lams_common/db/sql/create_quartz_table.sql	(revision 0)
+++ lams_common/db/sql/create_quartz_table.sql	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -0,0 +1,169 @@
+# LAMS1.1: quartz 1.5.2 table definition
+#
+# Quartz seems to work best with the driver mm.mysql-2.0.7-bin.jar
+#
+# In your Quartz properties file, you'll need to set 
+# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
+#
+
+set foreign_key_checks = 0;
+
+DROP TABLE IF EXISTS lams_quartz_JOB_LISTENERS;
+DROP TABLE IF EXISTS lams_quartz_TRIGGER_LISTENERS;
+DROP TABLE IF EXISTS lams_quartz_FIRED_TRIGGERS;
+DROP TABLE IF EXISTS lams_quartz_PAUSED_TRIGGER_GRPS;
+DROP TABLE IF EXISTS lams_quartz_SCHEDULER_STATE;
+DROP TABLE IF EXISTS lams_quartz_LOCKS;
+DROP TABLE IF EXISTS lams_quartz_SIMPLE_TRIGGERS;
+DROP TABLE IF EXISTS lams_quartz_CRON_TRIGGERS;
+DROP TABLE IF EXISTS lams_quartz_BLOB_TRIGGERS;
+DROP TABLE IF EXISTS lams_quartz_TRIGGERS;
+DROP TABLE IF EXISTS lams_quartz_JOB_DETAILS;
+DROP TABLE IF EXISTS lams_quartz_CALENDARS;
+
+
+CREATE TABLE lams_quartz_JOB_DETAILS
+  (
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    JOB_CLASS_NAME   VARCHAR(128) NOT NULL,
+    IS_DURABLE VARCHAR(1) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    IS_STATEFUL VARCHAR(1) NOT NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
+    JOB_DATA BLOB NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE lams_quartz_JOB_LISTENERS
+  (
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    JOB_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP)
+        REFERENCES lams_quartz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE lams_quartz_TRIGGERS
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    JOB_NAME  VARCHAR(80) NOT NULL,
+    JOB_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    DESCRIPTION VARCHAR(120) NULL,
+    NEXT_FIRE_TIME BIGINT(13) NULL,
+    PREV_FIRE_TIME BIGINT(13) NULL,
+    TRIGGER_STATE VARCHAR(16) NOT NULL,
+    TRIGGER_TYPE VARCHAR(8) NOT NULL,
+    START_TIME BIGINT(13) NOT NULL,
+    END_TIME BIGINT(13) NULL,
+    CALENDAR_NAME VARCHAR(80) NULL,
+    MISFIRE_INSTR SMALLINT(2) NULL,
+    JOB_DATA BLOB NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (JOB_NAME,JOB_GROUP)
+        REFERENCES lams_quartz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE lams_quartz_SIMPLE_TRIGGERS
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    REPEAT_COUNT BIGINT(7) NOT NULL,
+    REPEAT_INTERVAL BIGINT(12) NOT NULL,
+    TIMES_TRIGGERED BIGINT(7) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES lams_quartz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE lams_quartz_CRON_TRIGGERS
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    CRON_EXPRESSION VARCHAR(80) NOT NULL,
+    TIME_ZONE_ID VARCHAR(80),
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES lams_quartz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE lams_quartz_BLOB_TRIGGERS
+  (
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    BLOB_DATA BLOB NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES lams_quartz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE lams_quartz_TRIGGER_LISTENERS
+  (
+    TRIGGER_NAME  VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    TRIGGER_LISTENER VARCHAR(80) NOT NULL,
+    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES lams_quartz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+
+CREATE TABLE lams_quartz_CALENDARS
+  (
+    CALENDAR_NAME  VARCHAR(80) NOT NULL,
+    CALENDAR BLOB NOT NULL,
+    PRIMARY KEY (CALENDAR_NAME)
+);
+
+
+
+CREATE TABLE lams_quartz_PAUSED_TRIGGER_GRPS
+  (
+    TRIGGER_GROUP  VARCHAR(80) NOT NULL, 
+    PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE lams_quartz_FIRED_TRIGGERS
+  (
+    ENTRY_ID VARCHAR(95) NOT NULL,
+    TRIGGER_NAME VARCHAR(80) NOT NULL,
+    TRIGGER_GROUP VARCHAR(80) NOT NULL,
+    IS_VOLATILE VARCHAR(1) NOT NULL,
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    FIRED_TIME BIGINT(13) NOT NULL,
+    STATE VARCHAR(16) NOT NULL,
+    JOB_NAME VARCHAR(80) NULL,
+    JOB_GROUP VARCHAR(80) NULL,
+    IS_STATEFUL VARCHAR(1) NULL,
+    REQUESTS_RECOVERY VARCHAR(1) NULL,
+    PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE lams_quartz_SCHEDULER_STATE
+  (
+    INSTANCE_NAME VARCHAR(80) NOT NULL,
+    LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
+    CHECKIN_INTERVAL BIGINT(13) NOT NULL,
+    RECOVERER VARCHAR(80) NULL,
+    PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE lams_quartz_LOCKS
+  (
+    LOCK_NAME  VARCHAR(40) NOT NULL, 
+    PRIMARY KEY (LOCK_NAME)
+);
+
+
+INSERT INTO lams_quartz_LOCKS values('TRIGGER_ACCESS');
+INSERT INTO lams_quartz_LOCKS values('JOB_ACCESS');
+INSERT INTO lams_quartz_LOCKS values('CALENDAR_ACCESS');
+INSERT INTO lams_quartz_LOCKS values('STATE_ACCESS');
+INSERT INTO lams_quartz_LOCKS values('MISFIRE_ACCESS');
+
+
+set foreign_key_checks = 1;
\ No newline at end of file
Index: lams_common/src/java/org/lamsfoundation/lams/applicationContext.xml
===================================================================
diff -u -r750f84843809e7143585d1ace1742c935df2898a -rd5e8d7001b9fb1f67ee7216ac92ea3d9012165dd
--- lams_common/src/java/org/lamsfoundation/lams/applicationContext.xml	(.../applicationContext.xml)	(revision 750f84843809e7143585d1ace1742c935df2898a)
+++ lams_common/src/java/org/lamsfoundation/lams/applicationContext.xml	(.../applicationContext.xml)	(revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd)
@@ -39,6 +39,10 @@
 	<bean id="toolDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
 		<property name="jndiName"><value>java:jdbc/tool-ds</value></property>
 	</bean>
+	
+	<bean id="quartzDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
+		<property name="jndiName"><value>java:jdbc/quartz-ds</value></property>
+	</bean>
 
 	<!--  Transaction manager for all transactions involving the core classes or the content repository. -->