Table: aspnet_PersonalizationPerUser

Description

Used by the SQL Personalization Provider to store per-user personalization data.

Columns

Name	Type	Required?	Defaults To	Description
Id	uniqueidentifier	Yes	(newid())	ID of this record
PathId	uniqueidentifier	No		ID of the virtual path to which this state pertains
UserId	uniqueidentifier	No		ID of the user to which this state pertains
PageSettings	image	Yes		Serialized personalization state
LastUpdatedDate	datetime	Yes		Date and time state was saved

Relationships

Primary Table	Primary Key	Foreign Table	Foreign Key
aspnet_Paths	PathId	aspnet_PersonalizationPerUser	PathId
aspnet_Users	UserId	aspnet_PersonalizationPerUser	UserId

Indexes

Name	Type	Columns
aspnet_PersonalizationPerUser_index1	Unique, Clustered	PathId, UserId
aspnet_PersonalizationPerUser_ncindex2	Unique	UserId, PathId
PK__aspnet_Personali__4D94879B	Unique	Id

Referencing Views

Name
vw_aspnet_WebPartState_User

Definition

CREATE TABLE [aspnet_PersonalizationPerUser]
(
    [Id] uniqueidentifier NOT NULL DEFAULT ((newid())),
    [PathId] uniqueidentifier NULL,
    [UserId] uniqueidentifier NULL,
    [PageSettings] image NOT NULL,
    [LastUpdatedDate] datetime NOT NULL
    CONSTRAINT [PK_aspnet_PersonalizationPerUser] PRIMARY KEY
    (
        [Id]
    )
)

---

ASP.NET 2.0 Provider Database