Re: [Firebird-net-provider] Fb Web Provider

[Jiri C. <di...@ci...>]

On 5/30/08, Mercea Paul <pau...@ya...> 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