CREATE GENERATOR G_AUTO_INC_WEB_ACCESS;
CREATE TABLE WEB_ACCESS (
    ID         UNIC NOT NULL /* UNIC = INTEGER NOT NULL */,
    ID_CITY    INT_ /* INT_ = INTEGER */,
    ID_USER    INT_ /* INT_ = INTEGER */,
    ID_DILLER  INT_ /* INT_ = INTEGER */
);
ALTER TABLE WEB_ACCESS ADD CONSTRAINT PK_WEB_ACCESS PRIMARY KEY (ID);
ALTER TABLE WEB_ACCESS ADD CONSTRAINT FK_WEB_ACCESS_2 FOREIGN KEY (ID_USER) REFERENCES WEB_USERS (ID) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE WEB_ACCESS ADD CONSTRAINT FK_WEB_ACCESS_3 FOREIGN KEY (ID_CITY) REFERENCES S_CITY (ID) ON DELETE CASCADE ON UPDATE CASCADE;

CREATE TRIGGER T_AUTO_INC_WEB_ACCESS FOR WEB_ACCESS
ACTIVE BEFORE INSERT POSITION  0 
AS
BEGIN
  IF( NEW.ID IS NULL )THEN
    NEW.ID = GEN_ID(G_AUTO_INC_WEB_ACCESS, 1 );
END