/****** Object:  Table [dbo].[vevok_zaradek]    Script Date: 2014.06.25. 9:59:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[vevok_zaradek](
	[vevo_kod] [dbo].[kulcs] NOT NULL,
	[zaradek] [char](1) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[VEVO_REND_TERM_AR_2014]    Script Date: 2014.06.25. 10:24:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[VEVO_REND_TERM_AR_2014](
	[CIKK_SZAM] [nvarchar](14) NULL,
	[CIKK_NEV] [nvarchar](45) NULL,
	[MENNY_EGYS] [nvarchar](8) NULL,
	[VTSZ] [nvarchar](14) NULL,
	[AFA_KULCS] [nvarchar](2) NULL,
	[CIKKCSOP2] [nvarchar](18) NULL,
	[ZSUGOR_DB] [float] NULL,
	[DB_KART] [float] NULL,
	[KART_SOR] [float] NULL,
	[KART_RAKL] [float] NULL,
	[TGON] [nvarchar](14) NULL,
	[NTGON] [nvarchar](14) NULL,
	[TGONSZOR] [float] NULL,
	[NTGONSZOR] [float] NULL,
	[BESZERZ_AR] [float] NULL,
	[BESZERZ_BR_AR] [float] NULL,
	[EGYSEG_AR] [float] NULL,
	[BRUTTO_AR] [float] NULL,
	[AKCIO] [nvarchar](1) NULL,
	[AKCIOS_AR] [float] NULL,
	[FELT_DB] [float] NULL,
	[AJAN_CSZ] [nvarchar](14) NULL,
	[KESZLET] [float] NULL,
	[NORM_ME] [nvarchar](8) NULL,
	[NORM_SZORZ] [float] NULL,
	[SZALLITO] [dbo].[kulcs] NULL,
	[GONGYOLEG] [char](1) NULL,
	[gyarto] [dbo].[kulcs] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[bolt_bevetjog]    Script Date: 2014.06.25. 10:27:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[bolt_bevetjog](
	[kod] [varchar](10) NOT NULL,
	[nev] [varchar](30) NOT NULL,
	[koltseghely] [varchar](10) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[bolt_kivetjog]    Script Date: 2014.06.25. 10:27:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[bolt_kivetjog](
	[kod] [varchar](10) NOT NULL,
	[nev] [varchar](30) NOT NULL,
	[koltseghely] [varchar](10) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[VEVO_REND_TERM]    Script Date: 2014.06.25. 10:28:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[VEVO_REND_TERM](
	[TERM_KOD] [dbo].[kulcs] NOT NULL,
	[VEVO_KOD] [dbo].[kulcs] NOT NULL,
	[SZALL_CIM] [char](4) NOT NULL,
	[SZCIM_NEV] [char](50) NOT NULL,
	[EMAILCIM] [char](40) NOT NULL,
	[EMAILJELSZO] [char](20) NOT NULL,
	[SZLA_KIV] [char](1) NOT NULL,
	[KIVETKOD] [int] NULL,
	[UTVER] [char](10) NOT NULL,
	[BOLT_PRG] [char](1) NOT NULL,
	[odbc_kapcsolat] [char](20) NOT NULL,
	[emailuser] [char](30) NOT NULL,
 CONSTRAINT [PK_VEVO_REND_TERM] PRIMARY KEY CLUSTERED 
(
	[TERM_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]

GO

SET ANSI_PADDING OFF
GO

/****** Object:  Table [dbo].[BOLT]    Script Date: 2014.06.25. 10:30:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BOLT](
	[boltnev] [char](30) NOT NULL,
	[kod] [int] NOT NULL,
	[kapcsolat] [char](52) NOT NULL,
	[megszunt] [char](1) NOT NULL,
	[cim] [varchar](50) NOT NULL,
	[adatbazis] [varchar](50) NOT NULL,
 CONSTRAINT [PK_BOLT] PRIMARY KEY CLUSTERED 
(
	[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]

GO

SET ANSI_PADDING OFF
GO

SET ANSI_PADDING ON

GO

/****** Object:  Index [IX_BOLT]    Script Date: 2014.06.25. 10:31:00 ******/
CREATE NONCLUSTERED INDEX [IX_BOLT] ON [dbo].[BOLT]
(
	[boltnev] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

SET ANSI_PADDING ON

GO

/****** Object:  Index [IX_BOLT_1]    Script Date: 2014.06.25. 10:31:00 ******/
CREATE NONCLUSTERED INDEX [IX_BOLT_1] ON [dbo].[BOLT]
(
	[boltnev] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

ALTER TABLE [dbo].[BOLT] ADD  CONSTRAINT [DF_BOLT_kapcsolat]  DEFAULT ('') FOR [kapcsolat]
GO

ALTER TABLE [dbo].[BOLT] ADD  CONSTRAINT [DF_BOLT_megszunt]  DEFAULT ('') FOR [megszunt]
GO

ALTER TABLE [dbo].[BOLT] ADD  CONSTRAINT [DF_BOLT_cim]  DEFAULT ('') FOR [cim]
GO

ALTER TABLE [dbo].[BOLT] ADD  CONSTRAINT [DF_BOLT_adatbazis]  DEFAULT ('bolt') FOR [adatbazis]
GO