PG User feature table

From MapbenderWiki

This database structure is the source to the PostgreSQL User Map.

Find the database structure including two dataset below. Observe that you need to have PostGIS support and the default tables geometry_columns and spatial_ref_sys in order to use MapServer or GeoServer to draw maps or GML from the database. Example of the data type geometry.

--
-- PostgreSQL database dump
--

\connect - admin

SET search_path = public, pg_catalog;

--
-- TOC entry 2 (OID 50056844)
-- Name: pg_users; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE pg_users (
    gid serial NOT NULL,
    firstname character varying(50),
    lastname character varying(50),
    usertype integer,
    orga character varying(50),
    url character varying(150),
    town character varying(100),
    email character varying(100),
    fullname character varying(150),
    urlmap character varying(250),
    postgresql_version character varying(15),
    postgis_version character varying(15),
    the_geom geometry,
    labeling character varying(50),
    CONSTRAINT "$1" CHECK ((srid(the_geom) = 4326)),
    CONSTRAINT "$2" CHECK (((geometrytype(the_geom) = 'POINT'::text) OR (the_geom IS NULL)))
);


--
-- Data for TOC entry 4 (OID 50056844)
-- Name: pg_users; Type: TABLE DATA; Schema: public; Owner: admin
--

INSERT INTO pg_users VALUES (1, 'Arnulf', 'Christl', 1, 'CCGIS', 'http://www.ccgis.de', 'Bonn', 'arnulf.christl@ccgis.de', 'Arnulf B. Christl', 'http://www.mapbender.org', '', '', 'SRID=4326;POINT(7.0714 50.73767)', 'User');
INSERT INTO pg_users VALUES (55, 'Peter', 'Eisentraut', 2, 'credativ', 'http://www.credativ.de', 'Jülich', 'peter.eisentraut@credativ.de', 'Peter Eisentraut', '', '9.007', '', 'SRID=4326;POINT(6.3607 50.9294)', 'Developer');


--
-- TOC entry 3 (OID 50056842)
-- Name: pg_users_gid_seq; Type: SEQUENCE SET; Schema: public; Owner: admin
--

SELECT pg_catalog.setval ('pg_users_gid_seq', 68, true);