# @tag: contacts_add_street_and_zipcode_and_city
# @description: Spalten hinzufügen.
# @depends: release_2_7_0
-# @charset: utf-8
+package SL::DBUpgrade2::contacts_add_street_and_zipcode_and_city;
-use utf8;
use strict;
+use utf8;
+
+use parent qw(SL::DBUpgrade2::Base);
+
+sub run {
+ my ($self) = @_;
-my @queries = (
- 'ALTER TABLE contacts ADD COLUMN cp_street text;',
- 'ALTER TABLE contacts ADD COLUMN cp_zipcode text;',
- 'ALTER TABLE contacts ADD COLUMN cp_city text;',
-);
+ my @queries = (
+ 'ALTER TABLE contacts ADD COLUMN cp_street text;',
+ 'ALTER TABLE contacts ADD COLUMN cp_zipcode text;',
+ 'ALTER TABLE contacts ADD COLUMN cp_city text;',
+ );
-foreach my $query (@queries) {
- if ( $dbh->do($query) ) {
- next;
- }
+ $self->db_query($_, may_fail => 1) for @queries;
- $dbh->rollback();
- $dbh->begin_work();
+ return 1;
}
-return 1;
+1;