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
