1 # @tag: taxzone_sortkey
2 # @description: Setzt eine neue Spalte sortkey in der Datenbank, um Steuerzonen sortierbar zu machen.
3 # @depends: taxzone_charts
4 package SL::DBUpgrade2::taxzone_sortkey;
9 use SL::DB::Manager::TaxZone;
11 use parent qw(SL::DBUpgrade2::Base);
16 my $query = qq|ALTER TABLE tax_zones ADD COLUMN sortkey INTEGER|;
17 $self->db_query($query);
20 $query = qq|SELECT * FROM tax_zones ORDER BY id|;
22 my $sth = $self->dbh->prepare($query);
23 $sth->execute || $::form->dberror($query);
25 while (my $ref = $sth->fetchrow_hashref("NAME_lc")) {
26 $self->db_query(qq|UPDATE tax_zones SET sortkey = $sortkey WHERE id = | . $ref->{id});
31 $query = qq|ALTER TABLE tax_zones ALTER COLUMN sortkey SET NOT NULL|;
32 $self->db_query($query);