Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database
In directory usw-pr-cvs1:/tmp/cvs-serv5164/chat/install/database
Modified Files:
mysql.sql
Log Message:
The first dev. version that works! Still many things to do, of course...
Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/mysql.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** mysql.sql 2001/03/29 22:52:17 1.1
--- mysql.sql 2001/04/03 20:14:52 1.2
***************
*** 26,30 ****
m_time int(11) unsigned NOT NULL DEFAULT '0' ,
address varchar(30) ,
! message text NOT NULL DEFAULT '' ,
KEY type (type),
KEY m_time (m_time)
--- 26,32 ----
m_time int(11) unsigned NOT NULL DEFAULT '0' ,
address varchar(30) ,
! color varchar(7) NOT NULL DEFAULT '#000000' ,
! msg_original text NOT NULL DEFAULT '' ,
! msg_enhanced text NOT NULL DEFAULT '' ,
KEY type (type),
KEY m_time (m_time)
***************
*** 76,86 ****
CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_users (
session_id varchar(32) NOT NULL DEFAULT '' ,
room varchar(30) NOT NULL DEFAULT '' ,
- latin1 tinyint(1) unsigned NOT NULL DEFAULT '0' ,
username varchar(30) NOT NULL DEFAULT '' ,
status char(1) NOT NULL DEFAULT 'u' ,
ip varchar(16) NOT NULL DEFAULT '' ,
PRIMARY KEY (session_id),
KEY room_id (room),
! KEY status (status)
);
--- 78,90 ----
CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_users (
session_id varchar(32) NOT NULL DEFAULT '' ,
+ u_time int(11) unsigned NOT NULL DEFAULT '0' ,
room varchar(30) NOT NULL DEFAULT '' ,
username varchar(30) NOT NULL DEFAULT '' ,
+ latin1 tinyint(1) unsigned NOT NULL DEFAULT '0' ,
status char(1) NOT NULL DEFAULT 'u' ,
ip varchar(16) NOT NULL DEFAULT '' ,
PRIMARY KEY (session_id),
KEY room_id (room),
! KEY status (status),
! KEY u_time (u_time)
);
|
