From a3cb015e6b69821062306981924a43a5487f3b5d Mon Sep 17 00:00:00 2001
From: deva <deva>
Date: Mon, 24 Sep 2007 12:47:16 +0000
Subject: Server now parses XML and handles include.

---
 server/src/database.cc | 20 ++++++++++----------
 1 file changed, 10 insertions(+), 10 deletions(-)

(limited to 'server/src/database.cc')

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;
-- 
cgit v1.2.3