installer/data/mysql/db_revs/211200005.pl

   1 use Modern::Perl;
   2
   3 return {
   4     bug_number => "29778",
   5     description => "Delete orphan additional contents",
   6     up => sub {
   7         my ($args) = @_;
   8         my ($dbh, $out) = @$args{qw(dbh out)};
   9         $dbh->do(q{
  10             DELETE FROM additional_contents
  11             WHERE code NOT IN (
  12                 SELECT code FROM (
  13                     SELECT code
  14                     FROM additional_contents
  15                     WHERE lang = "default"
  16                 ) as tmp
  17             );
  18         });
  19     },
  20 }