liquid_feedback_core
annotate README @ 8:e6faf5ff83af
Version beta9
Added missing indicies on TSVECTOR fields
New field latest_snapshot_event in table issue specifying the type of the latest snapshot taken
Added weight field also for (intermediate) delegating members in snapshot and voter tables
Possibility for an initiative to specify a URL where an external discussion takes place (discussion_url)
Export concept for creating a database dump, without some non-public information (e.g. private contact data), including:
- Shell script lf_export
- Database function delete_private_data()
Field in member table to be used by a frontend to store information about hints being hidden by the user
Minor cleanup / New comments
Added missing indicies on TSVECTOR fields
New field latest_snapshot_event in table issue specifying the type of the latest snapshot taken
Added weight field also for (intermediate) delegating members in snapshot and voter tables
Possibility for an initiative to specify a URL where an external discussion takes place (discussion_url)
Export concept for creating a database dump, without some non-public information (e.g. private contact data), including:
- Shell script lf_export
- Database function delete_private_data()
Field in member table to be used by a frontend to store information about hints being hidden by the user
Minor cleanup / New comments
| author | jbe |
|---|---|
| date | Mon Nov 30 12:00:00 2009 +0100 (2009-11-30) |
| parents | 8d021cb5eaf4 |
| children | 92fc60ed705d |
| rev | line source |
|---|---|
| jbe@0 | 1 |
| jbe@0 | 2 Setup the database: |
| jbe@0 | 3 $ createdb liquid_feedback |
| jbe@0 | 4 $ psql -v ON_ERROR_STOP=1 -f core.sql liquid_feedback |
| jbe@0 | 5 |
| jbe@0 | 6 Optionally insert demo data: |
| jbe@0 | 7 $ psql -v ON_ERROR_STOP=1 -f demo.sql liquid_feedback |
| jbe@0 | 8 |
| jbe@0 | 9 Compile lf_update binary: |
| jbe@0 | 10 $ make |
| jbe@0 | 11 |
| jbe@0 | 12 If you wish, copy the created lf_update file to /usr/local/bin or a |
| jbe@0 | 13 similar directory. Ensure that "lf_update dbname=liquid_feedback" |
| jbe@0 | 14 is called regularly. On successful run, lf_update will not produce |
| jbe@0 | 15 any output and exit with code 0. |
| jbe@0 | 16 |
| jbe@0 | 17 NOTE: When writing to the database, some INSERTs must be executed |
| jbe@0 | 18 within the same transaction, e.g. issues can't exist without |
| jbe@0 | 19 an initiative and vice versa. |
| jbe@0 | 20 |
| jbe@8 | 21 To create an export file, which is containing all but private data, |
| jbe@8 | 22 you may use the lf_export shell-script: |
| jbe@8 | 23 $ lf_export liquid_feedback export.sql.gz |
| jbe@8 | 24 |
| jbe@0 | 25 To uninstall the software, delete the lf_update binary |
| jbe@0 | 26 and drop the database by entering the following command: |
| jbe@0 | 27 $ dropdb liquid_feedback |
| jbe@0 | 28 |