Tab metadata sql

From MapbenderWiki

CREATE TABLE tab_metadata
(
 md_fileidentifier varchar NOT NULL,
 metadatadatestamp timestamptz,
 revisiondatestamp timestamptz,
 metadatastandardname varchar,
 metadatastandardversion varchar,
 identificationinfo varchar,
 abstract varchar,
 fkey_status int4 DEFAULT 4,
 fkey_spatialrepresentationtype int4 DEFAULT 1,
 fkey_datasetlanguage int4 DEFAULT 1,
 fkey_spatialreferencesystem int4 DEFAULT 3,
 fkey_maintenancefrequency int4,
 geographicbox_minx float8,
 geographicbox_miny float8,
 geographicbox_maxx float8,
 geographicbox_maxy float8,
 graphicoverviewfilename varchar,
 equivalentscale int4,
 specificusage varchar,
 uselimitation varchar,
 useconstraints varchar,
 lineagestatement varchar,
 lineagesource varchar,
 positionalaccuracy varchar,
 creationdate timestamptz,
 revisiondate timestamptz,
 publicationdate timestamptz,
 expirationdate timestamptz,
 geometricobjectcount int4,
 distributorformatname varchar,
 resourceformatname varchar,
 plannedavailabledatatime timestamptz,
 minscale int4 DEFAULT 0,
 maxscale int4 DEFAULT 0,
 s_iden varchar,
 s_name varchar,
 s_infotext varchar,
 dat_quein timestamptz,
 in_darst varchar,
 linkage varchar,
 identificationinfo_config varchar,
 public bool DEFAULT true,
 md_fileidentifier_english varchar,
 layername_deutsch varchar,
 layername_english varchar,
 search_columns text,
 search_result text,
 search_keywords text,
 wms_title text
)