When trying to create a second instance of moodle using the same db but a different prefix, the following two sql statements complain:
CONSTRAINT user_username_uk UNIQUE (username)
CONSTRAINT config_name_uk UNIQUE (name)
for the user table & config tables respectively.
These are the only two I've found thus far, as can't get past the first admin screen.