# HG changeset patch
# User Lars Winterfeld <lars.winterfeld@tu-ilmenau.de>
# Date 1319424304 25200
# Node ID 6fce4f08157bad27e7174478523dd1310c08ae55
# Parent  b8fa47ee5d82c000dc44cbaa5df83f67c5af9518
fix init.sql

error was:
ERROR:  new row for relation "member" violates check constraint "active_requires_activated_and_last_activity"

solution: init fields "activated" and "last_activity" with NOW()

diff -r b8fa47ee5d82 -r 6fce4f08157b init.sql
--- a/init.sql	Sat Oct 08 21:06:24 2011 +0200
+++ b/init.sql	Sun Oct 23 19:45:04 2011 -0700
@@ -18,13 +18,18 @@
         "password",
         "active",
         "admin",
-        "name"
+        "name",
+        "activated",
+        "last_activity"
     ) VALUES (
         'admin',
         '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1',
         TRUE,
         TRUE,
-        'Administrator' );
+        'Administrator',
+        NOW(),
+        NOW()
+    );
 
 INSERT INTO "policy" (
         "index",