Syntax

SQL commands are written in all capital letters.

SELECT * FROM
  ezuser
WHERE
  id='$user_id'
HAVING
  age > '42'
LIMIT 0,20

SELECT a, b as c FROM
  ezcontentobject,
  ezcontentobject_attribute,
  ezcontentobject_version
WHERE
  ezcontentobject.id = ezcontentobject_version.contentobject_id AND
  ezcontentobject.id = '42'
LIMIT 0, 20

Tables

Table names should be in English. The names should be grammatically correct. Table names with several words should be separated with capital letters.

Example:

ezuser
ezcontentobject_version
ezcontentclass_attribute

Row names should be named in a similar manner.

Example:

ezuser
{
  id int,
  first_name varchar(150),
  last_name varchar(150),
  login varchar(150)
}