[phpMP-CVS] CVS: phpMP/dba/sql mysql_default_vals.sql,1.6,1.7 mysql_structure.sql,1.2,1.3
Status: Pre-Alpha
Brought to you by:
heimidal
Menu
▾
▴
[phpMP-CVS] CVS: phpMP/dba/sql mysql_default_vals.sql,1.6,1.7 mysql_structure.sql,1.2,1.3
|
From: Brian R. <hei...@us...> - 2003-04-23 07:21:06
|
Update of /cvsroot/phpmp/phpMP/dba/sql In directory sc8-pr-cvs1:/tmp/cvs-serv4022/dba/sql Modified Files: mysql_default_vals.sql mysql_structure.sql Log Message: Literally, TONS of changes. The most significant include a session system that finally works (!) as well as a change in the way config values are assigned - all config settings are now housed in an associative array called "$Config", which must be globalized before use. Index: mysql_default_vals.sql =================================================================== RCS file: /cvsroot/phpmp/phpMP/dba/sql/mysql_default_vals.sql,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -r1.6 -r1.7 *** mysql_default_vals.sql 4 Feb 2003 21:43:14 -0000 1.6 --- mysql_default_vals.sql 23 Apr 2003 07:21:02 -0000 1.7 *************** *** 1,11 **** # phpMyAdmin MySQL-Dump ! # version 2.3.2 # http://www.phpmyadmin.net/ (download page) # # Host: localhost ! # Generation Time: Dec 03, 2002 at 05:32 AM ! # Server version: 3.23.53 ! # PHP Version: 4.2.3 # Database : `phpmp` # --- 1,12 ---- # phpMyAdmin MySQL-Dump ! # version 2.5.0-rc1 # http://www.phpmyadmin.net/ (download page) # # Host: localhost ! # Generation Time: Apr 23, 2003 at 01:14 AM ! # Server version: 4.0.12 ! # PHP Version: 4.3.0 # Database : `phpmp` + # -------------------------------------------------------- # *************** *** 13,27 **** # ! INSERT INTO phpmp_config VALUES ('site_addr', 'http://localhost'); ! INSERT INTO phpmp_config VALUES ('rel_path', '/'); ! INSERT INTO phpmp_config VALUES ('default_tpl', 'TealMP'); ! INSERT INTO phpmp_config VALUES ('override_usr_tpl', '0'); ! INSERT INTO phpmp_config VALUES ('site_name', 'phpMP'); ! INSERT INTO phpmp_config VALUES ('default_lang', 'english'); ! INSERT INTO phpmp_config VALUES ('default_date_format', 'M j, Y h:ia T'); ! INSERT INTO phpmp_config VALUES ('enable_account_activation', '0'); ! INSERT INTO phpmp_config VALUES ('system_timezone', '-7'); ! INSERT INTO phpmp_config VALUES ('version', '0.1a'); ! INSERT INTO phpmp_config VALUES ('use_portal_perms', '0'); # --- 14,33 ---- # ! INSERT INTO `phpmp_config` VALUES ('site_domain', 'http://localhost'); ! INSERT INTO `phpmp_config` VALUES ('rel_path', '/phpMP/'); ! INSERT INTO `phpmp_config` VALUES ('default_tpl', ''); ! INSERT INTO `phpmp_config` VALUES ('override_usr_tpl', '0'); ! INSERT INTO `phpmp_config` VALUES ('site_name', 'phpMP'); ! INSERT INTO `phpmp_config` VALUES ('default_lang', 'english'); ! INSERT INTO `phpmp_config` VALUES ('default_date_format', 'M j, Y h:ia T'); ! INSERT INTO `phpmp_config` VALUES ('enable_account_activation', '0'); ! INSERT INTO `phpmp_config` VALUES ('system_timezone', '-5'); ! INSERT INTO `phpmp_config` VALUES ('version', '0.1a'); ! INSERT INTO `phpmp_config` VALUES ('cookie_name', 'phpmp_cookie'); ! INSERT INTO `phpmp_config` VALUES ('cookie_domain', ''); ! INSERT INTO `phpmp_config` VALUES ('cookie_path', ''); ! INSERT INTO `phpmp_config` VALUES ('cookie_secure', '0'); ! INSERT INTO `phpmp_config` VALUES ('session_length', '3600'); ! # -------------------------------------------------------- # *************** *** 29,31 **** # ! INSERT INTO phpmp_users VALUES (1, 'Anonymous', '', 1, '', '', 0, '', '', ''); --- 35,37 ---- # ! INSERT INTO `phpmp_users` VALUES (1, 'Anonymous', '', 1, '', '', 0, '', '', '', ''); \ No newline at end of file Index: mysql_structure.sql =================================================================== RCS file: /cvsroot/phpmp/phpMP/dba/sql/mysql_structure.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -r1.2 -r1.3 *** mysql_structure.sql 3 Dec 2002 12:35:56 -0000 1.2 --- mysql_structure.sql 23 Apr 2003 07:21:03 -0000 1.3 *************** *** 1,10 **** # phpMyAdmin MySQL-Dump ! # version 2.3.2 # http://www.phpmyadmin.net/ (download page) # # Host: localhost ! # Generation Time: Dec 03, 2002 at 05:30 AM ! # Server version: 3.23.53 ! # PHP Version: 4.2.3 # Database : `phpmp` # -------------------------------------------------------- --- 1,10 ---- # phpMyAdmin MySQL-Dump ! # version 2.5.0-rc1 # http://www.phpmyadmin.net/ (download page) # # Host: localhost ! # Generation Time: Apr 23, 2003 at 01:14 AM ! # Server version: 4.0.12 ! # PHP Version: 4.3.0 # Database : `phpmp` # -------------------------------------------------------- *************** *** 13,39 **** # Table structure for table `phpmp_config` # ! CREATE TABLE phpmp_config ( ! config_key varchar(255) NOT NULL default '', ! config_value varchar(255) NOT NULL default '', ! PRIMARY KEY (config_key) ) TYPE=MyISAM; - # -------------------------------------------------------- # # Table structure for table `phpmp_users` # ! CREATE TABLE phpmp_users ( ! userid mediumint(8) NOT NULL auto_increment, ! username varchar(24) NOT NULL default '', ! passwd varchar(32) NOT NULL default '', ! active tinyint(1) NOT NULL default '0', ! email varchar(255) NOT NULL default '', ! actkey varchar(32) NOT NULL default '', ! auth_level tinyint(1) NOT NULL default '0', ! date_format varchar(32) NOT NULL default '', ! template varchar(32) NOT NULL default '', ! signature varchar(255) NOT NULL default '', ! PRIMARY KEY (userid) ! ) TYPE=MyISAM; \ No newline at end of file --- 13,62 ---- # Table structure for table `phpmp_config` # + # Creation: Apr 22, 2003 at 08:46 AM + # Last update: Apr 22, 2003 at 11:54 PM + # ! CREATE TABLE `phpmp_config` ( ! `config_key` varchar(255) NOT NULL default '', ! `config_value` varchar(255) NOT NULL default '', ! PRIMARY KEY (`config_key`) ! ) TYPE=MyISAM; ! ! # ! # Table structure for table `phpmp_sessions` ! # ! # Creation: Apr 22, 2003 at 05:34 PM ! # Last update: Apr 23, 2003 at 01:11 AM ! # ! ! CREATE TABLE `phpmp_sessions` ( ! `session_key` varchar(32) NOT NULL default '', ! `session_user_id` mediumint(8) NOT NULL default '0', ! `session_start_time` int(10) NOT NULL default '0', ! `session_exp_time` int(10) NOT NULL default '0', ! `session_page` varchar(50) NOT NULL default '', ! `session_ip` varchar(8) NOT NULL default '', ! PRIMARY KEY (`session_key`) ) TYPE=MyISAM; # # Table structure for table `phpmp_users` # + # Creation: Apr 23, 2003 at 12:34 AM + # Last update: Apr 23, 2003 at 12:37 AM + # ! CREATE TABLE `phpmp_users` ( ! `user_id` mediumint(8) NOT NULL auto_increment, ! `user_name` varchar(24) NOT NULL default '', ! `user_passwd` varchar(32) NOT NULL default '', ! `active` tinyint(1) NOT NULL default '0', ! `email` varchar(255) NOT NULL default '', ! `actkey` varchar(32) NOT NULL default '', ! `auth_level` tinyint(1) NOT NULL default '0', ! `language` varchar(32) NOT NULL default '', ! `date_format` varchar(32) NOT NULL default '', ! `template` varchar(32) NOT NULL default '', ! `signature` varchar(255) NOT NULL default '', ! PRIMARY KEY (`user_id`) ! ) TYPE=MyISAM AUTO_INCREMENT=3 ; \ No newline at end of file |
