/****** Object:  ForeignKey [FK_anyagszukseglet_cikkek]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] DROP CONSTRAINT [FK_anyagszukseglet_cikkek]
GO
/****** Object:  ForeignKey [FK_anyagszukseglet_cikkek1]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_cikkek1]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] DROP CONSTRAINT [FK_anyagszukseglet_cikkek1]
GO
/****** Object:  ForeignKey [FK_anyagszukseglet_raktarak]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_raktarak]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] DROP CONSTRAINT [FK_anyagszukseglet_raktarak]
GO
/****** Object:  ForeignKey [FK_diszpo_belepes]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] DROP CONSTRAINT [FK_diszpo_belepes]
GO
/****** Object:  ForeignKey [FK_diszpo_cikkek]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] DROP CONSTRAINT [FK_diszpo_cikkek]
GO
/****** Object:  ForeignKey [FK_diszpo_raktarak]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_raktarak]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] DROP CONSTRAINT [FK_diszpo_raktarak]
GO
/****** Object:  ForeignKey [FK_diszpoauditlog_belepes]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpoauditlog_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]'))
ALTER TABLE [dbo].[diszpoauditlog] DROP CONSTRAINT [FK_diszpoauditlog_belepes]
GO
/****** Object:  ForeignKey [FK_diszpoauditlog_diszpoauditlog]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpoauditlog_diszpoauditlog]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]'))
ALTER TABLE [dbo].[diszpoauditlog] DROP CONSTRAINT [FK_diszpoauditlog_diszpoauditlog]
GO
/****** Object:  ForeignKey [FK_keszre1_belepes]    Script Date: 06/11/2012 16:07:11 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre1_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre1]'))
ALTER TABLE [dbo].[keszre1] DROP CONSTRAINT [FK_keszre1_belepes]
GO
/****** Object:  ForeignKey [FK_keszre1_diszpo]    Script Date: 06/11/2012 16:07:11 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre1_diszpo]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre1]'))
ALTER TABLE [dbo].[keszre1] DROP CONSTRAINT [FK_keszre1_diszpo]
GO
/****** Object:  ForeignKey [FK_keszre2_cikkek]    Script Date: 06/11/2012 16:07:11 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre2_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre2]'))
ALTER TABLE [dbo].[keszre2] DROP CONSTRAINT [FK_keszre2_cikkek]
GO
/****** Object:  ForeignKey [FK_keszre2_keszre1]    Script Date: 06/11/2012 16:07:11 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre2_keszre1]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre2]'))
ALTER TABLE [dbo].[keszre2] DROP CONSTRAINT [FK_keszre2_keszre1]
GO
/****** Object:  Table [dbo].[diszpoauditlog]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpoauditlog_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]'))
ALTER TABLE [dbo].[diszpoauditlog] DROP CONSTRAINT [FK_diszpoauditlog_belepes]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpoauditlog_diszpoauditlog]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]'))
ALTER TABLE [dbo].[diszpoauditlog] DROP CONSTRAINT [FK_diszpoauditlog_diszpoauditlog]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]') AND type in (N'U'))
DROP TABLE [dbo].[diszpoauditlog]
GO
/****** Object:  Table [dbo].[keszre2]    Script Date: 06/11/2012 16:07:11 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre2_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre2]'))
ALTER TABLE [dbo].[keszre2] DROP CONSTRAINT [FK_keszre2_cikkek]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre2_keszre1]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre2]'))
ALTER TABLE [dbo].[keszre2] DROP CONSTRAINT [FK_keszre2_keszre1]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[keszre2]') AND type in (N'U'))
DROP TABLE [dbo].[keszre2]
GO
/****** Object:  Table [dbo].[keszre1]    Script Date: 06/11/2012 16:07:11 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre1_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre1]'))
ALTER TABLE [dbo].[keszre1] DROP CONSTRAINT [FK_keszre1_belepes]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre1_diszpo]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre1]'))
ALTER TABLE [dbo].[keszre1] DROP CONSTRAINT [FK_keszre1_diszpo]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[keszre1]') AND type in (N'U'))
DROP TABLE [dbo].[keszre1]
GO
/****** Object:  Table [dbo].[anyagszukseglet]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] DROP CONSTRAINT [FK_anyagszukseglet_cikkek]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_cikkek1]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] DROP CONSTRAINT [FK_anyagszukseglet_cikkek1]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_raktarak]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] DROP CONSTRAINT [FK_anyagszukseglet_raktarak]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]') AND type in (N'U'))
DROP TABLE [dbo].[anyagszukseglet]
GO
/****** Object:  Table [dbo].[diszpo]    Script Date: 06/11/2012 16:07:10 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] DROP CONSTRAINT [FK_diszpo_belepes]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] DROP CONSTRAINT [FK_diszpo_cikkek]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_raktarak]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] DROP CONSTRAINT [FK_diszpo_raktarak]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[diszpo]') AND type in (N'U'))
DROP TABLE [dbo].[diszpo]
GO
/****** Object:  Table [dbo].[diszpo]    Script Date: 06/11/2012 16:07:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[diszpo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[diszpo](
	[kulcs] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[prioritas] [bigint] NOT NULL,
	[raktar_kod] [dbo].[kulcs] NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[edarab] [numeric](18, 4) NOT NULL,
	[darab] [numeric](18, 4) NOT NULL,
	[hova] [char](1) COLLATE Hungarian_CI_AS NOT NULL,
	[megjegyzes] [dbo].[megjegyzes] NOT NULL,
	[rogzitette] [dbo].[kicsoda] NOT NULL,
	[rogzites] [dbo].[datum_ora] NOT NULL,
	[keszrejelentette] [dbo].[kicsoda] NOT NULL,
	[keszrejelentes] [dbo].[datum_ora] NOT NULL,
	[visszaigazolas] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_diszpo] 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]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[diszpo]') AND name = N'IX_diszpo')
CREATE NONCLUSTERED INDEX [IX_diszpo] ON [dbo].[diszpo] 
(
	[prioritas] 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]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[diszpo]') AND name = N'IX_diszpo_1')
CREATE NONCLUSTERED INDEX [IX_diszpo_1] ON [dbo].[diszpo] 
(
	[raktar_kod] 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]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[diszpo]') AND name = N'IX_diszpo_2')
CREATE NONCLUSTERED INDEX [IX_diszpo_2] ON [dbo].[diszpo] 
(
	[cikk_szam] 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]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[diszpo]') AND name = N'IX_diszpo_3')
CREATE NONCLUSTERED INDEX [IX_diszpo_3] ON [dbo].[diszpo] 
(
	[darab] 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]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[diszpo]') AND name = N'IX_diszpo_4')
CREATE NONCLUSTERED INDEX [IX_diszpo_4] ON [dbo].[diszpo] 
(
	[keszrejelentette] 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]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[diszpo]') AND name = N'IX_diszpo_5')
CREATE NONCLUSTERED INDEX [IX_diszpo_5] ON [dbo].[diszpo] 
(
	[rogzitette] 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]
GO
/****** Object:  Table [dbo].[anyagszukseglet]    Script Date: 06/11/2012 16:07:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[anyagszukseglet](
	[raktar_kod] [dbo].[kulcs] NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[acikk_szam] [dbo].[cikk_szam] NOT NULL,
	[darab] [numeric](18, 4) NOT NULL,
 CONSTRAINT [PK_anyagszukseglet] PRIMARY KEY CLUSTERED 
(
	[raktar_kod] ASC,
	[cikk_szam] ASC,
	[acikk_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]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]') AND name = N'IX_anyagszukseglet')
CREATE NONCLUSTERED INDEX [IX_anyagszukseglet] ON [dbo].[anyagszukseglet] 
(
	[raktar_kod] 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]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]') AND name = N'IX_anyagszukseglet_1')
CREATE NONCLUSTERED INDEX [IX_anyagszukseglet_1] ON [dbo].[anyagszukseglet] 
(
	[cikk_szam] 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]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]') AND name = N'IX_anyagszukseglet_2')
CREATE NONCLUSTERED INDEX [IX_anyagszukseglet_2] ON [dbo].[anyagszukseglet] 
(
	[acikk_szam] 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]
GO
/****** Object:  Table [dbo].[keszre1]    Script Date: 06/11/2012 16:07:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[keszre1]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[keszre1](
	[kulcs] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[diszpo] [dbo].[kulcs] NOT NULL,
	[darab] [numeric](18, 4) NOT NULL,
	[kicsoda] [dbo].[kicsoda] NOT NULL,
	[modido] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_keszre1] 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]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[keszre2]    Script Date: 06/11/2012 16:07:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[keszre2]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[keszre2](
	[kulcs] [dbo].[kulcs] NOT NULL,
	[acikk_szam] [dbo].[cikk_szam] NOT NULL,
	[darab] [numeric](18, 4) NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[diszpoauditlog]    Script Date: 06/11/2012 16:07:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[diszpoauditlog](
	[kicsoda] [dbo].[kicsoda] NOT NULL,
	[idopont] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_diszpoauditlog] PRIMARY KEY CLUSTERED 
(
	[kicsoda] ASC,
	[idopont] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  ForeignKey [FK_anyagszukseglet_cikkek]    Script Date: 06/11/2012 16:07:10 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet]  WITH CHECK ADD  CONSTRAINT [FK_anyagszukseglet_cikkek] FOREIGN KEY([cikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] CHECK CONSTRAINT [FK_anyagszukseglet_cikkek]
GO
/****** Object:  ForeignKey [FK_anyagszukseglet_cikkek1]    Script Date: 06/11/2012 16:07:10 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_cikkek1]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet]  WITH CHECK ADD  CONSTRAINT [FK_anyagszukseglet_cikkek1] FOREIGN KEY([acikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_cikkek1]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] CHECK CONSTRAINT [FK_anyagszukseglet_cikkek1]
GO
/****** Object:  ForeignKey [FK_anyagszukseglet_raktarak]    Script Date: 06/11/2012 16:07:10 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_raktarak]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet]  WITH CHECK ADD  CONSTRAINT [FK_anyagszukseglet_raktarak] FOREIGN KEY([raktar_kod])
REFERENCES [dbo].[raktarak] ([kod])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_anyagszukseglet_raktarak]') AND parent_object_id = OBJECT_ID(N'[dbo].[anyagszukseglet]'))
ALTER TABLE [dbo].[anyagszukseglet] CHECK CONSTRAINT [FK_anyagszukseglet_raktarak]
GO
/****** Object:  ForeignKey [FK_diszpo_belepes]    Script Date: 06/11/2012 16:07:10 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo]  WITH CHECK ADD  CONSTRAINT [FK_diszpo_belepes] FOREIGN KEY([rogzitette])
REFERENCES [dbo].[belepes] ([ROVIDNEV])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] CHECK CONSTRAINT [FK_diszpo_belepes]
GO
/****** Object:  ForeignKey [FK_diszpo_cikkek]    Script Date: 06/11/2012 16:07:10 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo]  WITH CHECK ADD  CONSTRAINT [FK_diszpo_cikkek] FOREIGN KEY([cikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] CHECK CONSTRAINT [FK_diszpo_cikkek]
GO
/****** Object:  ForeignKey [FK_diszpo_raktarak]    Script Date: 06/11/2012 16:07:10 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_raktarak]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo]  WITH CHECK ADD  CONSTRAINT [FK_diszpo_raktarak] FOREIGN KEY([raktar_kod])
REFERENCES [dbo].[raktarak] ([kod])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpo_raktarak]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpo]'))
ALTER TABLE [dbo].[diszpo] CHECK CONSTRAINT [FK_diszpo_raktarak]
GO
/****** Object:  ForeignKey [FK_diszpoauditlog_belepes]    Script Date: 06/11/2012 16:07:10 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpoauditlog_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]'))
ALTER TABLE [dbo].[diszpoauditlog]  WITH CHECK ADD  CONSTRAINT [FK_diszpoauditlog_belepes] FOREIGN KEY([kicsoda])
REFERENCES [dbo].[belepes] ([ROVIDNEV])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpoauditlog_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]'))
ALTER TABLE [dbo].[diszpoauditlog] CHECK CONSTRAINT [FK_diszpoauditlog_belepes]
GO
/****** Object:  ForeignKey [FK_diszpoauditlog_diszpoauditlog]    Script Date: 06/11/2012 16:07:10 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpoauditlog_diszpoauditlog]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]'))
ALTER TABLE [dbo].[diszpoauditlog]  WITH CHECK ADD  CONSTRAINT [FK_diszpoauditlog_diszpoauditlog] FOREIGN KEY([kicsoda], [idopont])
REFERENCES [dbo].[diszpoauditlog] ([kicsoda], [idopont])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_diszpoauditlog_diszpoauditlog]') AND parent_object_id = OBJECT_ID(N'[dbo].[diszpoauditlog]'))
ALTER TABLE [dbo].[diszpoauditlog] CHECK CONSTRAINT [FK_diszpoauditlog_diszpoauditlog]
GO
/****** Object:  ForeignKey [FK_keszre1_belepes]    Script Date: 06/11/2012 16:07:11 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre1_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre1]'))
ALTER TABLE [dbo].[keszre1]  WITH CHECK ADD  CONSTRAINT [FK_keszre1_belepes] FOREIGN KEY([kicsoda])
REFERENCES [dbo].[belepes] ([ROVIDNEV])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre1_belepes]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre1]'))
ALTER TABLE [dbo].[keszre1] CHECK CONSTRAINT [FK_keszre1_belepes]
GO
/****** Object:  ForeignKey [FK_keszre1_diszpo]    Script Date: 06/11/2012 16:07:11 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre1_diszpo]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre1]'))
ALTER TABLE [dbo].[keszre1]  WITH CHECK ADD  CONSTRAINT [FK_keszre1_diszpo] FOREIGN KEY([diszpo])
REFERENCES [dbo].[diszpo] ([kulcs])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre1_diszpo]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre1]'))
ALTER TABLE [dbo].[keszre1] CHECK CONSTRAINT [FK_keszre1_diszpo]
GO
/****** Object:  ForeignKey [FK_keszre2_cikkek]    Script Date: 06/11/2012 16:07:11 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre2_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre2]'))
ALTER TABLE [dbo].[keszre2]  WITH CHECK ADD  CONSTRAINT [FK_keszre2_cikkek] FOREIGN KEY([acikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre2_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre2]'))
ALTER TABLE [dbo].[keszre2] CHECK CONSTRAINT [FK_keszre2_cikkek]
GO
/****** Object:  ForeignKey [FK_keszre2_keszre1]    Script Date: 06/11/2012 16:07:11 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre2_keszre1]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre2]'))
ALTER TABLE [dbo].[keszre2]  WITH CHECK ADD  CONSTRAINT [FK_keszre2_keszre1] FOREIGN KEY([kulcs])
REFERENCES [dbo].[keszre1] ([kulcs])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_keszre2_keszre1]') AND parent_object_id = OBJECT_ID(N'[dbo].[keszre2]'))
ALTER TABLE [dbo].[keszre2] CHECK CONSTRAINT [FK_keszre2_keszre1]
GO