Table: aspnet_PersonalizationAllUsers

Description

Used by the SQL Personalization Provider to store shared personalization data.

Columns

Name	Type	Required?	Defaults To	Description
PathId	uniqueidentifier	Yes		ID of the virtual path 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_PersonalizationAllUsers	PathId

Indexes

Name	Type	Columns
PK__aspnet_Personali__4AB81AF0	Unique, Clustered	PathId

Referencing Views

Name
vw_aspnet_WebPartState_Shared

Definition

CREATE TABLE [aspnet_PersonalizationAllUsers]
(
    [PathId] uniqueidentifier NOT NULL,
    [PageSettings] image NOT NULL,
    [LastUpdatedDate] datetime NOT NULL
    CONSTRAINT [PK_aspnet_PersonalizationAllUsers] PRIMARY KEY
    (
        [PathId]
    )
)

---

ASP.NET 2.0 Provider Database