[development] no date / time types in schema API

[Gerhard Killesreiter]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

augustin (beginner) schrieb:


> http://en.wikibooks.org/wiki/SQL_dialects_reference/Data_structure_definition/Data_types/Date_and_time_types
> All (but one) SQL dialects have a date type. 

> However, Drupal's Schema API does not seem to have a type for date
> only: http://drupal.org/node/159605
> 
> It causes schema.module to complain: no type for Schema type
> date:normal.  I am concerned that with the new Schema API, my
> modules may not install properly anymore. (how can it install a
> table where a column has an unsupported type?)

Just do a normal db_query. I've had to do that for event.module since
it needs a time type.

> Is this a purposeful omission? 

IIRC it was decided that "nobody needs it" or "it is too complicated
because of pgsql".

IMO it's a bug.

> How are you all coping with the lack of time/date data type? What
> workarounds do you use?

See event.install.


Cheers,
	Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIa1zUfg6TFvELooQRAhiGAKDD+LFNzxsHswjASEioEMahb6NElgCfX8yM
qaPIvws5zCsr64hPl7sz/tE=
=vmeQ
-----END PGP SIGNATURE-----