IF(db_id('TPMediaDB') IS NULL)
CREATE DATABASE TPMediaDB
GO

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