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 3659-3664 CREATE TABLE IF NOT EXISTS columns_settings ( Link Here
3659
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3659
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3660
3660
3661
--
3661
--
3662
-- Table structure for table `tables_settings`
3663
--
3664
3665
CREATE TABLE IF NOT EXISTS tables_settings (
3666
    module varchar(255) NOT NULL,
3667
    page varchar(255) NOT NULL,
3668
    tablename varchar(255) NOT NULL,
3669
    default_display_length smallint(6) NOT NULL DEFAULT 20 ,
3670
    default_sort_order varchar(255),
3671
    PRIMARY KEY(module (191), page (191), tablename (191) )
3672
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3673
3674
--
3662
-- Table structure for table 'items_search_fields'
3675
-- Table structure for table 'items_search_fields'
3663
--
3676
--
3664
3677
3665
- 

Return to bug 24156