[phpMP-CVS] CVS: phpMP/dba/sql mysql.sql,1.3,1.4

[Brian R. <hei...@us...>]

Update of /cvsroot/phpmp/phpMP/dba/sql
In directory usw-pr-cvs1:/tmp/cvs-serv5237/dba/sql

Modified Files:
	mysql.sql 
Log Message:
Updated MySQL database structure.  Fixed session cleanup problem (by adding
an extra function that should work fine).

Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmp/phpMP/dba/sql/mysql.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** mysql.sql	11 Apr 2002 06:30:11 -0000	1.3
--- mysql.sql	31 Jul 2002 17:48:38 -0000	1.4
***************
*** 1,2 ****
--- 1,3 ----
+ Database phpmp running on mysql.sourceforge.net
  # phpMyAdmin MySQL-Dump
  # version 2.2.5
***************
*** 5,11 ****
  #
  # Host: mysql.sourceforge.net
! # Generation Time: Apr 10, 2002 at 11:19 PM
  # Server version: 3.23.36
! # PHP Version: 4.0.6
  # Database : `phpmp`
  # --------------------------------------------------------
--- 6,12 ----
  #
  # Host: mysql.sourceforge.net
! # Generation Time: Jul 31, 2002 at 09:09 AM
  # Server version: 3.23.36
! # PHP Version: 4.1.2
  # Database : `phpmp`
  # --------------------------------------------------------
***************
*** 24,34 ****
    KEY side (side)
  ) TYPE=MyISAM;
- 
- #
- # Dumping data for table `phpmp_blocking`
- #
- 
- INSERT INTO phpmp_blocking VALUES ('Main Menu', 'left', 1, '', 1, 'menu_side.php');
- INSERT INTO phpmp_blocking VALUES ('User', 'right', 1, '', 1, 'user_side.php');
  # --------------------------------------------------------
  
--- 25,28 ----
***************
*** 42,58 ****
    value char(255) NOT NULL default ''
  ) TYPE=MyISAM;
- 
- #
- # Dumping data for table `phpmp_config`
- #
- 
- INSERT INTO phpmp_config VALUES ('TPL', 'tpl_name', 'TealMP');
- INSERT INTO phpmp_config VALUES ('GEN', 'address', '');
- INSERT INTO phpmp_config VALUES ('GEN', 'uri', '');
- INSERT INTO phpmp_config VALUES ('GEN', 'version', '0.9 alpha');
- INSERT INTO phpmp_config VALUES ('SES', 'session_length', '3600');
- INSERT INTO phpmp_config VALUES ('SES', 'extcookie', 'phpMPextend');
- INSERT INTO phpmp_config VALUES ('TPL', 'bullet_html', '•');
- INSERT INTO phpmp_config VALUES ('SES', 'normcookie', 'phpMPcookie');
  # --------------------------------------------------------
  
--- 36,39 ----
***************
*** 62,78 ****
  
  CREATE TABLE phpmp_modules (
!   name char(40) NOT NULL default '',
!   unixname char(24) NOT NULL default '',
    active tinyint(1) NOT NULL default '0',
!   filename char(255) NOT NULL default '',
    PRIMARY KEY  (unixname)
  ) TYPE=MyISAM;
- 
- #
- # Dumping data for table `phpmp_modules`
- #
- 
- INSERT INTO phpmp_modules VALUES ('News', 'news', 1, 'simple_news.php');
- INSERT INTO phpmp_modules VALUES ('User CP', 'usercp', 1, 'usercp.php');
  # --------------------------------------------------------
  
--- 43,55 ----
  
  CREATE TABLE phpmp_modules (
!   name varchar(40) NOT NULL default '',
!   unixname varchar(24) NOT NULL default '',
!   mod_id varchar(24) NOT NULL default '',
    active tinyint(1) NOT NULL default '0',
!   filename varchar(255) NOT NULL default '',
!   data text NOT NULL,
!   link varchar(250) NOT NULL default '',
    PRIMARY KEY  (unixname)
  ) TYPE=MyISAM;
  # --------------------------------------------------------
  
***************
*** 90,99 ****
    PRIMARY KEY  (id)
  ) TYPE=MyISAM;
- 
- #
- # Dumping data for table `phpmp_news`
- #
- 
- INSERT INTO phpmp_news VALUES (1, 'index', 'phpMP Simple News Test', 'This is a simple test of the news posting engine here on phpMP.  The news posting engine is a module and can therefore be removed using the Administrative Area.  Please do not remove the file before removing the MPLink.', 1018475688, 0);
  # --------------------------------------------------------
  
--- 67,70 ----
***************
*** 103,116 ****
  
  CREATE TABLE phpmp_sessions (
!   sesskey varchar(24) NOT NULL default '',
!   expiretime int(11) unsigned NOT NULL default '0',
!   username varchar(24) NOT NULL default '',
!   PRIMARY KEY  (sesskey)
  ) TYPE=MyISAM;
- 
- #
- # Dumping data for table `phpmp_sessions`
- #
- 
  # --------------------------------------------------------
  
--- 74,85 ----
  
  CREATE TABLE phpmp_sessions (
!   sesskey varchar(32) NOT NULL default '',
!   user_id tinyint(11) NOT NULL default '0',
!   time_started int(14) NOT NULL default '0',
!   expiretime int(14) NOT NULL default '0',
!   data text NOT NULL,
!   PRIMARY KEY  (sesskey),
!   KEY time_started (time_started)
  ) TYPE=MyISAM;
  # --------------------------------------------------------
  
***************
*** 126,129 ****
--- 95,99 ----
    email char(75) NOT NULL default '',
    location char(75) NOT NULL default '',
+   language char(40) NOT NULL default '',
    usr_tpl char(255) NOT NULL default '',
    joindate timestamp(14) NOT NULL,
***************
*** 132,140 ****
    PRIMARY KEY  (user_id),
    KEY username (username)
! ) TYPE=MyISAM;
! 
! #
! # Dumping data for table `phpmp_users`
! #
! 
! INSERT INTO phpmp_users VALUES (1, 'Anonymous', '', 'Anonymous', 'anonymous@127.0.0.1', '', '', 20020402174305, 0, 0);
\ No newline at end of file
--- 102,104 ----
    PRIMARY KEY  (user_id),
    KEY username (username)
! ) TYPE=MyISAM;
\ No newline at end of file