Index: lams_common/db/sql/create_quartz_table.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_quartz_table.sql,v
diff -u -r1.4 -r1.5
--- lams_common/db/sql/create_quartz_table.sql	21 Mar 2006 05:55:25 -0000	1.4
+++ lams_common/db/sql/create_quartz_table.sql	17 Aug 2006 02:19:15 -0000	1.5
@@ -10,21 +10,21 @@
 
 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;
+DROP TABLE IF EXISTS lams_qtz_JOB_LISTENERS;
+DROP TABLE IF EXISTS lams_qtz_TRIGGER_LISTENERS;
+DROP TABLE IF EXISTS lams_qtz_FIRED_TRIGGERS;
+DROP TABLE IF EXISTS lams_qtz_PAUSED_TRIGGER_GRPS;
+DROP TABLE IF EXISTS lams_qtz_SCHEDULER_STATE;
+DROP TABLE IF EXISTS lams_qtz_LOCKS;
+DROP TABLE IF EXISTS lams_qtz_SIMPLE_TRIGGERS;
+DROP TABLE IF EXISTS lams_qtz_CRON_TRIGGERS;
+DROP TABLE IF EXISTS lams_qtz_BLOB_TRIGGERS;
+DROP TABLE IF EXISTS lams_qtz_TRIGGERS;
+DROP TABLE IF EXISTS lams_qtz_JOB_DETAILS;
+DROP TABLE IF EXISTS lams_qtz_CALENDARS;
 
 
-CREATE TABLE lams_quartz_JOB_DETAILS
+CREATE TABLE lams_qtz_JOB_DETAILS
   (
     JOB_NAME  VARCHAR(80) NOT NULL,
     JOB_GROUP VARCHAR(80) NOT NULL,
@@ -38,17 +38,17 @@
     PRIMARY KEY (JOB_NAME,JOB_GROUP)
 );
 
-CREATE TABLE lams_quartz_JOB_LISTENERS
+CREATE TABLE lams_qtz_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)
+        REFERENCES lams_qtz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
 );
 
-CREATE TABLE lams_quartz_TRIGGERS
+CREATE TABLE lams_qtz_TRIGGERS
   (
     TRIGGER_NAME VARCHAR(80) NOT NULL,
     TRIGGER_GROUP VARCHAR(80) NOT NULL,
@@ -67,10 +67,10 @@
     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)
+        REFERENCES lams_qtz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
 );
 
-CREATE TABLE lams_quartz_SIMPLE_TRIGGERS
+CREATE TABLE lams_qtz_SIMPLE_TRIGGERS
   (
     TRIGGER_NAME VARCHAR(80) NOT NULL,
     TRIGGER_GROUP VARCHAR(80) NOT NULL,
@@ -79,42 +79,42 @@
     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)
+        REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
 );
 
-CREATE TABLE lams_quartz_CRON_TRIGGERS
+CREATE TABLE lams_qtz_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)
+        REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
 );
 
-CREATE TABLE lams_quartz_BLOB_TRIGGERS
+CREATE TABLE lams_qtz_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)
+        REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
 );
 
-CREATE TABLE lams_quartz_TRIGGER_LISTENERS
+CREATE TABLE lams_qtz_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)
+        REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
 );
 
 
-CREATE TABLE lams_quartz_CALENDARS
+CREATE TABLE lams_qtz_CALENDARS
   (
     CALENDAR_NAME  VARCHAR(80) NOT NULL,
     CALENDAR BLOB NOT NULL,
@@ -123,13 +123,13 @@
 
 
 
-CREATE TABLE lams_quartz_PAUSED_TRIGGER_GRPS
+CREATE TABLE lams_qtz_PAUSED_TRIGGER_GRPS
   (
     TRIGGER_GROUP  VARCHAR(80) NOT NULL, 
     PRIMARY KEY (TRIGGER_GROUP)
 );
 
-CREATE TABLE lams_quartz_FIRED_TRIGGERS
+CREATE TABLE lams_qtz_FIRED_TRIGGERS
   (
     ENTRY_ID VARCHAR(95) NOT NULL,
     TRIGGER_NAME VARCHAR(80) NOT NULL,
@@ -145,7 +145,7 @@
     PRIMARY KEY (ENTRY_ID)
 );
 
-CREATE TABLE lams_quartz_SCHEDULER_STATE
+CREATE TABLE lams_qtz_SCHEDULER_STATE
   (
     INSTANCE_NAME VARCHAR(80) NOT NULL,
     LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
@@ -154,18 +154,18 @@
     PRIMARY KEY (INSTANCE_NAME)
 );
 
-CREATE TABLE lams_quartz_LOCKS
+CREATE TABLE lams_qtz_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');
+INSERT INTO lams_qtz_LOCKS values('TRIGGER_ACCESS');
+INSERT INTO lams_qtz_LOCKS values('JOB_ACCESS');
+INSERT INTO lams_qtz_LOCKS values('CALENDAR_ACCESS');
+INSERT INTO lams_qtz_LOCKS values('STATE_ACCESS');
+INSERT INTO lams_qtz_LOCKS values('MISFIRE_ACCESS');
 
 
 set foreign_key_checks = 1;
\ No newline at end of file