How do I mark a file as run once?

Hi All,
 
We have certain files that can only be applied once to an environment.
Mostly database table scripts like create table, alter table, some
inserts that fill with default data, etc. Using PVCS, we use promotion
groups to manage this. If/when we move to subversion, how would we
manage this?
 
Also, we manually list all the files required for a change in a
tracking system. This allows us to set an apply order - you want to
create the table before you attempt to insert data into it, or maybe
alter it before you update it. If SVN doesn't require us to keep the
list of files, because the atomic commits are an intrinisic changeset,
(something we're looking forward to) how do we maintain this apply
order? DO we have to keep the manual list of files, but just the
database changes, not every file in the change?
 
 

Luke Mason
Configuration Specialist

Oasis Asset Management Limited
Ground Floor, 65-67 Burelli Street
WOLLONGONG NSW 2500

Telephone:

61 2 4231 3086

Facsimile:

61 2 4231 3005

Email:

lmason_at_oasisasset.com.au <mailto:lmason_at_oasisasset.com.au>

Website:

www.oasisasset.com.au <http://www.oasisasset.com.au/>

"This email is intended for the named recipient only. The information contained in this message may be confidential, or commercially sensitive. If you are not the intended recipient you must not reproduce or distribute any part of this email, disclose its contents to any other party, or take any action in reliance on it, or in reference to it. If you have received this email in error, would you please contact the sender immediately and delete/destroy all copies of this message, both electronic and otherwise. It is the recipient's duty to virus scan and otherwise test the enclosed information before using the information or loading attached files onto any computer system. Oasis Asset Management Ltd does not warrant that the information contained in this e-mail is free from viruses, defects, errors, interception or interference. Any views expressed in this message are those of the individual sender, except where that sender specifically states them to be the views of Oasis Asset Management Ltd."

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________