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

(-)a/installer/data/mysql/atomicupdate/bug_32773.pl (+30 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
3
4
return {
5
    bug_number  => "32773",
6
    description => "Add ability to have more than 1 Fast Add framework",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        if ( !column_exists( 'biblio_framework', 'is_fast_add' ) ) {
12
            $dbh->do(
13
                q{
14
                ALTER TABLE biblio_framework
15
                ADD COLUMN is_fast_add TINYINT(1) NOT NULL DEFAULT 0
16
                AFTER frameworktext;
17
            }
18
            );
19
            say_success( $out, "Added column 'biblio_framework.is_fast_add'" );
20
            $dbh->do(
21
                q{
22
                UPDATE biblio_framework SET is_fast_add = 1 where frameworkcode = 'FA';
23
            }
24
            );
25
            say_success( $out, "Set is_fast_add = 1 for FA framework'" );
26
        } else {
27
            say_info( $out, "Column 'biblio_framework.is_fast_add' already exists!" );
28
        }
29
    },
30
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 1126-1131 DROP TABLE IF EXISTS `biblio_framework`; Link Here
1126
CREATE TABLE `biblio_framework` (
1126
CREATE TABLE `biblio_framework` (
1127
  `frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'the unique code assigned to the framework',
1127
  `frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'the unique code assigned to the framework',
1128
  `frameworktext` varchar(255) NOT NULL DEFAULT '' COMMENT 'the description/name given to the framework',
1128
  `frameworktext` varchar(255) NOT NULL DEFAULT '' COMMENT 'the description/name given to the framework',
1129
  `is_fast_add` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'the ability to be used as a Fast Add framework',
1129
  PRIMARY KEY (`frameworkcode`)
1130
  PRIMARY KEY (`frameworkcode`)
1130
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1131
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1131
/*!40101 SET character_set_client = @saved_cs_client */;
1132
/*!40101 SET character_set_client = @saved_cs_client */;
Lines 6755-6758 CREATE TABLE `zebraqueue` ( Link Here
6755
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6756
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6756
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6757
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6757
6758
6758
-- Dump completed on 2024-11-25 12:13:27
6759
-- Dump completed on 2024-11-25 12:13:27
6759
- 

Return to bug 32773