[sr-dev] version of s tables

[Alex Balashov]

Juha Heinanen wrote:
> Martin Hoffmann writes:
> 
>  > > 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.
> 
> 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