anroots/wp-theatre-troupe — Issue #1: Assigning actors to shows fails
Author: anroots
Created: 2011-10-14 00:21:59+00:00
State: open

There is a problem with the actors database definition in v1.3 (the one currently up at Wordpress official SVN).

wp_ttroupe_show_participants table creation fails during plugin activation because of an invalid primary key definition.
Creating the table manually resolves it.

CREATE TABLE IF NOT EXISTS wp_ttroupe_show_participants (
actor_id INT( 8 ) UNSIGNED NOT NULL,
show_id INT( 8 ) UNSIGNED NOT NULL,
PRIMARY KEY (actor_id, show_id)
);