1.1 --- a/demo.sql	Tue May 24 23:33:29 2011 +0200
     1.2 +++ b/demo.sql	Tue May 24 23:35:29 2011 +0200
     1.3 @@ -186,6 +186,35 @@
     1.4  INSERT INTO "opinion" ("member_id", "suggestion_id", "degree", "fulfilled") VALUES
     1.5    (19, 1, 2, FALSE);
     1.6  
     1.7 +INSERT INTO "issue" ("area_id", "policy_id") VALUES
     1.8 +  (4, 1);  -- id 2
     1.9 +
    1.10 +INSERT INTO "initiative" ("issue_id", "name") VALUES
    1.11 +  (2, 'Initiative A'),  -- id 8
    1.12 +  (2, 'Initiative B');  -- id 9
    1.13 +
    1.14 +INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES
    1.15 +  (8, 1, 'Lorem ipsum...'),  -- id 8
    1.16 +  (9, 2, 'Lorem ipsum...');  -- id 9
    1.17 +
    1.18 +INSERT INTO "initiator" ("initiative_id", "member_id") VALUES
    1.19 +  (8, 1),
    1.20 +  (9, 2);
    1.21 +
    1.22 +INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES
    1.23 +  (1, 8, 8),
    1.24 +  (1, 9, 9),
    1.25 +  (2, 8, 8),
    1.26 +  (2, 9, 9),
    1.27 +  (3, 8, 8),
    1.28 +  (3, 9, 9),
    1.29 +  (4, 8, 8),
    1.30 +  (4, 9, 9),
    1.31 +  (5, 8, 8),
    1.32 +  (5, 9, 9),
    1.33 +  (6, 8, 8),
    1.34 +  (6, 9, 9);
    1.35 +
    1.36  SELECT "time_warp"();
    1.37  SELECT "time_warp"();
    1.38  SELECT "time_warp"();
    1.39 @@ -247,6 +276,70 @@
    1.40    (20, 1, 5,  1),
    1.41    (21, 1, 5, -1);
    1.42  
    1.43 +INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
    1.44 +  ( 1, 2),
    1.45 +  ( 2, 2),
    1.46 +  ( 3, 2),
    1.47 +  ( 4, 2),
    1.48 +  ( 5, 2),
    1.49 +  ( 6, 2),
    1.50 +  ( 7, 2),
    1.51 +  ( 8, 2),
    1.52 +  ( 9, 2),
    1.53 +  (10, 2),
    1.54 +  (11, 2),
    1.55 +  (12, 2),
    1.56 +  (13, 2),
    1.57 +  (14, 2),
    1.58 +  (15, 2),
    1.59 +  (16, 2),
    1.60 +  (17, 2),
    1.61 +  (18, 2),
    1.62 +  (19, 2),
    1.63 +  (20, 2);
    1.64 +
    1.65 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
    1.66 +  ( 1, 2, 8,  2),
    1.67 +  ( 1, 2, 9,  1),
    1.68 +  ( 2, 2, 8,  2),
    1.69 +  ( 2, 2, 9,  1),
    1.70 +  ( 3, 2, 8,  2),
    1.71 +  ( 3, 2, 9,  1),
    1.72 +  ( 4, 2, 8,  2),
    1.73 +  ( 4, 2, 9,  1),
    1.74 +  ( 5, 2, 8,  2),
    1.75 +  ( 5, 2, 9,  1),
    1.76 +  ( 6, 2, 8,  2),
    1.77 +  ( 6, 2, 9,  1),
    1.78 +  ( 7, 2, 8,  2),
    1.79 +  ( 7, 2, 9,  1),
    1.80 +  ( 8, 2, 8,  2),
    1.81 +  ( 8, 2, 9,  1),
    1.82 +  ( 9, 2, 8,  2),
    1.83 +  ( 9, 2, 9,  1),
    1.84 +  (10, 2, 8, -1),
    1.85 +  (10, 2, 9,  1),
    1.86 +  (11, 2, 8, -1),
    1.87 +  (11, 2, 9,  1),
    1.88 +  (12, 2, 8, -1),
    1.89 +  (12, 2, 9,  1),
    1.90 +  (13, 2, 8, -1),
    1.91 +  (13, 2, 9,  1),
    1.92 +  (14, 2, 8, -1),
    1.93 +  (14, 2, 9,  1),
    1.94 +  (15, 2, 8, -1),
    1.95 +  (15, 2, 9,  1),
    1.96 +  (16, 2, 8, -1),
    1.97 +  (16, 2, 9,  1),
    1.98 +  (17, 2, 8, -1),
    1.99 +  (17, 2, 9, -2),
   1.100 +  (18, 2, 8, -1),
   1.101 +  (18, 2, 9, -2),
   1.102 +  (19, 2, 8, -1),
   1.103 +  (19, 2, 9, -2),
   1.104 +  (20, 2, 8, -1),
   1.105 +  (20, 2, 9, -2);
   1.106 +
   1.107  SELECT "time_warp"();
   1.108  
   1.109  DROP FUNCTION "time_warp"();