[phpesp-dev] [ phpesp-Bugs-1153614 ] too small password fields

[SourceForge.net <no...@so...>]

Bugs item #1153614, was opened at 2005-02-28 08:44
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1153614&group_id=8956

Category: SQL
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: too small password fields

Initial Comment:
In 1.7 rc(something) the password char columns are too
narrow to accomodate the mysql 4 password() hashes. The
following patch seems to fix it: 

===================================================================
RCS file: RCS/mysql_populate.sql,v
retrieving revision 1.1
diff -u -r1.1 mysql_populate.sql
--- mysql_populate.sql  2005/02/28 16:40:32     1.1
+++ mysql_populate.sql  2005/02/28 16:41:25
@@ -31,7 +31,7 @@
 -- # table of respondents (people who enter data /
take surveys)
 CREATE TABLE respondent (
        username        CHAR(64) NOT NULL,
-       password        CHAR(16) NOT NULL,
+       password        CHAR(64) NOT NULL,
        auth            CHAR(16) NOT NULL DEFAULT 'BASIC',
        realm           CHAR(16) NOT NULL,
        fname           CHAR(16),
@@ -46,7 +46,7 @@
 -- # table of designers (people who create forms /
surveys)
 CREATE TABLE designer (
        username        CHAR(64) NOT NULL,
-       password        CHAR(16) NOT NULL,
+       password        CHAR(64) NOT NULL,
        auth            CHAR(16) NOT NULL DEFAULT 'BASIC',
        realm           CHAR(16) NOT NULL,
        fname           CHAR(16),


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1153614&group_id=8956