/****** Object:  Table [dbo].[nb_vevok]    Script Date: 04/14/2011 15:23:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevok]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevok]
GO
/****** Object:  Table [dbo].[nb_vevo_kapcsolat]    Script Date: 04/14/2011 15:23:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_kapcsolat]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_kapcsolat]
GO
/****** Object:  Table [dbo].[nb_vevo_bank]    Script Date: 04/14/2011 15:23:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_bank]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_bank]
GO
/****** Object:  Table [dbo].[nb_vevo_tel]    Script Date: 04/14/2011 15:23:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_tel]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_tel]
GO
/****** Object:  Table [dbo].[nb_parameterek]    Script Date: 04/14/2011 15:23:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_parameterek]') AND type in (N'U'))
DROP TABLE [dbo].[nb_parameterek]
GO
/****** Object:  Table [dbo].[nb_parameterek]    Script Date: 04/14/2011 15:23:41 ******/
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].[nb_parameterek]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_parameterek](
	[UZLETKOTO] [varchar](20) COLLATE Hungarian_CI_AS NOT NULL,
	[AZONOSITO] [varchar](30) COLLATE Hungarian_CI_AS NOT NULL,
	[ERTEK] [varchar](50) COLLATE Hungarian_CI_AS NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_tel]    Script Date: 04/14/2011 15:23:41 ******/
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].[nb_vevo_tel]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_tel](
	[VEVO_KOD] [int] NOT NULL,
	[TELEP_KOD] [char](4) COLLATE Hungarian_CI_AS NOT NULL,
	[TELEP_NEV] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[VAROS] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[IRANYITO] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[CIM] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[KAPCSOLAT] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[TELEFON] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[EMAIL] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[KARTYA] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[LIMIT] [real] NULL,
	[jovedeki] [nvarchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[TOROLT] [char](1) COLLATE Hungarian_CI_AS NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_bank]    Script Date: 04/14/2011 15:23:41 ******/
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].[nb_vevo_bank]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_bank](
	[vevo_kod] [dbo].[kulcs] NOT NULL,
	[bank] [dbo].[nev] NOT NULL,
	[torolt] [char](1) COLLATE Hungarian_CI_AS NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_kapcsolat]    Script Date: 04/14/2011 15:23:41 ******/
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].[nb_vevo_kapcsolat]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_kapcsolat](
	[VEVO_KOD] [dbo].[kulcs] NOT NULL,
	[KAPCS_KOD] [dbo].[kulcs] NOT NULL,
	[KAPCSOLAT] [dbo].[nev] NOT NULL,
	[TELEFON] [dbo].[nev] NOT NULL,
	[EMAIL] [dbo].[nev] NOT NULL,
	[BEOSZTAS] [dbo].[nev] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevok]    Script Date: 04/14/2011 15:23:42 ******/
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].[nb_vevok]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevok](
	[VEVO_KOD] [dbo].[kulcs] NOT NULL,
	[VEVO_NEV] [dbo].[nev] NOT NULL,
	[IRANYITO] [dbo].[nev] NOT NULL,
	[VAROS] [dbo].[nev] NOT NULL,
	[orszag] [char](3) COLLATE Hungarian_CI_AS NOT NULL,
	[CIM] [dbo].[nev] NOT NULL,
	[TELEFON] [dbo].[nev] NOT NULL,
	[FAX] [dbo].[nev] NOT NULL,
	[KAPCSOLAT] [dbo].[nev] NOT NULL,
	[EMAIL] [dbo].[nev] NOT NULL,
	[ADOSZAM] [dbo].[nev] NOT NULL,
	[eu_adoszam] [dbo].[nev] NULL,
	[BANK] [dbo].[nev] NOT NULL,
	[JOVEDEKI] [dbo].[nev] NOT NULL,
	[vevo_arcsoport] [dbo].[kulcs] NOT NULL,
	[vevo_akc_csoport] [dbo].[kulcs] NULL,
	[KEDVEZMENY] [dbo].[kedvezmeny] NOT NULL,
	[FIZMOD] [char](1) COLLATE Hungarian_CI_AS NOT NULL,
	[FIZHAT] [int] NOT NULL,
	[vevo_csoport] [dbo].[kulcs] NOT NULL,
	[vevo_lanc] [dbo].[kulcs] NOT NULL,
	[vevo_cegjelleg] [dbo].[kulcs] NOT NULL,
	[vevo_terulet] [dbo].[kulcs] NOT NULL,
	[vevo_cszcsoport] [dbo].[kulcs] NOT NULL,
	[Viszontelado] [char](1) COLLATE Hungarian_CI_AS NULL,
	[sajat_bolt] [char](1) COLLATE Hungarian_CI_AS NULL,
	[KICSODA] [dbo].[kicsoda] NOT NULL,
	[MODOSITVA] [dbo].[datum_ora] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO