I plan on working on this too. We should work together. This is the
table format I will be using. Thanks for the
link, I had been looking for it :-) . I will also be duplicating this
for Oracle and SQL Server. This is for the
Chrome Portal project.
http://sourceforge.net/projects/chromeportal/
RECREATE TABLE CP_MEMBERS
(
MEMBER_ID NUMERIC( 15, 0) NOT NULL,
MEMBER_DATE TIMESTAMP NOT NULL,
MEMBER_PASSWORD VARCHAR( 128) CHARACTER SET
UNICODE_FSS NOT NULL COLLATE UNICODE_FSS,
PASSWORD_FORMAT NUMERIC( 1, 0) DEFAULT 0 NOT
NULL,
PASSWORD_SALT VARCHAR( 128) CHARACTER SET
UNICODE_FSS NOT NULL COLLATE UNICODE_FSS,
MOBILE_PIN VARCHAR( 30) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
MEMBER_EMAIL VARCHAR( 256) CHARACTER SET
UNICODE_FSS NOT NULL COLLATE UNICODE_FSS,
MEMBER_EMAIL_LOWERED VARCHAR( 256) CHARACTER SET
UNICODE_FSS NOT NULL COLLATE UNICODE_FSS,
MEMBER_SCREEN_NAME VARCHAR( 30) CHARACTER SET
UNICODE_FSS NOT NULL COLLATE UNICODE_FSS,
MEMBER_SCREEN_NAME_LOWERED VARCHAR( 30) CHARACTER SET
UNICODE_FSS NOT NULL COLLATE UNICODE_FSS,
PASSWORD_QUESTION VARCHAR( 256) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
PASSWORD_ANSWER VARCHAR( 256) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
FIRST_NAME VARCHAR( 60) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
MIDDLE_NAME VARCHAR( 60) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
LAST_NAME VARCHAR( 60) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
MEMBER_GENDER CHAR( 1) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
MEMBER_DATE_OF_BIRTH TIMESTAMP,
ACCOUNT_STATUS VARCHAR( 30) CHARACTER SET
UNICODE_FSS DEFAULT 'NEW' NOT NULL COLLATE UNICODE_FSS,
LOCK_DATE TIMESTAMP,
LAST_LOGIN_DATE TIMESTAMP NOT NULL,
LAST_PASSWORD_CHANGED_DATE TIMESTAMP NOT NULL,
LAST_LOCKOUT_DATE TIMESTAMP NOT NULL,
FAILED_PASS_ATTEMPT_COUNT NUMERIC( 1, 0) DEFAULT 0 NOT
NULL,
FAILED_PASS_ATTEMPT_START TIMESTAMP,
FAILED_ANSWER_ATTEMPT_COUNT NUMERIC( 1, 0) DEFAULT 0 NOT
NULL,
FAILED_ANSWER_ATTEMPT_START TIMESTAMP,
MEMBER_ICON_TYPE CHAR( 1) CHARACTER SET
UNICODE_FSS DEFAULT 'F' NOT NULL COLLATE UNICODE_FSS,
MEMBER_ICON_FILE VARCHAR( 256) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
MEMBER_ICON_IMAGE BLOB SUB_TYPE 0 SEGMENT
SIZE 80,
MEMBER_PICTURE_TYPE CHAR( 1) CHARACTER SET
UNICODE_FSS DEFAULT 'F' NOT NULL COLLATE UNICODE_FSS,
MEMBER_PICTURE_FILE VARCHAR( 256) CHARACTER SET
UNICODE_FSS COLLATE UNICODE_FSS,
MEMBER_PICTURE_IMAGE BLOB SUB_TYPE 0 SEGMENT
SIZE 80,
MEMBER_NOTE BLOB SUB_TYPE 1 SEGMENT
SIZE 80,
LAST_WRITE_DATE TIMESTAMP DEFAULT
'CURRENT_TIMESTAMP NOT' NOT NULL,
CONSTRAINT CP_MEMBERS_PK PRIMARY KEY (MEMBER_ID)
);
Carlos Guzmán Álvarez wrote:
Hello:
I have done some changes in the nant build file now the build will
generate 3 assemblies:
FirebirdSql.Data.FirebirdClient.dll
FirebirdSql.Data.FirebirdClient.UnitTests.dll
FirebirdSql.Web.Providers.dll
The FirebirdSql.Web.Providers will include the
SessionStateStoreProviderBase contributed by Alessandro Petrelli
I have found a sample implementation of a MembershipProvider in teh MS
docs that i will try to port to Firebird, the sample can be found here:
http://msdn2.microsoft.com/en-us/library/6tc47t75.aspx
--
Thomas Miller
Chrome Portal Project Manager
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com
http://www.cpcug.org/user/delphi/index.html
http://sourceforge.net/projects/chromeportal/
http://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
