On Wed, May 27, 2009 at 11:24 AM, Cantwell, Bryan
bcantw...@firescope.com wrote:
I want to check all my functions and procs into my svn as individual sql
files. When I use these to create my db, the person doing this may not
realize the correct order to run these files and not have dependency
challenges... How can I have procs that depend on functions, or vice versa,
get successfully created without regard to correct order?
Thanks
Bryancan
I prefixed the filenames of the various discrete files with numeric
prefixes like so
10-create-customer.sql
20-finalize-transaction.sql
...
and then wrote a shell script to fire them off in sort-order. I
deliberately used the numbering convention from line-numbered basic to
allow me to inject intervening files without having to renumber the
set.
--
- michael dykman
- mdyk...@gmail.com
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org