liquid_feedback_frontend

annotate db/vote-test.sql @ 10:72c5e0ee7c98

find changesets by author, revision, files, or words in the commit message
Version beta6

Bugfixes:
- Security fix: Every user was able to change the discussion URL of an initiative
- Creation of new issues in areas without default policies is now possible
- Members can now be sorted in different ways
- No error when trying to compare a draft with itself
- Added missing local statement to variable initialization in app/main/delegation/new.lua
- CSS flaw in initiative action bar fixed

New features:
- Possiblity to invite other users to become initiator
- Revokation of initiatives implemented
- Number of suggestions, supporters, etc. is shown on corresponding tabs of initiative view
- Members can now be sorted by account creation (default sorting is "newest first")
- Configuration option to create an automatic discussion link for all issues
- First draft of global timeline feature (not accessible via link yet)
- Custom stylesheet URL for users marked as developers

In area listing the number of closed issues is shown too

Renamed "author" field of initiative to "last author"

Removed wrongly included file app/main/member/_show_thumb.lua.orig in the distribution

Help texts updated
author bsw
date Sun Jan 10 12:00:00 2010 +0100 (2010-01-10)
parents 3bfb2fcf7ab9
children
rev   line source
bsw/jbe@0 1 BEGIN;
bsw/jbe@0 2
bsw/jbe@0 3 INSERT INTO "member" ("login", "name", "ident_number") VALUES
bsw/jbe@0 4 ('bernd', 'Bernd', '002'),
bsw/jbe@0 5 ('cesar', 'Cesar', '003'),
bsw/jbe@0 6 ('doris', 'Doris', '004'),
bsw/jbe@0 7 ('emil', 'Emil', '005'),
bsw/jbe@0 8 ('frank', 'Frank', '006'),
bsw/jbe@0 9 ('gerhard', 'Gerhard', '007'),
bsw/jbe@0 10 ('hugo', 'Hugo', '008'),
bsw/jbe@0 11 ('ines', 'Ines', '009'),
bsw/jbe@0 12 ('johann', 'Johann', '010'),
bsw/jbe@0 13 ('klaus', 'Klaus', '011'),
bsw/jbe@0 14 ('lisa', 'Lisa', '012'),
bsw/jbe@0 15 ('monika', 'Monika', '013'),
bsw/jbe@0 16 ('norbert', 'Norbert', '014'),
bsw/jbe@0 17 ('olaf', 'Olaf', '015'),
bsw/jbe@0 18 ('peter', 'Peter', '016'),
bsw/jbe@0 19 ('quinn', 'Quinn', '017'),
bsw/jbe@0 20 ('ralf', 'Ralf', '018'),
bsw/jbe@0 21 ('sabine', 'Sabine', '019'),
bsw/jbe@0 22 ('tobias', 'Tobias', '020'),
bsw/jbe@0 23 ('ulla', 'Ulla', '021'),
bsw/jbe@0 24 ('vincent', 'Vincent', '022'),
bsw/jbe@0 25 ('wolfgang', 'Wolfgang', '023'),
bsw/jbe@0 26 ('xavier', 'Xavier', '024'),
bsw/jbe@0 27 ('yoko', 'Yoko', '025'),
bsw/jbe@0 28 ('zareb', 'Zareb', '026');
bsw/jbe@0 29
bsw/jbe@0 30 INSERT INTO "issue" ("area_id", "policy_id") VALUES (1, 3);
bsw/jbe@0 31 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #1');
bsw/jbe@0 32 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #2');
bsw/jbe@0 33 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #3');
bsw/jbe@0 34 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #4');
bsw/jbe@0 35 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #5');
bsw/jbe@0 36 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #6');
bsw/jbe@0 37 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #7');
bsw/jbe@0 38 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #8');
bsw/jbe@0 39 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #9');
bsw/jbe@0 40 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #10');
bsw/jbe@0 41 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #11');
bsw/jbe@0 42 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #12');
bsw/jbe@0 43 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #13');
bsw/jbe@0 44 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #14');
bsw/jbe@0 45 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #15');
bsw/jbe@0 46 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #16');
bsw/jbe@0 47 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #17');
bsw/jbe@0 48 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #18');
bsw/jbe@0 49 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #19');
bsw/jbe@0 50 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #20');
bsw/jbe@0 51 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #21');
bsw/jbe@0 52 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #22');
bsw/jbe@0 53 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #23');
bsw/jbe@0 54 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #24');
bsw/jbe@0 55 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #25');
bsw/jbe@0 56 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #26');
bsw/jbe@0 57 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #27');
bsw/jbe@0 58 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #28');
bsw/jbe@0 59 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #29');
bsw/jbe@0 60 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #30');
bsw/jbe@0 61
bsw/jbe@0 62 INSERT INTO "draft" ("initiative_id", "content") SELECT "id", 'Lorem ipsum ...' FROM "initiative";
bsw/jbe@0 63 INSERT INTO "initiator" ("member_id", "initiative_id") SELECT 1, "id" FROM "initiative";
bsw/jbe@0 64 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") SELECT "member"."id", "initiative"."id", "initiative"."id" FROM "member", "initiative";
bsw/jbe@0 65
bsw/jbe@0 66 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 1, 1);
bsw/jbe@0 67 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 2, 2);
bsw/jbe@0 68 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 3, 3);
bsw/jbe@0 69 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 4, 4);
bsw/jbe@0 70 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 5, 5);
bsw/jbe@0 71 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 6, 6);
bsw/jbe@0 72 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 7, 7);
bsw/jbe@0 73 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 8, 8);
bsw/jbe@0 74 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 9, 9);
bsw/jbe@0 75 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 10, 10);
bsw/jbe@0 76 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 11, 11);
bsw/jbe@0 77 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 12, 12);
bsw/jbe@0 78 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 13, 13);
bsw/jbe@0 79 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 14, 14);
bsw/jbe@0 80 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 15, 15);
bsw/jbe@0 81 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 16, 16);
bsw/jbe@0 82 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 17, 17);
bsw/jbe@0 83 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 18, 18);
bsw/jbe@0 84 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 19, 19);
bsw/jbe@0 85 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 20, 20);
bsw/jbe@0 86 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 21, 21);
bsw/jbe@0 87 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 22, 22);
bsw/jbe@0 88 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 23, 23);
bsw/jbe@0 89 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 24, 24);
bsw/jbe@0 90 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 25, 25);
bsw/jbe@0 91 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 26, 26);
bsw/jbe@0 92 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 27, 27);
bsw/jbe@0 93 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 28, 28);
bsw/jbe@0 94 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 29, 29);
bsw/jbe@0 95 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 30, 30);
bsw/jbe@0 96
bsw/jbe@0 97 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 1, 2);
bsw/jbe@0 98 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 2, 1);
bsw/jbe@0 99 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 3, 3);
bsw/jbe@0 100 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 4, 4);
bsw/jbe@0 101 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 5, 5);
bsw/jbe@0 102 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 6, 6);
bsw/jbe@0 103 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 7, 7);
bsw/jbe@0 104 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 8, 8);
bsw/jbe@0 105 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 9, 9);
bsw/jbe@0 106 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 10, 10);
bsw/jbe@0 107 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 11, 11);
bsw/jbe@0 108 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 12, 12);
bsw/jbe@0 109 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 13, 13);
bsw/jbe@0 110 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 14, 14);
bsw/jbe@0 111 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 15, 15);
bsw/jbe@0 112 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 16, 16);
bsw/jbe@0 113 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 17, 17);
bsw/jbe@0 114 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 18, 18);
bsw/jbe@0 115 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 19, 19);
bsw/jbe@0 116 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 20, 20);
bsw/jbe@0 117 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 21, 21);
bsw/jbe@0 118 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 22, 22);
bsw/jbe@0 119 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 23, 23);
bsw/jbe@0 120 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 24, 24);
bsw/jbe@0 121 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 25, 25);
bsw/jbe@0 122 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 26, 26);
bsw/jbe@0 123 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 27, 27);
bsw/jbe@0 124 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 28, 28);
bsw/jbe@0 125 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 29, 29);
bsw/jbe@0 126 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 30, 30);
bsw/jbe@0 127
bsw/jbe@0 128
bsw/jbe@0 129 SELECT check_issues();
bsw/jbe@0 130 UPDATE issue SET frozen = now();
bsw/jbe@0 131
bsw/jbe@0 132 END;
bsw/jbe@0 133
bsw/jbe@0 134 -- UPDATE issue SET closed = now();

Impressum / About Us