phpmp-commits

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

Update of /cvsroot/phpmp/phpMP/docs/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv28190/docs/sql

Modified Files:
	mysql_structure.sql 
Log Message:
Updated current Database structure.

Index: mysql_structure.sql
===================================================================
RCS file: /cvsroot/phpmp/phpMP/docs/sql/mysql_structure.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** mysql_structure.sql	14 Sep 2003 06:52:26 -0000	1.1
--- mysql_structure.sql	15 Sep 2003 02:44:12 -0000	1.2
***************
*** 1,11 ****
! # 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`
  # --------------------------------------------------------
  
--- 1,14 ----
! # phpMyAdmin SQL Dump
! # version 2.5.3-rc2
! # http://www.phpmyadmin.net
  #
  # Host: localhost
! # Generation Time: Sep 14, 2003 at 08:46 PM
! # Server version: 4.0.14
! # PHP Version: 4.3.2
! # 
  # Database : `phpmp`
+ # 
+ 
  # --------------------------------------------------------
  
***************
*** 13,19 ****
  # 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` (
--- 16,19 ----
***************
*** 23,31 ****
  ) 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
  #
  
--- 23,93 ----
  ) TYPE=MyISAM;
  
+ # --------------------------------------------------------
+ 
  #
! # Table structure for table `phpmp_groups`
! #
! 
! CREATE TABLE `phpmp_groups` (
!   `group_id` int(11) NOT NULL auto_increment,
!   `group_name` varchar(255) NOT NULL default '',
!   PRIMARY KEY  (`group_id`)
! ) TYPE=MyISAM;
! 
! # --------------------------------------------------------
! 
  #
! # Table structure for table `phpmp_modules`
! #
! 
! CREATE TABLE `phpmp_modules` (
!   `module_id` int(11) NOT NULL auto_increment,
!   `module_name` varchar(40) NOT NULL default '',
!   PRIMARY KEY  (`module_id`)
! ) TYPE=MyISAM;
! 
! # --------------------------------------------------------
! 
! #
! # Table structure for table `phpmp_modules_data`
! #
! 
! CREATE TABLE `phpmp_modules_data` (
!   `module_id` int(11) NOT NULL default '0',
!   `data_description` varchar(40) NOT NULL default '',
!   `data_contents` varchar(255) NOT NULL default '',
!   PRIMARY KEY  (`module_id`)
! ) TYPE=MyISAM;
! 
! # --------------------------------------------------------
! 
! #
! # Table structure for table `phpmp_profile_fields`
! #
! 
! CREATE TABLE `phpmp_profile_fields` (
!   `profile_field_id` int(11) NOT NULL auto_increment,
!   `profile_field_name` varchar(40) NOT NULL default '',
!   PRIMARY KEY  (`profile_field_id`)
! ) TYPE=MyISAM;
! 
! # --------------------------------------------------------
! 
! #
! # Table structure for table `phpmp_profile_fields_data`
! #
! 
! CREATE TABLE `phpmp_profile_fields_data` (
!   `user_id` int(11) NOT NULL default '0',
!   `profile_field_id` int(11) NOT NULL default '0',
!   `profile_field_data` varchar(255) NOT NULL default '',
!   PRIMARY KEY  (`user_id`),
!   KEY `profile_field_id` (`profile_field_id`)
! ) TYPE=MyISAM;
! 
! # --------------------------------------------------------
! 
! #
! # Table structure for table `phpmp_sessions`
  #
  
***************
*** 38,54 ****
    `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 '',
--- 100,115 ----
    `session_ip` varchar(8) NOT NULL default '',
    PRIMARY KEY  (`session_key`)
! ) TYPE=HEAP;
! 
! # --------------------------------------------------------
  
  #
  # Table structure for table `phpmp_users`
  #
  
  CREATE TABLE `phpmp_users` (
    `user_id` mediumint(8) NOT NULL auto_increment,
    `user_name` varchar(24) NOT NULL default '',
!   `password` varchar(32) NOT NULL default '',
    `active` tinyint(1) NOT NULL default '0',
    `email` varchar(255) NOT NULL default '',
***************
*** 58,62 ****
    `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
--- 119,122 ----
    `date_format` varchar(32) NOT NULL default '',
    `template` varchar(32) NOT NULL default '',
    PRIMARY KEY  (`user_id`)
! ) TYPE=MyISAM;
\ No newline at end of file