Guidance about developing a public application with lots of db's

[eluser]thurting[/eluser]
If the schema will be copied exactly across all of your clients, it may be a better idea to create one and set up a client table; e.g. table client (id name). You could then make sure to reference client.id as a foreign key constraint in all tables that contain data related to client instances; e.g. table customers (id client.id name). This is how I would do it. You don't really need to copy the schema for each client.