From: bradymiller <bradymiller@users.sourceforge.net>
Date: Fri, 18 Jan 2013 02:24:47 +0000 (-0800)
Subject: Support for larger size codes (such as SNOMED US Extension codes)
X-Git-Tag: whats-been-changed~453
X-Git-Url: https://repo.or.cz/w/openemr.git/commitdiff_plain/2b8568a9c565c4bf48140581a66e3ac69a4529a1

Support for larger size codes (such as SNOMED US Extension codes)
---

diff --git a/sql/4_1_1-to-4_1_2_upgrade.sql b/sql/4_1_1-to-4_1_2_upgrade.sql
index 077f58ba0..bd136ba5a 100644
--- a/sql/4_1_1-to-4_1_2_upgrade.sql
+++ b/sql/4_1_1-to-4_1_2_upgrade.sql
@@ -120,3 +120,11 @@ DROP TABLE `temp_table_one`;
 ALTER TABLE `codes` CHANGE `code` `code` varchar(25) NOT NULL default '';
 #EndIf
 
+#IfNotColumnType billing code varchar(20)
+ALTER TABLE `billing` CHANGE `code` `code` varchar(20) default NULL;
+#EndIf
+
+#IfNotColumnType ar_activity code varchar(20)
+ALTER TABLE `ar_activity` CHANGE `code` `code` varchar(20) NOT NULL COMMENT 'empty means claim level';
+#EndIf
+
diff --git a/sql/database.sql b/sql/database.sql
index 9e04b7e20..cedf3ab39 100644
--- a/sql/database.sql
+++ b/sql/database.sql
@@ -113,7 +113,7 @@ CREATE TABLE `billing` (
   `id` int(11) NOT NULL auto_increment,
   `date` datetime default NULL,
   `code_type` varchar(15) default NULL,
-  `code` varchar(9) default NULL,
+  `code` varchar(20) default NULL,
   `pid` int(11) default NULL,
   `provider_id` int(11) default NULL,
   `user` int(11) default NULL,
@@ -5291,7 +5291,7 @@ CREATE TABLE ar_activity (
   encounter      int(11)       NOT NULL,
   sequence_no    int unsigned  NOT NULL AUTO_INCREMENT,
   `code_type`    varchar(12)   NOT NULL DEFAULT '',
-  code           varchar(9)    NOT NULL            COMMENT 'empty means claim level',
+  code           varchar(20)   NOT NULL            COMMENT 'empty means claim level',
   modifier       varchar(12)   NOT NULL DEFAULT '',
   payer_type     int           NOT NULL            COMMENT '0=pt, 1=ins1, 2=ins2, etc',
   post_time      datetime      NOT NULL,
diff --git a/version.php b/version.php
index fcd3456ee..d7cd68d5e 100644
--- a/version.php
+++ b/version.php
@@ -17,7 +17,7 @@ $v_realpatch = '0';
 // is a database change in the course of development.  It is used
 // internally to determine when a database upgrade is needed.
 //
-$v_database = 84;
+$v_database = 85;
 
 // Access control version identifier, this is to be incremented whenever there
 // is a access control change in the course of development.  It is used