This wizard guides you through the process of creating a new custom table.

 

Step 1

 

In the first step, you are asked to fill in the custom table's display name (used in Kentico CMS user interface) and code name (used in website code). The code name is always preceded by a namespace, which allows you to have different tables of the same name used in different contexts.

 

Step 2

 

In the second step, you are asked to fill in the database table name, i.e. the actual name of the table in the system database. A name in the <namespace>_<code name> format is pre-filled automatically. The primary key name can't be changed by default.

 

Using the check-boxes below, you can determine which of the default fields should be included in the table:

 

•ItemCreatedBy - user name of the user who created the item

•ItemCreatedWhen - date and time of when the item was created

•ItemModifiedBy - user name of the user who last modified the item

•ItemModifiedWhen - date and time of last modification

•ItemOrder - order of the item when table content list is displayed; the lower number, the earlier position in the list

 

Step 3

 

In the third step, the field editor is displayed. It lets you define which columns will be included in the database table.

 

Step 4

 

In Step 4, you only have to select in which sites will the custom table be available. Use the Add sites button to add required websites to the list.

 

Step 5

 

Step 5 offers you to configure indexing of data in the custom table by the Smart Search module.

 

In the top part, you can specify how items from this custom table will be displayed in search results:

 

•Title field - specifies which field will be used as the title of the result item

•Content field - specifies which field will be used for the content extract of the result item

•Image field - specifies which field will be used for the image of the result item

•Date field - specifies which field will be used for the date and time displayed with the result item

 

Lines of the table in the bottom part of the page represent fields defined on the Fields tab, while columns define the following:

 

•Content - if checked, content of the field will be indexed and searchable the standard way

•Searchable - if checked, content of the field will be searchable in format <field code name>:<searched phrase>, which searches only through the fields and not through the other fields

•Tokenized - indicates if the content of the field should be processed by the analyzer when indexing; the general rule is to use this for Content fields and not for Searchable fields

•Custom search name - relevant for Searchable fields; substitutes field code name in the <field code name>:<searched phrase> expression; if entered, the original code name can't be used

 

For more information about settings in this step, please refer to Developer's Guide -> Modules -> Smart search -> Obejct settings.

 

Step 6

 

The fifth step gives you an overview of what has been done automatically. To finish the wizard, click Finish. You will be redirected back to the list of custom tables in Site Manager -> Development -> Custom tables.

 

Detailed information about the Custom tables module can be found in Developer's Guide -> Modules -> Custom tables.

A complete example of creating a sample custom table is available in Developer's Guide -> Modules -> Custom tables -> Creating a new custom table.