Re: setting foreign and primary key with contrib.sql ? how to setup db with un and pw?

[Stephen C. Gilardi]

On Jan 6, 2009, at 2:27 PM, ssecorp wrote:

On Jan 6, 8:12 pm, ssecorp <circularf...@gmail.com> wrote:

CREATE TABLE foo (
  col1 INTEGER NOT NULL,
  col2 VARCHAR(32) NOT NULL,
  col3 DATE NOT NULL,
  PRIMARY KEY (col1, col2)
);

how would I set primary key if it is a combination of 2 keys?

This appears to work:

(sql/create-table :foo
  [:col1 :integer :not :null]
  [:col2 "Varchar(32) :not :null]
  [:col3 "DATE" :not :null]
  ["primary key" "(col1, col2)"])

Can you confirm that?

I think your other examples can be done in a similar way.

--Steve

smime.p7s
Description: S/MIME cryptographic signature