[phpMyChat CVS] CVS: phpMyChat-0.15/chat/install/database mysql.sql,1.9,1.10 pgsql.sql,1.6,1.7

[Lo?c C. <lo...@us...>]

Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database
In directory usw-pr-cvs1:/tmp/cvs-serv12055/chat/install/database

Modified Files:
	mysql.sql pgsql.sql 
Log Message:
added m_id in the pmc_messages table to fix messages loss in the message frame

Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/mysql.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** mysql.sql	2001/06/10 21:02:06	1.9
--- mysql.sql	2001/11/26 20:22:15	1.10
***************
*** 26,29 ****
--- 26,30 ----
  DROP TABLE /*!32200 IF EXISTS*/ pmc_messages;
  CREATE TABLE pmc_messages (
+   m_id int unsigned NOT NULL AUTO_INCREMENT ,
    room varchar(30) NOT NULL DEFAULT '' ,
    username varchar(30) NOT NULL DEFAULT '' ,
***************
*** 34,40 ****
    msg_original text NOT NULL DEFAULT '' ,
    msg_enhanced text NOT NULL DEFAULT '' ,
!   PRIMARY KEY (username, room, m_time),
!   INDEX idx1 (m_time, room, address, username),
!   INDEX idx2 (m_time, username)
  );
  
--- 35,41 ----
    msg_original text NOT NULL DEFAULT '' ,
    msg_enhanced text NOT NULL DEFAULT '' ,
!   PRIMARY KEY (m_id) ,
!   INDEX idx1 (m_id, room, address, username) ,
!   INDEX idx2 (m_time, username, room)
  );
  

Index: pgsql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/pgsql.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** pgsql.sql	2001/06/10 21:02:33	1.6
--- pgsql.sql	2001/11/26 20:22:15	1.7
***************
*** 27,31 ****
--- 27,33 ----
  #
  
+ CREATE SEQUENCE pmc_messages_m_id;
  CREATE TABLE pmc_messages (
+   m_id int4 NOT NULL DEFAULT nextval('pmc_messages_m_id') ,
    room varchar(30) NOT NULL DEFAULT '' ,
    username varchar(30) NOT NULL DEFAULT '' ,
***************
*** 36,43 ****
    msg_original text NOT NULL DEFAULT '' ,
    msg_enhanced text NOT NULL DEFAULT '' ,
!   PRIMARY KEY (username, room, m_time)
  );
! CREATE INDEX idx1 ON pmc_messages (m_time, room, address, username);
! CREATE INDEX idx2 ON pmc_messages (m_time, username);
  
  
--- 38,45 ----
    msg_original text NOT NULL DEFAULT '' ,
    msg_enhanced text NOT NULL DEFAULT '' ,
!   PRIMARY KEY (m_id)
  );
! CREATE INDEX idx1 ON pmc_messages (m_id, room, address, username);
! CREATE INDEX idx2 ON pmc_messages (m_time, username, room);