[LON-CAPA-cvs] cvs: loncom /interface lonmysql.pm /metadata_database configure_mysql_db.pl /metadata_database/LONCAPA lonmetadata.pm

[raeburn]

raeburn		Tue May 31 02:40:08 2011 EDT

  Modified files:              
    /loncom/interface	lonmysql.pm 
    /loncom/metadata_database/LONCAPA	lonmetadata.pm 
    /loncom/metadata_database	configure_mysql_db.pl 
  Log:
  - TYPE=MYISAM was replaced with ENGINE=MYISAM in MySQL 4.
  - TYPE was deprecated in 4 and 5.0/5.1.  It is no longer supported in 5.5.
  
  
Index: loncom/interface/lonmysql.pm
diff -u loncom/interface/lonmysql.pm:1.38 loncom/interface/lonmysql.pm:1.39
--- loncom/interface/lonmysql.pm:1.38	Sun Feb  1 22:03:42 2009
+++ loncom/interface/lonmysql.pm	Tue May 31 02:40:02 2011
@@ -1,7 +1,7 @@
 # The LearningOnline Network with CAPA
 # MySQL utility functions
 #
-# $Id: lonmysql.pm,v 1.38 2009/02/01 22:03:42 lueken Exp $
+# $Id: lonmysql.pm,v 1.39 2011/05/31 02:40:02 raeburn Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -817,7 +817,7 @@
     unless($table_des->{'permanent'} eq 'yes') {
         $request.="COMMENT = 'temporary' ";
     } 
-    $request .= "TYPE=MYISAM";
+    $request .= "ENGINE=MYISAM";
     return $request,$table_id;
 }
 
Index: loncom/metadata_database/LONCAPA/lonmetadata.pm
diff -u loncom/metadata_database/LONCAPA/lonmetadata.pm:1.31 loncom/metadata_database/LONCAPA/lonmetadata.pm:1.32
--- loncom/metadata_database/LONCAPA/lonmetadata.pm:1.31	Sun May 29 19:10:10 2011
+++ loncom/metadata_database/LONCAPA/lonmetadata.pm	Tue May 31 02:40:05 2011
@@ -1,6 +1,6 @@
 # The LearningOnline Network with CAPA
 #
-# $Id: lonmetadata.pm,v 1.31 2011/05/29 19:10:10 raeburn Exp $
+# $Id: lonmetadata.pm,v 1.32 2011/05/31 02:40:05 raeburn Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -93,7 +93,7 @@
 FULLTEXT idx_owner (owner), 
 FULLTEXT idx_copyright (copyright)) 
 
-TYPE=MYISAM;
+ENGINE=MYISAM;
 
 =cut
 
Index: loncom/metadata_database/configure_mysql_db.pl
diff -u loncom/metadata_database/configure_mysql_db.pl:1.3 loncom/metadata_database/configure_mysql_db.pl:1.4
--- loncom/metadata_database/configure_mysql_db.pl:1.3	Fri Aug 22 22:30:50 2003
+++ loncom/metadata_database/configure_mysql_db.pl	Tue May 31 02:40:08 2011
@@ -2,7 +2,7 @@
 # The LearningOnline Network 
 # Red Hat 7.3 installation script
 #
-# $Id: configure_mysql_db.pl,v 1.3 2003/08/22 22:30:50 albertel Exp $
+# $Id: configure_mysql_db.pl,v 1.4 2011/05/31 02:40:08 raeburn Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -163,7 +163,7 @@
                                      FULLTEXT idx_language (language), 
                                      FULLTEXT idx_owner (owner), 
                                      FULLTEXT idx_copyright (copyright)
-                                     ) TYPE=MYISAM
+                                     ) ENGINE=MYISAM
 ENDDBINIT
 
 $dbh->do(<<ENDDBINIT);