Go to the first, previous, next, last section, table of contents.

Create a table

In the example used in this chapter, the urldemo table contains the data used in all the catalogs. Since your own application is likely to require a different kind of data you will have to create your own table.

A few requirements must be met when creating a table that will be used by catalogs (thematic, alphabetical or chronological).

• The table must contain a numerical field named rowid which is the primary key so that Catalog can use it. Here is a typical example:

  create table urldemo (
  ...
    rowid int autoincrement,
  ...
    unique urldemo1 (rowid)
  );
  
  

• The table field names must only be alphanumerical. Specifically it may not contain underscore which is a reserved character for Catalog.
• It is best if you take care not to use any field names used in the catalog administrative tables. Although this will never be a real problem, it will force you to always disambiguate the field names by prepending the name of the table in front of it. For a complete list of the field names used by Catalog, See section Catalog tables.

If you're not sure how to create a new table, please refer to the MySQL documentation. If you want to do it quick and dirty you can guess from the table creation listed in the Catalog tables chapter.

At present we will use the urldemo table, you don't have to worry about creating a new table.

Go to the first, previous, next, last section, table of contents.