liquid_feedback_core

annotate init.sql @ 42:0dfc5e164b52

Save timestamps of last login and member deactivation; Deletion of suggestions with attached opinions now possible (on delete cascade)
author jbe
date Thu Mar 25 18:33:11 2010 +0100 (2010-03-25)
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;

Impressum / About Us