site plan, calendar

15:00-19:00

• Wrote the site plan, rough draft.
• Came up with a usable design for the calendar.
• Helped Zeke with rte configuration.
  

calendar plan

Will serve ranged queries on date, using first, last date and optional event type. Schema is:

CREATE TABLE calendar (

event_id INT NOT NULL AUTO_INCREMENT UNIQUE,
start_date DATE NOT NULL,
start_time TIME NOT NULL,
end_date DATE,
end_time TIME,
event_type ENUM ('MUSIC', 'VISUAL', 'PERFORMANCE', etc),
event_name VARCHAR(100),
event_location VARCHAR(100),
html_text TEXT(2000)


PRIMARY KEY (event_id),
KEY(start_date)
);
Limitations of RTE mean that uploaded images must go in a directory named .../image, and must be named by hand. This means that a user (dynamic) image directory is required, which I will call
href="/uploads/image"