liquid_feedback_core
view update/core-update.beta23-beta24.sql @ 95:625f88e41125
Added tag v1.3.0 for changeset fb9688f31740
author | jbe |
---|---|
date | Mon Nov 08 01:46:58 2010 +0100 (2010-11-08) |
parents | c78ab22c4870 |
children |
line source
1 BEGIN;
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
4 SELECT * FROM (VALUES ('beta24', NULL, NULL, NULL))
5 AS "subquery"("string", "major", "minor", "revision");
7 COMMENT ON TABLE "setting" IS 'Place to store a frontend specific setting for members as a string';
9 COMMENT ON TABLE "member_relation_setting" IS 'Place to store a frontend specific setting related to relations between members as a string';
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 $$;
60 COMMIT;