Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database
In directory usw-pr-cvs1:/tmp/cvs-serv2053/chat/install/database
Modified Files:
pgsql.sql mysql.sql
Log Message:
Increased security: session id must be associated with the same ip to be true.
Index: pgsql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/pgsql.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** pgsql.sql 2001/05/24 15:15:59 1.4
--- pgsql.sql 2001/05/27 15:21:32 1.5
***************
*** 70,73 ****
--- 70,74 ----
CREATE TABLE pmc_sessions (
session_id varchar(32) PRIMARY KEY ,
+ ip varchar(15) NOT NULL DEFAULT '' ,
last int4 NOT NULL DEFAULT '0' ,
data text
Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/mysql.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** mysql.sql 2001/05/24 15:15:59 1.6
--- mysql.sql 2001/05/27 15:21:32 1.7
***************
*** 69,72 ****
--- 69,73 ----
CREATE TABLE pmc_sessions (
session_id varchar(32) NOT NULL DEFAULT '' ,
+ ip varchar(15) NOT NULL DEFAULT '' ,
last int(11) unsigned NOT NULL DEFAULT '0' ,
data text ,
|