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 3624-3629 CREATE TABLE IF NOT EXISTS columns_settings ( Link Here
3624
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3624
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3625
3625
3626
--
3626
--
3627
-- Table structure for table `tables_settings`
3628
--
3629
3630
CREATE TABLE IF NOT EXISTS tables_settings (
3631
    module varchar(255) NOT NULL,
3632
    page varchar(255) NOT NULL,
3633
    tablename varchar(255) NOT NULL,
3634
    default_display_length smallint(6) NOT NULL DEFAULT 20 ,
3635
    default_sort_order varchar(255),
3636
    PRIMARY KEY(module (191), page (191), tablename (191) )
3637
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3638
3639
--
3627
-- Table structure for table 'items_search_fields'
3640
-- Table structure for table 'items_search_fields'
3628
--
3641
--
3629
3642
3630
- 

Return to bug 24156