Managing
Top  Previous  Next

The main schema manager window gives you a list of defined schemas, and a set of commands that you may run on each of them. Every table in the database has at least one schema defined, some have 2 or 3. Schemas are mainly used by the system to draw input forms for you in the admin center, and for your visitors on the front end. Very often, you'll want 2 schemas for a given table so that you are able to hide certain information from your users, but reserve the right to edit that information in the admin center.


schema1

You may regenerate all table schemas at once, by using the "Regenerate" link.

You may create a schema for any table in the database that does not already have a schema, by entering the table name in the "Create" box, and hitting the "Go" button. Use this when you create a table manually.

For each Schema, you have the following options:

View / Edit
This option will let you "dig in" to the schema itself, where you can change the options, settings, and behaviour of the table.  

Re-Generate
This will regenerate the schema based on the table structure in the database. When a table is altered (ie: you add or delete a column), the schema definition is not automatically updated to reflect the change. Use this utility to redefine the schema to use the columns that are actually in the table. Any settings that you'd previously had will remain for all columns that exist in both the old and new table structure.  

Delete Schema
This will remove the schema definition from the database. This does NOT drop the table or affect your actual data in any way. It simply removes the schema definition (and perhaps your ability to use a form to enter data into the table).  

Copy Schema
This will make a copy of the schema, with a new name. Useful for creating multiple "input forms" for certain tables, to be used by different users.