gistfile1.sql

CREATE TABLE geo (id INT NOT NULL, PRIMARY KEY(id));
SELECT AddGeometryColumn('geo', 'point', -1, 'POINT', 2);
SELECT AddGeometryColumn('geo', 'linestring', -1, 'LINESTRING', 2);
SELECT AddGeometryColumn('geo', 'polygon', -1, 'POLYGON', 2);
SELECT AddGeometryColumn('geo', 'multipoint', -1, 'MULTIPOINT', 2);
SELECT AddGeometryColumn('geo', 'multilinestring', -1, 'MULTILINESTRING', 2);
SELECT AddGeometryColumn('geo', 'multipolygon', -1, 'MULTIPOLYGON', 2);
SELECT AddGeometryColumn('geo', 'geometrycollection', -1, 'GEOMETRYCOLLECTION', 2);
CREATE SEQUENCE geo_id_seq INCREMENT BY 1 MINVALUE 1 START 1