projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Kosmetik: keine Tabs
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
taxzone_sortkey.pl
diff --git
a/sql/Pg-upgrade2/taxzone_sortkey.pl
b/sql/Pg-upgrade2/taxzone_sortkey.pl
index
88897d7
..
7b1c4ce
100644
(file)
--- a/
sql/Pg-upgrade2/taxzone_sortkey.pl
+++ b/
sql/Pg-upgrade2/taxzone_sortkey.pl
@@
-15,7
+15,6
@@
sub run {
my $query = qq|ALTER TABLE tax_zones ADD COLUMN sortkey INTEGER|;
$self->db_query($query);
my $query = qq|ALTER TABLE tax_zones ADD COLUMN sortkey INTEGER|;
$self->db_query($query);
- $self->dbh->commit;
my $sortkey = 1;
$query = qq|SELECT * FROM tax_zones ORDER BY id|;
my $sortkey = 1;
$query = qq|SELECT * FROM tax_zones ORDER BY id|;
@@
-29,8
+28,6
@@
sub run {
}
$sth->finish;
}
$sth->finish;
- $self->dbh->commit;
-
$query = qq|ALTER TABLE tax_zones ALTER COLUMN sortkey SET NOT NULL|;
$self->db_query($query);
$query = qq|ALTER TABLE tax_zones ALTER COLUMN sortkey SET NOT NULL|;
$self->db_query($query);