<?xml version="1.0" encoding="utf-8" ?>
<before>
  <sql date="2019-01-11">
    <dialect name="SQLServer">
    <![CDATA[
        IF NOT EXISTS(SELECT name FROM sys.databases where name = 'TPMediaDB')
          CREATE DATABASE TPMediaDB
     ]]>
    </dialect>
  </sql>
  <sql date="2019-01-12">
    <dialect name="SQLServer">
        <![CDATA[
            IF (OBJECT_ID('[TPMediaDB].[dbo].[FDowody]') IS NULL)
            BEGIN
            CREATE TABLE [TPMediaDB].[dbo].[FDowody](
                [Rok] [smallint] NOT NULL,
                [Miesiac] [smallint] NOT NULL,
                [KodDowodu] [char](5) NOT NULL,
                [NumerDowodu] [int] NOT NULL,
                [DataDowodu] [char](10) NOT NULL,
                [DataWplywu] [char](10) NULL,
                [NumerKs] [int] NULL,
                [DataDziennika] [char](10) NULL,
                [CzasDziennika] [char](8) NULL,
                [Wprowadzil] [char](10) NOT NULL,
                [Zaksiegowal] [char](10) NULL,
                [NumerDziennika] [int] NULL,
                [Tresc] [varchar](150) NULL,
                [ObrotyWN] [float] NULL,
                [ObrotyMA] [float] NULL,
                [RodzajDowodu] [char](1) NULL,
                [NAZ_TAB_ZR] [varchar](20) NULL,
                [IDREC_ZR] [int] NULL,
                [DATA_WPR] [char](10) NOT NULL,
                [CZAS_WPR] [char](8) NOT NULL,
                [USER_WPR] [char](10) NOT NULL,
                [KluczDowodu] [int] IDENTITY(1,1) NOT NULL,
                [IdKursuWalutowego] [int] NULL,
                CONSTRAINT [FDowody00] PRIMARY KEY CLUSTERED
            (
                [KluczDowodu] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
            ) ON [PRIMARY]

            CREATE UNIQUE NONCLUSTERED INDEX [FDowody01] ON [TPMediaDB].[dbo].[FDowody]
            (
                [Rok] ASC,
                [Miesiac] ASC,
                [KodDowodu] ASC,
                [NumerDowodu] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

            CREATE NONCLUSTERED INDEX [FDowody02] ON [TPMediaDB].[dbo].[FDowody]
            (
                [Rok] ASC,
                [Miesiac] ASC,
                [NumerDziennika] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

            CREATE NONCLUSTERED INDEX [IN_FDowody03] ON [TPMediaDB].[dbo].[FDowody]
            (
                [Rok] ASC,
                [Miesiac] ASC,
                [USER_WPR] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
            END
            GO

            IF (OBJECT_ID('[TPMediaDB].[dbo].[FKodyDow]') IS NULL)
            BEGIN
            CREATE TABLE [TPMediaDB].[dbo].[FKodyDow](
                [KodDowodu] [char](5) NOT NULL,
                [Okreslenie] [varchar](255) NULL,
                [Status] [char](1) NULL,
                [Konto] [varchar](40) NULL,
                [Wprow] [char](1) NULL,
                [DATA_WPR] [char](10) NOT NULL,
                [CZAS_WPR] [char](8) NOT NULL,
                [USER_WPR] [char](10) NOT NULL,
                [IDREC] [int] IDENTITY(1,1) NOT NULL,
                [CZYNNY] [char](1) NULL,
                [Opis_JPK] [varchar](255) NULL,
                [PRINT_DEFAULT] [bit] NULL,
                CONSTRAINT [FKodyDow00] PRIMARY KEY CLUSTERED
            (
                [IDREC] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
            ) ON [PRIMARY]
            CREATE UNIQUE NONCLUSTERED INDEX [FKodyDow01] ON [TPMediaDB].[dbo].[FKodyDow]
            (
                [KodDowodu] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
            END
            GO


            IF (OBJECT_ID('[TPMediaDB].[dbo].[FOkresy]') IS NULL)
            BEGIN
            CREATE TABLE [TPMediaDB].[dbo].[FOkresy](
                [Rok] [smallint] NOT NULL,
                [Miesiac] [smallint] NOT NULL,
                [Status] [char](1) NOT NULL,
                [DataOtwarcia] [char](10) NOT NULL,
                [CzasOtwarcia] [char](8) NOT NULL,
                [Otwarl] [char](10) NOT NULL,
                [DataZamkniecia] [char](10) NULL,
                [CzasZamkniecia] [char](8) NULL,
                [Zamknal] [char](10) NULL,
                [IDREC] [int] IDENTITY(1,1) NOT NULL,
                CONSTRAINT [FOkresy00] PRIMARY KEY CLUSTERED
            (
                [IDREC] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
            ) ON [PRIMARY]
            CREATE UNIQUE NONCLUSTERED INDEX [FOkresy01] ON [TPMediaDB].[dbo].[FOkresy]
            (
                [Rok] ASC,
                [Miesiac] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
            END
            GO


            IF (OBJECT_ID('[TPMediaDB].[dbo].[FOperac]') IS NULL)
            BEGIN
            CREATE TABLE [TPMediaDB].[dbo].[FOperac](
                [KluczDowodu] [int] NOT NULL,
                [Lp] [int] NOT NULL,
                [Synt] [smallint] NOT NULL,
                [Konto] [varchar](40) NOT NULL,
                [Wn] [float] NOT NULL,
                [Ma] [float] NOT NULL,
                [Tresc] [varchar](100) NULL,
                [KontoPrzeciwstawne] [smallint] NULL,
                [NumerKs] [int] NULL,
                [IDREC] [int] IDENTITY(1,1) NOT NULL,
                [SYST] [char](1) NULL,
                [ID_SYST] [int] NULL,
                [OBCY_NR_DOK] [varchar](50) NULL,
                [DATA_WPR] [char](10) NULL,
                [CZAS_WPR] [char](8) NULL,
                [USER_WPR] [char](10) NULL,
                [Kontrahent] [int] NULL,
                [Rodzaj] [char](1) NULL,
                [Tytul] [char](1) NULL,
                [Id_Rpk_Connected] [int] NULL,
                [ID_FSymbKomorki] [int] NULL,
                [LiczbaP] [int] NULL,
                CONSTRAINT [FOperac00] PRIMARY KEY CLUSTERED
            (
                [IDREC] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
            ) ON [PRIMARY]
            CREATE NONCLUSTERED INDEX [FOPERAC_ID_SYST] ON [TPMediaDB].[dbo].[FOperac]
            (
                [ID_SYST] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

            CREATE UNIQUE NONCLUSTERED INDEX [FOperac01] ON [TPMediaDB].[dbo].[FOperac]
            (
                [KluczDowodu] ASC,
                [Lp] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


            CREATE NONCLUSTERED INDEX [FOperac02] ON [TPMediaDB].[dbo].[FOperac]
            (
                [Konto] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


            CREATE NONCLUSTERED INDEX [I_FOPERAC01] ON [TPMediaDB].[dbo].[FOperac]
            (
                [ID_SYST] ASC,
                [SYST] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

            ALTER TABLE [TPMediaDB].[dbo].[FKodyDow] ADD  DEFAULT ((0)) FOR [PRINT_DEFAULT]

            ALTER TABLE [TPMediaDB].[dbo].[FDowody]  WITH CHECK ADD  CONSTRAINT [FK_FDowodyFkody] FOREIGN KEY([KodDowodu])
            REFERENCES [TPMediaDB].[dbo].[FKodyDow] ([KodDowodu])

            ALTER TABLE [TPMediaDB].[dbo].[FDowody] CHECK CONSTRAINT [FK_FDowodyFkody]

            ALTER TABLE [TPMediaDB].[dbo].[FDowody]  WITH CHECK ADD  CONSTRAINT [FK_FDowodyFOkresy] FOREIGN KEY([Rok], [Miesiac])
            REFERENCES [TPMediaDB].[dbo].[FOkresy] ([Rok], [Miesiac])

            ALTER TABLE [TPMediaDB].[dbo].[FDowody] CHECK CONSTRAINT [FK_FDowodyFOkresy]

            ALTER TABLE [TPMediaDB].[dbo].[FOperac]  WITH CHECK ADD  CONSTRAINT [FK_FOperacFDowody] FOREIGN KEY([KluczDowodu])
            REFERENCES [TPMediaDB].[dbo].[FDowody] ([KluczDowodu])

            ALTER TABLE [TPMediaDB].[dbo].[FOperac] CHECK CONSTRAINT [FK_FOperacFDowody]


            END
            GO

        ]]>
    </dialect>
  </sql>
</before>