Jwc0SZUj

1
2ALTER DATABASE [UTO2015] SET ANSI_NULL_DEFAULT OFF 
3GO
4ALTER DATABASE [UTO2015] SET ANSI_NULLS OFF 
5GO
6ALTER DATABASE [UTO2015] SET ANSI_PADDING OFF 
7GO
8ALTER DATABASE [UTO2015] SET ANSI_WARNINGS OFF 
9GO
10ALTER DATABASE [UTO2015] SET ARITHABORT OFF 
11GO
12ALTER DATABASE [UTO2015] SET AUTO_CLOSE OFF 
13GO
14ALTER DATABASE [UTO2015] SET AUTO_SHRINK OFF 
15GO
16ALTER DATABASE [UTO2015] SET AUTO_UPDATE_STATISTICS ON 
17GO
18ALTER DATABASE [UTO2015] SET CURSOR_CLOSE_ON_COMMIT OFF 
19GO
20ALTER DATABASE [UTO2015] SET CURSOR_DEFAULT  GLOBAL 
21GO
22ALTER DATABASE [UTO2015] SET CONCAT_NULL_YIELDS_NULL OFF 
23GO
24ALTER DATABASE [UTO2015] SET NUMERIC_ROUNDABORT OFF 
25GO
26ALTER DATABASE [UTO2015] SET QUOTED_IDENTIFIER OFF 
27GO
28ALTER DATABASE [UTO2015] SET RECURSIVE_TRIGGERS OFF 
29GO
30ALTER DATABASE [UTO2015] SET  DISABLE_BROKER 
31GO
32ALTER DATABASE [UTO2015] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
33GO
34ALTER DATABASE [UTO2015] SET DATE_CORRELATION_OPTIMIZATION OFF 
35GO
36ALTER DATABASE [UTO2015] SET TRUSTWORTHY OFF 
37GO
38ALTER DATABASE [UTO2015] SET ALLOW_SNAPSHOT_ISOLATION OFF 
39GO
40ALTER DATABASE [UTO2015] SET PARAMETERIZATION SIMPLE 
41GO
42ALTER DATABASE [UTO2015] SET READ_COMMITTED_SNAPSHOT OFF 
43GO
44ALTER DATABASE [UTO2015] SET HONOR_BROKER_PRIORITY OFF 
45GO
46ALTER DATABASE [UTO2015] SET RECOVERY FULL 
47GO
48ALTER DATABASE [UTO2015] SET  MULTI_USER 
49GO
50ALTER DATABASE [UTO2015] SET PAGE_VERIFY CHECKSUM  
51GO
52ALTER DATABASE [UTO2015] SET DB_CHAINING OFF 
53GO
54ALTER DATABASE [UTO2015] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
55GO
56ALTER DATABASE [UTO2015] SET TARGET_RECOVERY_TIME = 0 SECONDS 
57GO
58ALTER DATABASE [UTO2015] SET DELAYED_DURABILITY = DISABLED 
59GO
60USE [UTO2015]
61GO
62/****** Object:  User [uto.web]    Script Date: 16.2.2017. 14:59:48 ******/
63CREATE USER [uto.web] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
64GO
65/****** Object:  DatabaseRole [aspnet_WebEvent_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
66CREATE ROLE [aspnet_WebEvent_FullAccess]
67GO
68/****** Object:  DatabaseRole [aspnet_Roles_ReportingAccess]    Script Date: 16.2.2017. 14:59:48 ******/
69CREATE ROLE [aspnet_Roles_ReportingAccess]
70GO
71/****** Object:  DatabaseRole [aspnet_Roles_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
72CREATE ROLE [aspnet_Roles_FullAccess]
73GO
74/****** Object:  DatabaseRole [aspnet_Roles_BasicAccess]    Script Date: 16.2.2017. 14:59:48 ******/
75CREATE ROLE [aspnet_Roles_BasicAccess]
76GO
77/****** Object:  DatabaseRole [aspnet_Profile_ReportingAccess]    Script Date: 16.2.2017. 14:59:48 ******/
78CREATE ROLE [aspnet_Profile_ReportingAccess]
79GO
80/****** Object:  DatabaseRole [aspnet_Profile_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
81CREATE ROLE [aspnet_Profile_FullAccess]
82GO
83/****** Object:  DatabaseRole [aspnet_Profile_BasicAccess]    Script Date: 16.2.2017. 14:59:48 ******/
84CREATE ROLE [aspnet_Profile_BasicAccess]
85GO
86/****** Object:  DatabaseRole [aspnet_Personalization_ReportingAccess]    Script Date: 16.2.2017. 14:59:48 ******/
87CREATE ROLE [aspnet_Personalization_ReportingAccess]
88GO
89/****** Object:  DatabaseRole [aspnet_Personalization_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
90CREATE ROLE [aspnet_Personalization_FullAccess]
91GO
92/****** Object:  DatabaseRole [aspnet_Personalization_BasicAccess]    Script Date: 16.2.2017. 14:59:48 ******/
93CREATE ROLE [aspnet_Personalization_BasicAccess]
94GO
95/****** Object:  DatabaseRole [aspnet_Membership_ReportingAccess]    Script Date: 16.2.2017. 14:59:48 ******/
96CREATE ROLE [aspnet_Membership_ReportingAccess]
97GO
98/****** Object:  DatabaseRole [aspnet_Membership_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
99CREATE ROLE [aspnet_Membership_FullAccess]
100GO
101/****** Object:  DatabaseRole [aspnet_Membership_BasicAccess]    Script Date: 16.2.2017. 14:59:48 ******/
102CREATE ROLE [aspnet_Membership_BasicAccess]
103GO
104ALTER ROLE [db_owner] ADD MEMBER [uto.web]
105GO
106ALTER ROLE [aspnet_Roles_BasicAccess] ADD MEMBER [aspnet_Roles_FullAccess]
107GO
108ALTER ROLE [aspnet_Roles_ReportingAccess] ADD MEMBER [aspnet_Roles_FullAccess]
109GO
110ALTER ROLE [aspnet_Profile_BasicAccess] ADD MEMBER [aspnet_Profile_FullAccess]
111GO
112ALTER ROLE [aspnet_Profile_ReportingAccess] ADD MEMBER [aspnet_Profile_FullAccess]
113GO
114ALTER ROLE [aspnet_Personalization_BasicAccess] ADD MEMBER [aspnet_Personalization_FullAccess]
115GO
116ALTER ROLE [aspnet_Personalization_ReportingAccess] ADD MEMBER [aspnet_Personalization_FullAccess]
117GO
118ALTER ROLE [aspnet_Membership_BasicAccess] ADD MEMBER [aspnet_Membership_FullAccess]
119GO
120ALTER ROLE [aspnet_Membership_ReportingAccess] ADD MEMBER [aspnet_Membership_FullAccess]
121GO
122/****** Object:  Schema [aspnet_Membership_BasicAccess]    Script Date: 16.2.2017. 14:59:48 ******/
123CREATE SCHEMA [aspnet_Membership_BasicAccess]
124GO
125/****** Object:  Schema [aspnet_Membership_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
126CREATE SCHEMA [aspnet_Membership_FullAccess]
127GO
128/****** Object:  Schema [aspnet_Membership_ReportingAccess]    Script Date: 16.2.2017. 14:59:48 ******/
129CREATE SCHEMA [aspnet_Membership_ReportingAccess]
130GO
131/****** Object:  Schema [aspnet_Personalization_BasicAccess]    Script Date: 16.2.2017. 14:59:48 ******/
132CREATE SCHEMA [aspnet_Personalization_BasicAccess]
133GO
134/****** Object:  Schema [aspnet_Personalization_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
135CREATE SCHEMA [aspnet_Personalization_FullAccess]
136GO
137/****** Object:  Schema [aspnet_Personalization_ReportingAccess]    Script Date: 16.2.2017. 14:59:48 ******/
138CREATE SCHEMA [aspnet_Personalization_ReportingAccess]
139GO
140/****** Object:  Schema [aspnet_Profile_BasicAccess]    Script Date: 16.2.2017. 14:59:48 ******/
141CREATE SCHEMA [aspnet_Profile_BasicAccess]
142GO
143/****** Object:  Schema [aspnet_Profile_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
144CREATE SCHEMA [aspnet_Profile_FullAccess]
145GO
146/****** Object:  Schema [aspnet_Profile_ReportingAccess]    Script Date: 16.2.2017. 14:59:48 ******/
147CREATE SCHEMA [aspnet_Profile_ReportingAccess]
148GO
149/****** Object:  Schema [aspnet_Roles_BasicAccess]    Script Date: 16.2.2017. 14:59:48 ******/
150CREATE SCHEMA [aspnet_Roles_BasicAccess]
151GO
152/****** Object:  Schema [aspnet_Roles_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
153CREATE SCHEMA [aspnet_Roles_FullAccess]
154GO
155/****** Object:  Schema [aspnet_Roles_ReportingAccess]    Script Date: 16.2.2017. 14:59:48 ******/
156CREATE SCHEMA [aspnet_Roles_ReportingAccess]
157GO
158/****** Object:  Schema [aspnet_WebEvent_FullAccess]    Script Date: 16.2.2017. 14:59:48 ******/
159CREATE SCHEMA [aspnet_WebEvent_FullAccess]
160GO
161/****** Object:  Table [dbo].[aspnet_Applications]    Script Date: 16.2.2017. 14:59:48 ******/
162SET ANSI_NULLS ON
163GO
164SET QUOTED_IDENTIFIER ON
165GO
166CREATE TABLE [dbo].[aspnet_Applications](
167	[ApplicationName] [nvarchar](256) NOT NULL,
168	[LoweredApplicationName] [nvarchar](256) NOT NULL,
169	[ApplicationId] [uniqueidentifier] NOT NULL,
170	[Description] [nvarchar](256) NULL,
171PRIMARY KEY NONCLUSTERED 
172(
173	[ApplicationId] ASC
174)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
175UNIQUE NONCLUSTERED 
176(
177	[LoweredApplicationName] ASC
178)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
179UNIQUE NONCLUSTERED 
180(
181	[ApplicationName] ASC
182)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
183) ON [PRIMARY]
184
185GO
186SET ANSI_PADDING ON
187
188GO
189/****** Object:  Index [aspnet_Applications_Index]    Script Date: 16.2.2017. 14:59:48 ******/
190CREATE CLUSTERED INDEX [aspnet_Applications_Index] ON [dbo].[aspnet_Applications]
191(
192	[LoweredApplicationName] ASC
193)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]
194GO
195/****** Object:  Table [dbo].[aspnet_Membership]    Script Date: 16.2.2017. 14:59:48 ******/
196SET ANSI_NULLS ON
197GO
198SET QUOTED_IDENTIFIER ON
199GO
200CREATE TABLE [dbo].[aspnet_Membership](
201	[ApplicationId] [uniqueidentifier] NOT NULL,
202	[UserId] [uniqueidentifier] NOT NULL,
203	[Password] [nvarchar](128) NOT NULL,
204	[PasswordFormat] [int] NOT NULL,
205	[PasswordSalt] [nvarchar](128) NOT NULL,
206	[MobilePIN] [nvarchar](16) NULL,
207	[Email] [nvarchar](256) NULL,
208	[LoweredEmail] [nvarchar](256) NULL,
209	[PasswordQuestion] [nvarchar](256) NULL,
210	[PasswordAnswer] [nvarchar](128) NULL,
211	[IsApproved] [bit] NOT NULL,
212	[IsLockedOut] [bit] NOT NULL,
213	[CreateDate] [datetime] NOT NULL,
214	[LastLoginDate] [datetime] NOT NULL,
215	[LastPasswordChangedDate] [datetime] NOT NULL,
216	[LastLockoutDate] [datetime] NOT NULL,
217	[FailedPasswordAttemptCount] [int] NOT NULL,
218	[FailedPasswordAttemptWindowStart] [datetime] NOT NULL,
219	[FailedPasswordAnswerAttemptCount] [int] NOT NULL,
220	[FailedPasswordAnswerAttemptWindowStart] [datetime] NOT NULL,
221	[Comment] [ntext] NULL,
222PRIMARY KEY NONCLUSTERED 
223(
224	[UserId] ASC
225)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
226) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
227
228GO
229SET ANSI_PADDING ON
230
231GO
232/****** Object:  Index [aspnet_Membership_index]    Script Date: 16.2.2017. 14:59:48 ******/
233CREATE CLUSTERED INDEX [aspnet_Membership_index] ON [dbo].[aspnet_Membership]
234(
235	[ApplicationId] ASC,
236	[LoweredEmail] ASC
237)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]
238GO
239/****** Object:  Table [dbo].[aspnet_Paths]    Script Date: 16.2.2017. 14:59:48 ******/
240SET ANSI_NULLS ON
241GO
242SET QUOTED_IDENTIFIER ON
243GO
244CREATE TABLE [dbo].[aspnet_Paths](
245	[ApplicationId] [uniqueidentifier] NOT NULL,
246	[PathId] [uniqueidentifier] NOT NULL,
247	[Path] [nvarchar](256) NOT NULL,
248	[LoweredPath] [nvarchar](256) NOT NULL,
249PRIMARY KEY NONCLUSTERED 
250(
251	[PathId] ASC
252)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
253) ON [PRIMARY]
254
255GO
256SET ANSI_PADDING ON
257
258GO
259/****** Object:  Index [aspnet_Paths_index]    Script Date: 16.2.2017. 14:59:48 ******/
260CREATE UNIQUE CLUSTERED INDEX [aspnet_Paths_index] ON [dbo].[aspnet_Paths]
261(
262	[ApplicationId] ASC,
263	[LoweredPath] ASC
264)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]
265GO
266/****** Object:  Table [dbo].[aspnet_PersonalizationAllUsers]    Script Date: 16.2.2017. 14:59:48 ******/
267SET ANSI_NULLS ON
268GO
269SET QUOTED_IDENTIFIER ON
270GO
271CREATE TABLE [dbo].[aspnet_PersonalizationAllUsers](
272	[PathId] [uniqueidentifier] NOT NULL,
273	[PageSettings] [image] NOT NULL,
274	[LastUpdatedDate] [datetime] NOT NULL,
275PRIMARY KEY CLUSTERED 
276(
277	[PathId] ASC
278)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
279) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
280
281GO
282/****** Object:  Table [dbo].[aspnet_PersonalizationPerUser]    Script Date: 16.2.2017. 14:59:48 ******/
283SET ANSI_NULLS ON
284GO
285SET QUOTED_IDENTIFIER ON
286GO
287CREATE TABLE [dbo].[aspnet_PersonalizationPerUser](
288	[Id] [uniqueidentifier] NOT NULL,
289	[PathId] [uniqueidentifier] NULL,
290	[UserId] [uniqueidentifier] NULL,
291	[PageSettings] [image] NOT NULL,
292	[LastUpdatedDate] [datetime] NOT NULL,
293PRIMARY KEY NONCLUSTERED 
294(
295	[Id] ASC
296)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
297) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
298
299GO
300/****** Object:  Index [aspnet_PersonalizationPerUser_index1]    Script Date: 16.2.2017. 14:59:48 ******/
301CREATE UNIQUE CLUSTERED INDEX [aspnet_PersonalizationPerUser_index1] ON [dbo].[aspnet_PersonalizationPerUser]
302(
303	[PathId] ASC,
304	[UserId] ASC
305)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]
306GO
307/****** Object:  Table [dbo].[aspnet_Profile]    Script Date: 16.2.2017. 14:59:48 ******/
308SET ANSI_NULLS ON
309GO
310SET QUOTED_IDENTIFIER ON
311GO
312CREATE TABLE [dbo].[aspnet_Profile](
313	[UserId] [uniqueidentifier] NOT NULL,
314	[PropertyNames] [ntext] NOT NULL,
315	[PropertyValuesString] [ntext] NOT NULL,
316	[PropertyValuesBinary] [image] NOT NULL,
317	[LastUpdatedDate] [datetime] NOT NULL,
318PRIMARY KEY CLUSTERED 
319(
320	[UserId] ASC
321)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
322) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
323
324GO
325/****** Object:  Table [dbo].[aspnet_Roles]    Script Date: 16.2.2017. 14:59:48 ******/
326SET ANSI_NULLS ON
327GO
328SET QUOTED_IDENTIFIER ON
329GO
330CREATE TABLE [dbo].[aspnet_Roles](
331	[ApplicationId] [uniqueidentifier] NOT NULL,
332	[RoleId] [uniqueidentifier] NOT NULL,
333	[RoleName] [nvarchar](256) NOT NULL,
334	[LoweredRoleName] [nvarchar](256) NOT NULL,
335	[Description] [nvarchar](256) NULL,
336PRIMARY KEY NONCLUSTERED 
337(
338	[RoleId] ASC
339)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
340) ON [PRIMARY]
341
342GO
343SET ANSI_PADDING ON
344
345GO
346/****** Object:  Index [aspnet_Roles_index1]    Script Date: 16.2.2017. 14:59:48 ******/
347CREATE UNIQUE CLUSTERED INDEX [aspnet_Roles_index1] ON [dbo].[aspnet_Roles]
348(
349	[ApplicationId] ASC,
350	[LoweredRoleName] ASC
351)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]
352GO
353/****** Object:  Table [dbo].[aspnet_SchemaVersions]    Script Date: 16.2.2017. 14:59:48 ******/
354SET ANSI_NULLS ON
355GO
356SET QUOTED_IDENTIFIER ON
357GO
358CREATE TABLE [dbo].[aspnet_SchemaVersions](
359	[Feature] [nvarchar](128) NOT NULL,
360	[CompatibleSchemaVersion] [nvarchar](128) NOT NULL,
361	[IsCurrentVersion] [bit] NOT NULL,
362PRIMARY KEY CLUSTERED 
363(
364	[Feature] ASC,
365	[CompatibleSchemaVersion] ASC
366)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
367) ON [PRIMARY]
368
369GO
370/****** Object:  Table [dbo].[aspnet_Users]    Script Date: 16.2.2017. 14:59:48 ******/
371SET ANSI_NULLS ON
372GO
373SET QUOTED_IDENTIFIER ON
374GO
375CREATE TABLE [dbo].[aspnet_Users](
376	[ApplicationId] [uniqueidentifier] NOT NULL,
377	[UserId] [uniqueidentifier] NOT NULL,
378	[UserName] [nvarchar](256) NOT NULL,
379	[LoweredUserName] [nvarchar](256) NOT NULL,
380	[MobileAlias] [nvarchar](16) NULL,
381	[IsAnonymous] [bit] NOT NULL,
382	[LastActivityDate] [datetime] NOT NULL,
383PRIMARY KEY NONCLUSTERED 
384(
385	[UserId] ASC
386)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
387) ON [PRIMARY]
388
389GO
390SET ANSI_PADDING ON
391
392GO
393/****** Object:  Index [aspnet_Users_Index]    Script Date: 16.2.2017. 14:59:48 ******/
394CREATE UNIQUE CLUSTERED INDEX [aspnet_Users_Index] ON [dbo].[aspnet_Users]
395(
396	[ApplicationId] ASC,
397	[LoweredUserName] ASC
398)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]
399GO
400/****** Object:  Table [dbo].[aspnet_UsersInRoles]    Script Date: 16.2.2017. 14:59:48 ******/
401SET ANSI_NULLS ON
402GO
403SET QUOTED_IDENTIFIER ON
404GO
405CREATE TABLE [dbo].[aspnet_UsersInRoles](
406	[UserId] [uniqueidentifier] NOT NULL,
407	[RoleId] [uniqueidentifier] NOT NULL,
408PRIMARY KEY CLUSTERED 
409(
410	[UserId] ASC,
411	[RoleId] ASC
412)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
413) ON [PRIMARY]
414
415GO
416/****** Object:  Table [dbo].[aspnet_WebEvent_Events]    Script Date: 16.2.2017. 14:59:48 ******/
417SET ANSI_NULLS ON
418GO
419SET QUOTED_IDENTIFIER ON
420GO
421SET ANSI_PADDING ON
422GO
423CREATE TABLE [dbo].[aspnet_WebEvent_Events](
424	[EventId] [char](32) NOT NULL,
425	[EventTimeUtc] [datetime] NOT NULL,
426	[EventTime] [datetime] NOT NULL,
427	[EventType] [nvarchar](256) NOT NULL,
428	[EventSequence] [decimal](19, 0) NOT NULL,
429	[EventOccurrence] [decimal](19, 0) NOT NULL,
430	[EventCode] [int] NOT NULL,
431	[EventDetailCode] [int] NOT NULL,
432	[Message] [nvarchar](1024) NULL,
433	[ApplicationPath] [nvarchar](256) NULL,
434	[ApplicationVirtualPath] [nvarchar](256) NULL,
435	[MachineName] [nvarchar](256) NOT NULL,
436	[RequestUrl] [nvarchar](1024) NULL,
437	[ExceptionType] [nvarchar](256) NULL,
438	[Details] [ntext] NULL,
439PRIMARY KEY CLUSTERED 
440(
441	[EventId] ASC
442)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
443) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
444
445GO
446SET ANSI_PADDING OFF
447GO
448/****** Object:  Table [dbo].[Card]    Script Date: 16.2.2017. 14:59:48 ******/
449SET ANSI_NULLS ON
450GO
451SET QUOTED_IDENTIFIER ON
452GO
453CREATE TABLE [dbo].[Card](
454	[ID] [int] NOT NULL,
455 CONSTRAINT [PK_Card] PRIMARY KEY CLUSTERED 
456(
457	[ID] ASC
458)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
459) ON [PRIMARY]
460
461GO
462/****** Object:  Table [dbo].[CardMap]    Script Date: 16.2.2017. 14:59:48 ******/
463SET ANSI_NULLS ON
464GO
465SET QUOTED_IDENTIFIER ON
466GO
467CREATE TABLE [dbo].[CardMap](
468	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
469	[CardID] [int] NOT NULL,
470	[SortOrder] [int] NOT NULL,
471	[HasPopup] [bit] NOT NULL,
472	[PopupTop] [int] NULL,
473	[PopupLeft] [int] NULL,
474 CONSTRAINT [PK_CardMap] PRIMARY KEY CLUSTERED 
475(
476	[ID] ASC
477)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
478) ON [PRIMARY]
479
480GO
481/****** Object:  Table [dbo].[Contact]    Script Date: 16.2.2017. 14:59:48 ******/
482SET ANSI_NULLS ON
483GO
484SET QUOTED_IDENTIFIER ON
485GO
486CREATE TABLE [dbo].[Contact](
487	[ID] [uniqueidentifier] NOT NULL,
488	[TimeStamp] [datetime] NOT NULL,
489	[IPAddress] [nvarchar](100) NOT NULL,
490	[Name] [nvarchar](max) NOT NULL,
491	[Company] [nvarchar](max) NULL,
492	[Title] [nvarchar](100) NOT NULL,
493	[City] [nvarchar](100) NULL,
494	[ZIP] [nvarchar](10) NULL,
495	[State] [nvarchar](100) NULL,
496	[Country] [nvarchar](200) NULL,
497	[Email] [nvarchar](200) NOT NULL,
498	[Question] [nvarchar](max) NULL,
499	[JoinMailing] [bit] NOT NULL,
500	[RepresentativeContact] [bit] NOT NULL,
501 CONSTRAINT [PK_Contact] PRIMARY KEY CLUSTERED 
502(
503	[ID] ASC
504)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
505) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
506
507GO
508/****** Object:  Table [dbo].[GameEntry]    Script Date: 16.2.2017. 14:59:48 ******/
509SET ANSI_NULLS ON
510GO
511SET QUOTED_IDENTIFIER ON
512GO
513CREATE TABLE [dbo].[GameEntry](
514	[ID] [uniqueidentifier] NOT NULL,
515	[TimeStampStart] [datetime] NOT NULL,
516	[TimeStampEnd] [datetime] NULL,
517	[Finished] [bit] NOT NULL,
518	[TotalSeconds] [int] NOT NULL,
519	[IPAddress] [nvarchar](max) NOT NULL,
520	[Started] [bit] NOT NULL,
521	[Name] [nvarchar](200) NULL,
522	[Company] [nvarchar](200) NULL,
523	[Title] [nvarchar](200) NULL,
524	[ZIP] [nvarchar](50) NULL,
525	[Email] [nvarchar](200) NULL,
526	[Newsletter] [bit] NOT NULL,
527	[Rules] [bit] NOT NULL,
528	[EntryDone] [bit] NOT NULL,
529	[CardID] [int] NOT NULL,
530	[Kind] [int] NOT NULL,
531	[CustomerEmail] [nvarchar](200) NULL,
532	[AnswerID] [uniqueidentifier] NULL,
533	[Moves] [int] NOT NULL,
534	[Score] [int] NOT NULL,
535	[TwoMinuteClicks] [int] NOT NULL,
536 CONSTRAINT [PK_GameEntry] PRIMARY KEY CLUSTERED 
537(
538	[ID] ASC
539)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
540) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
541
542GO
543/****** Object:  Table [dbo].[QuizAnswer]    Script Date: 16.2.2017. 14:59:48 ******/
544SET ANSI_NULLS ON
545GO
546SET QUOTED_IDENTIFIER ON
547GO
548CREATE TABLE [dbo].[QuizAnswer](
549	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
550	[QuestionID] [uniqueidentifier] NOT NULL,
551	[Answer] [nvarchar](max) NOT NULL,
552	[Correct] [bit] NOT NULL,
553	[SortOrder] [int] NOT NULL,
554 CONSTRAINT [PK_QuizAnswer] PRIMARY KEY CLUSTERED 
555(
556	[ID] ASC
557)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
558) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
559
560GO
561/****** Object:  Table [dbo].[QuizQuestion]    Script Date: 16.2.2017. 14:59:48 ******/
562SET ANSI_NULLS ON
563GO
564SET QUOTED_IDENTIFIER ON
565GO
566CREATE TABLE [dbo].[QuizQuestion](
567	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
568	[Question] [nvarchar](max) NOT NULL,
569	[CardID] [int] NOT NULL,
570	[SortOrder] [int] NOT NULL,
571	[Response] [nvarchar](max) NULL,
572 CONSTRAINT [PK_QuizQuestion] PRIMARY KEY CLUSTERED 
573(
574	[ID] ASC
575)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
576) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
577
578GO
579/****** Object:  Table [dbo].[ReferralClicks]    Script Date: 16.2.2017. 14:59:48 ******/
580SET ANSI_NULLS ON
581GO
582SET QUOTED_IDENTIFIER ON
583GO
584CREATE TABLE [dbo].[ReferralClicks](
585	[ID] [uniqueidentifier] NOT NULL,
586	[URL] [nvarchar](max) NOT NULL,
587	[TimeStamp] [datetime] NOT NULL,
588 CONSTRAINT [PK_ReferralClicks] PRIMARY KEY CLUSTERED 
589(
590	[ID] ASC
591)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
592) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
593
594GO
595/****** Object:  Table [dbo].[TwoMinuteClicks]    Script Date: 16.2.2017. 14:59:48 ******/
596SET ANSI_NULLS ON
597GO
598SET QUOTED_IDENTIFIER ON
599GO
600CREATE TABLE [dbo].[TwoMinuteClicks](
601	[ID] [uniqueidentifier] NOT NULL,
602	[IPAddress] [nvarchar](100) NOT NULL,
603	[TimeStamp] [datetime] NOT NULL,
604	[Link] [nvarchar](100) NOT NULL,
605	[GameEntryID] [uniqueidentifier] NULL,
606 CONSTRAINT [PK_TwoMinuteClicks] PRIMARY KEY CLUSTERED 
607(
608	[ID] ASC
609)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
610) ON [PRIMARY]
611
612GO
613/****** Object:  Table [dbo].[Winner]    Script Date: 16.2.2017. 14:59:48 ******/
614SET ANSI_NULLS ON
615GO
616SET QUOTED_IDENTIFIER ON
617GO
618CREATE TABLE [dbo].[Winner](
619	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
620	[Date] [date] NOT NULL,
621	[Kind] [int] NOT NULL,
622	[WinnerKind] [int] NOT NULL,
623	[Name] [nvarchar](max) NOT NULL,
624	[Company] [nvarchar](max) NOT NULL,
625	[Email] [nvarchar](max) NOT NULL,
626 CONSTRAINT [PK_Winner] PRIMARY KEY CLUSTERED 
627(
628	[ID] ASC
629)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
630) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
631
632GO
633/****** Object:  View [dbo].[vw_aspnet_Applications]    Script Date: 16.2.2017. 14:59:48 ******/
634SET ANSI_NULLS ON
635GO
636SET QUOTED_IDENTIFIER OFF
637GO
638
639  CREATE VIEW [dbo].[vw_aspnet_Applications]
640  AS SELECT [dbo].[aspnet_Applications].[ApplicationName], [dbo].[aspnet_Applications].[LoweredApplicationName], [dbo].[aspnet_Applications].[ApplicationId], [dbo].[aspnet_Applications].[Description]
641  FROM [dbo].[aspnet_Applications]
642  
643GO
644/****** Object:  View [dbo].[vw_aspnet_MembershipUsers]    Script Date: 16.2.2017. 14:59:48 ******/
645SET ANSI_NULLS ON
646GO
647SET QUOTED_IDENTIFIER OFF
648GO
649
650  CREATE VIEW [dbo].[vw_aspnet_MembershipUsers]
651  AS SELECT [dbo].[aspnet_Membership].[UserId],
652            [dbo].[aspnet_Membership].[PasswordFormat],
653            [dbo].[aspnet_Membership].[MobilePIN],
654            [dbo].[aspnet_Membership].[Email],
655            [dbo].[aspnet_Membership].[LoweredEmail],
656            [dbo].[aspnet_Membership].[PasswordQuestion],
657            [dbo].[aspnet_Membership].[PasswordAnswer],
658            [dbo].[aspnet_Membership].[IsApproved],
659            [dbo].[aspnet_Membership].[IsLockedOut],
660            [dbo].[aspnet_Membership].[CreateDate],
661            [dbo].[aspnet_Membership].[LastLoginDate],
662            [dbo].[aspnet_Membership].[LastPasswordChangedDate],
663            [dbo].[aspnet_Membership].[LastLockoutDate],
664            [dbo].[aspnet_Membership].[FailedPasswordAttemptCount],
665            [dbo].[aspnet_Membership].[FailedPasswordAttemptWindowStart],
666            [dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptCount],
667            [dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptWindowStart],
668            [dbo].[aspnet_Membership].[Comment],
669            [dbo].[aspnet_Users].[ApplicationId],
670            [dbo].[aspnet_Users].[UserName],
671            [dbo].[aspnet_Users].[MobileAlias],
672            [dbo].[aspnet_Users].[IsAnonymous],
673            [dbo].[aspnet_Users].[LastActivityDate]
674  FROM [dbo].[aspnet_Membership] INNER JOIN [dbo].[aspnet_Users]
675      ON [dbo].[aspnet_Membership].[UserId] = [dbo].[aspnet_Users].[UserId]
676  
677GO
678/****** Object:  View [dbo].[vw_aspnet_Profiles]    Script Date: 16.2.2017. 14:59:48 ******/
679SET ANSI_NULLS ON
680GO
681SET QUOTED_IDENTIFIER OFF
682GO
683
684  CREATE VIEW [dbo].[vw_aspnet_Profiles]
685  AS SELECT [dbo].[aspnet_Profile].[UserId], [dbo].[aspnet_Profile].[LastUpdatedDate],
686      [DataSize]=  DATALENGTH([dbo].[aspnet_Profile].[PropertyNames])
687                 + DATALENGTH([dbo].[aspnet_Profile].[PropertyValuesString])
688                 + DATALENGTH([dbo].[aspnet_Profile].[PropertyValuesBinary])
689  FROM [dbo].[aspnet_Profile]
690  
691GO
692/****** Object:  View [dbo].[vw_aspnet_Roles]    Script Date: 16.2.2017. 14:59:48 ******/
693SET ANSI_NULLS ON
694GO
695SET QUOTED_IDENTIFIER OFF
696GO
697
698  CREATE VIEW [dbo].[vw_aspnet_Roles]
699  AS SELECT [dbo].[aspnet_Roles].[ApplicationId], [dbo].[aspnet_Roles].[RoleId], [dbo].[aspnet_Roles].[RoleName], [dbo].[aspnet_Roles].[LoweredRoleName], [dbo].[aspnet_Roles].[Description]
700  FROM [dbo].[aspnet_Roles]
701  
702GO
703/****** Object:  View [dbo].[vw_aspnet_Users]    Script Date: 16.2.2017. 14:59:48 ******/
704SET ANSI_NULLS ON
705GO
706SET QUOTED_IDENTIFIER OFF
707GO
708
709  CREATE VIEW [dbo].[vw_aspnet_Users]
710  AS SELECT [dbo].[aspnet_Users].[ApplicationId], [dbo].[aspnet_Users].[UserId], [dbo].[aspnet_Users].[UserName], [dbo].[aspnet_Users].[LoweredUserName], [dbo].[aspnet_Users].[MobileAlias], [dbo].[aspnet_Users].[IsAnonymous], [dbo].[aspnet_Users].[LastActivityDate]
711  FROM [dbo].[aspnet_Users]
712  
713GO
714/****** Object:  View [dbo].[vw_aspnet_UsersInRoles]    Script Date: 16.2.2017. 14:59:48 ******/
715SET ANSI_NULLS ON
716GO
717SET QUOTED_IDENTIFIER OFF
718GO
719
720  CREATE VIEW [dbo].[vw_aspnet_UsersInRoles]
721  AS SELECT [dbo].[aspnet_UsersInRoles].[UserId], [dbo].[aspnet_UsersInRoles].[RoleId]
722  FROM [dbo].[aspnet_UsersInRoles]
723  
724GO
725/****** Object:  View [dbo].[vw_aspnet_WebPartState_Paths]    Script Date: 16.2.2017. 14:59:48 ******/
726SET ANSI_NULLS ON
727GO
728SET QUOTED_IDENTIFIER OFF
729GO
730
731  CREATE VIEW [dbo].[vw_aspnet_WebPartState_Paths]
732  AS SELECT [dbo].[aspnet_Paths].[ApplicationId], [dbo].[aspnet_Paths].[PathId], [dbo].[aspnet_Paths].[Path], [dbo].[aspnet_Paths].[LoweredPath]
733  FROM [dbo].[aspnet_Paths]
734  
735GO
736/****** Object:  View [dbo].[vw_aspnet_WebPartState_Shared]    Script Date: 16.2.2017. 14:59:48 ******/
737SET ANSI_NULLS ON
738GO
739SET QUOTED_IDENTIFIER OFF
740GO
741
742  CREATE VIEW [dbo].[vw_aspnet_WebPartState_Shared]
743  AS SELECT [dbo].[aspnet_PersonalizationAllUsers].[PathId], [DataSize]=DATALENGTH([dbo].[aspnet_PersonalizationAllUsers].[PageSettings]), [dbo].[aspnet_PersonalizationAllUsers].[LastUpdatedDate]
744  FROM [dbo].[aspnet_PersonalizationAllUsers]
745  
746GO
747/****** Object:  View [dbo].[vw_aspnet_WebPartState_User]    Script Date: 16.2.2017. 14:59:48 ******/
748SET ANSI_NULLS ON
749GO
750SET QUOTED_IDENTIFIER OFF
751GO
752
753  CREATE VIEW [dbo].[vw_aspnet_WebPartState_User]
754  AS SELECT [dbo].[aspnet_PersonalizationPerUser].[PathId], [dbo].[aspnet_PersonalizationPerUser].[UserId], [DataSize]=DATALENGTH([dbo].[aspnet_PersonalizationPerUser].[PageSettings]), [dbo].[aspnet_PersonalizationPerUser].[LastUpdatedDate]
755  FROM [dbo].[aspnet_PersonalizationPerUser]
756  
757GO
758/****** Object:  Index [aspnet_PersonalizationPerUser_ncindex2]    Script Date: 16.2.2017. 14:59:48 ******/
759CREATE UNIQUE NONCLUSTERED INDEX [aspnet_PersonalizationPerUser_ncindex2] ON [dbo].[aspnet_PersonalizationPerUser]
760(
761	[UserId] ASC,
762	[PathId] ASC
763)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]
764GO
765/****** Object:  Index [aspnet_Users_Index2]    Script Date: 16.2.2017. 14:59:48 ******/
766CREATE NONCLUSTERED INDEX [aspnet_Users_Index2] ON [dbo].[aspnet_Users]
767(
768	[ApplicationId] ASC,
769	[LastActivityDate] ASC
770)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]
771GO
772/****** Object:  Index [aspnet_UsersInRoles_index]    Script Date: 16.2.2017. 14:59:48 ******/
773CREATE NONCLUSTERED INDEX [aspnet_UsersInRoles_index] ON [dbo].[aspnet_UsersInRoles]
774(
775	[RoleId] ASC
776)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]
777GO
778ALTER TABLE [dbo].[aspnet_Applications] ADD  DEFAULT (newid()) FOR [ApplicationId]
779GO
780ALTER TABLE [dbo].[aspnet_Membership] ADD  DEFAULT ((0)) FOR [PasswordFormat]
781GO
782ALTER TABLE [dbo].[aspnet_Paths] ADD  DEFAULT (newid()) FOR [PathId]
783GO
784ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] ADD  DEFAULT (newid()) FOR [Id]
785GO
786ALTER TABLE [dbo].[aspnet_Roles] ADD  DEFAULT (newid()) FOR [RoleId]
787GO
788ALTER TABLE [dbo].[aspnet_Users] ADD  DEFAULT (newid()) FOR [UserId]
789GO
790ALTER TABLE [dbo].[aspnet_Users] ADD  DEFAULT (NULL) FOR [MobileAlias]
791GO
792ALTER TABLE [dbo].[aspnet_Users] ADD  DEFAULT ((0)) FOR [IsAnonymous]
793GO
794ALTER TABLE [dbo].[CardMap] ADD  CONSTRAINT [DF_CardMap_ID]  DEFAULT (newid()) FOR [ID]
795GO
796ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_Finished]  DEFAULT ((0)) FOR [Finished]
797GO
798ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_Started]  DEFAULT ((0)) FOR [Started]
799GO
800ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_Newsletter]  DEFAULT ((0)) FOR [Newsletter]
801GO
802ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_Rules]  DEFAULT ((0)) FOR [Rules]
803GO
804ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_EntryDone]  DEFAULT ((0)) FOR [EntryDone]
805GO
806ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_CardID]  DEFAULT ((1)) FOR [CardID]
807GO
808ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_Kind]  DEFAULT ((1)) FOR [Kind]
809GO
810ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_Moves]  DEFAULT ((0)) FOR [Moves]
811GO
812ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_Score]  DEFAULT ((0)) FOR [Score]
813GO
814ALTER TABLE [dbo].[GameEntry] ADD  CONSTRAINT [DF_GameEntry_TwoMinuteClicks]  DEFAULT ((0)) FOR [TwoMinuteClicks]
815GO
816ALTER TABLE [dbo].[QuizAnswer] ADD  CONSTRAINT [DF_QuizAnswer_ID]  DEFAULT (newid()) FOR [ID]
817GO
818ALTER TABLE [dbo].[QuizAnswer] ADD  CONSTRAINT [DF_QuizAnswer_Correct]  DEFAULT ((0)) FOR [Correct]
819GO
820ALTER TABLE [dbo].[QuizAnswer] ADD  CONSTRAINT [DF_QuizAnswer_SortOrder]  DEFAULT ((0)) FOR [SortOrder]
821GO
822ALTER TABLE [dbo].[QuizQuestion] ADD  CONSTRAINT [DF_QuizQuestion_ID]  DEFAULT (newid()) FOR [ID]
823GO
824ALTER TABLE [dbo].[Winner] ADD  CONSTRAINT [DF_Winner_ID]  DEFAULT (newid()) FOR [ID]
825GO
826ALTER TABLE [dbo].[aspnet_Membership]  WITH CHECK ADD FOREIGN KEY([ApplicationId])
827REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
828GO
829ALTER TABLE [dbo].[aspnet_Membership]  WITH CHECK ADD FOREIGN KEY([UserId])
830REFERENCES [dbo].[aspnet_Users] ([UserId])
831GO
832ALTER TABLE [dbo].[aspnet_Paths]  WITH CHECK ADD FOREIGN KEY([ApplicationId])
833REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
834GO
835ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers]  WITH CHECK ADD FOREIGN KEY([PathId])
836REFERENCES [dbo].[aspnet_Paths] ([PathId])
837GO
838ALTER TABLE [dbo].[aspnet_PersonalizationPerUser]  WITH CHECK ADD FOREIGN KEY([PathId])
839REFERENCES [dbo].[aspnet_Paths] ([PathId])
840GO
841ALTER TABLE [dbo].[aspnet_PersonalizationPerUser]  WITH CHECK ADD FOREIGN KEY([UserId])
842REFERENCES [dbo].[aspnet_Users] ([UserId])
843GO
844ALTER TABLE [dbo].[aspnet_Profile]  WITH CHECK ADD FOREIGN KEY([UserId])
845REFERENCES [dbo].[aspnet_Users] ([UserId])
846GO
847ALTER TABLE [dbo].[aspnet_Roles]  WITH CHECK ADD FOREIGN KEY([ApplicationId])
848REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
849GO
850ALTER TABLE [dbo].[aspnet_Users]  WITH CHECK ADD FOREIGN KEY([ApplicationId])
851REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
852GO
853ALTER TABLE [dbo].[aspnet_UsersInRoles]  WITH CHECK ADD FOREIGN KEY([RoleId])
854REFERENCES [dbo].[aspnet_Roles] ([RoleId])
855GO
856ALTER TABLE [dbo].[aspnet_UsersInRoles]  WITH CHECK ADD FOREIGN KEY([UserId])
857REFERENCES [dbo].[aspnet_Users] ([UserId])
858GO
859ALTER TABLE [dbo].[CardMap]  WITH CHECK ADD  CONSTRAINT [FK_CardMap_Card] FOREIGN KEY([CardID])
860REFERENCES [dbo].[Card] ([ID])
861GO
862ALTER TABLE [dbo].[CardMap] CHECK CONSTRAINT [FK_CardMap_Card]
863GO
864ALTER TABLE [dbo].[GameEntry]  WITH CHECK ADD  CONSTRAINT [FK_GameEntry_Card] FOREIGN KEY([CardID])
865REFERENCES [dbo].[Card] ([ID])
866GO
867ALTER TABLE [dbo].[GameEntry] CHECK CONSTRAINT [FK_GameEntry_Card]
868GO
869ALTER TABLE [dbo].[GameEntry]  WITH CHECK ADD  CONSTRAINT [FK_GameEntry_QuizAnswer] FOREIGN KEY([AnswerID])
870REFERENCES [dbo].[QuizAnswer] ([ID])
871GO
872ALTER TABLE [dbo].[GameEntry] CHECK CONSTRAINT [FK_GameEntry_QuizAnswer]
873GO
874ALTER TABLE [dbo].[QuizAnswer]  WITH CHECK ADD  CONSTRAINT [FK_QuizAnswer_QuizQuestion] FOREIGN KEY([QuestionID])
875REFERENCES [dbo].[QuizQuestion] ([ID])
876GO
877ALTER TABLE [dbo].[QuizAnswer] CHECK CONSTRAINT [FK_QuizAnswer_QuizQuestion]
878GO
879ALTER TABLE [dbo].[TwoMinuteClicks]  WITH CHECK ADD  CONSTRAINT [FK_TwoMinuteClicks_GameEntry] FOREIGN KEY([GameEntryID])
880REFERENCES [dbo].[GameEntry] ([ID])
881GO
882ALTER TABLE [dbo].[TwoMinuteClicks] CHECK CONSTRAINT [FK_TwoMinuteClicks_GameEntry]
883GO
884/****** Object:  StoredProcedure [dbo].[aspnet_AnyDataInTables]    Script Date: 16.2.2017. 14:59:48 ******/
885SET ANSI_NULLS ON
886GO
887SET QUOTED_IDENTIFIER OFF
888GO
889CREATE PROCEDURE [dbo].[aspnet_AnyDataInTables]
890    @TablesToCheck int
891AS
892BEGIN
893    -- Check Membership table if (@TablesToCheck & 1) is set
894    IF ((@TablesToCheck & 1) <> 0 AND
895        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_MembershipUsers') AND (type = 'V'))))
896    BEGIN
897        IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Membership))
898        BEGIN
899            SELECT N'aspnet_Membership'
900            RETURN
901        END
902    END
903
904    -- Check aspnet_Roles table if (@TablesToCheck & 2) is set
905    IF ((@TablesToCheck & 2) <> 0  AND
906        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_Roles') AND (type = 'V'))) )
907    BEGIN
908        IF (EXISTS(SELECT TOP 1 RoleId FROM dbo.aspnet_Roles))
909        BEGIN
910            SELECT N'aspnet_Roles'
911            RETURN
912        END
913    END
914
915    -- Check aspnet_Profile table if (@TablesToCheck & 4) is set
916    IF ((@TablesToCheck & 4) <> 0  AND
917        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_Profiles') AND (type = 'V'))) )
918    BEGIN
919        IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Profile))
920        BEGIN
921            SELECT N'aspnet_Profile'
922            RETURN
923        END
924    END
925
926    -- Check aspnet_PersonalizationPerUser table if (@TablesToCheck & 8) is set
927    IF ((@TablesToCheck & 8) <> 0  AND
928        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_WebPartState_User') AND (type = 'V'))) )
929    BEGIN
930        IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_PersonalizationPerUser))
931        BEGIN
932            SELECT N'aspnet_PersonalizationPerUser'
933            RETURN
934        END
935    END
936
937    -- Check aspnet_PersonalizationPerUser table if (@TablesToCheck & 16) is set
938    IF ((@TablesToCheck & 16) <> 0  AND
939        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'aspnet_WebEvent_LogEvent') AND (type = 'P'))) )
940    BEGIN
941        IF (EXISTS(SELECT TOP 1 * FROM dbo.aspnet_WebEvent_Events))
942        BEGIN
943            SELECT N'aspnet_WebEvent_Events'
944            RETURN
945        END
946    END
947
948    -- Check aspnet_Users table if (@TablesToCheck & 1,2,4 & 8) are all set
949    IF ((@TablesToCheck & 1) <> 0 AND
950        (@TablesToCheck & 2) <> 0 AND
951        (@TablesToCheck & 4) <> 0 AND
952        (@TablesToCheck & 8) <> 0 AND
953        (@TablesToCheck & 32) <> 0 AND
954        (@TablesToCheck & 128) <> 0 AND
955        (@TablesToCheck & 256) <> 0 AND
956        (@TablesToCheck & 512) <> 0 AND
957        (@TablesToCheck & 1024) <> 0)
958    BEGIN
959        IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Users))
960        BEGIN
961            SELECT N'aspnet_Users'
962            RETURN
963        END
964        IF (EXISTS(SELECT TOP 1 ApplicationId FROM dbo.aspnet_Applications))
965        BEGIN
966            SELECT N'aspnet_Applications'
967            RETURN
968        END
969    END
970END
971GO
972/****** Object:  StoredProcedure [dbo].[aspnet_Applications_CreateApplication]    Script Date: 16.2.2017. 14:59:48 ******/
973SET ANSI_NULLS ON
974GO
975SET QUOTED_IDENTIFIER OFF
976GO
977
978CREATE PROCEDURE [dbo].[aspnet_Applications_CreateApplication]
979    @ApplicationName      nvarchar(256),
980    @ApplicationId        uniqueidentifier OUTPUT
981AS
982BEGIN
983    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
984
985    IF(@ApplicationId IS NULL)
986    BEGIN
987        DECLARE @TranStarted   bit
988        SET @TranStarted = 0
989
990        IF( @@TRANCOUNT = 0 )
991        BEGIN
992	        BEGIN TRANSACTION
993	        SET @TranStarted = 1
994        END
995        ELSE
996    	    SET @TranStarted = 0
997
998        SELECT  @ApplicationId = ApplicationId
999        FROM dbo.aspnet_Applications WITH (UPDLOCK, HOLDLOCK)
1000        WHERE LOWER(@ApplicationName) = LoweredApplicationName
1001
1002        IF(@ApplicationId IS NULL)
1003        BEGIN
1004            SELECT  @ApplicationId = NEWID()
1005            INSERT  dbo.aspnet_Applications (ApplicationId, ApplicationName, LoweredApplicationName)
1006            VALUES  (@ApplicationId, @ApplicationName, LOWER(@ApplicationName))
1007        END
1008
1009
1010        IF( @TranStarted = 1 )
1011        BEGIN
1012            IF(@@ERROR = 0)
1013            BEGIN
1014	        SET @TranStarted = 0
1015	        COMMIT TRANSACTION
1016            END
1017            ELSE
1018            BEGIN
1019                SET @TranStarted = 0
1020                ROLLBACK TRANSACTION
1021            END
1022        END
1023    END
1024END
1025GO
1026/****** Object:  StoredProcedure [dbo].[aspnet_CheckSchemaVersion]    Script Date: 16.2.2017. 14:59:48 ******/
1027SET ANSI_NULLS ON
1028GO
1029SET QUOTED_IDENTIFIER OFF
1030GO
1031
1032CREATE PROCEDURE [dbo].[aspnet_CheckSchemaVersion]
1033    @Feature                   nvarchar(128),
1034    @CompatibleSchemaVersion   nvarchar(128)
1035AS
1036BEGIN
1037    IF (EXISTS( SELECT  *
1038                FROM    dbo.aspnet_SchemaVersions
1039                WHERE   Feature = LOWER( @Feature ) AND
1040                        CompatibleSchemaVersion = @CompatibleSchemaVersion ))
1041        RETURN 0
1042
1043    RETURN 1
1044END
1045GO
1046/****** Object:  StoredProcedure [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]    Script Date: 16.2.2017. 14:59:48 ******/
1047SET ANSI_NULLS ON
1048GO
1049SET QUOTED_IDENTIFIER OFF
1050GO
1051CREATE PROCEDURE [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]
1052    @ApplicationName       nvarchar(256),
1053    @UserName              nvarchar(256),
1054    @NewPasswordQuestion   nvarchar(256),
1055    @NewPasswordAnswer     nvarchar(128)
1056AS
1057BEGIN
1058    DECLARE @UserId uniqueidentifier
1059    SELECT  @UserId = NULL
1060    SELECT  @UserId = u.UserId
1061    FROM    dbo.aspnet_Membership m, dbo.aspnet_Users u, dbo.aspnet_Applications a
1062    WHERE   LoweredUserName = LOWER(@UserName) AND
1063            u.ApplicationId = a.ApplicationId  AND
1064            LOWER(@ApplicationName) = a.LoweredApplicationName AND
1065            u.UserId = m.UserId
1066    IF (@UserId IS NULL)
1067    BEGIN
1068        RETURN(1)
1069    END
1070
1071    UPDATE dbo.aspnet_Membership
1072    SET    PasswordQuestion = @NewPasswordQuestion, PasswordAnswer = @NewPasswordAnswer
1073    WHERE  UserId=@UserId
1074    RETURN(0)
1075END
1076GO
1077/****** Object:  StoredProcedure [dbo].[aspnet_Membership_CreateUser]    Script Date: 16.2.2017. 14:59:48 ******/
1078SET ANSI_NULLS ON
1079GO
1080SET QUOTED_IDENTIFIER OFF
1081GO
1082CREATE PROCEDURE [dbo].[aspnet_Membership_CreateUser]
1083    @ApplicationName                        nvarchar(256),
1084    @UserName                               nvarchar(256),
1085    @Password                               nvarchar(128),
1086    @PasswordSalt                           nvarchar(128),
1087    @Email                                  nvarchar(256),
1088    @PasswordQuestion                       nvarchar(256),
1089    @PasswordAnswer                         nvarchar(128),
1090    @IsApproved                             bit,
1091    @CurrentTimeUtc                         datetime,
1092    @CreateDate                             datetime = NULL,
1093    @UniqueEmail                            int      = 0,
1094    @PasswordFormat                         int      = 0,
1095    @UserId                                 uniqueidentifier OUTPUT
1096AS
1097BEGIN
1098    DECLARE @ApplicationId uniqueidentifier
1099    SELECT  @ApplicationId = NULL
1100
1101    DECLARE @NewUserId uniqueidentifier
1102    SELECT @NewUserId = NULL
1103
1104    DECLARE @IsLockedOut bit
1105    SET @IsLockedOut = 0
1106
1107    DECLARE @LastLockoutDate  datetime
1108    SET @LastLockoutDate = CONVERT( datetime, '17540101', 112 )
1109
1110    DECLARE @FailedPasswordAttemptCount int
1111    SET @FailedPasswordAttemptCount = 0
1112
1113    DECLARE @FailedPasswordAttemptWindowStart  datetime
1114    SET @FailedPasswordAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
1115
1116    DECLARE @FailedPasswordAnswerAttemptCount int
1117    SET @FailedPasswordAnswerAttemptCount = 0
1118
1119    DECLARE @FailedPasswordAnswerAttemptWindowStart  datetime
1120    SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
1121
1122    DECLARE @NewUserCreated bit
1123    DECLARE @ReturnValue   int
1124    SET @ReturnValue = 0
1125
1126    DECLARE @ErrorCode     int
1127    SET @ErrorCode = 0
1128
1129    DECLARE @TranStarted   bit
1130    SET @TranStarted = 0
1131
1132    IF( @@TRANCOUNT = 0 )
1133    BEGIN
1134	    BEGIN TRANSACTION
1135	    SET @TranStarted = 1
1136    END
1137    ELSE
1138    	SET @TranStarted = 0
1139
1140    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT
1141
1142    IF( @@ERROR <> 0 )
1143    BEGIN
1144        SET @ErrorCode = -1
1145        GOTO Cleanup
1146    END
1147
1148    SET @CreateDate = @CurrentTimeUtc
1149
1150    SELECT  @NewUserId = UserId FROM dbo.aspnet_Users WHERE LOWER(@UserName) = LoweredUserName AND @ApplicationId = ApplicationId
1151    IF ( @NewUserId IS NULL )
1152    BEGIN
1153        SET @NewUserId = @UserId
1154        EXEC @ReturnValue = dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, 0, @CreateDate, @NewUserId OUTPUT
1155        SET @NewUserCreated = 1
1156    END
1157    ELSE
1158    BEGIN
1159        SET @NewUserCreated = 0
1160        IF( @NewUserId <> @UserId AND @UserId IS NOT NULL )
1161        BEGIN
1162            SET @ErrorCode = 6
1163            GOTO Cleanup
1164        END
1165    END
1166
1167    IF( @@ERROR <> 0 )
1168    BEGIN
1169        SET @ErrorCode = -1
1170        GOTO Cleanup
1171    END
1172
1173    IF( @ReturnValue = -1 )
1174    BEGIN
1175        SET @ErrorCode = 10
1176        GOTO Cleanup
1177    END
1178
1179    IF ( EXISTS ( SELECT UserId
1180                  FROM   dbo.aspnet_Membership
1181                  WHERE  @NewUserId = UserId ) )
1182    BEGIN
1183        SET @ErrorCode = 6
1184        GOTO Cleanup
1185    END
1186
1187    SET @UserId = @NewUserId
1188
1189    IF (@UniqueEmail = 1)
1190    BEGIN
1191        IF (EXISTS (SELECT *
1192                    FROM  dbo.aspnet_Membership m WITH ( UPDLOCK, HOLDLOCK )
1193                    WHERE ApplicationId = @ApplicationId AND LoweredEmail = LOWER(@Email)))
1194        BEGIN
1195            SET @ErrorCode = 7
1196            GOTO Cleanup
1197        END
1198    END
1199
1200    IF (@NewUserCreated = 0)
1201    BEGIN
1202        UPDATE dbo.aspnet_Users
1203        SET    LastActivityDate = @CreateDate
1204        WHERE  @UserId = UserId
1205        IF( @@ERROR <> 0 )
1206        BEGIN
1207            SET @ErrorCode = -1
1208            GOTO Cleanup
1209        END
1210    END
1211
1212    INSERT INTO dbo.aspnet_Membership
1213                ( ApplicationId,
1214                  UserId,
1215                  Password,
1216                  PasswordSalt,
1217                  Email,
1218                  LoweredEmail,
1219                  PasswordQuestion,
1220                  PasswordAnswer,
1221                  PasswordFormat,
1222                  IsApproved,
1223                  IsLockedOut,
1224                  CreateDate,
1225                  LastLoginDate,
1226                  LastPasswordChangedDate,
1227                  LastLockoutDate,
1228                  FailedPasswordAttemptCount,
1229                  FailedPasswordAttemptWindowStart,
1230                  FailedPasswordAnswerAttemptCount,
1231                  FailedPasswordAnswerAttemptWindowStart )
1232         VALUES ( @ApplicationId,
1233                  @UserId,
1234                  @Password,
1235                  @PasswordSalt,
1236                  @Email,
1237                  LOWER(@Email),
1238                  @PasswordQuestion,
1239                  @PasswordAnswer,
1240                  @PasswordFormat,
1241                  @IsApproved,
1242                  @IsLockedOut,
1243                  @CreateDate,
1244                  @CreateDate,
1245                  @CreateDate,
1246                  @LastLockoutDate,
1247                  @FailedPasswordAttemptCount,
1248                  @FailedPasswordAttemptWindowStart,
1249                  @FailedPasswordAnswerAttemptCount,
1250                  @FailedPasswordAnswerAttemptWindowStart )
1251
1252    IF( @@ERROR <> 0 )
1253    BEGIN
1254        SET @ErrorCode = -1
1255        GOTO Cleanup
1256    END
1257
1258    IF( @TranStarted = 1 )
1259    BEGIN
1260	    SET @TranStarted = 0
1261	    COMMIT TRANSACTION
1262    END
1263
1264    RETURN 0
1265
1266Cleanup:
1267
1268    IF( @TranStarted = 1 )
1269    BEGIN
1270        SET @TranStarted = 0
1271    	ROLLBACK TRANSACTION
1272    END
1273
1274    RETURN @ErrorCode
1275
1276END
1277GO
1278/****** Object:  StoredProcedure [dbo].[aspnet_Membership_FindUsersByEmail]    Script Date: 16.2.2017. 14:59:48 ******/
1279SET ANSI_NULLS ON
1280GO
1281SET QUOTED_IDENTIFIER OFF
1282GO
1283CREATE PROCEDURE [dbo].[aspnet_Membership_FindUsersByEmail]
1284    @ApplicationName       nvarchar(256),
1285    @EmailToMatch          nvarchar(256),
1286    @PageIndex             int,
1287    @PageSize              int
1288AS
1289BEGIN
1290    DECLARE @ApplicationId uniqueidentifier
1291    SELECT  @ApplicationId = NULL
1292    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
1293    IF (@ApplicationId IS NULL)
1294        RETURN 0
1295
1296    -- Set the page bounds
1297    DECLARE @PageLowerBound int
1298    DECLARE @PageUpperBound int
1299    DECLARE @TotalRecords   int
1300    SET @PageLowerBound = @PageSize * @PageIndex
1301    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound
1302
1303    -- Create a temp table TO store the select results
1304    CREATE TABLE #PageIndexForUsers
1305    (
1306        IndexId int IDENTITY (0, 1) NOT NULL,
1307        UserId uniqueidentifier
1308    )
1309
1310    -- Insert into our temp table
1311    IF( @EmailToMatch IS NULL )
1312        INSERT INTO #PageIndexForUsers (UserId)
1313            SELECT u.UserId
1314            FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m
1315            WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND m.Email IS NULL
1316            ORDER BY m.LoweredEmail
1317    ELSE
1318        INSERT INTO #PageIndexForUsers (UserId)
1319            SELECT u.UserId
1320            FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m
1321            WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND m.LoweredEmail LIKE LOWER(@EmailToMatch)
1322            ORDER BY m.LoweredEmail
1323
1324    SELECT  u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
1325            m.CreateDate,
1326            m.LastLoginDate,
1327            u.LastActivityDate,
1328            m.LastPasswordChangedDate,
1329            u.UserId, m.IsLockedOut,
1330            m.LastLockoutDate
1331    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p
1332    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND
1333           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound
1334    ORDER BY m.LoweredEmail
1335
1336    SELECT  @TotalRecords = COUNT(*)
1337    FROM    #PageIndexForUsers
1338    RETURN @TotalRecords
1339END
1340GO
1341/****** Object:  StoredProcedure [dbo].[aspnet_Membership_FindUsersByName]    Script Date: 16.2.2017. 14:59:48 ******/
1342SET ANSI_NULLS ON
1343GO
1344SET QUOTED_IDENTIFIER OFF
1345GO
1346CREATE PROCEDURE [dbo].[aspnet_Membership_FindUsersByName]
1347    @ApplicationName       nvarchar(256),
1348    @UserNameToMatch       nvarchar(256),
1349    @PageIndex             int,
1350    @PageSize              int
1351AS
1352BEGIN
1353    DECLARE @ApplicationId uniqueidentifier
1354    SELECT  @ApplicationId = NULL
1355    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
1356    IF (@ApplicationId IS NULL)
1357        RETURN 0
1358
1359    -- Set the page bounds
1360    DECLARE @PageLowerBound int
1361    DECLARE @PageUpperBound int
1362    DECLARE @TotalRecords   int
1363    SET @PageLowerBound = @PageSize * @PageIndex
1364    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound
1365
1366    -- Create a temp table TO store the select results
1367    CREATE TABLE #PageIndexForUsers
1368    (
1369        IndexId int IDENTITY (0, 1) NOT NULL,
1370        UserId uniqueidentifier
1371    )
1372
1373    -- Insert into our temp table
1374    INSERT INTO #PageIndexForUsers (UserId)
1375        SELECT u.UserId
1376        FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m
1377        WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND u.LoweredUserName LIKE LOWER(@UserNameToMatch)
1378        ORDER BY u.UserName
1379
1380
1381    SELECT  u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
1382            m.CreateDate,
1383            m.LastLoginDate,
1384            u.LastActivityDate,
1385            m.LastPasswordChangedDate,
1386            u.UserId, m.IsLockedOut,
1387            m.LastLockoutDate
1388    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p
1389    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND
1390           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound
1391    ORDER BY u.UserName
1392
1393    SELECT  @TotalRecords = COUNT(*)
1394    FROM    #PageIndexForUsers
1395    RETURN @TotalRecords
1396END
1397GO
1398/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetAllUsers]    Script Date: 16.2.2017. 14:59:48 ******/
1399SET ANSI_NULLS ON
1400GO
1401SET QUOTED_IDENTIFIER OFF
1402GO
1403CREATE PROCEDURE [dbo].[aspnet_Membership_GetAllUsers]
1404    @ApplicationName       nvarchar(256),
1405    @PageIndex             int,
1406    @PageSize              int
1407AS
1408BEGIN
1409    DECLARE @ApplicationId uniqueidentifier
1410    SELECT  @ApplicationId = NULL
1411    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
1412    IF (@ApplicationId IS NULL)
1413        RETURN 0
1414
1415
1416    -- Set the page bounds
1417    DECLARE @PageLowerBound int
1418    DECLARE @PageUpperBound int
1419    DECLARE @TotalRecords   int
1420    SET @PageLowerBound = @PageSize * @PageIndex
1421    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound
1422
1423    -- Create a temp table TO store the select results
1424    CREATE TABLE #PageIndexForUsers
1425    (
1426        IndexId int IDENTITY (0, 1) NOT NULL,
1427        UserId uniqueidentifier
1428    )
1429
1430    -- Insert into our temp table
1431    INSERT INTO #PageIndexForUsers (UserId)
1432    SELECT u.UserId
1433    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u
1434    WHERE  u.ApplicationId = @ApplicationId AND u.UserId = m.UserId
1435    ORDER BY u.UserName
1436
1437    SELECT @TotalRecords = @@ROWCOUNT
1438
1439    SELECT u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
1440            m.CreateDate,
1441            m.LastLoginDate,
1442            u.LastActivityDate,
1443            m.LastPasswordChangedDate,
1444            u.UserId, m.IsLockedOut,
1445            m.LastLockoutDate
1446    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p
1447    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND
1448           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound
1449    ORDER BY u.UserName
1450    RETURN @TotalRecords
1451END
1452GO
1453/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetNumberOfUsersOnline]    Script Date: 16.2.2017. 14:59:48 ******/
1454SET ANSI_NULLS ON
1455GO
1456SET QUOTED_IDENTIFIER OFF
1457GO
1458CREATE PROCEDURE [dbo].[aspnet_Membership_GetNumberOfUsersOnline]
1459    @ApplicationName            nvarchar(256),
1460    @MinutesSinceLastInActive   int,
1461    @CurrentTimeUtc             datetime
1462AS
1463BEGIN
1464    DECLARE @DateActive datetime
1465    SELECT  @DateActive = DATEADD(minute,  -(@MinutesSinceLastInActive), @CurrentTimeUtc)
1466
1467    DECLARE @NumOnline int
1468    SELECT  @NumOnline = COUNT(*)
1469    FROM    dbo.aspnet_Users u(NOLOCK),
1470            dbo.aspnet_Applications a(NOLOCK),
1471            dbo.aspnet_Membership m(NOLOCK)
1472    WHERE   u.ApplicationId = a.ApplicationId                  AND
1473            LastActivityDate > @DateActive                     AND
1474            a.LoweredApplicationName = LOWER(@ApplicationName) AND
1475            u.UserId = m.UserId
1476    RETURN(@NumOnline)
1477END
1478GO
1479/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetPassword]    Script Date: 16.2.2017. 14:59:48 ******/
1480SET ANSI_NULLS ON
1481GO
1482SET QUOTED_IDENTIFIER OFF
1483GO
1484CREATE PROCEDURE [dbo].[aspnet_Membership_GetPassword]
1485    @ApplicationName                nvarchar(256),
1486    @UserName                       nvarchar(256),
1487    @MaxInvalidPasswordAttempts     int,
1488    @PasswordAttemptWindow          int,
1489    @CurrentTimeUtc                 datetime,
1490    @PasswordAnswer                 nvarchar(128) = NULL
1491AS
1492BEGIN
1493    DECLARE @UserId                                 uniqueidentifier
1494    DECLARE @PasswordFormat                         int
1495    DECLARE @Password                               nvarchar(128)
1496    DECLARE @passAns                                nvarchar(128)
1497    DECLARE @IsLockedOut                            bit
1498    DECLARE @LastLockoutDate                        datetime
1499    DECLARE @FailedPasswordAttemptCount             int
1500    DECLARE @FailedPasswordAttemptWindowStart       datetime
1501    DECLARE @FailedPasswordAnswerAttemptCount       int
1502    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime
1503
1504    DECLARE @ErrorCode     int
1505    SET @ErrorCode = 0
1506
1507    DECLARE @TranStarted   bit
1508    SET @TranStarted = 0
1509
1510    IF( @@TRANCOUNT = 0 )
1511    BEGIN
1512	    BEGIN TRANSACTION
1513	    SET @TranStarted = 1
1514    END
1515    ELSE
1516    	SET @TranStarted = 0
1517
1518    SELECT  @UserId = u.UserId,
1519            @Password = m.Password,
1520            @passAns = m.PasswordAnswer,
1521            @PasswordFormat = m.PasswordFormat,
1522            @IsLockedOut = m.IsLockedOut,
1523            @LastLockoutDate = m.LastLockoutDate,
1524            @FailedPasswordAttemptCount = m.FailedPasswordAttemptCount,
1525            @FailedPasswordAttemptWindowStart = m.FailedPasswordAttemptWindowStart,
1526            @FailedPasswordAnswerAttemptCount = m.FailedPasswordAnswerAttemptCount,
1527            @FailedPasswordAnswerAttemptWindowStart = m.FailedPasswordAnswerAttemptWindowStart
1528    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m WITH ( UPDLOCK )
1529    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
1530            u.ApplicationId = a.ApplicationId    AND
1531            u.UserId = m.UserId AND
1532            LOWER(@UserName) = u.LoweredUserName
1533
1534    IF ( @@rowcount = 0 )
1535    BEGIN
1536        SET @ErrorCode = 1
1537        GOTO Cleanup
1538    END
1539
1540    IF( @IsLockedOut = 1 )
1541    BEGIN
1542        SET @ErrorCode = 99
1543        GOTO Cleanup
1544    END
1545
1546    IF ( NOT( @PasswordAnswer IS NULL ) )
1547    BEGIN
1548        IF( ( @passAns IS NULL ) OR ( LOWER( @passAns ) <> LOWER( @PasswordAnswer ) ) )
1549        BEGIN
1550            IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAnswerAttemptWindowStart ) )
1551            BEGIN
1552                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc
1553                SET @FailedPasswordAnswerAttemptCount = 1
1554            END
1555            ELSE
1556            BEGIN
1557                SET @FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount + 1
1558                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc
1559            END
1560
1561            BEGIN
1562                IF( @FailedPasswordAnswerAttemptCount >= @MaxInvalidPasswordAttempts )
1563                BEGIN
1564                    SET @IsLockedOut = 1
1565                    SET @LastLockoutDate = @CurrentTimeUtc
1566                END
1567            END
1568
1569            SET @ErrorCode = 3
1570        END
1571        ELSE
1572        BEGIN
1573            IF( @FailedPasswordAnswerAttemptCount > 0 )
1574            BEGIN
1575                SET @FailedPasswordAnswerAttemptCount = 0
1576                SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
1577            END
1578        END
1579
1580        UPDATE dbo.aspnet_Membership
1581        SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,
1582            FailedPasswordAttemptCount = @FailedPasswordAttemptCount,
1583            FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,
1584            FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,
1585            FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart
1586        WHERE @UserId = UserId
1587
1588        IF( @@ERROR <> 0 )
1589        BEGIN
1590            SET @ErrorCode = -1
1591            GOTO Cleanup
1592        END
1593    END
1594
1595    IF( @TranStarted = 1 )
1596    BEGIN
1597	SET @TranStarted = 0
1598	COMMIT TRANSACTION
1599    END
1600
1601    IF( @ErrorCode = 0 )
1602        SELECT @Password, @PasswordFormat
1603
1604    RETURN @ErrorCode
1605
1606Cleanup:
1607
1608    IF( @TranStarted = 1 )
1609    BEGIN
1610        SET @TranStarted = 0
1611    	ROLLBACK TRANSACTION
1612    END
1613
1614    RETURN @ErrorCode
1615
1616END
1617GO
1618/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetPasswordWithFormat]    Script Date: 16.2.2017. 14:59:48 ******/
1619SET ANSI_NULLS ON
1620GO
1621SET QUOTED_IDENTIFIER OFF
1622GO
1623CREATE PROCEDURE [dbo].[aspnet_Membership_GetPasswordWithFormat]
1624    @ApplicationName                nvarchar(256),
1625    @UserName                       nvarchar(256),
1626    @UpdateLastLoginActivityDate    bit,
1627    @CurrentTimeUtc                 datetime
1628AS
1629BEGIN
1630    DECLARE @IsLockedOut                        bit
1631    DECLARE @UserId                             uniqueidentifier
1632    DECLARE @Password                           nvarchar(128)
1633    DECLARE @PasswordSalt                       nvarchar(128)
1634    DECLARE @PasswordFormat                     int
1635    DECLARE @FailedPasswordAttemptCount         int
1636    DECLARE @FailedPasswordAnswerAttemptCount   int
1637    DECLARE @IsApproved                         bit
1638    DECLARE @LastActivityDate                   datetime
1639    DECLARE @LastLoginDate                      datetime
1640
1641    SELECT  @UserId          = NULL
1642
1643    SELECT  @UserId = u.UserId, @IsLockedOut = m.IsLockedOut, @Password=Password, @PasswordFormat=PasswordFormat,
1644            @PasswordSalt=PasswordSalt, @FailedPasswordAttemptCount=FailedPasswordAttemptCount,
1645		    @FailedPasswordAnswerAttemptCount=FailedPasswordAnswerAttemptCount, @IsApproved=IsApproved,
1646            @LastActivityDate = LastActivityDate, @LastLoginDate = LastLoginDate
1647    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
1648    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
1649            u.ApplicationId = a.ApplicationId    AND
1650            u.UserId = m.UserId AND
1651            LOWER(@UserName) = u.LoweredUserName
1652
1653    IF (@UserId IS NULL)
1654        RETURN 1
1655
1656    IF (@IsLockedOut = 1)
1657        RETURN 99
1658
1659    SELECT   @Password, @PasswordFormat, @PasswordSalt, @FailedPasswordAttemptCount,
1660             @FailedPasswordAnswerAttemptCount, @IsApproved, @LastLoginDate, @LastActivityDate
1661
1662    IF (@UpdateLastLoginActivityDate = 1 AND @IsApproved = 1)
1663    BEGIN
1664        UPDATE  dbo.aspnet_Membership
1665        SET     LastLoginDate = @CurrentTimeUtc
1666        WHERE   UserId = @UserId
1667
1668        UPDATE  dbo.aspnet_Users
1669        SET     LastActivityDate = @CurrentTimeUtc
1670        WHERE   @UserId = UserId
1671    END
1672
1673
1674    RETURN 0
1675END
1676GO
1677/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByEmail]    Script Date: 16.2.2017. 14:59:48 ******/
1678SET ANSI_NULLS ON
1679GO
1680SET QUOTED_IDENTIFIER OFF
1681GO
1682CREATE PROCEDURE [dbo].[aspnet_Membership_GetUserByEmail]
1683    @ApplicationName  nvarchar(256),
1684    @Email            nvarchar(256)
1685AS
1686BEGIN
1687    IF( @Email IS NULL )
1688        SELECT  u.UserName
1689        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
1690        WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
1691                u.ApplicationId = a.ApplicationId    AND
1692                u.UserId = m.UserId AND
1693                m.LoweredEmail IS NULL
1694    ELSE
1695        SELECT  u.UserName
1696        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
1697        WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
1698                u.ApplicationId = a.ApplicationId    AND
1699                u.UserId = m.UserId AND
1700                LOWER(@Email) = m.LoweredEmail
1701
1702    IF (@@rowcount = 0)
1703        RETURN(1)
1704    RETURN(0)
1705END
1706GO
1707/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByName]    Script Date: 16.2.2017. 14:59:48 ******/
1708SET ANSI_NULLS ON
1709GO
1710SET QUOTED_IDENTIFIER OFF
1711GO
1712CREATE PROCEDURE [dbo].[aspnet_Membership_GetUserByName]
1713    @ApplicationName      nvarchar(256),
1714    @UserName             nvarchar(256),
1715    @CurrentTimeUtc       datetime,
1716    @UpdateLastActivity   bit = 0
1717AS
1718BEGIN
1719    DECLARE @UserId uniqueidentifier
1720
1721    IF (@UpdateLastActivity = 1)
1722    BEGIN
1723        -- select user ID from aspnet_users table
1724        SELECT TOP 1 @UserId = u.UserId
1725        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
1726        WHERE    LOWER(@ApplicationName) = a.LoweredApplicationName AND
1727                u.ApplicationId = a.ApplicationId    AND
1728                LOWER(@UserName) = u.LoweredUserName AND u.UserId = m.UserId
1729
1730        IF (@@ROWCOUNT = 0) -- Username not found
1731            RETURN -1
1732
1733        UPDATE   dbo.aspnet_Users
1734        SET      LastActivityDate = @CurrentTimeUtc
1735        WHERE    @UserId = UserId
1736
1737        SELECT m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
1738                m.CreateDate, m.LastLoginDate, u.LastActivityDate, m.LastPasswordChangedDate,
1739                u.UserId, m.IsLockedOut, m.LastLockoutDate
1740        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
1741        WHERE  @UserId = u.UserId AND u.UserId = m.UserId 
1742    END
1743    ELSE
1744    BEGIN
1745        SELECT TOP 1 m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
1746                m.CreateDate, m.LastLoginDate, u.LastActivityDate, m.LastPasswordChangedDate,
1747                u.UserId, m.IsLockedOut,m.LastLockoutDate
1748        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
1749        WHERE    LOWER(@ApplicationName) = a.LoweredApplicationName AND
1750                u.ApplicationId = a.ApplicationId    AND
1751                LOWER(@UserName) = u.LoweredUserName AND u.UserId = m.UserId
1752
1753        IF (@@ROWCOUNT = 0) -- Username not found
1754            RETURN -1
1755    END
1756
1757    RETURN 0
1758END
1759GO
1760/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByUserId]    Script Date: 16.2.2017. 14:59:48 ******/
1761SET ANSI_NULLS ON
1762GO
1763SET QUOTED_IDENTIFIER OFF
1764GO
1765CREATE PROCEDURE [dbo].[aspnet_Membership_GetUserByUserId]
1766    @UserId               uniqueidentifier,
1767    @CurrentTimeUtc       datetime,
1768    @UpdateLastActivity   bit = 0
1769AS
1770BEGIN
1771    IF ( @UpdateLastActivity = 1 )
1772    BEGIN
1773        UPDATE   dbo.aspnet_Users
1774        SET      LastActivityDate = @CurrentTimeUtc
1775        FROM     dbo.aspnet_Users
1776        WHERE    @UserId = UserId
1777
1778        IF ( @@ROWCOUNT = 0 ) -- User ID not found
1779            RETURN -1
1780    END
1781
1782    SELECT  m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
1783            m.CreateDate, m.LastLoginDate, u.LastActivityDate,
1784            m.LastPasswordChangedDate, u.UserName, m.IsLockedOut,
1785            m.LastLockoutDate
1786    FROM    dbo.aspnet_Users u, dbo.aspnet_Membership m
1787    WHERE   @UserId = u.UserId AND u.UserId = m.UserId
1788
1789    IF ( @@ROWCOUNT = 0 ) -- User ID not found
1790       RETURN -1
1791
1792    RETURN 0
1793END
1794GO
1795/****** Object:  StoredProcedure [dbo].[aspnet_Membership_ResetPassword]    Script Date: 16.2.2017. 14:59:48 ******/
1796SET ANSI_NULLS ON
1797GO
1798SET QUOTED_IDENTIFIER OFF
1799GO
1800CREATE PROCEDURE [dbo].[aspnet_Membership_ResetPassword]
1801    @ApplicationName             nvarchar(256),
1802    @UserName                    nvarchar(256),
1803    @NewPassword                 nvarchar(128),
1804    @MaxInvalidPasswordAttempts  int,
1805    @PasswordAttemptWindow       int,
1806    @PasswordSalt                nvarchar(128),
1807    @CurrentTimeUtc              datetime,
1808    @PasswordFormat              int = 0,
1809    @PasswordAnswer              nvarchar(128) = NULL
1810AS
1811BEGIN
1812    DECLARE @IsLockedOut                            bit
1813    DECLARE @LastLockoutDate                        datetime
1814    DECLARE @FailedPasswordAttemptCount             int
1815    DECLARE @FailedPasswordAttemptWindowStart       datetime
1816    DECLARE @FailedPasswordAnswerAttemptCount       int
1817    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime
1818
1819    DECLARE @UserId                                 uniqueidentifier
1820    SET     @UserId = NULL
1821
1822    DECLARE @ErrorCode     int
1823    SET @ErrorCode = 0
1824
1825    DECLARE @TranStarted   bit
1826    SET @TranStarted = 0
1827
1828    IF( @@TRANCOUNT = 0 )
1829    BEGIN
1830	    BEGIN TRANSACTION
1831	    SET @TranStarted = 1
1832    END
1833    ELSE
1834    	SET @TranStarted = 0
1835
1836    SELECT  @UserId = u.UserId
1837    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
1838    WHERE   LoweredUserName = LOWER(@UserName) AND
1839            u.ApplicationId = a.ApplicationId  AND
1840            LOWER(@ApplicationName) = a.LoweredApplicationName AND
1841            u.UserId = m.UserId
1842
1843    IF ( @UserId IS NULL )
1844    BEGIN
1845        SET @ErrorCode = 1
1846        GOTO Cleanup
1847    END
1848
1849    SELECT @IsLockedOut = IsLockedOut,
1850           @LastLockoutDate = LastLockoutDate,
1851           @FailedPasswordAttemptCount = FailedPasswordAttemptCount,
1852           @FailedPasswordAttemptWindowStart = FailedPasswordAttemptWindowStart,
1853           @FailedPasswordAnswerAttemptCount = FailedPasswordAnswerAttemptCount,
1854           @FailedPasswordAnswerAttemptWindowStart = FailedPasswordAnswerAttemptWindowStart
1855    FROM dbo.aspnet_Membership WITH ( UPDLOCK )
1856    WHERE @UserId = UserId
1857
1858    IF( @IsLockedOut = 1 )
1859    BEGIN
1860        SET @ErrorCode = 99
1861        GOTO Cleanup
1862    END
1863
1864    UPDATE dbo.aspnet_Membership
1865    SET    Password = @NewPassword,
1866           LastPasswordChangedDate = @CurrentTimeUtc,
1867           PasswordFormat = @PasswordFormat,
1868           PasswordSalt = @PasswordSalt
1869    WHERE  @UserId = UserId AND
1870           ( ( @PasswordAnswer IS NULL ) OR ( LOWER( PasswordAnswer ) = LOWER( @PasswordAnswer ) ) )
1871
1872    IF ( @@ROWCOUNT = 0 )
1873        BEGIN
1874            IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAnswerAttemptWindowStart ) )
1875            BEGIN
1876                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc
1877                SET @FailedPasswordAnswerAttemptCount = 1
1878            END
1879            ELSE
1880            BEGIN
1881                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc
1882                SET @FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount + 1
1883            END
1884
1885            BEGIN
1886                IF( @FailedPasswordAnswerAttemptCount >= @MaxInvalidPasswordAttempts )
1887                BEGIN
1888                    SET @IsLockedOut = 1
1889                    SET @LastLockoutDate = @CurrentTimeUtc
1890                END
1891            END
1892
1893            SET @ErrorCode = 3
1894        END
1895    ELSE
1896        BEGIN
1897            IF( @FailedPasswordAnswerAttemptCount > 0 )
1898            BEGIN
1899                SET @FailedPasswordAnswerAttemptCount = 0
1900                SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
1901            END
1902        END
1903
1904    IF( NOT ( @PasswordAnswer IS NULL ) )
1905    BEGIN
1906        UPDATE dbo.aspnet_Membership
1907        SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,
1908            FailedPasswordAttemptCount = @FailedPasswordAttemptCount,
1909            FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,
1910            FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,
1911            FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart
1912        WHERE @UserId = UserId
1913
1914        IF( @@ERROR <> 0 )
1915        BEGIN
1916            SET @ErrorCode = -1
1917            GOTO Cleanup
1918        END
1919    END
1920
1921    IF( @TranStarted = 1 )
1922    BEGIN
1923	SET @TranStarted = 0
1924	COMMIT TRANSACTION
1925    END
1926
1927    RETURN @ErrorCode
1928
1929Cleanup:
1930
1931    IF( @TranStarted = 1 )
1932    BEGIN
1933        SET @TranStarted = 0
1934    	ROLLBACK TRANSACTION
1935    END
1936
1937    RETURN @ErrorCode
1938
1939END
1940GO
1941/****** Object:  StoredProcedure [dbo].[aspnet_Membership_SetPassword]    Script Date: 16.2.2017. 14:59:48 ******/
1942SET ANSI_NULLS ON
1943GO
1944SET QUOTED_IDENTIFIER OFF
1945GO
1946CREATE PROCEDURE [dbo].[aspnet_Membership_SetPassword]
1947    @ApplicationName  nvarchar(256),
1948    @UserName         nvarchar(256),
1949    @NewPassword      nvarchar(128),
1950    @PasswordSalt     nvarchar(128),
1951    @CurrentTimeUtc   datetime,
1952    @PasswordFormat   int = 0
1953AS
1954BEGIN
1955    DECLARE @UserId uniqueidentifier
1956    SELECT  @UserId = NULL
1957    SELECT  @UserId = u.UserId
1958    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
1959    WHERE   LoweredUserName = LOWER(@UserName) AND
1960            u.ApplicationId = a.ApplicationId  AND
1961            LOWER(@ApplicationName) = a.LoweredApplicationName AND
1962            u.UserId = m.UserId
1963
1964    IF (@UserId IS NULL)
1965        RETURN(1)
1966
1967    UPDATE dbo.aspnet_Membership
1968    SET Password = @NewPassword, PasswordFormat = @PasswordFormat, PasswordSalt = @PasswordSalt,
1969        LastPasswordChangedDate = @CurrentTimeUtc
1970    WHERE @UserId = UserId
1971    RETURN(0)
1972END
1973GO
1974/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UnlockUser]    Script Date: 16.2.2017. 14:59:48 ******/
1975SET ANSI_NULLS ON
1976GO
1977SET QUOTED_IDENTIFIER OFF
1978GO
1979CREATE PROCEDURE [dbo].[aspnet_Membership_UnlockUser]
1980    @ApplicationName                         nvarchar(256),
1981    @UserName                                nvarchar(256)
1982AS
1983BEGIN
1984    DECLARE @UserId uniqueidentifier
1985    SELECT  @UserId = NULL
1986    SELECT  @UserId = u.UserId
1987    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
1988    WHERE   LoweredUserName = LOWER(@UserName) AND
1989            u.ApplicationId = a.ApplicationId  AND
1990            LOWER(@ApplicationName) = a.LoweredApplicationName AND
1991            u.UserId = m.UserId
1992
1993    IF ( @UserId IS NULL )
1994        RETURN 1
1995
1996    UPDATE dbo.aspnet_Membership
1997    SET IsLockedOut = 0,
1998        FailedPasswordAttemptCount = 0,
1999        FailedPasswordAttemptWindowStart = CONVERT( datetime, '17540101', 112 ),
2000        FailedPasswordAnswerAttemptCount = 0,
2001        FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 ),
2002        LastLockoutDate = CONVERT( datetime, '17540101', 112 )
2003    WHERE @UserId = UserId
2004
2005    RETURN 0
2006END
2007GO
2008/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UpdateUser]    Script Date: 16.2.2017. 14:59:48 ******/
2009SET ANSI_NULLS ON
2010GO
2011SET QUOTED_IDENTIFIER OFF
2012GO
2013CREATE PROCEDURE [dbo].[aspnet_Membership_UpdateUser]
2014    @ApplicationName      nvarchar(256),
2015    @UserName             nvarchar(256),
2016    @Email                nvarchar(256),
2017    @Comment              ntext,
2018    @IsApproved           bit,
2019    @LastLoginDate        datetime,
2020    @LastActivityDate     datetime,
2021    @UniqueEmail          int,
2022    @CurrentTimeUtc       datetime
2023AS
2024BEGIN
2025    DECLARE @UserId uniqueidentifier
2026    DECLARE @ApplicationId uniqueidentifier
2027    SELECT  @UserId = NULL
2028    SELECT  @UserId = u.UserId, @ApplicationId = a.ApplicationId
2029    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
2030    WHERE   LoweredUserName = LOWER(@UserName) AND
2031            u.ApplicationId = a.ApplicationId  AND
2032            LOWER(@ApplicationName) = a.LoweredApplicationName AND
2033            u.UserId = m.UserId
2034
2035    IF (@UserId IS NULL)
2036        RETURN(1)
2037
2038    IF (@UniqueEmail = 1)
2039    BEGIN
2040        IF (EXISTS (SELECT *
2041                    FROM  dbo.aspnet_Membership WITH (UPDLOCK, HOLDLOCK)
2042                    WHERE ApplicationId = @ApplicationId  AND @UserId <> UserId AND LoweredEmail = LOWER(@Email)))
2043        BEGIN
2044            RETURN(7)
2045        END
2046    END
2047
2048    DECLARE @TranStarted   bit
2049    SET @TranStarted = 0
2050
2051    IF( @@TRANCOUNT = 0 )
2052    BEGIN
2053	    BEGIN TRANSACTION
2054	    SET @TranStarted = 1
2055    END
2056    ELSE
2057	SET @TranStarted = 0
2058
2059    UPDATE dbo.aspnet_Users WITH (ROWLOCK)
2060    SET
2061         LastActivityDate = @LastActivityDate
2062    WHERE
2063       @UserId = UserId
2064
2065    IF( @@ERROR <> 0 )
2066        GOTO Cleanup
2067
2068    UPDATE dbo.aspnet_Membership WITH (ROWLOCK)
2069    SET
2070         Email            = @Email,
2071         LoweredEmail     = LOWER(@Email),
2072         Comment          = @Comment,
2073         IsApproved       = @IsApproved,
2074         LastLoginDate    = @LastLoginDate
2075    WHERE
2076       @UserId = UserId
2077
2078    IF( @@ERROR <> 0 )
2079        GOTO Cleanup
2080
2081    IF( @TranStarted = 1 )
2082    BEGIN
2083	SET @TranStarted = 0
2084	COMMIT TRANSACTION
2085    END
2086
2087    RETURN 0
2088
2089Cleanup:
2090
2091    IF( @TranStarted = 1 )
2092    BEGIN
2093        SET @TranStarted = 0
2094    	ROLLBACK TRANSACTION
2095    END
2096
2097    RETURN -1
2098END
2099GO
2100/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UpdateUserInfo]    Script Date: 16.2.2017. 14:59:48 ******/
2101SET ANSI_NULLS ON
2102GO
2103SET QUOTED_IDENTIFIER OFF
2104GO
2105CREATE PROCEDURE [dbo].[aspnet_Membership_UpdateUserInfo]
2106    @ApplicationName                nvarchar(256),
2107    @UserName                       nvarchar(256),
2108    @IsPasswordCorrect              bit,
2109    @UpdateLastLoginActivityDate    bit,
2110    @MaxInvalidPasswordAttempts     int,
2111    @PasswordAttemptWindow          int,
2112    @CurrentTimeUtc                 datetime,
2113    @LastLoginDate                  datetime,
2114    @LastActivityDate               datetime
2115AS
2116BEGIN
2117    DECLARE @UserId                                 uniqueidentifier
2118    DECLARE @IsApproved                             bit
2119    DECLARE @IsLockedOut                            bit
2120    DECLARE @LastLockoutDate                        datetime
2121    DECLARE @FailedPasswordAttemptCount             int
2122    DECLARE @FailedPasswordAttemptWindowStart       datetime
2123    DECLARE @FailedPasswordAnswerAttemptCount       int
2124    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime
2125
2126    DECLARE @ErrorCode     int
2127    SET @ErrorCode = 0
2128
2129    DECLARE @TranStarted   bit
2130    SET @TranStarted = 0
2131
2132    IF( @@TRANCOUNT = 0 )
2133    BEGIN
2134	    BEGIN TRANSACTION
2135	    SET @TranStarted = 1
2136    END
2137    ELSE
2138    	SET @TranStarted = 0
2139
2140    SELECT  @UserId = u.UserId,
2141            @IsApproved = m.IsApproved,
2142            @IsLockedOut = m.IsLockedOut,
2143            @LastLockoutDate = m.LastLockoutDate,
2144            @FailedPasswordAttemptCount = m.FailedPasswordAttemptCount,
2145            @FailedPasswordAttemptWindowStart = m.FailedPasswordAttemptWindowStart,
2146            @FailedPasswordAnswerAttemptCount = m.FailedPasswordAnswerAttemptCount,
2147            @FailedPasswordAnswerAttemptWindowStart = m.FailedPasswordAnswerAttemptWindowStart
2148    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m WITH ( UPDLOCK )
2149    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
2150            u.ApplicationId = a.ApplicationId    AND
2151            u.UserId = m.UserId AND
2152            LOWER(@UserName) = u.LoweredUserName
2153
2154    IF ( @@rowcount = 0 )
2155    BEGIN
2156        SET @ErrorCode = 1
2157        GOTO Cleanup
2158    END
2159
2160    IF( @IsLockedOut = 1 )
2161    BEGIN
2162        GOTO Cleanup
2163    END
2164
2165    IF( @IsPasswordCorrect = 0 )
2166    BEGIN
2167        IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAttemptWindowStart ) )
2168        BEGIN
2169            SET @FailedPasswordAttemptWindowStart = @CurrentTimeUtc
2170            SET @FailedPasswordAttemptCount = 1
2171        END
2172        ELSE
2173        BEGIN
2174            SET @FailedPasswordAttemptWindowStart = @CurrentTimeUtc
2175            SET @FailedPasswordAttemptCount = @FailedPasswordAttemptCount + 1
2176        END
2177
2178        BEGIN
2179            IF( @FailedPasswordAttemptCount >= @MaxInvalidPasswordAttempts )
2180            BEGIN
2181                SET @IsLockedOut = 1
2182                SET @LastLockoutDate = @CurrentTimeUtc
2183            END
2184        END
2185    END
2186    ELSE
2187    BEGIN
2188        IF( @FailedPasswordAttemptCount > 0 OR @FailedPasswordAnswerAttemptCount > 0 )
2189        BEGIN
2190            SET @FailedPasswordAttemptCount = 0
2191            SET @FailedPasswordAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
2192            SET @FailedPasswordAnswerAttemptCount = 0
2193            SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
2194            SET @LastLockoutDate = CONVERT( datetime, '17540101', 112 )
2195        END
2196    END
2197
2198    IF( @UpdateLastLoginActivityDate = 1 )
2199    BEGIN
2200        UPDATE  dbo.aspnet_Users
2201        SET     LastActivityDate = @LastActivityDate
2202        WHERE   @UserId = UserId
2203
2204        IF( @@ERROR <> 0 )
2205        BEGIN
2206            SET @ErrorCode = -1
2207            GOTO Cleanup
2208        END
2209
2210        UPDATE  dbo.aspnet_Membership
2211        SET     LastLoginDate = @LastLoginDate
2212        WHERE   UserId = @UserId
2213
2214        IF( @@ERROR <> 0 )
2215        BEGIN
2216            SET @ErrorCode = -1
2217            GOTO Cleanup
2218        END
2219    END
2220
2221
2222    UPDATE dbo.aspnet_Membership
2223    SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,
2224        FailedPasswordAttemptCount = @FailedPasswordAttemptCount,
2225        FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,
2226        FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,
2227        FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart
2228    WHERE @UserId = UserId
2229
2230    IF( @@ERROR <> 0 )
2231    BEGIN
2232        SET @ErrorCode = -1
2233        GOTO Cleanup
2234    END
2235
2236    IF( @TranStarted = 1 )
2237    BEGIN
2238	SET @TranStarted = 0
2239	COMMIT TRANSACTION
2240    END
2241
2242    RETURN @ErrorCode
2243
2244Cleanup:
2245
2246    IF( @TranStarted = 1 )
2247    BEGIN
2248        SET @TranStarted = 0
2249    	ROLLBACK TRANSACTION
2250    END
2251
2252    RETURN @ErrorCode
2253
2254END
2255GO
2256/****** Object:  StoredProcedure [dbo].[aspnet_Paths_CreatePath]    Script Date: 16.2.2017. 14:59:48 ******/
2257SET ANSI_NULLS ON
2258GO
2259SET QUOTED_IDENTIFIER OFF
2260GO
2261CREATE PROCEDURE [dbo].[aspnet_Paths_CreatePath]
2262    @ApplicationId UNIQUEIDENTIFIER,
2263    @Path           NVARCHAR(256),
2264    @PathId         UNIQUEIDENTIFIER OUTPUT
2265AS
2266BEGIN
2267    BEGIN TRANSACTION
2268    IF (NOT EXISTS(SELECT * FROM dbo.aspnet_Paths WHERE LoweredPath = LOWER(@Path) AND ApplicationId = @ApplicationId))
2269    BEGIN
2270        INSERT dbo.aspnet_Paths (ApplicationId, Path, LoweredPath) VALUES (@ApplicationId, @Path, LOWER(@Path))
2271    END
2272    COMMIT TRANSACTION
2273    SELECT @PathId = PathId FROM dbo.aspnet_Paths WHERE LOWER(@Path) = LoweredPath AND ApplicationId = @ApplicationId
2274END
2275GO
2276/****** Object:  StoredProcedure [dbo].[aspnet_Personalization_GetApplicationId]    Script Date: 16.2.2017. 14:59:48 ******/
2277SET ANSI_NULLS ON
2278GO
2279SET QUOTED_IDENTIFIER OFF
2280GO
2281CREATE PROCEDURE [dbo].[aspnet_Personalization_GetApplicationId] (
2282    @ApplicationName NVARCHAR(256),
2283    @ApplicationId UNIQUEIDENTIFIER OUT)
2284AS
2285BEGIN
2286    SELECT @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
2287END
2288GO
2289/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_DeleteAllState]    Script Date: 16.2.2017. 14:59:48 ******/
2290SET ANSI_NULLS ON
2291GO
2292SET QUOTED_IDENTIFIER OFF
2293GO
2294CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_DeleteAllState] (
2295    @AllUsersScope bit,
2296    @ApplicationName NVARCHAR(256),
2297    @Count int OUT)
2298AS
2299BEGIN
2300    DECLARE @ApplicationId UNIQUEIDENTIFIER
2301    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2302    IF (@ApplicationId IS NULL)
2303        SELECT @Count = 0
2304    ELSE
2305    BEGIN
2306        IF (@AllUsersScope = 1)
2307            DELETE FROM aspnet_PersonalizationAllUsers
2308            WHERE PathId IN
2309               (SELECT Paths.PathId
2310                FROM dbo.aspnet_Paths Paths
2311                WHERE Paths.ApplicationId = @ApplicationId)
2312        ELSE
2313            DELETE FROM aspnet_PersonalizationPerUser
2314            WHERE PathId IN
2315               (SELECT Paths.PathId
2316                FROM dbo.aspnet_Paths Paths
2317                WHERE Paths.ApplicationId = @ApplicationId)
2318
2319        SELECT @Count = @@ROWCOUNT
2320    END
2321END
2322GO
2323/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_FindState]    Script Date: 16.2.2017. 14:59:48 ******/
2324SET ANSI_NULLS ON
2325GO
2326SET QUOTED_IDENTIFIER OFF
2327GO
2328CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_FindState] (
2329    @AllUsersScope bit,
2330    @ApplicationName NVARCHAR(256),
2331    @PageIndex              INT,
2332    @PageSize               INT,
2333    @Path NVARCHAR(256) = NULL,
2334    @UserName NVARCHAR(256) = NULL,
2335    @InactiveSinceDate DATETIME = NULL)
2336AS
2337BEGIN
2338    DECLARE @ApplicationId UNIQUEIDENTIFIER
2339    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2340    IF (@ApplicationId IS NULL)
2341        RETURN
2342
2343    -- Set the page bounds
2344    DECLARE @PageLowerBound INT
2345    DECLARE @PageUpperBound INT
2346    DECLARE @TotalRecords   INT
2347    SET @PageLowerBound = @PageSize * @PageIndex
2348    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound
2349
2350    -- Create a temp table to store the selected results
2351    CREATE TABLE #PageIndex (
2352        IndexId int IDENTITY (0, 1) NOT NULL,
2353        ItemId UNIQUEIDENTIFIER
2354    )
2355
2356    IF (@AllUsersScope = 1)
2357    BEGIN
2358        -- Insert into our temp table
2359        INSERT INTO #PageIndex (ItemId)
2360        SELECT Paths.PathId
2361        FROM dbo.aspnet_Paths Paths,
2362             ((SELECT Paths.PathId
2363               FROM dbo.aspnet_PersonalizationAllUsers AllUsers, dbo.aspnet_Paths Paths
2364               WHERE Paths.ApplicationId = @ApplicationId
2365                      AND AllUsers.PathId = Paths.PathId
2366                      AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
2367              ) AS SharedDataPerPath
2368              FULL OUTER JOIN
2369              (SELECT DISTINCT Paths.PathId
2370               FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Paths Paths
2371               WHERE Paths.ApplicationId = @ApplicationId
2372                      AND PerUser.PathId = Paths.PathId
2373                      AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
2374              ) AS UserDataPerPath
2375              ON SharedDataPerPath.PathId = UserDataPerPath.PathId
2376             )
2377        WHERE Paths.PathId = SharedDataPerPath.PathId OR Paths.PathId = UserDataPerPath.PathId
2378        ORDER BY Paths.Path ASC
2379
2380        SELECT @TotalRecords = @@ROWCOUNT
2381
2382        SELECT Paths.Path,
2383               SharedDataPerPath.LastUpdatedDate,
2384               SharedDataPerPath.SharedDataLength,
2385               UserDataPerPath.UserDataLength,
2386               UserDataPerPath.UserCount
2387        FROM dbo.aspnet_Paths Paths,
2388             ((SELECT PageIndex.ItemId AS PathId,
2389                      AllUsers.LastUpdatedDate AS LastUpdatedDate,
2390                      DATALENGTH(AllUsers.PageSettings) AS SharedDataLength
2391               FROM dbo.aspnet_PersonalizationAllUsers AllUsers, #PageIndex PageIndex
2392               WHERE AllUsers.PathId = PageIndex.ItemId
2393                     AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound
2394              ) AS SharedDataPerPath
2395              FULL OUTER JOIN
2396              (SELECT PageIndex.ItemId AS PathId,
2397                      SUM(DATALENGTH(PerUser.PageSettings)) AS UserDataLength,
2398                      COUNT(*) AS UserCount
2399               FROM aspnet_PersonalizationPerUser PerUser, #PageIndex PageIndex
2400               WHERE PerUser.PathId = PageIndex.ItemId
2401                     AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound
2402               GROUP BY PageIndex.ItemId
2403              ) AS UserDataPerPath
2404              ON SharedDataPerPath.PathId = UserDataPerPath.PathId
2405             )
2406        WHERE Paths.PathId = SharedDataPerPath.PathId OR Paths.PathId = UserDataPerPath.PathId
2407        ORDER BY Paths.Path ASC
2408    END
2409    ELSE
2410    BEGIN
2411        -- Insert into our temp table
2412        INSERT INTO #PageIndex (ItemId)
2413        SELECT PerUser.Id
2414        FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths
2415        WHERE Paths.ApplicationId = @ApplicationId
2416              AND PerUser.UserId = Users.UserId
2417              AND PerUser.PathId = Paths.PathId
2418              AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
2419              AND (@UserName IS NULL OR Users.LoweredUserName LIKE LOWER(@UserName))
2420              AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)
2421        ORDER BY Paths.Path ASC, Users.UserName ASC
2422
2423        SELECT @TotalRecords = @@ROWCOUNT
2424
2425        SELECT Paths.Path, PerUser.LastUpdatedDate, DATALENGTH(PerUser.PageSettings), Users.UserName, Users.LastActivityDate
2426        FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths, #PageIndex PageIndex
2427        WHERE PerUser.Id = PageIndex.ItemId
2428              AND PerUser.UserId = Users.UserId
2429              AND PerUser.PathId = Paths.PathId
2430              AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound
2431        ORDER BY Paths.Path ASC, Users.UserName ASC
2432    END
2433
2434    RETURN @TotalRecords
2435END
2436GO
2437/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_GetCountOfState]    Script Date: 16.2.2017. 14:59:48 ******/
2438SET ANSI_NULLS ON
2439GO
2440SET QUOTED_IDENTIFIER OFF
2441GO
2442CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_GetCountOfState] (
2443    @Count int OUT,
2444    @AllUsersScope bit,
2445    @ApplicationName NVARCHAR(256),
2446    @Path NVARCHAR(256) = NULL,
2447    @UserName NVARCHAR(256) = NULL,
2448    @InactiveSinceDate DATETIME = NULL)
2449AS
2450BEGIN
2451
2452    DECLARE @ApplicationId UNIQUEIDENTIFIER
2453    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2454    IF (@ApplicationId IS NULL)
2455        SELECT @Count = 0
2456    ELSE
2457        IF (@AllUsersScope = 1)
2458            SELECT @Count = COUNT(*)
2459            FROM dbo.aspnet_PersonalizationAllUsers AllUsers, dbo.aspnet_Paths Paths
2460            WHERE Paths.ApplicationId = @ApplicationId
2461                  AND AllUsers.PathId = Paths.PathId
2462                  AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
2463        ELSE
2464            SELECT @Count = COUNT(*)
2465            FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths
2466            WHERE Paths.ApplicationId = @ApplicationId
2467                  AND PerUser.UserId = Users.UserId
2468                  AND PerUser.PathId = Paths.PathId
2469                  AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
2470                  AND (@UserName IS NULL OR Users.LoweredUserName LIKE LOWER(@UserName))
2471                  AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)
2472END
2473GO
2474/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetSharedState]    Script Date: 16.2.2017. 14:59:48 ******/
2475SET ANSI_NULLS ON
2476GO
2477SET QUOTED_IDENTIFIER OFF
2478GO
2479CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetSharedState] (
2480    @Count int OUT,
2481    @ApplicationName NVARCHAR(256),
2482    @Path NVARCHAR(256))
2483AS
2484BEGIN
2485    DECLARE @ApplicationId UNIQUEIDENTIFIER
2486    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2487    IF (@ApplicationId IS NULL)
2488        SELECT @Count = 0
2489    ELSE
2490    BEGIN
2491        DELETE FROM dbo.aspnet_PersonalizationAllUsers
2492        WHERE PathId IN
2493            (SELECT AllUsers.PathId
2494             FROM dbo.aspnet_PersonalizationAllUsers AllUsers, dbo.aspnet_Paths Paths
2495             WHERE Paths.ApplicationId = @ApplicationId
2496                   AND AllUsers.PathId = Paths.PathId
2497                   AND Paths.LoweredPath = LOWER(@Path))
2498
2499        SELECT @Count = @@ROWCOUNT
2500    END
2501END
2502GO
2503/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetUserState]    Script Date: 16.2.2017. 14:59:48 ******/
2504SET ANSI_NULLS ON
2505GO
2506SET QUOTED_IDENTIFIER OFF
2507GO
2508CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetUserState] (
2509    @Count                  int                 OUT,
2510    @ApplicationName        NVARCHAR(256),
2511    @InactiveSinceDate      DATETIME            = NULL,
2512    @UserName               NVARCHAR(256)       = NULL,
2513    @Path                   NVARCHAR(256)       = NULL)
2514AS
2515BEGIN
2516    DECLARE @ApplicationId UNIQUEIDENTIFIER
2517    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2518    IF (@ApplicationId IS NULL)
2519        SELECT @Count = 0
2520    ELSE
2521    BEGIN
2522        DELETE FROM dbo.aspnet_PersonalizationPerUser
2523        WHERE Id IN (SELECT PerUser.Id
2524                     FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths
2525                     WHERE Paths.ApplicationId = @ApplicationId
2526                           AND PerUser.UserId = Users.UserId
2527                           AND PerUser.PathId = Paths.PathId
2528                           AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)
2529                           AND (@UserName IS NULL OR Users.LoweredUserName = LOWER(@UserName))
2530                           AND (@Path IS NULL OR Paths.LoweredPath = LOWER(@Path)))
2531
2532        SELECT @Count = @@ROWCOUNT
2533    END
2534END
2535GO
2536/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]    Script Date: 16.2.2017. 14:59:48 ******/
2537SET ANSI_NULLS ON
2538GO
2539SET QUOTED_IDENTIFIER OFF
2540GO
2541CREATE PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] (
2542    @ApplicationName  NVARCHAR(256),
2543    @Path              NVARCHAR(256))
2544AS
2545BEGIN
2546    DECLARE @ApplicationId UNIQUEIDENTIFIER
2547    DECLARE @PathId UNIQUEIDENTIFIER
2548
2549    SELECT @ApplicationId = NULL
2550    SELECT @PathId = NULL
2551
2552    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2553    IF (@ApplicationId IS NULL)
2554    BEGIN
2555        RETURN
2556    END
2557
2558    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
2559    IF (@PathId IS NULL)
2560    BEGIN
2561        RETURN
2562    END
2563
2564    SELECT p.PageSettings FROM dbo.aspnet_PersonalizationAllUsers p WHERE p.PathId = @PathId
2565END
2566GO
2567/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]    Script Date: 16.2.2017. 14:59:48 ******/
2568SET ANSI_NULLS ON
2569GO
2570SET QUOTED_IDENTIFIER OFF
2571GO
2572CREATE PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] (
2573    @ApplicationName  NVARCHAR(256),
2574    @Path              NVARCHAR(256))
2575AS
2576BEGIN
2577    DECLARE @ApplicationId UNIQUEIDENTIFIER
2578    DECLARE @PathId UNIQUEIDENTIFIER
2579
2580    SELECT @ApplicationId = NULL
2581    SELECT @PathId = NULL
2582
2583    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2584    IF (@ApplicationId IS NULL)
2585    BEGIN
2586        RETURN
2587    END
2588
2589    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
2590    IF (@PathId IS NULL)
2591    BEGIN
2592        RETURN
2593    END
2594
2595    DELETE FROM dbo.aspnet_PersonalizationAllUsers WHERE PathId = @PathId
2596    RETURN 0
2597END
2598GO
2599/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]    Script Date: 16.2.2017. 14:59:48 ******/
2600SET ANSI_NULLS ON
2601GO
2602SET QUOTED_IDENTIFIER OFF
2603GO
2604CREATE PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] (
2605    @ApplicationName  NVARCHAR(256),
2606    @Path             NVARCHAR(256),
2607    @PageSettings     IMAGE,
2608    @CurrentTimeUtc   DATETIME)
2609AS
2610BEGIN
2611    DECLARE @ApplicationId UNIQUEIDENTIFIER
2612    DECLARE @PathId UNIQUEIDENTIFIER
2613
2614    SELECT @ApplicationId = NULL
2615    SELECT @PathId = NULL
2616
2617    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT
2618
2619    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
2620    IF (@PathId IS NULL)
2621    BEGIN
2622        EXEC dbo.aspnet_Paths_CreatePath @ApplicationId, @Path, @PathId OUTPUT
2623    END
2624
2625    IF (EXISTS(SELECT PathId FROM dbo.aspnet_PersonalizationAllUsers WHERE PathId = @PathId))
2626        UPDATE dbo.aspnet_PersonalizationAllUsers SET PageSettings = @PageSettings, LastUpdatedDate = @CurrentTimeUtc WHERE PathId = @PathId
2627    ELSE
2628        INSERT INTO dbo.aspnet_PersonalizationAllUsers(PathId, PageSettings, LastUpdatedDate) VALUES (@PathId, @PageSettings, @CurrentTimeUtc)
2629    RETURN 0
2630END
2631GO
2632/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_GetPageSettings]    Script Date: 16.2.2017. 14:59:48 ******/
2633SET ANSI_NULLS ON
2634GO
2635SET QUOTED_IDENTIFIER OFF
2636GO
2637CREATE PROCEDURE [dbo].[aspnet_PersonalizationPerUser_GetPageSettings] (
2638    @ApplicationName  NVARCHAR(256),
2639    @UserName         NVARCHAR(256),
2640    @Path             NVARCHAR(256),
2641    @CurrentTimeUtc   DATETIME)
2642AS
2643BEGIN
2644    DECLARE @ApplicationId UNIQUEIDENTIFIER
2645    DECLARE @PathId UNIQUEIDENTIFIER
2646    DECLARE @UserId UNIQUEIDENTIFIER
2647
2648    SELECT @ApplicationId = NULL
2649    SELECT @PathId = NULL
2650    SELECT @UserId = NULL
2651
2652    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2653    IF (@ApplicationId IS NULL)
2654    BEGIN
2655        RETURN
2656    END
2657
2658    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
2659    IF (@PathId IS NULL)
2660    BEGIN
2661        RETURN
2662    END
2663
2664    SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)
2665    IF (@UserId IS NULL)
2666    BEGIN
2667        RETURN
2668    END
2669
2670    UPDATE   dbo.aspnet_Users WITH (ROWLOCK)
2671    SET      LastActivityDate = @CurrentTimeUtc
2672    WHERE    UserId = @UserId
2673    IF (@@ROWCOUNT = 0) -- Username not found
2674        RETURN
2675
2676    SELECT p.PageSettings FROM dbo.aspnet_PersonalizationPerUser p WHERE p.PathId = @PathId AND p.UserId = @UserId
2677END
2678GO
2679/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]    Script Date: 16.2.2017. 14:59:48 ******/
2680SET ANSI_NULLS ON
2681GO
2682SET QUOTED_IDENTIFIER OFF
2683GO
2684CREATE PROCEDURE [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] (
2685    @ApplicationName  NVARCHAR(256),
2686    @UserName         NVARCHAR(256),
2687    @Path             NVARCHAR(256),
2688    @CurrentTimeUtc   DATETIME)
2689AS
2690BEGIN
2691    DECLARE @ApplicationId UNIQUEIDENTIFIER
2692    DECLARE @PathId UNIQUEIDENTIFIER
2693    DECLARE @UserId UNIQUEIDENTIFIER
2694
2695    SELECT @ApplicationId = NULL
2696    SELECT @PathId = NULL
2697    SELECT @UserId = NULL
2698
2699    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
2700    IF (@ApplicationId IS NULL)
2701    BEGIN
2702        RETURN
2703    END
2704
2705    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
2706    IF (@PathId IS NULL)
2707    BEGIN
2708        RETURN
2709    END
2710
2711    SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)
2712    IF (@UserId IS NULL)
2713    BEGIN
2714        RETURN
2715    END
2716
2717    UPDATE   dbo.aspnet_Users WITH (ROWLOCK)
2718    SET      LastActivityDate = @CurrentTimeUtc
2719    WHERE    UserId = @UserId
2720    IF (@@ROWCOUNT = 0) -- Username not found
2721        RETURN
2722
2723    DELETE FROM dbo.aspnet_PersonalizationPerUser WHERE PathId = @PathId AND UserId = @UserId
2724    RETURN 0
2725END
2726GO
2727/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_SetPageSettings]    Script Date: 16.2.2017. 14:59:48 ******/
2728SET ANSI_NULLS ON
2729GO
2730SET QUOTED_IDENTIFIER OFF
2731GO
2732CREATE PROCEDURE [dbo].[aspnet_PersonalizationPerUser_SetPageSettings] (
2733    @ApplicationName  NVARCHAR(256),
2734    @UserName         NVARCHAR(256),
2735    @Path             NVARCHAR(256),
2736    @PageSettings     IMAGE,
2737    @CurrentTimeUtc   DATETIME)
2738AS
2739BEGIN
2740    DECLARE @ApplicationId UNIQUEIDENTIFIER
2741    DECLARE @PathId UNIQUEIDENTIFIER
2742    DECLARE @UserId UNIQUEIDENTIFIER
2743
2744    SELECT @ApplicationId = NULL
2745    SELECT @PathId = NULL
2746    SELECT @UserId = NULL
2747
2748    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT
2749
2750    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
2751    IF (@PathId IS NULL)
2752    BEGIN
2753        EXEC dbo.aspnet_Paths_CreatePath @ApplicationId, @Path, @PathId OUTPUT
2754    END
2755
2756    SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)
2757    IF (@UserId IS NULL)
2758    BEGIN
2759        EXEC dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, 0, @CurrentTimeUtc, @UserId OUTPUT
2760    END
2761
2762    UPDATE   dbo.aspnet_Users WITH (ROWLOCK)
2763    SET      LastActivityDate = @CurrentTimeUtc
2764    WHERE    UserId = @UserId
2765    IF (@@ROWCOUNT = 0) -- Username not found
2766        RETURN
2767
2768    IF (EXISTS(SELECT PathId FROM dbo.aspnet_PersonalizationPerUser WHERE UserId = @UserId AND PathId = @PathId))
2769        UPDATE dbo.aspnet_PersonalizationPerUser SET PageSettings = @PageSettings, LastUpdatedDate = @CurrentTimeUtc WHERE UserId = @UserId AND PathId = @PathId
2770    ELSE
2771        INSERT INTO dbo.aspnet_PersonalizationPerUser(UserId, PathId, PageSettings, LastUpdatedDate) VALUES (@UserId, @PathId, @PageSettings, @CurrentTimeUtc)
2772    RETURN 0
2773END
2774GO
2775/****** Object:  StoredProcedure [dbo].[aspnet_Profile_DeleteInactiveProfiles]    Script Date: 16.2.2017. 14:59:48 ******/
2776SET ANSI_NULLS ON
2777GO
2778SET QUOTED_IDENTIFIER OFF
2779GO
2780
2781CREATE PROCEDURE [dbo].[aspnet_Profile_DeleteInactiveProfiles]
2782    @ApplicationName        nvarchar(256),
2783    @ProfileAuthOptions     int,
2784    @InactiveSinceDate      datetime
2785AS
2786BEGIN
2787    DECLARE @ApplicationId uniqueidentifier
2788    SELECT  @ApplicationId = NULL
2789    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
2790    IF (@ApplicationId IS NULL)
2791    BEGIN
2792        SELECT  0
2793        RETURN
2794    END
2795
2796    DELETE
2797    FROM    dbo.aspnet_Profile
2798    WHERE   UserId IN
2799            (   SELECT  UserId
2800                FROM    dbo.aspnet_Users u
2801                WHERE   ApplicationId = @ApplicationId
2802                        AND (LastActivityDate <= @InactiveSinceDate)
2803                        AND (
2804                                (@ProfileAuthOptions = 2)
2805                             OR (@ProfileAuthOptions = 0 AND IsAnonymous = 1)
2806                             OR (@ProfileAuthOptions = 1 AND IsAnonymous = 0)
2807                            )
2808            )
2809
2810    SELECT  @@ROWCOUNT
2811END
2812GO
2813/****** Object:  StoredProcedure [dbo].[aspnet_Profile_DeleteProfiles]    Script Date: 16.2.2017. 14:59:48 ******/
2814SET ANSI_NULLS ON
2815GO
2816SET QUOTED_IDENTIFIER OFF
2817GO
2818
2819CREATE PROCEDURE [dbo].[aspnet_Profile_DeleteProfiles]
2820    @ApplicationName        nvarchar(256),
2821    @UserNames              nvarchar(4000)
2822AS
2823BEGIN
2824    DECLARE @UserName     nvarchar(256)
2825    DECLARE @CurrentPos   int
2826    DECLARE @NextPos      int
2827    DECLARE @NumDeleted   int
2828    DECLARE @DeletedUser  int
2829    DECLARE @TranStarted  bit
2830    DECLARE @ErrorCode    int
2831
2832    SET @ErrorCode = 0
2833    SET @CurrentPos = 1
2834    SET @NumDeleted = 0
2835    SET @TranStarted = 0
2836
2837    IF( @@TRANCOUNT = 0 )
2838    BEGIN
2839        BEGIN TRANSACTION
2840        SET @TranStarted = 1
2841    END
2842    ELSE
2843    	SET @TranStarted = 0
2844
2845    WHILE (@CurrentPos <= LEN(@UserNames))
2846    BEGIN
2847        SELECT @NextPos = CHARINDEX(N',', @UserNames,  @CurrentPos)
2848        IF (@NextPos = 0 OR @NextPos IS NULL)
2849            SELECT @NextPos = LEN(@UserNames) + 1
2850
2851        SELECT @UserName = SUBSTRING(@UserNames, @CurrentPos, @NextPos - @CurrentPos)
2852        SELECT @CurrentPos = @NextPos+1
2853
2854        IF (LEN(@UserName) > 0)
2855        BEGIN
2856            SELECT @DeletedUser = 0
2857            EXEC dbo.aspnet_Users_DeleteUser @ApplicationName, @UserName, 4, @DeletedUser OUTPUT
2858            IF( @@ERROR <> 0 )
2859            BEGIN
2860                SET @ErrorCode = -1
2861                GOTO Cleanup
2862            END
2863            IF (@DeletedUser <> 0)
2864                SELECT @NumDeleted = @NumDeleted + 1
2865        END
2866    END
2867    SELECT @NumDeleted
2868    IF (@TranStarted = 1)
2869    BEGIN
2870    	SET @TranStarted = 0
2871    	COMMIT TRANSACTION
2872    END
2873    SET @TranStarted = 0
2874
2875    RETURN 0
2876
2877Cleanup:
2878    IF (@TranStarted = 1 )
2879    BEGIN
2880        SET @TranStarted = 0
2881    	ROLLBACK TRANSACTION
2882    END
2883    RETURN @ErrorCode
2884END
2885GO
2886/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]    Script Date: 16.2.2017. 14:59:48 ******/
2887SET ANSI_NULLS ON
2888GO
2889SET QUOTED_IDENTIFIER OFF
2890GO
2891
2892CREATE PROCEDURE [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]
2893    @ApplicationName        nvarchar(256),
2894    @ProfileAuthOptions     int,
2895    @InactiveSinceDate      datetime
2896AS
2897BEGIN
2898    DECLARE @ApplicationId uniqueidentifier
2899    SELECT  @ApplicationId = NULL
2900    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
2901    IF (@ApplicationId IS NULL)
2902    BEGIN
2903        SELECT 0
2904        RETURN
2905    END
2906
2907    SELECT  COUNT(*)
2908    FROM    dbo.aspnet_Users u, dbo.aspnet_Profile p
2909    WHERE   ApplicationId = @ApplicationId
2910        AND u.UserId = p.UserId
2911        AND (LastActivityDate <= @InactiveSinceDate)
2912        AND (
2913                (@ProfileAuthOptions = 2)
2914                OR (@ProfileAuthOptions = 0 AND IsAnonymous = 1)
2915                OR (@ProfileAuthOptions = 1 AND IsAnonymous = 0)
2916            )
2917END
2918GO
2919/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetProfiles]    Script Date: 16.2.2017. 14:59:48 ******/
2920SET ANSI_NULLS ON
2921GO
2922SET QUOTED_IDENTIFIER OFF
2923GO
2924
2925CREATE PROCEDURE [dbo].[aspnet_Profile_GetProfiles]
2926    @ApplicationName        nvarchar(256),
2927    @ProfileAuthOptions     int,
2928    @PageIndex              int,
2929    @PageSize               int,
2930    @UserNameToMatch        nvarchar(256) = NULL,
2931    @InactiveSinceDate      datetime      = NULL
2932AS
2933BEGIN
2934    DECLARE @ApplicationId uniqueidentifier
2935    SELECT  @ApplicationId = NULL
2936    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
2937    IF (@ApplicationId IS NULL)
2938        RETURN
2939
2940    -- Set the page bounds
2941    DECLARE @PageLowerBound int
2942    DECLARE @PageUpperBound int
2943    DECLARE @TotalRecords   int
2944    SET @PageLowerBound = @PageSize * @PageIndex
2945    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound
2946
2947    -- Create a temp table TO store the select results
2948    CREATE TABLE #PageIndexForUsers
2949    (
2950        IndexId int IDENTITY (0, 1) NOT NULL,
2951        UserId uniqueidentifier
2952    )
2953
2954    -- Insert into our temp table
2955    INSERT INTO #PageIndexForUsers (UserId)
2956        SELECT  u.UserId
2957        FROM    dbo.aspnet_Users u, dbo.aspnet_Profile p
2958        WHERE   ApplicationId = @ApplicationId
2959            AND u.UserId = p.UserId
2960            AND (@InactiveSinceDate IS NULL OR LastActivityDate <= @InactiveSinceDate)
2961            AND (     (@ProfileAuthOptions = 2)
2962                   OR (@ProfileAuthOptions = 0 AND IsAnonymous = 1)
2963                   OR (@ProfileAuthOptions = 1 AND IsAnonymous = 0)
2964                 )
2965            AND (@UserNameToMatch IS NULL OR LoweredUserName LIKE LOWER(@UserNameToMatch))
2966        ORDER BY UserName
2967
2968    SELECT  u.UserName, u.IsAnonymous, u.LastActivityDate, p.LastUpdatedDate,
2969            DATALENGTH(p.PropertyNames) + DATALENGTH(p.PropertyValuesString) + DATALENGTH(p.PropertyValuesBinary)
2970    FROM    dbo.aspnet_Users u, dbo.aspnet_Profile p, #PageIndexForUsers i
2971    WHERE   u.UserId = p.UserId AND p.UserId = i.UserId AND i.IndexId >= @PageLowerBound AND i.IndexId <= @PageUpperBound
2972
2973    SELECT COUNT(*)
2974    FROM   #PageIndexForUsers
2975
2976    DROP TABLE #PageIndexForUsers
2977END
2978GO
2979/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetProperties]    Script Date: 16.2.2017. 14:59:48 ******/
2980SET ANSI_NULLS ON
2981GO
2982SET QUOTED_IDENTIFIER OFF
2983GO
2984
2985CREATE PROCEDURE [dbo].[aspnet_Profile_GetProperties]
2986    @ApplicationName      nvarchar(256),
2987    @UserName             nvarchar(256),
2988    @CurrentTimeUtc       datetime
2989AS
2990BEGIN
2991    DECLARE @ApplicationId uniqueidentifier
2992    SELECT  @ApplicationId = NULL
2993    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
2994    IF (@ApplicationId IS NULL)
2995        RETURN
2996
2997    DECLARE @UserId uniqueidentifier
2998    SELECT  @UserId = NULL
2999
3000    SELECT @UserId = UserId
3001    FROM   dbo.aspnet_Users
3002    WHERE  ApplicationId = @ApplicationId AND LoweredUserName = LOWER(@UserName)
3003
3004    IF (@UserId IS NULL)
3005        RETURN
3006    SELECT TOP 1 PropertyNames, PropertyValuesString, PropertyValuesBinary
3007    FROM         dbo.aspnet_Profile
3008    WHERE        UserId = @UserId
3009
3010    IF (@@ROWCOUNT > 0)
3011    BEGIN
3012        UPDATE dbo.aspnet_Users
3013        SET    LastActivityDate=@CurrentTimeUtc
3014        WHERE  UserId = @UserId
3015    END
3016END
3017GO
3018/****** Object:  StoredProcedure [dbo].[aspnet_Profile_SetProperties]    Script Date: 16.2.2017. 14:59:48 ******/
3019SET ANSI_NULLS ON
3020GO
3021SET QUOTED_IDENTIFIER OFF
3022GO
3023
3024CREATE PROCEDURE [dbo].[aspnet_Profile_SetProperties]
3025    @ApplicationName        nvarchar(256),
3026    @PropertyNames          ntext,
3027    @PropertyValuesString   ntext,
3028    @PropertyValuesBinary   image,
3029    @UserName               nvarchar(256),
3030    @IsUserAnonymous        bit,
3031    @CurrentTimeUtc         datetime
3032AS
3033BEGIN
3034    DECLARE @ApplicationId uniqueidentifier
3035    SELECT  @ApplicationId = NULL
3036
3037    DECLARE @ErrorCode     int
3038    SET @ErrorCode = 0
3039
3040    DECLARE @TranStarted   bit
3041    SET @TranStarted = 0
3042
3043    IF( @@TRANCOUNT = 0 )
3044    BEGIN
3045       BEGIN TRANSACTION
3046       SET @TranStarted = 1
3047    END
3048    ELSE
3049    	SET @TranStarted = 0
3050
3051    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT
3052
3053    IF( @@ERROR <> 0 )
3054    BEGIN
3055        SET @ErrorCode = -1
3056        GOTO Cleanup
3057    END
3058
3059    DECLARE @UserId uniqueidentifier
3060    DECLARE @LastActivityDate datetime
3061    SELECT  @UserId = NULL
3062    SELECT  @LastActivityDate = @CurrentTimeUtc
3063
3064    SELECT @UserId = UserId
3065    FROM   dbo.aspnet_Users
3066    WHERE  ApplicationId = @ApplicationId AND LoweredUserName = LOWER(@UserName)
3067    IF (@UserId IS NULL)
3068        EXEC dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, @IsUserAnonymous, @LastActivityDate, @UserId OUTPUT
3069
3070    IF( @@ERROR <> 0 )
3071    BEGIN
3072        SET @ErrorCode = -1
3073        GOTO Cleanup
3074    END
3075
3076    UPDATE dbo.aspnet_Users
3077    SET    LastActivityDate=@CurrentTimeUtc
3078    WHERE  UserId = @UserId
3079
3080    IF( @@ERROR <> 0 )
3081    BEGIN
3082        SET @ErrorCode = -1
3083        GOTO Cleanup
3084    END
3085
3086    IF (EXISTS( SELECT *
3087               FROM   dbo.aspnet_Profile
3088               WHERE  UserId = @UserId))
3089        UPDATE dbo.aspnet_Profile
3090        SET    PropertyNames=@PropertyNames, PropertyValuesString = @PropertyValuesString,
3091               PropertyValuesBinary = @PropertyValuesBinary, LastUpdatedDate=@CurrentTimeUtc
3092        WHERE  UserId = @UserId
3093    ELSE
3094        INSERT INTO dbo.aspnet_Profile(UserId, PropertyNames, PropertyValuesString, PropertyValuesBinary, LastUpdatedDate)
3095             VALUES (@UserId, @PropertyNames, @PropertyValuesString, @PropertyValuesBinary, @CurrentTimeUtc)
3096
3097    IF( @@ERROR <> 0 )
3098    BEGIN
3099        SET @ErrorCode = -1
3100        GOTO Cleanup
3101    END
3102
3103    IF( @TranStarted = 1 )
3104    BEGIN
3105    	SET @TranStarted = 0
3106    	COMMIT TRANSACTION
3107    END
3108
3109    RETURN 0
3110
3111Cleanup:
3112
3113    IF( @TranStarted = 1 )
3114    BEGIN
3115        SET @TranStarted = 0
3116    	ROLLBACK TRANSACTION
3117    END
3118
3119    RETURN @ErrorCode
3120
3121END
3122GO
3123/****** Object:  StoredProcedure [dbo].[aspnet_RegisterSchemaVersion]    Script Date: 16.2.2017. 14:59:48 ******/
3124SET ANSI_NULLS ON
3125GO
3126SET QUOTED_IDENTIFIER OFF
3127GO
3128
3129CREATE PROCEDURE [dbo].[aspnet_RegisterSchemaVersion]
3130    @Feature                   nvarchar(128),
3131    @CompatibleSchemaVersion   nvarchar(128),
3132    @IsCurrentVersion          bit,
3133    @RemoveIncompatibleSchema  bit
3134AS
3135BEGIN
3136    IF( @RemoveIncompatibleSchema = 1 )
3137    BEGIN
3138        DELETE FROM dbo.aspnet_SchemaVersions WHERE Feature = LOWER( @Feature )
3139    END
3140    ELSE
3141    BEGIN
3142        IF( @IsCurrentVersion = 1 )
3143        BEGIN
3144            UPDATE dbo.aspnet_SchemaVersions
3145            SET IsCurrentVersion = 0
3146            WHERE Feature = LOWER( @Feature )
3147        END
3148    END
3149
3150    INSERT  dbo.aspnet_SchemaVersions( Feature, CompatibleSchemaVersion, IsCurrentVersion )
3151    VALUES( LOWER( @Feature ), @CompatibleSchemaVersion, @IsCurrentVersion )
3152END
3153GO
3154/****** Object:  StoredProcedure [dbo].[aspnet_Roles_CreateRole]    Script Date: 16.2.2017. 14:59:48 ******/
3155SET ANSI_NULLS ON
3156GO
3157SET QUOTED_IDENTIFIER OFF
3158GO
3159CREATE PROCEDURE [dbo].[aspnet_Roles_CreateRole]
3160    @ApplicationName  nvarchar(256),
3161    @RoleName         nvarchar(256)
3162AS
3163BEGIN
3164    DECLARE @ApplicationId uniqueidentifier
3165    SELECT  @ApplicationId = NULL
3166
3167    DECLARE @ErrorCode     int
3168    SET @ErrorCode = 0
3169
3170    DECLARE @TranStarted   bit
3171    SET @TranStarted = 0
3172
3173    IF( @@TRANCOUNT = 0 )
3174    BEGIN
3175        BEGIN TRANSACTION
3176        SET @TranStarted = 1
3177    END
3178    ELSE
3179        SET @TranStarted = 0
3180
3181    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT
3182
3183    IF( @@ERROR <> 0 )
3184    BEGIN
3185        SET @ErrorCode = -1
3186        GOTO Cleanup
3187    END
3188
3189    IF (EXISTS(SELECT RoleId FROM dbo.aspnet_Roles WHERE LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId))
3190    BEGIN
3191        SET @ErrorCode = 1
3192        GOTO Cleanup
3193    END
3194
3195    INSERT INTO dbo.aspnet_Roles
3196                (ApplicationId, RoleName, LoweredRoleName)
3197         VALUES (@ApplicationId, @RoleName, LOWER(@RoleName))
3198
3199    IF( @@ERROR <> 0 )
3200    BEGIN
3201        SET @ErrorCode = -1
3202        GOTO Cleanup
3203    END
3204
3205    IF( @TranStarted = 1 )
3206    BEGIN
3207        SET @TranStarted = 0
3208        COMMIT TRANSACTION
3209    END
3210
3211    RETURN(0)
3212
3213Cleanup:
3214
3215    IF( @TranStarted = 1 )
3216    BEGIN
3217        SET @TranStarted = 0
3218        ROLLBACK TRANSACTION
3219    END
3220
3221    RETURN @ErrorCode
3222
3223END
3224GO
3225/****** Object:  StoredProcedure [dbo].[aspnet_Roles_DeleteRole]    Script Date: 16.2.2017. 14:59:48 ******/
3226SET ANSI_NULLS ON
3227GO
3228SET QUOTED_IDENTIFIER OFF
3229GO
3230
3231CREATE PROCEDURE [dbo].[aspnet_Roles_DeleteRole]
3232    @ApplicationName            nvarchar(256),
3233    @RoleName                   nvarchar(256),
3234    @DeleteOnlyIfRoleIsEmpty    bit
3235AS
3236BEGIN
3237    DECLARE @ApplicationId uniqueidentifier
3238    SELECT  @ApplicationId = NULL
3239    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3240    IF (@ApplicationId IS NULL)
3241        RETURN(1)
3242
3243    DECLARE @ErrorCode     int
3244    SET @ErrorCode = 0
3245
3246    DECLARE @TranStarted   bit
3247    SET @TranStarted = 0
3248
3249    IF( @@TRANCOUNT = 0 )
3250    BEGIN
3251        BEGIN TRANSACTION
3252        SET @TranStarted = 1
3253    END
3254    ELSE
3255        SET @TranStarted = 0
3256
3257    DECLARE @RoleId   uniqueidentifier
3258    SELECT  @RoleId = NULL
3259    SELECT  @RoleId = RoleId FROM dbo.aspnet_Roles WHERE LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId
3260
3261    IF (@RoleId IS NULL)
3262    BEGIN
3263        SELECT @ErrorCode = 1
3264        GOTO Cleanup
3265    END
3266    IF (@DeleteOnlyIfRoleIsEmpty <> 0)
3267    BEGIN
3268        IF (EXISTS (SELECT RoleId FROM dbo.aspnet_UsersInRoles  WHERE @RoleId = RoleId))
3269        BEGIN
3270            SELECT @ErrorCode = 2
3271            GOTO Cleanup
3272        END
3273    END
3274
3275
3276    DELETE FROM dbo.aspnet_UsersInRoles  WHERE @RoleId = RoleId
3277
3278    IF( @@ERROR <> 0 )
3279    BEGIN
3280        SET @ErrorCode = -1
3281        GOTO Cleanup
3282    END
3283
3284    DELETE FROM dbo.aspnet_Roles WHERE @RoleId = RoleId  AND ApplicationId = @ApplicationId
3285
3286    IF( @@ERROR <> 0 )
3287    BEGIN
3288        SET @ErrorCode = -1
3289        GOTO Cleanup
3290    END
3291
3292    IF( @TranStarted = 1 )
3293    BEGIN
3294        SET @TranStarted = 0
3295        COMMIT TRANSACTION
3296    END
3297
3298    RETURN(0)
3299
3300Cleanup:
3301
3302    IF( @TranStarted = 1 )
3303    BEGIN
3304        SET @TranStarted = 0
3305        ROLLBACK TRANSACTION
3306    END
3307
3308    RETURN @ErrorCode
3309END
3310GO
3311/****** Object:  StoredProcedure [dbo].[aspnet_Roles_GetAllRoles]    Script Date: 16.2.2017. 14:59:48 ******/
3312SET ANSI_NULLS ON
3313GO
3314SET QUOTED_IDENTIFIER OFF
3315GO
3316
3317CREATE PROCEDURE [dbo].[aspnet_Roles_GetAllRoles] (
3318    @ApplicationName           nvarchar(256))
3319AS
3320BEGIN
3321    DECLARE @ApplicationId uniqueidentifier
3322    SELECT  @ApplicationId = NULL
3323    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3324    IF (@ApplicationId IS NULL)
3325        RETURN
3326    SELECT RoleName
3327    FROM   dbo.aspnet_Roles WHERE ApplicationId = @ApplicationId
3328    ORDER BY RoleName
3329END
3330GO
3331/****** Object:  StoredProcedure [dbo].[aspnet_Roles_RoleExists]    Script Date: 16.2.2017. 14:59:48 ******/
3332SET ANSI_NULLS ON
3333GO
3334SET QUOTED_IDENTIFIER OFF
3335GO
3336
3337CREATE PROCEDURE [dbo].[aspnet_Roles_RoleExists]
3338    @ApplicationName  nvarchar(256),
3339    @RoleName         nvarchar(256)
3340AS
3341BEGIN
3342    DECLARE @ApplicationId uniqueidentifier
3343    SELECT  @ApplicationId = NULL
3344    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3345    IF (@ApplicationId IS NULL)
3346        RETURN(0)
3347    IF (EXISTS (SELECT RoleName FROM dbo.aspnet_Roles WHERE LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId ))
3348        RETURN(1)
3349    ELSE
3350        RETURN(0)
3351END
3352GO
3353/****** Object:  StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers]    Script Date: 16.2.2017. 14:59:48 ******/
3354SET ANSI_NULLS ON
3355GO
3356SET QUOTED_IDENTIFIER OFF
3357GO
3358
3359CREATE PROCEDURE [dbo].[aspnet_Setup_RemoveAllRoleMembers]
3360    @name   sysname
3361AS
3362BEGIN
3363    CREATE TABLE #aspnet_RoleMembers
3364    (
3365        Group_name      sysname,
3366        Group_id        smallint,
3367        Users_in_group  sysname,
3368        User_id         smallint
3369    )
3370
3371    INSERT INTO #aspnet_RoleMembers
3372    EXEC sp_helpuser @name
3373
3374    DECLARE @user_id smallint
3375    DECLARE @cmd nvarchar(500)
3376    DECLARE c1 cursor FORWARD_ONLY FOR
3377        SELECT User_id FROM #aspnet_RoleMembers
3378
3379    OPEN c1
3380
3381    FETCH c1 INTO @user_id
3382    WHILE (@@fetch_status = 0)
3383    BEGIN
3384        SET @cmd = 'EXEC sp_droprolemember ' + '''' + @name + ''', ''' + USER_NAME(@user_id) + ''''
3385        EXEC (@cmd)
3386        FETCH c1 INTO @user_id
3387    END
3388
3389    CLOSE c1
3390    DEALLOCATE c1
3391END
3392GO
3393/****** Object:  StoredProcedure [dbo].[aspnet_Setup_RestorePermissions]    Script Date: 16.2.2017. 14:59:48 ******/
3394SET ANSI_NULLS ON
3395GO
3396SET QUOTED_IDENTIFIER OFF
3397GO
3398
3399CREATE PROCEDURE [dbo].[aspnet_Setup_RestorePermissions]
3400    @name   sysname
3401AS
3402BEGIN
3403    DECLARE @object sysname
3404    DECLARE @protectType char(10)
3405    DECLARE @action varchar(60)
3406    DECLARE @grantee sysname
3407    DECLARE @cmd nvarchar(500)
3408    DECLARE c1 cursor FORWARD_ONLY FOR
3409        SELECT Object, ProtectType, [Action], Grantee FROM #aspnet_Permissions where Object = @name
3410
3411    OPEN c1
3412
3413    FETCH c1 INTO @object, @protectType, @action, @grantee
3414    WHILE (@@fetch_status = 0)
3415    BEGIN
3416        SET @cmd = @protectType + ' ' + @action + ' on ' + @object + ' TO [' + @grantee + ']'
3417        EXEC (@cmd)
3418        FETCH c1 INTO @object, @protectType, @action, @grantee
3419    END
3420
3421    CLOSE c1
3422    DEALLOCATE c1
3423END
3424GO
3425/****** Object:  StoredProcedure [dbo].[aspnet_UnRegisterSchemaVersion]    Script Date: 16.2.2017. 14:59:48 ******/
3426SET ANSI_NULLS ON
3427GO
3428SET QUOTED_IDENTIFIER OFF
3429GO
3430
3431CREATE PROCEDURE [dbo].[aspnet_UnRegisterSchemaVersion]
3432    @Feature                   nvarchar(128),
3433    @CompatibleSchemaVersion   nvarchar(128)
3434AS
3435BEGIN
3436    DELETE FROM dbo.aspnet_SchemaVersions
3437        WHERE   Feature = LOWER(@Feature) AND @CompatibleSchemaVersion = CompatibleSchemaVersion
3438END
3439GO
3440/****** Object:  StoredProcedure [dbo].[aspnet_Users_CreateUser]    Script Date: 16.2.2017. 14:59:48 ******/
3441SET ANSI_NULLS ON
3442GO
3443SET QUOTED_IDENTIFIER OFF
3444GO
3445
3446CREATE PROCEDURE [dbo].[aspnet_Users_CreateUser]
3447    @ApplicationId    uniqueidentifier,
3448    @UserName         nvarchar(256),
3449    @IsUserAnonymous  bit,
3450    @LastActivityDate DATETIME,
3451    @UserId           uniqueidentifier OUTPUT
3452AS
3453BEGIN
3454    IF( @UserId IS NULL )
3455        SELECT @UserId = NEWID()
3456    ELSE
3457    BEGIN
3458        IF( EXISTS( SELECT UserId FROM dbo.aspnet_Users
3459                    WHERE @UserId = UserId ) )
3460            RETURN -1
3461    END
3462
3463    INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)
3464    VALUES (@ApplicationId, @UserId, @UserName, LOWER(@UserName), @IsUserAnonymous, @LastActivityDate)
3465
3466    RETURN 0
3467END
3468GO
3469/****** Object:  StoredProcedure [dbo].[aspnet_Users_DeleteUser]    Script Date: 16.2.2017. 14:59:48 ******/
3470SET ANSI_NULLS ON
3471GO
3472SET QUOTED_IDENTIFIER OFF
3473GO
3474CREATE PROCEDURE [dbo].[aspnet_Users_DeleteUser]
3475    @ApplicationName  nvarchar(256),
3476    @UserName         nvarchar(256),
3477    @TablesToDeleteFrom int,
3478    @NumTablesDeletedFrom int OUTPUT
3479AS
3480BEGIN
3481    DECLARE @UserId               uniqueidentifier
3482    SELECT  @UserId               = NULL
3483    SELECT  @NumTablesDeletedFrom = 0
3484
3485    DECLARE @TranStarted   bit
3486    SET @TranStarted = 0
3487
3488    IF( @@TRANCOUNT = 0 )
3489    BEGIN
3490	    BEGIN TRANSACTION
3491	    SET @TranStarted = 1
3492    END
3493    ELSE
3494	SET @TranStarted = 0
3495
3496    DECLARE @ErrorCode   int
3497    DECLARE @RowCount    int
3498
3499    SET @ErrorCode = 0
3500    SET @RowCount  = 0
3501
3502    SELECT  @UserId = u.UserId
3503    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a
3504    WHERE   u.LoweredUserName       = LOWER(@UserName)
3505        AND u.ApplicationId         = a.ApplicationId
3506        AND LOWER(@ApplicationName) = a.LoweredApplicationName
3507
3508    IF (@UserId IS NULL)
3509    BEGIN
3510        GOTO Cleanup
3511    END
3512
3513    -- Delete from Membership table if (@TablesToDeleteFrom & 1) is set
3514    IF ((@TablesToDeleteFrom & 1) <> 0 AND
3515        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_MembershipUsers') AND (type = 'V'))))
3516    BEGIN
3517        DELETE FROM dbo.aspnet_Membership WHERE @UserId = UserId
3518
3519        SELECT @ErrorCode = @@ERROR,
3520               @RowCount = @@ROWCOUNT
3521
3522        IF( @ErrorCode <> 0 )
3523            GOTO Cleanup
3524
3525        IF (@RowCount <> 0)
3526            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1
3527    END
3528
3529    -- Delete from aspnet_UsersInRoles table if (@TablesToDeleteFrom & 2) is set
3530    IF ((@TablesToDeleteFrom & 2) <> 0  AND
3531        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_UsersInRoles') AND (type = 'V'))) )
3532    BEGIN
3533        DELETE FROM dbo.aspnet_UsersInRoles WHERE @UserId = UserId
3534
3535        SELECT @ErrorCode = @@ERROR,
3536                @RowCount = @@ROWCOUNT
3537
3538        IF( @ErrorCode <> 0 )
3539            GOTO Cleanup
3540
3541        IF (@RowCount <> 0)
3542            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1
3543    END
3544
3545    -- Delete from aspnet_Profile table if (@TablesToDeleteFrom & 4) is set
3546    IF ((@TablesToDeleteFrom & 4) <> 0  AND
3547        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_Profiles') AND (type = 'V'))) )
3548    BEGIN
3549        DELETE FROM dbo.aspnet_Profile WHERE @UserId = UserId
3550
3551        SELECT @ErrorCode = @@ERROR,
3552                @RowCount = @@ROWCOUNT
3553
3554        IF( @ErrorCode <> 0 )
3555            GOTO Cleanup
3556
3557        IF (@RowCount <> 0)
3558            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1
3559    END
3560
3561    -- Delete from aspnet_PersonalizationPerUser table if (@TablesToDeleteFrom & 8) is set
3562    IF ((@TablesToDeleteFrom & 8) <> 0  AND
3563        (EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_WebPartState_User') AND (type = 'V'))) )
3564    BEGIN
3565        DELETE FROM dbo.aspnet_PersonalizationPerUser WHERE @UserId = UserId
3566
3567        SELECT @ErrorCode = @@ERROR,
3568                @RowCount = @@ROWCOUNT
3569
3570        IF( @ErrorCode <> 0 )
3571            GOTO Cleanup
3572
3573        IF (@RowCount <> 0)
3574            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1
3575    END
3576
3577    -- Delete from aspnet_Users table if (@TablesToDeleteFrom & 1,2,4 & 8) are all set
3578    IF ((@TablesToDeleteFrom & 1) <> 0 AND
3579        (@TablesToDeleteFrom & 2) <> 0 AND
3580        (@TablesToDeleteFrom & 4) <> 0 AND
3581        (@TablesToDeleteFrom & 8) <> 0 AND
3582        (EXISTS (SELECT UserId FROM dbo.aspnet_Users WHERE @UserId = UserId)))
3583    BEGIN
3584        DELETE FROM dbo.aspnet_Users WHERE @UserId = UserId
3585
3586        SELECT @ErrorCode = @@ERROR,
3587                @RowCount = @@ROWCOUNT
3588
3589        IF( @ErrorCode <> 0 )
3590            GOTO Cleanup
3591
3592        IF (@RowCount <> 0)
3593            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1
3594    END
3595
3596    IF( @TranStarted = 1 )
3597    BEGIN
3598	    SET @TranStarted = 0
3599	    COMMIT TRANSACTION
3600    END
3601
3602    RETURN 0
3603
3604Cleanup:
3605    SET @NumTablesDeletedFrom = 0
3606
3607    IF( @TranStarted = 1 )
3608    BEGIN
3609        SET @TranStarted = 0
3610	    ROLLBACK TRANSACTION
3611    END
3612
3613    RETURN @ErrorCode
3614
3615END
3616GO
3617/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_AddUsersToRoles]    Script Date: 16.2.2017. 14:59:48 ******/
3618SET ANSI_NULLS ON
3619GO
3620SET QUOTED_IDENTIFIER OFF
3621GO
3622
3623CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_AddUsersToRoles]
3624	@ApplicationName  nvarchar(256),
3625	@UserNames		  nvarchar(4000),
3626	@RoleNames		  nvarchar(4000),
3627	@CurrentTimeUtc   datetime
3628AS
3629BEGIN
3630	DECLARE @AppId uniqueidentifier
3631	SELECT  @AppId = NULL
3632	SELECT  @AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3633	IF (@AppId IS NULL)
3634		RETURN(2)
3635	DECLARE @TranStarted   bit
3636	SET @TranStarted = 0
3637
3638	IF( @@TRANCOUNT = 0 )
3639	BEGIN
3640		BEGIN TRANSACTION
3641		SET @TranStarted = 1
3642	END
3643
3644	DECLARE @tbNames	table(Name nvarchar(256) NOT NULL PRIMARY KEY)
3645	DECLARE @tbRoles	table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)
3646	DECLARE @tbUsers	table(UserId uniqueidentifier NOT NULL PRIMARY KEY)
3647	DECLARE @Num		int
3648	DECLARE @Pos		int
3649	DECLARE @NextPos	int
3650	DECLARE @Name		nvarchar(256)
3651
3652	SET @Num = 0
3653	SET @Pos = 1
3654	WHILE(@Pos <= LEN(@RoleNames))
3655	BEGIN
3656		SELECT @NextPos = CHARINDEX(N',', @RoleNames,  @Pos)
3657		IF (@NextPos = 0 OR @NextPos IS NULL)
3658			SELECT @NextPos = LEN(@RoleNames) + 1
3659		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@RoleNames, @Pos, @NextPos - @Pos)))
3660		SELECT @Pos = @NextPos+1
3661
3662		INSERT INTO @tbNames VALUES (@Name)
3663		SET @Num = @Num + 1
3664	END
3665
3666	INSERT INTO @tbRoles
3667	  SELECT RoleId
3668	  FROM   dbo.aspnet_Roles ar, @tbNames t
3669	  WHERE  LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @AppId
3670
3671	IF (@@ROWCOUNT <> @Num)
3672	BEGIN
3673		SELECT TOP 1 Name
3674		FROM   @tbNames
3675		WHERE  LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar,  @tbRoles r WHERE r.RoleId = ar.RoleId)
3676		IF( @TranStarted = 1 )
3677			ROLLBACK TRANSACTION
3678		RETURN(2)
3679	END
3680
3681	DELETE FROM @tbNames WHERE 1=1
3682	SET @Num = 0
3683	SET @Pos = 1
3684
3685	WHILE(@Pos <= LEN(@UserNames))
3686	BEGIN
3687		SELECT @NextPos = CHARINDEX(N',', @UserNames,  @Pos)
3688		IF (@NextPos = 0 OR @NextPos IS NULL)
3689			SELECT @NextPos = LEN(@UserNames) + 1
3690		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@UserNames, @Pos, @NextPos - @Pos)))
3691		SELECT @Pos = @NextPos+1
3692
3693		INSERT INTO @tbNames VALUES (@Name)
3694		SET @Num = @Num + 1
3695	END
3696
3697	INSERT INTO @tbUsers
3698	  SELECT UserId
3699	  FROM   dbo.aspnet_Users ar, @tbNames t
3700	  WHERE  LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @AppId
3701
3702	IF (@@ROWCOUNT <> @Num)
3703	BEGIN
3704		DELETE FROM @tbNames
3705		WHERE LOWER(Name) IN (SELECT LoweredUserName FROM dbo.aspnet_Users au,  @tbUsers u WHERE au.UserId = u.UserId)
3706
3707		INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)
3708		  SELECT @AppId, NEWID(), Name, LOWER(Name), 0, @CurrentTimeUtc
3709		  FROM   @tbNames
3710
3711		INSERT INTO @tbUsers
3712		  SELECT  UserId
3713		  FROM	dbo.aspnet_Users au, @tbNames t
3714		  WHERE   LOWER(t.Name) = au.LoweredUserName AND au.ApplicationId = @AppId
3715	END
3716
3717	IF (EXISTS (SELECT * FROM dbo.aspnet_UsersInRoles ur, @tbUsers tu, @tbRoles tr WHERE tu.UserId = ur.UserId AND tr.RoleId = ur.RoleId))
3718	BEGIN
3719		SELECT TOP 1 UserName, RoleName
3720		FROM		 dbo.aspnet_UsersInRoles ur, @tbUsers tu, @tbRoles tr, aspnet_Users u, aspnet_Roles r
3721		WHERE		u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND tu.UserId = ur.UserId AND tr.RoleId = ur.RoleId
3722
3723		IF( @TranStarted = 1 )
3724			ROLLBACK TRANSACTION
3725		RETURN(3)
3726	END
3727
3728	INSERT INTO dbo.aspnet_UsersInRoles (UserId, RoleId)
3729	SELECT UserId, RoleId
3730	FROM @tbUsers, @tbRoles
3731
3732	IF( @TranStarted = 1 )
3733		COMMIT TRANSACTION
3734	RETURN(0)
3735END                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
3736GO
3737/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_FindUsersInRole]    Script Date: 16.2.2017. 14:59:48 ******/
3738SET ANSI_NULLS ON
3739GO
3740SET QUOTED_IDENTIFIER OFF
3741GO
3742
3743CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_FindUsersInRole]
3744    @ApplicationName  nvarchar(256),
3745    @RoleName         nvarchar(256),
3746    @UserNameToMatch  nvarchar(256)
3747AS
3748BEGIN
3749    DECLARE @ApplicationId uniqueidentifier
3750    SELECT  @ApplicationId = NULL
3751    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3752    IF (@ApplicationId IS NULL)
3753        RETURN(1)
3754     DECLARE @RoleId uniqueidentifier
3755     SELECT  @RoleId = NULL
3756
3757     SELECT  @RoleId = RoleId
3758     FROM    dbo.aspnet_Roles
3759     WHERE   LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId
3760
3761     IF (@RoleId IS NULL)
3762         RETURN(1)
3763
3764    SELECT u.UserName
3765    FROM   dbo.aspnet_Users u, dbo.aspnet_UsersInRoles ur
3766    WHERE  u.UserId = ur.UserId AND @RoleId = ur.RoleId AND u.ApplicationId = @ApplicationId AND LoweredUserName LIKE LOWER(@UserNameToMatch)
3767    ORDER BY u.UserName
3768    RETURN(0)
3769END
3770GO
3771/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_GetRolesForUser]    Script Date: 16.2.2017. 14:59:48 ******/
3772SET ANSI_NULLS ON
3773GO
3774SET QUOTED_IDENTIFIER OFF
3775GO
3776
3777CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_GetRolesForUser]
3778    @ApplicationName  nvarchar(256),
3779    @UserName         nvarchar(256)
3780AS
3781BEGIN
3782    DECLARE @ApplicationId uniqueidentifier
3783    SELECT  @ApplicationId = NULL
3784    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3785    IF (@ApplicationId IS NULL)
3786        RETURN(1)
3787    DECLARE @UserId uniqueidentifier
3788    SELECT  @UserId = NULL
3789
3790    SELECT  @UserId = UserId
3791    FROM    dbo.aspnet_Users
3792    WHERE   LoweredUserName = LOWER(@UserName) AND ApplicationId = @ApplicationId
3793
3794    IF (@UserId IS NULL)
3795        RETURN(1)
3796
3797    SELECT r.RoleName
3798    FROM   dbo.aspnet_Roles r, dbo.aspnet_UsersInRoles ur
3799    WHERE  r.RoleId = ur.RoleId AND r.ApplicationId = @ApplicationId AND ur.UserId = @UserId
3800    ORDER BY r.RoleName
3801    RETURN (0)
3802END
3803GO
3804/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_GetUsersInRoles]    Script Date: 16.2.2017. 14:59:48 ******/
3805SET ANSI_NULLS ON
3806GO
3807SET QUOTED_IDENTIFIER OFF
3808GO
3809
3810CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_GetUsersInRoles]
3811    @ApplicationName  nvarchar(256),
3812    @RoleName         nvarchar(256)
3813AS
3814BEGIN
3815    DECLARE @ApplicationId uniqueidentifier
3816    SELECT  @ApplicationId = NULL
3817    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3818    IF (@ApplicationId IS NULL)
3819        RETURN(1)
3820     DECLARE @RoleId uniqueidentifier
3821     SELECT  @RoleId = NULL
3822
3823     SELECT  @RoleId = RoleId
3824     FROM    dbo.aspnet_Roles
3825     WHERE   LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId
3826
3827     IF (@RoleId IS NULL)
3828         RETURN(1)
3829
3830    SELECT u.UserName
3831    FROM   dbo.aspnet_Users u, dbo.aspnet_UsersInRoles ur
3832    WHERE  u.UserId = ur.UserId AND @RoleId = ur.RoleId AND u.ApplicationId = @ApplicationId
3833    ORDER BY u.UserName
3834    RETURN(0)
3835END
3836GO
3837/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_IsUserInRole]    Script Date: 16.2.2017. 14:59:48 ******/
3838SET ANSI_NULLS ON
3839GO
3840SET QUOTED_IDENTIFIER OFF
3841GO
3842
3843CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_IsUserInRole]
3844    @ApplicationName  nvarchar(256),
3845    @UserName         nvarchar(256),
3846    @RoleName         nvarchar(256)
3847AS
3848BEGIN
3849    DECLARE @ApplicationId uniqueidentifier
3850    SELECT  @ApplicationId = NULL
3851    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3852    IF (@ApplicationId IS NULL)
3853        RETURN(2)
3854    DECLARE @UserId uniqueidentifier
3855    SELECT  @UserId = NULL
3856    DECLARE @RoleId uniqueidentifier
3857    SELECT  @RoleId = NULL
3858
3859    SELECT  @UserId = UserId
3860    FROM    dbo.aspnet_Users
3861    WHERE   LoweredUserName = LOWER(@UserName) AND ApplicationId = @ApplicationId
3862
3863    IF (@UserId IS NULL)
3864        RETURN(2)
3865
3866    SELECT  @RoleId = RoleId
3867    FROM    dbo.aspnet_Roles
3868    WHERE   LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId
3869
3870    IF (@RoleId IS NULL)
3871        RETURN(3)
3872
3873    IF (EXISTS( SELECT * FROM dbo.aspnet_UsersInRoles WHERE  UserId = @UserId AND RoleId = @RoleId))
3874        RETURN(1)
3875    ELSE
3876        RETURN(0)
3877END
3878GO
3879/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]    Script Date: 16.2.2017. 14:59:48 ******/
3880SET ANSI_NULLS ON
3881GO
3882SET QUOTED_IDENTIFIER OFF
3883GO
3884
3885CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]
3886	@ApplicationName  nvarchar(256),
3887	@UserNames		  nvarchar(4000),
3888	@RoleNames		  nvarchar(4000)
3889AS
3890BEGIN
3891	DECLARE @AppId uniqueidentifier
3892	SELECT  @AppId = NULL
3893	SELECT  @AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
3894	IF (@AppId IS NULL)
3895		RETURN(2)
3896
3897
3898	DECLARE @TranStarted   bit
3899	SET @TranStarted = 0
3900
3901	IF( @@TRANCOUNT = 0 )
3902	BEGIN
3903		BEGIN TRANSACTION
3904		SET @TranStarted = 1
3905	END
3906
3907	DECLARE @tbNames  table(Name nvarchar(256) NOT NULL PRIMARY KEY)
3908	DECLARE @tbRoles  table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)
3909	DECLARE @tbUsers  table(UserId uniqueidentifier NOT NULL PRIMARY KEY)
3910	DECLARE @Num	  int
3911	DECLARE @Pos	  int
3912	DECLARE @NextPos  int
3913	DECLARE @Name	  nvarchar(256)
3914	DECLARE @CountAll int
3915	DECLARE @CountU	  int
3916	DECLARE @CountR	  int
3917
3918
3919	SET @Num = 0
3920	SET @Pos = 1
3921	WHILE(@Pos <= LEN(@RoleNames))
3922	BEGIN
3923		SELECT @NextPos = CHARINDEX(N',', @RoleNames,  @Pos)
3924		IF (@NextPos = 0 OR @NextPos IS NULL)
3925			SELECT @NextPos = LEN(@RoleNames) + 1
3926		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@RoleNames, @Pos, @NextPos - @Pos)))
3927		SELECT @Pos = @NextPos+1
3928
3929		INSERT INTO @tbNames VALUES (@Name)
3930		SET @Num = @Num + 1
3931	END
3932
3933	INSERT INTO @tbRoles
3934	  SELECT RoleId
3935	  FROM   dbo.aspnet_Roles ar, @tbNames t
3936	  WHERE  LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @AppId
3937	SELECT @CountR = @@ROWCOUNT
3938
3939	IF (@CountR <> @Num)
3940	BEGIN
3941		SELECT TOP 1 N'', Name
3942		FROM   @tbNames
3943		WHERE  LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar,  @tbRoles r WHERE r.RoleId = ar.RoleId)
3944		IF( @TranStarted = 1 )
3945			ROLLBACK TRANSACTION
3946		RETURN(2)
3947	END
3948
3949
3950	DELETE FROM @tbNames WHERE 1=1
3951	SET @Num = 0
3952	SET @Pos = 1
3953
3954
3955	WHILE(@Pos <= LEN(@UserNames))
3956	BEGIN
3957		SELECT @NextPos = CHARINDEX(N',', @UserNames,  @Pos)
3958		IF (@NextPos = 0 OR @NextPos IS NULL)
3959			SELECT @NextPos = LEN(@UserNames) + 1
3960		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@UserNames, @Pos, @NextPos - @Pos)))
3961		SELECT @Pos = @NextPos+1
3962
3963		INSERT INTO @tbNames VALUES (@Name)
3964		SET @Num = @Num + 1
3965	END
3966
3967	INSERT INTO @tbUsers
3968	  SELECT UserId
3969	  FROM   dbo.aspnet_Users ar, @tbNames t
3970	  WHERE  LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @AppId
3971
3972	SELECT @CountU = @@ROWCOUNT
3973	IF (@CountU <> @Num)
3974	BEGIN
3975		SELECT TOP 1 Name, N''
3976		FROM   @tbNames
3977		WHERE  LOWER(Name) NOT IN (SELECT au.LoweredUserName FROM dbo.aspnet_Users au,  @tbUsers u WHERE u.UserId = au.UserId)
3978
3979		IF( @TranStarted = 1 )
3980			ROLLBACK TRANSACTION
3981		RETURN(1)
3982	END
3983
3984	SELECT  @CountAll = COUNT(*)
3985	FROM	dbo.aspnet_UsersInRoles ur, @tbUsers u, @tbRoles r
3986	WHERE   ur.UserId = u.UserId AND ur.RoleId = r.RoleId
3987
3988	IF (@CountAll <> @CountU * @CountR)
3989	BEGIN
3990		SELECT TOP 1 UserName, RoleName
3991		FROM		 @tbUsers tu, @tbRoles tr, dbo.aspnet_Users u, dbo.aspnet_Roles r
3992		WHERE		 u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND
3993					 tu.UserId NOT IN (SELECT ur.UserId FROM dbo.aspnet_UsersInRoles ur WHERE ur.RoleId = tr.RoleId) AND
3994					 tr.RoleId NOT IN (SELECT ur.RoleId FROM dbo.aspnet_UsersInRoles ur WHERE ur.UserId = tu.UserId)
3995		IF( @TranStarted = 1 )
3996			ROLLBACK TRANSACTION
3997		RETURN(3)
3998	END
3999
4000	DELETE FROM dbo.aspnet_UsersInRoles
4001	WHERE UserId IN (SELECT UserId FROM @tbUsers)
4002	  AND RoleId IN (SELECT RoleId FROM @tbRoles)
4003	IF( @TranStarted = 1 )
4004		COMMIT TRANSACTION
4005	RETURN(0)
4006END
4007                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
4008GO
4009/****** Object:  StoredProcedure [dbo].[aspnet_WebEvent_LogEvent]    Script Date: 16.2.2017. 14:59:48 ******/
4010SET ANSI_NULLS ON
4011GO
4012SET QUOTED_IDENTIFIER OFF
4013GO
4014CREATE PROCEDURE [dbo].[aspnet_WebEvent_LogEvent]
4015        @EventId         char(32),
4016        @EventTimeUtc    datetime,
4017        @EventTime       datetime,
4018        @EventType       nvarchar(256),
4019        @EventSequence   decimal(19,0),
4020        @EventOccurrence decimal(19,0),
4021        @EventCode       int,
4022        @EventDetailCode int,
4023        @Message         nvarchar(1024),
4024        @ApplicationPath nvarchar(256),
4025        @ApplicationVirtualPath nvarchar(256),
4026        @MachineName    nvarchar(256),
4027        @RequestUrl      nvarchar(1024),
4028        @ExceptionType   nvarchar(256),
4029        @Details         ntext
4030AS
4031BEGIN
4032    INSERT
4033        dbo.aspnet_WebEvent_Events
4034        (
4035            EventId,
4036            EventTimeUtc,
4037            EventTime,
4038            EventType,
4039            EventSequence,
4040            EventOccurrence,
4041            EventCode,
4042            EventDetailCode,
4043            Message,
4044            ApplicationPath,
4045            ApplicationVirtualPath,
4046            MachineName,
4047            RequestUrl,
4048            ExceptionType,
4049            Details
4050        )
4051    VALUES
4052    (
4053        @EventId,
4054        @EventTimeUtc,
4055        @EventTime,
4056        @EventType,
4057        @EventSequence,
4058        @EventOccurrence,
4059        @EventCode,
4060        @EventDetailCode,
4061        @Message,
4062        @ApplicationPath,
4063        @ApplicationVirtualPath,
4064        @MachineName,
4065        @RequestUrl,
4066        @ExceptionType,
4067        @Details
4068    )
4069END
4070GO
4071USE [master]
4072GO
4073ALTER DATABASE [UTO2015] SET  READ_WRITE 
4074GO