Changeset 89

Timestamp:

Jan 12, 2007 11:12:36 AM (6 years ago)

Author:

dkg

Message:

JPDD: added proper tables to the database for mailings, user tracking, and password resets. updated homepage a little bit.

Location:

trunk/jpdd

Files:

• snippets/footer.default.html (modified) (1 diff)
• snippets/home.default.html (modified) (1 diff)
• sql/db.sql (modified) (6 diffs)

trunk/jpdd/snippets/footer.default.html

@@ -1 @@
-<div class="attribution">site code developed by <a href="http://www.fifthhorseman.net/">dkg</a></div>
+<div class="attribution">site code developed by <a href="http://www.fifthhorseman.net/">dkg</a> for the <a href="http://performanceassessment.org/">New York Performance Standards Consortium</a></div>

trunk/jpdd/snippets/home.default.html

@@ -1 @@
-<div class="narrow"><p>There will be a Professional Development Day for New York City
-teachers at <a href="http://jrec.org/">the Julia Richman Education
-Complex</a> on 31 January, 2007.
+<div class="narrow"><p>The <a
+href="http://performanceassessment.org/">New York Performance
+Standards Consortium</a> will be hosting a Professional Development
+Day for New York City teachers at <a href="http://jrec.org/">the Julia
+Richman Education Complex</a> on 31 January, 2007.
 
 <p>You can see the workshops that will be offered on that day, and if

trunk/jpdd/sql/db.sql

@@ -85 +85 @@
 
 ALTER TABLE public.log OWNER TO dkg;
+
+--
+-- Name: mail_log; Type: TABLE; Schema: public; Owner: dkg; Tablespace: 
+--
+
+CREATE TABLE mail_log (
+    id serial NOT NULL,
+    mail_from character varying NOT NULL,
+    mail_to character varying NOT NULL,
+    subject character varying NOT NULL,
+    body text NOT NULL,
+    extra_headers character varying,
+    whattime timestamp with time zone DEFAULT now() NOT NULL
+);
+
+
+ALTER TABLE public.mail_log OWNER TO dkg;
 
 --
@@ -113 +130 @@
     session_touched timestamp with time zone,
     session_created timestamp with time zone,
+    resetpass character varying(30),
+    resetpass_created timestamp with time zone,
     CONSTRAINT person_email_check CHECK (((email)::text <> ''::text)),
     CONSTRAINT person_first_name_check CHECK (((first_name)::text <> ''::text)),
@@ -133 +152 @@
 
 ALTER TABLE public.person_privilege OWNER TO dkg;
+
+--
+-- Name: post_log; Type: TABLE; Schema: public; Owner: dkg; Tablespace: 
+--
+
+CREATE TABLE post_log (
+    id serial NOT NULL,
+    person_id integer,
+    whattime timestamp with time zone DEFAULT now() NOT NULL,
+    from_ip inet NOT NULL,
+    request character varying NOT NULL,
+    "action" character varying,
+    "type" character varying
+);
+
+
+ALTER TABLE public.post_log OWNER TO dkg;
 
 --
@@ -246 +282 @@
 
 --
+-- Name: mail_log_pkey; Type: CONSTRAINT; Schema: public; Owner: dkg; Tablespace: 
+--
+
+ALTER TABLE ONLY mail_log
+    ADD CONSTRAINT mail_log_pkey PRIMARY KEY (id);
+
+
+--
 -- Name: no_double_attendance; Type: CONSTRAINT; Schema: public; Owner: dkg; Tablespace: 
 --
@@ -302 +346 @@
 
 --
+-- Name: post_log_pkey; Type: CONSTRAINT; Schema: public; Owner: dkg; Tablespace: 
+--
+
+ALTER TABLE ONLY post_log
+    ADD CONSTRAINT post_log_pkey PRIMARY KEY (id);
+
+
+--
 -- Name: privilege_name_key; Type: CONSTRAINT; Schema: public; Owner: dkg; Tablespace: 
 --
@@ -403 +455 @@
 ALTER TABLE ONLY person_privilege
     ADD CONSTRAINT person_privilege_privilege_id_fkey FOREIGN KEY (privilege_id) REFERENCES privilege(id);
+
+
+--
+-- Name: post_log_person_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dkg
+--
+
+ALTER TABLE ONLY post_log
+    ADD CONSTRAINT post_log_person_id_fkey FOREIGN KEY (person_id) REFERENCES person(id);