SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblDokWykaz](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[JK] [smallint] NOT NULL,
	[Grupa] [varchar](20) NOT NULL,
	[Nazwa] [varchar](30) NOT NULL,
	[Lokalizacja] [varchar](10) NULL,
	[Data] [date] NULL,
	[Aktualizacja] [datetime] NOT NULL,
	[Uzytkownik] [nvarchar](20) NOT NULL,
 CONSTRAINT [PK_tblDokWykaz] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tblDokWykaz_Images]    Script Date: 20-12-2022 09:01:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblDokWykaz_Images](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ID_DokWykaz] [int] NOT NULL,
	[Page] [int] NOT NULL,
	[Image] [varbinary](max) NOT NULL,
	[Type] [varchar](4) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tblKlienciDok_Images]    Script Date: 20-12-2022 09:01:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblKlienciDok_Images](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ID_KlienciDok] [int] NOT NULL,
	[Page] [int] NOT NULL,
	[Image] [varbinary](max) NOT NULL,
	[Type] [varchar](4) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tblRejestrP_Images]    Script Date: 20-12-2022 09:01:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblRejestrP_Images](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ID_RejestrP] [int] NOT NULL,
	[Page] [int] NOT NULL,
	[Image] [varbinary](max) NOT NULL,
	[Type] [varchar](4) NOT NULL,
 CONSTRAINT [PK_tblRejestrP_Images] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tblRejestrW_Images]    Script Date: 20-12-2022 09:01:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblRejestrW_Images](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ID_RejestrW] [int] NOT NULL,
	[Page] [int] NOT NULL,
	[Image] [varbinary](max) NOT NULL,
	[Type] [varchar](4) NOT NULL,
 CONSTRAINT [PK_tblRejestrW_Images] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblRejestrP_Images] ADD  CONSTRAINT [DF_tblRejestrP_Images_Type]  DEFAULT ('PNG') FOR [Type]
GO
ALTER TABLE [dbo].[tblRejestrW_Images] ADD  CONSTRAINT [DF_tblRejestrW_Images_Type]  DEFAULT ('PNG') FOR [Type]
GO
ALTER TABLE [dbo].[tblDokWykaz_Images]  WITH CHECK ADD  CONSTRAINT [FK_tblDokWykaz_Images_tblDokWykaz] FOREIGN KEY([ID_DokWykaz])
REFERENCES [dbo].[tblDokWykaz] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[tblDokWykaz_Images] CHECK CONSTRAINT [FK_tblDokWykaz_Images_tblDokWykaz]
GO