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
|
