r5275 - branches/bmas-staging/scripts

[subve...@svn.freemedsoftware.org]

Author: jeff
Date: 2010-03-11 13:42:43 -0500 (Thu, 11 Mar 2010)
New Revision: 5275

Modified:
branches/bmas-staging/scripts/upgrade.php
Log:
Fix for 0.8.x -> 0.9.x pharmacy table differences.

Modified: branches/bmas-staging/scripts/upgrade.php
===================================================================
--- branches/bmas-staging/scripts/upgrade.php 2010-03-11 17:02:46 UTC (rev 5274)
+++ branches/bmas-staging/scripts/upgrade.php 2010-03-11 18:42:43 UTC (rev 5275)
@@ -68,6 +68,9 @@
execSql( "ALTER TABLE procrec CHANGE COLUMN id id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT;" );
execSql( "ALTER TABLE rx CHANGE COLUMN id id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT;" );

+printHeader( "Fix potentially differing table column names" );
+execSql( "ALTER TABLE pharmacy CHANGE COLUMN phstpr phstate CHAR(3);" );
+
printHeader( "Fix eventual patient table issue" );
execSql("ALTER IGNORE TABLE patient ADD COLUMN ptmphone CHAR(16) AFTER ptwphone;");
execSql("ALTER IGNORE TABLE patient ADD COLUMN ptprefcontact VARCHAR (10) NOT NULL DEFAULT 'home' AFTER ptcountry;");