Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database
In directory usw-pr-cvs1:/tmp/cvs-serv21588/chat/install/database
Modified Files:
mysql.sql
Log Message:
Add the admin default record (log and password are 'admin' and 'admin')
Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/mysql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** mysql.sql 2001/04/03 20:14:52 1.2
--- mysql.sql 2001/04/16 16:44:47 1.3
***************
*** 3,7 ****
#
! CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_ban_users (
username varchar(30) NOT NULL DEFAULT '' ,
latin1 tinyint(1) unsigned NOT NULL DEFAULT '0' ,
--- 3,8 ----
#
! DROP TABLE /*!32312 IF EXISTS*/ pmc_ban_users;
! CREATE TABLE pmc_ban_users (
username varchar(30) NOT NULL DEFAULT '' ,
latin1 tinyint(1) unsigned NOT NULL DEFAULT '0' ,
***************
*** 19,23 ****
#
! CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_messages (
type tinyint(1) unsigned NOT NULL DEFAULT '0' ,
room varchar(30) NOT NULL DEFAULT '' ,
--- 20,25 ----
#
! 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 '' ,
***************
*** 57,60 ****
--- 59,63 ----
KEY perms (perms)
);
+ INSERT INTO c_reg_users VALUES('admin', '', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', '', '', '');
***************
*** 63,67 ****
#
! CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_sessions (
session_id varchar(32) NOT NULL DEFAULT '' ,
last int(11) unsigned NOT NULL DEFAULT '0' ,
--- 66,71 ----
#
! DROP TABLE /*!32312 IF EXISTS*/ pmc_sessions;
! CREATE TABLE pmc_sessions (
session_id varchar(32) NOT NULL DEFAULT '' ,
last int(11) unsigned NOT NULL DEFAULT '0' ,
***************
*** 76,80 ****
#
! CREATE TABLE /*!32312 IF NOT EXISTS*/ pmc_users (
session_id varchar(32) NOT NULL DEFAULT '' ,
u_time int(11) unsigned NOT NULL DEFAULT '0' ,
--- 80,85 ----
#
! DROP TABLE /*!32312 IF EXISTS*/ pmc_users;
! CREATE TABLE pmc_users (
session_id varchar(32) NOT NULL DEFAULT '' ,
u_time int(11) unsigned NOT NULL DEFAULT '0' ,
|