UPDATE
The issue has been partly resolved so far. In my wp-config was the wrong database chosen. Thanks for the help so far! :)
I got another question: Now the table creation works, but only the first table is created. The other 3 not. Does somebody know why?
My Code now looks like this:
function artok_activate(){
global $wpdb;
require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
$charset_collate = $wpdb->get_charset_collate();
$table_Veranstaltung = $wpdb->prefix . 'Veranstaltung';
$table_Personen = $wpdb->prefix . 'Personen';
$table_Sponsor = $wpdb->prefix . 'Sponsor';
$table_SponKunde = $wpdb->prefix . 'SponKunde';
if( $wpdb->get_var( "SHOW TABLES LIKE '$table_Veranstaltung'" ) != $table_Veranstaltung ) {
$tableVer_Crea = 'CREATE TABLE ' . $table_Veranstaltung . '(
ver_id int(11) NOT NULL AUTO_INCREMENT,
VeranstaltungName varchar(255),
PRIMARY KEY (ver_id)
)' . $charset_collate . ';';
dbDelta( $tableVer_Crea );
$success = empty($wpdb->last_error);
return $success;
}
if( $wpdb->get_var( "SHOW TABLES LIKE '$table_Personen'" ) != $table_Personen ) {
$tablePers_Crea = "CREATE TABLE " . $table_Personen . "(
pers_id int(11) NOT NULL AUTO_INCREMENT,
Datum DATE,
Passwort varchar(255) UNIQUE,
Vorname varchar(255),
Nachname varchar(255),
Anrede varchar(255),
LoeschDatum DATE,
fkVer_id int(11),
FOREIGN KEY(fkVer_id) REFERENCES wp_Veranstaltung(Ver_id),
PRIMARY KEY (pers_id)
)" . $charset_collate . ";";
dbDelta($tablePers_Crea);
$success = empty($wpdb->last_error);
return $success;
}
if( $wpdb->get_var( "SHOW TABLES LIKE '$table_Sponsor'" ) != $table_Sponsor) {
$tableSp_Crea = "CREATE TABLE " . $table_Sponsor . "(
sp_id int(11) NOT NULL AUTO_INCREMENT,
Code varchar(255),
Name varchar(255),
PRIMARY KEY (sp_id)
)" . $charset_collate . ";";
dbDelta( $tableSp_Crea );
$success = empty($wpdb->last_error);
return $success;
}
if( $wpdb->get_var( "SHOW TABLES LIKE '$table_SponKunde'" ) != $table_SponKunde ) {
$tableSpKu_Crea = "CREATE TABLE " . $table_SponKunde . "(
fkPers_id int(11),
fkSp_id int(11),
FOREIGN KEY(fkPers_id) REFERENCES wp_Personen(pers_id),
FOREIGN KEY(fkSp_id) REFERENCES wp_Sponsor(sp_id)
)" . $charset_collate . ";";
dbDelta( $tableSpKu_Crea );
$success = empty($wpdb->last_error);
return $success;
}
}
register_activation_hook( __FILE__, 'artok_activate' );