[phpMyChat CVS] CVS: phpMyChat-0.15/chat/install/database pgsql.sql,1.8,1.9 mysql.sql,1.11,1.12

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

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

Modified Files:
	pgsql.sql mysql.sql 
Log Message:
For Tinou: improved messages tables (lower database soft. charge)

Index: pgsql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/pgsql.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -r1.8 -r1.9
*** pgsql.sql	2001/11/26 22:16:08	1.8
--- pgsql.sql	2001/11/29 22:00:56	1.9
***************
*** 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);
  
  
--- 38,46 ----
    msg_original text NOT NULL DEFAULT '' ,
    msg_enhanced text NOT NULL DEFAULT '' ,
!   PRIMARY KEY (m_id, room)
  );
! CREATE INDEX idx1 ON pmc_messages (username, address, room);
  CREATE INDEX idx2 ON pmc_messages (m_time, username, room);
+ CREATE INDEX idx3 ON pmc_messages (room, username);
  
  

Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/mysql.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** mysql.sql	2001/11/26 22:16:08	1.11
--- mysql.sql	2001/11/29 22:00:56	1.12
***************
*** 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)
  );
  
--- 35,42 ----
    msg_original text NOT NULL DEFAULT '' ,
    msg_enhanced text NOT NULL DEFAULT '' ,
!   PRIMARY KEY (m_id, room) ,
!   INDEX idx1 (username, address, room) ,
!   INDEX idx2 (m_time, username, room) ,
!   INDEX idx3 (room, username)
  );