1 BEGIN;

2

3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS

4 SELECT * FROM (VALUES ('beta24', NULL, NULL, NULL))

5 AS "subquery"("string", "major", "minor", "revision");

6

7 COMMENT ON TABLE "setting" IS 'Place to store a frontend specific setting for members as a string';

8

9 COMMENT ON TABLE "member_relation_setting" IS 'Place to store a frontend specific setting related to relations between members as a string';

10

11 CREATE OR REPLACE FUNCTION "delete_private_data"()

12 RETURNS VOID

13 LANGUAGE 'plpgsql' VOLATILE AS $$

14 DECLARE

15 "issue_id_v" "issue"."id"%TYPE;

16 BEGIN

17 UPDATE "member" SET

18 "login" = 'login' || "id"::text,

19 "password" = NULL,

20 "notify_email" = NULL,

21 "notify_email_unconfirmed" = NULL,

22 "notify_email_secret" = NULL,

23 "notify_email_secret_expiry" = NULL,

24 "password_reset_secret" = NULL,

25 "password_reset_secret_expiry" = NULL,

26 "organizational_unit" = NULL,

27 "internal_posts" = NULL,

28 "realname" = NULL,

29 "birthday" = NULL,

30 "address" = NULL,

31 "email" = NULL,

32 "xmpp_address" = NULL,

33 "website" = NULL,

34 "phone" = NULL,

35 "mobile_phone" = NULL,

36 "profession" = NULL,

37 "external_memberships" = NULL,

38 "external_posts" = NULL,

39 "statement" = NULL;

40 -- "text_search_data" is updated by triggers

41 UPDATE "member_history" SET "login" = 'login' || "member_id"::text;

42 DELETE FROM "invite_code";

43 DELETE FROM "setting";

44 DELETE FROM "setting_map";

45 DELETE FROM "member_relation_setting";

46 DELETE FROM "member_image";

47 DELETE FROM "contact";

48 DELETE FROM "session";

49 DELETE FROM "area_setting";

50 DELETE FROM "issue_setting";

51 DELETE FROM "initiative_setting";

52 DELETE FROM "suggestion_setting";

53 DELETE FROM "direct_voter" USING "issue"

54 WHERE "direct_voter"."issue_id" = "issue"."id"

55 AND "issue"."closed" ISNULL;

56 RETURN;

57 END;

58 $$;

59

60 COMMIT;