Table installation query needs updateing

After i installed this plugin and attempting to map a domain to a site i noticed that nothing was happening.

so looking at the database i could see the plugin had created the ‘domain_mapping_logins’ table but not the ‘domain_mapping’ table.

I then procceeded to attempt to manually install the table via the query found in file: domain_mapping.php line 94.

MySql threw an error: #1071 – Specified key was too long; max key length is 1000 bytes

so i updated the query to the following and the query went though, and the plugin worked again:

CREATE TABLE IF NOT EXISTSwpprefix_domain_mapping` (
id bigint(20) NOT NULL auto_increment,
blog_id bigint(20) NOT NULL,
domain varchar(255) NOT NULL,
active tinyint(4) default ‘1’,
PRIMARY KEY (id),
KEY blog_id (blog_id,domain(50),active)
);`

the diffrence is in this line: KEYblog_id(blog_id,domain(50),active)

the varchar(255) is just to big to be indexed, so we do the above to only index part of the data stored in the column.

Id also like to note that the plugin really should improve upon its error reporting as this could have turned into hours of searching..