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 - + );