phpmp-commits

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

Update of /cvsroot/phpmp/phpMP/core/dba/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv9778/core/dba/sql

Added Files:
	mysql_default_vals.sql mysql_structure.sql 
Log Message:
This should be fun.

--- NEW FILE: mysql_default_vals.sql ---
# 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`
# --------------------------------------------------------

#
# Dumping data for table `phpmp_config`
#

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');
# --------------------------------------------------------

#
# Dumping data for table `phpmp_users`
#

INSERT INTO `phpmp_users` VALUES (1, 'Anonymous', '', 1, '', '', 0, '', '', '', '');
--- NEW FILE: mysql_structure.sql ---
# 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`
# --------------------------------------------------------

#
# 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=Heap;

#
# 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 ;