[MKDoc-dev] Events component, creating the Document_TimeRange table

[Sam Tregar]

On Tue, 19 Oct 2004, Bruno Postle wrote:

> > > You'll need to rebuild your database, or else create the new >
> > Document_TimeRange table by hand.
> 
> Ok, _this_ script seems to actually add the Document_TimeRange table to an
> existing running site (it had a stray "," before):
> 
>  CREATE TABLE IF NOT EXISTS Document_TimeRange (
>    ID int(11) NOT NULL auto_increment,
>    Document_ID int(11) default NULL,
>    FromDate datetime NOT NULL default '0000-00-00 00:00:00',
>    ToDate datetime NOT NULL default '0000-00-00 00:00:00',
>    PRIMARY KEY (ID)
>  ) TYPE=MyISAM;
> 
> MKDoc with the patch runs ok without the table, but has errors as expected if
> you try to create and save a TimeRange component.

Looks good, but it's missing the indexes.  Of course that won't matter
unless you dump a ton of data into it.  I'll put together a real
script soon.

-sam