/****** Object:  Table [dbo].[hcimke_sablon]    Script Date: 2017. 06. 21. 12:58:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[hcimke_sablon](
	[kulcs] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[nev] [dbo].[nev] NULL,
	[sablon] [varchar](512) NULL,
 CONSTRAINT [PK_hcimke_sablon] PRIMARY KEY CLUSTERED 
(
	[kulcs] 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

SET ANSI_PADDING OFF
GO



/****** Object:  Table [dbo].[hcimke_csz]    Script Date: 2017. 06. 23. 12:55:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[hcimke_csz](
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[hcimke_sablon] [dbo].[kulcs] NOT NULL,
 CONSTRAINT [PK_hcimke_csz] PRIMARY KEY CLUSTERED 
(
	[cikk_szam] 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

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[hcimke_csz]  WITH CHECK ADD  CONSTRAINT [FK_hcimke_csz_cikkek] FOREIGN KEY([cikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO

ALTER TABLE [dbo].[hcimke_csz] CHECK CONSTRAINT [FK_hcimke_csz_cikkek]
GO

ALTER TABLE [dbo].[hcimke_csz]  WITH CHECK ADD  CONSTRAINT [FK_hcimke_csz_hcimke_sablon] FOREIGN KEY([hcimke_sablon])
REFERENCES [dbo].[hcimke_sablon] ([kulcs])
GO

ALTER TABLE [dbo].[hcimke_csz] CHECK CONSTRAINT [FK_hcimke_csz_hcimke_sablon]
GO



insert into verzio values('upg','Ver. 2.43', dbo.mygetdatetime())
go