|
New custom table |
|
|
|
|
|
New custom table |
|
|
|
|
This wizard guides you through the process of creating a new custom table.
Step 1
On the first step of the wizard, you are asked to fill in the custom table's display name and code name. The code name is always preceded by a namespace which allows you to have different tables of the same name used in different contexts. Enter the following details:
| • | Custom table display name: People |
| • | Custom table code name: customtable.People |
and click Next to continue.
Step 2
In the second step, you are asked to fill in the database table name. A name in the format <namespace>_<code name> is pre-filled automatically. The primary key name cannot be changed by default. Using the check-boxes below, you can determine which of the default fields should be included in the table. The meanings of the fields are the following:
| • | 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 |
Leave default values for all parameters and click Next to continue.
Step 3
In the third step, the field editor that you should be already familiar with is displayed. Create three fields with the following parameters:
| • | Attribute name: FirstName |
| • | Attribute type: Text |
| • | Attribute size: 100 |
| • | Field caption: First name |
| • | Field type: Text box |
| • | Attribute name: LastName |
| • | Attribute type: Text |
| • | Attribute size: 100 |
| • | Field caption: Last name |
| • | Field type: Text box |
| • | Attribute name: DateOfBirth |
| • | Attribute type: Date and Time |
| • | Field caption: Date of birth |
| • | Field type: Calendar |
| • | Edit time: unchecked |
When you are finished, click Next to continue to the following step.
Step 4
On Step 4, you only have to select by which sites will the custom table be used. Check the Corporate Site check-box and click Next.
Step 5
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.
