iBase.ru Forum

Код: Выделить всё

CREATE TABLE ClientS
(
	Id INTEGER NOT NULL,
	Name VARCHAR (20),

	PRIMARY KEY (Id)
);

CREATE TABLE Photo
(
	Id INTEGER NOT NULL,
	Photo BLOB sub_type 0 segment size 80,
	Client_Fk INTEGER NOT NULL,

	PRIMARY KEY (Id)
);

CREATE GENERATOR Photo_gen;
CREATE GENERATOR Client_gen;

ALTER TABLE Photo ADD CONSTRAINT fkPhoto FOREIGN KEY (Client_Fk)
REFERENCES ClientS (Id) ON DELETE CASCADE ON UPDATE CASCADE;