Hi,
On Mon, 22 Apr 2002, Jacob Vennervald Madsen wrote:
> CREATE TABLE "alarm_schedule" (
> "alarm_schedule_id" SERIAL NOT NULL,
> "day_of_week" int2 NOT NULL,
> "user_id" int4 NOT NULL,
> "send_email" bool NOT NULL,
> "send_sms" bool NOT NULL,
> PRIMARY KEY ("alarm_schedule_id"),
> FOREIGN KEY "user_id" REFERENCES smartlight_user ("user_id")
> );
This works:
CREATE TABLE "alarm_schedule" (
"alarm_schedule_id" SERIAL NOT NULL,
"day_of_week" int2 NOT NULL,
"user_id" int4 NOT NULL,
"send_email" bool NOT NULL,
"send_sms" bool NOT NULL,
PRIMARY KEY ("alarm_schedule_id"),
FOREIGN KEY ("user_id") REFERENCES smartlight_user(user_id)
);
Just a parenthesis ;)
Best regards.
--
Devrim GUNDUZ
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net
Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------
