liquid_feedback_core
annotate init.sql @ 295:69d6fba0f84c
Use EXCLUSIVE MODE table locks in function "lock_issue"("issue"."id")
Avoids deadlocks caused by explicit FOR UPDATE row locks when updating member statements and implicit FOR SHARE row locks when writing snapshots.
Avoids deadlocks caused by explicit FOR UPDATE row locks when updating member statements and implicit FOR SHARE row locks when writing snapshots.
| author | jbe |
|---|---|
| date | Thu Sep 13 17:02:22 2012 +0200 (2012-09-13) |
| 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; |