Santrope
Дата: 10.09.2005 11:07:01
При SQL запросе ругается на foreign key (id2) references users; и выдает ошибку : Parsing Error Invalid statement on line 35 constraint usersabon Foreign key (id2) references users
create table users
( id int not null primary key,
fam char(20),
name char(20),
otch char(20),
foto blob,
datar date,
dataz date,
other char(30));
Create generator gusersid;
set generator gusersid to 1;
create trigger tusersid for users
Active
before insert
As
begin
new.id= gen_id(gusersid, 1);
end;
create table abon
( id int not null primary key,
id2 int not null,
vidzan char(2),
vidabon char(2),
Kolich smallint,
summa int,
datan date,
datak date,
numbera int,
other char(30));
constraint usersabon
foreign key (id2) references users;
Create generator gabonid;
set generator gabonid to 1;
create trigger tabonid for abon
Active
before insert
As
begin
new.id= gen_id(gabonid, 1);
end;