Banshee
the secure PHP framework

Forum

Database Upgrading

MNicole
4 october 2016, 20:50
Hi Hugo !

A general question concerning Database, I guess useful for eveybody.

When you change, for example from Banshee#5.3 to Banshee#5.4, the Database structure changes also.
The first and basic step is to create the Database. The SQL script you provide.

But ... When you have and 'old' and consistent database, how to only change to the new structure (small changes, of course) ? Making a "diff
" between the two SQL scripts, extracting the appropriate requests, and submit them to the MySQL engine ?

Some time that I thought that we could make this via a kind of script ?
A kind of "import/export".
And I could work on it.

Maybe I do not see well the stuff ?

Regards.
Hi to everybody.
Hugo Leisink
5 october 2016, 16:45
The reason Banshee doesn't update the database of previous installations, is because I see Banshee more as a framework than as a CMS. I expect users to change Banshee's code, making an automated upgrade impossible.

To update the database, do a diff between the older database/mysql.sql file and the one you're about to install. Changes are often minimal.
MNicole
6 october 2016, 01:25

Yes, maybe it's a better choice.

So many 'CMS' with so many 'services' provided, and the result is that it's much more time consuming than going into some clean 'CMF' code ...

And this way the user must understand the underlying engines.

Thanks. Regards.
Message preview

The following BB-codes are available in a message:

  • [b]Bold text[/b]
  • [center]Center text or imagen[/center]
  • [color=color name or #RGB code]Colored text[/color]
  • [i]Italic text[/i]
  • [img]Link to image[/img]
  • [right]Align text or image right[/right]
  • [s]Strike-through text[/s]
  • [size=pixelsize]Big or small text[/size]
  • [u]Underlined text[/u]
  • [url]Link to website[/url]
  • [url=link to website]Link text[/url]