/****** Object:  Table [dbo].[utnyilv_tavolsag]    Script Date: 11/25/2011 16:14:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[utnyilv_tavolsag]') AND type in (N'U'))
DROP TABLE [dbo].[utnyilv_tavolsag]
GO
/****** Object:  Table [dbo].[utnyilv_utak]    Script Date: 11/25/2011 16:14:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[utnyilv_utak]') AND type in (N'U'))
DROP TABLE [dbo].[utnyilv_utak]
GO
/****** Object:  Table [dbo].[utnyilv_gk]    Script Date: 11/25/2011 16:14:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[utnyilv_gk]') AND type in (N'U'))
DROP TABLE [dbo].[utnyilv_gk]
GO
/****** Object:  Table [dbo].[utnyilv_ua_arak]    Script Date: 11/25/2011 16:14:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[utnyilv_ua_arak]') AND type in (N'U'))
DROP TABLE [dbo].[utnyilv_ua_arak]
GO
/****** Object:  Table [dbo].[utnyilv_ua_arak]    Script Date: 11/25/2011 16:14:20 ******/
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].[utnyilv_ua_arak]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[utnyilv_ua_arak](
	[honap] [char](7) COLLATE Hungarian_CI_AS NOT NULL,
	[benzin] [numeric](6, 0) NOT NULL,
	[diesel] [numeric](6, 0) NOT NULL,
 CONSTRAINT [PK_utnyilv_ua_arak] PRIMARY KEY CLUSTERED 
(
	[honap] 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].[utnyilv_gk]    Script Date: 11/25/2011 16:14:20 ******/
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].[utnyilv_gk]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[utnyilv_gk](
	[rendszam] [char](10) COLLATE Hungarian_CI_AS NOT NULL,
	[uzemanyag_tip] [nchar](1) COLLATE Hungarian_CI_AS NOT NULL,
	[norma] [numeric](5, 1) NOT NULL,
	[tulajdonos] [nchar](40) COLLATE Hungarian_CI_AS NOT NULL,
 CONSTRAINT [PK_utnyilv_gk_1] PRIMARY KEY CLUSTERED 
(
	[rendszam] 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].[utnyilv_utak]    Script Date: 11/25/2011 16:14:20 ******/
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].[utnyilv_utak]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[utnyilv_utak](
	[kulcs] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[rendszam] [varchar](10) COLLATE Hungarian_CI_AS NOT NULL,
	[datum] [varchar](10) COLLATE Hungarian_CI_AS NOT NULL,
	[inev] [varchar](70) COLLATE Hungarian_CI_AS NOT NULL,
	[icim] [varchar](120) COLLATE Hungarian_CI_AS NOT NULL,
	[enev] [varchar](70) COLLATE Hungarian_CI_AS NOT NULL,
	[ecim] [varchar](120) COLLATE Hungarian_CI_AS NOT NULL,
	[tavolsag] [numeric](18, 1) NOT NULL,
 CONSTRAINT [PK_utnyilv_utak] 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].[utnyilv_tavolsag]    Script Date: 11/25/2011 16:14:20 ******/
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].[utnyilv_tavolsag]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[utnyilv_tavolsag](
	[vevo_szall] [nchar](1) COLLATE Hungarian_CI_AS NOT NULL,
	[partner_kod] [dbo].[kulcs] NOT NULL,
	[telep_kod] [char](4) COLLATE Hungarian_CI_AS NOT NULL,
	[tavolsag] [numeric](18, 1) NOT NULL,
 CONSTRAINT [PK_utnyilv_tavolsag] PRIMARY KEY CLUSTERED 
(
	[vevo_szall] ASC,
	[partner_kod] ASC,
	[telep_kod] 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