Table Editor

This page will show you all the fields currently in the table and allow you to order them as well as add, modify or erase fields.

Table Name	This is the name of the table and in brackets will be the number of records that are currently saved in the table
Database Type	This is the type of database you are currently using. The options are file or database and this can be toggled from the main Admin > Database Editor page.
Table Prefix	This will be appended to the front of your table name. If you are using a flat file, it will be at the beginning of the file name like this: db_account.cgi
Description	This will describe the table.
Default Search Fields	These are the fields that keyword searches will look in. This works for both the search that appears on published pages and search fields in the admin program. For example, if you are in db_articles and have title, summary and content, keyword searching from within admin and keyword searching from the published pages will only look in these three fields.
Default Sort Fields	These are the fields that will be used to sort the records in this table. It will effect both lists that are published and in the internal fields. For example, the Article Editor and your index pages will display articles in the same order based on the values in this field. You can have multiple values in this field so the lists are furhter sorted when two records have the same value in the field.

After this, there are 5 columns:

Order
This is the order that the field appear in on the editor page for this table. By default they are spread out 10 apart and you can adjust the numbers however you like.

Field Name / Placeholder
This is the name of the field as well as the placeholder name. The placeholder is what will be used on your templates to display the value of this field.

Stored as
This is the type of data that is being stored in the field.

Displayed as
This is how the value in this field will be displayed on the editor pages and published pages.

Action
This lets you know what options you have. There will be "system field" which means you shouldn't edit the properties of that field, "modify" which will let you edit the properties and "erase" which will let you erase the entire field.

Creating/Editing a field's properties

There are actually several types of fields that you can create here. Depending on which type you select, there will be different options for you to choose from. Every field though, will share the same first seven fields:

Database table
this is the table you are currently working in

Field Label This is the label that will appear on the editor pages for this field

Field Name This is what the fields placeholder will be called.

Field Type
This is where you can select what type the field will be. The different types are detailed below.

Field Attributes
Hidden: the field will not show up on the editor pages, but will be available to your templates.
Not Editable: will appear on the editor pages, but its value will not be editable.

Stored as
This is the type of data that is being stored in the field.