<br />
<b>Deprecated</b>:  Assigning the return value of new by reference is deprecated in <b>/home/bluestat/public_html/source/index.php</b> on line <b>477</b><br />
## $Id$ ##

CREATE TABLE calendar
(
	calendarid int unsigned NOT NULL AUTO_INCREMENT,
	userid int unsigned NOT NULL,
	name varchar(250) NOT NULL,
	description text NULL,
	PRIMARY KEY (calendarid)
);

CREATE TABLE event
(
	eventid int unsigned NOT NULL AUTO_INCREMENT,
	calendarid int unsigned NOT NULL,
	userid int unsigned NOT NULL,
	name varchar(200) NOT NULL,
	description text NULL,
	pattern int unsigned NOT NULL,
	occurrence int unsigned NULL,
	startstamp int unsigned NOT NULL,
	endstamp int unsigned NOT NULL,
	allday bool NULL,
	PRIMARY KEY (eventid)
);

CREATE TABLE user
(
	userid int unsigned NOT NULL AUTO_INCREMENT,
	username varchar(250) NOT NULL,
	email varchar(250) NOT NULL,
	salt varchar(15) NOT NULL,
	password varchar(32) NOT NULL,
	authkey varchar(100) NOT NULL,
	calendarids text NULL,
	PRIMARY KEY (userid)
);