r18243 - gnucash/trunk/src/backend/sql - For versions table, use table name as primary key, and disallow NULL values for both fields

[Phil Longstaff]

Author: plongstaff
Date: 2009-08-09 18:28:34 -0400 (Sun, 09 Aug 2009)
New Revision: 18243
Trac: http://svn.gnucash.org/trac/changeset/18243

Modified:
   gnucash/trunk/src/backend/sql/gnc-backend-sql.c
Log:
For versions table, use table name as primary key, and disallow NULL values for both fields


Modified: gnucash/trunk/src/backend/sql/gnc-backend-sql.c
===================================================================
--- gnucash/trunk/src/backend/sql/gnc-backend-sql.c	2009-08-09 22:26:01 UTC (rev 18242)
+++ gnucash/trunk/src/backend/sql/gnc-backend-sql.c	2009-08-09 22:28:34 UTC (rev 18243)
@@ -2635,8 +2635,8 @@
 static GncSqlColumnTableEntry version_table[] =
 {
 	/*@ -full_init_block @*/
-    { TABLE_COL_NAME,   CT_STRING, MAX_TABLE_NAME_LEN },
-	{ VERSION_COL_NAME, CT_INT },
+    { TABLE_COL_NAME,   CT_STRING, MAX_TABLE_NAME_LEN, COL_PKEY|COL_NNUL },
+	{ VERSION_COL_NAME, CT_INT,    0,                  COL_NNUL },
     { NULL }
 	/*@ +full_init_block @*/
 };