liquid_feedback_core
annotate init.sql @ 7:69d84040fb93
Version beta8
More attibutes in member table
Renamed column ident_number of member table to identification
Images of members are now stored in extra table member_image
Minor bugfix in init.sql: Added missing verification_time column
Full text index search support using PostgreSQL's TSVECTOR and TSQUERY datatypes
New function highlight(...), which helps to highlight matching words in search results
More attibutes in member table
Renamed column ident_number of member table to identification
Images of members are now stored in extra table member_image
Minor bugfix in init.sql: Added missing verification_time column
Full text index search support using PostgreSQL's TSVECTOR and TSQUERY datatypes
New function highlight(...), which helps to highlight matching words in search results
author | jbe |
---|---|
date | Mon Nov 23 12:00:00 2009 +0100 (2009-11-23) |
parents | 8d021cb5eaf4 |
children | 4af4df1415f9 |
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 "id", |
jbe@0 | 7 "login", |
jbe@0 | 8 "password", |
jbe@0 | 9 "active", |
jbe@0 | 10 "admin", |
jbe@7 | 11 "name" |
jbe@0 | 12 ) VALUES ( |
jbe@0 | 13 DEFAULT, |
jbe@0 | 14 'admin', |
jbe@0 | 15 '', |
jbe@0 | 16 TRUE, |
jbe@0 | 17 TRUE, |
jbe@7 | 18 'Administrator' ); |
jbe@0 | 19 |
jbe@0 | 20 INSERT INTO "policy" ( |
jbe@0 | 21 "id", |
jbe@0 | 22 "active", |
jbe@0 | 23 "name", |
jbe@0 | 24 "description", |
jbe@0 | 25 "admission_time", |
jbe@0 | 26 "discussion_time", |
jbe@7 | 27 "verification_time", |
jbe@0 | 28 "voting_time", |
jbe@0 | 29 "issue_quorum_num", |
jbe@0 | 30 "issue_quorum_den", |
jbe@0 | 31 "initiative_quorum_num", |
jbe@0 | 32 "initiative_quorum_den" |
jbe@0 | 33 ) VALUES ( |
jbe@0 | 34 DEFAULT, |
jbe@0 | 35 TRUE, |
jbe@0 | 36 'Extensive proceeding', |
jbe@0 | 37 DEFAULT, |
jbe@0 | 38 '1 month', |
jbe@7 | 39 '5 months', |
jbe@7 | 40 '1 month', |
jbe@0 | 41 '3 weeks', |
jbe@7 | 42 10, 100, |
jbe@7 | 43 10, 100 |
jbe@0 | 44 ), ( |
jbe@0 | 45 DEFAULT, |
jbe@0 | 46 TRUE, |
jbe@0 | 47 'Standard proceeding', |
jbe@0 | 48 DEFAULT, |
jbe@7 | 49 '1 month', |
jbe@0 | 50 '1 month', |
jbe@0 | 51 '1 week', |
jbe@7 | 52 '1 week', |
jbe@7 | 53 10, 100, |
jbe@7 | 54 10, 100 |
jbe@0 | 55 ), ( |
jbe@0 | 56 DEFAULT, |
jbe@0 | 57 TRUE, |
jbe@0 | 58 'Fast proceeding', |
jbe@0 | 59 DEFAULT, |
jbe@7 | 60 '48 hours', |
jbe@7 | 61 '3 hours', |
jbe@7 | 62 '1 hour', |
jbe@0 | 63 '20 hours', |
jbe@7 | 64 1, 100, |
jbe@0 | 65 1, 100 ); |
jbe@0 | 66 |
jbe@0 | 67 INSERT INTO "area" ( |
jbe@0 | 68 "id", |
jbe@0 | 69 "active", |
jbe@0 | 70 "name", |
jbe@0 | 71 "description" |
jbe@0 | 72 ) VALUES ( |
jbe@0 | 73 DEFAULT, |
jbe@0 | 74 TRUE, |
jbe@0 | 75 'Generic area', |
jbe@0 | 76 DEFAULT ); |
jbe@0 | 77 |
jbe@0 | 78 COMMIT; |