--
-- f_schemainfo
--
DROP TABLE IF EXISTS f_schemainfo;

create table f_schemainfo (
    schemaname       varchar(255) not null,
    description      varchar(255),
    owner            varchar(255) not null,
    creationdate     timestamp,
    schemaversionid  numeric(5,3) not null,
    tableowner       varchar(64),
    tablelinkname    varchar(128),
    tablemapping     varchar(30)
);

COMMENT ON TABLE f_schemainfo IS 'Definition of information properties for FDO meta schema.';

insert into f_schemainfo (schemaname, description, creationdate, owner, schemaversionid )
values (current_schema(), 'System Metaschema', current_timestamp, current_user, 3.000);

-- F_MetaClass is a special schema with a class for each FDO Feature schema class type
insert into f_schemainfo  (schemaname, description, creationdate, owner, schemaversionid )
values ('F_MetaClass', 'Special classes for FDO Feature metaclasses', current_timestamp, current_user, 3.000);
