RE: need advice on how to design tables for recurring events

2007-10-11 Thread Ramsey, Robert L
This and Frederic Wenzel's suggestions were exactly what I was looking for. Thanks! Bob > -Original Message- > From: Erich C. Beyrent [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 11, 2007 6:10 AM > To: mysql@lists.mysql.com > Subject: Re: need advice on how

Re: need advice on how to design tables for recurring events

2007-10-11 Thread Erich C. Beyrent
I've been working with Drupal for some time, and there is a module that allows you to create event-based content with a repeating schedule. The schema that it uses may be of some help to you. CREATE TABLE IF NOT EXISTS event_repeat ( rid int(10) unsigned NOT NULL default '0', repeat_data longt

Re: need advice on how to design tables for recurring events

2007-10-11 Thread Frederic Wenzel
On 10/10/07, Ramsey, Robert L <[EMAIL PROTECTED]> wrote: > I'm looking for a "best practices" way of creating tables to store both > one time and regularly repeating events. These are classes, so for the > most part the have a regularly recurring time, but we do have some one > off events. (...) >