r16958 - gnucash/branches/gda-dev2/src - Increase the size of text fields. In most cases, these are increased to

Phil Longstaff plongstaff at cvs.gnucash.org
Sun Feb 24 14:57:28 EST 2008


Author: plongstaff
Date: 2008-02-24 14:57:28 -0500 (Sun, 24 Feb 2008)
New Revision: 16958
Trac: http://svn.gnucash.org/trac/changeset/16958

Modified:
   gnucash/branches/gda-dev2/src/backend/gda/gnc-account-gda.c
   gnucash/branches/gda-dev2/src/backend/gda/gnc-budget-gda.c
   gnucash/branches/gda-dev2/src/backend/gda/gnc-commodity-gda.c
   gnucash/branches/gda-dev2/src/backend/gda/gnc-price-gda.c
   gnucash/branches/gda-dev2/src/backend/gda/gnc-recurrence-gda.c
   gnucash/branches/gda-dev2/src/backend/gda/gnc-schedxaction-gda.c
   gnucash/branches/gda-dev2/src/backend/gda/gnc-slots-gda.c
   gnucash/branches/gda-dev2/src/backend/gda/gnc-transaction-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-address-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-bill-term-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-customer-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-employee-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-entry-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-invoice-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-job-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-order-gda.c
   gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-vendor-gda.c
Log:
Increase the size of text fields.  In most cases, these are increased to
2048 chars.  In a few cases, these were then reduced where mysql ran
into a row length limitation of 65536 bytes per row.



Modified: gnucash/branches/gda-dev2/src/backend/gda/gnc-account-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/backend/gda/gnc-account-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/backend/gda/gnc-account-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -51,10 +51,10 @@
 static void set_parent( gpointer pObject, gpointer pValue );
 static void set_parent_guid( gpointer pObject, gpointer pValue );
 
-#define ACCOUNT_MAX_NAME_LEN 50
-#define ACCOUNT_MAX_TYPE_LEN 50
-#define ACCOUNT_MAX_CODE_LEN 100
-#define ACCOUNT_MAX_DESCRIPTION_LEN 500
+#define ACCOUNT_MAX_NAME_LEN 2048
+#define ACCOUNT_MAX_TYPE_LEN 2048
+#define ACCOUNT_MAX_CODE_LEN 2048
+#define ACCOUNT_MAX_DESCRIPTION_LEN 2048
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/backend/gda/gnc-budget-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/backend/gda/gnc-budget-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/backend/gda/gnc-budget-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -47,8 +47,8 @@
 
 static QofLogModule log_module = G_LOG_DOMAIN;
 
-#define BUDGET_MAX_NAME_LEN 50
-#define BUDGET_MAX_DESCRIPTION_LEN 500
+#define BUDGET_MAX_NAME_LEN 2048
+#define BUDGET_MAX_DESCRIPTION_LEN 2048
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/backend/gda/gnc-commodity-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/backend/gda/gnc-commodity-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/backend/gda/gnc-commodity-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -49,12 +49,12 @@
 
 #define COMMODITIES_TABLE "commodities"
 
-#define COMMODITY_MAX_NAMESPACE_LEN 40
-#define COMMODITY_MAX_MNEMONIC_LEN 40
-#define COMMODITY_MAX_FULLNAME_LEN 100
-#define COMMODITY_MAX_CUSIP_LEN 50
-#define COMMODITY_MAX_QUOTESOURCE_LEN 50
-#define COMMODITY_MAX_QUOTE_TZ_LEN 50
+#define COMMODITY_MAX_NAMESPACE_LEN 2048
+#define COMMODITY_MAX_MNEMONIC_LEN 2048
+#define COMMODITY_MAX_FULLNAME_LEN 2048
+#define COMMODITY_MAX_CUSIP_LEN 2048
+#define COMMODITY_MAX_QUOTESOURCE_LEN 2048
+#define COMMODITY_MAX_QUOTE_TZ_LEN 2048
 
 static col_cvt_t col_table[] = {
     { "guid",         CT_GUID,   0,                             COL_NNUL|COL_PKEY, "guid" },

Modified: gnucash/branches/gda-dev2/src/backend/gda/gnc-price-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/backend/gda/gnc-price-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/backend/gda/gnc-price-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -44,8 +44,8 @@
 
 #define TABLE_NAME "prices"
 
-#define PRICE_MAX_SOURCE_LEN 50
-#define PRICE_MAX_TYPE_LEN 50
+#define PRICE_MAX_SOURCE_LEN 2048
+#define PRICE_MAX_TYPE_LEN 2048
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/backend/gda/gnc-recurrence-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/backend/gda/gnc-recurrence-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/backend/gda/gnc-recurrence-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -43,7 +43,7 @@
 
 #define TABLE_NAME "recurrences"
 
-#define BUDGET_MAX_RECURRENCE_PERIOD_TYPE_LEN 50
+#define BUDGET_MAX_RECURRENCE_PERIOD_TYPE_LEN 2048
 
 typedef struct {
     GncGdaBackend* be;

Modified: gnucash/branches/gda-dev2/src/backend/gda/gnc-schedxaction-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/backend/gda/gnc-schedxaction-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/backend/gda/gnc-schedxaction-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -48,7 +48,7 @@
 
 static QofLogModule log_module = G_LOG_DOMAIN;
 
-#define SX_MAX_NAME_LEN 50
+#define SX_MAX_NAME_LEN 2048
 
 static gpointer get_autocreate( gpointer pObject, const QofParam* param );
 static void set_autocreate( gpointer pObject, gpointer pValue );

Modified: gnucash/branches/gda-dev2/src/backend/gda/gnc-slots-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/backend/gda/gnc-slots-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/backend/gda/gnc-slots-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -70,8 +70,8 @@
 static gnc_numeric get_numeric_val( gpointer pObject, const QofParam* param );
 static void set_numeric_val( gpointer pObject, gnc_numeric value );
 
-#define SLOT_MAX_PATHNAME_LEN 500
-#define SLOT_MAX_STRINGVAL_LEN 1000
+#define SLOT_MAX_PATHNAME_LEN 4096
+#define SLOT_MAX_STRINGVAL_LEN 4096
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/backend/gda/gnc-transaction-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/backend/gda/gnc-transaction-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/backend/gda/gnc-transaction-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -57,8 +57,8 @@
     const GUID* guid;
 } split_info_t;
 
-#define TX_MAX_NUM_LEN 50
-#define TX_MAX_DESCRIPTION_LEN 500
+#define TX_MAX_NUM_LEN 2048
+#define TX_MAX_DESCRIPTION_LEN 2048
 
 static col_cvt_t tx_col_table[] =
 {
@@ -79,8 +79,8 @@
 static void set_split_reconcile_state( gpointer pObject, gpointer pValue );
 static void set_split_reconcile_date( gpointer pObject, Timespec ts );
 
-#define SPLIT_MAX_MEMO_LEN 50
-#define SPLIT_MAX_ACTION_LEN 50
+#define SPLIT_MAX_MEMO_LEN 2048
+#define SPLIT_MAX_ACTION_LEN 2048
 
 static col_cvt_t split_col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-address-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-address-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-address-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -43,11 +43,11 @@
 
 static QofLogModule log_module = G_LOG_DOMAIN;
 
-#define ADDRESS_MAX_NAME_LEN 50
-#define ADDRESS_MAX_ADDRESS_LINE_LEN 50
-#define ADDRESS_MAX_PHONE_LEN 40
-#define ADDRESS_MAX_FAX_LEN 40
-#define ADDRESS_MAX_EMAIL_LEN 40
+#define ADDRESS_MAX_NAME_LEN 1024
+#define ADDRESS_MAX_ADDRESS_LINE_LEN 1024
+#define ADDRESS_MAX_PHONE_LEN 128
+#define ADDRESS_MAX_FAX_LEN 128
+#define ADDRESS_MAX_EMAIL_LEN 256
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-bill-term-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-bill-term-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-bill-term-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -40,9 +40,9 @@
 
 static QofLogModule log_module = G_LOG_DOMAIN;
 
-#define MAX_NAME_LEN 50
-#define MAX_DESCRIPTION_LEN 50
-#define MAX_TYPE_LEN 50
+#define MAX_NAME_LEN 2048
+#define MAX_DESCRIPTION_LEN 2048
+#define MAX_TYPE_LEN 2048
 
 static void set_invisible( gpointer data, gpointer value );
 

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-customer-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-customer-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-customer-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -45,9 +45,9 @@
 
 #define TABLE_NAME "customers"
 
-#define MAX_NAME_LEN 50
-#define MAX_ID_LEN 50
-#define MAX_NOTES_LEN 50
+#define MAX_NAME_LEN 2048
+#define MAX_ID_LEN 2048
+#define MAX_NOTES_LEN 2048
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-employee-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-employee-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-employee-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -46,10 +46,10 @@
 
 static QofLogModule log_module = G_LOG_DOMAIN;
 
-#define MAX_USERNAME_LEN 50
-#define MAX_ID_LEN 50
-#define MAX_LANGUAGE_LEN 50
-#define MAX_ACL_LEN 50
+#define MAX_USERNAME_LEN 2048
+#define MAX_ID_LEN 2048
+#define MAX_LANGUAGE_LEN 2048
+#define MAX_ACL_LEN 2048
 
 #define TABLE_NAME "employees"
 

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-entry-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-entry-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-entry-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -47,11 +47,11 @@
 static QofLogModule log_module = G_LOG_DOMAIN;
 
 #define TABLE_NAME "entries"
-#define MAX_DESCRIPTION_LEN 50
-#define MAX_ACTION_LEN 50
-#define MAX_NOTES_LEN 50
-#define MAX_DISCTYPE_LEN 50
-#define MAX_DISCHOW_LEN 50
+#define MAX_DESCRIPTION_LEN 2048
+#define MAX_ACTION_LEN 2048
+#define MAX_NOTES_LEN 2048
+#define MAX_DISCTYPE_LEN 2048
+#define MAX_DISCHOW_LEN 2048
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-invoice-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-invoice-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-invoice-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -46,9 +46,9 @@
 
 #define TABLE_NAME "invoices"
 
-#define MAX_ID_LEN 50
-#define MAX_NOTES_LEN 100
-#define MAX_BILLING_ID_LEN 100
+#define MAX_ID_LEN 2048
+#define MAX_NOTES_LEN 2048
+#define MAX_BILLING_ID_LEN 2048
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-job-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-job-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-job-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -43,9 +43,9 @@
 
 #define TABLE_NAME "jobs"
 
-#define MAX_ID_LEN 50
-#define MAX_NAME_LEN 50
-#define MAX_REFERENCE_LEN 50
+#define MAX_ID_LEN 2048
+#define MAX_NAME_LEN 2048
+#define MAX_REFERENCE_LEN 2048
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-order-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-order-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-order-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -42,9 +42,9 @@
 
 #define TABLE_NAME "orders"
 
-#define MAX_ID_LEN 50
-#define MAX_NOTES_LEN 50
-#define MAX_REFERENCE_LEN 50
+#define MAX_ID_LEN 2048
+#define MAX_NOTES_LEN 2048
+#define MAX_REFERENCE_LEN 2048
 
 static col_cvt_t col_table[] =
 {

Modified: gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-vendor-gda.c
===================================================================
--- gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-vendor-gda.c	2008-02-24 19:36:29 UTC (rev 16957)
+++ gnucash/branches/gda-dev2/src/business/business-core/gda/gnc-vendor-gda.c	2008-02-24 19:57:28 UTC (rev 16958)
@@ -49,10 +49,10 @@
 
 static QofLogModule log_module = G_LOG_DOMAIN;
 
-#define MAX_NAME_LEN 50
-#define MAX_ID_LEN 50
-#define MAX_NOTES_LEN 100
-#define MAX_TAX_INC_LEN 50
+#define MAX_NAME_LEN 2048
+#define MAX_ID_LEN 2048
+#define MAX_NOTES_LEN 2048
+#define MAX_TAX_INC_LEN 2048
 
 #define TABLE_NAME "vendors"
 



More information about the gnucash-changes mailing list