View | Details | Raw Unified | Return to bug 39838
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_39838.pl (+25 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_success say_info);
3
4
return {
5
    bug_number  => "39838",
6
    description => "Rename alias_id -> vendor_alias_id",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        if ( TableExists('aqbookseller_aliases') ) {
12
            if ( column_exists( 'aqbookseller_aliases', 'alias_id' ) ) {
13
                $dbh->do(
14
                    q{
15
                        ALTER TABLE aqbookseller_aliases RENAME COLUMN alias_id TO vendor_alias_id;
16
                    }
17
                );
18
                say_success(
19
                    $out,
20
                    q{Column 'aqbookseller_aliases.alias_id' renamed to 'aqbookseller_aliases.vendor_alias_id'}
21
                );
22
            }
23
        }
24
    },
25
};
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 418-427 DROP TABLE IF EXISTS `aqbookseller_aliases`; Link Here
418
/*!40101 SET @saved_cs_client     = @@character_set_client */;
418
/*!40101 SET @saved_cs_client     = @@character_set_client */;
419
/*!40101 SET character_set_client = utf8mb4 */;
419
/*!40101 SET character_set_client = utf8mb4 */;
420
CREATE TABLE `aqbookseller_aliases` (
420
CREATE TABLE `aqbookseller_aliases` (
421
  `alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha',
421
  `vendor_alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha',
422
  `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor',
422
  `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor',
423
  `alias` varchar(255) NOT NULL COMMENT 'the alias',
423
  `alias` varchar(255) NOT NULL COMMENT 'the alias',
424
  PRIMARY KEY (`alias_id`),
424
  PRIMARY KEY (`vendor_alias_id`),
425
  KEY `aqbookseller_aliases_ibfk_1` (`vendor_id`),
425
  KEY `aqbookseller_aliases_ibfk_1` (`vendor_id`),
426
  CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
426
  CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
427
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
427
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
428
- 

Return to bug 39838