phpmp-commits

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

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

Added Files:
	mysql.sql 
Log Message:
Added MySQL table structure and default data.

--- NEW FILE: mysql.sql ---
# phpMyAdmin MySQL-Dump
# version 2.2.5
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: mysql.sourceforge.net
# Generation Time: Apr 10, 2002 at 02:26 PM
# Server version: 3.23.36
# PHP Version: 4.0.6
# Database : `phpmp`
# --------------------------------------------------------

#
# Table structure for table `phpmp_blocking`
#

CREATE TABLE phpmp_blocking (
  blockname varchar(40) NOT NULL default '',
  side varchar(5) default NULL,
  weight smallint(3) default NULL,
  content text NOT NULL,
  is_php tinyint(4) NOT NULL default '0',
  php_file varchar(255) NOT NULL default '',
  KEY side (side)
) TYPE=MyISAM;

#
# Dumping data for table `phpmp_blocking`
#

INSERT INTO phpmp_blocking VALUES ('Welcome', 'right', 1, '', 1, 'user_side.php');
INSERT INTO phpmp_blocking VALUES ('Main Menu', 'left', 1, '', 1, 'menu_side.php');
# --------------------------------------------------------

#
# Table structure for table `phpmp_config`
#

CREATE TABLE phpmp_config (
  type char(5) NOT NULL default '',
  name char(255) NOT NULL default '',
  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');
# --------------------------------------------------------

#
# Table structure for table `phpmp_modules`
#

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 ('User CP', 'usercp', 1, 'usercp.php');
# --------------------------------------------------------

#
# Table structure for table `phpmp_sessions`
#

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

# --------------------------------------------------------

#
# Table structure for table `phpmp_users`
#

CREATE TABLE phpmp_users (
  username char(24) NOT NULL default '',
  password char(150) NOT NULL default '',
  realname char(75) NOT NULL default '',
  email char(75) NOT NULL default '',
  location char(75) NOT NULL default '',
  usr_tpl char(255) NOT NULL default '',
  joindate timestamp(14) NOT NULL,
  isadmin tinyint(4) NOT NULL default '0',
  isgod tinyint(4) NOT NULL default '0',
  privs char(255) NOT NULL default '',
  PRIMARY KEY  (username)
) TYPE=MyISAM;

#
# Dumping data for table `phpmp_users`
#

INSERT INTO phpmp_users VALUES ('Anonymous', '', 'Anonymous', 'anonymous@127.0.0.1', '', '', 20020402174305, 0, 0, '');