You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@syncope.apache.org by il...@apache.org on 2013/03/13 14:24:33 UTC
svn commit: r1455927 -
/syncope/trunk/core/src/main/resources/quartz/tables_sqlServer.sql
Author: ilgrosso
Date: Wed Mar 13 13:24:32 2013
New Revision: 1455927
URL: http://svn.apache.org/r1455927
Log:
H2, MySQL, Oracle and SQL Server are on; still PostgreSQL to go
Modified:
syncope/trunk/core/src/main/resources/quartz/tables_sqlServer.sql
Modified: syncope/trunk/core/src/main/resources/quartz/tables_sqlServer.sql
URL: http://svn.apache.org/viewvc/syncope/trunk/core/src/main/resources/quartz/tables_sqlServer.sql?rev=1455927&r1=1455926&r2=1455927&view=diff
==============================================================================
--- syncope/trunk/core/src/main/resources/quartz/tables_sqlServer.sql (original)
+++ syncope/trunk/core/src/main/resources/quartz/tables_sqlServer.sql Wed Mar 13 13:24:32 2013
@@ -15,101 +15,11 @@
-- specific language governing permissions and limitations
-- under the License.
---# 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_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_SIMPROP_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
-ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPROP_TRIGGERS_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_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_SIMPROP_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
-DROP TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS]
-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] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
[CALENDAR_NAME] [VARCHAR] (200) NOT NULL ,
[CALENDAR] [IMAGE] NOT NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
@@ -117,8 +27,7 @@ CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS]
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
[CRON_EXPRESSION] [VARCHAR] (120) NOT NULL ,
[TIME_ZONE_ID] [VARCHAR] (80)
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
@@ -133,28 +42,24 @@ CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS]
[JOB_GROUP] [VARCHAR] (200) NULL ,
[IS_NONCONCURRENT] [VARCHAR] (1) NULL ,
[REQUESTS_RECOVERY] [VARCHAR] (1) NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
[INSTANCE_NAME] [VARCHAR] (200) NOT NULL ,
[LAST_CHECKIN_TIME] [BIGINT] NOT NULL ,
[CHECKIN_INTERVAL] [BIGINT] NOT NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_LOCKS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
[LOCK_NAME] [VARCHAR] (40) NOT NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
@@ -167,8 +72,7 @@ CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
[IS_UPDATE_DATA] [VARCHAR] (1) NOT NULL ,
[REQUESTS_RECOVERY] [VARCHAR] (1) NOT NULL ,
[JOB_DATA] [IMAGE] NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
@@ -177,8 +81,7 @@ CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS
[REPEAT_COUNT] [BIGINT] NOT NULL ,
[REPEAT_INTERVAL] [BIGINT] NOT NULL ,
[TIMES_TRIGGERED] [BIGINT] NOT NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
@@ -195,16 +98,14 @@ CREATE TABLE [dbo].[QRTZ_SIMPROP_TRIGGER
[DEC_PROP_2] [NUMERIC] (13,4) NULL,
[BOOL_PROP_1] [VARCHAR] (1) NULL,
[BOOL_PROP_2] [VARCHAR] (1) NULL,
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
[BLOB_DATA] [IMAGE] NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
@@ -223,16 +124,14 @@ CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
[CALENDAR_NAME] [VARCHAR] (200) NULL ,
[MISFIRE_INSTR] [SMALLINT] NULL ,
[JOB_DATA] [IMAGE] NULL
-) ON [PRIMARY]
-GO
+) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_CALENDARS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_CALENDARS] PRIMARY KEY CLUSTERED
(
[SCHED_NAME],
[CALENDAR_NAME]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_CRON_TRIGGERS] PRIMARY KEY CLUSTERED
@@ -240,40 +139,35 @@ ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] W
[SCHED_NAME],
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_FIRED_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_FIRED_TRIGGERS] PRIMARY KEY CLUSTERED
(
[SCHED_NAME],
[ENTRY_ID]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_PAUSED_TRIGGER_GRPS] PRIMARY KEY CLUSTERED
(
[SCHED_NAME],
[TRIGGER_GROUP]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_SCHEDULER_STATE] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_SCHEDULER_STATE] PRIMARY KEY CLUSTERED
(
[SCHED_NAME],
[INSTANCE_NAME]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_LOCKS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_LOCKS] PRIMARY KEY CLUSTERED
(
[SCHED_NAME],
[LOCK_NAME]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_JOB_DETAILS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_JOB_DETAILS] PRIMARY KEY CLUSTERED
@@ -281,8 +175,7 @@ ALTER TABLE [dbo].[QRTZ_JOB_DETAILS] WIT
[SCHED_NAME],
[JOB_NAME],
[JOB_GROUP]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_SIMPLE_TRIGGERS] PRIMARY KEY CLUSTERED
@@ -290,8 +183,7 @@ ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS]
[SCHED_NAME],
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_SIMPROP_TRIGGERS] PRIMARY KEY CLUSTERED
@@ -299,8 +191,7 @@ ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS
[SCHED_NAME],
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_TRIGGERS] PRIMARY KEY CLUSTERED
@@ -308,8 +199,7 @@ ALTER TABLE [dbo].[QRTZ_TRIGGERS] WITH N
[SCHED_NAME],
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) ON [PRIMARY]
-GO
+ ) ON [PRIMARY];
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] ADD
CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
@@ -321,8 +211,7 @@ ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] A
[SCHED_NAME],
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) ON DELETE CASCADE
-GO
+ ) ON DELETE CASCADE;
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] ADD
CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
@@ -334,8 +223,7 @@ ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS]
[SCHED_NAME],
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) ON DELETE CASCADE
-GO
+ ) ON DELETE CASCADE;
ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] ADD
CONSTRAINT [FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
@@ -347,8 +235,7 @@ ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS
[SCHED_NAME],
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) ON DELETE CASCADE
-GO
+ ) ON DELETE CASCADE;
ALTER TABLE [dbo].[QRTZ_TRIGGERS] ADD
CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS] FOREIGN KEY
@@ -360,6 +247,4 @@ ALTER TABLE [dbo].[QRTZ_TRIGGERS] ADD
[SCHED_NAME],
[JOB_NAME],
[JOB_GROUP]
- )
-GO
-
+ );