liquid_feedback_core
annotate pgLatLon/create_test_db.schema.sql @ 530:6bc81898fd3b
Fixed typo in documentation and comments: "indicies" -> "indices"; Marked make-doc.sh as executable
| author | jbe |
|---|---|
| date | Sun Aug 21 16:28:21 2016 +0200 (2016-08-21) |
| parents | 96ee2db56bec |
| children |
| rev | line source |
|---|---|
| jbe@529 | 1 |
| jbe@529 | 2 CREATE EXTENSION latlon; |
| jbe@529 | 3 |
| jbe@529 | 4 CREATE TABLE "test" ( |
| jbe@529 | 5 "id" SERIAL4 PRIMARY KEY, |
| jbe@529 | 6 "location" EPOINT NOT NULL, |
| jbe@529 | 7 "area" ECIRCLE NOT NULL ); |
| jbe@529 | 8 |
| jbe@529 | 9 CREATE INDEX "test_location_key" ON "test" USING gist ("location"); |
| jbe@529 | 10 CREATE INDEX "test_area_key" ON "test" USING gist ("area"); |
| jbe@529 | 11 |