# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1499237530 -10800
# Node ID 907f2ddf6801f703edfb29b6add6d45c13871ac7
# Parent  2524434a7193218bdca5dafe9966fd18629b4e4c
Use #defines for SQL table field lengths.

diff -r 2524434a7193 -r 907f2ddf6801 src/main.cpp
--- a/src/main.cpp	Tue Jul 04 12:43:43 2017 +0300
+++ b/src/main.cpp	Wed Jul 05 09:52:10 2017 +0300
@@ -218,11 +218,14 @@
     {
         query.exec(QStringLiteral(
             "CREATE TABLE people (id INTEGER PRIMARY KEY, "
-            "first_name VARCHAR(128) NOT NULL, "
-            "last_name VARCHAR(128) NOT NULL, "
-            "extra_info VARCHAR(2048), "
+            "first_name VARCHAR(%1) NOT NULL, "
+            "last_name VARCHAR(%2) NOT NULL, "
+            "extra_info VARCHAR(%3), "
             "added DATETIME NOT NULL, "
-            "updated DATETIME NOT NULL)"));
+            "updated DATETIME NOT NULL)").
+            arg(SQL_MAX_FIRST_NAME).
+            arg(SQL_MAX_LAST_NAME).
+            arg(SQL_MAX_EXTRA_INFO));
 
         slCheckAndReportSQLError("CREATE TABLE people", query.lastError());
     }
@@ -855,6 +858,9 @@
     ui->tableview_Transactions->verticalHeader()->setVisible(false);
     ui->tableview_Transactions->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
 
+    ui->edit_FirstName->setMaxLength(SQL_MAX_FIRST_NAME);
+    ui->edit_LastName->setMaxLength(SQL_MAX_LAST_NAME);
+
     validateForm();
 }
 
diff -r 2524434a7193 -r 907f2ddf6801 src/main.h
--- a/src/main.h	Tue Jul 04 12:43:43 2017 +0300
+++ b/src/main.h	Wed Jul 05 09:52:10 2017 +0300
@@ -25,6 +25,11 @@
 #define APP_SQLITE_FILE   "syntilista.sqlite3"      // SQLite3 database file name (without path)
 
 
+#define SQL_MAX_FIRST_NAME 128
+#define SQL_MAX_LAST_NAME  128
+#define SQL_MAX_EXTRA_INFO 2048
+
+
 //
 // Custom SQL models
 //