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.5 -r1.6
--- lams_common/db/sql/create_quartz_table.sql	17 Aug 2006 02:19:15 -0000	1.5
+++ lams_common/db/sql/create_quartz_table.sql	29 Feb 2008 03:46:48 -0000	1.6
@@ -36,7 +36,7 @@
     REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
     JOB_DATA BLOB NULL,
     PRIMARY KEY (JOB_NAME,JOB_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_JOB_LISTENERS
   (
@@ -46,7 +46,7 @@
     PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
     FOREIGN KEY (JOB_NAME,JOB_GROUP)
         REFERENCES lams_qtz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_TRIGGERS
   (
@@ -68,7 +68,7 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (JOB_NAME,JOB_GROUP)
         REFERENCES lams_qtz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_SIMPLE_TRIGGERS
   (
@@ -80,7 +80,7 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_CRON_TRIGGERS
   (
@@ -91,7 +91,7 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_BLOB_TRIGGERS
   (
@@ -101,7 +101,7 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_TRIGGER_LISTENERS
   (
@@ -111,23 +111,23 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 
 CREATE TABLE lams_qtz_CALENDARS
   (
     CALENDAR_NAME  VARCHAR(80) NOT NULL,
     CALENDAR BLOB NOT NULL,
     PRIMARY KEY (CALENDAR_NAME)
-);
+)TYPE=InnoDB;
 
 
 
 CREATE TABLE lams_qtz_PAUSED_TRIGGER_GRPS
   (
     TRIGGER_GROUP  VARCHAR(80) NOT NULL, 
     PRIMARY KEY (TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_FIRED_TRIGGERS
   (
@@ -143,7 +143,7 @@
     IS_STATEFUL VARCHAR(1) NULL,
     REQUESTS_RECOVERY VARCHAR(1) NULL,
     PRIMARY KEY (ENTRY_ID)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_SCHEDULER_STATE
   (
@@ -152,13 +152,13 @@
     CHECKIN_INTERVAL BIGINT(13) NOT NULL,
     RECOVERER VARCHAR(80) NULL,
     PRIMARY KEY (INSTANCE_NAME)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_LOCKS
   (
     LOCK_NAME  VARCHAR(40) NOT NULL, 
     PRIMARY KEY (LOCK_NAME)
-);
+)TYPE=InnoDB;
 
 
 INSERT INTO lams_qtz_LOCKS values('TRIGGER_ACCESS');