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