Forums / Cotonti / Extensions / Work In Progress - Events\Calendar Update

An updated Events\Calendar plugin

GHengeveld
#27551 2010-12-20 03:21

Team
Thanked: 52 times

There's also some changes in events table itself. Here's the structure of the two.
CREATE TABLE sed_events (
  event_id mediumint(8) unsigned NOT NULL auto_increment,
  event_date int(11) NOT NULL,
  event_state tinyint(1) NOT NULL default '0',
  event_cat varchar(16) NOT NULL default '0',
  event_maxparticipants int(6) NOT NULL default '0',
  event_usergroups_default varchar(255) NOT NULL default '0',
  event_usergroups_allowed varchar(255) NOT NULL default '0',
  event_repeat varchar(12) NOT NULL default 'disabled',
  event_lastoccurrence int(11) NOT NULL default '0',
  event_title varchar(64) NOT NULL default '',
  event_extra1 varchar(255) NOT NULL default '',
  event_extra2 varchar(255) NOT NULL default '',
  event_text text,
  event_url varchar(128) NOT NULL default '',
  event_ownerid int(11) NOT NULL default '0',
  event_alias varchar(24) NOT NULL default '',
  PRIMARY KEY  (event_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE sed_event_instances (
  instance_id int(11) NOT NULL auto_increment,
  instance_eventid int(11) NOT NULL,
  instance_number int(11) NOT NULL,
  instance_start int(11) NOT NULL,
  instance_end int(11) NOT NULL,
  instance_deadline int(11) NOT NULL,
  PRIMARY KEY  (instance_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;