liquid_feedback_core

annotate init.sql @ 624:82387194519b

Added code to suppress compiler warning (writing one byte into region of size 0)
author jbe
date Fri Feb 05 13:50:45 2021 +0100 (3 months ago)
parents 6fce4f08157b
children
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@97 5 INSERT INTO "unit" (
jbe@97 6 "active",
jbe@97 7 "name",
jbe@97 8 "description"
jbe@97 9 ) VALUES (
jbe@97 10 true,
jbe@97 11 'Default unit',
jbe@97 12 'Default unit created by init script.'
jbe@97 13 );
jbe@97 14
jbe@97 15
jbe@0 16 INSERT INTO "member" (
jbe@0 17 "login",
jbe@0 18 "password",
jbe@0 19 "active",
jbe@0 20 "admin",
lars@208 21 "name",
lars@208 22 "activated",
lars@208 23 "last_activity"
jbe@0 24 ) VALUES (
jbe@0 25 'admin',
jbe@9 26 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1',
jbe@0 27 TRUE,
jbe@0 28 TRUE,
lars@208 29 'Administrator',
lars@208 30 NOW(),
lars@208 31 NOW()
lars@208 32 );
jbe@0 33
jbe@0 34 INSERT INTO "policy" (
jbe@9 35 "index",
jbe@0 36 "active",
jbe@0 37 "name",
jbe@0 38 "description",
jbe@0 39 "admission_time",
jbe@0 40 "discussion_time",
jbe@7 41 "verification_time",
jbe@0 42 "voting_time",
jbe@0 43 "issue_quorum_num",
jbe@0 44 "issue_quorum_den",
jbe@0 45 "initiative_quorum_num",
jbe@0 46 "initiative_quorum_den"
jbe@0 47 ) VALUES (
jbe@9 48 1,
jbe@0 49 TRUE,
jbe@0 50 'Extensive proceeding',
jbe@0 51 DEFAULT,
jbe@0 52 '1 month',
jbe@7 53 '5 months',
jbe@7 54 '1 month',
jbe@0 55 '3 weeks',
jbe@7 56 10, 100,
jbe@7 57 10, 100
jbe@0 58 ), (
jbe@9 59 2,
jbe@0 60 TRUE,
jbe@0 61 'Standard proceeding',
jbe@0 62 DEFAULT,
jbe@7 63 '1 month',
jbe@0 64 '1 month',
jbe@0 65 '1 week',
jbe@7 66 '1 week',
jbe@7 67 10, 100,
jbe@7 68 10, 100
jbe@0 69 ), (
jbe@9 70 3,
jbe@0 71 TRUE,
jbe@0 72 'Fast proceeding',
jbe@0 73 DEFAULT,
jbe@7 74 '48 hours',
jbe@7 75 '3 hours',
jbe@7 76 '1 hour',
jbe@0 77 '20 hours',
jbe@7 78 1, 100,
jbe@0 79 1, 100 );
jbe@0 80
jbe@0 81 INSERT INTO "area" (
jbe@97 82 "unit_id",
jbe@0 83 "active",
jbe@0 84 "name",
jbe@0 85 "description"
jbe@0 86 ) VALUES (
jbe@97 87 1,
jbe@0 88 TRUE,
jbe@0 89 'Generic area',
jbe@0 90 DEFAULT );
jbe@0 91
jbe@0 92 COMMIT;

Impressum / About Us