1.1 --- a/demo.sql	Tue May 24 23:24:43 2011 +0200
     1.2 +++ b/demo.sql	Tue May 24 23:33:29 2011 +0200
     1.3 @@ -186,35 +186,6 @@
     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 @@ -276,70 +247,6 @@
    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"();