Great, so in most cases it's automatic. PS: You should put this in the wiki, it isn't there upgrages[501] = "UPDATE some_table WITH aiki_parent= aiki_father";
On Wed, 28 Mar 2012 21:46:35 +0200 Roger Martín <[email protected]> wrote: > Hi people > > Now upgrader only upgrade database structure checking: > "AIKI_ROOT_DIR/sql/CreateTables.sql", > "AIKI_ROOT_DIR/sql/CreateTablesSite.sql" (optional for site) > Upgrader add new field, and index, but never delete a field or a > table. > > First version upgrade some data, but as admin is inserted in aiki site > default it was disable to avoid deleting customized admin. > > Manual SQL can be done (read point 3) > > > > ------------------------------- > Notes about upgrader (sent feb 2012) > > Some notes about upgrader > 2) please read > http://www.aikiframework.org/wiki/Aiki_installation/upgrade_process > > > 3) last-version > - config/last-version is created and used in > not ./bzr/branch/last-version is detected. It is not necessary > that /configs/last-version are updated all time, only when manual > correction is necesary. > > 3) manual sql > - assets/apps/upgrades/upgrades.php . > File that contain manual sql necessary for revision. For example if > revison 501 change field aiki_father to aiki_parents, then > upgrades must contains: > upgrages[501] = "UPDATE some_table WITH aiki_parent= aiki_father"; > Aiki knows in which revision is was installed, so can filter this > array to execute only necessary sql (in ascending order of revision) > > > 4) configs/changelog.php > This files contains an array with useful information about revision. > Again, it's not necessary include all revision, only: > - bug correction when have number. > - important improvements. > - changes that requires manual corrections. > - changes in version number. > > 5) Old installation > For old installation, upgrade only upgrade database structure, but > you can help adding in upgrades.php the SQL necessary to make > changes. Ask for help. -- Jakub Jankiewicz twitter: @jcubic www: http://jcubic.pl _______________________________________________ Mailing list: https://launchpad.net/~aikiframework-devel Post to : [email protected] Unsubscribe : https://launchpad.net/~aikiframework-devel More help : https://help.launchpad.net/ListHelp
