SET SQL DIALECT 3;

CREATE DATABASE 'database_name'
USER 'SYSDBA' PASSWORD 'masterkey' ;


CREATE TABLE KLIENT (
ID INTEGER NOT NULL PRIMARY KEY,
LS INTEGER,
NT INTEGER,
F VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251,
I VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251,
O VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251,
RABON FLOAT);



CREATE TABLE PRIHOD (
ID_PRIHOD INTEGER NOT NULL PRIMARY KEY,
ID_S INTEGER NOT NULL,
SU FLOAT,
DA DATE DEFAULT 'NOW' NOT NULL,
PRIM VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251);

ALTER TABLE PRIHOD
ADD CONSTRAINT FK_KLIENT
FOREIGN KEY (ID_S) REFERENCES KLIENT (ID)
on update cascade ;


Все работает!