## SVN $Id$

ALTER TABLE `product` DROP `shortname`;

ALTER TABLE `usergroup` DROP `opentag`;

ALTER TABLE `usergroup` DROP `closetag`;

CREATE TABLE `fieldhelp` (
  `keystring` VARCHAR(255) NOT NULL, 
  `title` VARCHAR(255) NOT NULL, 
  `body` MEDIUMTEXT NOT NULL
);

ALTER TABLE `fieldhelp` ADD PRIMARY KEY(`keystring`);