Le vendredi 13 août 2010 à 23:36 +0200, Hans De Bisschop a écrit :
> Hi all,
> 
> In preparation of the upcoming Chamilo 2.0 code sprint and as a part
> of on ongoing documentation effort, I wrote a 28-page document today
> about the rights management framework used in Chamilo 2.0. It should
> help developers understand the system and the philosophy behind it, as
> well as help them implement it in their own applications.
> 
> The result is now available via the Chamilo.org website.

As a short preliminary comment: please try not to use the confusing
int(10) or tinyint(3) notation. This is a MySQL (or even phpMyAdmin)
specific notation that means that the integer value will be shifted to
fill a corresponding display size of 10 or 3 characters. Nothing to do
with the actual size of the integer in memory or on disk (which I assume
you intend to represent here).

Instead, use the normal ANSI SQL-standard[1] values: integer or smallint
(tinyint is not *really* part of all versions of SQL and is only
supported by MySQL[2][3][4][5] as a one byte representation of an
integer).

Better use integer and smallint, anyway, and avoid the (10) or (3) or
(whatever) notation.

And so far it's a nice documentation

Yannick

[1] http://en.wikipedia.org/wiki/SQL
[2] http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html
[3] PostgreSQL - no tinyint
http://www.postgresql.org/docs/7.4/interactive/datatype.html#DATATYPE-INT
[4] Oracle - no tinyint
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/sql_elements001.htm#i54335
[5] MSSQL - tinyint http://webcoder.info/reference/MSSQLDataTypes.html



_______________________________________________
Dev mailing list
Dev@lists.chamilo.org
http://lists.chamilo.org/listinfo/dev

Reply via email to