the backend is now running on the freepic server. so it's possible to test the export function of hCalendar and hCard.

http://fhvcha1349.fh.funpic.de/vccal/admin/

i'll try to keep this up to date to the current programming progress.

hey guys, where's the design???

Month


Week


Day

The requirements from the programming are almost fulfilled - we're now already over time. But doesn't matter???
Where's the design? Haven't heard anything today, though we had arranged a meeting.

i've set up the database and already done some scripting for filling the tables. i've also added the thickbox-script that provides the input forms inside the page without reloading.

goto page

Hopefully this is the last version of our database structure:

CREATE TABLE events (
id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(50),
description TEXT,
startTime TIME,
startDate DATE,
endTime TIME,
endDate DATE,
linkage TINYTEXT,
institution SMALLINT UNSIGNED,
location TEXT,
category SMALLINT UNSIGNED,
prize DECIMAL(3,2),
active CHAR(1),
PRIMARY KEY(id));

CREATE TABLE institutions (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
logo VARCHAR(50),
linkage TINYTEXT,
description TEXT,
telephone TINYTEXT,
cellphone TINYTEXT,
street TINYTEXT,
zip INT(10),
city VARCHAR(50),
email TINYTEXT,
PRIMARY KEY(id));

CREATE TABLE categories (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
icon VARCHAR(50),
description TEXT,
PRIMARY KEY(id));

I at the moment asked Markus from the Information Service to install a GUI (phpMyAdmin) for the database administration. He sees no problem. :-)

cause there is no GUI for the administration of the database, i've set up it manally in the command line (terminal on osx).

CREATE TABLE events (
id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(50),
description TEXT,
startTime TIME,
startDate DATE,
endTime TIME,
endDate DATE,
linkage TINYTEXT,
institution SMALLINT UNSIGNED,
prize DECIMAL(3,2),
active CHAR(1),
PRIMARY KEY(id));

CREATE TABLE institution (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
logo BLOB,
linkage TINYTEXT,
description TEXT,
telephone TINYTEXT,
cellphone TINYTEXT,
email TINYTEXT,
PRIMARY KEY(id));