bug 7291 follow-up DBRev number

[koha_gimpoz] / installer / data / mysql / patroncards_upgrade.pl

diff --git a/installer/data/mysql/patroncards_upgrade.pl b/installer/data/mysql/patroncards_upgrade.pl
old mode 100644 (file)
new mode 100755 (executable)
index 9306b4d..a9f4ce5
--- a/installer/data/mysql/patroncards_upgrade.pl
+++ b/installer/data/mysql/patroncards_upgrade.pl
@@ -13,9 +13,12 @@
 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
 #
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA  02111-1307 USA
+# You should have received a copy of the GNU General Public License along
+# with Koha; if not, write to the Free Software Foundation, Inc.,
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+
+#use strict;
+#use warnings; FIXME - Bug 2505
 
 use C4::Context;
 
@@ -44,7 +47,7 @@ $sth->do("
       `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
       `branch_code` varchar(10) NOT NULL DEFAULT 'NB',
       `creator` char(15) NOT NULL DEFAULT 'Labels',
-      PRIMARY KEY (`label_id`) USING BTREE,
+      PRIMARY KEY (`label_id`),
       KEY `branch_fk_constraint` (`branch_code`),
       KEY `item_fk_constraint` (`item_number`),
       KEY `borrower_fk_constraint` (`borrower_number`),
@@ -72,7 +75,7 @@ $sth->do("
       `format_string` varchar(210) NOT NULL DEFAULT 'barcode',
       `layout_xml` text NOT NULL,
       `creator` char(15) NOT NULL DEFAULT 'Labels',
-      PRIMARY KEY (`layout_id`) USING BTREE
+      PRIMARY KEY (`layout_id`)
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 ") or die "DB ERROR: " . $sth->errstr . "\n";
 
@@ -110,7 +113,7 @@ CREATE TABLE `creator_images` (
       `image_id` int(4) NOT NULL AUTO_INCREMENT,
       `imagefile` mediumblob,
       `image_name` char(20) NOT NULL DEFAULT 'DEFAULT',
-      PRIMARY KEY (`image_id`) USING BTREE,
+      PRIMARY KEY (`image_id`),
       UNIQUE KEY `image_name_index` (`image_name`)
     ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
 ") or die "DB ERROR: " . $sth->errstr . "\n";
@@ -124,7 +127,7 @@ $sth->do("
 ") or die "DB ERROR: " . $sth->errstr . "\n";
 
 $sth->do("
-    ALTER TABLE printers_profile ADD UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`) USING BTREE;
+    ALTER TABLE printers_profile ADD UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`);
 ") or die "DB ERROR: " . $sth->errstr . "\n";
 
 # Migrate data from existing tables to new tables...