liquid_feedback_core
diff demo.sql @ 184:af3d208e81be
Member deactivation based on last_activity instead of last_login
author | jbe |
---|---|
date | Fri Jul 29 20:26:45 2011 +0200 (2011-07-29) |
parents | 4c03ef70dd92 |
children |
line diff
1.1 --- a/demo.sql Fri Jul 29 16:04:17 2011 +0200 1.2 +++ b/demo.sql Fri Jul 29 20:26:45 2011 +0200 1.3 @@ -3,30 +3,30 @@ 1.4 1.5 BEGIN; 1.6 1.7 -INSERT INTO "member" ("activated", "active", "login", "name") VALUES 1.8 - ('now', TRUE, 'user1', 'User #1'), -- id 1 1.9 - ('now', TRUE, 'user2', 'User #2'), -- id 2 1.10 - ('now', TRUE, 'user3', 'User #3'), -- id 3 1.11 - ('now', TRUE, 'user4', 'User #4'), -- id 4 1.12 - ('now', TRUE, 'user5', 'User #5'), -- id 5 1.13 - ('now', TRUE, 'user6', 'User #6'), -- id 6 1.14 - ('now', TRUE, 'user7', 'User #7'), -- id 7 1.15 - ('now', TRUE, 'user8', 'User #8'), -- id 8 1.16 - ('now', TRUE, 'user9', 'User #9'), -- id 9 1.17 - ('now', TRUE, 'user10', 'User #10'), -- id 10 1.18 - ('now', TRUE, 'user11', 'User #11'), -- id 11 1.19 - ('now', TRUE, 'user12', 'User #12'), -- id 12 1.20 - ('now', TRUE, 'user13', 'User #13'), -- id 13 1.21 - ('now', TRUE, 'user14', 'User #14'), -- id 14 1.22 - ('now', TRUE, 'user15', 'User #15'), -- id 15 1.23 - ('now', TRUE, 'user16', 'User #16'), -- id 16 1.24 - ('now', TRUE, 'user17', 'User #17'), -- id 17 1.25 - ('now', TRUE, 'user18', 'User #18'), -- id 18 1.26 - ('now', TRUE, 'user19', 'User #19'), -- id 19 1.27 - ('now', TRUE, 'user20', 'User #20'), -- id 20 1.28 - ('now', TRUE, 'user21', 'User #21'), -- id 21 1.29 - ('now', TRUE, 'user22', 'User #22'), -- id 22 1.30 - ('now', TRUE, 'user23', 'User #23'); -- id 23 1.31 +INSERT INTO "member" ("activated", "last_activity", "active", "login", "name") VALUES 1.32 + ('now', 'now', TRUE, 'user1', 'User #1'), -- id 1 1.33 + ('now', 'now', TRUE, 'user2', 'User #2'), -- id 2 1.34 + ('now', 'now', TRUE, 'user3', 'User #3'), -- id 3 1.35 + ('now', 'now', TRUE, 'user4', 'User #4'), -- id 4 1.36 + ('now', 'now', TRUE, 'user5', 'User #5'), -- id 5 1.37 + ('now', 'now', TRUE, 'user6', 'User #6'), -- id 6 1.38 + ('now', 'now', TRUE, 'user7', 'User #7'), -- id 7 1.39 + ('now', 'now', TRUE, 'user8', 'User #8'), -- id 8 1.40 + ('now', 'now', TRUE, 'user9', 'User #9'), -- id 9 1.41 + ('now', 'now', TRUE, 'user10', 'User #10'), -- id 10 1.42 + ('now', 'now', TRUE, 'user11', 'User #11'), -- id 11 1.43 + ('now', 'now', TRUE, 'user12', 'User #12'), -- id 12 1.44 + ('now', 'now', TRUE, 'user13', 'User #13'), -- id 13 1.45 + ('now', 'now', TRUE, 'user14', 'User #14'), -- id 14 1.46 + ('now', 'now', TRUE, 'user15', 'User #15'), -- id 15 1.47 + ('now', 'now', TRUE, 'user16', 'User #16'), -- id 16 1.48 + ('now', 'now', TRUE, 'user17', 'User #17'), -- id 17 1.49 + ('now', 'now', TRUE, 'user18', 'User #18'), -- id 18 1.50 + ('now', 'now', TRUE, 'user19', 'User #19'), -- id 19 1.51 + ('now', 'now', TRUE, 'user20', 'User #20'), -- id 20 1.52 + ('now', 'now', TRUE, 'user21', 'User #21'), -- id 21 1.53 + ('now', 'now', TRUE, 'user22', 'User #22'), -- id 22 1.54 + ('now', 'now', TRUE, 'user23', 'User #23'); -- id 23 1.55 1.56 -- set password to "login" 1.57 UPDATE "member" SET "password" = '$1$PcI6b1Bg$2SHjAZH2nMLFp0fxHis.Q0';