User Tools

  • Logged in as: anonymous (anonymous)
  • Log Out

Site Tools


mantisbt:schema_compare_update

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
mantisbt:schema_compare_update [2013/09/14 19:12]
dregad created
mantisbt:schema_compare_update [2013/09/16 03:56] (current)
dregad exclude mantis_upgrade_table from tables to drop as per grangeway's suggestion
Line 7: Line 7:
  
 The script and process was tested using a dump from mantisbt.org bugs database taken on 13-Sep-2013. The script and process was tested using a dump from mantisbt.org bugs database taken on 13-Sep-2013.
 +
  
  
Line 31: Line 32:
  * 2013-09-13  dregad  handle unique index creation  * 2013-09-13  dregad  handle unique index creation
  * 2013-09-14  dregad  fix default value setting for ''  * 2013-09-14  dregad  fix default value setting for ''
 + * 2013-09-16  dregad  exclude mantis_upgrade_table from tables to drop
  */  */
  
Line 157: Line 159:
     WHERE std_12x IS NULL     WHERE std_12x IS NULL
       AND tbl NOT LIKE '%_plugin_%'       AND tbl NOT LIKE '%_plugin_%'
 +      AND tbl <> 'mantis_upgrade_table'
  
 ) delta; ) delta;
mantisbt/schema_compare_update.1379200368.txt.gz ยท Last modified: 2013/09/16 03:56 (external edit)