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