1 # @tag: globalprojectnumber_ap_ar_oe
2 # @description: Neue Spalte für eine globale Projektnummer in Einkaufs- und Verkaufsbelegen
3 # @depends: release_2_4_1
7 # import vars from caller
8 our ($dbup_locale, $dbup_myconfig, $dbh);
10 die("This script cannot be run from the command line.") unless ($main::form);
14 die($dbup_locale->text("Database update error:") .
15 "<br>$msg<br>" . $DBI::errstr);
19 my ($query, $may_fail) = @_;
21 if (!$dbh->do($query)) {
22 mydberror($query) unless ($may_fail);
30 ("ALTER TABLE ap ADD COLUMN globalproject_id integer;",
31 "ALTER TABLE ap ADD FOREIGN KEY (globalproject_id) REFERENCES project (id);",
32 "ALTER TABLE ar ADD COLUMN globalproject_id integer;",
33 "ALTER TABLE ar ADD FOREIGN KEY (globalproject_id) REFERENCES project (id);",
34 "ALTER TABLE oe ADD COLUMN globalproject_id integer;",
35 "ALTER TABLE oe ADD FOREIGN KEY (globalproject_id) REFERENCES project (id);");
37 do_query("ALTER TABLE project ADD PRIMARY KEY (id);", 1);
38 map({ do_query($_, 0); } @queries);