6 Jul
2009
6 Jul
'09
10:17 a.m.
Juha Heinanen wrote:
Martin Hoffmann writes:
as i already mentioned, table upgrades are much simpler if you know the
current version of the table. if you don't, then your (php or whatever)
upgrade script needs to analyze each field of the table based on (in case
of mysql) textual output of describe statements, which is not very
convenient.
if you have an easier means to do the table upgrades, please let me
know. in the meanwhile, i can use my private version table.
Most database APIs provide a way to expose the table definition as well,
i.e. a list of column types and names.
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : (+1) (678) 954-0670
Direct : (+1) (678) 954-0671
Mobile : (+1) (678) 237-1775
in
scripts/mysql/my_create.sql there is no version table. does it mean
that s ser database tables don't have any version number? if so, they
have to be added in order to allow easy db table upgrade.
What? Why? One of the Great Annoyances of S[E]R is the feckin' versions
table. We had various surprise breakages with assorted panic because of
it.