Upgrading Obliquid from 0.9.0 to 0.9.1

First of all overwrite all common files with the new ones. For example with unix shell cp -r obliquid-0.9.1/common/ obliquid-0.9.0/, or you can overwrite the common dir using ftp

Execute the following queries -- If your prefix is not sl_, adjust accordingly

CREATE TABLE _sequence_sl_tabledesc (
  sequence int(11) NOT NULL auto_increment,
  PRIMARY KEY  (sequence)
) TYPE=MyISAM AUTO_INCREMENT=100001;

INSERT INTO _sequence_sl_tabledesc VALUES (100000);

ALTER TABLE sl_doc_cat1 ADD id_parent INT NOT NULL;

CREATE TABLE _sequence_sl_doc_cat1_parent (
  sequence int(11) NOT NULL auto_increment,
  PRIMARY KEY  (sequence)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE sl_doc_cat1_parent (
  id_doc_cat1_parent int(11) NOT NULL default '0',
  name char(80) NOT NULL default '',
  UNIQUE KEY doc_cat1 (id_doc_cat1_parent)
) TYPE=MyISAM;

INSERT INTO sl_tabledesc (id_tabledesc, tablename, field, type, length, is_primary) VALUES (2705, 'doc_cat1', 'id_parent', 'integer', 0, 'N');
INSERT INTO sl_tabledesc (id_tabledesc, tablename, field, type, length, is_primary) VALUES (2706, 'doc_cat1_parent', 'id_doc_cat1_parent', 'integer', 0, 'Y');
INSERT INTO sl_tabledesc (id_tabledesc, tablename, field, type, length, is_primary) VALUES (2707, 'doc_cat1_parent', 'name', 'text', 80, 'N');

INSERT INTO sl_configparms (name, setting, description, id_module, ord) VALUES ('cat1_parent', 'N', 'Use category 1 with parent (doublecombo)', 5, 50);
INSERT INTO sl_configparms (name, setting, description, id_module, ord) VALUES ('signup_enable', 'Y', 'Allow guests to create a new user record.', 2, 15);

UPDATE sl_slotfield SET label = '#passwd' WHERE `d_slotfield = 422;

The new roles cal_view and cal_adm have been introduced. security_partial, security_full, doc_adm and site_conf have been modified.