Changeset 70 for trunk

Timestamp:

10/25/2007 06:35:34 PM (15 months ago)

Author:

cmccurdy

Message:

fixed errors in transfers table creation

Files:

• trunk/src/database.c (modified) (2 diffs)

trunk/src/database.c

@@ -107 +107 @@
         value varchar(50));\n\
     create table transfers(\n\
-        trans_id1 integer primary key,\n\
-        trans_id2 integer primary key);\n\
+        trans_id1 integer,\n\
+        trans_id2 integer,\n\
+        unique ( trans_id1, trans_id2 ));\n\
     insert into options values ('last_used','-1');\n\
     insert into options values ('db_version','3');\n\
@@ -218 +219 @@
 
         char *new_table = sqlite3_mprintf( "create table transfers(\n\
-            trans_id1 integer primary key,\n\
-            trans_id2 integer primary key)" );
+            trans_id1 integer,\n\
+            trans_id2 integer,\n\
+            unique ( trans_id1, trans_id2 ))" );
 
         char *errmsg = 0;