|
From: Lo?c C. <lo...@us...> - 2001-06-10 14:58:20
|
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)
);
|