can you add it real quick? 2012/3/29 Jakub Jankiewicz <[email protected]>: > 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
-- Jon Phillips 王✳爻气 http://fabricatorz.com ✳ skype: kidproto ✳ irc: rejon +1.415.830.3884 (global) ✳ +86-187-1003-9974 (beijing) _______________________________________________ Mailing list: https://launchpad.net/~aikiframework-devel Post to : [email protected] Unsubscribe : https://launchpad.net/~aikiframework-devel More help : https://help.launchpad.net/ListHelp
