# Updating your database schema

Next, you need to update your database schema.

Use the appropriate tools for your database vendor. If you are using the HSQL database (which is not recommended for production), you must use a tool such as SQuirrel SQL to modify your database.

To update your database schema:

Make the following changes:

- Change endeca_bookmarks_portlets.portletId to `varchar(500)`.
- Change endeca_metadata.key to `varchar(250)`.
- Change endeca_metadata_property.key to `varchar(250)`.

For example, in MySQL, using the MySQL Workbench or Administrator and assuming a schema named df, you would enter the following:

    ALTER TABLE df.endeca_bookmarks_portlets MODIFY COLUMN portletId varchar(500);
    ALTER TABLE df.endeca_metadata MODIFY COLUMN key_ varchar(250);
    ALTER TABLE df.endeca_metadata_property MODIFY COLUMN key_ varchar(250);