docs/schema_changes.sql

   1 ## SVN $Id$
   2
   3 ALTER TABLE `product` DROP `shortname`;
   4
   5 ALTER TABLE `usergroup` DROP `opentag`;
   6
   7 ALTER TABLE `usergroup` DROP `closetag`;
   8
   9 CREATE TABLE `fieldhelp` (
  10   `keystring` VARCHAR(255) NOT NULL,
  11   `title` VARCHAR(255) NOT NULL,
  12   `body` MEDIUMTEXT NOT NULL
  13 );
  14
  15 ALTER TABLE `fieldhelp` ADD PRIMARY KEY(`keystring`);
  16
  17 ALTER TABLE `language` CHANGE `default` `isdefault` INT(2) UNSIGNED NOT NULL DEFAULT '0';
  18
  19 ALTER TABLE `language` DROP `isdefault`;