liquid_feedback_core: init.sql annotate

liquid_feedback_core

Version beta17

New view timeline

More indicies (for timeline)

New table setting_map to store more complicated frontend user settings

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;