Upgrading Obliquid from 0.8.0 to 0.8.1

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

Execute the following queries

INSERT INTO sl_security (id_security, ifq, ug, objtype) VALUES (174, 'user/userview::', 'g2', 's');

INSERT INTO sl_tabledesc (id_tabledesc, tablename, field, type, length, is_primary) VALUES (2590, 'persparms', 'id_module', 'integer', 0, 'Y');
INSERT INTO sl_tabledesc (id_tabledesc, tablename, field, type, length, is_primary) VALUES (2591, 'persparms', 'name', 'text', 100, 'Y');
INSERT INTO sl_tabledesc (id_tabledesc, tablename, field, type, length, is_primary) VALUES (2592, 'persparms', 'ug', 'text', 12, 'Y');
INSERT INTO sl_tabledesc (id_tabledesc, tablename, field, type, length, is_primary) VALUES (2593, 'persparms', 'setting', 'text', 255, 'N');
INSERT INTO sl_tabledesc (id_tabledesc, tablename, field, type, length, is_primary) VALUES (2594, 'persparms', 'priority', 'integer', 0, 'N');

CREATE TABLE `sl_persparms` (
  `id_module` int(11) NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `ug` varchar(12) NOT NULL default '',
  `setting` varchar(255) NOT NULL default '',
  `priority` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_module`,`name`,`ug`)
) TYPE=MyISAM;

ALTER TABLE `sl_group_group` CHANGE `id_son` `id_son` CHAR( 6 ) DEFAULT '0' NOT NULL;

UPDATE sl_tabledesc SET type='text', length=6 WHERE tablename='group_group' AND field='id_son';

At this point add security to access to user_roleadd and its slot