From 369b53ae06e433a439d792ff134f8f573a96a16d Mon Sep 17 00:00:00 2001
From: sunsetsystems <sunsetsystems>
Date: Mon, 24 Oct 2005 16:39:00 +0000
Subject: [PATCH] increased size of codes.code

---
 sql/2_7_2-to-2_7_3_upgrade.sql | 2 ++
 sql/database.sql               | 2 +-
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/sql/2_7_2-to-2_7_3_upgrade.sql b/sql/2_7_2-to-2_7_3_upgrade.sql
index 42a1942f6..da63a606a 100644
--- a/sql/2_7_2-to-2_7_3_upgrade.sql
+++ b/sql/2_7_2-to-2_7_3_upgrade.sql
@@ -72,3 +72,5 @@ CREATE TABLE IF NOT EXISTS `batchcom` (
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM ;
 
+ALTER TABLE billing
+  CHANGE `code` varchar(9) DEFAULT NULL;
diff --git a/sql/database.sql b/sql/database.sql
index 310cfbe28..213eeb00e 100644
--- a/sql/database.sql
+++ b/sql/database.sql
@@ -20,7 +20,7 @@ CREATE TABLE `billing` (
   `id` int(11) NOT NULL auto_increment,
   `date` datetime default NULL,
   `code_type` varchar(7) default NULL,
-  `code` varchar(7) default NULL,
+  `code` varchar(9) default NULL,
   `pid` int(11) default NULL,
   `provider_id` int(11) default NULL,
   `user` int(11) default NULL,
-- 
2.11.4.GIT