SET TERM !!;

CREATE TABLE MSERETERNSPR(
ID INTEGER NOT NULL PRIMARY KEY,
NAME VARCHAR(1000) NOT NULL,
ISVISIBLE FIBBOOLEAN VARCHAR
 )!!

COMMENT ON TABLE MSERETERNSPR IS 'Справочник'!!
----------
COMMENT ON COLUMN  MSERETERNSPR.ID IS 'Идентификатор (ID)'!!
COMMENT ON COLUMN  MSERETERNSPR.ID IS 'Имя (NAME)'!!

GRANT SELECT ON MSERETERNSPR  TO PUBLIC!!
GRANT SELECT,INSERT,UPDATE,DELETE ON MSERETERNSPR TO ADMINISTRATOR!!
GRANT SELECT,INSERT,UPDATE,DELETE ON MSERETERNSPR TO DOCTOR!!