r6184 - trunk/data/schema/mysql

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

Author: jeff
Date: 2011-11-29 23:52:29 -0500 (Tue, 29 Nov 2011)
New Revision: 6184

Modified:
trunk/data/schema/mysql/icd9.sql
Log:
Fix icddrg definition (forward-ported from 0.8.x fix).

Modified: trunk/data/schema/mysql/icd9.sql
===================================================================
--- trunk/data/schema/mysql/icd9.sql 2011-11-30 04:31:42 UTC (rev 6183)
+++ trunk/data/schema/mysql/icd9.sql 2011-11-30 04:52:29 UTC (rev 6184)
@@ -27,7 +27,7 @@
icd10descrip VARCHAR (100),
icdmetadesc VARCHAR (100),
icdng DATE,
- icddrg DATE,
+ icddrg TEXT,
icdnum INT UNSIGNED DEFAULT 0,
icdamt REAL DEFAULT 0.0,
icdcoll REAL DEFAULT 0.0,
@@ -45,9 +45,10 @@
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
ALTER IGNORE TABLE icd9 ADD COLUMN icdarchive INT(10) UNSIGNED DEFAULT 0 AFTER icdcoll;
+ ALTER IGNORE TABLE icd9 CHANGE COLUMN icddrg icddrg TEXT;
#----- Upgrades

END
//
DELIMITER ;
-CALL icd9_Upgrade( );
\ No newline at end of file
+CALL icd9_Upgrade( );