1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:

ALTER TABLE `bb1_smilies` ADD `catname` varchar(150) DEFAULT '' NOT NULL;

DROP TABLE IF EXISTS bb1_smilies_categorie;
CREATE TABLE bb1_smilies_categorie (
  catid int(3) NOT NULL auto_increment,
  catname varchar(100) NOT NULL default '',
  catorder int(3) unsigned NOT NULL default '0',
  catseite tinyint(1) NOT NULL default '0',
  counter int(5) NOT NULL default '0',
  standard tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (catid),
  KEY catid (catid)
) ENGINE=MyISAM;

INSERT INTO bb1_acpmenuitems VALUES("", "11", "smilie.php?action=catadd", "SMILIE_CATADD", "", "", "OR", "3", "2");
INSERT INTO bb1_acpmenuitems VALUES("", "11", "smilie.php?action=catview", "SMILIE_CATVIEW", "", "", "OR", "4", "2");