[mxbb-commits] core/install/schemas mysql_41_schema_install.sql, 1.9, 1.10

[FlorinCB <ory...@us...>]

Update of /cvsroot/mxbb/core/install/schemas
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv24724/install/schemas

Modified Files:
	mysql_41_schema_install.sql 
Log Message:
fix for mx_users module and added a global var

Index: mysql_41_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_41_schema_install.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** mysql_41_schema_install.sql	30 Sep 2008 07:04:46 -0000	1.9
--- mysql_41_schema_install.sql	4 Oct 2008 18:01:29 -0000	1.10
***************
*** 626,653 ****
  #
  DROP TABLE IF EXISTS `mx_table_users`;
! CREATE TABLE `mx_table_users` (
     user_id mediumint(8) NOT NULL,
!    user_active tinyint(1) DEFAULT '1',
!    username varchar(25) NOT NULL,
!    user_password varchar(32) NOT NULL,
!    user_session_time int(11) DEFAULT '0' NOT NULL,
!    user_session_page smallint(5) DEFAULT '0' NOT NULL,
!    user_lastvisit int(11) DEFAULT '0' NOT NULL,
!    user_regdate int(11) DEFAULT '0' NOT NULL,
!    user_level tinyint(4) DEFAULT '0',
!    user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
!    user_last_login_try int(11) DEFAULT '0' NOT NULL,
!    user_email varchar(255),
     PRIMARY KEY (user_id),
     KEY user_session_time (user_session_time)
! ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
  
  
  
  # -- Users
! INSERT INTO `mx_table_users` (user_id, username, user_level, user_regdate, user_password, user_email, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', 0);
  
  # -- username: admin    password: admin (change this or remove it once everything is working!)
! INSERT INTO `mx_table_users` (user_id, username, user_level, user_regdate, user_password, user_email, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'ad...@yo...', 1);
  
  # -- Groups
--- 626,653 ----
  #
  DROP TABLE IF EXISTS `mx_table_users`;
! CREATE TABLE IF NOT EXISTS `mx_table_users` (
     user_id mediumint(8) NOT NULL,
!    user_active tinyint(1) default '1',
!    username varchar(25) collate utf8_bin NOT NULL,
!    user_password varchar(32) collate utf8_bin NOT NULL,
!    user_session_time int(11) NOT NULL default '0',
!    user_session_page smallint(5) NOT NULL default '0',
!    user_lastvisit int(11) NOT NULL default '0',
!    user_regdate int(11) NOT NULL default '0',
!    user_level tinyint(4) default '0',
!    user_login_tries smallint(5) unsigned NOT NULL default '0',
!    user_last_login_try int(11) NOT NULL default '0',
!    user_email varchar(255) collate utf8_bin default NULL,
     PRIMARY KEY (user_id),
     KEY user_session_time (user_session_time)
! ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  
  
  # -- Users
! INSERT INTO `mx_table_users` (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_login_tries, user_last_login_try, user_email) VALUES('-1', '0', 'Anonymous', '', '0', '0', '0', '1221460256', '0', '0', '0', '');
  
  # -- username: admin    password: admin (change this or remove it once everything is working!)
! INSERT INTO `mx_table_users` (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_login_tries, user_last_login_try, user_email) VALUES('2', '1', 'Admin', '21232f297a57a5a743894a0e4a801fc3', '1223142439', '0', '1221524623', '1221460256', '1', '0', '0', 'admin@localhost');
  
  # -- Groups