Re: [SQL] problem with uniques and foreing keys

2006-05-06 Thread Stephan Szabo
On Sat, 6 May 2006, kernel.alert kernel.alert wrote: > I create the follow tables... > > > > CREATE TABLE empresa ( > id_empresa integer NOT NULL primary key, > nombre varchar(45), > ); > CREATE TABLE casino ( > i

Re: [SQL] problem with uniques and foreing keys

2006-05-06 Thread kernel.alert kernel.alert
Sorry i had a mistake in the post it was with the definition of the primary key in the empresa table...I'm having the same error when i build the last table...thanks for your answers...  Hi list...Please i have a problem with this... I create the follow tables...

Re: [SQL] problem with uniques and foreing keys

2006-05-06 Thread Bruno Wolff III
On Sat, May 06, 2006 at 12:27:41 -0500, "kernel.alert kernel.alert" <[EMAIL PROTECTED]> wrote: > Hi list... > > Please i have a problem with this... > > I create the follow tables... > > > > CREATE TABLE empresa ( > id_empresa

Re: [SQL] problem with uniques and foreing keys

2006-05-06 Thread Terry Lee Tucker
On Saturday 06 May 2006 01:27 pm, "kernel.alert kernel.alert" <[EMAIL PROTECTED]> thus communicated: --> Hi list... --> --> Please i have a problem with this... --> --> I create the follow tables... --> --> --> --> CREATE TABLE empresa ( -->

[SQL] problem with uniques and foreing keys

2006-05-06 Thread kernel.alert kernel.alert
Hi list...Please i have a problem with this...I create the follow tables...CREATE TABLE empresa (  id_empresa integer  NOT NULL primary key,   nombre varchar(45),);CREATE TABLE casino (  id_casino  integer  NOT NULL