On 5/30/08, Mercea Paul <[EMAIL PROTECTED]> wrote:
> 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…
There's a FbWebProviders2.0.sql file, that contains calling for
separate files in right order.
> 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!
Removed.
> 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);
Done.
> How is more suggesting the index name ?
> CREATE INDEX USERS_IDX5 ON USERS (EMAIL)
> Or
> CREATE INDEX USERS_EMAIL ON USERS (EMAIL)
Done.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
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
