liquid_feedback_core

diff init.sql @ 7:69d84040fb93

find changesets by author, revision, files, or words in the commit message
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
author jbe
date Mon Nov 23 12:00:00 2009 +0100 (2009-11-23)
parents 8d021cb5eaf4
children 4af4df1415f9
line diff
     1.1 --- a/init.sql	Wed Nov 18 12:00:00 2009 +0100
     1.2 +++ b/init.sql	Mon Nov 23 12:00:00 2009 +0100
     1.3 @@ -8,16 +8,14 @@
     1.4          "password",
     1.5          "active",
     1.6          "admin",
     1.7 -        "name",
     1.8 -        "ident_number"
     1.9 +        "name"
    1.10      ) VALUES (
    1.11          DEFAULT,
    1.12          'admin',
    1.13          '',
    1.14          TRUE,
    1.15          TRUE,
    1.16 -        'Administrator',
    1.17 -        DEFAULT );
    1.18 +        'Administrator' );
    1.19  
    1.20  INSERT INTO "policy" (
    1.21          "id",
    1.22 @@ -26,6 +24,7 @@
    1.23          "description",
    1.24          "admission_time",
    1.25          "discussion_time",
    1.26 +        "verification_time",
    1.27          "voting_time",
    1.28          "issue_quorum_num",
    1.29          "issue_quorum_den",
    1.30 @@ -37,29 +36,32 @@
    1.31          'Extensive proceeding',
    1.32          DEFAULT,
    1.33          '1 month',
    1.34 -        '6 months',
    1.35 +        '5 months',
    1.36 +        '1 month',
    1.37          '3 weeks',
    1.38 -        5, 100,
    1.39 -        1, 100
    1.40 +        10, 100,
    1.41 +        10, 100
    1.42      ), (
    1.43          DEFAULT,
    1.44          TRUE,
    1.45          'Standard proceeding',
    1.46          DEFAULT,
    1.47 -        '1 week',
    1.48 +        '1 month',
    1.49          '1 month',
    1.50          '1 week',
    1.51 -        5, 100,
    1.52 -        1, 100
    1.53 +        '1 week',
    1.54 +        10, 100,
    1.55 +        10, 100
    1.56      ), (
    1.57         DEFAULT,
    1.58         TRUE,
    1.59         'Fast proceeding',
    1.60         DEFAULT,
    1.61 -       '24 hours',
    1.62 -       '4 hours',
    1.63 +       '48 hours',
    1.64 +       '3 hours',
    1.65 +       '1 hour',
    1.66         '20 hours',
    1.67 -        5, 100,
    1.68 +        1, 100,
    1.69          1, 100 );
    1.70  
    1.71  INSERT INTO "area" (

Impressum / About Us