[phpMyChat CVS] CVS: phpMyChat-0.15/chat/install/database pgsql.sql,1.5,1.6

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

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

Modified Files:
	pgsql.sql 
Log Message:
Too many changes to detail.

Index: pgsql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/pgsql.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** pgsql.sql	2001/05/27 15:21:32	1.5
--- pgsql.sql	2001/06/10 21:02:33	1.6
***************
*** 1,2 ****
--- 1,5 ----
+ # -----------------------------------------
+ # Tables structure for phpMyChat 0.15.0-dev
+ # -----------------------------------------
  #
  # Please note that this model is a bit theorical: we don't test it yet.
***************
*** 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);
  
  
--- 13,24 ----
  
  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, ip)
  );
! CREATE INDEX idx1 ON pmc_ban_users (ban_until);
  
  
***************
*** 25,40 ****
  
  CREATE TABLE pmc_messages (
-   type int2 NOT NULL DEFAULT '0' ,
    room varchar(30) NOT NULL DEFAULT '' ,
    username varchar(30) NOT NULL DEFAULT '' ,
    latin1 int2 NOT NULL DEFAULT '0' ,
    m_time int4 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 ''
  );
! CREATE INDEX type ON pmc_messages (type);
! CREATE INDEX m_time ON pmc_messages (m_time);
  
  
--- 28,43 ----
  
  CREATE TABLE pmc_messages (
    room varchar(30) NOT NULL DEFAULT '' ,
    username varchar(30) NOT NULL DEFAULT '' ,
    latin1 int2 NOT NULL DEFAULT '0' ,
    m_time int4 NOT NULL DEFAULT '0' ,
!   address varchar(30) NOT NULL DEFAULT '' ,
    color varchar(7) NOT NULL DEFAULT '#000000' ,
    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);
  
  
***************
*** 44,78 ****
  
  CREATE TABLE pmc_reg_users (
!   username varchar(30) PRIMARY KEY ,
!   latin1 int2 NOT NULL DEFAULT '0' ,
    password varchar(32) NOT NULL DEFAULT '' ,
    firstname varchar(64) NOT NULL DEFAULT '' ,
    lastname varchar(64) NOT NULL DEFAULT '' ,
!   country varchar(64) ,
!   website varchar(64) ,
    email varchar(64) NOT NULL DEFAULT '' ,
    showemail int2 NOT NULL DEFAULT '0' ,
-   perms varchar(9) NOT NULL DEFAULT 'user' ,
-   rooms varchar(128) NOT NULL DEFAULT '' ,
    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', '', 'admin', '', '', '', '', '', 0, 'admin', '', '', '', '');
! CREATE INDEX reg_time ON pmc_reg_users (reg_time);
! CREATE INDEX perms ON pmc_reg_users (perms);
  
  
  #
  # Table structure for table 'pmc_sessions'
  #
  
  CREATE TABLE pmc_sessions (
!   session_id varchar(32) PRIMARY KEY ,
    ip varchar(15) NOT NULL DEFAULT '' ,
    last int4 NOT NULL DEFAULT '0' ,
!   data text
  );
! CREATE INDEX last ON pmc_sessions (last);
  
  
--- 47,108 ----
  
  CREATE TABLE pmc_reg_users (
!   username varchar(30) NOT NULL DEFAULT '' ,
!   charset varchar(20) NOT NULL DEFAULT 'x-user-defined' ,
    password varchar(32) NOT NULL DEFAULT '' ,
    firstname varchar(64) NOT NULL DEFAULT '' ,
    lastname varchar(64) NOT NULL DEFAULT '' ,
!   country varchar(64) NOT NULL DEFAULT '' ,
!   website varchar(200) NOT NULL DEFAULT '' ,
    email varchar(64) NOT NULL DEFAULT '' ,
    showemail int2 NOT NULL DEFAULT '0' ,
    reg_time int4 NOT NULL DEFAULT '0' ,
    ip varchar(16) NOT NULL DEFAULT '' ,
!   gender int2 NOT NULL DEFAULT '0' ,
!   PRIMARY KEY (username)
  );
! CREATE INDEX idx1 ON pmc_reg_users (reg_time);
! INSERT INTO pmc_reg_users VALUES('admin', '', 'admin', '', '', '', '', '', 0, '', '', '');
  
  
  #
+ # Table structure for table 'pmc_rights'
+ # right_level is : 10 for the administrator,
+ #                   5 for a moderator 
+ #
+ 
+ CREATE TABLE pmc_rights (
+   username varchar(30) NOT NULL DEFAULT '' ,
+   room varchar(30) NOT NULL DEFAULT '' ,
+   right_level int2 NOT NULL DEFAULT '5' ,
+   PRIMARY KEY (username, room)
+ );
+ CREATE INDEX idx1 ON pmc_rights (room);
+ INSERT INTO pmc_rights VALUES('admin', '', 10);
+ 
+ 
+ #
+ # Table structure for table 'pmc_rooms'
+ #
+ 
+ CREATE TABLE pmc_rooms (
+   room_type int2 NOT NULL DEFAULT '1' ,
+   room_name varchar(30) NOT NULL DEFAULT '' ,
+   last_user_modif int4 NOT NULL DEFAULT '0' ,
+   PRIMARY KEY (room_name)
+ );
+ 
+ 
+ #
  # Table structure for table 'pmc_sessions'
  #
  
  CREATE TABLE pmc_sessions (
!   session_id varchar(32) NOT NULL DEFAULT '' ,
    ip varchar(15) NOT NULL DEFAULT '' ,
    last int4 NOT NULL DEFAULT '0' ,
!   data text ,
!   PRIMARY KEY (session_id, ip)
  );
! CREATE INDEX idx1 ON pmc_sessions (last);
  
  
***************
*** 82,94 ****
  
  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);
--- 112,125 ----
  
  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(2) NOT NULL DEFAULT '0' ,
!   ip varchar(16) NOT NULL DEFAULT '' ,
!   away int2 NOT NULL DEFAULT '0' ,
!   PRIMARY KEY (username, room)
  );
! CREATE INDEX idx1 ON pmc_users (u_time, status);
! CREATE INDEX idx2 ON pmc_users (session_id);