· 8 years ago · Apr 25, 2018, 01:36 PM
1USE [TreinandoDotNet]
2GO
3/****** Object: Role [aspnet_Membership_BasicAccess] Script Date: 12/10/2011 11:49:45 ******/
4CREATE ROLE [aspnet_Membership_BasicAccess] AUTHORIZATION [dbo]
5GO
6/****** Object: Role [aspnet_Membership_FullAccess] Script Date: 12/10/2011 11:49:45 ******/
7CREATE ROLE [aspnet_Membership_FullAccess] AUTHORIZATION [dbo]
8GO
9/****** Object: Role [aspnet_Membership_ReportingAccess] Script Date: 12/10/2011 11:49:45 ******/
10CREATE ROLE [aspnet_Membership_ReportingAccess] AUTHORIZATION [dbo]
11GO
12/****** Object: Role [aspnet_Personalization_BasicAccess] Script Date: 12/10/2011 11:49:45 ******/
13CREATE ROLE [aspnet_Personalization_BasicAccess] AUTHORIZATION [dbo]
14GO
15/****** Object: Role [aspnet_Personalization_FullAccess] Script Date: 12/10/2011 11:49:45 ******/
16CREATE ROLE [aspnet_Personalization_FullAccess] AUTHORIZATION [dbo]
17GO
18/****** Object: Role [aspnet_Personalization_ReportingAccess] Script Date: 12/10/2011 11:49:45 ******/
19CREATE ROLE [aspnet_Personalization_ReportingAccess] AUTHORIZATION [dbo]
20GO
21/****** Object: Role [aspnet_Profile_BasicAccess] Script Date: 12/10/2011 11:49:45 ******/
22CREATE ROLE [aspnet_Profile_BasicAccess] AUTHORIZATION [dbo]
23GO
24/****** Object: Role [aspnet_Profile_FullAccess] Script Date: 12/10/2011 11:49:45 ******/
25CREATE ROLE [aspnet_Profile_FullAccess] AUTHORIZATION [dbo]
26GO
27/****** Object: Role [aspnet_Profile_ReportingAccess] Script Date: 12/10/2011 11:49:45 ******/
28CREATE ROLE [aspnet_Profile_ReportingAccess] AUTHORIZATION [dbo]
29GO
30/****** Object: Role [aspnet_Roles_BasicAccess] Script Date: 12/10/2011 11:49:45 ******/
31CREATE ROLE [aspnet_Roles_BasicAccess] AUTHORIZATION [dbo]
32GO
33/****** Object: Role [aspnet_Roles_FullAccess] Script Date: 12/10/2011 11:49:45 ******/
34CREATE ROLE [aspnet_Roles_FullAccess] AUTHORIZATION [dbo]
35GO
36/****** Object: Role [aspnet_Roles_ReportingAccess] Script Date: 12/10/2011 11:49:45 ******/
37CREATE ROLE [aspnet_Roles_ReportingAccess] AUTHORIZATION [dbo]
38GO
39/****** Object: Role [aspnet_WebEvent_FullAccess] Script Date: 12/10/2011 11:49:45 ******/
40CREATE ROLE [aspnet_WebEvent_FullAccess] AUTHORIZATION [dbo]
41GO
42/****** Object: Schema [aspnet_Membership_BasicAccess] Script Date: 12/10/2011 11:49:35 ******/
43CREATE SCHEMA [aspnet_Membership_BasicAccess] AUTHORIZATION [aspnet_Membership_BasicAccess]
44GO
45/****** Object: Schema [aspnet_Membership_FullAccess] Script Date: 12/10/2011 11:49:35 ******/
46CREATE SCHEMA [aspnet_Membership_FullAccess] AUTHORIZATION [aspnet_Membership_FullAccess]
47GO
48/****** Object: Schema [aspnet_Membership_ReportingAccess] Script Date: 12/10/2011 11:49:35 ******/
49CREATE SCHEMA [aspnet_Membership_ReportingAccess] AUTHORIZATION [aspnet_Membership_ReportingAccess]
50GO
51/****** Object: Schema [aspnet_Personalization_BasicAccess] Script Date: 12/10/2011 11:49:35 ******/
52CREATE SCHEMA [aspnet_Personalization_BasicAccess] AUTHORIZATION [aspnet_Personalization_BasicAccess]
53GO
54/****** Object: Schema [aspnet_Personalization_FullAccess] Script Date: 12/10/2011 11:49:35 ******/
55CREATE SCHEMA [aspnet_Personalization_FullAccess] AUTHORIZATION [aspnet_Personalization_FullAccess]
56GO
57/****** Object: Schema [aspnet_Personalization_ReportingAccess] Script Date: 12/10/2011 11:49:35 ******/
58CREATE SCHEMA [aspnet_Personalization_ReportingAccess] AUTHORIZATION [aspnet_Personalization_ReportingAccess]
59GO
60/****** Object: Schema [aspnet_Profile_BasicAccess] Script Date: 12/10/2011 11:49:35 ******/
61CREATE SCHEMA [aspnet_Profile_BasicAccess] AUTHORIZATION [aspnet_Profile_BasicAccess]
62GO
63/****** Object: Schema [aspnet_Profile_FullAccess] Script Date: 12/10/2011 11:49:35 ******/
64CREATE SCHEMA [aspnet_Profile_FullAccess] AUTHORIZATION [aspnet_Profile_FullAccess]
65GO
66/****** Object: Schema [aspnet_Profile_ReportingAccess] Script Date: 12/10/2011 11:49:35 ******/
67CREATE SCHEMA [aspnet_Profile_ReportingAccess] AUTHORIZATION [aspnet_Profile_ReportingAccess]
68GO
69/****** Object: Schema [aspnet_Roles_BasicAccess] Script Date: 12/10/2011 11:49:35 ******/
70CREATE SCHEMA [aspnet_Roles_BasicAccess] AUTHORIZATION [aspnet_Roles_BasicAccess]
71GO
72/****** Object: Schema [aspnet_Roles_FullAccess] Script Date: 12/10/2011 11:49:35 ******/
73CREATE SCHEMA [aspnet_Roles_FullAccess] AUTHORIZATION [aspnet_Roles_FullAccess]
74GO
75/****** Object: Schema [aspnet_Roles_ReportingAccess] Script Date: 12/10/2011 11:49:35 ******/
76CREATE SCHEMA [aspnet_Roles_ReportingAccess] AUTHORIZATION [aspnet_Roles_ReportingAccess]
77GO
78/****** Object: Schema [aspnet_WebEvent_FullAccess] Script Date: 12/10/2011 11:49:35 ******/
79CREATE SCHEMA [aspnet_WebEvent_FullAccess] AUTHORIZATION [aspnet_WebEvent_FullAccess]
80GO
81/****** Object: Table [dbo].[aspnet_Applications] Script Date: 12/10/2011 11:49:44 ******/
82SET ANSI_NULLS ON
83GO
84SET QUOTED_IDENTIFIER ON
85GO
86CREATE TABLE [dbo].[aspnet_Applications](
87 [ApplicationName] [nvarchar](256) NOT NULL,
88 [LoweredApplicationName] [nvarchar](256) NOT NULL,
89 [ApplicationId] [uniqueidentifier] NOT NULL,
90 [Description] [nvarchar](256) NULL,
91PRIMARY KEY NONCLUSTERED
92(
93 [ApplicationId] ASC
94)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
95UNIQUE NONCLUSTERED
96(
97 [LoweredApplicationName] ASC
98)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
99UNIQUE NONCLUSTERED
100(
101 [ApplicationName] ASC
102)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
103) ON [PRIMARY]
104GO
105/****** Object: Table [dbo].[aspnet_WebEvent_Events] Script Date: 12/10/2011 11:49:44 ******/
106SET ANSI_NULLS ON
107GO
108SET QUOTED_IDENTIFIER ON
109GO
110SET ANSI_PADDING ON
111GO
112CREATE TABLE [dbo].[aspnet_WebEvent_Events](
113 [EventId] [char](32) NOT NULL,
114 [EventTimeUtc] [datetime] NOT NULL,
115 [EventTime] [datetime] NOT NULL,
116 [EventType] [nvarchar](256) NOT NULL,
117 [EventSequence] [decimal](19, 0) NOT NULL,
118 [EventOccurrence] [decimal](19, 0) NOT NULL,
119 [EventCode] [int] NOT NULL,
120 [EventDetailCode] [int] NOT NULL,
121 [Message] [nvarchar](1024) NULL,
122 [ApplicationPath] [nvarchar](256) NULL,
123 [ApplicationVirtualPath] [nvarchar](256) NULL,
124 [MachineName] [nvarchar](256) NOT NULL,
125 [RequestUrl] [nvarchar](1024) NULL,
126 [ExceptionType] [nvarchar](256) NULL,
127 [Details] [ntext] NULL,
128PRIMARY KEY CLUSTERED
129(
130 [EventId] ASC
131)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
132) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
133GO
134SET ANSI_PADDING OFF
135GO
136/****** Object: StoredProcedure [dbo].[aspnet_Setup_RestorePermissions] Script Date: 12/10/2011 11:49:42 ******/
137SET ANSI_NULLS ON
138GO
139SET QUOTED_IDENTIFIER OFF
140GO
141CREATE PROCEDURE [dbo].[aspnet_Setup_RestorePermissions]
142 @name sysname
143AS
144BEGIN
145 DECLARE @object sysname
146 DECLARE @protectType char(10)
147 DECLARE @action varchar(60)
148 DECLARE @grantee sysname
149 DECLARE @cmd nvarchar(500)
150 DECLARE c1 cursor FORWARD_ONLY FOR
151 SELECT Object, ProtectType, [Action], Grantee FROM #aspnet_Permissions where Object = @name
152
153 OPEN c1
154
155 FETCH c1 INTO @object, @protectType, @action, @grantee
156 WHILE (@@fetch_status = 0)
157 BEGIN
158 SET @cmd = @protectType + ' ' + @action + ' on ' + @object + ' TO [' + @grantee + ']'
159 EXEC (@cmd)
160 FETCH c1 INTO @object, @protectType, @action, @grantee
161 END
162
163 CLOSE c1
164 DEALLOCATE c1
165END
166GO
167/****** Object: StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers] Script Date: 12/10/2011 11:49:42 ******/
168SET ANSI_NULLS ON
169GO
170SET QUOTED_IDENTIFIER OFF
171GO
172CREATE PROCEDURE [dbo].[aspnet_Setup_RemoveAllRoleMembers]
173 @name sysname
174AS
175BEGIN
176 CREATE TABLE #aspnet_RoleMembers
177 (
178 Group_name sysname,
179 Group_id smallint,
180 Users_in_group sysname,
181 User_id smallint
182 )
183
184 INSERT INTO #aspnet_RoleMembers
185 EXEC sp_helpuser @name
186
187 DECLARE @user_id smallint
188 DECLARE @cmd nvarchar(500)
189 DECLARE c1 cursor FORWARD_ONLY FOR
190 SELECT User_id FROM #aspnet_RoleMembers
191
192 OPEN c1
193
194 FETCH c1 INTO @user_id
195 WHILE (@@fetch_status = 0)
196 BEGIN
197 SET @cmd = 'EXEC sp_droprolemember ' + '''' + @name + ''', ''' + USER_NAME(@user_id) + ''''
198 EXEC (@cmd)
199 FETCH c1 INTO @user_id
200 END
201
202 CLOSE c1
203 DEALLOCATE c1
204END
205GO
206/****** Object: Table [dbo].[aspnet_SchemaVersions] Script Date: 12/10/2011 11:49:44 ******/
207SET ANSI_NULLS ON
208GO
209SET QUOTED_IDENTIFIER ON
210GO
211CREATE TABLE [dbo].[aspnet_SchemaVersions](
212 [Feature] [nvarchar](128) NOT NULL,
213 [CompatibleSchemaVersion] [nvarchar](128) NOT NULL,
214 [IsCurrentVersion] [bit] NOT NULL,
215PRIMARY KEY CLUSTERED
216(
217 [Feature] ASC,
218 [CompatibleSchemaVersion] ASC
219)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
220) ON [PRIMARY]
221GO
222/****** Object: Table [dbo].[Categoria] Script Date: 12/10/2011 11:49:44 ******/
223SET ANSI_NULLS ON
224GO
225SET QUOTED_IDENTIFIER ON
226GO
227SET ANSI_PADDING ON
228GO
229CREATE TABLE [dbo].[Categoria](
230 [catCodigo] [int] IDENTITY(1,1) NOT NULL,
231 [catNome] [varchar](max) NULL,
232 CONSTRAINT [PK_Categoria] PRIMARY KEY CLUSTERED
233(
234 [catCodigo] ASC
235)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
236) ON [PRIMARY]
237GO
238SET ANSI_PADDING OFF
239GO
240/****** Object: StoredProcedure [dbo].[aspnet_WebEvent_LogEvent] Script Date: 12/10/2011 11:49:42 ******/
241SET ANSI_NULLS ON
242GO
243SET QUOTED_IDENTIFIER OFF
244GO
245CREATE PROCEDURE [dbo].[aspnet_WebEvent_LogEvent]
246 @EventId char(32),
247 @EventTimeUtc datetime,
248 @EventTime datetime,
249 @EventType nvarchar(256),
250 @EventSequence decimal(19,0),
251 @EventOccurrence decimal(19,0),
252 @EventCode int,
253 @EventDetailCode int,
254 @Message nvarchar(1024),
255 @ApplicationPath nvarchar(256),
256 @ApplicationVirtualPath nvarchar(256),
257 @MachineName nvarchar(256),
258 @RequestUrl nvarchar(1024),
259 @ExceptionType nvarchar(256),
260 @Details ntext
261AS
262BEGIN
263 INSERT
264 dbo.aspnet_WebEvent_Events
265 (
266 EventId,
267 EventTimeUtc,
268 EventTime,
269 EventType,
270 EventSequence,
271 EventOccurrence,
272 EventCode,
273 EventDetailCode,
274 Message,
275 ApplicationPath,
276 ApplicationVirtualPath,
277 MachineName,
278 RequestUrl,
279 ExceptionType,
280 Details
281 )
282 VALUES
283 (
284 @EventId,
285 @EventTimeUtc,
286 @EventTime,
287 @EventType,
288 @EventSequence,
289 @EventOccurrence,
290 @EventCode,
291 @EventDetailCode,
292 @Message,
293 @ApplicationPath,
294 @ApplicationVirtualPath,
295 @MachineName,
296 @RequestUrl,
297 @ExceptionType,
298 @Details
299 )
300END
301GO
302/****** Object: Table [dbo].[Produto] Script Date: 12/10/2011 11:49:44 ******/
303SET ANSI_NULLS ON
304GO
305SET QUOTED_IDENTIFIER ON
306GO
307SET ANSI_PADDING ON
308GO
309CREATE TABLE [dbo].[Produto](
310 [proCodigo] [int] IDENTITY(1,1) NOT NULL,
311 [catCodigo] [int] NOT NULL,
312 [proNome] [varchar](max) NOT NULL,
313 [proDescricao] [varchar](max) NOT NULL,
314 [proDesenvolvedor] [varchar](max) NOT NULL,
315 [proDataLancamento] [datetime] NOT NULL,
316 [proClassificacao] [varchar](10) NOT NULL,
317 CONSTRAINT [PK_Produto] PRIMARY KEY CLUSTERED
318(
319 [proCodigo] ASC
320)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
321) ON [PRIMARY]
322GO
323SET ANSI_PADDING OFF
324GO
325/****** Object: View [dbo].[vw_aspnet_Applications] Script Date: 12/10/2011 11:49:45 ******/
326SET ANSI_NULLS ON
327GO
328SET QUOTED_IDENTIFIER OFF
329GO
330CREATE VIEW [dbo].[vw_aspnet_Applications]
331 AS SELECT [dbo].[aspnet_Applications].[ApplicationName], [dbo].[aspnet_Applications].[LoweredApplicationName], [dbo].[aspnet_Applications].[ApplicationId], [dbo].[aspnet_Applications].[Description]
332 FROM [dbo].[aspnet_Applications]
333GO
334/****** Object: Table [dbo].[aspnet_Users] Script Date: 12/10/2011 11:49:44 ******/
335SET ANSI_NULLS ON
336GO
337SET QUOTED_IDENTIFIER ON
338GO
339CREATE TABLE [dbo].[aspnet_Users](
340 [ApplicationId] [uniqueidentifier] NOT NULL,
341 [UserId] [uniqueidentifier] NOT NULL,
342 [UserName] [nvarchar](256) NOT NULL,
343 [LoweredUserName] [nvarchar](256) NOT NULL,
344 [MobileAlias] [nvarchar](16) NULL,
345 [IsAnonymous] [bit] NOT NULL,
346 [LastActivityDate] [datetime] NOT NULL,
347PRIMARY KEY NONCLUSTERED
348(
349 [UserId] ASC
350)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
351) ON [PRIMARY]
352GO
353/****** Object: StoredProcedure [dbo].[aspnet_UnRegisterSchemaVersion] Script Date: 12/10/2011 11:49:42 ******/
354SET ANSI_NULLS ON
355GO
356SET QUOTED_IDENTIFIER OFF
357GO
358CREATE PROCEDURE [dbo].[aspnet_UnRegisterSchemaVersion]
359 @Feature nvarchar(128),
360 @CompatibleSchemaVersion nvarchar(128)
361AS
362BEGIN
363 DELETE FROM dbo.aspnet_SchemaVersions
364 WHERE Feature = LOWER(@Feature) AND @CompatibleSchemaVersion = CompatibleSchemaVersion
365END
366GO
367/****** Object: StoredProcedure [dbo].[aspnet_CheckSchemaVersion] Script Date: 12/10/2011 11:49:42 ******/
368SET ANSI_NULLS ON
369GO
370SET QUOTED_IDENTIFIER OFF
371GO
372CREATE PROCEDURE [dbo].[aspnet_CheckSchemaVersion]
373 @Feature nvarchar(128),
374 @CompatibleSchemaVersion nvarchar(128)
375AS
376BEGIN
377 IF (EXISTS( SELECT *
378 FROM dbo.aspnet_SchemaVersions
379 WHERE Feature = LOWER( @Feature ) AND
380 CompatibleSchemaVersion = @CompatibleSchemaVersion ))
381 RETURN 0
382
383 RETURN 1
384END
385GO
386/****** Object: StoredProcedure [dbo].[aspnet_Applications_CreateApplication] Script Date: 12/10/2011 11:49:42 ******/
387SET ANSI_NULLS ON
388GO
389SET QUOTED_IDENTIFIER OFF
390GO
391CREATE PROCEDURE [dbo].[aspnet_Applications_CreateApplication]
392 @ApplicationName nvarchar(256),
393 @ApplicationId uniqueidentifier OUTPUT
394AS
395BEGIN
396 SELECT @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
397
398 IF(@ApplicationId IS NULL)
399 BEGIN
400 DECLARE @TranStarted bit
401 SET @TranStarted = 0
402
403 IF( @@TRANCOUNT = 0 )
404 BEGIN
405 BEGIN TRANSACTION
406 SET @TranStarted = 1
407 END
408 ELSE
409 SET @TranStarted = 0
410
411 SELECT @ApplicationId = ApplicationId
412 FROM dbo.aspnet_Applications WITH (UPDLOCK, HOLDLOCK)
413 WHERE LOWER(@ApplicationName) = LoweredApplicationName
414
415 IF(@ApplicationId IS NULL)
416 BEGIN
417 SELECT @ApplicationId = NEWID()
418 INSERT dbo.aspnet_Applications (ApplicationId, ApplicationName, LoweredApplicationName)
419 VALUES (@ApplicationId, @ApplicationName, LOWER(@ApplicationName))
420 END
421
422
423 IF( @TranStarted = 1 )
424 BEGIN
425 IF(@@ERROR = 0)
426 BEGIN
427 SET @TranStarted = 0
428 COMMIT TRANSACTION
429 END
430 ELSE
431 BEGIN
432 SET @TranStarted = 0
433 ROLLBACK TRANSACTION
434 END
435 END
436 END
437END
438GO
439/****** Object: Table [dbo].[aspnet_Paths] Script Date: 12/10/2011 11:49:44 ******/
440SET ANSI_NULLS ON
441GO
442SET QUOTED_IDENTIFIER ON
443GO
444CREATE TABLE [dbo].[aspnet_Paths](
445 [ApplicationId] [uniqueidentifier] NOT NULL,
446 [PathId] [uniqueidentifier] NOT NULL,
447 [Path] [nvarchar](256) NOT NULL,
448 [LoweredPath] [nvarchar](256) NOT NULL,
449PRIMARY KEY NONCLUSTERED
450(
451 [PathId] ASC
452)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
453) ON [PRIMARY]
454GO
455/****** Object: StoredProcedure [dbo].[aspnet_Personalization_GetApplicationId] Script Date: 12/10/2011 11:49:42 ******/
456SET ANSI_NULLS ON
457GO
458SET QUOTED_IDENTIFIER OFF
459GO
460CREATE PROCEDURE [dbo].[aspnet_Personalization_GetApplicationId] (
461 @ApplicationName NVARCHAR(256),
462 @ApplicationId UNIQUEIDENTIFIER OUT)
463AS
464BEGIN
465 SELECT @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
466END
467GO
468/****** Object: Table [dbo].[aspnet_Roles] Script Date: 12/10/2011 11:49:44 ******/
469SET ANSI_NULLS ON
470GO
471SET QUOTED_IDENTIFIER ON
472GO
473CREATE TABLE [dbo].[aspnet_Roles](
474 [ApplicationId] [uniqueidentifier] NOT NULL,
475 [RoleId] [uniqueidentifier] NOT NULL,
476 [RoleName] [nvarchar](256) NOT NULL,
477 [LoweredRoleName] [nvarchar](256) NOT NULL,
478 [Description] [nvarchar](256) NULL,
479PRIMARY KEY NONCLUSTERED
480(
481 [RoleId] ASC
482)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
483) ON [PRIMARY]
484GO
485/****** Object: StoredProcedure [dbo].[aspnet_RegisterSchemaVersion] Script Date: 12/10/2011 11:49:42 ******/
486SET ANSI_NULLS ON
487GO
488SET QUOTED_IDENTIFIER OFF
489GO
490CREATE PROCEDURE [dbo].[aspnet_RegisterSchemaVersion]
491 @Feature nvarchar(128),
492 @CompatibleSchemaVersion nvarchar(128),
493 @IsCurrentVersion bit,
494 @RemoveIncompatibleSchema bit
495AS
496BEGIN
497 IF( @RemoveIncompatibleSchema = 1 )
498 BEGIN
499 DELETE FROM dbo.aspnet_SchemaVersions WHERE Feature = LOWER( @Feature )
500 END
501 ELSE
502 BEGIN
503 IF( @IsCurrentVersion = 1 )
504 BEGIN
505 UPDATE dbo.aspnet_SchemaVersions
506 SET IsCurrentVersion = 0
507 WHERE Feature = LOWER( @Feature )
508 END
509 END
510
511 INSERT dbo.aspnet_SchemaVersions( Feature, CompatibleSchemaVersion, IsCurrentVersion )
512 VALUES( LOWER( @Feature ), @CompatibleSchemaVersion, @IsCurrentVersion )
513END
514GO
515/****** Object: Table [dbo].[aspnet_PersonalizationPerUser] Script Date: 12/10/2011 11:49:44 ******/
516SET ANSI_NULLS ON
517GO
518SET QUOTED_IDENTIFIER ON
519GO
520CREATE TABLE [dbo].[aspnet_PersonalizationPerUser](
521 [Id] [uniqueidentifier] NOT NULL,
522 [PathId] [uniqueidentifier] NULL,
523 [UserId] [uniqueidentifier] NULL,
524 [PageSettings] [image] NOT NULL,
525 [LastUpdatedDate] [datetime] NOT NULL,
526PRIMARY KEY NONCLUSTERED
527(
528 [Id] ASC
529)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
530) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
531GO
532/****** Object: Table [dbo].[aspnet_Profile] Script Date: 12/10/2011 11:49:44 ******/
533SET ANSI_NULLS ON
534GO
535SET QUOTED_IDENTIFIER ON
536GO
537CREATE TABLE [dbo].[aspnet_Profile](
538 [UserId] [uniqueidentifier] NOT NULL,
539 [PropertyNames] [ntext] NOT NULL,
540 [PropertyValuesString] [ntext] NOT NULL,
541 [PropertyValuesBinary] [image] NOT NULL,
542 [LastUpdatedDate] [datetime] NOT NULL,
543PRIMARY KEY CLUSTERED
544(
545 [UserId] ASC
546)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
547) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
548GO
549/****** Object: Table [dbo].[aspnet_Membership] Script Date: 12/10/2011 11:49:44 ******/
550SET ANSI_NULLS ON
551GO
552SET QUOTED_IDENTIFIER ON
553GO
554CREATE TABLE [dbo].[aspnet_Membership](
555 [ApplicationId] [uniqueidentifier] NOT NULL,
556 [UserId] [uniqueidentifier] NOT NULL,
557 [Password] [nvarchar](128) NOT NULL,
558 [PasswordFormat] [int] NOT NULL,
559 [PasswordSalt] [nvarchar](128) NOT NULL,
560 [MobilePIN] [nvarchar](16) NULL,
561 [Email] [nvarchar](256) NULL,
562 [LoweredEmail] [nvarchar](256) NULL,
563 [PasswordQuestion] [nvarchar](256) NULL,
564 [PasswordAnswer] [nvarchar](128) NULL,
565 [IsApproved] [bit] NOT NULL,
566 [IsLockedOut] [bit] NOT NULL,
567 [CreateDate] [datetime] NOT NULL,
568 [LastLoginDate] [datetime] NOT NULL,
569 [LastPasswordChangedDate] [datetime] NOT NULL,
570 [LastLockoutDate] [datetime] NOT NULL,
571 [FailedPasswordAttemptCount] [int] NOT NULL,
572 [FailedPasswordAttemptWindowStart] [datetime] NOT NULL,
573 [FailedPasswordAnswerAttemptCount] [int] NOT NULL,
574 [FailedPasswordAnswerAttemptWindowStart] [datetime] NOT NULL,
575 [Comment] [ntext] NULL,
576PRIMARY KEY NONCLUSTERED
577(
578 [UserId] ASC
579)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
580) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
581GO
582/****** Object: StoredProcedure [dbo].[aspnet_Paths_CreatePath] Script Date: 12/10/2011 11:49:42 ******/
583SET ANSI_NULLS ON
584GO
585SET QUOTED_IDENTIFIER OFF
586GO
587CREATE PROCEDURE [dbo].[aspnet_Paths_CreatePath]
588 @ApplicationId UNIQUEIDENTIFIER,
589 @Path NVARCHAR(256),
590 @PathId UNIQUEIDENTIFIER OUTPUT
591AS
592BEGIN
593 BEGIN TRANSACTION
594 IF (NOT EXISTS(SELECT * FROM dbo.aspnet_Paths WHERE LoweredPath = LOWER(@Path) AND ApplicationId = @ApplicationId))
595 BEGIN
596 INSERT dbo.aspnet_Paths (ApplicationId, Path, LoweredPath) VALUES (@ApplicationId, @Path, LOWER(@Path))
597 END
598 COMMIT TRANSACTION
599 SELECT @PathId = PathId FROM dbo.aspnet_Paths WHERE LOWER(@Path) = LoweredPath AND ApplicationId = @ApplicationId
600END
601GO
602/****** Object: Table [dbo].[aspnet_PersonalizationAllUsers] Script Date: 12/10/2011 11:49:44 ******/
603SET ANSI_NULLS ON
604GO
605SET QUOTED_IDENTIFIER ON
606GO
607CREATE TABLE [dbo].[aspnet_PersonalizationAllUsers](
608 [PathId] [uniqueidentifier] NOT NULL,
609 [PageSettings] [image] NOT NULL,
610 [LastUpdatedDate] [datetime] NOT NULL,
611PRIMARY KEY CLUSTERED
612(
613 [PathId] ASC
614)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
615) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
616GO
617/****** Object: StoredProcedure [dbo].[aspnet_Users_CreateUser] Script Date: 12/10/2011 11:49:42 ******/
618SET ANSI_NULLS ON
619GO
620SET QUOTED_IDENTIFIER OFF
621GO
622CREATE PROCEDURE [dbo].[aspnet_Users_CreateUser]
623 @ApplicationId uniqueidentifier,
624 @UserName nvarchar(256),
625 @IsUserAnonymous bit,
626 @LastActivityDate DATETIME,
627 @UserId uniqueidentifier OUTPUT
628AS
629BEGIN
630 IF( @UserId IS NULL )
631 SELECT @UserId = NEWID()
632 ELSE
633 BEGIN
634 IF( EXISTS( SELECT UserId FROM dbo.aspnet_Users
635 WHERE @UserId = UserId ) )
636 RETURN -1
637 END
638
639 INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)
640 VALUES (@ApplicationId, @UserId, @UserName, LOWER(@UserName), @IsUserAnonymous, @LastActivityDate)
641
642 RETURN 0
643END
644GO
645/****** Object: StoredProcedure [dbo].[aspnet_Roles_RoleExists] Script Date: 12/10/2011 11:49:42 ******/
646SET ANSI_NULLS ON
647GO
648SET QUOTED_IDENTIFIER OFF
649GO
650CREATE PROCEDURE [dbo].[aspnet_Roles_RoleExists]
651 @ApplicationName nvarchar(256),
652 @RoleName nvarchar(256)
653AS
654BEGIN
655 DECLARE @ApplicationId uniqueidentifier
656 SELECT @ApplicationId = NULL
657 SELECT @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
658 IF (@ApplicationId IS NULL)
659 RETURN(0)
660 IF (EXISTS (SELECT RoleName FROM dbo.aspnet_Roles WHERE LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId ))
661 RETURN(1)
662 ELSE
663 RETURN(0)
664END
665GO
666/****** Object: StoredProcedure [dbo].[aspnet_Roles_GetAllRoles] Script Date: 12/10/2011 11:49:42 ******/
667SET ANSI_NULLS ON
668GO
669SET QUOTED_IDENTIFIER OFF
670GO
671CREATE PROCEDURE [dbo].[aspnet_Roles_GetAllRoles] (
672 @ApplicationName nvarchar(256))
673AS
674BEGIN
675 DECLARE @ApplicationId uniqueidentifier
676 SELECT @ApplicationId = NULL
677 SELECT @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
678 IF (@ApplicationId IS NULL)
679 RETURN
680 SELECT RoleName
681 FROM dbo.aspnet_Roles