|
Lines 76-85
sub _new_schema {
Link Here
|
| 76 |
%encoding_attr = ( mysql_enable_utf8 => 1 ); |
76 |
%encoding_attr = ( mysql_enable_utf8 => 1 ); |
| 77 |
$encoding_query = "set NAMES 'utf8mb4'"; |
77 |
$encoding_query = "set NAMES 'utf8mb4'"; |
| 78 |
$tz_query = qq(SET time_zone = "$tz") if $tz; |
78 |
$tz_query = qq(SET time_zone = "$tz") if $tz; |
| 79 |
unless ( C4::Context->config('strict_sql_modes') ) { |
79 |
if ( $ENV{_} =~ m|prove| or C4::Context->config('strict_sql_modes') ) { |
| 80 |
$sql_mode_query = q{SET sql_mode = 'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'}; |
|
|
| 81 |
} else { |
| 82 |
$sql_mode_query = q{SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'}; |
80 |
$sql_mode_query = q{SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'}; |
|
|
81 |
} else { |
| 82 |
$sql_mode_query = q{SET sql_mode = 'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'}; |
| 83 |
} |
83 |
} |
| 84 |
} |
84 |
} |
| 85 |
elsif ( $db_driver eq 'Pg' ) { |
85 |
elsif ( $db_driver eq 'Pg' ) { |
| 86 |
- |
|
|