# HG changeset patch
# User jbe
# Date 1299465266 -3600
# Node ID 2abc6bc59f06bf948699da7c15d47508704d3c36
# Parent  76ffbafb23b5e026e05d4f12b0915e4121cc8634
Added comments for columns of "event" table

diff -r 76ffbafb23b5 -r 2abc6bc59f06 core.sql
--- a/core.sql	Sat Mar 05 22:05:13 2011 +0100
+++ b/core.sql	Mon Mar 07 03:34:26 2011 +0100
@@ -724,7 +724,7 @@
 
 COMMENT ON TABLE "membership" IS 'Interest of members in topic areas';
 
-COMMENT ON COLUMN "membership"."autoreject"        IS 'TRUE = member votes against all initiatives, if he is neither direct_ or delegating_voter; Entries in the "interest" table can override this setting.';
+COMMENT ON COLUMN "membership"."autoreject" IS 'TRUE = member votes against all initiatives, if he is neither direct_ or delegating_voter; Entries in the "interest" table can override this setting.';
 
 
 CREATE TABLE "interest" (
@@ -1084,6 +1084,11 @@
 
 COMMENT ON TABLE "event" IS 'Event table, automatically filled by triggers';
 
+COMMENT ON COLUMN "event"."occurrence" IS 'Point in time, when event occurred';
+COMMENT ON COLUMN "event"."event"      IS 'Type of event (see TYPE "event_type")';
+COMMENT ON COLUMN "event"."member_id"  IS 'Member who caused the event, if applicable';
+COMMENT ON COLUMN "event"."state"      IS 'If issue_id is set: state of affected issue; If state changed: new state';
+
 
 
 ----------------------------------------------