USE [master]
GO
/****** Object:  Database [portal]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE DATABASE [portal]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'portal', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\portal.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'portal_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\portal_log.ldf' , SIZE = 2048KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [portal] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [portal].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [portal] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [portal] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [portal] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [portal] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [portal] SET ARITHABORT OFF 
GO
ALTER DATABASE [portal] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [portal] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [portal] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [portal] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [portal] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [portal] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [portal] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [portal] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [portal] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [portal] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [portal] SET  DISABLE_BROKER 
GO
ALTER DATABASE [portal] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [portal] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [portal] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [portal] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [portal] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [portal] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [portal] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [portal] SET RECOVERY FULL 
GO
ALTER DATABASE [portal] SET  MULTI_USER 
GO
ALTER DATABASE [portal] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [portal] SET DB_CHAINING OFF 
GO
ALTER DATABASE [portal] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [portal] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'portal', N'ON'
GO
USE [portal]
GO
/****** Object:  Table [dbo].[Articles]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Articles](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[author] [int] NOT NULL,
	[status] [int] NOT NULL,
	[title] [nvarchar](max) NULL,
	[text] [nvarchar](max) NULL,
	[created] [datetime] NOT NULL,
	[edited] [datetime] NULL,
	[published] [datetime] NULL,
	[commentsAllowed] [bit] NOT NULL,
	[categoryID] [int] NOT NULL,
	[image] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Articles] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Categories]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Categories](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[parentID] [int] NULL,
	[name] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Categories] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Clubs]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Clubs](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](max) NULL,
	[countryID] [int] NOT NULL,
	[yearFounded] [int] NOT NULL,
	[info] [nvarchar](max) NULL,
	[email] [nvarchar](max) NULL,
	[tel] [nvarchar](max) NULL,
	[address] [nvarchar](max) NULL,
	[stadiumID] [int] NOT NULL,
	[categoryID] [int] NULL,
 CONSTRAINT [PK_dbo.Clubs] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Comments]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Comments](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[author] [int] NOT NULL,
	[disabled] [bit] NOT NULL,
	[text] [nvarchar](max) NULL,
	[created] [datetime] NOT NULL,
	[articleID] [int] NOT NULL,
	[reactOnID] [int] NULL,
 CONSTRAINT [PK_dbo.Comments] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Countries]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Countries](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](max) NULL,
	[regionID] [int] NOT NULL,
 CONSTRAINT [PK_dbo.Countries] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FavoriteClubs]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FavoriteClubs](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[userID] [int] NOT NULL,
	[clubID] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FavoriteClubs] 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]

GO
/****** Object:  Table [dbo].[MenuItems]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MenuItems](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[title] [nvarchar](max) NULL,
	[path] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MenuItems] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Opinions]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Opinions](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[author] [int] NOT NULL,
	[text] [nvarchar](max) NULL,
	[status] [int] NOT NULL,
	[created] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.Opinions] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[PlayerResults]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlayerResults](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[resultID] [int] NOT NULL,
	[playerID] [int] NOT NULL,
	[clubID] [int] NOT NULL,
	[minutes] [int] NOT NULL,
	[goals] [int] NOT NULL,
	[goalsReceived] [int] NOT NULL,
	[yellowCards] [int] NOT NULL,
	[redCards] [int] NOT NULL,
 CONSTRAINT [PK_dbo.PlayerResult] 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]

GO
/****** Object:  Table [dbo].[Players]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Players](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[firstName] [nvarchar](max) NULL,
	[lastName] [nvarchar](max) NULL,
	[fullName] [nvarchar](max) NULL,
	[nickName] [nvarchar](max) NULL,
	[countryID] [int] NOT NULL,
	[clubID] [int] NOT NULL,
	[borned] [datetime] NOT NULL,
	[weight] [int] NOT NULL,
	[height] [int] NOT NULL,
	[dressNumber] [int] NOT NULL,
	[image] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Players] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Regions]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Regions](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Regions] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Results]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Results](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[homeClubID] [int] NOT NULL,
	[visitorClubID] [int] NOT NULL,
	[date] [datetime] NOT NULL,
	[categoryID] [int] NOT NULL,
	[seasonYear] [int] NOT NULL,
	[homeClubGoals] [int] NOT NULL,
	[visitorClubGoals] [int] NOT NULL,
	[homeClubPoints] [int] NOT NULL,
	[visitorClubPoints] [int] NOT NULL,
	[penaltyWin] [bit] NOT NULL,
	[round] [int] NOT NULL,
 CONSTRAINT [PK_dbo.Results] 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]

GO
/****** Object:  Table [dbo].[Stadia]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Stadia](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](max) NULL,
	[address] [nvarchar](max) NULL,
	[capacity] [int] NOT NULL,
	[image] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Stadia] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[UserFriendship]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserFriendship](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[userId] [int] NOT NULL,
	[friendUserId] [int] NOT NULL,
 CONSTRAINT [PK_dbo.UserFriendship] 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]

GO
/****** Object:  Table [dbo].[UserProfile]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserProfile](
	[UserId] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](56) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserId] 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
/****** Object:  Table [dbo].[Videos]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Videos](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[author] [int] NOT NULL,
	[disabled] [bit] NOT NULL,
	[videoLink] [nvarchar](max) NULL,
	[created] [datetime] NOT NULL,
	[name] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Videos] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[webpages_Membership]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[webpages_Membership](
	[UserId] [int] NOT NULL,
	[CreateDate] [datetime] NULL,
	[ConfirmationToken] [nvarchar](128) NULL,
	[IsConfirmed] [bit] NULL,
	[LastPasswordFailureDate] [datetime] NULL,
	[PasswordFailuresSinceLastSuccess] [int] NOT NULL,
	[Password] [nvarchar](128) NOT NULL,
	[PasswordChangedDate] [datetime] NULL,
	[PasswordSalt] [nvarchar](128) NOT NULL,
	[PasswordVerificationToken] [nvarchar](128) NULL,
	[PasswordVerificationTokenExpirationDate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[UserId] 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
/****** Object:  Table [dbo].[webpages_OAuthMembership]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[webpages_OAuthMembership](
	[Provider] [nvarchar](30) NOT NULL,
	[ProviderUserId] [nvarchar](100) NOT NULL,
	[UserId] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Provider] ASC,
	[ProviderUserId] 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
/****** Object:  Table [dbo].[webpages_Roles]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[webpages_Roles](
	[RoleId] [int] IDENTITY(1,1) NOT NULL,
	[RoleName] [nvarchar](256) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RoleId] 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
/****** Object:  Table [dbo].[webpages_UsersInRoles]    Script Date: 24. 4. 2015 21:31:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[webpages_UsersInRoles](
	[UserId] [int] NOT NULL,
	[RoleId] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserId] ASC,
	[RoleId] 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 IDENTITY_INSERT [dbo].[Articles] ON 

INSERT [dbo].[Articles] ([id], [author], [status], [title], [text], [created], [edited], [published], [commentsAllowed], [categoryID], [image]) VALUES (1, 1, 1, N'Xhaka spekulace neřeší, na odchod z Gladbachu už nemyslí', N'Granit Xhaka se v nejbližší době nechystá opustit Borussii Mönchengladbach. Jméno mladého švýcarského záložníka bylo v posledních týdnech spojováno s možným stěhováním do Itálie a zájem o něho mají mít Inter Milán s Laziem, hráč ovšem stěhování neplánuje... 

 Xhaka dlouho patřil do základní sestavy Gladbachu, vše se změnilo až začátkem března, od té doby nastoupil k bundesligovému utkání od první minuty jenom ve dvou případech. Sám následně nevyloučil přestup, nyní názor změnil a podobně se na celou záležitost dívá rovněž vedení německého klubu, které je v krajním případě ochotno hráče uvolnit nejméně za patnáct milionů eur. 

"Že jsem nešťastný? To vůbec není pravda, jsou to jenom spekulace tisku. V loňské sezoně jsem odehrál 28 ze 34 zápasů, co více byste ještě chtěli?" podivuje se švýcarský reprezentant. 

"Samozřejmě bych chtěl hráč pořád, ale v tomto ohledu už záleží pouze na volbě trenéra," dodal.', CAST(0x0000A33C010D9610 AS DateTime), CAST(0x0000A33C010DEF1B AS DateTime), CAST(0x0000A33B00E6B680 AS DateTime), 1, 3, N'12318_4.jpg')
INSERT [dbo].[Articles] ([id], [author], [status], [title], [text], [created], [edited], [published], [commentsAllowed], [categoryID], [image]) VALUES (1002, 1, 1, N'Zidane: Hazard patří mezi nejlepší na světě', N'Chelsea se neochvějně drží na čele Premier League a pomalu směřuje k zisku titulu, na čemž má velký podíl Eden Hazard. Belgický ofenzivní záložník patří podle Zinedina Zidana mezi nejlepší hráče na světě... 

Hazard přišel do Chelsea před necelými třemi roky z Lille a prakticky okamžitě se zařadil mezi opory Blues. Ještě větší vliv na hru CFC má belgický záložník po příchodu Josého Mourinha. 

Během letošní sezóny přispěl Hazard londýnskému klubu osmnácti góly a jedenácti asistencemi, čímž se řadí na první místo klubové produktivity. "Líbí se mi všechno, co na hřišti udělá," řekl Zidane. "Osobně řadím Hazarda do skupiny s Messim a Ronaldem," dodal. 

Hazard má navíc ve svých 24 letech všechno před sebou a je u něho velký předpoklad k tomu, že se bude i nadále zlepšovat. "Neustále se zlepšuje, každým rokem jde nahoru. Právě on je jedním z hlavních důvodů, proč je Chelsea nahoře," uvedl Zidane na adresu Belgičana.', CAST(0x0000A48401543368 AS DateTime), CAST(0x0000A48401543368 AS DateTime), CAST(0x0000A48300E6B680 AS DateTime), 1, 1, N'eden-hazard_2788463b.jpg')
INSERT [dbo].[Articles] ([id], [author], [status], [title], [text], [created], [edited], [published], [commentsAllowed], [categoryID], [image]) VALUES (1003, 1, 1, N'Zvažoval jsem konec kariéry, přiznal Pienaar', N'Hodně složitou sezónu prožívá Steven Pienaar. Reprezentant Jihoafrické republiky stihl za Everton kvůli zdravotním problémům odehrát pouze jedenáct utkání, a jak sám přiznal, zvažoval i konec kariéry... 

 Zkušený záložník nastupuje za Toffees, vyjma kratší přestávky u konkurenčního Tottenhamu, osmou sezónu, letos však kvůli zranění třísel a kolena za liverpoolský klub skoro nehrál. 

 To se změnilo až při utkání na hřišti Swansea, kde se Pienaar konečně vrátil do sestavy "Karamelek" a mohl si odškrtnout první ligový zápas tohoto roku. "V jednu chvíli jsem si myslel, že bude nejlepší, když pověsím kopačky na hřebík," řekl Pienaar pro oficiální stránky Evertonu.', CAST(0x0000A4840154BDB0 AS DateTime), CAST(0x0000A4840154BDB0 AS DateTime), CAST(0x0000A48200E6B680 AS DateTime), 1, 1, N'220px-Steven_Pienaar,_Everton.jpg')
INSERT [dbo].[Articles] ([id], [author], [status], [title], [text], [created], [edited], [published], [commentsAllowed], [categoryID], [image]) VALUES (1004, 1, 1, N'Messi dal za Barcelonu 400 gólů, spoustu dalších chce přidat', N'Barcelona včera proti Valencii nepodala přesvědčivý výkon, přesto měla hned dva důvody k radosti. Katalánský klub vyhrál 2:0 a drží první místo tabulky před Realem Madrid, historické statistiky pak znovu přepisoval Lionel Messi - argentinský útočník dal v dresu Barcelony už 400 gólů... 

 Barcelona včera vedla už od první minuty díky brance Luise Suáreze, v dalším průběhu ale měla namále a přežila několik velkých šancí Valencie, včetně neproměněné penalty Daniela Pareja z desáté minuty. O výhru se domácí nakonec strachovali až do nastaveného času, v němž se trefil Messi. 

"Čtyři sta gólů za Barcelonu a doufám, že spoustu dalších ještě přidám! Nejdůležitější každopádně je to, že jsme z velmi těžkého zápasu získali tři body," sdělil včera na své facebookové stránce.', CAST(0x0000A48401551EF4 AS DateTime), CAST(0x0000A48401551EF4 AS DateTime), CAST(0x0000A4840128A180 AS DateTime), 1, 2, N'messi.jpg')
INSERT [dbo].[Articles] ([id], [author], [status], [title], [text], [created], [edited], [published], [commentsAllowed], [categoryID], [image]) VALUES (1005, 1, 1, N'Robben: Chci stihnout semifinále Ligy mistrů', N'Bayern po úvodním nepovedeném čtvrtfinále nejprestižnější evropské klubové soutěže v odvetě na domácí půdě smetl Porto a s přehledem si zajistil postup do další fáze. Semifinále už by chtěl stihnout i Arjen Robben... 

 Nizozemská opora Mnichovanů si při ligovém šlágru s Borussií Mönchengladbach přivodila zranění břišního svalu, načež se odhadovalo, že Bayernu nepomůže celých šest týdnů. 

 Čtyři týdny od zranění už však Robben znovu trénuje a věří, že stihne květnové semifinále Champions League. "Zranění břicha je dobré, ale zápas s Portem jsem stihnout nemohl," uvedl Robben, jenž už myslí na semifinále. "Doktoři předpokládali, že budu mimo hru šest týdnů, vrátil jsem se tak o dva týdny dříve. Nechci ale nic uspěchat," dodal. "Rád bych ale stihl semifinále Ligy mistrů," doufá Robben.', CAST(0x0000A484015583BC AS DateTime), CAST(0x0000A484015583BC AS DateTime), CAST(0x0000A48200E6B680 AS DateTime), 0, 3, N'57134.jpg')
INSERT [dbo].[Articles] ([id], [author], [status], [title], [text], [created], [edited], [published], [commentsAllowed], [categoryID], [image]) VALUES (1006, 1, 1, N'Okazaki zůstane v Mainzu, věří trenér Schmidt', N'Mainz neprožívá ideální sezónu, fanoušky může těšit alespoň forma útočníka Shinjiho Okazakiho, jehož jméno se však začíná spojovat s odchodem. Kouč Martin Schmidt ale věří, že pro příští sezónu zůstane... 

 Falcký klub zvládl včerejší důležité utkání na hřišti Freiburgu, čímž se opět vzdálil sestupovému pásmu, dvěma góly se přitom na výhře podílel právě nezastavitelný Okazaki. 

 Japonský reprezentant má na kontě už dvanáct ligových branek, přibližuje se tak loňskému patnáctigólovému maximu. I vzhledem ke smlouvě do roku 2016 je pak o služby 29letého kanonýra zájem. "Shinji má smlouvu, předpokládám tak, že tady zůstane," řekl Schmidt.', CAST(0x0000A4840155D36C AS DateTime), CAST(0x0000A4840155D36C AS DateTime), CAST(0x0000A48000E6B680 AS DateTime), 1, 3, N'14553_4.jpg')
INSERT [dbo].[Articles] ([id], [author], [status], [title], [text], [created], [edited], [published], [commentsAllowed], [categoryID], [image]) VALUES (1007, 1, 1, N'Horvátha stále trápí kotník a zřejmě už se na hřiště nevrátí', N'Plzeňský záložník Pavel Horváth připustil, že mu zraněný kotník už zřejmě nedovolí nastoupit do soutěžního zápasu. Bývalý český reprezentant, který ve středu oslaví 40. narozeniny, plánoval ukončit profesionální hráčskou kariéru po této sezoně. 

"Jsem už tři týdny mimo hru a od doktorů vím, že jsem mimo hru v podstatě už definitivně, protože ten kotník je opravdu ve špatném stavu. Budu věřit tomu, že když se nám poštěstí a podaří se získat titul v nějakém předstihu, tak se mi povede dostat se s nějakým obstřikem kotníku do kádru a naposledy si šlápnout na hřiště," řekl Horváth v rozhovoru na webu Viktorie. 

"Takhle jsem si to vysnil já, ale reálně to je asi tak, že se na trávník už asi nepodívám. V létě bych stejně skončil a bohužel to asi přijde o nějakou tu chvíli dřív," uvedl dlouholetý kapitán Plzně. 

 V této sezoně za prvoligového lídra nastoupil v nejvyšší soutěži jen pětkrát, několik dalších startů si připsal za juniorku a třetiligové Domažlice, které jsou plzeňskou farmou. Ještě před měsícem s A-týmem naplno trénoval.', CAST(0x0000A4840157794C AS DateTime), CAST(0x0000A4840157794C AS DateTime), CAST(0x0000A48401499700 AS DateTime), 0, 1003, N'12343_4.jpg')
SET IDENTITY_INSERT [dbo].[Articles] OFF
SET IDENTITY_INSERT [dbo].[Categories] ON 

INSERT [dbo].[Categories] ([id], [parentID], [name]) VALUES (1, NULL, N'Premier League')
INSERT [dbo].[Categories] ([id], [parentID], [name]) VALUES (2, NULL, N'Primera Division')
INSERT [dbo].[Categories] ([id], [parentID], [name]) VALUES (3, NULL, N'1. Bundesliga')
INSERT [dbo].[Categories] ([id], [parentID], [name]) VALUES (1002, 3, N'2. Bundesliga')
INSERT [dbo].[Categories] ([id], [parentID], [name]) VALUES (1003, NULL, N'Synot liga')
INSERT [dbo].[Categories] ([id], [parentID], [name]) VALUES (1004, NULL, N'Ligue 1')
SET IDENTITY_INSERT [dbo].[Categories] OFF
SET IDENTITY_INSERT [dbo].[Clubs] ON 

INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (1, N'AC Sparta Praha', 1, 1893, NULL, NULL, NULL, NULL, 1, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (2, N'FC Hradec Králové', 1, 1903, NULL, NULL, NULL, NULL, 2, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (3, N'Real Madrid CF', 2, 1897, NULL, NULL, NULL, NULL, 3, 2)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (4, N'FC Viktoria Plzeň', 1, 1911, NULL, NULL, NULL, NULL, 4, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (5, N'FK Baumit Jablonec', 1, 1944, NULL, NULL, NULL, NULL, 17, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (6, N'FK Mladá Boleslav', 1, 1901, NULL, NULL, NULL, NULL, 6, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (7, N'FK Teplice', 1, 1945, NULL, NULL, NULL, NULL, 7, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (8, N'FK Dukla Praha', 1, 1948, NULL, NULL, NULL, NULL, 8, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (9, N'1. FC Slovácko', 1, 1927, NULL, NULL, NULL, NULL, 9, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (10, N'1. FK Příbram', 1, 1948, NULL, NULL, NULL, NULL, 10, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (11, N'FC Baník Ostrava', 1, 1922, NULL, NULL, NULL, NULL, 11, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (12, N'SK Slavia Praha', 1, 1891, NULL, NULL, NULL, NULL, 12, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (13, N'FC Zbrojovka Brno', 1, 1913, NULL, NULL, NULL, NULL, 13, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (14, N'FC Vysočina Jihlava', 1, 1948, NULL, NULL, NULL, NULL, 14, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (15, N'Bohemians Praha 1905', 1, 1905, NULL, NULL, NULL, NULL, 15, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (17, N'SK Dynamo České Budějovice', 1, 1905, NULL, NULL, NULL, NULL, 16, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (18, N'FC Slovan Liberec', 1, 1958, NULL, NULL, NULL, NULL, 17, 1003)
INSERT [dbo].[Clubs] ([id], [name], [countryID], [yearFounded], [info], [email], [tel], [address], [stadiumID], [categoryID]) VALUES (19, N'FC Barcelona', 2, 1899, NULL, NULL, NULL, NULL, 18, 2)
SET IDENTITY_INSERT [dbo].[Clubs] OFF
SET IDENTITY_INSERT [dbo].[Comments] ON 

INSERT [dbo].[Comments] ([id], [author], [disabled], [text], [created], [articleID], [reactOnID]) VALUES (1, 1, 0, N'Test komentáře', CAST(0x0000A47B01232F60 AS DateTime), 1, NULL)
INSERT [dbo].[Comments] ([id], [author], [disabled], [text], [created], [articleID], [reactOnID]) VALUES (2, 1, 0, N'Další komentář', CAST(0x0000A47B0123D32C AS DateTime), 1, NULL)
INSERT [dbo].[Comments] ([id], [author], [disabled], [text], [created], [articleID], [reactOnID]) VALUES (3, 1, 0, N'Další komentář', CAST(0x0000A47B01241F4A AS DateTime), 1, NULL)
INSERT [dbo].[Comments] ([id], [author], [disabled], [text], [created], [articleID], [reactOnID]) VALUES (4, 1, 0, N'souhlasím', CAST(0x0000A47B0124994B AS DateTime), 1, NULL)
INSERT [dbo].[Comments] ([id], [author], [disabled], [text], [created], [articleID], [reactOnID]) VALUES (5, 1, 0, N'nesouhlasím', CAST(0x0000A47B0126305F AS DateTime), 1, NULL)
INSERT [dbo].[Comments] ([id], [author], [disabled], [text], [created], [articleID], [reactOnID]) VALUES (6, 1, 0, N'nesouhlasím', CAST(0x0000A47B01263946 AS DateTime), 1, NULL)
INSERT [dbo].[Comments] ([id], [author], [disabled], [text], [created], [articleID], [reactOnID]) VALUES (7, 1, 0, N'zásadně nesouhlasím', CAST(0x0000A47B01268534 AS DateTime), 1, NULL)
SET IDENTITY_INSERT [dbo].[Comments] OFF
SET IDENTITY_INSERT [dbo].[Countries] ON 

INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (1, N'Česká Republika', 1)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (2, N'Španělsko', 1)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (3, N'Německo', 1)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (4, N'Brazílie', 6)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (5, N'Argentina', 6)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (6, N'Mexiko', 7)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (7, N'USA', 5)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (8, N'Japonsko', 2)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (9, N'Austrálie', 4)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (10, N'Kamerun', 3)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (11, N'Pobřeží slonoviny', 3)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (12, N'Kanada', 5)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (13, N'Zimbabwe', 3)
INSERT [dbo].[Countries] ([id], [name], [regionID]) VALUES (14, N'Albánie', 1)
SET IDENTITY_INSERT [dbo].[Countries] OFF
SET IDENTITY_INSERT [dbo].[FavoriteClubs] ON 

INSERT [dbo].[FavoriteClubs] ([id], [userID], [clubID]) VALUES (5, 1, 1)
SET IDENTITY_INSERT [dbo].[FavoriteClubs] OFF
SET IDENTITY_INSERT [dbo].[MenuItems] ON 

INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (2, N'Administrace článků', N'Article/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (3, N'Schvalování článků', N'Article/Approve')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (4, N'Administrace kategorií', N'Category/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (5, N'Administrace klubů', N'Club/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (6, N'Administrace hráčů', N'Player/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (7, N'Administrace stadionů', N'Stadium/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (8, N'Administrace kontinentů', N'Region/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (9, N'Administrace zemí', N'Country/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (10, N'Administrace videopříspěvků', N'Video/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (11, N'Schvalování videopříspěvků', N'Video/Approve')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (12, N'Nový článek', N'Article/Create')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (13, N'Administrace menu', N'MenuItem/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (14, N'Přehled uživatelů', N'Account/Users')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (15, N'Administrace výsledků', N'Result/Index')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (16, N'Schvalování článků', N'Article/Approve')
INSERT [dbo].[MenuItems] ([id], [title], [path]) VALUES (17, N'Správa rolí', N'Account/RoleIndex')
SET IDENTITY_INSERT [dbo].[MenuItems] OFF
SET IDENTITY_INSERT [dbo].[Opinions] ON 

INSERT [dbo].[Opinions] ([id], [author], [text], [status], [created]) VALUES (1, 1, N'Zítra el classico!', 1, CAST(0x0000A46300A0ACD0 AS DateTime))
INSERT [dbo].[Opinions] ([id], [author], [text], [status], [created]) VALUES (2, 1, N'Test', 1, CAST(0x0000A46300926313 AS DateTime))
SET IDENTITY_INSERT [dbo].[Opinions] OFF
SET IDENTITY_INSERT [dbo].[PlayerResults] ON 

INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (1, 1, 4, 1, 90, 0, 1, 1, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (3, 1, 11, 1, 90, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (4, 1, 5, 1, 90, 0, 0, 1, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (5, 1, 6, 1, 90, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (6, 1, 8, 1, 90, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (7, 1, 10, 1, 90, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (8, 1, 2, 1, 90, 0, 0, 1, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (9, 1, 15, 1, 56, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (10, 1, 13, 1, 80, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (11, 1, 18, 1, 90, 1, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (12, 1, 19, 1, 90, 2, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (13, 1, 17, 1, 34, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (14, 1, 12, 1, 10, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (15, 5, 4, 1, 90, 0, 1, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (16, 5, 11, 1, 90, 0, 1, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (17, 5, 6, 1, 67, 0, 0, 2, 1)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (18, 5, 5, 1, 90, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (19, 5, 8, 1, 90, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (20, 5, 2, 1, 90, 0, 1, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (21, 5, 10, 1, 75, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (22, 5, 15, 1, 70, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (23, 5, 13, 1, 58, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (24, 5, 18, 1, 90, 2, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (25, 5, 19, 1, 90, 1, 0, 1, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (26, 5, 7, 1, 20, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (27, 5, 12, 1, 15, 0, 0, 0, 0)
INSERT [dbo].[PlayerResults] ([id], [resultID], [playerID], [clubID], [minutes], [goals], [goalsReceived], [yellowCards], [redCards]) VALUES (28, 5, 16, 1, 32, 0, 0, 0, 0)
SET IDENTITY_INSERT [dbo].[PlayerResults] OFF
SET IDENTITY_INSERT [dbo].[Players] ON 

INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (1, N'Josef', N'Hušbauer', NULL, NULL, 1, 1, CAST(0x000080B200D63BC0 AS DateTime), 73, 182, 22, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (2, N'Lukáš', N'Vácha', NULL, NULL, 1, 1, CAST(0x00007F7F00E6B680 AS DateTime), 67, 173, 6, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (3, N'David', N'Bičík', NULL, NULL, 1, 1, CAST(0x0000742B00E6B680 AS DateTime), 83, 188, 35, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (4, N'Marek', N'Štěch', NULL, NULL, 1, 1, CAST(0x0000808300D63BC0 AS DateTime), 89, 191, 1, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (5, N'Mario', N'Holek', NULL, NULL, 1, 1, CAST(0x00007BDF00D63BC0 AS DateTime), 75, 185, 25, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (6, N'Jakub', N'Brabec', NULL, NULL, 1, 1, CAST(0x0000841C00E6B680 AS DateTime), 78, 186, 5, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (7, N'Radoslav', N'Kováč', NULL, NULL, 1, 1, CAST(0x0000720000D63BC0 AS DateTime), 78, 189, 15, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (8, N'Costa', N'Nhamoinesu', NULL, NULL, 13, 1, CAST(0x00007AB800D63BC0 AS DateTime), 74, 186, 26, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (9, N'Ondřej', N'Švejdík', NULL, NULL, 1, 1, CAST(0x0000764E00D63BC0 AS DateTime), 82, 189, 4, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (10, N'Bořek', N'Dočkal', NULL, NULL, 1, 1, CAST(0x00007E9E00E6B680 AS DateTime), 71, 182, 9, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (11, N'Pavel', N'Kadeřábek', NULL, NULL, 1, 1, CAST(0x000083B500E6B680 AS DateTime), 80, 183, 16, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (12, N'Tiemoko', N'Konaté', NULL, NULL, 11, 1, CAST(0x000080A500D63BC0 AS DateTime), 75, 174, 18, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (13, N'Ladislav', N'Krejčí', NULL, NULL, 1, 1, CAST(0x000083FC00E6B680 AS DateTime), 61, 179, 23, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (14, N'Lukáš', N'Mareček', NULL, NULL, 1, 1, CAST(0x000080D200E6B680 AS DateTime), 69, 182, 11, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (15, N'Marek', N'Matějovský', NULL, NULL, 1, 1, CAST(0x000074F200D63BC0 AS DateTime), 72, 177, 8, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (16, N'Jakub', N'Podaný', NULL, NULL, 1, 1, CAST(0x00007CC500E6B680 AS DateTime), 77, 184, 39, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (17, N'Herolind', N'Shala', NULL, NULL, 14, 1, CAST(0x0000836100D63BC0 AS DateTime), 75, 180, 10, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (18, N'Václav', N'Kadlec', NULL, NULL, 1, 1, CAST(0x000083CE00E6B680 AS DateTime), 67, 179, 3, NULL)
INSERT [dbo].[Players] ([id], [firstName], [lastName], [fullName], [nickName], [countryID], [clubID], [borned], [weight], [height], [dressNumber], [image]) VALUES (19, N'David', N'Lafata', NULL, NULL, 1, 1, CAST(0x0000749500E6B680 AS DateTime), 72, 180, 21, NULL)
SET IDENTITY_INSERT [dbo].[Players] OFF
SET IDENTITY_INSERT [dbo].[Regions] ON 

INSERT [dbo].[Regions] ([id], [name]) VALUES (1, N'Evropa')
INSERT [dbo].[Regions] ([id], [name]) VALUES (2, N'Asie')
INSERT [dbo].[Regions] ([id], [name]) VALUES (3, N'Afrika')
INSERT [dbo].[Regions] ([id], [name]) VALUES (4, N'Austrálie a Oceánie')
INSERT [dbo].[Regions] ([id], [name]) VALUES (5, N'Severní Amerika')
INSERT [dbo].[Regions] ([id], [name]) VALUES (6, N'Jižní Amerika')
INSERT [dbo].[Regions] ([id], [name]) VALUES (7, N'Střední Amerika')
SET IDENTITY_INSERT [dbo].[Regions] OFF
SET IDENTITY_INSERT [dbo].[Results] ON 

INSERT [dbo].[Results] ([id], [homeClubID], [visitorClubID], [date], [categoryID], [seasonYear], [homeClubGoals], [visitorClubGoals], [homeClubPoints], [visitorClubPoints], [penaltyWin], [round]) VALUES (1, 1, 2, CAST(0x0000A46200D63BC0 AS DateTime), 1003, 2014, 3, 1, 3, 0, 0, 1)
INSERT [dbo].[Results] ([id], [homeClubID], [visitorClubID], [date], [categoryID], [seasonYear], [homeClubGoals], [visitorClubGoals], [homeClubPoints], [visitorClubPoints], [penaltyWin], [round]) VALUES (2, 5, 6, CAST(0x0000A46100D63BC0 AS DateTime), 1003, 2014, 2, 1, 3, 0, 0, 1)
INSERT [dbo].[Results] ([id], [homeClubID], [visitorClubID], [date], [categoryID], [seasonYear], [homeClubGoals], [visitorClubGoals], [homeClubPoints], [visitorClubPoints], [penaltyWin], [round]) VALUES (3, 11, 12, CAST(0x0000A46200D63BC0 AS DateTime), 1003, 2014, 2, 2, 1, 1, 0, 1)
INSERT [dbo].[Results] ([id], [homeClubID], [visitorClubID], [date], [categoryID], [seasonYear], [homeClubGoals], [visitorClubGoals], [homeClubPoints], [visitorClubPoints], [penaltyWin], [round]) VALUES (4, 12, 2, CAST(0x0000A47000E6B680 AS DateTime), 1003, 2014, 0, 0, 1, 1, 0, 2)
INSERT [dbo].[Results] ([id], [homeClubID], [visitorClubID], [date], [categoryID], [seasonYear], [homeClubGoals], [visitorClubGoals], [homeClubPoints], [visitorClubPoints], [penaltyWin], [round]) VALUES (5, 4, 1, CAST(0x0000A47100E6B680 AS DateTime), 1003, 2014, 1, 3, 0, 3, 0, 2)
SET IDENTITY_INSERT [dbo].[Results] OFF
SET IDENTITY_INSERT [dbo].[Stadia] ON 

INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (1, N'Generali Aréna', N'Praha', 19784, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (2, N'Všesportovní stadion', N'Hradec Králové', 7000, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (3, N'Santiago Bernabeu', N'Madrid', 80354, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (4, N'Doosan Aréna', N'Plzeň', 12500, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (5, N'Střelnice', N'Jablonec', 6246, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (6, N'Městský stadion', N'Mladá Boleslav', 5000, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (7, N'Na stínadlech', N'Teplice', 18221, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (8, N'Na Julisce', N'Praha', 18000, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (9, N'Městský fotbalový stadion', N'Uherské hradiště', 8121, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (10, N'Stadion na Litavce', N'Příbram', 9100, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (11, N'Bazaly', N'Ostrava', 17372, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (12, N'Eden Aréna', N'Praha', 21000, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (13, N'Městský fotbalový stadión', N'Brno', 8065, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (14, N'Stadión FC Vysočina', N'Jihlava', 4025, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (15, N'Ďolíček', N'Praha', 6863, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (16, N'Stadión na Střeleckém ostrově', N'České Budějovice', 6708, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (17, N'Stadión u Nisy', N'Liberec', 9900, NULL)
INSERT [dbo].[Stadia] ([id], [name], [address], [capacity], [image]) VALUES (18, N'Camp Nou', N'Barcelona', 98772, NULL)
SET IDENTITY_INSERT [dbo].[Stadia] OFF
SET IDENTITY_INSERT [dbo].[UserFriendship] ON 

INSERT [dbo].[UserFriendship] ([id], [userId], [friendUserId]) VALUES (8, 1, 2)
INSERT [dbo].[UserFriendship] ([id], [userId], [friendUserId]) VALUES (9, 2, 1)
SET IDENTITY_INSERT [dbo].[UserFriendship] OFF
SET IDENTITY_INSERT [dbo].[UserProfile] ON 

INSERT [dbo].[UserProfile] ([UserId], [UserName]) VALUES (3, N'admin')
INSERT [dbo].[UserProfile] ([UserId], [UserName]) VALUES (2, N'Johny')
INSERT [dbo].[UserProfile] ([UserId], [UserName]) VALUES (1, N'steve')
SET IDENTITY_INSERT [dbo].[UserProfile] OFF
SET IDENTITY_INSERT [dbo].[Videos] ON 

INSERT [dbo].[Videos] ([id], [author], [disabled], [videoLink], [created], [name]) VALUES (1, 1, 0, N'https://www.youtube.com/watch?v=KIXlPp_t21k', CAST(0x0000A33C010E75E4 AS DateTime), N'World Cup 2010')
INSERT [dbo].[Videos] ([id], [author], [disabled], [videoLink], [created], [name]) VALUES (2, 1, 0, N'https://www.youtube.com/watch?v=fxbfU-AQjmk', CAST(0x0000A47A01412994 AS DateTime), N'Cristiano Ronaldo')
SET IDENTITY_INSERT [dbo].[Videos] OFF
INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (1, CAST(0x0000A33C00EB04C1 AS DateTime), NULL, 1, CAST(0x0000A484012F7A36 AS DateTime), 0, N'AHPvpl6zv4rWLCrQL6jxvt7Okr4nMty8pYeucUYbSaTVxpA7XcpualQ8eONxeg8bzw==', CAST(0x0000A33C00EB04C1 AS DateTime), N'', NULL, NULL)
INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (2, CAST(0x0000A34401082F92 AS DateTime), NULL, 1, NULL, 0, N'ACj8tF4FKq0TkLigzZFv+vldXhJTDunlpnm+BqD6neQnV3RgrTWXw20vATGCRou1dw==', CAST(0x0000A34401082F92 AS DateTime), N'', NULL, NULL)
INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (3, CAST(0x0000A4840136BF6E AS DateTime), NULL, 1, NULL, 0, N'AE3uUbbXNVYqlIR3Jk6EabgXOoZi2tEsHHMD/CERmbb4bcEjqSpKeM9CXJa3gC4riw==', CAST(0x0000A4840136BF6E AS DateTime), N'', NULL, NULL)
SET IDENTITY_INSERT [dbo].[webpages_Roles] ON 

INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (1, N'admin')
INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (5, N'authorized')
INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (4, N'editor')
INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (2, N'redaktor')
INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (3, N'sefredaktor')
SET IDENTITY_INSERT [dbo].[webpages_Roles] OFF
INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (1, 1)
INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (3, 1)
/****** Object:  Index [IX_categoryID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_categoryID] ON [dbo].[Articles]
(
	[categoryID] 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_parentID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_parentID] ON [dbo].[Categories]
(
	[parentID] 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_categoryID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_categoryID] ON [dbo].[Clubs]
(
	[categoryID] 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_countryID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_countryID] ON [dbo].[Clubs]
(
	[countryID] 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_stadiumID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_stadiumID] ON [dbo].[Clubs]
(
	[stadiumID] 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_articleID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_articleID] ON [dbo].[Comments]
(
	[articleID] 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_reactOnID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_reactOnID] ON [dbo].[Comments]
(
	[reactOnID] 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_regionID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_regionID] ON [dbo].[Countries]
(
	[regionID] 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_clubID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_clubID] ON [dbo].[Players]
(
	[clubID] 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_countryID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_countryID] ON [dbo].[Players]
(
	[countryID] 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_categoryID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_categoryID] ON [dbo].[Results]
(
	[categoryID] 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_homeClubID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_homeClubID] ON [dbo].[Results]
(
	[homeClubID] 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_visitorClubID]    Script Date: 24. 4. 2015 21:31:03 ******/
CREATE NONCLUSTERED INDEX [IX_visitorClubID] ON [dbo].[Results]
(
	[visitorClubID] 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 [UQ__UserProf__C9F28456AD91640D]    Script Date: 24. 4. 2015 21:31:03 ******/
ALTER TABLE [dbo].[UserProfile] ADD UNIQUE NONCLUSTERED 
(
	[UserName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [UQ__webpages__8A2B6160F6C9809F]    Script Date: 24. 4. 2015 21:31:03 ******/
ALTER TABLE [dbo].[webpages_Roles] ADD UNIQUE NONCLUSTERED 
(
	[RoleName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Results] ADD  DEFAULT ((0)) FOR [round]
GO
ALTER TABLE [dbo].[webpages_Membership] ADD  DEFAULT ((0)) FOR [IsConfirmed]
GO
ALTER TABLE [dbo].[webpages_Membership] ADD  DEFAULT ((0)) FOR [PasswordFailuresSinceLastSuccess]
GO
ALTER TABLE [dbo].[Articles]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Articles_dbo.Categories_categoryID] FOREIGN KEY([categoryID])
REFERENCES [dbo].[Categories] ([id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Articles] CHECK CONSTRAINT [FK_dbo.Articles_dbo.Categories_categoryID]
GO
ALTER TABLE [dbo].[Categories]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Categories_dbo.Categories_parentID] FOREIGN KEY([parentID])
REFERENCES [dbo].[Categories] ([id])
GO
ALTER TABLE [dbo].[Categories] CHECK CONSTRAINT [FK_dbo.Categories_dbo.Categories_parentID]
GO
ALTER TABLE [dbo].[Clubs]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Clubs_dbo.Categories_categoryID] FOREIGN KEY([categoryID])
REFERENCES [dbo].[Categories] ([id])
GO
ALTER TABLE [dbo].[Clubs] CHECK CONSTRAINT [FK_dbo.Clubs_dbo.Categories_categoryID]
GO
ALTER TABLE [dbo].[Clubs]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Clubs_dbo.Countries_countryID] FOREIGN KEY([countryID])
REFERENCES [dbo].[Countries] ([id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Clubs] CHECK CONSTRAINT [FK_dbo.Clubs_dbo.Countries_countryID]
GO
ALTER TABLE [dbo].[Clubs]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Clubs_dbo.Stadia_stadiumID] FOREIGN KEY([stadiumID])
REFERENCES [dbo].[Stadia] ([id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Clubs] CHECK CONSTRAINT [FK_dbo.Clubs_dbo.Stadia_stadiumID]
GO
ALTER TABLE [dbo].[Comments]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Comments_dbo.Articles_articleID] FOREIGN KEY([articleID])
REFERENCES [dbo].[Articles] ([id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Comments] CHECK CONSTRAINT [FK_dbo.Comments_dbo.Articles_articleID]
GO
ALTER TABLE [dbo].[Comments]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Comments_dbo.Comments_reactOnID] FOREIGN KEY([reactOnID])
REFERENCES [dbo].[Comments] ([id])
GO
ALTER TABLE [dbo].[Comments] CHECK CONSTRAINT [FK_dbo.Comments_dbo.Comments_reactOnID]
GO
ALTER TABLE [dbo].[Countries]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Countries_dbo.Regions_regionID] FOREIGN KEY([regionID])
REFERENCES [dbo].[Regions] ([id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Countries] CHECK CONSTRAINT [FK_dbo.Countries_dbo.Regions_regionID]
GO
ALTER TABLE [dbo].[Players]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Players_dbo.Clubs_clubID] FOREIGN KEY([clubID])
REFERENCES [dbo].[Clubs] ([id])
GO
ALTER TABLE [dbo].[Players] CHECK CONSTRAINT [FK_dbo.Players_dbo.Clubs_clubID]
GO
ALTER TABLE [dbo].[Players]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Players_dbo.Countries_countryID] FOREIGN KEY([countryID])
REFERENCES [dbo].[Countries] ([id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Players] CHECK CONSTRAINT [FK_dbo.Players_dbo.Countries_countryID]
GO
ALTER TABLE [dbo].[Results]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Results_dbo.Categories_categoryID] FOREIGN KEY([categoryID])
REFERENCES [dbo].[Categories] ([id])
GO
ALTER TABLE [dbo].[Results] CHECK CONSTRAINT [FK_dbo.Results_dbo.Categories_categoryID]
GO
ALTER TABLE [dbo].[Results]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Results_dbo.Clubs_homeClubID] FOREIGN KEY([homeClubID])
REFERENCES [dbo].[Clubs] ([id])
GO
ALTER TABLE [dbo].[Results] CHECK CONSTRAINT [FK_dbo.Results_dbo.Clubs_homeClubID]
GO
ALTER TABLE [dbo].[Results]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Results_dbo.Clubs_visitorClubID] FOREIGN KEY([visitorClubID])
REFERENCES [dbo].[Clubs] ([id])
GO
ALTER TABLE [dbo].[Results] CHECK CONSTRAINT [FK_dbo.Results_dbo.Clubs_visitorClubID]
GO
ALTER TABLE [dbo].[webpages_UsersInRoles]  WITH CHECK ADD  CONSTRAINT [fk_RoleId] FOREIGN KEY([RoleId])
REFERENCES [dbo].[webpages_Roles] ([RoleId])
GO
ALTER TABLE [dbo].[webpages_UsersInRoles] CHECK CONSTRAINT [fk_RoleId]
GO
ALTER TABLE [dbo].[webpages_UsersInRoles]  WITH CHECK ADD  CONSTRAINT [fk_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[UserProfile] ([UserId])
GO
ALTER TABLE [dbo].[webpages_UsersInRoles] CHECK CONSTRAINT [fk_UserId]
GO
USE [master]
GO
ALTER DATABASE [portal] SET  READ_WRITE 
GO
