Bugzilla – Attachment 38353 Details for
Bug 13790
Add unique id issue_id to issues and old_issues tables
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13790: [QA Follow-up] Relocation of db revision in updatedatabase
Bug-13790-QA-Follow-up-Relocation-of-db-revision-i.patch (text/plain), 2.28 KB, created by
Kyle M Hall (khall)
on 2015-04-22 17:58:59 UTC
(
hide
)
Description:
Bug 13790: [QA Follow-up] Relocation of db revision in updatedatabase
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2015-04-22 17:58:59 UTC
Size:
2.28 KB
patch
obsolete
>From 19e0560c513efe9ad777d55e7c2c300f3fc57f28 Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Mon, 20 Apr 2015 09:11:02 +0200 >Subject: [PATCH] Bug 13790: [QA Follow-up] Relocation of db revision in updatedatabase > >The db rev lines should not be under the bug 13068 sandbox section. > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/updatedatabase.pl | 28 ++++++++++++++-------------- > 1 files changed, 14 insertions(+), 14 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 819f0d2..7c1ee47 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -10146,20 +10146,7 @@ if(CheckVersion($DBversion)) { > SetVersion($DBversion); > } > >-# DEVELOPER PROCESS, search for anything to execute in the db_update directory >-# SEE bug 13068 >-# if there is anything in the atomicupdate, read and execute it. >- >-my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/'; >-opendir( my $dirh, $update_dir ); >-while ( my $file = readdir $dirh ) { >- next unless $file =~ /\.sql$/; # skip non SQL files >- print "DEV atomic update : $file \n"; >- my $installer = C4::Installer->new(); >- my $rv = $installer->load_sql( $update_dir . $file ) ? 0 : 1; >-} >- >-$DBversion = "XXX"; >+$DBversion = "3.19.00.XXX"; > if(CheckVersion($DBversion)) { > $dbh->do(q{ > ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST >@@ -10183,7 +10170,20 @@ if(CheckVersion($DBversion)) { > > print "Upgrade to $DBversion done (Bug 13790 - Add unique id issue_id to issues and oldissues tables)\n"; > SetVersion($DBversion); >+} >+ > >+# DEVELOPER PROCESS, search for anything to execute in the db_update directory >+# SEE bug 13068 >+# if there is anything in the atomicupdate, read and execute it. >+ >+my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/'; >+opendir( my $dirh, $update_dir ); >+while ( my $file = readdir $dirh ) { >+ next unless $file =~ /\.sql$/; # skip non SQL files >+ print "DEV atomic update : $file \n"; >+ my $installer = C4::Installer->new(); >+ my $rv = $installer->load_sql( $update_dir . $file ) ? 0 : 1; > } > > =head1 FUNCTIONS >-- >1.7.2.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 13790
:
36441
|
36442
|
37108
|
37109
|
37709
|
37710
|
38073
|
38081
|
38082
|
38155
|
38156
|
38157
|
38158
|
38182
|
38184
|
38349
|
38350
|
38351
|
38352
| 38353 |
38354
|
38429