IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kosar_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kosar]'))
ALTER TABLE [dbo].[_web_kosar] DROP CONSTRAINT [FK__web_kosar_cikkek]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kedvencek_vevok]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kedvencek]'))
ALTER TABLE [dbo].[_web_kedvencek] DROP CONSTRAINT [FK__web_kedvencek_vevok]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kedvencek_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kedvencek]'))
ALTER TABLE [dbo].[_web_kedvencek] DROP CONSTRAINT [FK__web_kedvencek_cikkek]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_belepes_vevok]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_belepes]'))
ALTER TABLE [dbo].[_web_belepes] DROP CONSTRAINT [FK__web_belepes_vevok]
GO
/****** Object:  Index [IX__web_kosar_3]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND name = N'IX__web_kosar_3')
DROP INDEX [IX__web_kosar_3] ON [dbo].[_web_kosar]
GO
/****** Object:  Index [IX__web_kosar_2]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND name = N'IX__web_kosar_2')
DROP INDEX [IX__web_kosar_2] ON [dbo].[_web_kosar]
GO
/****** Object:  Index [IX__web_kosar_1]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND name = N'IX__web_kosar_1')
DROP INDEX [IX__web_kosar_1] ON [dbo].[_web_kosar]
GO
/****** Object:  Index [IX__web_kosar]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND name = N'IX__web_kosar')
DROP INDEX [IX__web_kosar] ON [dbo].[_web_kosar]
GO
/****** Object:  Index [IX__web_belepes_1]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_belepes]') AND name = N'IX__web_belepes_1')
DROP INDEX [IX__web_belepes_1] ON [dbo].[_web_belepes]
GO
/****** Object:  Index [IX__web_belepes]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_belepes]') AND name = N'IX__web_belepes')
DROP INDEX [IX__web_belepes] ON [dbo].[_web_belepes]
GO
/****** Object:  Table [dbo].[_web_oldalak]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_oldalak]') AND type in (N'U'))
DROP TABLE [dbo].[_web_oldalak]
GO
/****** Object:  Table [dbo].[_web_kosar]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND type in (N'U'))
DROP TABLE [dbo].[_web_kosar]
GO
/****** Object:  Table [dbo].[_web_kedvencek]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_kedvencek]') AND type in (N'U'))
DROP TABLE [dbo].[_web_kedvencek]
GO
/****** Object:  Table [dbo].[_web_belepes]    Script Date: 2014.10.14. 15:56:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_belepes]') AND type in (N'U'))
DROP TABLE [dbo].[_web_belepes]
GO
/****** Object:  Table [dbo].[_web_belepes]    Script Date: 2014.10.14. 15:56:30 ******/
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].[_web_belepes]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_belepes](
	[belep_nev] [varchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[jelszo] [varchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[email] [varchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[vevo_kod] [dbo].[kulcs] NOT NULL,
	[vevo_terulet] [dbo].[kulcs] NOT NULL,
	[ut_belepes] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK__web_belepes] PRIMARY KEY CLUSTERED 
(
	[belep_nev] 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].[_web_kedvencek]    Script Date: 2014.10.14. 15:56:30 ******/
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].[_web_kedvencek]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_kedvencek](
	[vevo_kod] [dbo].[kulcs] NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[_web_kosar]    Script Date: 2014.10.14. 15:56:30 ******/
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].[_web_kosar]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_kosar](
	[kulcs] [int] IDENTITY(1,1) NOT NULL,
	[cikk_szam] [char](14) COLLATE Hungarian_CI_AS NOT NULL,
	[cikk_nev] [varchar](80) COLLATE Hungarian_CI_AS NOT NULL,
	[brutto_ar] [numeric](18, 2) NOT NULL,
	[netto_ar] [numeric](18, 2) NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NULL,
	[darab] [numeric](18, 3) NOT NULL,
	[menny_egys] [varchar](8) COLLATE Hungarian_CI_AS NOT NULL,
	[afa_kulcs] [dbo].[afa_kulcs] NULL,
	[gongyoleg_csz] [dbo].[cikk_szam] NULL,
	[gongyoleg_ar] [dbo].[egyseg_ar] NULL,
	[akcio] [varchar](1) COLLATE Hungarian_CI_AS NULL,
	[vevo_kod] [int] NOT NULL,
	[session_id] [varchar](50) COLLATE Hungarian_CI_AS NOT NULL,
	[kosarba_kerul] [dbo].[datum_ora] NULL,
 CONSTRAINT [PK__web_kosar] 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].[_web_oldalak]    Script Date: 2014.10.14. 15:56:30 ******/
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].[_web_oldalak]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_oldalak](
	[kulcs] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[cim_hun] [varchar](75) COLLATE Hungarian_CI_AS NULL,
	[html_hun] [nvarchar](max) COLLATE Hungarian_CI_AS NULL,
	[cim_ang] [varchar](75) COLLATE Hungarian_CI_AS NULL,
	[html_ang] [nvarchar](max) COLLATE Hungarian_CI_AS NULL,
	[modositva] [date] NULL,
 CONSTRAINT [PK__web_oldalak] 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] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX__web_belepes]    Script Date: 2014.10.14. 15:56:30 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_belepes]') AND name = N'IX__web_belepes')
CREATE NONCLUSTERED INDEX [IX__web_belepes] ON [dbo].[_web_belepes]
(
	[belep_nev] 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__web_belepes_1]    Script Date: 2014.10.14. 15:56:30 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_belepes]') AND name = N'IX__web_belepes_1')
CREATE NONCLUSTERED INDEX [IX__web_belepes_1] ON [dbo].[_web_belepes]
(
	[email] 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__web_kosar]    Script Date: 2014.10.14. 15:56:30 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND name = N'IX__web_kosar')
CREATE NONCLUSTERED INDEX [IX__web_kosar] ON [dbo].[_web_kosar]
(
	[cikk_szam] 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__web_kosar_1]    Script Date: 2014.10.14. 15:56:30 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND name = N'IX__web_kosar_1')
CREATE NONCLUSTERED INDEX [IX__web_kosar_1] ON [dbo].[_web_kosar]
(
	[session_id] 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
/****** Object:  Index [IX__web_kosar_2]    Script Date: 2014.10.14. 15:56:30 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND name = N'IX__web_kosar_2')
CREATE NONCLUSTERED INDEX [IX__web_kosar_2] ON [dbo].[_web_kosar]
(
	[vevo_kod] 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__web_kosar_3]    Script Date: 2014.10.14. 15:56:30 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_kosar]') AND name = N'IX__web_kosar_3')
CREATE NONCLUSTERED INDEX [IX__web_kosar_3] ON [dbo].[_web_kosar]
(
	[kosarba_kerul] 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
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_belepes_vevok]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_belepes]'))
ALTER TABLE [dbo].[_web_belepes]  WITH CHECK ADD  CONSTRAINT [FK__web_belepes_vevok] FOREIGN KEY([vevo_kod])
REFERENCES [dbo].[vevok] ([VEVO_KOD])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_belepes_vevok]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_belepes]'))
ALTER TABLE [dbo].[_web_belepes] CHECK CONSTRAINT [FK__web_belepes_vevok]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kedvencek_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kedvencek]'))
ALTER TABLE [dbo].[_web_kedvencek]  WITH CHECK ADD  CONSTRAINT [FK__web_kedvencek_cikkek] FOREIGN KEY([cikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kedvencek_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kedvencek]'))
ALTER TABLE [dbo].[_web_kedvencek] CHECK CONSTRAINT [FK__web_kedvencek_cikkek]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kedvencek_vevok]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kedvencek]'))
ALTER TABLE [dbo].[_web_kedvencek]  WITH CHECK ADD  CONSTRAINT [FK__web_kedvencek_vevok] FOREIGN KEY([vevo_kod])
REFERENCES [dbo].[vevok] ([VEVO_KOD])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kedvencek_vevok]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kedvencek]'))
ALTER TABLE [dbo].[_web_kedvencek] CHECK CONSTRAINT [FK__web_kedvencek_vevok]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kosar_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kosar]'))
ALTER TABLE [dbo].[_web_kosar]  WITH CHECK ADD  CONSTRAINT [FK__web_kosar_cikkek] FOREIGN KEY([cikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__web_kosar_cikkek]') AND parent_object_id = OBJECT_ID(N'[dbo].[_web_kosar]'))
ALTER TABLE [dbo].[_web_kosar] CHECK CONSTRAINT [FK__web_kosar_cikkek]
GO


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