phpmychat-cvs-commited

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

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

Added Files:
	mysql.sql 
Log Message:
First drafts for the 0.15 release

--- NEW FILE ---
#
# Table structure for table 'pmc_ban_users'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_ban_users (
  username varchar(30) NOT NULL DEFAULT '' ,
  latin1 tinyint(1) unsigned NOT NULL DEFAULT '0' ,
  ip varchar(16) NOT NULL DEFAULT '' ,
  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)
);


#
# Table structure for table 'pmc_messages'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ 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) ,
  message text NOT NULL DEFAULT '' ,
  KEY type (type),
  KEY m_time (m_time)
);


#
# Table structure for table 'pmc_reg_users'
#

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


#
# Table structure for table 'pmc_sessions'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_sessions (
  session_id varchar(32) NOT NULL DEFAULT '' ,
  last int(11) unsigned NOT NULL DEFAULT '0' ,
  data text ,
  PRIMARY KEY (session_id),
  KEY last (last)
);


#
# Table structure for table 'pmc_users'
#

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