Attached a update file for wicked.sql.

Edwin Culp <[email protected]> Sat, 7 Aug 2004 09:15:20 -0500

Newsgroups	gmane.comp.horde.wicked
Message-ID	<[email protected]>

To use the new wicked, I made a minor mysql upgrade
diff that might be of use to others.  It worked for our
wiki's.   It's pretty minor.

ed

-- 
wicked mailing list - Join the hunt: http://horde.org/bounties/#wicked
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]

wickedsqldiff.txt (text/plain, 1.4 KB)

## mysqldiff 0.33
## 
## Run on Sat Aug  7 08:59:21 2004
##
## --- file: wicked.sql.diff
## +++ file: wicked.sql

ALTER TABLE wicked_history CHANGE COLUMN page_minorversion page_minorversion int(11) NOT NULL default '0'; # was int(11) default NULL
ALTER TABLE wicked_history CHANGE COLUMN page_majorversion page_majorversion smallint(6) NOT NULL default '0'; # was smallint(6) default NULL
ALTER TABLE wicked_history ADD PRIMARY KEY (page_name,page_majorversion,page_minorversion);
CREATE TABLE wicked_attachment_history (
  page_name varchar(100) NOT NULL default '',
  attachment_name varchar(100) NOT NULL default '',
  attachment_majorversion smallint(6) NOT NULL default '0',
  attachment_minorversion int(11) NOT NULL default '0',
  attachment_created int(11) NOT NULL default '0',
  change_author varchar(255) default NULL,
  change_log text,
  PRIMARY KEY  (page_name,attachment_name,attachment_majorversion,attachment_minorversion),
  KEY wicked_attachment_history_name_idx (page_name,attachment_name)
) TYPE=MyISAM;

CREATE TABLE wicked_attachments (
  page_name varchar(100) NOT NULL default '',
  attachment_name varchar(100) NOT NULL default '',
  attachment_hits int(11) default '0',
  attachment_majorversion smallint(6) default NULL,
  attachment_minorversion int(11) default NULL,
  attachment_created int(11) NOT NULL default '0',
  change_author varchar(255) default NULL,
  change_log text,
  PRIMARY KEY  (page_name,attachment_name)
) TYPE=MyISAM;