shared tables role

Hi there,

I'm attempting my first multi-site, single codebase drupal 6 installation using prefixed tables to share common data.

Background

Looking from the outside, I think the best way to explain my reasoning for this configuration is going to be module management, and to ease the development of the core facilities the site(s) will offer.

I'm attempting to split the rather large modules apart so I end up with subdomains offering the features the users require, here is the basic layout.

<

ol>

BS"D

Drupal version 5.x

I have created two sites sharing one database so that user data is shared. At first, I was unable to create content on either site so I was instructed to run the following commands:

update shared_sequences set name = concat('site1_',name) where name not like 'site2_%';

update shared_sequences set id = id + 100;

I've already read the discussion about D5 Shared database but didn't find a resumed classification for D6

Knowing which tables to share can be hard to figure out, so I would like some help on this.

The scenario:
- Intranet services developed by different individual which shouldn't interfere each other (so each developer has one D6 sandbox for each service which shouldn't interfere with others)
- Global user/roles/permission settings
- Modules/Themes can (probably will) differ from service to service

In my multisite setup, I am sharing the role table. My issue is that every time I install a new site, it adds anonymous and authenticated roles to the roles table. So, now I have several duplicate sets of these roles. Any one figure a way to fix this... or maybe it's something to be posted as a bug?