|
From: Wesley L. R. <we...@cm...> - 2009-05-12 17:35:37
|
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 > |