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
|
