filenames format in \sql\updates folder
Posted: Fri Oct 27, 2006 10:18 am
Hi All,
I'd like to propose this a log time ago. As you can see, the content of \sql\updates folder is a bit messy. We can find there updates marked with a dates in a lot of date format.
What do you think about making a standard that will:
a) more clear for everyone
b) support the file sorting
It can contain the date of update in yyyymmdd format along with a DP revision. For example:
present filename: update10152006.sql
can be replaced with: 20061015-dp2197.sql
and merged with: 20061015-[dp2197].sql
If merge is not possible or not handy it can be marked with a proper letter (a, b, c...) as for one dp update we can have more than one sql update.
What do you think about this?
A.
I'd like to propose this a log time ago. As you can see, the content of \sql\updates folder is a bit messy. We can find there updates marked with a dates in a lot of date format.
What do you think about making a standard that will:
a) more clear for everyone
b) support the file sorting
It can contain the date of update in yyyymmdd format along with a DP revision. For example:
present filename: update10152006.sql
can be replaced with: 20061015-dp2197.sql
and merged with: 20061015-[dp2197].sql
If merge is not possible or not handy it can be marked with a proper letter (a, b, c...) as for one dp update we can have more than one sql update.
What do you think about this?
A.