yes, create a new database. Let's called it "puppet_extra" Let say the StoreConfigs db has a table called "hosts" that you want to add columns to. Create a table in puppet_extra called "hosts" with two fields: ID and myExtraColumn. Assuming you have some sort of code that inserts the extra data, just add the extra to the puppet_extra.hosts table. If there is not entry there, then add one using the same ID as the hosts entry in the puppet db.
One thing you will need to be careful of is when you do selects from the two tables. Normally you would do a join between puppet.hosts.id and puppet_extra.hosts.id, but it's possible that there is not entry in puppet_extra.hosts for every enter in puppet.hosts (unless you ensure there is). If there is not, then you need to do a left join to make sure you get all the rows in puppet.hosts. If this doesn't make sense, find a database person to help. --- Thanks, Allan Marcus 505-667-5666 On Jul 3, 2009, at 2:10 AM, Sheldon Hearn wrote: > > I'm not sure I understand. Do you mean create a new database? > > Ciao, > Sheldon. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
