[MKDoc-dev] Upgrading sites to use current 1.6 CVS

[Bruno Postle]

1.6 has some new user group functionality which involves upgrading 
existing sites.

Until we have an upgrade script, these are basic instructions for 
upgrading for anyone who wants to try the new functionality:

Create the missing tables using the attached SQL script:

   mysql -umkdoc1 -pmkdoc1 mkdoc1 \
     < create-missing-mkdoc-tables-1.6-timerange-groups.sql

These tables need database definition files which you need to copy 
from a freshly installed site:

   cd /path/to/example.com/su
   cp Document_TimeRange.def *Grp.def $SITE_DIR/su/

That's it.

-- 
Bruno
-------------- next part --------------
CREATE TABLE IF NOT EXISTS Document_TimeRange (
  ID int(11) NOT NULL auto_increment,
  Document_ID int(11) NOT NULL default '0',
  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),
  KEY DocIndex (Document_ID),
  KEY FromIndex (FromDate),
  KEY ToIndex (ToDate)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS Document_Grp (
  Document_ID int(11) NOT NULL default '0',
  Grp_ID int(11) NOT NULL default '0',
  PRIMARY KEY  (Document_ID,Grp_ID),
  KEY ReverseGrpDocumentIndex (Grp_ID,Document_ID)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS Editor_Grp (
  Editor_ID int(11) NOT NULL default '0',
  Grp_ID int(11) NOT NULL default '0',
  PRIMARY KEY  (Editor_ID,Grp_ID),
  KEY ReverseGrpEditorIndex (Grp_ID,Editor_ID)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS Grp (
  ID int(11) NOT NULL auto_increment,
  Name char(255) default NULL,
  Description char(255) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;