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 2012/10/17 13:35:36 UTC
svn commit: r1399186 - in
/incubator/syncope/branches/1_0_X/core/src/main/resources:
logback/sqlserver.sql quartz/tables_sqlserver.sql
Author: ilgrosso
Date: Wed Oct 17 11:35:35 2012
New Revision: 1399186
URL: http://svn.apache.org/viewvc?rev=1399186&view=rev
Log:
Fixing misbehaviour with SQL Server and non-Syncope (i.e. Quartz and Logback) tables creation
Modified:
incubator/syncope/branches/1_0_X/core/src/main/resources/logback/sqlserver.sql
incubator/syncope/branches/1_0_X/core/src/main/resources/quartz/tables_sqlserver.sql
Modified: incubator/syncope/branches/1_0_X/core/src/main/resources/logback/sqlserver.sql
URL: http://svn.apache.org/viewvc/incubator/syncope/branches/1_0_X/core/src/main/resources/logback/sqlserver.sql?rev=1399186&r1=1399185&r2=1399186&view=diff
==============================================================================
--- incubator/syncope/branches/1_0_X/core/src/main/resources/logback/sqlserver.sql (original)
+++ incubator/syncope/branches/1_0_X/core/src/main/resources/logback/sqlserver.sql Wed Oct 17 11:35:35 2012
@@ -19,46 +19,8 @@ DROP TABLE logging_event_property
DROP TABLE logging_event_exception
DROP TABLE logging_event
-CREATE TABLE logging_event
- (
- timestmp DECIMAL(20) NOT NULL,
- formatted_message VARCHAR(4000) NOT NULL,
- logger_name VARCHAR(254) NOT NULL,
- level_string VARCHAR(254) NOT NULL,
- thread_name VARCHAR(254),
- reference_flag SMALLINT,
- arg0 VARCHAR(254),
- arg1 VARCHAR(254),
- arg2 VARCHAR(254),
- arg3 VARCHAR(254),
- caller_filename VARCHAR(254) NOT NULL,
- caller_class VARCHAR(254) NOT NULL,
- caller_method VARCHAR(254) NOT NULL,
- caller_line CHAR(4) NOT NULL,
- event_id DECIMAL(40) NOT NULL identity,
- PRIMARY KEY(event_id)
- )
+CREATE TABLE logging_event ( timestmp DECIMAL(20) NOT NULL, formatted_message VARCHAR(4000) NOT NULL, logger_name VARCHAR(254) NOT NULL, level_string VARCHAR(254) NOT NULL, thread_name VARCHAR(254), reference_flag SMALLINT, arg0 VARCHAR(254), arg1 VARCHAR(254), arg2 VARCHAR(254), arg3 VARCHAR(254), caller_filename VARCHAR(254) NOT NULL, caller_class VARCHAR(254) NOT NULL, caller_method VARCHAR(254) NOT NULL, caller_line CHAR(4) NOT NULL, event_id DECIMAL(38) NOT NULL identity, PRIMARY KEY(event_id))
-CREATE TABLE logging_event_property
- (
- event_id DECIMAL(40) NOT NULL,
- mapped_key VARCHAR(254) NOT NULL,
- mapped_value VARCHAR(1024),
- PRIMARY KEY(event_id, mapped_key),
- FOREIGN KEY (event_id) REFERENCES logging_event(event_id)
- )
+CREATE TABLE logging_event_property ( event_id DECIMAL(38) NOT NULL, mapped_key VARCHAR(254) NOT NULL, mapped_value VARCHAR(1024), PRIMARY KEY(event_id, mapped_key), FOREIGN KEY (event_id) REFERENCES logging_event(event_id))
-CREATE TABLE logging_event_exception
- (
-
- event_id DECIMAL(40) NOT NULL,
-
- i SMALLINT NOT NULL,
-
- trace_line VARCHAR(254) NOT NULL,
-
- PRIMARY KEY(event_id, i),
-
- FOREIGN KEY (event_id) REFERENCES logging_event(event_id)
-
- )
+CREATE TABLE logging_event_exception ( event_id DECIMAL(38) NOT NULL, i SMALLINT NOT NULL, trace_line VARCHAR(254) NOT NULL, PRIMARY KEY(event_id, i), FOREIGN KEY (event_id) REFERENCES logging_event(event_id) )
Modified: incubator/syncope/branches/1_0_X/core/src/main/resources/quartz/tables_sqlserver.sql
URL: http://svn.apache.org/viewvc/incubator/syncope/branches/1_0_X/core/src/main/resources/quartz/tables_sqlserver.sql?rev=1399186&r1=1399185&r2=1399186&view=diff
==============================================================================
--- incubator/syncope/branches/1_0_X/core/src/main/resources/quartz/tables_sqlserver.sql (original)
+++ incubator/syncope/branches/1_0_X/core/src/main/resources/quartz/tables_sqlserver.sql Wed Oct 17 11:35:35 2012
@@ -15,72 +15,70 @@
-- specific language governing permissions and limitations
-- under the License.
-USE syncope
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [QRTZ_JOB_LISTENERS] DROP CONSTRAINT FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS
-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
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [QRTZ_TRIGGERS] DROP CONSTRAINT FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS
-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
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [QRTZ_CRON_TRIGGERS] DROP CONSTRAINT FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS
-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
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [QRTZ_SIMPLE_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS
-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
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
+ALTER TABLE [QRTZ_TRIGGER_LISTENERS] DROP CONSTRAINT FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS
-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
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_CALENDARS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_CRON_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_CRON_TRIGGERS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_BLOB_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_BLOB_TRIGGERS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_FIRED_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_FIRED_TRIGGERS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_PAUSED_TRIGGER_GRPS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_PAUSED_TRIGGER_GRPS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_SCHEDULER_STATE]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_SCHEDULER_STATE]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_LOCKS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_LOCKS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_JOB_DETAILS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_JOB_LISTENERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_JOB_LISTENERS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_SIMPLE_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_SIMPLE_TRIGGERS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_TRIGGER_LISTENERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_TRIGGER_LISTENERS]
-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]
+IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
+DROP TABLE [QRTZ_TRIGGERS]
-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]
-
-CREATE TABLE [dbo].[QRTZ_CALENDARS] (
+CREATE TABLE [QRTZ_CALENDARS] (
[CALENDAR_NAME] [VARCHAR] (200) NOT NULL ,
[CALENDAR] [IMAGE] NOT NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (
+CREATE TABLE [QRTZ_CRON_TRIGGERS] (
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
[CRON_EXPRESSION] [VARCHAR] (120) NOT NULL ,
[TIME_ZONE_ID] [VARCHAR] (80)
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (
+CREATE TABLE [QRTZ_FIRED_TRIGGERS] (
[ENTRY_ID] [VARCHAR] (95) NOT NULL ,
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
@@ -95,21 +93,21 @@ CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS]
[REQUESTS_RECOVERY] [VARCHAR] (1) NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (
+CREATE TABLE [QRTZ_PAUSED_TRIGGER_GRPS] (
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (
+CREATE TABLE [QRTZ_SCHEDULER_STATE] (
[INSTANCE_NAME] [VARCHAR] (200) NOT NULL ,
[LAST_CHECKIN_TIME] [BIGINT] NOT NULL ,
[CHECKIN_INTERVAL] [BIGINT] NOT NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_LOCKS] (
+CREATE TABLE [QRTZ_LOCKS] (
[LOCK_NAME] [VARCHAR] (40) NOT NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
+CREATE TABLE [QRTZ_JOB_DETAILS] (
[JOB_NAME] [VARCHAR] (200) NOT NULL ,
[JOB_GROUP] [VARCHAR] (200) NOT NULL ,
[DESCRIPTION] [VARCHAR] (250) NULL ,
@@ -121,13 +119,13 @@ CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
[JOB_DATA] [IMAGE] NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_JOB_LISTENERS] (
+CREATE TABLE [QRTZ_JOB_LISTENERS] (
[JOB_NAME] [VARCHAR] (200) NOT NULL ,
[JOB_GROUP] [VARCHAR] (200) NOT NULL ,
[JOB_LISTENER] [VARCHAR] (200) NOT NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (
+CREATE TABLE [QRTZ_SIMPLE_TRIGGERS] (
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
[REPEAT_COUNT] [BIGINT] NOT NULL ,
@@ -135,19 +133,19 @@ CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS
[TIMES_TRIGGERED] [BIGINT] NOT NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (
+CREATE TABLE [QRTZ_BLOB_TRIGGERS] (
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
[BLOB_DATA] [IMAGE] NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] (
+CREATE TABLE [QRTZ_TRIGGER_LISTENERS] (
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
[TRIGGER_LISTENER] [VARCHAR] (200) NOT NULL
) ON [PRIMARY]
-CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
+CREATE TABLE [QRTZ_TRIGGERS] (
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
[JOB_NAME] [VARCHAR] (200) NOT NULL ,
@@ -166,51 +164,51 @@ CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
[JOB_DATA] [IMAGE] NULL
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_CALENDARS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_CALENDARS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_CALENDARS] PRIMARY KEY CLUSTERED
(
[CALENDAR_NAME]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_CRON_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_CRON_TRIGGERS] PRIMARY KEY CLUSTERED
(
[TRIGGER_NAME],
[TRIGGER_GROUP]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_FIRED_TRIGGERS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_FIRED_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_FIRED_TRIGGERS] PRIMARY KEY CLUSTERED
(
[ENTRY_ID]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_PAUSED_TRIGGER_GRPS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_PAUSED_TRIGGER_GRPS] PRIMARY KEY CLUSTERED
(
[TRIGGER_GROUP]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_SCHEDULER_STATE] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_SCHEDULER_STATE] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_SCHEDULER_STATE] PRIMARY KEY CLUSTERED
(
[INSTANCE_NAME]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_LOCKS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_LOCKS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_LOCKS] PRIMARY KEY CLUSTERED
(
[LOCK_NAME]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_JOB_DETAILS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_JOB_DETAILS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_JOB_DETAILS] PRIMARY KEY CLUSTERED
(
[JOB_NAME],
[JOB_GROUP]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_JOB_LISTENERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_JOB_LISTENERS] PRIMARY KEY CLUSTERED
(
[JOB_NAME],
@@ -218,14 +216,14 @@ ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] W
[JOB_LISTENER]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_SIMPLE_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_SIMPLE_TRIGGERS] PRIMARY KEY CLUSTERED
(
[TRIGGER_NAME],
[TRIGGER_GROUP]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_TRIGGER_LISTENERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_TRIGGER_LISTENERS] PRIMARY KEY CLUSTERED
(
[TRIGGER_NAME],
@@ -233,65 +231,65 @@ ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENER
[TRIGGER_LISTENER]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_TRIGGERS] WITH NOCHECK ADD
+ALTER TABLE [QRTZ_TRIGGERS] WITH NOCHECK ADD
CONSTRAINT [PK_QRTZ_TRIGGERS] PRIMARY KEY CLUSTERED
(
[TRIGGER_NAME],
[TRIGGER_GROUP]
) ON [PRIMARY]
-ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] ADD
+ALTER TABLE [QRTZ_CRON_TRIGGERS] ADD
CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
(
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
+ ) REFERENCES [QRTZ_TRIGGERS] (
[TRIGGER_NAME],
[TRIGGER_GROUP]
) ON DELETE CASCADE
-ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] ADD
+ALTER TABLE [QRTZ_JOB_LISTENERS] ADD
CONSTRAINT [FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS] FOREIGN KEY
(
[JOB_NAME],
[JOB_GROUP]
- ) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
+ ) REFERENCES [QRTZ_JOB_DETAILS] (
[JOB_NAME],
[JOB_GROUP]
) ON DELETE CASCADE
-ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] ADD
+ALTER TABLE [QRTZ_SIMPLE_TRIGGERS] ADD
CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
(
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
+ ) REFERENCES [QRTZ_TRIGGERS] (
[TRIGGER_NAME],
[TRIGGER_GROUP]
) ON DELETE CASCADE
-ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] ADD
+ALTER TABLE [QRTZ_TRIGGER_LISTENERS] ADD
CONSTRAINT [FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS] FOREIGN KEY
(
[TRIGGER_NAME],
[TRIGGER_GROUP]
- ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
+ ) REFERENCES [QRTZ_TRIGGERS] (
[TRIGGER_NAME],
[TRIGGER_GROUP]
) ON DELETE CASCADE
-ALTER TABLE [dbo].[QRTZ_TRIGGERS] ADD
+ALTER TABLE [QRTZ_TRIGGERS] ADD
CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS] FOREIGN KEY
(
[JOB_NAME],
[JOB_GROUP]
- ) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
+ ) REFERENCES [QRTZ_JOB_DETAILS] (
[JOB_NAME],
[JOB_GROUP]
)
-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');
+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');