IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__websi__7469CB5A]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__websi__7469CB5A]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__class__7375A721]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__class__7375A721]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__tag_i__728182E8]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__tag_i__728182E8]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__secti__718D5EAF]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__secti__718D5EAF]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__secti__70993A76]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__secti__70993A76]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__count__6FA5163D]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__count__6FA5163D]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__szall__6EB0F204]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__szall__6EB0F204]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__gyart__6DBCCDCB]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__gyart__6DBCCDCB]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__produ__6CC8A992]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sect__produ__6CC8A992]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sectio__cid__6BD48559]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] DROP CONSTRAINT [DF___web_sectio__cid__6BD48559]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_prodpa__cid__7A22A4B0]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_prodpages_products] DROP CONSTRAINT [DF___web_prodpa__cid__7A22A4B0]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_prod__page___792E8077]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_prodpages_products] DROP CONSTRAINT [DF___web_prod__page___792E8077]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_prod__is_de__77463805]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_prodpages] DROP CONSTRAINT [DF___web_prod__is_de__77463805]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_orde__maxim__2230960A]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_orders_delivery_limit] DROP CONSTRAINT [DF___web_orde__maxim__2230960A]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_custo__user__03AC0EEA]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_customers_searches] DROP CONSTRAINT [DF___web_custo__user__03AC0EEA]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_cust__resul__02B7EAB1]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_customers_searches] DROP CONSTRAINT [DF___web_cust__resul__02B7EAB1]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_cust__query__01C3C678]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_customers_searches] DROP CONSTRAINT [DF___web_cust__query__01C3C678]
END

GO
/****** Object:  Index [IX__web_prodpages_products_1]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_prodpages_products]') AND name = N'IX__web_prodpages_products_1')
DROP INDEX [IX__web_prodpages_products_1] ON [dbo].[_web_prodpages_products]
GO
/****** Object:  Index [IX__web_prodpages_products]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_prodpages_products]') AND name = N'IX__web_prodpages_products')
DROP INDEX [IX__web_prodpages_products] ON [dbo].[_web_prodpages_products]
GO
/****** Object:  Index [IX__web_orders_delivery_limit]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_orders_delivery_limit]') AND name = N'IX__web_orders_delivery_limit')
DROP INDEX [IX__web_orders_delivery_limit] ON [dbo].[_web_orders_delivery_limit]
GO
/****** Object:  Index [IX__web_customers_searches_2]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_customers_searches]') AND name = N'IX__web_customers_searches_2')
DROP INDEX [IX__web_customers_searches_2] ON [dbo].[_web_customers_searches]
GO
/****** Object:  Index [IX__web_customers_searches_1]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_customers_searches]') AND name = N'IX__web_customers_searches_1')
DROP INDEX [IX__web_customers_searches_1] ON [dbo].[_web_customers_searches]
GO
/****** Object:  Index [IX__web_customers_searches]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_customers_searches]') AND name = N'IX__web_customers_searches')
DROP INDEX [IX__web_customers_searches] ON [dbo].[_web_customers_searches]
GO
/****** Object:  Table [dbo].[_web_sections]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_sections]') AND type in (N'U'))
DROP TABLE [dbo].[_web_sections]
GO
/****** Object:  Table [dbo].[_web_prodpages_products]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_prodpages_products]') AND type in (N'U'))
DROP TABLE [dbo].[_web_prodpages_products]
GO
/****** Object:  Table [dbo].[_web_prodpages]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_prodpages]') AND type in (N'U'))
DROP TABLE [dbo].[_web_prodpages]
GO
/****** Object:  Table [dbo].[_web_orders_delivery_limit]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_orders_delivery_limit]') AND type in (N'U'))
DROP TABLE [dbo].[_web_orders_delivery_limit]
GO
/****** Object:  Table [dbo].[_web_customers_searches]    Script Date: 2016.02.23. 14:52:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_web_customers_searches]') AND type in (N'U'))
DROP TABLE [dbo].[_web_customers_searches]
GO
/****** Object:  Table [dbo].[_web_customers_searches]    Script Date: 2016.02.23. 14:52:22 ******/
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_customers_searches]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_customers_searches](
	[id] [int] IDENTITY(33194,1) NOT NULL,
	[date] [datetime] NOT NULL,
	[query] [varchar](75) NULL,
	[results] [int] NULL,
	[user_name] [varchar](75) NULL,
 CONSTRAINT [PK_web_customers_searches] PRIMARY KEY CLUSTERED 
(
	[id] 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_orders_delivery_limit]    Script Date: 2016.02.23. 14:52:22 ******/
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_orders_delivery_limit]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_orders_delivery_limit](
	[day] [varchar](10) NOT NULL,
	[maximum] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[_web_prodpages]    Script Date: 2016.02.23. 14:52:22 ******/
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_prodpages]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_prodpages](
	[page_id] [smallint] IDENTITY(40,1) NOT NULL,
	[title_hu] [varchar](100) NOT NULL,
	[title_en] [varchar](100) NOT NULL,
	[url_hu] [varchar](75) NOT NULL,
	[url_en] [varchar](75) NOT NULL,
	[date_created] [date] NOT NULL,
	[is_deleted] [tinyint] NOT NULL,
 CONSTRAINT [PK_web_prodpages] PRIMARY KEY CLUSTERED 
(
	[page_id] 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_prodpages_products]    Script Date: 2016.02.23. 14:52:22 ******/
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_prodpages_products]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_prodpages_products](
	[page_id] [smallint] NOT NULL,
	[cid] [varchar](15) NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[_web_sections]    Script Date: 2016.02.23. 14:52:22 ******/
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_sections]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[_web_sections](
	[section_id] [int] IDENTITY(178,1) NOT NULL,
	[name_hu] [varchar](255) NOT NULL,
	[name_en] [varchar](255) NOT NULL,
	[cid] [varchar](50) NULL,
	[products] [varchar](50) NULL,
	[gyarto] [varchar](255) NULL,
	[szallito] [varchar](255) NULL,
	[keyword] [varchar](25) NOT NULL,
	[is_offer] [tinyint] NOT NULL,
	[country] [varchar](150) NULL,
	[section_order] [tinyint] NOT NULL,
	[section_type] [tinyint] NULL,
	[tag_id] [int] NULL,
	[pids] [text] NULL,
	[pids_w_images] [text] NULL,
	[class] [varchar](20) NULL,
	[website] [tinyint] NOT NULL,
 CONSTRAINT [PK_web_sections] PRIMARY KEY CLUSTERED 
(
	[section_id] 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
/****** Object:  Index [IX__web_customers_searches]    Script Date: 2016.02.23. 14:52:22 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_customers_searches]') AND name = N'IX__web_customers_searches')
CREATE NONCLUSTERED INDEX [IX__web_customers_searches] ON [dbo].[_web_customers_searches]
(
	[date] 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_customers_searches_1]    Script Date: 2016.02.23. 14:52:22 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_customers_searches]') AND name = N'IX__web_customers_searches_1')
CREATE NONCLUSTERED INDEX [IX__web_customers_searches_1] ON [dbo].[_web_customers_searches]
(
	[query] 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_customers_searches_2]    Script Date: 2016.02.23. 14:52:22 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_customers_searches]') AND name = N'IX__web_customers_searches_2')
CREATE NONCLUSTERED INDEX [IX__web_customers_searches_2] ON [dbo].[_web_customers_searches]
(
	[user_name] 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_orders_delivery_limit]    Script Date: 2016.02.23. 14:52:22 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_orders_delivery_limit]') AND name = N'IX__web_orders_delivery_limit')
CREATE NONCLUSTERED INDEX [IX__web_orders_delivery_limit] ON [dbo].[_web_orders_delivery_limit]
(
	[day] 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_prodpages_products]    Script Date: 2016.02.23. 14:52:22 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_prodpages_products]') AND name = N'IX__web_prodpages_products')
CREATE NONCLUSTERED INDEX [IX__web_prodpages_products] ON [dbo].[_web_prodpages_products]
(
	[page_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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX__web_prodpages_products_1]    Script Date: 2016.02.23. 14:52:22 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[_web_prodpages_products]') AND name = N'IX__web_prodpages_products_1')
CREATE NONCLUSTERED INDEX [IX__web_prodpages_products_1] ON [dbo].[_web_prodpages_products]
(
	[cid] 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 dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_cust__query__01C3C678]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_customers_searches] ADD  CONSTRAINT [DF___web_cust__query__01C3C678]  DEFAULT (NULL) FOR [query]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_cust__resul__02B7EAB1]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_customers_searches] ADD  CONSTRAINT [DF___web_cust__resul__02B7EAB1]  DEFAULT (NULL) FOR [results]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_custo__user__03AC0EEA]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_customers_searches] ADD  CONSTRAINT [DF___web_custo__user__03AC0EEA]  DEFAULT (NULL) FOR [user_name]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_orde__maxim__2230960A]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_orders_delivery_limit] ADD  DEFAULT ((0)) FOR [maximum]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_prod__is_de__77463805]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_prodpages] ADD  CONSTRAINT [DF___web_prod__is_de__77463805]  DEFAULT ((0)) FOR [is_deleted]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_prod__page___792E8077]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_prodpages_products] ADD  CONSTRAINT [DF___web_prod__page___792E8077]  DEFAULT (NULL) FOR [page_id]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_prodpa__cid__7A22A4B0]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_prodpages_products] ADD  CONSTRAINT [DF___web_prodpa__cid__7A22A4B0]  DEFAULT (NULL) FOR [cid]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sectio__cid__6BD48559]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sectio__cid__6BD48559]  DEFAULT (NULL) FOR [cid]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__produ__6CC8A992]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__produ__6CC8A992]  DEFAULT (NULL) FOR [products]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__gyart__6DBCCDCB]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__gyart__6DBCCDCB]  DEFAULT (NULL) FOR [gyarto]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__szall__6EB0F204]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__szall__6EB0F204]  DEFAULT (NULL) FOR [szallito]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__count__6FA5163D]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__count__6FA5163D]  DEFAULT (NULL) FOR [country]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__secti__70993A76]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__secti__70993A76]  DEFAULT ((0)) FOR [section_order]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__secti__718D5EAF]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__secti__718D5EAF]  DEFAULT (NULL) FOR [section_type]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__tag_i__728182E8]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__tag_i__728182E8]  DEFAULT (NULL) FOR [tag_id]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__class__7375A721]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__class__7375A721]  DEFAULT (NULL) FOR [class]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF___web_sect__websi__7469CB5A]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[_web_sections] ADD  CONSTRAINT [DF___web_sect__websi__7469CB5A]  DEFAULT ((1)) FOR [website]
END

GO




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