# Sql120640_5 CREATE TABLE calusers (userid varchar(25) NOT NULL default '', password varchar(25) NOT NULL default '', rights tinyint(4) NOT NULL default '0', PRIMARY KEY (userid), UNIQUE KEY userid (userid), KEY userid_2 (userid)) TYPE=MyISAM; INSERT INTO calusers VALUES ('admin', 'admin', 2); CREATE TABLE recurring (id int(10) unsigned NOT NULL auto_increment, weekday tinyint(4) NOT NULL default '0', eventtime time NOT NULL default '25:00:00', schedule enum('weekly','monthly','yearly') NOT NULL default 'weekly', period tinyint(4) default NULL, month tinyint(4) default NULL, shortevent varchar(50) NOT NULL default '', longevent varchar(255) NOT NULL default '', userid varchar(25) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY id (id), KEY weekday (weekday), KEY eventtime (eventtime)) TYPE=MyISAM; CREATE TABLE bydate (id int(10) unsigned NOT NULL auto_increment, eventdate date NOT NULL default '0000-00-00', eventtime time NOT NULL default '25:00:00', shortevent varchar(50) NOT NULL default '', longevent varchar(255) NOT NULL default '', userid varchar(25) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY id (id), KEY eventdate (eventdate), KEY eventtime (eventtime)) TYPE=MyISAM;