[cvs] commit: ansel/scripts/upgrades 2006-11-27_cleanup.php 2006-11-27_datatree_to_sql_renames.php 2006-11-27_sql_images.php

[Chuck Hagenbuch]

chuck       2006-12-01 12:56:09 PST

  Added files:
    scripts/upgrades     2006-11-27_cleanup.php 
                         2006-11-27_datatree_to_sql_renames.php 
                         2006-11-27_sql_images.php 
  Log:
  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.
  
  Revision  Changes    Path
  1.1       +69 -0     ansel/scripts/upgrades/2006-11-27_cleanup.php (new)
  1.1       +100 -0    ansel/scripts/upgrades/2006-11-27_datatree_to_sql_renames.php (new)
  1.1       +159 -0    ansel/scripts/upgrades/2006-11-27_sql_images.php (new)

  Chora Links:
  http://cvs.horde.org/co.php/ansel/scripts/upgrades/2006-11-27_cleanup.php?r=1.1
  http://cvs.horde.org/co.php/ansel/scripts/upgrades/2006-11-27_datatree_to_sql_renames.php?r=1.1
  http://cvs.horde.org/co.php/ansel/scripts/upgrades/2006-11-27_sql_images.php?r=1.1