Re: [Andro-general] Postgres question

[Wesley L. R. <we...@cm...>]

Hi Don
I'm not necessarily going to be running it on Postgresql but Drupal 
supports it and I don't want to screw that up for people who do run it.
My question it basically do I use tinyint, or should I say int and give 
it a size, or does Postgresql have a boolean type/how does

Wes

Donald J. Organ IV wrote:
> Can I ask why you are looking to run Drupal on Postgresql?
>
>
> ----- Original Message -----
> From: "Wesley L. Roepken" <we...@cm...>
> To: "Andromeda" <and...@li...>
> Sent: Tuesday, May 12, 2009 1:11:50 PM GMT -05:00 US/Canada Eastern
> Subject: [Andro-general] Postgres question
>
> Hi all
> I'm not that familiar with postgres and need a little help so that my 
> project can support it properly. I need to make sure that my create 
> table statement will work, after that Drupal's db abstraction layer will 
> handle all other calls correctly. How would you rework this to conform 
> to postgres? or is it fine the way it is?
>
> CREATE TABLE spamicide (
>         form_id varchar(128) NOT NULL,
>         form_field varchar(64) NOT NULL default 'feed_me',
>         enabled tinyint NOT NULL default 0,
>         removable tinyint NOT NULL default 1,
>         PRIMARY KEY (form_id)
>         );
>
> TIA
> Wes
>