|
zdravicko, strucne a jasne: 1. problem s profile providerem, pridal som par stlpcov ako datum narodenia a podobne (web.config) a nasledne som upravil CreateUserWizard o dalsie polozky s profile provideru, takze otazka znie: mam tam este pisat nejaky kod do CreateUserWizard na ukladanie do tabulky Profiles?? ci to sa robi automaticky ? lebo mi do tabulky v DB nic neulozi 2. maju byt previazane tabulky Users a Profiles? (dal som to cez FK UserName) PS: web.config je nastaveny spravne tam chyba nebude. PRILOHA SQL table:
go
CREATE TABLE dbo.[Users](
UserId int IDENTITY(1,1) NOT NULL,
UserName nvarchar(100) NOT NULL,
PasswordHash char(86) NOT NULL,
PasswordSalt char(5) NOT NULL,
Email nvarchar(100) NOT NULL,
Comment text NULL,
Enabled bit NOT NULL,
DateCreated datetime NOT NULL,
DateLastLogin datetime NULL,
DateLastActivity datetime NULL,
DateLastPasswordChange datetime NOT NULL,
CONSTRAINT PK_Users PRIMARY KEY CLUSTERED (UserId ASC),
CONSTRAINT IX_Users_UserName UNIQUE NONCLUSTERED (UserName ASC)
)
go
CREATE TABLE dbo.[Profiles] (
[ProfileId] int IDENTITY(1,1) NOT NULL,
[UserName] nvarchar(100) NOT NULL,
[MotoGPNickName] nvarchar(100) NOT NULL,
[FirstName] nvarchar(32) NULL,
[LastName] nvarchar(32) NULL,
[BirthDay] Smalldatetime NOT NULL,
[IcqNumber] nvarchar(9) NULL,
--[Email] nvarchar(256) NOT NULL,
[Question] nvarchar(256) NOT NULL,
[Answer] nvarchar(128) NOT NULL,
[LastUpdate] datetime NOT NULL,
[ShowPersonalInfo] bit NOT NULL DEFAULT(0),
CONSTRAINT PK_Profiles PRIMARY KEY CLUSTERED (ProfileId ASC),
CONSTRAINT FK_Profiles_Users FOREIGN KEY (UserName) REFERENCES dbo.[Users] (UserName) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT IX_Profiles_MotoGPNickName UNIQUE NONCLUSTERED (MotoGPNickName ASC)
)
|