liquid_feedback_core
annotate init.sql @ 532:5855ff9e5c8f
Several changes/additions for upcoming major release
- OAuth 2.0 support
- storing profiles as JSON document
- removed subject area membership
- revised snapshot system
- additional issue limiter (dynamic quorum in subject area)
- extended event logging in "event" table
- OAuth 2.0 support
- storing profiles as JSON document
- removed subject area membership
- revised snapshot system
- additional issue limiter (dynamic quorum in subject area)
- extended event logging in "event" table
| author | jbe |
|---|---|
| date | Thu Mar 30 19:42:38 2017 +0200 (2017-03-30) |
| parents | 6fce4f08157b |
| children |
| 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@97 | 5 INSERT INTO "unit" ( |
| jbe@97 | 6 "active", |
| jbe@97 | 7 "name", |
| jbe@97 | 8 "description" |
| jbe@97 | 9 ) VALUES ( |
| jbe@97 | 10 true, |
| jbe@97 | 11 'Default unit', |
| jbe@97 | 12 'Default unit created by init script.' |
| jbe@97 | 13 ); |
| jbe@97 | 14 |
| jbe@97 | 15 |
| jbe@0 | 16 INSERT INTO "member" ( |
| jbe@0 | 17 "login", |
| jbe@0 | 18 "password", |
| jbe@0 | 19 "active", |
| jbe@0 | 20 "admin", |
| lars@208 | 21 "name", |
| lars@208 | 22 "activated", |
| lars@208 | 23 "last_activity" |
| jbe@0 | 24 ) VALUES ( |
| jbe@0 | 25 'admin', |
| jbe@9 | 26 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1', |
| jbe@0 | 27 TRUE, |
| jbe@0 | 28 TRUE, |
| lars@208 | 29 'Administrator', |
| lars@208 | 30 NOW(), |
| lars@208 | 31 NOW() |
| lars@208 | 32 ); |
| jbe@0 | 33 |
| jbe@0 | 34 INSERT INTO "policy" ( |
| jbe@9 | 35 "index", |
| jbe@0 | 36 "active", |
| jbe@0 | 37 "name", |
| jbe@0 | 38 "description", |
| jbe@0 | 39 "admission_time", |
| jbe@0 | 40 "discussion_time", |
| jbe@7 | 41 "verification_time", |
| jbe@0 | 42 "voting_time", |
| jbe@0 | 43 "issue_quorum_num", |
| jbe@0 | 44 "issue_quorum_den", |
| jbe@0 | 45 "initiative_quorum_num", |
| jbe@0 | 46 "initiative_quorum_den" |
| jbe@0 | 47 ) VALUES ( |
| jbe@9 | 48 1, |
| jbe@0 | 49 TRUE, |
| jbe@0 | 50 'Extensive proceeding', |
| jbe@0 | 51 DEFAULT, |
| jbe@0 | 52 '1 month', |
| jbe@7 | 53 '5 months', |
| jbe@7 | 54 '1 month', |
| jbe@0 | 55 '3 weeks', |
| jbe@7 | 56 10, 100, |
| jbe@7 | 57 10, 100 |
| jbe@0 | 58 ), ( |
| jbe@9 | 59 2, |
| jbe@0 | 60 TRUE, |
| jbe@0 | 61 'Standard proceeding', |
| jbe@0 | 62 DEFAULT, |
| jbe@7 | 63 '1 month', |
| jbe@0 | 64 '1 month', |
| jbe@0 | 65 '1 week', |
| jbe@7 | 66 '1 week', |
| jbe@7 | 67 10, 100, |
| jbe@7 | 68 10, 100 |
| jbe@0 | 69 ), ( |
| jbe@9 | 70 3, |
| jbe@0 | 71 TRUE, |
| jbe@0 | 72 'Fast proceeding', |
| jbe@0 | 73 DEFAULT, |
| jbe@7 | 74 '48 hours', |
| jbe@7 | 75 '3 hours', |
| jbe@7 | 76 '1 hour', |
| jbe@0 | 77 '20 hours', |
| jbe@7 | 78 1, 100, |
| jbe@0 | 79 1, 100 ); |
| jbe@0 | 80 |
| jbe@0 | 81 INSERT INTO "area" ( |
| jbe@97 | 82 "unit_id", |
| jbe@0 | 83 "active", |
| jbe@0 | 84 "name", |
| jbe@0 | 85 "description" |
| jbe@0 | 86 ) VALUES ( |
| jbe@97 | 87 1, |
| jbe@0 | 88 TRUE, |
| jbe@0 | 89 'Generic area', |
| jbe@0 | 90 DEFAULT ); |
| jbe@0 | 91 |
| jbe@0 | 92 COMMIT; |