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-serv21772/chat/install/database

Added Files:
	pgsql.sql 
Log Message:
A theorical dump....

--- NEW FILE ---
#
# Please note that this model is a bit theorical: we don't test it yet.
# If you face some problems with it or have some suggestions to improve it
# please send us an e-mail.
#

#
# Table structure for table 'pmc_ban_users'
#

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


#
# Table structure for table 'pmc_messages'
#

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 '' ,
  KEY type (type),
  KEY m_time (m_time)
);


#
# Table structure for table 'pmc_reg_users'
#

CREATE TABLE pmc_reg_users (
  username varchar(30) NOT NULL DEFAULT '' ,
  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' ,
  PRIMARY KEY (username),
  KEY reg_time (reg_time),
  KEY perms (perms)
);
INSERT INTO c_reg_users VALUES('admin', '', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', '', '', '');


#
# Table structure for table 'pmc_sessions'
#

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


#
# Table structure for table 'pmc_users'
#

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