## 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`);

ALTER TABLE `language` CHANGE `default` `isdefault` INT(2) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE `language` DROP `isdefault`;