how to add enum field using drupal_install_schema?

Posted by Rajan M on June 9, 2010 at 5:29am

Hello friends,

I want to create a table using drupal_install_schema, I have define all fields within schema but now I am not getting how to add enum type fields.
I can create this table by directly using query in hook_install( ) but i would like to do this in drupal way.

Thanks in advance.

Comments

Rajon, Have a look at the

Posted by yuriy.babenko on June 9, 2010 at 5:48pm

Rajon,

Have a look at the Schema module. This module provides the functionality to export the Drupal "schema" of any database table. You can use this module to export the schema of a table which contains an ENUM field type and see how it's done.

I have just done some quick searching and it appears that the ENUM field type is lacking from the schema API. There's a suggested workaround here, although it's not really a solution to the problem...

---
Yuriy Babenko
http://yuriybabenko.com
My Drupal tutorials: http://yuriybabenko.com/blog/tag/tutorials

Thanks Yuriy, I will try this.

Posted by Rajan M on June 10, 2010 at 4:55am

I will try this and let you know here.

Rajan
Open Source Developer

schema doesn't help :-(

Posted by njathan on June 17, 2010 at 4:32pm

I am trying the same. I have defined ENUMs in the table. And i had used the 'Inspect' tab in the schema module to copy the code to be pasted in hook_schema.

But it seems the module installation returns a error that the SQL syntax is incorrect.
Upon closely observing the code from the 'Inspect' tab, i see that though it does say 'type' => 'enum', it does not list the options of the enum.. a sample pasted below.. where the options for t_cooliris_float were (manually) defined to be Left, Right, Center and None in the database

		't_cooliris_method' => array(
		  'description' => t('Cooliris method for Teaser'),
		  'type' => 'enum',
		  'not null' => TRUE,
		  'default' => 'piclens',
		),
		't_cooliris_float' => array(
		  'description' => t('Float for Teaser'),
		  'type' => 'enum',
		  'not null' => TRUE,
		  'default' => 'Center',
		),
		't_cooliris_width' => array(
		  'description' => t('width for Teaser'),
		  'type' => 'int',
		  'unsigned' => TRUE,
		  'not null' => TRUE,
		  'default' => 320,

This post in the schema issue queue says that schema module cannot handle ENUMs.
Can someone think of an alternative way of defining ENUMs in drupal?
Alternatively, does drupal's hook_install() itself support enums at all?

edit: a closer look at the schema issue queue post... the limitation seems to be with the drupal schema api :-(

Query is last option for me.

Posted by Rajan M on June 21, 2010 at 4:23am

I also tried using schema module, but no success :-(
So i put query in my hook_install and hook_uninstall.

Rajan
Open Source Developer