liquid_feedback_core: init.sql annotate

liquid_feedback_core

annotate init.sql @ 14:ac7836ac00d9

Version beta15

Bugfix: Revoked initiatives will never be admitted

Possibility to recommend another initiative to support when revoking an initiative

Allow "initiator"."accepted" to be NULL (NULL means "no answer yet", while FALSE means "rejected")

author	jbe
date	Sun Jan 10 12:00:00 2010 +0100 (2010-01-10)
parents	4af4df1415f9
children	58451b5565ae

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 "login",
jbe@0	7 "password",
jbe@0	8 "active",
jbe@0	9 "admin",
jbe@7	10 "name"
jbe@0	11 ) VALUES (
jbe@0	12 'admin',
jbe@9	13 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1',
jbe@0	14 TRUE,
jbe@0	15 TRUE,
jbe@7	16 'Administrator' );
jbe@0	17
jbe@0	18 INSERT INTO "policy" (
jbe@9	19 "index",
jbe@0	20 "active",
jbe@0	21 "name",
jbe@0	22 "description",
jbe@0	23 "admission_time",
jbe@0	24 "discussion_time",
jbe@7	25 "verification_time",
jbe@0	26 "voting_time",
jbe@0	27 "issue_quorum_num",
jbe@0	28 "issue_quorum_den",
jbe@0	29 "initiative_quorum_num",
jbe@0	30 "initiative_quorum_den"
jbe@0	31 ) VALUES (
jbe@9	32 1,
jbe@0	33 TRUE,
jbe@0	34 'Extensive proceeding',
jbe@0	35 DEFAULT,
jbe@0	36 '1 month',
jbe@7	37 '5 months',
jbe@7	38 '1 month',
jbe@0	39 '3 weeks',
jbe@7	40 10, 100,
jbe@7	41 10, 100
jbe@0	42 ), (
jbe@9	43 2,
jbe@0	44 TRUE,
jbe@0	45 'Standard proceeding',
jbe@0	46 DEFAULT,
jbe@7	47 '1 month',
jbe@0	48 '1 month',
jbe@0	49 '1 week',
jbe@7	50 '1 week',
jbe@7	51 10, 100,
jbe@7	52 10, 100
jbe@0	53 ), (
jbe@9	54 3,
jbe@0	55 TRUE,
jbe@0	56 'Fast proceeding',
jbe@0	57 DEFAULT,
jbe@7	58 '48 hours',
jbe@7	59 '3 hours',
jbe@7	60 '1 hour',
jbe@0	61 '20 hours',
jbe@7	62 1, 100,
jbe@0	63 1, 100 );
jbe@0	64
jbe@0	65 INSERT INTO "area" (
jbe@0	66 "active",
jbe@0	67 "name",
jbe@0	68 "description"
jbe@0	69 ) VALUES (
jbe@0	70 TRUE,
jbe@0	71 'Generic area',
jbe@0	72 DEFAULT );
jbe@0	73
jbe@0	74 COMMIT;