====== Database structure convention ======

Each table must have a unique index (Primary Key) named with the following convention: id<tablename>.

To create this index with MySQL you create an integer field with name id<tablename> and with option auto_increment and set it as a PRIMARY KEY.
<code sql>
 CREATE TABLE person (
 idperson INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY
 ); 
</code>
Here is an example of how to create the index with PostgreSQL :
<code sql>
CREATE TABLE person (
  idperson   SERIAL,
  name TEXT
);
</code>
 It is automatically translated into this:
<code sql>
CREATE SEQUENCE person_idperson_seq;
CREATE TABLE person (
  idperson INT4 NOT NULL DEFAULT nextval('person_idperson_seq'),
  name TEXT
);
CREATE UNIQUE INDEX person_id_key ON person ( id );
</code>


For each field you've created, you will need to map it to a field type in the registry by creating or editing the registry file for that table.