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

Bruno Postle bruno at webarchitects.co.uk
Tue Oct 19 16:52:14 BST 2004


> > 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.

-- 
Bruno


More information about the MKDoc-dev mailing list