[mxbb-commits] kb_076_mxaddon install_kb_tables.php,1.3,1.4 upgrade_kb_tables.php,1.2,1.3

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

Update of /cvsroot/mxbb/kb_076_mxaddon
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25435/modules/kb_076_mxaddon

Modified Files:
	install_kb_tables.php upgrade_kb_tables.php 
Log Message:
db fix

Index: install_kb_tables.php
===================================================================
RCS file: /cvsroot/mxbb/kb_076_mxaddon/install_kb_tables.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** install_kb_tables.php	29 Mar 2005 21:39:30 -0000	1.3
--- install_kb_tables.php	30 Mar 2005 09:53:30 -0000	1.4
***************
*** 138,142 ****
    						article_description varchar(255) binary NOT NULL default "",
    						article_date varchar(255) binary NOT NULL default "",
!   						article_author_id mediumint(8) unsigned NOT NULL default "0",
  						username VARCHAR(255),
    						bbcode_uid varchar(10) binary NOT NULL default "",
--- 138,142 ----
    						article_description varchar(255) binary NOT NULL default "",
    						article_date varchar(255) binary NOT NULL default "",
!   						article_author_id mediumint(8) NOT NULL,
  						username VARCHAR(255),
    						bbcode_uid varchar(10) binary NOT NULL default "",

Index: upgrade_kb_tables.php
===================================================================
RCS file: /cvsroot/mxbb/kb_076_mxaddon/upgrade_kb_tables.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** upgrade_kb_tables.php	28 Mar 2005 20:54:52 -0000	1.2
--- upgrade_kb_tables.php	30 Mar 2005 09:53:30 -0000	1.3
***************
*** 273,280 ****
  								  customdata_custom int(50) NOT NULL default "0",
  								  data text NOT NULL
! 				) TYPE=MyISAM;';		
! 			
! 			}
  				
  			break;
  		
--- 273,282 ----
  								  customdata_custom int(50) NOT NULL default "0",
  								  data text NOT NULL
! 				) TYPE=MyISAM;';
  				
+ 			}
+ 			
+ 			$sql[] = 'ALTER TABLE ' . KB_ARTICLES_TABLE . ' MODIFY article_author_id mediumint(8) NOT NULL ;';
+ 			
  			break;