| Index: trunk/extensions/geoserver/geoserver.psql |
| — | — | @@ -1,8 +1,3 @@ |
| 2 | | - |
| 3 | 2 | CREATE TABLE geodata ( |
| 4 | 3 | title character varying(255) NOT NULL, |
| 5 | 4 | type_major character(1), |
| — | — | @@ -19,3 +14,7 @@ |
| 20 | 15 | |
| 21 | 16 | select AddGeometryColumn ( 'geodata', 'geom', 4326, 'GEOMETRY', 2); |
| 22 | 17 | CREATE INDEX "geodata_geom_idx" ON "geodata" using gist ("geom" gist_geometry_ops); |
| | 18 | + |
| | 19 | +CREATE SEQUENCE geodata_fid_seq ; |
| | 20 | +ALTER TABLE geodata ALTER COLUMN fid SET DEFAULT nextval('geodata_fid_seq'::regclass); |
| | 21 | + |