[mxbb-commits] mx_smartor db_install.php, 1.31, 1.32 db_upgrade.php, 1.28, 1.29

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

Update of /cvsroot/mxbb/mx_smartor
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15524/mx_smartor

Modified Files:
	db_install.php db_upgrade.php 
Log Message:
update

Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_smartor/db_install.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -C2 -d -r1.31 -r1.32
*** db_install.php	8 Jan 2009 21:18:15 -0000	1.31
--- db_install.php	29 Jul 2009 05:08:13 -0000	1.32
***************
*** 205,210 ****
  		pic_filename varchar(255) NOT NULL,
  		pic_thumbnail varchar(255),
! 		pic_title varchar(255) NOT NULL,
! 		pic_desc text,
  		pic_user_id mediumint(8) NOT NULL,
  		pic_username varchar(32),
--- 205,210 ----
  		pic_filename varchar(255) NOT NULL,
  		pic_thumbnail varchar(255),
! 		pic_title mediumtext,
! 		pic_desc mediumtext,
  		pic_user_id mediumint(8) NOT NULL,
  		pic_username varchar(32),

Index: db_upgrade.php
===================================================================
RCS file: /cvsroot/mxbb/mx_smartor/db_upgrade.php,v
retrieving revision 1.28
retrieving revision 1.29
diff -C2 -d -r1.28 -r1.29
*** db_upgrade.php	8 Jan 2009 21:18:15 -0000	1.28
--- db_upgrade.php	29 Jul 2009 05:08:13 -0000	1.29
***************
*** 150,154 ****
  		$message .= "<b>Upgrading to v. 2.00 Beta 2...</b><br/><br/>";
  		$sql[] = "UPDATE ". $mx_table_prefix ."smartor_album_config
! 			SET config_value = '1.4.1'
  			WHERE config_name = 'fap_version'";
  		$sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('invert_nav_arrows', '0')";
--- 150,154 ----
  		$message .= "<b>Upgrading to v. 2.00 Beta 2...</b><br/><br/>";
  		$sql[] = "UPDATE ". $mx_table_prefix ."smartor_album_config
! 			SET config_value = '1.4.2'
  			WHERE config_name = 'fap_version'";
  		$sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('invert_nav_arrows', '0')";
***************
*** 156,159 ****
--- 156,162 ----
  		$sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_all_pics_link', '1')";
  		$sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_personal_galleries_link', '1')";
+ 		$sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album ADD comment_cat_id int(11) NOT NULL default '0' AFTER comment_pic_id";		
+ 		$sql[] = "ALTER TABLE ".$mx_table_prefix . "smartor_album MODIFY pic_title mediumtext";
+ 		$sql[] = "ALTER TABLE ".$mx_table_prefix . "smartor_album MODIFY pic_desc mediumtext";		
  		$sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_comment ADD comment_cat_id int(11) NOT NULL default '0' AFTER comment_pic_id";
  	}