/****** Object:  Table [dbo].[nb_vevo_rent]    Script Date: 2018. 10. 01. 9:50:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_rent]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_rent]
GO
/****** Object:  Table [dbo].[nb_vevo_renf]    Script Date: 2018. 10. 01. 9:50:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_renf]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_renf]
GO
/****** Object:  Table [dbo].[nb_vevo_renf]    Script Date: 2018. 10. 01. 9:50: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].[nb_vevo_renf]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_renf](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[VEVO] [dbo].[kulcs] NOT NULL,
	[szallcim] [char](4) COLLATE Hungarian_CI_AS NULL,
	[REND_DAT] [dbo].[datum] NOT NULL,
	[SZALL_DAT] [dbo].[datum] NOT NULL,
	[IDOPONT] [varchar](20) COLLATE Hungarian_CI_AS NULL,
	[visszaig_dat] [dbo].[datum] NOT NULL,
	[UZLETKOTO] [dbo].[kulcs] NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NOT NULL,
	[penznem] [dbo].[penznem] NOT NULL,
	[afamentes] [bit] NOT NULL,
	[AKCIOCSOPORT] [dbo].[kulcs] NULL,
	[ARCSOPORT] [dbo].[kulcs] NULL,
	[MEGJEGYZES] [dbo].[megjegyzes] NOT NULL,
	[BIZTIPUS] [int] NOT NULL,
	[ALLAPOT] [char](15) COLLATE Hungarian_CI_AS NOT NULL,
	[KICSODA] [dbo].[kicsoda] NOT NULL,
	[MODOSITVA] [dbo].[datum_ora] NOT NULL,
	[raktar_kod] [dbo].[kulcs] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_rent]    Script Date: 2018. 10. 01. 9:50:12 ******/
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_rent]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_rent](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[TETEL] [dbo].[bizonylat_tetel] NOT NULL,
	[CIKK_SZAM] [dbo].[cikk_szam] NOT NULL,
	[afa_kulcs] [varchar](2) COLLATE Hungarian_CI_AS NOT NULL,
	[MENNY_EGYS] [dbo].[menny_egyseg] NOT NULL,
	[SZORZO] [int] NOT NULL,
	[EDARAB] [dbo].[mennyiseg] NOT NULL,
	[DARAB] [dbo].[mennyiseg] NOT NULL,
	[EGYSEG_AR] [dbo].[egyseg_ar] NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NOT NULL,
	[visszaig_dat] [dbo].[datum] NOT NULL,
	[AKCIO] [char](1) COLLATE Hungarian_CI_AS NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO



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