Re: Re: [midgard-user] Midcom 2.6 schema and sql files

Henri Bergius <henri.bergius-ZpG/[email protected]> wrote:

> We could create another custom role for this, yes. Even after midgard- 
> schema table creation this could be useful for adding indexes, etc.
> 
> Any preferences on the location? Maybe config/database.sql ?

Currently database and tables update are far from being perfect.
I mean that all sql files from update subdirectory are imported when 
user selects 'database update' from dg menu. So now error like 
'column already exists' is silently ignored and sql import doesn't stop.

Torben suggested database versioning , but this means much more work 
with dg itself and with sql files included in components.
Even if this much work is worth to be made , there is still issue with versioning 
itself. 
Should sql file follow MidCOM, component or Midgard version?

Preferenced location is : $prefix/share/midgard/sql/update for updates.
I am not sure if create subdirectory should be created as midgard-schema 
creates tables and columns very well right now.

Piotras