liquid_feedback_core
annotate init.sql @ 9:4af4df1415f9
Version beta10
Voting will be skipped, if no initiative is admitted for voting
Invite code feature allows people having an invite code to create one account
Contingent system to limit the number of initiatives or text entries to be submitted by each member within a given time
Ability to store a formatting engine for each draft, which can be used to allow initiatives to choose between available wiki parsers
New table setting storing user settings for the frontend (replaced hidden_hints column of beta9)
Better policy support:
- New table allowed_policy to select which policies can be used in each area
- Policies are now ordered by an index field
Bugfixes:
- In function close_voting(...): If there were no voters, this resulted in a NULL value as positive and negative vote counts
- In delete_private_data() function: Secret fields of member table are now deleted too
- Major bug fixed in lf_export, which caused data loss on execution
Voting will be skipped, if no initiative is admitted for voting
Invite code feature allows people having an invite code to create one account
Contingent system to limit the number of initiatives or text entries to be submitted by each member within a given time
Ability to store a formatting engine for each draft, which can be used to allow initiatives to choose between available wiki parsers
New table setting storing user settings for the frontend (replaced hidden_hints column of beta9)
Better policy support:
- New table allowed_policy to select which policies can be used in each area
- Policies are now ordered by an index field
Bugfixes:
- In function close_voting(...): If there were no voters, this resulted in a NULL value as positive and negative vote counts
- In delete_private_data() function: Secret fields of member table are now deleted too
- Major bug fixed in lf_export, which caused data loss on execution
| author | jbe |
|---|---|
| date | Thu Dec 10 12:00:00 2009 +0100 (2009-12-10) |
| parents | 69d84040fb93 |
| children | 58451b5565ae |
| rev | line source |
|---|---|
| jbe@0 | 1 -- NOTE: This file creates an admin user with an empty password! |
| jbe@0 | 2 |
| jbe@0 | 3 BEGIN; |
| jbe@0 | 4 |
| jbe@0 | 5 INSERT INTO "member" ( |
| jbe@0 | 6 "login", |
| jbe@0 | 7 "password", |
| jbe@0 | 8 "active", |
| jbe@0 | 9 "admin", |
| jbe@7 | 10 "name" |
| jbe@0 | 11 ) VALUES ( |
| jbe@0 | 12 'admin', |
| jbe@9 | 13 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1', |
| jbe@0 | 14 TRUE, |
| jbe@0 | 15 TRUE, |
| jbe@7 | 16 'Administrator' ); |
| jbe@0 | 17 |
| jbe@0 | 18 INSERT INTO "policy" ( |
| jbe@9 | 19 "index", |
| jbe@0 | 20 "active", |
| jbe@0 | 21 "name", |
| jbe@0 | 22 "description", |
| jbe@0 | 23 "admission_time", |
| jbe@0 | 24 "discussion_time", |
| jbe@7 | 25 "verification_time", |
| jbe@0 | 26 "voting_time", |
| jbe@0 | 27 "issue_quorum_num", |
| jbe@0 | 28 "issue_quorum_den", |
| jbe@0 | 29 "initiative_quorum_num", |
| jbe@0 | 30 "initiative_quorum_den" |
| jbe@0 | 31 ) VALUES ( |
| jbe@9 | 32 1, |
| jbe@0 | 33 TRUE, |
| jbe@0 | 34 'Extensive proceeding', |
| jbe@0 | 35 DEFAULT, |
| jbe@0 | 36 '1 month', |
| jbe@7 | 37 '5 months', |
| jbe@7 | 38 '1 month', |
| jbe@0 | 39 '3 weeks', |
| jbe@7 | 40 10, 100, |
| jbe@7 | 41 10, 100 |
| jbe@0 | 42 ), ( |
| jbe@9 | 43 2, |
| jbe@0 | 44 TRUE, |
| jbe@0 | 45 'Standard proceeding', |
| jbe@0 | 46 DEFAULT, |
| jbe@7 | 47 '1 month', |
| jbe@0 | 48 '1 month', |
| jbe@0 | 49 '1 week', |
| jbe@7 | 50 '1 week', |
| jbe@7 | 51 10, 100, |
| jbe@7 | 52 10, 100 |
| jbe@0 | 53 ), ( |
| jbe@9 | 54 3, |
| jbe@0 | 55 TRUE, |
| jbe@0 | 56 'Fast proceeding', |
| jbe@0 | 57 DEFAULT, |
| jbe@7 | 58 '48 hours', |
| jbe@7 | 59 '3 hours', |
| jbe@7 | 60 '1 hour', |
| jbe@0 | 61 '20 hours', |
| jbe@7 | 62 1, 100, |
| jbe@0 | 63 1, 100 ); |
| jbe@0 | 64 |
| jbe@0 | 65 INSERT INTO "area" ( |
| jbe@0 | 66 "active", |
| jbe@0 | 67 "name", |
| jbe@0 | 68 "description" |
| jbe@0 | 69 ) VALUES ( |
| jbe@0 | 70 TRUE, |
| jbe@0 | 71 'Generic area', |
| jbe@0 | 72 DEFAULT ); |
| jbe@0 | 73 |
| jbe@0 | 74 COMMIT; |