Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database
In directory usw-pr-cvs1:/tmp/cvs-serv28854/chat/install/database
Modified Files:
mysql.sql
Log Message:
The 'username' column is now a primary key
Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/mysql.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** mysql.sql 2001/04/17 10:04:50 1.4
--- mysql.sql 2001/04/21 15:16:22 1.5
***************
*** 90,94 ****
ip varchar(16) NOT NULL DEFAULT '' ,
PRIMARY KEY (session_id),
! KEY room_id (room),
KEY status (status),
KEY u_time (u_time)
--- 90,95 ----
ip varchar(16) NOT NULL DEFAULT '' ,
PRIMARY KEY (session_id),
! PRIMARY KEY (username),
! KEY room (room),
KEY status (status),
KEY u_time (u_time)
|
