[phpMyChat CVS] CVS: phpMyChat-0.15/chat/install/database pgsql.sql,1.2,1.3

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

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

Modified Files:
	pgsql.sql 
Log Message:
Far more convincing version...

Index: pgsql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/pgsql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** pgsql.sql	2001/04/17 11:55:42	1.2
--- pgsql.sql	2001/04/21 15:16:52	1.3
***************
*** 10,22 ****
  
  CREATE TABLE pmc_ban_users (
!   username varchar(30) NOT NULL DEFAULT '' ,
    latin1 int2 NOT NULL DEFAULT '0' ,
    ip varchar(16) NOT NULL DEFAULT '' ,
    rooms varchar(100) NOT NULL DEFAULT '' ,
!   ban_until int4 NOT NULL DEFAULT '0' ,
!   PRIMARY KEY (username),
!   KEY ip (ip),
!   KEY ban_until (ban_until)
  );
  
  
--- 10,21 ----
  
  CREATE TABLE pmc_ban_users (
!   username varchar(30) PRIMARY KEY,
    latin1 int2 NOT NULL DEFAULT '0' ,
    ip varchar(16) NOT NULL DEFAULT '' ,
    rooms varchar(100) NOT NULL DEFAULT '' ,
!   ban_until int4 NOT NULL DEFAULT '0'
  );
+ CREATE INDEX ip ON pmc_ban_users (ip);
+ CREATE INDEX ban_until ON pmc_ban_users (ban_until);
  
  
***************
*** 34,41 ****
    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)
  );
  
  
--- 33,40 ----
    color varchar(7) NOT NULL DEFAULT '#000000' ,
    msg_original text NOT NULL DEFAULT '' ,
!   msg_enhanced text NOT NULL DEFAULT ''
  );
+ CREATE INDEX type ON pmc_messages (type);
+ CREATE INDEX m_time ON pmc_messages (m_time);
  
  
***************
*** 45,49 ****
  
  CREATE TABLE pmc_reg_users (
!   username varchar(30) NOT NULL DEFAULT '' ,
    latin1 int2 NOT NULL DEFAULT '0' ,
    password varchar(32) NOT NULL DEFAULT '' ,
--- 44,48 ----
  
  CREATE TABLE pmc_reg_users (
!   username varchar(30) PRIMARY KEY ,
    latin1 int2 NOT NULL DEFAULT '0' ,
    password varchar(32) NOT NULL DEFAULT '' ,
***************
*** 58,67 ****
    reg_time int4 NOT NULL DEFAULT '0' ,
    ip varchar(16) NOT NULL DEFAULT '' ,
!   gender int2 NOT NULL DEFAULT '0' ,
!   PRIMARY KEY (username),
!   KEY reg_time (reg_time),
!   KEY perms (perms)
  );
  INSERT INTO pmc_reg_users VALUES('admin', '', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', '', '', '');
  
  
--- 57,65 ----
    reg_time int4 NOT NULL DEFAULT '0' ,
    ip varchar(16) NOT NULL DEFAULT '' ,
!   gender int2 NOT NULL DEFAULT '0'
  );
  INSERT INTO pmc_reg_users VALUES('admin', '', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', '', '', '');
+ CREATE INDEX reg_time ON pmc_reg_users (reg_time);
+ CREATE INDEX perms ON pmc_reg_users (perms);
  
  
***************
*** 71,80 ****
  
  CREATE TABLE pmc_sessions (
!   session_id varchar(32) NOT NULL DEFAULT '' ,
    last int4 NOT NULL DEFAULT '0' ,
!   data text ,
!   PRIMARY KEY (session_id),
!   KEY last (last)
  );
  
  
--- 69,77 ----
  
  CREATE TABLE pmc_sessions (
!   session_id varchar(32) PRIMARY KEY ,
    last int4 NOT NULL DEFAULT '0' ,
!   data text
  );
+ CREATE INDEX last ON pmc_sessions (last);
  
  
***************
*** 84,101 ****
  
  CREATE TABLE pmc_users (
!   session_id varchar(32) NOT NULL DEFAULT '' ,
    u_time int4 NOT NULL DEFAULT '0' ,
    room varchar(30) NOT NULL DEFAULT '' ,
!   username varchar(30) NOT NULL DEFAULT '' ,
    latin1 int2 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)
  );
! 
! 
! 
! 
--- 81,93 ----
  
  CREATE TABLE pmc_users (
!   session_id varchar(32) PRIMARY KEY ,
    u_time int4 NOT NULL DEFAULT '0' ,
    room varchar(30) NOT NULL DEFAULT '' ,
!   username varchar(30) PRIMARY KEY ,
    latin1 int2 NOT NULL DEFAULT '0' ,
    status char(1) NOT NULL DEFAULT 'u' ,
!   ip varchar(16) NOT NULL DEFAULT ''
  );
! CREATE INDEX room ON pmc_users (room);
! CREATE INDEX status ON pmc_users (status);
! CREATE INDEX u_time ON pmc_users (u_time);