Tutorials > Content management > Add content managed resources to the Catalog service module
Update the workspaces write schema
In this lesson, you run the UpdateWorkspaceSchema script to create the custom tables in all of the workspaces. If you change to the WebSphere Commerce database schema, such as adding a new table, these changes must also be made in the workspace schemas. This tool allows you to recalibrate the workspace schemas with the master database schema. Without recalibration, the workspaces will not work with your new changes to the base schema.
Procedure
- Stop the WebSphere Commerce Server.
- From command line, Run ANT
target: UpdateWorkspacesSchema to create the necessary tables
and views in the workspaces for the tables you have configured.
WCDE_INSTALL\bin\updateWorkspacesSchema.bat
You should see the following message:
Update schema was successful
- Connect to the development database, and run the following
SQL query:
select * from wcw101.XWARRANTY;
You should get zero rows returned, but the empty table should have the following columns:
CATENTRY_ID WARTERM WARTYPE CONTENT_STATUS CONTENT_TASKGRP OPTCOUNTER CONTENT_TASK
Register the change control insert more command for the custom access profiles. The InsertMoreNounChangeControlMetaDataCmdImpl looks up the locking information for a noun and adds the locking information to the response. Locking information is used by Management Center to flag objects as read-only or not read-only. Since the previous tutorial Tutorial: Adding new fields in the Catalogs tool customized the Catalogs tool to use custom access profiles, the InsertMoreNounChangeControlMetaDataCmdImpl must be registered to return locking information.
- Run the following SQL query:
insert into cmdreg ( storeent_id, interfacename, classname ) values ( 0, 'com.ibm.commerce.catalog.facade.server.commands.InsertMoreCatalogEntryDataCmd+MyCompany_All.0', 'com.ibm.commerce.foundation.server.command.bod.bom.InsertMoreNounChangeControlMetaDataCmdImpl');