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

Return to bug 24156