Page 1 of 1

Creating a Module?

Posted: Wed Sep 19, 2007 7:25 pm
by jmansa
I'm trying to create a module and in my method.install.php file I want to create databases but has run into a problem. I want to create a field like this:

new_field ENUM(yes,no) DEFAULT no NOTNULL

But it seems like I'm using the wrong syntax for enum... Can anybody help me with this?

Re: Creating a Module?

Posted: Wed Sep 19, 2007 7:32 pm
by calguy1000
See this link: http://phplens.com/lens/adodb/docs-datadict.htm
adodb doesn't support enums as a portable type from what I see.

Re: Creating a Module?

Posted: Wed Sep 19, 2007 7:51 pm
by jmansa
Arrrggghhh... What to do then... Manually?

Re: Creating a Module?

Posted: Wed Sep 19, 2007 7:51 pm
by calguy1000
Yup, just use integers, or strings.

Re: Creating a Module?

Posted: Wed Sep 19, 2007 7:59 pm
by jmansa
Thanks... Have to do!