[mxbb-commits] mx_kb db_install.php, 1.38, 1.39 db_uninstall.php, 1.17, 1.18 db_upgrade.php, 1.31, 1.32

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_kb
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv8125/modules/mx_kb

Modified Files:
	db_install.php db_uninstall.php db_upgrade.php 
Log Message:
Updating install schemas etc
Minor fresh install tweaks

Index: db_uninstall.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_uninstall.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** db_uninstall.php	2 May 2006 23:27:19 -0000	1.17
--- db_uninstall.php	27 Jun 2006 18:13:45 -0000	1.18
***************
*** 47,55 ****
  	"DROP TABLE " . $mx_table_prefix . "kb_types ",
  
! 	"DROP TABLE " . $mx_table_prefix . "kb_wordlist ",
  
! 	"DROP TABLE " . $mx_table_prefix . "kb_results ",
  
! 	"DROP TABLE " . $mx_table_prefix . "kb_wordmatch ",
  
  	"DROP TABLE " . $mx_table_prefix . "kb_votes ",
--- 47,55 ----
  	"DROP TABLE " . $mx_table_prefix . "kb_types ",
  
! 	//"DROP TABLE " . $mx_table_prefix . "kb_wordlist ",
  
! 	//"DROP TABLE " . $mx_table_prefix . "kb_results ",
  
! 	//"DROP TABLE " . $mx_table_prefix . "kb_wordmatch ",
  
  	"DROP TABLE " . $mx_table_prefix . "kb_votes ",

Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_install.php,v
retrieving revision 1.38
retrieving revision 1.39
diff -C2 -d -r1.38 -r1.39
*** db_install.php	17 Jun 2006 20:11:23 -0000	1.38
--- db_install.php	27 Jun 2006 18:13:45 -0000	1.39
***************
*** 77,88 ****
    			 	   	    category_id mediumint(8) unsigned NOT NULL auto_increment,
    						category_name VARCHAR(255) binary NOT NULL,
!   						category_details VARCHAR(255) binary NOT NULL,
  						parent mediumint(8) unsigned,
  						cat_order mediumint(8) unsigned NOT NULL,
  
! 						cat_allow_comments tinyint(2) NOT NULL default '1',
  						internal_comments tinyint(2) NOT NULL default '-1',
  						autogenerate_comments tinyint(2) NOT NULL default '-1',
! 						comments_forum_id mediumint(8) NOT NULL DEFAULT '-1',
  
  					    cat_allow_ratings tinyint(2) NOT NULL default '-1',
--- 77,88 ----
    			 	   	    category_id mediumint(8) unsigned NOT NULL auto_increment,
    						category_name VARCHAR(255) binary NOT NULL,
!   						category_details text,
  						parent mediumint(8) unsigned,
  						cat_order mediumint(8) unsigned NOT NULL,
  
! 						cat_allow_comments tinyint(2) NOT NULL default '-1',
  						internal_comments tinyint(2) NOT NULL default '-1',
  						autogenerate_comments tinyint(2) NOT NULL default '-1',
! 						comments_forum_id mediumint(8) NOT NULL default '-1',
  
  					    cat_allow_ratings tinyint(2) NOT NULL default '-1',
***************
*** 91,97 ****
  
  						notify tinyint(2) NOT NULL default '-1',
! 						notify_group mediumint(8) unsigned NOT NULL default '-1',
  
!  						number_articles mediumint(8) NOT NULL,
  						cat_last_article_id mediumint(8) unsigned NOT NULL default '0',
  						cat_last_article_name varchar(255) NOT NULL default '',
--- 91,97 ----
  
  						notify tinyint(2) NOT NULL default '-1',
! 						notify_group mediumint(8) NOT NULL default '-1',
  
!  						number_articles mediumint(8) NOT NULL default '-1',
  						cat_last_article_id mediumint(8) unsigned NOT NULL default '0',
  						cat_last_article_name varchar(255) NOT NULL default '',
***************
*** 121,125 ****
  		)",
  
! 		"INSERT INTO " . $mx_table_prefix . "kb_categories VALUES (1, 'Test Category 1', 'This is a test category', '0', '10', '-1', '-1','-1','-1','-1','-1','-1','-1', '', '0', '', '0', '0', '0', '0', '0', '0', '2', '0', '0', '', '', '', '', '', '', '', '', '0' )",
  
  		"CREATE TABLE " . $mx_table_prefix . "kb_config (
--- 121,125 ----
  		)",
  
! 		"INSERT INTO " . $mx_table_prefix . "kb_categories VALUES (1, 'Test Category', 'Just a test category', '0', '10', '-1', '-1','-1','-1','-1','-1','-1','-1', '-1', '0', '', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0' )",
  
  		"CREATE TABLE " . $mx_table_prefix . "kb_config (
***************
*** 157,162 ****
  		// Appearance
  		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('stats_list', '1')",
! 		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('header_banner', '1')",
! 		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('pagination', '5')",  // art_pagination
  		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('sort_method', 'Alphabetic')", // news_sort
  		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('sort_order', 'ASC')", // news_sort_par
--- 157,162 ----
  		// Appearance
  		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('stats_list', '1')",
! 		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('header_banner', '0')",
! 		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('pagination', '10')",  // art_pagination
  		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('sort_method', 'Alphabetic')", // news_sort
  		"INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('sort_order', 'ASC')", // news_sort_par

Index: db_upgrade.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_upgrade.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -C2 -d -r1.31 -r1.32
*** db_upgrade.php	17 Jun 2006 20:11:23 -0000	1.31
--- db_upgrade.php	27 Jun 2006 18:13:45 -0000	1.32
***************
*** 405,408 ****
--- 405,413 ----
  	{
  		$sql[] = "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('comments_forum_id', '0')";
+ 
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories MODIFY cat_allow_comments tinyint(2) NOT NULL default '-1' ";
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories MODIFY notify_group mediumint(8) NOT NULL default '-1' ";
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories MODIFY number_articles mediumint(8) NOT NULL default '-1' ";
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories MODIFY category_details text ";
  	}
  	else