liquid_feedback_core
changeset 208:6fce4f08157b
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()
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()
author | Lars Winterfeld <lars.winterfeld@tu-ilmenau.de> |
---|---|
date | Sun Oct 23 19:45:04 2011 -0700 (2011-10-23) |
parents | b8fa47ee5d82 |
children | 37bf1dcdb37a |
files | init.sql |
line diff
1.1 --- a/init.sql Sat Oct 08 21:06:24 2011 +0200 1.2 +++ b/init.sql Sun Oct 23 19:45:04 2011 -0700 1.3 @@ -18,13 +18,18 @@ 1.4 "password", 1.5 "active", 1.6 "admin", 1.7 - "name" 1.8 + "name", 1.9 + "activated", 1.10 + "last_activity" 1.11 ) VALUES ( 1.12 'admin', 1.13 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1', 1.14 TRUE, 1.15 TRUE, 1.16 - 'Administrator' ); 1.17 + 'Administrator', 1.18 + NOW(), 1.19 + NOW() 1.20 + ); 1.21 1.22 INSERT INTO "policy" ( 1.23 "index",