[wicked] Attached a update file for wicked.sql.

[Edwin Culp]

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

-------------- next part --------------
## 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;