[mxbb-commits] core/install/schemas mysql_schema_install.sql, 1.46, 1.47

[OryNider <ory...@us...>]

Update of /cvsroot/mxbb/core/install/schemas
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv28359

Modified Files:
	mysql_schema_install.sql 
Log Message:
schema for fresh install fixed.

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.46
retrieving revision 1.47
diff -C2 -d -r1.46 -r1.47
*** mysql_schema_install.sql	15 Sep 2007 21:03:56 -0000	1.46
--- mysql_schema_install.sql	15 Dec 2007 23:57:16 -0000	1.47
***************
*** 402,410 ****
  # Dumping data for table 'mx_table_module'
  #
! INSERT INTO mx_table_module VALUES("10", "Core Blocks", "modules/mx_coreblocks/", "mxBB Portal Core Blocks", "", "mxBB Core Module", "Original mxBB <i>Core Blocks</i> module by <a href=\"http://www.mxbb.net\" target=\"_blank\">The mxBB Development Team</a>");
! INSERT INTO mx_table_module VALUES("20", "Textblocks", "modules/mx_textblocks/", "mxBB Portal Textblocks", "", "mxBB Core Module", "Original mxBB <i>Textblocks</i> module by <a href=\"http://www.mxbb.net\" target=\"_blank\">Jon</a>");
! INSERT INTO mx_table_module VALUES("30", "phpBB2 Blocks", "modules/mx_phpbb2blocks/", "mxBB Portal phpBB2 blocks", "", "mxBB Core Module", "Original mxBB <i>phpBB2 Blocks</i> module by <a href=\"http://www.mxbb.net\" target=\"_blank\"> The mxBB Development Team</a>");
! INSERT INTO mx_table_module VALUES("40", "Navigation Menu", "modules/mx_navmenu/", "mxBB Portal Site Navigation", "", "mxBB Core Module", "Original mxBB <i>Navigation Menu</i> module by <a href=\"http://www.mxbb.net\" target=\"_blank\">Jon</a>");
! INSERT INTO mx_table_module VALUES("50", "Users and Groups", "modules/mx_users/", "Users and Group adminCP", "1", "mxBB Core Module", "Based on original phpBB <i>Admin Tool MODs</i> by Adam Alkins, Omar Ramadan & wGEric :: Adapted for mxBB by <a href=\"http://www.mxbb.net\" target=\"_blank\">Jon</a>");
  
  #
--- 402,410 ----
  # Dumping data for table 'mx_table_module'
  #
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (10, 'Core Blocks', 'modules/mx_coreblocks/', 'mxBB Portal Core Blocks', '', 'mxBB Core Module', 'Original mxBB <i>Core Blocks</i> module by <a href="http://www.mxbb.net" target="_blank">The mxBB Development Team</a>');
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (20, 'Textblocks', 'modules/mx_textblocks/', 'mxBB Portal Textblocks', '', 'mxBB Core Module', 'Original mxBB <i>Textblocks</i> module by <a href="http://www.mxbb.net" target="_blank">Jon</a>');
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (30, 'phpBB2 Blocks', 'modules/mx_phpbb2blocks/', 'mxBB Portal phpBB2 blocks', '', 'mxBB Core Module', 'Original mxBB <i>phpBB2 Blocks</i> module by <a href="http://www.mxbb.net" target="_blank"> The mxBB Development Team</a>');
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (40, 'Users and Groups', 'modules/mx_users/', 'Users and Group adminCP', '1', 'mxBB Core Module', 'Based on original phpBB <i>Admin Tool MODs</i> by Adam Alkins, Omar Ramadan & wGEric :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">Jon</a>');
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (50, 'Navigation Menu', 'modules/mx_navmenu/', 'mxBB Portal Site Navigation', '', 'mxBB Core Module', 'Original mxBB <i>Navigation Menu</i> module by <a href="http://www.mxbb.net" target="_blank">Jon</a>');
  
  #
***************
*** 680,683 ****
--- 680,685 ----
  # Table structure for table 'mx_table_user_group'
  #
+ 
+ DROP TABLE IF EXISTS mx_table_user_group;
  CREATE TABLE mx_table_user_group (
     group_id mediumint(8) DEFAULT '0' NOT NULL,
***************
*** 691,694 ****
--- 693,698 ----
  # Table structure for table 'mx_table_groups'
  #
+ 
+ DROP TABLE IF EXISTS mx_table_groups;
  CREATE TABLE mx_table_groups (
     group_id mediumint(8) NOT NULL auto_increment,
***************
*** 712,715 ****
--- 716,721 ----
  # writing to disk ...
  #
+ 
+ DROP TABLE IF EXISTS mx_table_sessions;
  CREATE TABLE mx_table_sessions (
     session_id char(32) DEFAULT '' NOT NULL,
***************
*** 730,733 ****
--- 736,741 ----
  # Table structure for table `mx_table_sessions_keys`
  #
+ 
+ DROP TABLE IF EXISTS mx_table_sessions_keys;
  CREATE TABLE mx_table_sessions_keys (
    key_id varchar(32) DEFAULT '0' NOT NULL,
***************
*** 743,746 ****
--- 751,756 ----
  # Table structure for table 'mx_table_users'
  #
+ 
+ DROP TABLE IF EXISTS mx_table_users;
  CREATE TABLE mx_table_users (
     user_id mediumint(8) NOT NULL,
***************
*** 814,817 ****
--- 824,829 ----
  # Table structure for table 'mx_table_themes'
  #
+ 
+ DROP TABLE IF EXISTS mx_table_themes;
  CREATE TABLE mx_table_themes (
     themes_id mediumint(8) UNSIGNED NOT NULL auto_increment,
***************
*** 833,836 ****
--- 845,850 ----
  # Table structure for table 'mx_table_smilies'
  #
+ 
+ DROP TABLE IF EXISTS mx_table_smilies;
  CREATE TABLE mx_table_smilies (
     smilies_id smallint(5) UNSIGNED NOT NULL auto_increment,
***************
*** 891,894 ****
--- 905,910 ----
  # Table structure for table 'mx_table_words'
  #
+ 
+ DROP TABLE IF EXISTS mx_table_words;
  CREATE TABLE mx_table_words (
     word_id mediumint(8) UNSIGNED NOT NULL auto_increment,