[Wplug-web] Announcements table(s)

Jeremy Dinsel jeremy at wplug.org
Mon Dec 10 22:14:02 EST 2001


I modified things so that we could do historical tracking on announcements
(similar to screenshots). A delete was removed from the announcements page and
the front page will now grab only the most recent announcements (in the past,
it had grabbed the only entry in the db).

mysql> describe announcements;
+----------------+---------+------+-----+---------+----------------+
| Field          | Type    | Null | Key | Default | Extra          |
+----------------+---------+------+-----+---------+----------------+
| serial         | int(11) |      | PRI | 0       | auto_increment |
| nextmeeting    | date    | YES  |     | NULL    |                |
| nextfest       | date    | YES  |     | NULL    |                |
| nextmeetingloc | blob    | YES  |     | NULL    |                |
| nextfestloc    | blob    | YES  |     | NULL    |                |
| comments       | blob    | YES  |     | NULL    |                |
| meetingdetails | blob    | YES  |     | NULL    |                |
| festdetails    | blob    | YES  |     | NULL    |                |
+----------------+---------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

mysql> describe sotw;
+-----------+------------+------+-----+---------+----------------+
| Field     | Type       | Null | Key | Default | Extra          |
+-----------+------------+------+-----+---------+----------------+
| serial    | int(11)    |      | PRI | 0       | auto_increment |
| file      | tinyblob   | YES  |     | NULL    |                |
| comment   | mediumblob | YES  |     | NULL    |                |
| thumb     | tinyblob   | YES  |     | NULL    |                |
| datestamp | int(11)    |      |     | 0       |                |
+-----------+------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)


-j
--
- Jeremy Dinsel
- somewhere in the monkey house




More information about the Wplug-web mailing list