[phpMP-CVS] CVS: phpMP/dba/sql mysql.sql,1.1,1.2

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

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

Modified Files:
	mysql.sql 
Log Message:
Updated MySQL Table Structure.

Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmp/phpMP/dba/sql/mysql.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** mysql.sql	10 Apr 2002 21:28:57 -0000	1.1
--- mysql.sql	11 Apr 2002 06:23:38 -0000	1.2
***************
*** 1,2 ****
--- 1,3 ----
+ Database phpmp running on mysql.sourceforge.net
  # phpMyAdmin MySQL-Dump
  # version 2.2.5
***************
*** 5,9 ****
  #
  # Host: mysql.sourceforge.net
! # Generation Time: Apr 10, 2002 at 02:26 PM
  # Server version: 3.23.36
  # PHP Version: 4.0.6
--- 6,10 ----
  #
  # Host: mysql.sourceforge.net
! # Generation Time: Apr 10, 2002 at 11:19 PM
  # Server version: 3.23.36
  # PHP Version: 4.0.6
***************
*** 29,34 ****
  #
  
- 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');
  # --------------------------------------------------------
  
--- 30,35 ----
  #
  
  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');
  # --------------------------------------------------------
  
***************
*** 73,80 ****
--- 74,103 ----
  #
  
+ INSERT INTO phpmp_modules VALUES ('News', 'news', 1, 'simple_news.php');
  INSERT INTO phpmp_modules VALUES ('User CP', 'usercp', 1, 'usercp.php');
  # --------------------------------------------------------
  
  #
+ # Table structure for table `phpmp_news`
+ #
+ 
+ CREATE TABLE phpmp_news (
+   id int(11) NOT NULL auto_increment,
+   news_db varchar(25) NOT NULL default '',
+   title text NOT NULL,
+   body text NOT NULL,
+   date int(11) NOT NULL default '0',
+   user_id int(11) NOT NULL default '0',
+   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);
+ # --------------------------------------------------------
+ 
+ #
  # Table structure for table `phpmp_sessions`
  #
***************
*** 98,101 ****
--- 121,125 ----
  
  CREATE TABLE phpmp_users (
+   user_id int(11) NOT NULL auto_increment,
    username char(24) NOT NULL default '',
    password char(150) NOT NULL default '',
***************
*** 107,112 ****
    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;
  
--- 131,136 ----
    isadmin tinyint(4) NOT NULL default '0',
    isgod tinyint(4) NOT NULL default '0',
!   PRIMARY KEY  (user_id),
!   KEY username (username)
  ) TYPE=MyISAM;
  
***************
*** 115,117 ****
  #
  
! INSERT INTO phpmp_users VALUES ('Anonymous', '', 'Anonymous', 'anonymous@127.0.0.1', '', '', 20020402174305, 0, 0, '');    
\ No newline at end of file
--- 139,141 ----
  #
  
! INSERT INTO phpmp_users VALUES (1, 'Anonymous', '', 'Anonymous', 'anonymous@127.0.0.1', '', '', 20020402174305, 0, 0);
\ No newline at end of file