[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.98,1.99

[dhaun at iowaoutdoors.org]

Update of /var/cvs/geeklog-1.3/sql
In directory www:/tmp/cvs-serv22332

Modified Files:
	mysql_tableanddata.php 
Log Message:
Added a few indexes on the 'users' table


Index: mysql_tableanddata.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.98
retrieving revision 1.99
diff -C2 -d -r1.98 -r1.99
*** mysql_tableanddata.php	3 Feb 2005 19:57:40 -0000	1.98
--- mysql_tableanddata.php	6 Feb 2005 10:55:48 -0000	1.99
***************
*** 555,559 ****
    pwrequestid varchar(16) default NULL,
    PRIMARY KEY  (uid),
!   KEY LOGIN (uid,passwd,username)
  ) TYPE=MyISAM
  ";
--- 555,564 ----
    pwrequestid varchar(16) default NULL,
    PRIMARY KEY  (uid),
!   KEY LOGIN (uid,passwd,username),
!   INDEX users_username(username),
!   INDEX users_fullname(fullname),
!   INDEX users_email(email),
!   INDEX users_passwd(passwd),
!   INDEX users_pwrequestid(pwrequestid)
  ) TYPE=MyISAM
  ";