<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <mapping resource="quartz.sqlserver.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <database-object>
        <create>
            IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[PINS_SCHEDULER_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
            BEGIN
            CREATE TABLE [dbo].[PINS_SCHEDULER_CALENDARS] (
            [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
            [CALENDAR_NAME] [VARCHAR] (200)  NOT NULL ,
            [CALENDAR] [IMAGE] NOT NULL
            ) ON [PRIMARY];

            ALTER TABLE [dbo].[PINS_SCHEDULER_CALENDARS] WITH NOCHECK ADD
            CONSTRAINT [PK_PINS_SCHEDULER_CALENDARS] PRIMARY KEY  CLUSTERED
            (
            [SCHED_NAME],
            [CALENDAR_NAME]
            )  ON [PRIMARY];
        END
    </create>
    <drop>
        <!--IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[PINS_SCHEDULER_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)-->
        <!--BEGIN-->
            <!--DROP TABLE [dbo].[PINS_SCHEDULER_CALENDARS];-->
        <!--END-->
        SELECT 1
    </drop>
    <dialect-scope name="org.hibernate.dialect.SQLServer2012Dialect" />
</database-object>


</hibernate-mapping>

environments:
    development:
        dataSource:
            dbCreate: update
             dialect: org.hibernate.dialect.SQLServer2012Dialect
             driverClassName:
  com.microsoft.sqlserver.jdbc.SQLServerDriver
        url: 'jdbc:sqlserver://localhost;characterEncoding=utf-8;databaseName=*****'
        username: ****
        password: ****