OpenPKG CVS Repository
  http://cvs.openpkg.org/
  ____________________________________________________________________________

  Server: cvs.openpkg.org                  Name:   Thomas Lotterer
  Root:   /e/openpkg/cvs                   Email:  [EMAIL PROTECTED]
  Module: openpkg-tools                    Date:   26-Jan-2005 15:42:24
  Branch: HEAD                             Handle: 2005012614422400

  Modified files:
    openpkg-tools/cmd       bf-db.pl

  Log:
    fix index creation

  Summary:
    Revision    Changes     Path
    1.4         +7  -1      openpkg-tools/cmd/bf-db.pl
  ____________________________________________________________________________

  patch -p0 <<'@@ .'
  Index: openpkg-tools/cmd/bf-db.pl
  ============================================================================
  $ cvs diff -u -r1.3 -r1.4 bf-db.pl
  --- openpkg-tools/cmd/bf-db.pl        26 Jan 2005 14:03:52 -0000      1.3
  +++ openpkg-tools/cmd/bf-db.pl        26 Jan 2005 14:42:24 -0000      1.4
  @@ -338,8 +338,14 @@
           $sql .= "    st_build_color     TEXT DEFAULT \"\",\n"; # red/green 
depending on binary RPM  | green
           $sql .= "PRIMARY KEY ( st_inst_host, st_inst_arch, st_inst_os, 
st_inst_tag, st_package_name ) ON CONFLICT REPLACE\n";
           $sql .= ");\n";
  +        $dbh->do($sql);
  +        $sql = '';
           $sql .= "CREATE INDEX status_index ON status";
  -        $sql .= "    (st_package_name, st_package_version, 
st_package_release);\n";
  +        $sql .= "(\n";
  +        $sql .= "   st_package_name,\n";
  +        $sql .= "   st_package_version,\n";
  +        $sql .= "   st_package_release\n";
  +        $sql .= ");\n";
           $dbh->do($sql);
       };
   
  @@ .
______________________________________________________________________
The OpenPKG Project                                    www.openpkg.org
CVS Repository Commit List                     [email protected]

Reply via email to