[mxbb-commits] mx_radiocast db_install.php, 1.7, 1.8 db_upgrade.php, 1.6, 1.7

[Florin C B. <ory...@us...>]

Update of /cvsroot/mxbb/mx_radiocast
In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv12118

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


Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_radiocast/db_install.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** db_install.php	11 Jul 2009 02:55:44 -0000	1.7
--- db_install.php	17 Jun 2013 16:11:28 -0000	1.8
***************
*** 55,80 ****
  
  	$sql[] = "CREATE TABLE ". $mx_table_prefix . "radiocast (
! 		station_id int(11) UNSIGNED NOT NULL auto_increment,
! 		station_filename varchar(255) NOT NULL,
! 		station_filetype varchar(255) NOT NULL,
! 		station_imagename varchar(255) NOT NULL,
! 		station_title varchar(255) NOT NULL,
! 		station_url varchar(255) NOT NULL,
! 		station_desc text,
! 		station_singer varchar(255) NOT NULL,
! 		station_user_id mediumint(8) NOT NULL,
! 		station_username varchar(32),
! 		station_user_ip char(8) NOT NULL DEFAULT '0',
! 		station_time int(11) UNSIGNED NOT NULL,
! 		station_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1',
! 		station_view_count int(11) UNSIGNED NOT NULL DEFAULT '0',
! 		station_lock tinyint(3) NOT NULL DEFAULT '0',
! 		station_approval tinyint(3) NOT NULL DEFAULT '1',
! 		station_download_count varchar(255) NOT NULL,
! 		PRIMARY KEY (station_id),
! 		KEY station_cat_id (station_cat_id),
! 		KEY station_user_id (station_user_id),
! 		KEY station_time (station_time)
! 		) TYPE=MyISAM";
  
  	$sql[] = "CREATE TABLE ". $mx_table_prefix . "radiocast_rate (
--- 55,82 ----
  
  	$sql[] = "CREATE TABLE ". $mx_table_prefix . "radiocast (
! 	  station_id int(11) unsigned NOT NULL AUTO_INCREMENT,
! 	  station_filename varchar(255) COLLATE utf8_bin DEFAULT NULL,
! 	  station_filetype varchar(255) COLLATE utf8_bin DEFAULT NULL,
! 	  station_mimetype varchar(255) COLLATE utf8_bin DEFAULT NULL,
! 	  station_imagename varchar(255) COLLATE utf8_bin DEFAULT NULL,
! 	  station_logofile varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'no_image.png',
! 	  station_title varchar(255) COLLATE utf8_bin DEFAULT NULL,
! 	  station_url varchar(255) COLLATE utf8_bin DEFAULT NULL,
! 	  station_desc text COLLATE utf8_bin,
! 	  station_singer varchar(255) COLLATE utf8_bin DEFAULT NULL,
! 	  station_user_id mediumint(8) NOT NULL,
! 	  station_username varchar(32) COLLATE utf8_bin DEFAULT NULL,
! 	  station_user_ip char(8) COLLATE utf8_bin DEFAULT NULL,
! 	  station_time int(11) unsigned NOT NULL,
! 	  station_cat_id mediumint(8) unsigned NOT NULL DEFAULT '1',
! 	  station_view_count int(11) unsigned NOT NULL DEFAULT '0',
! 	  station_lock tinyint(3) NOT NULL DEFAULT '0',
! 	  station_approval tinyint(3) NOT NULL DEFAULT '1',
! 	  station_download_count varchar(255) COLLATE utf8_bin DEFAULT NULL,
! 	  PRIMARY KEY (station_id),
! 	  KEY station_cat_id (station_cat_id),
! 	  KEY station_user_id (station_user_id),
! 	  KEY station_time (station_time)
! 	  ) ENGINE=MyISAM";	
  
  	$sql[] = "CREATE TABLE ". $mx_table_prefix . "radiocast_rate (

Index: db_upgrade.php
===================================================================
RCS file: /cvsroot/mxbb/mx_radiocast/db_upgrade.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** db_upgrade.php	11 Jul 2009 02:55:44 -0000	1.6
--- db_upgrade.php	17 Jun 2013 16:11:28 -0000	1.7
***************
*** 91,94 ****
--- 91,96 ----
  
  		$sql[] = "ALTER TABLE " . $mx_table_prefix . "radiocast ADD station_filetype varchar(255) NOT NULL AFTER station_filename";
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "radiocast ADD station_logofile varchar(255) NOT NULL AFTER station_imagename"
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "radiocast ADD station_mimetype varchar(255) NOT NULL AFTER station_filetype";		
  	}
  	else