--
-- f_feature - 
--
DROP TABLE IF EXISTS f_feature;

-- #ifdef FDO_FEATURE
create table f_feature (
    featid        bigint not null,
    classid       numeric(20),
-- #ifdef FDO_VERSIONS
    ltid          numeric(20),
    nextltid      numeric(20),
    ltgeneration  numeric(20),
-- #endif
-- #ifdef FDO_LOCKS
    rowlockid     numeric(20),
    rowlocktype   varchar(1)
-- #endif
);

COMMENT ON TABLE f_feature IS 'Definition of FDO spatial feature types.';

-- #ifndef FDO_VERSIONS
-- #ifndef FDO_LOCKS
alter table f_feature add (constraint f_feature_pk primary key (featid));
-- #endif
-- #endif

-- #endif 