1.1 --- a/core.sql	Fri Jul 29 15:23:42 2011 +0200
     1.2 +++ b/core.sql	Fri Jul 29 16:04:17 2011 +0200
     1.3 @@ -280,22 +280,6 @@
     1.4  COMMENT ON COLUMN "ignored_member"."other_member_id" IS 'Member being ignored';
     1.5  
     1.6  
     1.7 -CREATE TABLE "session" (
     1.8 -        "ident"                 TEXT            PRIMARY KEY,
     1.9 -        "additional_secret"     TEXT,
    1.10 -        "expiry"                TIMESTAMPTZ     NOT NULL DEFAULT now() + '24 hours',
    1.11 -        "member_id"             INT8            REFERENCES "member" ("id") ON DELETE SET NULL,
    1.12 -        "lang"                  TEXT );
    1.13 -CREATE INDEX "session_expiry_idx" ON "session" ("expiry");
    1.14 -
    1.15 -COMMENT ON TABLE "session" IS 'Sessions, i.e. for a web-frontend';
    1.16 -
    1.17 -COMMENT ON COLUMN "session"."ident"             IS 'Secret session identifier (i.e. random string)';
    1.18 -COMMENT ON COLUMN "session"."additional_secret" IS 'Additional field to store a secret, which can be used against CSRF attacks';
    1.19 -COMMENT ON COLUMN "session"."member_id"         IS 'Reference to member, who is logged in';
    1.20 -COMMENT ON COLUMN "session"."lang"              IS 'Language code of the selected language';
    1.21 -
    1.22 -
    1.23  CREATE TABLE "policy" (
    1.24          "id"                    SERIAL4         PRIMARY KEY,
    1.25          "index"                 INT4            NOT NULL,
    1.26 @@ -1958,16 +1942,6 @@
    1.27  COMMENT ON VIEW "battle_view" IS 'Number of members preferring one initiative (or status-quo) to another initiative (or status-quo); Used to fill "battle" table';
    1.28  
    1.29  
    1.30 -CREATE VIEW "expired_session" AS
    1.31 -  SELECT * FROM "session" WHERE now() > "expiry";
    1.32 -
    1.33 -CREATE RULE "delete" AS ON DELETE TO "expired_session" DO INSTEAD
    1.34 -  DELETE FROM "session" WHERE "ident" = OLD."ident";
    1.35 -
    1.36 -COMMENT ON VIEW "expired_session" IS 'View containing all expired sessions where DELETE is possible';
    1.37 -COMMENT ON RULE "delete" ON "expired_session" IS 'Rule allowing DELETE on rows in "expired_session" view, i.e. DELETE FROM "expired_session"';
    1.38 -
    1.39 -
    1.40  CREATE VIEW "open_issue" AS
    1.41    SELECT * FROM "issue" WHERE "closed" ISNULL;
    1.42  
    1.43 @@ -3976,7 +3950,6 @@
    1.44      DECLARE
    1.45        "issue_id_v" "issue"."id"%TYPE;
    1.46      BEGIN
    1.47 -      DELETE FROM "expired_session";
    1.48        PERFORM "check_last_login"();
    1.49        PERFORM "calculate_member_counts"();
    1.50        FOR "issue_id_v" IN SELECT "id" FROM "open_issue" LOOP
    1.51 @@ -4089,7 +4062,6 @@
    1.52        DELETE FROM "member_image"       WHERE "member_id" = "member_id_p";
    1.53        DELETE FROM "contact"            WHERE "member_id" = "member_id_p";
    1.54        DELETE FROM "ignored_member"     WHERE "member_id" = "member_id_p";
    1.55 -      DELETE FROM "session"            WHERE "member_id" = "member_id_p";
    1.56        DELETE FROM "area_setting"       WHERE "member_id" = "member_id_p";
    1.57        DELETE FROM "issue_setting"      WHERE "member_id" = "member_id_p";
    1.58        DELETE FROM "ignored_initiative" WHERE "member_id" = "member_id_p";
    1.59 @@ -4146,7 +4118,6 @@
    1.60        DELETE FROM "member_image";
    1.61        DELETE FROM "contact";
    1.62        DELETE FROM "ignored_member";
    1.63 -      DELETE FROM "session";
    1.64        DELETE FROM "area_setting";
    1.65        DELETE FROM "issue_setting";
    1.66        DELETE FROM "ignored_initiative";