[phpMyChat CVS] CVS: phpMyChat-0.15/chat/install/database mysql.sql,1.7,1.8

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

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

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

Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/mysql.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -r1.7 -r1.8
*** mysql.sql	2001/05/27 15:21:32	1.7
--- mysql.sql	2001/06/10 14:57:47	1.8
***************
*** 1,7 ****
  #
  # Table structure for table 'pmc_ban_users'
  #
  
! DROP TABLE /*!32312 IF EXISTS*/ pmc_ban_users;
  CREATE TABLE pmc_ban_users (
    username varchar(30) NOT NULL DEFAULT '' ,
--- 1,12 ----
+ # -----------------------------------------
+ # Tables structure for phpMyChat 0.15.0-dev
+ # -----------------------------------------
+ 
+ 
  #
  # Table structure for table 'pmc_ban_users'
  #
  
! DROP TABLE /*!32200 IF EXISTS*/ pmc_ban_users;
  CREATE TABLE pmc_ban_users (
    username varchar(30) NOT NULL DEFAULT '' ,
***************
*** 10,16 ****
    rooms varchar(100) NOT NULL DEFAULT '' ,
    ban_until int(11) unsigned NOT NULL DEFAULT '0' ,
!   PRIMARY KEY (username),
!   KEY ip (ip),
!   KEY ban_until (ban_until)
  );
  
--- 15,20 ----
    rooms varchar(100) NOT NULL DEFAULT '' ,
    ban_until int(11) unsigned NOT NULL DEFAULT '0' ,
!   PRIMARY KEY (username, ip),
!   INDEX idx1 (ban_until)
  );
  
***************
*** 20,36 ****
  #
  
! DROP TABLE /*!32312 IF EXISTS*/ pmc_messages;
  CREATE TABLE pmc_messages (
-   type tinyint(1) 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' ,
    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)
  );
  
--- 24,40 ----
  #
  
! DROP TABLE /*!32200 IF EXISTS*/ pmc_messages;
  CREATE TABLE pmc_messages (
    room varchar(30) NOT NULL DEFAULT '' ,
    username varchar(30) NOT NULL DEFAULT '' ,
    latin1 tinyint(1) unsigned NOT NULL DEFAULT '0' ,
    m_time int(11) unsigned 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),
!   INDEX idx1 (m_time, room, address, username),
!   INDEX idx2 (m_time, username)
  );
  
***************
*** 40,70 ****
  #
  
! CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_reg_users (
    username varchar(30) NOT NULL DEFAULT '' ,
!   latin1 tinyint(1) unsigned 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 tinyint(1) unsigned NOT NULL DEFAULT '0' ,
-   perms varchar(9) NOT NULL DEFAULT 'user' ,
-   rooms varchar(128) NOT NULL DEFAULT '' ,
    reg_time int(11) unsigned NOT NULL DEFAULT '0' ,
    ip varchar(16) NOT NULL DEFAULT '' ,
    gender tinyint(1) unsigned NOT NULL DEFAULT '0' ,
    PRIMARY KEY (username),
!   KEY reg_time (reg_time),
!   KEY perms (perms)
  );
! INSERT INTO pmc_reg_users VALUES('admin', '', 'admin', '', '', '', '', '', 0, 'admin', '', '', '', '');
  
  
  #
  # Table structure for table 'pmc_sessions'
  #
  
! DROP TABLE /*!32312 IF EXISTS*/ pmc_sessions;
  CREATE TABLE pmc_sessions (
    session_id varchar(32) NOT NULL DEFAULT '' ,
--- 44,102 ----
  #
  
! DROP TABLE /*!32200 IF EXISTS*/ pmc_reg_users;
! 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(64) NOT NULL DEFAULT '' ,
    email varchar(64) NOT NULL DEFAULT '' ,
    showemail tinyint(1) unsigned NOT NULL DEFAULT '0' ,
    reg_time int(11) unsigned NOT NULL DEFAULT '0' ,
    ip varchar(16) NOT NULL DEFAULT '' ,
    gender tinyint(1) unsigned NOT NULL DEFAULT '0' ,
    PRIMARY KEY (username),
!   INDEX idx1 (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 
+ #
+ 
+ DROP TABLE /*!32200 IF EXISTS*/ pmc_rights;
+ CREATE TABLE pmc_rights (
+   username varchar(30) NOT NULL DEFAULT '' ,
+   room varchar(30) NOT NULL DEFAULT '' ,
+   right_level tinyint(2) unsigned NOT NULL DEFAULT '5' ,
+   PRIMARY KEY (username, room),
+   INDEX idx1 (room)
+ );
+ INSERT INTO pmc_rights VALUES('admin', '', 10);
+ 
+ 
+ #
+ # Table structure for table 'pmc_rooms'
+ #
+ 
+ DROP TABLE /*!32200 IF EXISTS*/ pmc_rooms;
+ CREATE TABLE pmc_rooms (
+   room_type tinyint(1) unsigned NOT NULL DEFAULT '1' ,
+   room_name varchar(30) NOT NULL DEFAULT '' ,
+   last_user_modif int(11) unsigned NOT NULL DEFAULT '0' ,
+   PRIMARY KEY (room_name)
+ );
+ 
+ 
+ #
  # Table structure for table 'pmc_sessions'
  #
  
! DROP TABLE /*!32200 IF EXISTS*/ pmc_sessions;
  CREATE TABLE pmc_sessions (
    session_id varchar(32) NOT NULL DEFAULT '' ,
***************
*** 72,77 ****
    last int(11) unsigned NOT NULL DEFAULT '0' ,
    data text ,
!   PRIMARY KEY (session_id),
!   KEY last (last)
  );
  
--- 104,109 ----
    last int(11) unsigned NOT NULL DEFAULT '0' ,
    data text ,
!   PRIMARY KEY (session_id, ip),
!   INDEX idx1 (last)
  );
  
***************
*** 81,85 ****
  #
  
! DROP TABLE /*!32312 IF EXISTS*/ pmc_users;
  CREATE TABLE pmc_users (
    session_id varchar(32) NOT NULL DEFAULT '' ,
--- 113,117 ----
  #
  
! DROP TABLE /*!32200 IF EXISTS*/ pmc_users;
  CREATE TABLE pmc_users (
    session_id varchar(32) NOT NULL DEFAULT '' ,
***************
*** 88,97 ****
    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),
!   PRIMARY KEY (username),
!   KEY room (room),
!   KEY status (status),
!   KEY u_time (u_time)
  );
--- 120,128 ----
    username varchar(30) NOT NULL DEFAULT '' ,
    latin1 tinyint(1) unsigned NOT NULL DEFAULT '0' ,
!   status char(2) NOT NULL DEFAULT '0' ,
    ip varchar(16) NOT NULL DEFAULT '' ,
!   away tinyint(1) unsigned NOT NULL DEFAULT '0' ,
!   PRIMARY KEY (username, room),
!   INDEX idx1 (u_time, status),
!   INDEX idx2 (session_id)
  );