Bug 31374: (follow-up) change private note to staff_note and reorder columns

[srvgit] / installer / data / mysql / atomicupdate / bug_31374.pl

diff --git a/installer/data/mysql/atomicupdate/bug_31374.pl b/installer/data/mysql/atomicupdate/bug_31374.pl
index 861a71f..80c278e 100755 (executable)
--- a/installer/data/mysql/atomicupdate/bug_31374.pl
+++ b/installer/data/mysql/atomicupdate/bug_31374.pl
@@ -2,19 +2,19 @@ use Modern::Perl;
 
 return {
     bug_number => "31374",
-    description => "Add a non-public note cololumn to the suggestions table",
+    description => "Add a non-public note collumn to the suggestions table",
     up => sub {
         my ($args) = @_;
         my ($dbh, $out) = @$args{qw(dbh out)};
-        if( !column_exists( 'suggestions', 'privatenote' ) ) {
+        if( !column_exists( 'suggestions', 'staff_note' ) ) {
             $dbh->do(q{
                     ALTER TABLE suggestions
-                    ADD COLUMN privatenote longtext NULL DEFAULT NULL
+                    ADD COLUMN staff_note longtext NULL DEFAULT NULL
                     COMMENT "suggestions table non-public note"
                     AFTER note
             });
         }
         # Print useful stuff here
-        say $out "Add privatenote column to suggestions table";
+        say $out "Add staff_note column to suggestions table";
     },
 };