1 files changed, 10 insertions, 10 deletions
diff --git a/server/src/database.cc b/server/src/database.cc
index 1d4915e..1a48925 100644
--- a/server/src/database.cc
+++ b/server/src/database.cc
@@ -62,7 +62,7 @@ int Database::post(Transaction &transaction)
         commit.macro + "', '" + 
         commit.version + "', '" + 
         now + "', '" + 
-        commit.user + "')";
+        transaction.user + "')";
       W.exec(sql);
 
       // Insert field entries
@@ -124,21 +124,21 @@ CREATE DATABASE pracro
 
 CREATE TABLE transactions
 (
-  "cpr" varchar(255),
-  "transaction" varchar(255),
-  "makro" varchar(255),
-  "version" varchar(255),
-  "timestamp" varchar(255),
-  "user" varchar(255)
+  "cpr" varchar(11),
+  "transaction" text,
+  "makro" text,
+  "version" text,
+  "timestamp" bigint,
+  "user" text
 ) 
 WITH OIDS;
 ALTER TABLE transactions OWNER TO pracro;
 
 CREATE TABLE fields
 (
-  "transaction" varchar(255),
-  "name" varchar(255),
-  "value" varchar(255)
+  "transaction" text,
+  "name" text,
+  "value" text
 ) 
 WITH OIDS;
 ALTER TABLE fields OWNER TO pracro;