Most scripts (WordPress, Drupal, etc) have the option to use "table prefixes", ie they add something like wp_ in front of their 'username' table to make it 'wp_username' so that it won't clash with table names from other scripts.
The 'max size' is dependent on the MySQL server, which should...