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

(-)a/installer/data/mysql/atomicupdate/bug_24156.perl (+18 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    unless ( TableExists( 'tables_settings' ) ) {
4
        $dbh->do(q|
5
            CREATE TABLE tables_settings (
6
                module varchar(255) NOT NULL,
7
                page varchar(255) NOT NULL,
8
                tablename varchar(255) NOT NULL,
9
                default_display_length smallint(6) NOT NULL DEFAULT 20,
10
                default_sort_order varchar(255),
11
                PRIMARY KEY(module (191), page (191), tablename (191) )
12
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
13
        |);
14
    }
15
16
    SetVersion( $DBversion );
17
    print "Upgrade to $DBversion done (Bug 24156 - Add new table tables_settings)\n";
18
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +13 lines)
Lines 3662-3667 CREATE TABLE IF NOT EXISTS columns_settings ( Link Here
3662
    PRIMARY KEY(module (191), page (191), tablename (191), columnname (191))
3662
    PRIMARY KEY(module (191), page (191), tablename (191), columnname (191))
3663
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3663
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3664
3664
3665
--
3666
-- Table structure for table `tables_settings`
3667
--
3668
3669
CREATE TABLE IF NOT EXISTS tables_settings (
3670
    module varchar(255) NOT NULL,
3671
    page varchar(255) NOT NULL,
3672
    tablename varchar(255) NOT NULL,
3673
    default_display_length smallint(6) NOT NULL DEFAULT 20 ,
3674
    default_sort_order varchar(255),
3675
    PRIMARY KEY(module (191), page (191), tablename (191) )
3676
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3677
3665
--
3678
--
3666
-- Table structure for table 'items_search_fields'
3679
-- Table structure for table 'items_search_fields'
3667
--
3680
--
3668
- 

Return to bug 24156