Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
1033	[ DIR ]	drwxrwxrwx
ASP.NETWebAdminFiles	[ DIR ]	drwxrwxrwx
Config	[ DIR ]	drwxrwxrwx
MSBuild	[ DIR ]	drwxrwxrwx
MUI	[ DIR ]	drwxrwxrwx
NativeImages	[ DIR ]	drwxrwxrwx
SQL	[ DIR ]	drwxrwxrwx
WPF	[ DIR ]	drwxrwxrwx
en-US	[ DIR ]	drwxrwxrwx
Accessibility.dll	35.17 KB	-rw-rw-rw-
AddInProcess.exe	41.18 KB	-rwxrwxrwx
AddInProcess.exe.config	161 B	-rw-rw-rw-
AddInProcess32.exe	41.19 KB	-rwxrwxrwx
AddInProcess32.exe.config	161 B	-rw-rw-rw-
AddInUtil.exe	41.66 KB	-rwxrwxrwx
AddInUtil.exe.config	161 B	-rw-rw-rw-
AdoNetDiag.dll	169.67 KB	-rw-rw-rw-
AppLaunch.exe	96.66 KB	-rwxrwxrwx
Aspnet.config	437 B	-rw-rw-rw-
Aspnet_perf.dll	35.94 KB	-rw-rw-rw-
CLR-ETW.man	313.6 KB	-rw-rw-rw-
CORPerfMonExt.dll	125.68 KB	-rw-rw-rw-
CasPol.exe	105.16 KB	-rwxrwxrwx
ComSvcConfig.exe	169.68 KB	-rwxrwxrwx
Culture.dll	53.66 KB	-rw-rw-rw-
CustomMarshalers.dll	93.69 KB	-rw-rw-rw-
DataSvcUtil.exe	69.67 KB	-rwxrwxrwx
DataSvcUtil.exe.config	156 B	-rw-rw-rw-
EdmGen.exe	94.65 KB	-rwxrwxrwx
EventLogMessages.dll	786.7 KB	-rw-rw-rw-
FXUpdate.dat	0 B	-rw-rw-rw-
FileTracker.dll	215.67 KB	-rw-rw-rw-
ISymWrapper.dll	69.67 KB	-rw-rw-rw-
InstallCommon.sql	24.03 KB	-rw-rw-rw-
InstallMembership.sql	54.93 KB	-rw-rw-rw-
InstallPersistSqlState.sql	53.37 KB	-rw-rw-rw-
InstallPersonalization.sql	34.13 KB	-rw-rw-rw-
InstallProfile.SQL	20.4 KB	-rw-rw-rw-
InstallRoles.sql	33.46 KB	-rw-rw-rw-
InstallSqlState.sql	53.15 KB	-rw-rw-rw-
InstallSqlStateTemplate.sql	54.92 KB	-rw-rw-rw-
InstallUtil.exe	40.17 KB	-rwxrwxrwx
InstallUtil.exe.config	182 B	-rw-rw-rw-
InstallUtilLib.dll	66.69 KB	-rw-rw-rw-
InstallWebEventSqlProvider.sql	6.31 KB	-rw-rw-rw-
MSBuild.exe	255.8 KB	-rwxrwxrwx
MSBuild.rsp	732 B	-rw-rw-rw-
Microsoft.Activities.Build.dll	52.23 KB	-rw-rw-rw-
Microsoft.Build.Conversion.v4....	83.25 KB	-rw-rw-rw-
Microsoft.Build.Engine.dll	643.72 KB	-rw-rw-rw-
Microsoft.Build.Framework.dll	97.73 KB	-rw-rw-rw-
Microsoft.Build.Tasks.v4.0.dll	1.12 MB	-rw-rw-rw-
Microsoft.Build.Utilities.v4.0...	263.24 KB	-rw-rw-rw-
Microsoft.Build.dll	1.35 MB	-rw-rw-rw-
Microsoft.Build.xsd	2.3 KB	-rw-rw-rw-
Microsoft.CSharp.dll	475.19 KB	-rw-rw-rw-
Microsoft.CSharp.targets	23.06 KB	-rw-rw-rw-
Microsoft.Common.OverrideTasks	6.15 KB	-rw-rw-rw-
Microsoft.Common.Tasks	14.55 KB	-rw-rw-rw-
Microsoft.Common.targets	256.39 KB	-rw-rw-rw-
Microsoft.Data.Entity.Build.Ta...	51.26 KB	-rw-rw-rw-
Microsoft.Data.Entity.targets	6.35 KB	-rw-rw-rw-
Microsoft.Internal.Tasks.Dataf...	180.76 KB	-rw-rw-rw-
Microsoft.JScript.dll	736.2 KB	-rw-rw-rw-
Microsoft.JScript.tlb	57.5 KB	-rw-rw-rw-
Microsoft.NETFramework.props	11.68 KB	-rw-rw-rw-
Microsoft.NETFramework.targets	7.99 KB	-rw-rw-rw-
Microsoft.ServiceModel.targets	9.55 KB	-rw-rw-rw-
Microsoft.Transactions.Bridge....	128.26 KB	-rw-rw-rw-
Microsoft.Transactions.Bridge....	386.76 KB	-rw-rw-rw-
Microsoft.VisualBasic.Activiti...	2.78 MB	-rw-rw-rw-
Microsoft.VisualBasic.Compatib...	114.29 KB	-rw-rw-rw-
Microsoft.VisualBasic.Compatib...	486.27 KB	-rw-rw-rw-
Microsoft.VisualBasic.dll	625.22 KB	-rw-rw-rw-
Microsoft.VisualBasic.targets	22.78 KB	-rw-rw-rw-
Microsoft.VisualC.Dll	29.69 KB	-rw-rw-rw-
Microsoft.VisualC.STLCLR.dll	49.73 KB	-rw-rw-rw-
Microsoft.WinFx.targets	41.22 KB	-rw-rw-rw-
Microsoft.Windows.ApplicationS...	707.35 KB	-rw-rw-rw-
Microsoft.Windows.ApplicationS...	137.38 KB	-rw-rw-rw-
Microsoft.Workflow.Compiler.ex...	32.23 KB	-rwxrwxrwx
Microsoft.Workflow.Compiler.ex...	144 B	-rw-rw-rw-
Microsoft.WorkflowBuildExtensi...	7.36 KB	-rw-rw-rw-
Microsoft.Xaml.targets	19.43 KB	-rw-rw-rw-
MmcAspExt.dll	105.66 KB	-rw-rw-rw-
PerfCounter.dll	210.67 KB	-rw-rw-rw-
RegAsm.exe	63.15 KB	-rwxrwxrwx
RegSvcs.exe	44.16 KB	-rwxrwxrwx
SMDiagnostics.dll	67.47 KB	-rw-rw-rw-
SMSvcHost.exe	135.8 KB	-rwxrwxrwx
SMSvcHost.exe.config	2.21 KB	-rw-rw-rw-
SOS.dll	719.91 KB	-rw-rw-rw-
SbsNclPerf.dll	23.16 KB	-rw-rw-rw-
ServiceModelEvents.dll	18.7 KB	-rw-rw-rw-
ServiceModelInstallRC.dll	18.71 KB	-rw-rw-rw-
ServiceModelPerformanceCounter...	89.25 KB	-rw-rw-rw-
ServiceModelPerformanceCounter...	126.02 KB	-rw-rw-rw-
ServiceModelReg.exe	216.69 KB	-rwxrwxrwx
ServiceModelRegUI.dll	18.7 KB	-rw-rw-rw-
ServiceMonikerSupport.dll	22.94 KB	-rw-rw-rw-
System.Activities.Core.Present...	690.77 KB	-rw-rw-rw-
System.Activities.DurableInsta...	138.8 KB	-rw-rw-rw-
System.Activities.Presentation...	2 MB	-rw-rw-rw-
System.Activities.dll	1.46 MB	-rw-rw-rw-
System.AddIn.Contract.dll	51.21 KB	-rw-rw-rw-
System.AddIn.dll	159.18 KB	-rw-rw-rw-
System.Collections.Concurrent....	28.77 KB	-rw-rw-rw-
System.Collections.dll	29.2 KB	-rw-rw-rw-
System.ComponentModel.Annotati...	29.79 KB	-rw-rw-rw-
System.ComponentModel.Composit...	298.29 KB	-rw-rw-rw-
System.ComponentModel.DataAnno...	123.31 KB	-rw-rw-rw-
System.ComponentModel.EventBas...	28.81 KB	-rw-rw-rw-
System.ComponentModel.dll	28.72 KB	-rw-rw-rw-
System.Configuration.Install.d...	100.26 KB	-rw-rw-rw-
System.Configuration.dll	410.66 KB	-rw-rw-rw-
System.Core.dll	1.48 MB	-rw-rw-rw-
System.Data.DataSetExtensions....	70.27 KB	-rw-rw-rw-
System.Data.Entity.Design.dll	1.03 MB	-rw-rw-rw-
System.Data.Entity.dll	3.85 MB	-rw-rw-rw-
System.Data.Linq.dll	673.19 KB	-rw-rw-rw-
System.Data.OracleClient.dll	496.72 KB	-rw-rw-rw-
System.Data.Services.Client.dl...	434.23 KB	-rw-rw-rw-
System.Data.Services.Design.dl...	170.73 KB	-rw-rw-rw-
System.Data.Services.dll	657.21 KB	-rw-rw-rw-
System.Data.SqlXml.dll	717.19 KB	-rw-rw-rw-
System.Data.dll	3.31 MB	-rw-rw-rw-
System.Deployment.dll	857.89 KB	-rw-rw-rw-
System.Design.dll	4.78 MB	-rw-rw-rw-
System.Device.dll	62.68 KB	-rw-rw-rw-
System.Diagnostics.Contracts.d...	29.26 KB	-rw-rw-rw-
System.Diagnostics.Debug.dll	28.73 KB	-rw-rw-rw-
System.Diagnostics.Tools.dll	28.73 KB	-rw-rw-rw-
System.Diagnostics.Tracing.dll	29.24 KB	-rw-rw-rw-
System.DirectoryServices.Accou...	289.27 KB	-rw-rw-rw-
System.DirectoryServices.Proto...	196.8 KB	-rw-rw-rw-
System.DirectoryServices.dll	408.34 KB	-rw-rw-rw-
System.Drawing.Design.dll	110.72 KB	-rw-rw-rw-
System.Drawing.dll	583.18 KB	-rw-rw-rw-
System.Drawing.tlb	8.5 KB	-rw-rw-rw-
System.Dynamic.Runtime.dll	29.23 KB	-rw-rw-rw-
System.Dynamic.dll	127.68 KB	-rw-rw-rw-
System.EnterpriseServices.Thun...	98.25 KB	-rw-rw-rw-
System.EnterpriseServices.Wrap...	109.5 KB	-rw-rw-rw-
System.EnterpriseServices.dll	236.23 KB	-rw-rw-rw-
System.EnterpriseServices.tlb	33.5 KB	-rw-rw-rw-
System.Globalization.dll	28.71 KB	-rw-rw-rw-
System.IO.Compression.FileSyst...	32.26 KB	-rw-rw-rw-
System.IO.Compression.dll	70.22 KB	-rw-rw-rw-
System.IO.Log.dll	130.68 KB	-rw-rw-rw-
System.IO.dll	28.14 KB	-rw-rw-rw-
System.IdentityModel.Selectors...	141.27 KB	-rw-rw-rw-
System.IdentityModel.Services....	187.94 KB	-rw-rw-rw-
System.IdentityModel.dll	1.04 MB	-rw-rw-rw-
System.Linq.Expressions.dll	30.73 KB	-rw-rw-rw-
System.Linq.Parallel.dll	28.7 KB	-rw-rw-rw-
System.Linq.Queryable.dll	28.72 KB	-rw-rw-rw-
System.Linq.dll	28.66 KB	-rw-rw-rw-
System.Management.Instrumentat...	142.26 KB	-rw-rw-rw-
System.Management.dll	405.7 KB	-rw-rw-rw-
System.Messaging.dll	268.19 KB	-rw-rw-rw-
System.Net.Http.Rtc.dll	28.7 KB	-rw-rw-rw-
System.Net.Http.WebRequest.dll	49.75 KB	-rw-rw-rw-
System.Net.Http.dll	198.58 KB	-rw-rw-rw-
System.Net.NetworkInformation....	29.77 KB	-rw-rw-rw-
System.Net.Primitives.dll	29.22 KB	-rw-rw-rw-
System.Net.Requests.dll	28.7 KB	-rw-rw-rw-
System.Net.WebHeaderCollection...	28.27 KB	-rw-rw-rw-
System.Net.dll	250.65 KB	-rw-rw-rw-
System.Numerics.Vectors.dll	30.73 KB	-rw-rw-rw-
System.Numerics.dll	135.18 KB	-rw-rw-rw-
System.ObjectModel.dll	29.2 KB	-rw-rw-rw-
System.Reflection.Emit.ILGener...	28.8 KB	-rw-rw-rw-
System.Reflection.Emit.Lightwe...	28.8 KB	-rw-rw-rw-
System.Reflection.Emit.dll	28.73 KB	-rw-rw-rw-
System.Reflection.Extensions.d...	28.76 KB	-rw-rw-rw-
System.Reflection.Primitives.d...	28.76 KB	-rw-rw-rw-
System.Reflection.context.dll	105.74 KB	-rw-rw-rw-
System.Reflection.dll	29.2 KB	-rw-rw-rw-
System.Resources.ResourceManag...	28.78 KB	-rw-rw-rw-
System.Runtime.Caching.dll	106.37 KB	-rw-rw-rw-
System.Runtime.DurableInstanci...	168.28 KB	-rw-rw-rw-
System.Runtime.Extensions.dll	28.74 KB	-rw-rw-rw-
System.Runtime.Handles.dll	28.72 KB	-rw-rw-rw-
System.Runtime.InteropServices...	28.87 KB	-rw-rw-rw-
System.Runtime.InteropServices...	31.77 KB	-rw-rw-rw-
System.Runtime.Numerics.dll	28.73 KB	-rw-rw-rw-
System.Runtime.Remoting.dll	334.97 KB	-rw-rw-rw-
System.Runtime.Serialization.F...	138.36 KB	-rw-rw-rw-
System.Runtime.Serialization.J...	28.79 KB	-rw-rw-rw-
System.Runtime.Serialization.P...	28.83 KB	-rw-rw-rw-
System.Runtime.Serialization.X...	28.78 KB	-rw-rw-rw-
System.Runtime.Serialization.d...	1 MB	-rw-rw-rw-
System.Runtime.WindowsRuntime....	70.81 KB	-rw-rw-rw-
System.Runtime.WindowsRuntime....	148.27 KB	-rw-rw-rw-
System.Runtime.dll	36.67 KB	-rw-rw-rw-
System.Security.Principal.dll	28.74 KB	-rw-rw-rw-
System.Security.dll	311.24 KB	-rw-rw-rw-
System.ServiceModel.Activation...	197.74 KB	-rw-rw-rw-
System.ServiceModel.Activities...	548.24 KB	-rw-rw-rw-
System.ServiceModel.Channels.d...	148.53 KB	-rw-rw-rw-
System.ServiceModel.Discovery....	295.42 KB	-rw-rw-rw-
System.ServiceModel.Duplex.dll	28.75 KB	-rw-rw-rw-
System.ServiceModel.Http.dll	29.23 KB	-rw-rw-rw-
System.ServiceModel.Internals....	249.96 KB	-rw-rw-rw-
System.ServiceModel.NetTcp.dll	28.74 KB	-rw-rw-rw-
System.ServiceModel.Primitives...	33.27 KB	-rw-rw-rw-
System.ServiceModel.Routing.dl...	127.73 KB	-rw-rw-rw-
System.ServiceModel.Security.d...	29.26 KB	-rw-rw-rw-
System.ServiceModel.ServiceMon...	22.77 KB	-rw-rw-rw-
System.ServiceModel.WasHosting...	33.53 KB	-rw-rw-rw-
System.ServiceModel.Web.dll	320.73 KB	-rw-rw-rw-
System.ServiceModel.dll	6.03 MB	-rw-rw-rw-
System.ServiceProcess.dll	131.72 KB	-rw-rw-rw-
System.Text.Encoding.Extension...	28.27 KB	-rw-rw-rw-
System.Text.Encoding.dll	28.71 KB	-rw-rw-rw-
System.Text.RegularExpressions...	28.77 KB	-rw-rw-rw-
System.Threading.Tasks.Paralle...	28.77 KB	-rw-rw-rw-
System.Threading.Tasks.dll	29.23 KB	-rw-rw-rw-
System.Threading.Timer.dll	28.73 KB	-rw-rw-rw-
System.Threading.dll	29.19 KB	-rw-rw-rw-
System.Transactions.dll	302.08 KB	-rw-rw-rw-
System.Web.Abstractions.dll	22.38 KB	-rw-rw-rw-
System.Web.ApplicationServices...	64.49 KB	-rw-rw-rw-
System.Web.DataVisualization.D...	103.42 KB	-rw-rw-rw-
System.Web.DataVisualization.d...	1.62 MB	-rw-rw-rw-
System.Web.DynamicData.Design....	43.9 KB	-rw-rw-rw-
System.Web.DynamicData.dll	242.37 KB	-rw-rw-rw-
System.Web.Entity.Design.dll	169.23 KB	-rw-rw-rw-
System.Web.Entity.dll	161.7 KB	-rw-rw-rw-
System.Web.Extensions.Design.d...	344.4 KB	-rw-rw-rw-
System.Web.Extensions.dll	1.76 MB	-rw-rw-rw-
System.Web.Mobile.dll	811.2 KB	-rw-rw-rw-
System.Web.RegularExpressions....	103.24 KB	-rw-rw-rw-
System.Web.Routing.dll	21.85 KB	-rw-rw-rw-
System.Web.Services.dll	826.7 KB	-rw-rw-rw-
System.Web.dll	5.16 MB	-rw-rw-rw-
System.Web.tlb	7 KB	-rw-rw-rw-
System.Windows.Forms.DataVisua...	80.46 KB	-rw-rw-rw-
System.Windows.Forms.DataVisua...	1.63 MB	-rw-rw-rw-
System.Windows.Forms.dll	4.99 MB	-rw-rw-rw-
System.Windows.Forms.tlb	84.5 KB	-rw-rw-rw-
System.Windows.dll	30.68 KB	-rw-rw-rw-
System.Workflow.Activities.dll	1 MB	-rw-rw-rw-
System.Workflow.ComponentModel...	1.48 MB	-rw-rw-rw-
System.Workflow.Runtime.dll	487.77 KB	-rw-rw-rw-
System.WorkflowServices.dll	440.22 KB	-rw-rw-rw-
System.XML.dll	2.55 MB	-rw-rw-rw-
System.Xaml.Hosting.dll	41.7 KB	-rw-rw-rw-
System.Xaml.dll	622.37 KB	-rw-rw-rw-
System.Xml.Linq.dll	159.68 KB	-rw-rw-rw-
System.Xml.ReaderWriter.dll	29.23 KB	-rw-rw-rw-
System.Xml.Serialization.dll	44.73 KB	-rw-rw-rw-
System.Xml.XDocument.dll	28.71 KB	-rw-rw-rw-
System.Xml.XmlSerializer.dll	29.23 KB	-rw-rw-rw-
System.dll	3.4 MB	-rw-rw-rw-
System.tlb	70.5 KB	-rw-rw-rw-
TLBREF.DLL	110.66 KB	-rw-rw-rw-
ThirdPartyNotices.txt	19.85 KB	-rw-rw-rw-
UnInstallProfile.SQL	4.65 KB	-rw-rw-rw-
UninstallCommon.sql	3.8 KB	-rw-rw-rw-
UninstallMembership.sql	6.75 KB	-rw-rw-rw-
UninstallPersistSqlState.sql	9.96 KB	-rw-rw-rw-
UninstallPersonalization.sql	7.31 KB	-rw-rw-rw-
UninstallRoles.sql	5.73 KB	-rw-rw-rw-
UninstallSqlState.sql	9.46 KB	-rw-rw-rw-
UninstallSqlStateTemplate.sql	11.52 KB	-rw-rw-rw-
UninstallWebEventSqlProvider.s...	2.94 KB	-rw-rw-rw-
WMINet_Utils.dll	133.17 KB	-rw-rw-rw-
Workflow.Targets	6.96 KB	-rw-rw-rw-
Workflow.VisualBasic.Targets	8.39 KB	-rw-rw-rw-
WorkflowServiceHostPerformance...	87.77 KB	-rw-rw-rw-
WorkflowServiceHostPerformance...	42.27 KB	-rw-rw-rw-
WsatConfig.exe	149.17 KB	-rwxrwxrwx
XPThemes.manifest	474 B	-rw-rw-rw-
XamlBuildTask.dll	129.18 KB	-rw-rw-rw-
XsdBuildTask.dll	66.18 KB	-rw-rw-rw-
adonetdiag.mof	7.35 KB	-rw-rw-rw-
adonetdiag.mof.uninstall	1.95 KB	-rw-rw-rw-
alink.dll	123.65 KB	-rw-rw-rw-
applaunch.exe.config	281 B	-rw-rw-rw-
aspnet_compiler.exe	54.19 KB	-rwxrwxrwx
aspnet_filter.dll	34.68 KB	-rw-rw-rw-
aspnet_isapi.dll	25.17 KB	-rw-rw-rw-
aspnet_perf.h	7.01 KB	-rw-rw-rw-
aspnet_perf.ini	974.12 KB	-rw-rw-rw-
aspnet_perf2.ini	972.21 KB	-rw-rw-rw-
aspnet_rc.dll	89.16 KB	-rw-rw-rw-
aspnet_regbrowsers.exe	38.55 KB	-rwxrwxrwx
aspnet_regiis.exe	34.55 KB	-rwxrwxrwx
aspnet_regsql.exe	118.55 KB	-rwxrwxrwx
aspnet_state.exe	46.17 KB	-rwxrwxrwx
aspnet_state_perf.h	318 B	-rw-rw-rw-
aspnet_state_perf.ini	41.99 KB	-rw-rw-rw-
aspnet_wp.exe	39.43 KB	-rwxrwxrwx
caspol.exe.config	368 B	-rw-rw-rw-
clr.dll	7.41 MB	-rw-rw-rw-
clrcompression.dll	127.43 KB	-rw-rw-rw-
clretwrc.dll	231.66 KB	-rw-rw-rw-
clrjit.dll	504.94 KB	-rw-rw-rw-
csc.exe	2.07 MB	-rwxrwxrwx
csc.exe.config	182 B	-rw-rw-rw-
csc.rsp	1.3 KB	-rw-rw-rw-
cvtres.exe	42.17 KB	-rwxrwxrwx
cvtres.exe.config	281 B	-rw-rw-rw-
default.win32manifest	490 B	-rw-rw-rw-
dfdll.dll	150.43 KB	-rw-rw-rw-
dfsvc.exe	23.65 KB	-rwxrwxrwx
dfsvc.exe.config	167 B	-rw-rw-rw-
diasymreader.dll	1.02 MB	-rw-rw-rw-
dv_aspnetmmc.chm	112.43 KB	-rw-rw-rw-
fusion.dll	92.66 KB	-rw-rw-rw-
ilasm.exe	289.65 KB	-rwxrwxrwx
ilasm.exe.config	223 B	-rw-rw-rw-
jsc.exe	45.64 KB	-rwxrwxrwx
jsc.exe.config	281 B	-rw-rw-rw-
locale.nlp	409.8 KB	-rw-rw-rw-
msbuild.exe.config	1.69 KB	-rw-rw-rw-
mscordacwks.dll	1.27 MB	-rw-rw-rw-
mscordbi.dll	1.11 MB	-rw-rw-rw-
mscoree.tlb	31 KB	-rw-rw-rw-
mscoreei.dll	500.48 KB	-rw-rw-rw-
mscoreeis.dll	33.16 KB	-rw-rw-rw-
mscorlib.dll	5.44 MB	-rw-rw-rw-
mscorlib.tlb	507.5 KB	-rw-rw-rw-
mscorpe.dll	87.66 KB	-rw-rw-rw-
mscorpehost.dll	145.54 KB	-rw-rw-rw-
mscorrc.dll	389.66 KB	-rw-rw-rw-
mscorsecimpl.dll	104.18 KB	-rw-rw-rw-
mscorsn.dll	25.66 KB	-rw-rw-rw-
mscorsvc.dll	414.88 KB	-rw-rw-rw-
mscorsvw.exe	98.42 KB	-rwxrwxrwx
ngen.exe	131.96 KB	-rwxrwxrwx
ngen.log	182.13 KB	-rw-rw-rw-
ngen.old.log	1 MB	-rw-rw-rw-
ngentask.exe	77.95 KB	-rwxrwxrwx
normidna.nlp	57.95 KB	-rw-rw-rw-
normnfc.nlp	45.97 KB	-rw-rw-rw-
normnfd.nlp	39.62 KB	-rw-rw-rw-
normnfkc.nlp	66.22 KB	-rw-rw-rw-
normnfkd.nlp	60.27 KB	-rw-rw-rw-
peverify.dll	178.42 KB	-rw-rw-rw-
regasm.exe.config	281 B	-rw-rw-rw-
regsvcs.exe.config	223 B	-rw-rw-rw-
sysglobl.dll	129.14 KB	-rw-rw-rw-
system.componentmodel.composit...	61.88 KB	-rw-rw-rw-
vbc.exe	2.56 MB	-rwxrwxrwx
vbc.exe.config	182 B	-rw-rw-rw-
vbc.rsp	1.43 KB	-rw-rw-rw-
webengine.dll	18.42 KB	-rw-rw-rw-
webengine4.dll	531.43 KB	-rw-rw-rw-

Code Editor : InstallPersonalization.sql

/**********************************************************************/
/* InstallPersonalization.SQL                                         */
/*                                                                    */
/* Installs the tables, triggers and stored procedures necessary for  */
/* supporting the personalization feature of ASP.NET                  */
/*                                                                    */
/* InstallCommon.sql must be run before running this file.            */
/*
** Copyright Microsoft, Inc. 2002
** All Rights Reserved.
*/
/**********************************************************************/

PRINT '------------------------------------------------'
PRINT 'Starting execution of InstallPersonalization.SQL'
PRINT '------------------------------------------------'
GO

SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON         -- We don't want (NULL = NULL) == TRUE
GO
SET ANSI_PADDING ON
GO
SET ANSI_NULL_DFLT_ON ON
GO

/*************************************************************/
/*************************************************************/
/*************************************************************/
/*************************************************************/
/*************************************************************/

DECLARE @dbname NVARCHAR(128)

SET @dbname = N'aspnetdb'

IF (NOT EXISTS (SELECT name
                FROM master.dbo.sysdatabases
                WHERE ('[' + name + ']' = @dbname OR name = @dbname)))
BEGIN
  RAISERROR('The database ''%s'' cannot be found. Please run InstallCommon.sql first.', 18, 1, @dbname)
END
GO

USE [aspnetdb]
GO

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_Applications')
                  AND (type = 'U')))
BEGIN
  RAISERROR('The table ''aspnet_Applications'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_Users')
                  AND (type = 'U')))
BEGIN
  RAISERROR('The table ''aspnet_Users'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

IF (NOT EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Applications_CreateApplication')
               AND (type = 'P')))
BEGIN
  RAISERROR('The stored procedure ''aspnet_Applications_CreateApplication'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

IF (NOT EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Users_CreateUser')
               AND (type = 'P')))
BEGIN
  RAISERROR('The stored procedure ''aspnet_Users_CreateUser'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

IF (NOT EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Users_DeleteUser')
               AND (type = 'P')))
BEGIN
  RAISERROR('The stored procedure ''aspnet_Users_DeleteUser'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

/***************************************************************************************************************************/
/***************************************************************************************************************************/

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_Paths')
                  AND (type = 'U')))
BEGIN
  PRINT 'Creating the aspnet_Paths table...'
  CREATE TABLE dbo.aspnet_Paths (
        ApplicationId    UNIQUEIDENTIFIER    NOT NULL FOREIGN KEY REFERENCES dbo.aspnet_Applications(ApplicationId),
        PathId            UNIQUEIDENTIFIER   PRIMARY KEY NONCLUSTERED DEFAULT NEWID(),
        Path              NVARCHAR(256)      NOT NULL,
        LoweredPath       NVARCHAR(256)      NOT NULL)
  CREATE UNIQUE CLUSTERED INDEX aspnet_Paths_index ON dbo.aspnet_Paths(ApplicationId, LoweredPath)
END

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Personalization_GetApplicationId')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Personalization_GetApplicationId
GO
CREATE PROCEDURE dbo.aspnet_Personalization_GetApplicationId (
    @ApplicationName NVARCHAR(256),
    @ApplicationId UNIQUEIDENTIFIER OUT)
AS
BEGIN
    SELECT @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
END
GO

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Paths_CreatePath')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Paths_CreatePath
GO
CREATE PROCEDURE dbo.aspnet_Paths_CreatePath
    @ApplicationId UNIQUEIDENTIFIER,
    @Path           NVARCHAR(256),
    @PathId         UNIQUEIDENTIFIER OUTPUT
AS
BEGIN
    BEGIN TRANSACTION
    IF (NOT EXISTS(SELECT * FROM dbo.aspnet_Paths WHERE LoweredPath = LOWER(@Path) AND ApplicationId = @ApplicationId))
    BEGIN
        INSERT dbo.aspnet_Paths (ApplicationId, Path, LoweredPath) VALUES (@ApplicationId, @Path, LOWER(@Path))
    END
    COMMIT TRANSACTION
    SELECT @PathId = PathId FROM dbo.aspnet_Paths WHERE LOWER(@Path) = LoweredPath AND ApplicationId = @ApplicationId
END
GO

/***************************************************************************************************************************/

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_PersonalizationAllUsers')
                  AND (type = 'U')))
BEGIN
  PRINT 'Creating the aspnet_PersonalizationAllUsers table...'
  CREATE TABLE dbo.aspnet_PersonalizationAllUsers (
        PathId            UNIQUEIDENTIFIER PRIMARY KEY FOREIGN KEY REFERENCES dbo.aspnet_Paths (PathId),
        PageSettings     IMAGE NOT NULL,
        LastUpdatedDate  DATETIME NOT NULL)
END

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_PersonalizationPerUser')
                  AND (type = 'U')))
BEGIN
  PRINT 'Creating the aspnet_PersonalizationPerUser table...'
  CREATE TABLE dbo.aspnet_PersonalizationPerUser (
        Id               UNIQUEIDENTIFIER NOT NULL PRIMARY KEY NONCLUSTERED DEFAULT NEWID(),
        PathId           UNIQUEIDENTIFIER FOREIGN KEY REFERENCES dbo.aspnet_Paths (PathId),
        UserId           UNIQUEIDENTIFIER FOREIGN KEY REFERENCES dbo.aspnet_Users (UserId),
        PageSettings     IMAGE NOT NULL,
        LastUpdatedDate  DATETIME NOT NULL)
  CREATE UNIQUE CLUSTERED INDEX aspnet_PersonalizationPerUser_index1 ON [dbo].[aspnet_PersonalizationPerUser](PathId,UserId)
  CREATE UNIQUE INDEX aspnet_PersonalizationPerUser_ncindex2 ON [dbo].[aspnet_PersonalizationPerUser](UserId,PathId)
END

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationAllUsers_GetPageSettings')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationAllUsers_GetPageSettings
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationAllUsers_GetPageSettings (
    @ApplicationName  NVARCHAR(256),
    @Path              NVARCHAR(256))
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    DECLARE @PathId UNIQUEIDENTIFIER

SELECT @ApplicationId = NULL
    SELECT @PathId = NULL

EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
    IF (@ApplicationId IS NULL)
    BEGIN
        RETURN
    END

SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
    IF (@PathId IS NULL)
    BEGIN
        RETURN
    END

SELECT p.PageSettings FROM dbo.aspnet_PersonalizationAllUsers p WHERE p.PathId = @PathId
END
GO

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationAllUsers_ResetPageSettings')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationAllUsers_ResetPageSettings
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationAllUsers_ResetPageSettings (
    @ApplicationName  NVARCHAR(256),
    @Path              NVARCHAR(256))
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    DECLARE @PathId UNIQUEIDENTIFIER

SELECT @ApplicationId = NULL
    SELECT @PathId = NULL

EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
    IF (@ApplicationId IS NULL)
    BEGIN
        RETURN
    END

SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
    IF (@PathId IS NULL)
    BEGIN
        RETURN
    END

DELETE FROM dbo.aspnet_PersonalizationAllUsers WHERE PathId = @PathId
    RETURN 0
END
GO

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationAllUsers_SetPageSettings')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationAllUsers_SetPageSettings
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationAllUsers_SetPageSettings (
    @ApplicationName  NVARCHAR(256),
    @Path             NVARCHAR(256),
    @PageSettings     IMAGE,
    @CurrentTimeUtc   DATETIME)
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    DECLARE @PathId UNIQUEIDENTIFIER

SELECT @ApplicationId = NULL
    SELECT @PathId = NULL

EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT

SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
    IF (@PathId IS NULL)
    BEGIN
        EXEC dbo.aspnet_Paths_CreatePath @ApplicationId, @Path, @PathId OUTPUT
    END

IF (EXISTS(SELECT PathId FROM dbo.aspnet_PersonalizationAllUsers WHERE PathId = @PathId))
        UPDATE dbo.aspnet_PersonalizationAllUsers SET PageSettings = @PageSettings, LastUpdatedDate = @CurrentTimeUtc WHERE PathId = @PathId
    ELSE
        INSERT INTO dbo.aspnet_PersonalizationAllUsers(PathId, PageSettings, LastUpdatedDate) VALUES (@PathId, @PageSettings, @CurrentTimeUtc)
    RETURN 0
END
GO

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationPerUser_GetPageSettings')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationPerUser_GetPageSettings
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationPerUser_GetPageSettings (
    @ApplicationName  NVARCHAR(256),
    @UserName         NVARCHAR(256),
    @Path             NVARCHAR(256),
    @CurrentTimeUtc   DATETIME)
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    DECLARE @PathId UNIQUEIDENTIFIER
    DECLARE @UserId UNIQUEIDENTIFIER

SELECT @ApplicationId = NULL
    SELECT @PathId = NULL
    SELECT @UserId = NULL

EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
    IF (@ApplicationId IS NULL)
    BEGIN
        RETURN
    END

SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
    IF (@PathId IS NULL)
    BEGIN
        RETURN
    END

SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)
    IF (@UserId IS NULL)
    BEGIN
        RETURN
    END

UPDATE   dbo.aspnet_Users WITH (ROWLOCK)
    SET      LastActivityDate = @CurrentTimeUtc
    WHERE    UserId = @UserId
    IF (@@ROWCOUNT = 0) -- Username not found
        RETURN

SELECT p.PageSettings FROM dbo.aspnet_PersonalizationPerUser p WHERE p.PathId = @PathId AND p.UserId = @UserId
END
GO

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationPerUser_ResetPageSettings')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationPerUser_ResetPageSettings
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationPerUser_ResetPageSettings (
    @ApplicationName  NVARCHAR(256),
    @UserName         NVARCHAR(256),
    @Path             NVARCHAR(256),
    @CurrentTimeUtc   DATETIME)
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    DECLARE @PathId UNIQUEIDENTIFIER
    DECLARE @UserId UNIQUEIDENTIFIER

SELECT @ApplicationId = NULL
    SELECT @PathId = NULL
    SELECT @UserId = NULL

EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
    IF (@ApplicationId IS NULL)
    BEGIN
        RETURN
    END

SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)
    IF (@PathId IS NULL)
    BEGIN
        RETURN
    END

SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)
    IF (@UserId IS NULL)
    BEGIN
        RETURN
    END

UPDATE   dbo.aspnet_Users WITH (ROWLOCK)
    SET      LastActivityDate = @CurrentTimeUtc
    WHERE    UserId = @UserId
    IF (@@ROWCOUNT = 0) -- Username not found
        RETURN

DELETE FROM dbo.aspnet_PersonalizationPerUser WHERE PathId = @PathId AND UserId = @UserId
    RETURN 0
END
GO

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationPerUser_SetPageSettings')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationPerUser_SetPageSettings
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationPerUser_SetPageSettings (
    @ApplicationName  NVARCHAR(256),
    @UserName         NVARCHAR(256),
    @Path             NVARCHAR(256),
    @PageSettings     IMAGE,
    @CurrentTimeUtc   DATETIME)
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    DECLARE @PathId UNIQUEIDENTIFIER
    DECLARE @UserId UNIQUEIDENTIFIER

SELECT @ApplicationId = NULL
    SELECT @PathId = NULL
    SELECT @UserId = NULL

EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT

SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)
    IF (@UserId IS NULL)
    BEGIN
        EXEC dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, 0, @CurrentTimeUtc, @UserId OUTPUT
    END

UPDATE   dbo.aspnet_Users WITH (ROWLOCK)
    SET      LastActivityDate = @CurrentTimeUtc
    WHERE    UserId = @UserId
    IF (@@ROWCOUNT = 0) -- Username not found
        RETURN

IF (EXISTS(SELECT PathId FROM dbo.aspnet_PersonalizationPerUser WHERE UserId = @UserId AND PathId = @PathId))
        UPDATE dbo.aspnet_PersonalizationPerUser SET PageSettings = @PageSettings, LastUpdatedDate = @CurrentTimeUtc WHERE UserId = @UserId AND PathId = @PathId
    ELSE
        INSERT INTO dbo.aspnet_PersonalizationPerUser(UserId, PathId, PageSettings, LastUpdatedDate) VALUES (@UserId, @PathId, @PageSettings, @CurrentTimeUtc)
    RETURN 0
END
GO

/*************************************************************/
/* Personalization Administration                            */
/*************************************************************/

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationAdministration_DeleteAllState')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationAdministration_DeleteAllState
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationAdministration_DeleteAllState (
    @AllUsersScope bit,
    @ApplicationName NVARCHAR(256),
    @Count int OUT)
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
    IF (@ApplicationId IS NULL)
        SELECT @Count = 0
    ELSE
    BEGIN
        IF (@AllUsersScope = 1)
            DELETE FROM aspnet_PersonalizationAllUsers
            WHERE PathId IN
               (SELECT Paths.PathId
                FROM dbo.aspnet_Paths Paths
                WHERE Paths.ApplicationId = @ApplicationId)
        ELSE
            DELETE FROM aspnet_PersonalizationPerUser
            WHERE PathId IN
               (SELECT Paths.PathId
                FROM dbo.aspnet_Paths Paths
                WHERE Paths.ApplicationId = @ApplicationId)

SELECT @Count = @@ROWCOUNT
    END
END
GO

/*************************************************************/
IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationAdministration_ResetUserState')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationAdministration_ResetUserState
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationAdministration_ResetUserState (
    @Count                  int                 OUT,
    @ApplicationName        NVARCHAR(256),
    @InactiveSinceDate      DATETIME            = NULL,
    @UserName               NVARCHAR(256)       = NULL,
    @Path                   NVARCHAR(256)       = NULL)
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
    IF (@ApplicationId IS NULL)
        SELECT @Count = 0
    ELSE
    BEGIN
        DELETE FROM dbo.aspnet_PersonalizationPerUser
        WHERE Id IN (SELECT PerUser.Id
                     FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths
                     WHERE Paths.ApplicationId = @ApplicationId
                           AND PerUser.UserId = Users.UserId
                           AND PerUser.PathId = Paths.PathId
                           AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)
                           AND (@UserName IS NULL OR Users.LoweredUserName = LOWER(@UserName))
                           AND (@Path IS NULL OR Paths.LoweredPath = LOWER(@Path)))

SELECT @Count = @@ROWCOUNT
    END
END
GO

/*************************************************************/
IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationAdministration_FindState')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationAdministration_FindState
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationAdministration_FindState (
    @AllUsersScope bit,
    @ApplicationName NVARCHAR(256),
    @PageIndex              INT,
    @PageSize               INT,
    @Path NVARCHAR(256) = NULL,
    @UserName NVARCHAR(256) = NULL,
    @InactiveSinceDate DATETIME = NULL)
AS
BEGIN
    DECLARE @ApplicationId UNIQUEIDENTIFIER
    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
    IF (@ApplicationId IS NULL)
        RETURN

-- Set the page bounds
    DECLARE @PageLowerBound INT
    DECLARE @PageUpperBound INT
    DECLARE @TotalRecords   INT
    SET @PageLowerBound = @PageSize * @PageIndex
    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound

-- Create a temp table to store the selected results
    CREATE TABLE #PageIndex (
        IndexId int IDENTITY (0, 1) NOT NULL,
        ItemId UNIQUEIDENTIFIER
    )

IF (@AllUsersScope = 1)
    BEGIN
        -- Insert into our temp table
        INSERT INTO #PageIndex (ItemId)
        SELECT Paths.PathId
        FROM dbo.aspnet_Paths Paths,
             ((SELECT Paths.PathId
               FROM dbo.aspnet_PersonalizationAllUsers AllUsers, dbo.aspnet_Paths Paths
               WHERE Paths.ApplicationId = @ApplicationId
                      AND AllUsers.PathId = Paths.PathId
                      AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
              ) AS SharedDataPerPath
              FULL OUTER JOIN
              (SELECT DISTINCT Paths.PathId
               FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Paths Paths
               WHERE Paths.ApplicationId = @ApplicationId
                      AND PerUser.PathId = Paths.PathId
                      AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
              ) AS UserDataPerPath
              ON SharedDataPerPath.PathId = UserDataPerPath.PathId
             )
        WHERE Paths.PathId = SharedDataPerPath.PathId OR Paths.PathId = UserDataPerPath.PathId
        ORDER BY Paths.Path ASC

SELECT @TotalRecords = @@ROWCOUNT

SELECT Paths.Path,
               SharedDataPerPath.LastUpdatedDate,
               SharedDataPerPath.SharedDataLength,
               UserDataPerPath.UserDataLength,
               UserDataPerPath.UserCount
        FROM dbo.aspnet_Paths Paths,
             ((SELECT PageIndex.ItemId AS PathId,
                      AllUsers.LastUpdatedDate AS LastUpdatedDate,
                      DATALENGTH(AllUsers.PageSettings) AS SharedDataLength
               FROM dbo.aspnet_PersonalizationAllUsers AllUsers, #PageIndex PageIndex
               WHERE AllUsers.PathId = PageIndex.ItemId
                     AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound
              ) AS SharedDataPerPath
              FULL OUTER JOIN
              (SELECT PageIndex.ItemId AS PathId,
                      SUM(DATALENGTH(PerUser.PageSettings)) AS UserDataLength,
                      COUNT(*) AS UserCount
               FROM aspnet_PersonalizationPerUser PerUser, #PageIndex PageIndex
               WHERE PerUser.PathId = PageIndex.ItemId
                     AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound
               GROUP BY PageIndex.ItemId
              ) AS UserDataPerPath
              ON SharedDataPerPath.PathId = UserDataPerPath.PathId
             )
        WHERE Paths.PathId = SharedDataPerPath.PathId OR Paths.PathId = UserDataPerPath.PathId
        ORDER BY Paths.Path ASC
    END
    ELSE
    BEGIN
        -- Insert into our temp table
        INSERT INTO #PageIndex (ItemId)
        SELECT PerUser.Id
        FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths
        WHERE Paths.ApplicationId = @ApplicationId
              AND PerUser.UserId = Users.UserId
              AND PerUser.PathId = Paths.PathId
              AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
              AND (@UserName IS NULL OR Users.LoweredUserName LIKE LOWER(@UserName))
              AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)
        ORDER BY Paths.Path ASC, Users.UserName ASC

SELECT @TotalRecords = @@ROWCOUNT

SELECT Paths.Path, PerUser.LastUpdatedDate, DATALENGTH(PerUser.PageSettings), Users.UserName, Users.LastActivityDate
        FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths, #PageIndex PageIndex
        WHERE PerUser.Id = PageIndex.ItemId
              AND PerUser.UserId = Users.UserId
              AND PerUser.PathId = Paths.PathId
              AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound
        ORDER BY Paths.Path ASC, Users.UserName ASC
    END

RETURN @TotalRecords
END
GO

/*************************************************************/
IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_PersonalizationAdministration_GetCountOfState')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_PersonalizationAdministration_GetCountOfState
GO
CREATE PROCEDURE dbo.aspnet_PersonalizationAdministration_GetCountOfState (
    @Count int OUT,
    @AllUsersScope bit,
    @ApplicationName NVARCHAR(256),
    @Path NVARCHAR(256) = NULL,
    @UserName NVARCHAR(256) = NULL,
    @InactiveSinceDate DATETIME = NULL)
AS
BEGIN

DECLARE @ApplicationId UNIQUEIDENTIFIER
    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT
    IF (@ApplicationId IS NULL)
        SELECT @Count = 0
    ELSE
        IF (@AllUsersScope = 1)
            SELECT @Count = COUNT(*)
            FROM dbo.aspnet_PersonalizationAllUsers AllUsers, dbo.aspnet_Paths Paths
            WHERE Paths.ApplicationId = @ApplicationId
                  AND AllUsers.PathId = Paths.PathId
                  AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
        ELSE
            SELECT @Count = COUNT(*)
            FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths
            WHERE Paths.ApplicationId = @ApplicationId
                  AND PerUser.UserId = Users.UserId
                  AND PerUser.PathId = Paths.PathId
                  AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))
                  AND (@UserName IS NULL OR Users.LoweredUserName LIKE LOWER(@UserName))
                  AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)
END
GO

/*************************************************************/
/*************************************************************/

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'vw_aspnet_WebPartState_Paths')
                  AND (type = 'V')))
BEGIN
  PRINT 'Creating the vw_aspnet_WebPartState_Paths view...'
  EXEC(N'
  CREATE VIEW [dbo].[vw_aspnet_WebPartState_Paths]
  AS SELECT [dbo].[aspnet_Paths].[ApplicationId], [dbo].[aspnet_Paths].[PathId], [dbo].[aspnet_Paths].[Path], [dbo].[aspnet_Paths].[LoweredPath]
  FROM [dbo].[aspnet_Paths]
  ')
END

/*************************************************************/
/*************************************************************/

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'vw_aspnet_WebPartState_Shared')
                  AND (type = 'V')))
BEGIN
  PRINT 'Creating the vw_aspnet_WebPartState_Shared view...'
  EXEC(N'
  CREATE VIEW [dbo].[vw_aspnet_WebPartState_Shared]
  AS SELECT [dbo].[aspnet_PersonalizationAllUsers].[PathId], [DataSize]=DATALENGTH([dbo].[aspnet_PersonalizationAllUsers].[PageSettings]), [dbo].[aspnet_PersonalizationAllUsers].[LastUpdatedDate]
  FROM [dbo].[aspnet_PersonalizationAllUsers]
  ')
END

/*************************************************************/
/*************************************************************/

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'vw_aspnet_WebPartState_User')
                  AND (type = 'V')))
BEGIN
  PRINT 'Creating the vw_aspnet_WebPartState_User view...'
  EXEC(N'
  CREATE VIEW [dbo].[vw_aspnet_WebPartState_User]
  AS SELECT [dbo].[aspnet_PersonalizationPerUser].[PathId], [dbo].[aspnet_PersonalizationPerUser].[UserId], [DataSize]=DATALENGTH([dbo].[aspnet_PersonalizationPerUser].[PageSettings]), [dbo].[aspnet_PersonalizationPerUser].[LastUpdatedDate]
  FROM [dbo].[aspnet_PersonalizationPerUser]
  ')
END
GO

/*************************************************************/
/*************************************************************/

--
--Create Personalization schema version
--

DECLARE @command nvarchar(4000)
SET @command = 'GRANT EXECUTE ON [dbo].aspnet_RegisterSchemaVersion TO ' + QUOTENAME(user)
EXECUTE (@command)
GO

EXEC [dbo].aspnet_RegisterSchemaVersion N'Personalization', N'1', 1, 1
GO

/*************************************************************/
/*************************************************************/

--
--Create Personalization roles
--

IF ( NOT EXISTS ( SELECT name
                  FROM sysusers
                  WHERE issqlrole = 1
                  AND name = N'aspnet_Personalization_FullAccess'  ) )
EXEC sp_addrole N'aspnet_Personalization_FullAccess'

IF ( NOT EXISTS ( SELECT name
                  FROM dbo.sysusers
                  WHERE issqlrole = 1
                  AND name = N'aspnet_Personalization_BasicAccess'  ) )
EXEC sp_addrole N'aspnet_Personalization_BasicAccess'

IF ( NOT EXISTS ( SELECT name
                  FROM sysusers
                  WHERE issqlrole = 1
                  AND name = N'aspnet_Personalization_ReportingAccess'  ) )
EXEC sp_addrole N'aspnet_Personalization_ReportingAccess'
GO

EXEC sp_addrolemember N'aspnet_Personalization_BasicAccess', N'aspnet_Personalization_FullAccess'
EXEC sp_addrolemember N'aspnet_Personalization_ReportingAccess', N'aspnet_Personalization_FullAccess'
GO

--
--Stored Procedure rights for BasicAccess
--
GRANT EXECUTE ON dbo.aspnet_Paths_CreatePath TO aspnet_Personalization_BasicAccess

GRANT EXECUTE ON dbo.aspnet_PersonalizationAllUsers_GetPageSettings TO aspnet_Personalization_BasicAccess
GRANT EXECUTE ON dbo.aspnet_PersonalizationPerUser_GetPageSettings TO aspnet_Personalization_BasicAccess
GRANT EXECUTE ON dbo.aspnet_PersonalizationAllUsers_ResetPageSettings TO aspnet_Personalization_BasicAccess
GRANT EXECUTE ON dbo.aspnet_PersonalizationPerUser_ResetPageSettings TO aspnet_Personalization_BasicAccess
GRANT EXECUTE ON dbo.aspnet_PersonalizationAllUsers_SetPageSettings TO aspnet_Personalization_BasicAccess
GRANT EXECUTE ON dbo.aspnet_PersonalizationPerUser_SetPageSettings TO aspnet_Personalization_BasicAccess

GRANT EXECUTE ON dbo.aspnet_Personalization_GetApplicationId TO aspnet_Personalization_BasicAccess

GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Personalization_BasicAccess
GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Personalization_BasicAccess
GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Personalization_BasicAccess

--
--Stored Procedure rights for ReportingAccess
--
GRANT EXECUTE ON dbo.aspnet_PersonalizationAdministration_FindState TO aspnet_Personalization_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_PersonalizationAdministration_GetCountOfState TO aspnet_Personalization_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Personalization_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Personalization_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Personalization_ReportingAccess

--
--Additional stored procedure rights for FullAccess
--
GRANT EXECUTE ON dbo.aspnet_PersonalizationAdministration_ResetUserState TO aspnet_Personalization_FullAccess
GRANT EXECUTE ON dbo.aspnet_PersonalizationAdministration_ResetSharedState TO aspnet_Personalization_FullAccess
GRANT EXECUTE ON dbo.aspnet_PersonalizationAdministration_DeleteAllState TO aspnet_Personalization_FullAccess

--
--View rights
--
GRANT SELECT ON dbo.vw_aspnet_Applications TO aspnet_Personalization_ReportingAccess
GRANT SELECT ON dbo.vw_aspnet_Users TO aspnet_Personalization_ReportingAccess

GRANT SELECT ON dbo.vw_aspnet_WebPartState_Paths TO aspnet_Personalization_ReportingAccess
GRANT SELECT ON dbo.vw_aspnet_WebPartState_Shared TO aspnet_Personalization_ReportingAccess
GRANT SELECT ON dbo.vw_aspnet_WebPartState_User TO aspnet_Personalization_ReportingAccess
GO
-------------------------------------------------------------------------
--- Version specific install
-------------------------------------------------------------------------

DECLARE @ver INT
DECLARE @version NCHAR(100)
DECLARE @dot INT
DECLARE @hyphen INT
DECLARE @SqlToExec NCHAR(400)

SELECT @ver = 8
SELECT @version = @@Version
SELECT @hyphen  = CHARINDEX(N' - ', @version)
IF (NOT(@hyphen IS NULL) AND @hyphen > 0)
BEGIN
    SELECT @hyphen = @hyphen + 3
    SELECT @dot    = CHARINDEX(N'.', @version, @hyphen)
    IF (NOT(@dot IS NULL) AND @dot > @hyphen)
    BEGIN
        SELECT @version = SUBSTRING(@version, @hyphen, @dot - @hyphen)
        SELECT @ver     = CONVERT(INT, @version)
    END
END

IF (@ver >= 8)
BEGIN
    EXEC sp_tableoption N'aspnet_PersonalizationAllUsers', 'text in row', 6000
    EXEC sp_tableoption N'aspnet_PersonalizationPerUser', 'text in row', 6000
END
GO

DECLARE @command nvarchar(4000)
SET @command = 'REVOKE EXECUTE ON [dbo].aspnet_RegisterSchemaVersion FROM ' + QUOTENAME(user)
EXECUTE (@command)
GO

PRINT '-------------------------------------------------'
PRINT 'Completed execution of InstallPersonalization.SQL'
PRINT '-------------------------------------------------'

${this.title}

Code Editor : InstallPersonalization.sql