/****** Object:  ForeignKey [FK_kont_szabalyf_kont_tip]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyf_kont_tip]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyf]'))
ALTER TABLE [dbo].[kont_szabalyf] DROP CONSTRAINT [FK_kont_szabalyf_kont_tip]
GO
/****** Object:  ForeignKey [FK_kont_szabalyt_kont_szabalyf]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyt_kont_szabalyf]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyt]'))
ALTER TABLE [dbo].[kont_szabalyt] DROP CONSTRAINT [FK_kont_szabalyt_kont_szabalyf]
GO
/****** Object:  ForeignKey [FK_kont_szabalyt_szamlatukor]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyt_szamlatukor]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyt]'))
ALTER TABLE [dbo].[kont_szabalyt] DROP CONSTRAINT [FK_kont_szabalyt_szamlatukor]
GO
/****** Object:  ForeignKey [FK_kontirf_kont_tip]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirf_kont_tip]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirf]'))
ALTER TABLE [dbo].[kontirf] DROP CONSTRAINT [FK_kontirf_kont_tip]
GO
/****** Object:  ForeignKey [FK_kontirt_kontirf]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirt_kontirf]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirt]'))
ALTER TABLE [dbo].[kontirt] DROP CONSTRAINT [FK_kontirt_kontirf]
GO
/****** Object:  ForeignKey [FK_kontirt_szamlatukor]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirt_szamlatukor]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirt]'))
ALTER TABLE [dbo].[kontirt] DROP CONSTRAINT [FK_kontirt_szamlatukor]
GO
/****** Object:  Table [dbo].[szamlatukor]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[szamlatukor]') AND type in (N'U'))
DROP TABLE [dbo].[szamlatukor]
GO
/****** Object:  Table [dbo].[kont_szabalyt]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[kont_szabalyt]') AND type in (N'U'))
DROP TABLE [dbo].[kont_szabalyt]
GO
/****** Object:  Table [dbo].[kont_szabalyf]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[kont_szabalyf]') AND type in (N'U'))
DROP TABLE [dbo].[kont_szabalyf]
GO
/****** Object:  Table [dbo].[kont_tip]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[kont_tip]') AND type in (N'U'))
DROP TABLE [dbo].[kont_tip]
GO
/****** Object:  Table [dbo].[kontirf]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[kontirf]') AND type in (N'U'))
DROP TABLE [dbo].[kontirf]
GO
/****** Object:  Table [dbo].[kontirt]    Script Date: 08/24/2010 13:31:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[kontirt]') AND type in (N'U'))
DROP TABLE [dbo].[kontirt]
GO
/****** Object:  Table [dbo].[kontirt]    Script Date: 08/24/2010 13:31:13 ******/
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].[kontirt]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[kontirt](
	[azon] [dbo].[bizonylat_szam] NOT NULL,
	[t_k] [char](1) COLLATE Hungarian_CI_AS NULL,
	[fk_szam] [varchar](18) COLLATE Hungarian_CI_AS NOT NULL,
	[ellen_fk] [varchar](50) COLLATE Hungarian_CI_AS NULL,
	[ertek] [dbo].[egyseg_ar] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[kontirf]    Script Date: 08/24/2010 13:31:13 ******/
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].[kontirf]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[kontirf](
	[azon] [dbo].[bizonylat_szam] NOT NULL,
	[kont_tip] [int] NOT NULL,
	[kont_datum] [dbo].[datum] NOT NULL,
	[bizszam] [dbo].[bizonylat_szam] NOT NULL,
	[hivszam] [varchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[szoveg] [dbo].[megjegyzes] NOT NULL,
	[kontirozta] [dbo].[kicsoda] NOT NULL,
	[kontirozva] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_kontirf] PRIMARY KEY CLUSTERED 
(
	[azon] 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].[kont_tip]    Script Date: 08/24/2010 13:31:13 ******/
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].[kont_tip]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[kont_tip](
	[kont_tip] [dbo].[kulcs] NOT NULL,
	[tip_nev] [varchar](20) COLLATE Hungarian_CI_AS NOT NULL,
 CONSTRAINT [PK_kont_tip] PRIMARY KEY CLUSTERED 
(
	[kont_tip] 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].[kont_szabalyf]    Script Date: 08/24/2010 13:31:13 ******/
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].[kont_szabalyf]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[kont_szabalyf](
	[kont_azon] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[kont_anev] [dbo].[nev] NOT NULL,
	[kont_tip] [dbo].[kulcs] NOT NULL,
	[felt_tablo] [varchar](500) COLLATE Hungarian_CI_AS NULL,
	[felt_ertek] [varchar](500) COLLATE Hungarian_CI_AS NULL,
	[felt_szures] [varchar](500) COLLATE Hungarian_CI_AS NULL,
	[szoveg] [dbo].[megjegyzes] NULL,
 CONSTRAINT [PK_kont_szabalyf] PRIMARY KEY CLUSTERED 
(
	[kont_azon] 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].[kont_szabalyt]    Script Date: 08/24/2010 13:31:13 ******/
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].[kont_szabalyt]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[kont_szabalyt](
	[kont_azon] [dbo].[kulcs] NOT NULL,
	[t_k] [char](1) COLLATE Hungarian_CI_AS NULL,
	[fk_szam] [varchar](18) COLLATE Hungarian_CI_AS NULL,
	[felt_tablo] [nvarchar](500) COLLATE Hungarian_CI_AS NULL,
	[felt_ertek] [nvarchar](500) COLLATE Hungarian_CI_AS NULL,
	[felt_szures] [nvarchar](500) COLLATE Hungarian_CI_AS NULL,
	[megjegyzes] [dbo].[megjegyzes] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[szamlatukor]    Script Date: 08/24/2010 13:31:13 ******/
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].[szamlatukor]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[szamlatukor](
	[szamlaszam] [varchar](18) COLLATE Hungarian_CI_AS NOT NULL,
	[szamlanev] [dbo].[nev] NOT NULL,
	[konyvelheto] [char](1) COLLATE Hungarian_CI_AS NOT NULL,
 CONSTRAINT [PK_szamlatukor] PRIMARY KEY CLUSTERED 
(
	[szamlaszam] 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_kont_szabalyf_kont_tip]    Script Date: 08/24/2010 13:31:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyf_kont_tip]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyf]'))
ALTER TABLE [dbo].[kont_szabalyf]  WITH CHECK ADD  CONSTRAINT [FK_kont_szabalyf_kont_tip] FOREIGN KEY([kont_tip])
REFERENCES [dbo].[kont_tip] ([kont_tip])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyf_kont_tip]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyf]'))
ALTER TABLE [dbo].[kont_szabalyf] CHECK CONSTRAINT [FK_kont_szabalyf_kont_tip]
GO
/****** Object:  ForeignKey [FK_kont_szabalyt_kont_szabalyf]    Script Date: 08/24/2010 13:31:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyt_kont_szabalyf]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyt]'))
ALTER TABLE [dbo].[kont_szabalyt]  WITH CHECK ADD  CONSTRAINT [FK_kont_szabalyt_kont_szabalyf] FOREIGN KEY([kont_azon])
REFERENCES [dbo].[kont_szabalyf] ([kont_azon])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyt_kont_szabalyf]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyt]'))
ALTER TABLE [dbo].[kont_szabalyt] CHECK CONSTRAINT [FK_kont_szabalyt_kont_szabalyf]
GO
/****** Object:  ForeignKey [FK_kont_szabalyt_szamlatukor]    Script Date: 08/24/2010 13:31:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyt_szamlatukor]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyt]'))
ALTER TABLE [dbo].[kont_szabalyt]  WITH CHECK ADD  CONSTRAINT [FK_kont_szabalyt_szamlatukor] FOREIGN KEY([fk_szam])
REFERENCES [dbo].[szamlatukor] ([szamlaszam])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kont_szabalyt_szamlatukor]') AND parent_object_id = OBJECT_ID(N'[dbo].[kont_szabalyt]'))
ALTER TABLE [dbo].[kont_szabalyt] CHECK CONSTRAINT [FK_kont_szabalyt_szamlatukor]
GO
/****** Object:  ForeignKey [FK_kontirf_kont_tip]    Script Date: 08/24/2010 13:31:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirf_kont_tip]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirf]'))
ALTER TABLE [dbo].[kontirf]  WITH CHECK ADD  CONSTRAINT [FK_kontirf_kont_tip] FOREIGN KEY([kont_tip])
REFERENCES [dbo].[kont_tip] ([kont_tip])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirf_kont_tip]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirf]'))
ALTER TABLE [dbo].[kontirf] CHECK CONSTRAINT [FK_kontirf_kont_tip]
GO
/****** Object:  ForeignKey [FK_kontirt_kontirf]    Script Date: 08/24/2010 13:31:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirt_kontirf]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirt]'))
ALTER TABLE [dbo].[kontirt]  WITH CHECK ADD  CONSTRAINT [FK_kontirt_kontirf] FOREIGN KEY([azon])
REFERENCES [dbo].[kontirf] ([azon])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirt_kontirf]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirt]'))
ALTER TABLE [dbo].[kontirt] CHECK CONSTRAINT [FK_kontirt_kontirf]
GO
/****** Object:  ForeignKey [FK_kontirt_szamlatukor]    Script Date: 08/24/2010 13:31:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirt_szamlatukor]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirt]'))
ALTER TABLE [dbo].[kontirt]  WITH CHECK ADD  CONSTRAINT [FK_kontirt_szamlatukor] FOREIGN KEY([fk_szam])
REFERENCES [dbo].[szamlatukor] ([szamlaszam])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_kontirt_szamlatukor]') AND parent_object_id = OBJECT_ID(N'[dbo].[kontirt]'))
ALTER TABLE [dbo].[kontirt] CHECK CONSTRAINT [FK_kontirt_szamlatukor]
GO