liquid_feedback_core
annotate README @ 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 | e6faf5ff83af |
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@0 | 21 To uninstall the software, delete the lf_update binary |
jbe@0 | 22 and drop the database by entering the following command: |
jbe@0 | 23 $ dropdb liquid_feedback |
jbe@0 | 24 |