quartz server.sql
--# 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:
--#
--# 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
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE . DROP CONSTRAINT FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE . DROP CONSTRAINT FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE . DROP CONSTRAINT FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE . DROP CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE . DROP CONSTRAINT FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'.') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE .
GO
CREATE TABLE . (
(200)NOT NULL ,
NOT NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL ,
(200)NOT NULL ,
(120)NOT NULL ,
(80)
) ON
GO
CREATE TABLE . (
(95)NOT NULL ,
(200)NOT NULL ,
(200)NOT NULL ,
(1)NOT NULL ,
(200)NOT NULL ,
NOT NULL ,
NOT NULL ,
(16)NOT NULL,
(200)NULL ,
(200)NULL ,
(1)NULL ,
(1)NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL ,
NOT NULL ,
NOT NULL
) ON
GO
CREATE TABLE . (
(40)NOT NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL ,
(200)NOT NULL ,
(250) NULL ,
(250)NOT NULL ,
(1)NOT NULL ,
(1)NOT NULL ,
(1)NOT NULL ,
(1)NOT NULL ,
NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL ,
(200)NOT NULL ,
(200)NOT NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL ,
(200)NOT NULL ,
NOT NULL ,
NOT NULL ,
NOT NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL ,
(200)NOT NULL ,
NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL ,
(200)NOT NULL ,
(200)NOT NULL
) ON
GO
CREATE TABLE . (
(200)NOT NULL ,
(200)NOT NULL ,
(200)NOT NULL ,
(200)NOT NULL ,
(1)NOT NULL ,
(250) NULL ,
NULL ,
NULL ,
NULL ,
(16)NOT NULL ,
(8)NOT NULL ,
NOT NULL ,
NULL ,
(200)NULL ,
NULL ,
NULL
) ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
,
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
,
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
,
,
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
,
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
,
,
)ON
GO
ALTER TABLE . WITH NOCHECK ADD
CONSTRAINT PRIMARY KEYCLUSTERED
(
,
)ON
GO
ALTER TABLE . ADD
CONSTRAINT FOREIGN KEY
(
,
) REFERENCES . (
,
) ON DELETE CASCADE
GO
ALTER TABLE . ADD
CONSTRAINT FOREIGN KEY
(
,
) REFERENCES . (
,
) ON DELETE CASCADE
GO
ALTER TABLE . ADD
CONSTRAINT FOREIGN KEY
(
,
) REFERENCES . (
,
) ON DELETE CASCADE
GO
ALTER TABLE . ADD
CONSTRAINT FOREIGN KEY
(
,
) REFERENCES . (
,
) ON DELETE CASCADE
GO
ALTER TABLE . ADD
CONSTRAINT FOREIGN KEY
(
,
) REFERENCES . (
,
)
GO
INSERT INTO . VALUES('TRIGGER_ACCESS');
INSERT INTO . VALUES('JOB_ACCESS');
INSERT INTO . VALUES('CALENDAR_ACCESS');
INSERT INTO . VALUES('STATE_ACCESS');
INSERT INTO . VALUES('MISFIRE_ACCESS');
页:
[1]