Hi all
I'm testing web provider for Fb for a new project and looks a little
unfriendly to install sql files!
For a user who try the first time this could be little disappointing!
So ,my suggestion is to order(rename) the files in execution order,
somethink like:
1.FbRoleProvider2.0.sql
2. FbMembershipProvider2.0.sql
3.FbProfileProvider2.0.sql
4.FbSessionStateStore2.0.sql
This way I know I must run 1,2,3,4.
Another thing:
in FbProfileProvider2.0.sql file is : /* This provider don't work without
the membership provider */,
Third line in FbProfileProvider2.0.sql :
CREATE DOMAIN BOOL AS
SMALLINT
NOT NULL
CHECK (value=1 or value=0 or value is null);
But Is already created from membership provider
(FbMembershipProvider2.0.sql) , it will generate error on execution!
On USERS table, can be changed the PK name? (Now is created like
RDB$PRIMARYXXXX!!)
>From
ALTER TABLE USERS ADD PRIMARY KEY (PKID);
To
ALTER TABLE USERS ADD CONSTRAINT PK_ USERS PRIMARY KEY (PKID);
How is more suggesting the index name ?
CREATE INDEX USERS_IDX5 ON USERS (EMAIL)
Or
CREATE INDEX USERS_EMAIL ON USERS (EMAIL)
Best Regards,
Paul
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
