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?
Creating a Module?
-
- Support Guru
- Posts: 8169
- Joined: Tue Oct 19, 2004 6:44 pm
- Location: Fernie British Columbia, Canada
Re: Creating a Module?
See this link: http://phplens.com/lens/adodb/docs-datadict.htm
adodb doesn't support enums as a portable type from what I see.
adodb doesn't support enums as a portable type from what I see.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Re: Creating a Module?
Arrrggghhh... What to do then... Manually?
-
- Support Guru
- Posts: 8169
- Joined: Tue Oct 19, 2004 6:44 pm
- Location: Fernie British Columbia, Canada
Re: Creating a Module?
Yup, just use integers, or strings.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Re: Creating a Module?
Thanks... Have to do!