/****** Object:  View [dbo].[vqszall_szle]    Script Date: 07/02/2008 10:04:07 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vqszall_szle]'))
DROP VIEW [dbo].[vqszall_szle]
GO


/****** Object:  ForeignKey [FK_akc_csom_szt_akc_csom_szf]    Script Date: 07/11/2008 15:33:00 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_akc_csom_szt_akc_csom_szf]') AND parent_object_id = OBJECT_ID(N'[dbo].[akc_csom_szt]'))
ALTER TABLE [dbo].[akc_csom_szt] DROP CONSTRAINT [FK_akc_csom_szt_akc_csom_szf]
GO
/****** Object:  Table [dbo].[akc_csom_szf]    Script Date: 07/11/2008 15:32:57 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_szf]') AND type in (N'U'))
DROP TABLE [dbo].[akc_csom_szf]
GO
/****** Object:  Table [dbo].[akc_csom_szt]    Script Date: 07/11/2008 15:33:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_szt]') AND type in (N'U'))
DROP TABLE [dbo].[akc_csom_szt]
GO
/****** Object:  Table [dbo].[akc_csom_jog]    Script Date: 07/11/2008 15:32:50 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_jog]') AND type in (N'U'))
DROP TABLE [dbo].[akc_csom_jog]
GO
/****** Object:  Table [dbo].[akc_csom_szt]    Script Date: 07/11/2008 15:33:00 ******/
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].[akc_csom_szt]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[akc_csom_szt](
	[csomag_azon] [int] NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[cikkcsoport] [char](18) NOT NULL,
	[gyarto] [dbo].[kulcs] NOT NULL,
	[szallito] [dbo].[kulcs] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_szt]') AND name = N'IX_akc_csom_szt_cikk_szam')
CREATE NONCLUSTERED INDEX [IX_akc_csom_szt_cikk_szam] ON [dbo].[akc_csom_szt] 
(
	[cikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_szt]') AND name = N'IX_akc_csom_szt_csomag_azon')
CREATE NONCLUSTERED INDEX [IX_akc_csom_szt_csomag_azon] ON [dbo].[akc_csom_szt] 
(
	[csomag_azon] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[akc_csom_szf]    Script Date: 07/11/2008 15:32:57 ******/
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].[akc_csom_szf]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[akc_csom_szf](
	[csomag_azon] [int] IDENTITY(1,1) NOT NULL,
	[csomag_nev] [dbo].[nev] NOT NULL,
	[idoszak] [char](7) NOT NULL,
	[prioritas] [int] NOT NULL,
	[kint1] [dbo].[egyseg_ar] NOT NULL,
	[vint1] [dbo].[egyseg_ar] NOT NULL,
	[kedv1] [dbo].[kedvezmeny] NOT NULL,
	[kint2] [dbo].[egyseg_ar] NOT NULL,
	[vint2] [dbo].[egyseg_ar] NOT NULL,
	[kedv2] [dbo].[kedvezmeny] NOT NULL,
	[kint3] [dbo].[egyseg_ar] NOT NULL,
	[vint3] [dbo].[egyseg_ar] NOT NULL,
	[kedv3] [dbo].[kedvezmeny] NOT NULL,
	[kicsoda] [dbo].[kicsoda] NOT NULL,
	[modositva] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_akc_csom_szf] PRIMARY KEY CLUSTERED 
(
	[csomag_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
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_szf]') AND name = N'IX_akc_csom_szf_1')
CREATE NONCLUSTERED INDEX [IX_akc_csom_szf_1] ON [dbo].[akc_csom_szf] 
(
	[idoszak] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[akc_csom_jog]    Script Date: 07/11/2008 15:32:50 ******/
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].[akc_csom_jog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[akc_csom_jog](
	[KOD] [int] NOT NULL,
	[NEV] [dbo].[nev] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  ForeignKey [FK_akc_csom_szt_akc_csom_szf]    Script Date: 07/11/2008 15:33:00 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_akc_csom_szt_akc_csom_szf]') AND parent_object_id = OBJECT_ID(N'[dbo].[akc_csom_szt]'))
ALTER TABLE [dbo].[akc_csom_szt]  WITH CHECK ADD  CONSTRAINT [FK_akc_csom_szt_akc_csom_szf] FOREIGN KEY([csomag_azon])
REFERENCES [dbo].[akc_csom_szf] ([csomag_azon])
GO
ALTER TABLE [dbo].[akc_csom_szt] CHECK CONSTRAINT [FK_akc_csom_szt_akc_csom_szf]
GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[bizsorszam]') AND name = N'IX_bizsorszam_EVTIPUS')
CREATE CLUSTERED INDEX [IX_bizsorszam_EVTIPUS] ON [dbo].[bizsorszam] 
(
	[EVTIPUS] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[parameterek]') AND name = N'IX_parameterek_Azonosito')
CREATE NONCLUSTERED INDEX [IX_parameterek_Azonosito] ON [dbo].[parameterek] 
(
	[AZONOSITO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[parameterek]') AND name = N'IX_parameterek_Szamitogep')
CREATE NONCLUSTERED INDEX [IX_parameterek_Szamitogep] ON [dbo].[parameterek] 
(
	[SZAMITOGEP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Posta]') AND name = N'IX_Posta_Irszam')
CREATE NONCLUSTERED INDEX [IX_Posta_Irszam] ON [dbo].[Posta] 
(
	[Irszam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[kivetf]') AND name = N'IX_KIVETF')
CREATE NONCLUSTERED INDEX [IX_KIVETF] ON [dbo].[kivetf] 
(
	[DATUM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[kivetf]') AND name = N'IX_KIVETF_1')
CREATE NONCLUSTERED INDEX [IX_KIVETF_1] ON [dbo].[kivetf] 
(
	[KIVET_KOD] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[kivetf]') AND name = N'IX_KIVETF_2')
CREATE NONCLUSTERED INDEX [IX_KIVETF_2] ON [dbo].[kivetf] 
(
	[RAKTAR_K] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[keszlet]') AND name = N'IX_KESZLET')
CREATE NONCLUSTERED INDEX [IX_KESZLET] ON [dbo].[keszlet] 
(
	[RAKTAR_KOD] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[keszlet]') AND name = N'IX_KESZLET_1')
CREATE NONCLUSTERED INDEX [IX_KESZLET_1] ON [dbo].[keszlet] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[keszlet]') AND name = N'IX_KESZLET_2')
CREATE NONCLUSTERED INDEX [IX_KESZLET_2] ON [dbo].[keszlet] 
(
	[RAKTAR_KOD] ASC,
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_rent]') AND name = N'IX_nb_vevo_rent_Bizszam')
CREATE NONCLUSTERED INDEX [IX_nb_vevo_rent_Bizszam] ON [dbo].[nb_vevo_rent] 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_szlet]') AND name = N'IX_szall_szlet')
CREATE NONCLUSTERED INDEX [IX_szall_szlet] ON [dbo].[szall_szlet] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_renf]') AND name = N'IX_nb_vevo_renf_vevo')
CREATE NONCLUSTERED INDEX [IX_nb_vevo_renf_vevo] ON [dbo].[nb_vevo_renf] 
(
	[VEVO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[rmozgast]') AND name = N'IX_RMOZGAST')
CREATE NONCLUSTERED INDEX [IX_RMOZGAST] ON [dbo].[rmozgast] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[rmozgast]') AND name = N'IX_rmozgast_bizszam')
CREATE NONCLUSTERED INDEX [IX_rmozgast_bizszam] ON [dbo].[rmozgast] 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_szlat]') AND name = N'IX_szall_szlat')
CREATE NONCLUSTERED INDEX [IX_szall_szlat] ON [dbo].[szall_szlat] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_szlef]') AND name = N'IX_szall_szlef')
CREATE NONCLUSTERED INDEX [IX_szall_szlef] ON [dbo].[szall_szlef] 
(
	[SZALLITO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_szlef]') AND name = N'IX_szall_szlef_1')
CREATE NONCLUSTERED INDEX [IX_szall_szlef_1] ON [dbo].[szall_szlef] 
(
	[TELJ_DATUM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_szlef]') AND name = N'IX_szall_szlef_2')
CREATE NONCLUSTERED INDEX [IX_szall_szlef_2] ON [dbo].[szall_szlef] 
(
	[RAKTAR_KOD] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlat]') AND name = N'IX_nb_vevo_szlat_bizszam')
CREATE NONCLUSTERED INDEX [IX_nb_vevo_szlat_bizszam] ON [dbo].[nb_vevo_szlat] 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlef]') AND name = N'IX_nb_vevo_szlef_Vevo')
CREATE NONCLUSTERED INDEX [IX_nb_vevo_szlef_Vevo] ON [dbo].[nb_vevo_szlef] 
(
	[VEVO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlet]') AND name = N'IX_nb_vevo_szlet_Bizszam')
CREATE NONCLUSTERED INDEX [IX_nb_vevo_szlet_Bizszam] ON [dbo].[nb_vevo_szlet] 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_szlaf]') AND name = N'IX_szall_szlaf')
CREATE NONCLUSTERED INDEX [IX_szall_szlaf] ON [dbo].[szall_szlaf] 
(
	[KULSOSZLASZ] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_szlaf]') AND name = N'IX_szall_szlaf_1')
CREATE NONCLUSTERED INDEX [IX_szall_szlaf_1] ON [dbo].[szall_szlaf] 
(
	[SZALLITO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_arf]') AND name = N'IX_SZAL_ARF')
CREATE NONCLUSTERED INDEX [IX_SZAL_ARF] ON [dbo].[szall_arf] 
(
	[SZALLITO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_arf]') AND name = N'IX_SZAL_ARF_1')
CREATE NONCLUSTERED INDEX [IX_SZAL_ARF_1] ON [dbo].[szall_arf] 
(
	[KDATUM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szlat]') AND name = N'IX_VEVO_SZLAT')
CREATE NONCLUSTERED INDEX [IX_VEVO_SZLAT] ON [dbo].[vevo_szlat] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szlaf]') AND name = N'IX_VEVO_SZLAF')
CREATE NONCLUSTERED INDEX [IX_VEVO_SZLAF] ON [dbo].[vevo_szlaf] 
(
	[VEVO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szlaf]') AND name = N'IX_VEVO_SZLAF_1')
CREATE NONCLUSTERED INDEX [IX_VEVO_SZLAF_1] ON [dbo].[vevo_szlaf] 
(
	[SZLA_DATUM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlaf]') AND name = N'IX_nb_vevo_szlaf_Vevo')
CREATE NONCLUSTERED INDEX [IX_nb_vevo_szlaf_Vevo] ON [dbo].[nb_vevo_szlaf] 
(
	[VEVO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_rent]') AND name = N'IX_szall_rent')
CREATE NONCLUSTERED INDEX [IX_szall_rent] ON [dbo].[szall_rent] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[kivett]') AND name = N'IX_KIVETT')
CREATE NONCLUSTERED INDEX [IX_KIVETT] ON [dbo].[kivett] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[kivett]') AND name = N'IX_KIVETT_Bizszam')
CREATE NONCLUSTERED INDEX [IX_KIVETT_Bizszam] ON [dbo].[kivett] 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szlet]') AND name = N'IX_VEVO_SZLET')
CREATE NONCLUSTERED INDEX [IX_VEVO_SZLET] ON [dbo].[vevo_szlet] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_renf]') AND name = N'IX_vevo_renf')
CREATE NONCLUSTERED INDEX [IX_vevo_renf] ON [dbo].[vevo_renf] 
(
	[VEVO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_renf]') AND name = N'IX_vevo_renf_1')
CREATE NONCLUSTERED INDEX [IX_vevo_renf_1] ON [dbo].[vevo_renf] 
(
	[REND_DAT] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_renf]') AND name = N'IX_vevo_renf_2')
CREATE NONCLUSTERED INDEX [IX_vevo_renf_2] ON [dbo].[vevo_renf] 
(
	[UZLETKOTO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[rmozgasf]') AND name = N'IX_RMOZGASF')
CREATE NONCLUSTERED INDEX [IX_RMOZGASF] ON [dbo].[rmozgasf] 
(
	[DATUM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[rmozgasf]') AND name = N'IX_RMOZGASF_1')
CREATE NONCLUSTERED INDEX [IX_RMOZGASF_1] ON [dbo].[rmozgasf] 
(
	[CRAKTAR_K] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[rmozgasf]') AND name = N'IX_RMOZGASF_2')
CREATE NONCLUSTERED INDEX [IX_RMOZGASF_2] ON [dbo].[rmozgasf] 
(
	[FRAKTAR_K] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[bevett]') AND name = N'IX_BEVETT')
CREATE NONCLUSTERED INDEX [IX_BEVETT] ON [dbo].[bevett] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szlef]') AND name = N'IX_VEVO_SZLEF')
CREATE NONCLUSTERED INDEX [IX_VEVO_SZLEF] ON [dbo].[vevo_szlef] 
(
	[VEVO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szlef]') AND name = N'IX_VEVO_SZLEF_1')
CREATE NONCLUSTERED INDEX [IX_VEVO_SZLEF_1] ON [dbo].[vevo_szlef] 
(
	[TELJ_DATUM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_renf]') AND name = N'IX_szall_renf')
CREATE NONCLUSTERED INDEX [IX_szall_renf] ON [dbo].[szall_renf] 
(
	[datum] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_renf]') AND name = N'IX_szall_renf_1')
CREATE NONCLUSTERED INDEX [IX_szall_renf_1] ON [dbo].[szall_renf] 
(
	[szallito] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_art]') AND name = N'IX_SZAL_ART')
CREATE NONCLUSTERED INDEX [IX_SZAL_ART] ON [dbo].[szall_art] 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_art]') AND name = N'IX_SZAL_ART_1')
CREATE NONCLUSTERED INDEX [IX_SZAL_ART_1] ON [dbo].[szall_art] 
(
	[BIZSZAM] ASC,
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szall_art]') AND name = N'IX_szall_art_bizszam')
CREATE NONCLUSTERED INDEX [IX_szall_art_bizszam] ON [dbo].[szall_art] 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[bevetf]') AND name = N'IX_BEVETF')
CREATE NONCLUSTERED INDEX [IX_BEVETF] ON [dbo].[bevetf] 
(
	[DATUM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[bevetf]') AND name = N'IX_BEVETF_1')
CREATE NONCLUSTERED INDEX [IX_BEVETF_1] ON [dbo].[bevetf] 
(
	[RAKTAR_K] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szl_fizetve]') AND name = N'IX_vevo_szl_fizetve_bizszam')
CREATE NONCLUSTERED INDEX [IX_vevo_szl_fizetve_bizszam] ON [dbo].[vevo_szl_fizetve] 
(
	[bizszam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mozgas]') AND name = N'IX_MOZGAS')
CREATE NONCLUSTERED INDEX [IX_MOZGAS] ON [dbo].[mozgas] 
(
	[MOZGASKOD] ASC,
	[BIZSZAM] ASC,
	[TETEL] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mozgas]') AND name = N'IX_MOZGAS_1')
CREATE NONCLUSTERED INDEX [IX_MOZGAS_1] ON [dbo].[mozgas] 
(
	[SORSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[leltar_felv]') AND name = N'IX_leltar_felv_cikk_szam')
CREATE NONCLUSTERED INDEX [IX_leltar_felv_cikk_szam] ON [dbo].[leltar_felv] 
(
	[cikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[leltar]') AND name = N'IX_leltar_cikk_szam')
CREATE NONCLUSTERED INDEX [IX_leltar_cikk_szam] ON [dbo].[leltar] 
(
	[cikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[uzletkoto]') AND name = N'IX_uzletkoto')
CREATE NONCLUSTERED INDEX [IX_uzletkoto] ON [dbo].[uzletkoto] 
(
	[nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_ido_szlat]') AND name = N'IX_vevo_ido_szlat_kod')
CREATE NONCLUSTERED INDEX [IX_vevo_ido_szlat_kod] ON [dbo].[vevo_ido_szlat] 
(
	[kod] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_ido_szlat]') AND name = N'IX_vevo_ido_szlat_vevo_kod')
CREATE NONCLUSTERED INDEX [IX_vevo_ido_szlat_vevo_kod] ON [dbo].[vevo_ido_szlat] 
(
	[vevo_kod] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_arcsoport]') AND name = N'IX_vevo_arcsoport')
CREATE NONCLUSTERED INDEX [IX_vevo_arcsoport] ON [dbo].[vevo_arcsoport] 
(
	[NEV] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_cegjelleg]') AND name = N'IX_vevo_cegjelleg')
CREATE NONCLUSTERED INDEX [IX_vevo_cegjelleg] ON [dbo].[vevo_cegjelleg] 
(
	[nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_csz]') AND name = N'IX_vevo_csz_cikk_szam')
CREATE NONCLUSTERED INDEX [IX_vevo_csz_cikk_szam] ON [dbo].[vevo_csz] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_csoport]') AND name = N'IX_vevo_csoport')
CREATE NONCLUSTERED INDEX [IX_vevo_csoport] ON [dbo].[vevo_csoport] 
(
	[Nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[raktarak]') AND name = N'IX_RAKTARAK')
CREATE NONCLUSTERED INDEX [IX_RAKTARAK] ON [dbo].[raktarak] 
(
	[nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_art]') AND name = N'IX_vevo_art')
CREATE NONCLUSTERED INDEX [IX_vevo_art] ON [dbo].[vevo_art] 
(
	[ARCSOPORT] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[kivetjog]') AND name = N'IX_KIVETJOG')
CREATE NONCLUSTERED INDEX [IX_KIVETJOG] ON [dbo].[kivetjog] 
(
	[kivetnev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_arak]') AND name = N'IX_vevo_arak_arcsoport')
CREATE NONCLUSTERED INDEX [IX_vevo_arak_arcsoport] ON [dbo].[vevo_arak] 
(
	[arcsoport] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[gyarto]') AND name = N'IX_gyarto')
CREATE NONCLUSTERED INDEX [IX_gyarto] ON [dbo].[gyarto] 
(
	[nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevok]') AND name = N'IX_vevok_Vevo_Nev')
CREATE NONCLUSTERED INDEX [IX_vevok_Vevo_Nev] ON [dbo].[vevok] 
(
	[VEVO_NEV] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_akc_csoport]') AND name = N'IX_vevo_akc_csoport')
CREATE NONCLUSTERED INDEX [IX_vevo_akc_csoport] ON [dbo].[vevo_akc_csoport] 
(
	[nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[bankcsomagf]') AND name = N'IX_bankcsomagf_datum')
CREATE NONCLUSTERED INDEX [IX_bankcsomagf_datum] ON [dbo].[bankcsomagf] 
(
	[datum] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[bankcsomagf]') AND name = N'IX_bankcsomagf_kivonat')
CREATE NONCLUSTERED INDEX [IX_bankcsomagf_kivonat] ON [dbo].[bankcsomagf] 
(
	[kivonat] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vonal]') AND name = N'IX_VONAL')
CREATE NONCLUSTERED INDEX [IX_VONAL] ON [dbo].[vonal] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[a_leltar_felv]') AND name = N'IX_a_leltar_felv_cikk_nev')
CREATE NONCLUSTERED INDEX [IX_a_leltar_felv_cikk_nev] ON [dbo].[a_leltar_felv] 
(
	[cikk_nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[a_leltar_felv]') AND name = N'IX_a_leltar_felv_cikk_szam')
CREATE NONCLUSTERED INDEX [IX_a_leltar_felv_cikk_szam] ON [dbo].[a_leltar_felv] 
(
	[cikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[a_leltar_felv]') AND name = N'IX_a_leltar_felv_oldal_tetel')
CREATE NONCLUSTERED INDEX [IX_a_leltar_felv_oldal_tetel] ON [dbo].[a_leltar_felv] 
(
	[oldal] ASC,
	[tetel] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_terulet]') AND name = N'IX_vevo_terulet')
CREATE NONCLUSTERED INDEX [IX_vevo_terulet] ON [dbo].[vevo_terulet] 
(
	[nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_cszcsoport]') AND name = N'IX_vevo_cszcsoport')
CREATE NONCLUSTERED INDEX [IX_vevo_cszcsoport] ON [dbo].[vevo_cszcsoport] 
(
	[NEV] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_szt]') AND name = N'IX_akc_csom_szt_cikk_szam')
CREATE NONCLUSTERED INDEX [IX_akc_csom_szt_cikk_szam] ON [dbo].[akc_csom_szt] 
(
	[cikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_szt]') AND name = N'IX_akc_csom_szt_csomag_azon')
CREATE NONCLUSTERED INDEX [IX_akc_csom_szt_csomag_azon] ON [dbo].[akc_csom_szt] 
(
	[csomag_azon] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[vevo_lanc]') AND name = N'IX_vevo_lanc')
CREATE NONCLUSTERED INDEX [IX_vevo_lanc] ON [dbo].[vevo_lanc] 
(
	[nev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szallito]') AND name = N'IX_SZALLITO')
CREATE NONCLUSTERED INDEX [IX_SZALLITO] ON [dbo].[szallito] 
(
	[SZALL_NEV] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[szallito]') AND name = N'IX_SZALLITO_1')
CREATE NONCLUSTERED INDEX [IX_SZALLITO_1] ON [dbo].[szallito] 
(
	[SZALLCSOP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[cikkek]') AND name = N'IX_Cikkek_Cikk_Nev')
CREATE NONCLUSTERED INDEX [IX_Cikkek_Cikk_Nev] ON [dbo].[cikkek] 
(
	[CIKK_NEV] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[cikkek]') AND name = N'IX_cikkek_cikkcsop2')
CREATE NONCLUSTERED INDEX [IX_cikkek_cikkcsop2] ON [dbo].[cikkek] 
(
	[CIKKCSOP2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[cikkek]') AND name = N'IX_cikkek_GYARTO')
CREATE NONCLUSTERED INDEX [IX_cikkek_GYARTO] ON [dbo].[cikkek] 
(
	[GYARTO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[cikkek]') AND name = N'IX_cikkek_SZALLITO')
CREATE NONCLUSTERED INDEX [IX_cikkek_SZALLITO] ON [dbo].[cikkek] 
(
	[SZALLITO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[akc_csom_szf]') AND name = N'IX_akc_csom_szf_1')
CREATE NONCLUSTERED INDEX [IX_akc_csom_szf_1] ON [dbo].[akc_csom_szf] 
(
	[idoszak] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[belepes]') AND name = N'IX_BELEPES')
CREATE NONCLUSTERED INDEX [IX_BELEPES] ON [dbo].[belepes] 
(
	[TELJESNEV] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[penztarb]') AND name = N'IX_penztarb_pentarb')
CREATE CLUSTERED INDEX [IX_penztarb_pentarb] ON [dbo].[penztarb] 
(
	[kulcs] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[penztarb]') AND name = N'IX_penztarb_bizszam')
CREATE NONCLUSTERED INDEX [IX_penztarb_bizszam] ON [dbo].[penztarb] 
(
	[bizszam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[bankcsomagb]') AND name = N'IX_bankcsomagb_bizszam')
CREATE NONCLUSTERED INDEX [IX_bankcsomagb_bizszam] ON [dbo].[bankcsomagb] 
(
	[bizszam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[orszag]') AND name = N'IX_orszag')
CREATE NONCLUSTERED INDEX [IX_orszag] ON [dbo].[orszag] 
(
	[orszag] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO