Changeset 1130

Timestamp:

Sep 3, 2008 8:36:02 AM (5 years ago)

Author:

dkg

Message:

recording individual interests, and person creation timestamps

File:

• trunk/jpdd/sql/db.sql (modified) (1 diff)

trunk/jpdd/sql/db.sql

@@ -1012 +1012 @@
 CREATE UNIQUE INDEX person_email_ci_unique ON person (lower(email));
 ALTER TABLE person DROP CONSTRAINT person_email_unique;
+
+-- record what date the person was created:
+
+ALTER TABLE person ADD COLUMN created_on timestamp with time zone; 
+UPDATE person SET created_on = now();
+ALTER TABLE person ALTER COLUMN created_on SET DEFAULT now();
+ALTER TABLE person ALTER COLUMN created_on SET NOT NULL;
+
+-- allow recording of a person's subject interests independently of
+-- their workshop attendance:
+
+CREATE TABLE person_interest (person_id integer NOT NULL REFERENCES
+person(id), category_id integer NOT NULL REFERENCES category(id));