[Wpigdc-cms-development] events tables

[Liam M. <lm...@WP...>]

Doing preliminary work on the events section. Here are the tables I've
created (following the format Dan outlined in his schema):

CREATE TABLE cms_event_group (
  cms_id INTEGER PRIMARY KEY,
  cms_name VARCHAR(64) NOT NULL,
  cms_location VARCHAR(128) NOT NULL,
  cms_url VARCHAR(255),
  cms_pairs TEXT
);

cms_pairs will be a string containing name/value pairs for those things to
be included for that event that we either haven't thought of or don't
apply to events in general.

I'll explain the name "event_group" below.

CREATE TABLE cms_event (
  cms_id INTEGER PRIMARY KEY,
  cms_start_date DATETIME NOT NULL,
  cms_end_date DATETIME NOT NULL,
  cms_pairs TEXT,
  cms_event_group INTEGER
);

Here is where the start date and end date are kept. As far as event_group
vs. event goes: I'll use an example. Say you've got an event (let's call
it "Kill 'em All 2001") spanning 2 days. The first day, it starts at 6pm
and lasts until 2am. The second day, it starts at 11am and lasts until
3pm. You want seperate information for each start/end date. So you
create 2 cms_event records and one cms_event_group record, with the 2
cms_events linked to the one cms_event_group. Of course this could go into
a name/value pair within cms_event_group, but I want to keep name/value
pair usage to a minimum (and if there's something that's getting placed in
name/value pairs often, I'd like to move it up and create an actual
attribute for it).

What I didn't include in here is any link to future work done in ACL's or
forums. These won't be in the database at all until after beta, and I'm
following Dan's example by keeping the db clean until it needs to get
dirtied. We can stage different schema versions over time without much of
a problem; this would be the desired approach in my eyes.

Also, I didn't include cms_groups either, although that does look
applicable. Dan, what's the purpose of cms_groups? You've got news linked
to it, is that something you intended to link news articles, events,
projects, and forums?

Comments are more than welcome.

Quick question: are there plans for ACL's for the beta? Or are we starting
out with all events/news articles accessible by all then going from there?

-------
Liam Morley

"light the deep, and bring silence to the world.
light the world, and bring depth to the silence."