liquid_feedback_core

view update/core-update.v2.0.1-v2.0.2.sql @ 235:2a6984869ba3

Delete sessions:
- when they expire
- in function "delete_private_data" (security relevant in certain setups)
- in function "delete_member"

(Sessions had been removed in changeset ed2f94a397cd and re-added in changeset 4e3d8f1ca3a9 without mechanisms for deletion of sessions)
author jbe
date Tue Mar 13 18:04:53 2012 +0100 (2012-03-13)
parents 919d16c8e8e3
children
line source
1 BEGIN;
3 -- update version number:
4 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
5 SELECT * FROM (VALUES ('2.0.2', 2, 0, 2))
6 AS "subquery"("string", "major", "minor", "revision");
8 -- add column "authentication" to table "member":
9 ALTER TABLE "member" ADD COLUMN "authentication" TEXT;
10 COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated';
12 COMMIT;

Impressum / About Us