From: Lo?c C. <lo...@us...> - 2001-04-16 16:44:51
|
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' , |