[phpMyChat CVS] CVS: phpMyChat-0.15/chat/install/database mysql.sql,1.1,1.2

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

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