Revisions for ansel/scripts/upgrades/2006-11-27_datatree_to_sql_renames.php

Location: [ Horde ] / ansel / scripts / upgrades / 2006-11-27_datatree_to_sql_renames.php View: Logs | Branches | Statistics
Search Revisions:
Show diffs between and
Show Differences shows diffs to the previous revision. If you select a revision by clicking its row, Show Differences will show the differences to the selected row.
Show Branch:
  Revision Date Author Log Message
1.5.2.1 FRAMEWORK_3 (+1 -1 lines) 11/05/2008 12:28 PM Jan Schneider jan

No need for pre-branching upgrade scripts here.

1.5 (+2 -2 lines) 01/15/2008 08:31 PM Michael Rubinsky mrubinsk

The mother of all Ansel commits.  This removes all the gallery attributes
from the datatree, leaving only permissions and hierarchical information in
datatree.

To upgrade, first run the 2008_01_07_add_galleries.sql script to create
the gallery table and then run the sql_galleries.php script.  The script
does *NOT* delete any data from the datatree - it only creates the new
structure. Another (upcoming) upgrade script will remove the data from
the datatree once this is more thoroughly tested.

Bug: 6101

Tags: FRAMEWORK_3

1.4 (+6 -6 lines) 08/29/2007 06:20 PM Jan Schneider jan

- Fix script to rename the vfs files. The old code assumed that the
thumbnails have the same image type like the original, which is not
necessarily true. Instead we simply delete all thumbnails now and have
them recreated on the next access.
- Fix the fix that fixed the fix for bug 5381. Always having two-digit
hash folders was the correct thing to do, but the rename script
created only single digit folders.

1.3 (+12 -15 lines) 12/02/2006 11:27 PM Chuck Hagenbuch chuck

much more efficient fetching of gallery ids.

1.2 (+4 -1 lines) 12/02/2006 10:00 PM Chuck Hagenbuch chuck

This script desperately needs some output.

1.1 12/01/2006 03:56 PM Chuck Hagenbuch chuck

3-part migration to the new SQL format (I wouldn't run this yet, it
might not be finalized). The scripts are intended to be run in this
order:

Step 0:
Create the new SQL tables using ansel.sql

Step 1, sql_images.php
This script creates entries in the new SQL tables for all of the
relevant datatree data. It does NOT modify or delete any data, so it
should be entirely safe to experiment with.

Step 2, datatree_to_sql_renames.php
This script accounts for the fact that image ids have changed and
renames VFS files accordingly. It does change data, but should not be
destructive. Still, it would be very awkward to go back after running
this, so use care and back up first.

Step 3, cleanup.php
This script's whole purpose is destructive - it removes the data you
don't need any more from the DataTree, and also the
ansel_datatree_transition table that was used to map old image ids to
new image ids. Don't run it until you're sure things are working
perfectly again.