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);
|