1-- Based on https://github.com/tonyta/ScrallWall/blob/master/db/data/neighborhoods.sql 2SET CLIENT_ENCODING TO UTF8; 3SET STANDARD_CONFORMING_STRINGS TO ON; 4BEGIN; 5CREATE TABLE "neighborhoods" (gid serial, 6"objectid" numeric(10,0), 7"pri_neigh_" varchar(3), 8"pri_neigh" varchar(50), 9"sec_neigh_" varchar(3), 10"sec_neigh" varchar(50), 11"shape_area" numeric, 12"shape_len" numeric); 13ALTER TABLE "neighborhoods" ADD PRIMARY KEY (gid); 14CREATE INDEX "neighborhoods_geom_gist" ON "neighborhoods" USING GIST ("geom"); 15COMMIT; 16 17BEGIN TRANSACTION; 18CREATE TABLE "player" (uid serial, "name" varchar(50)); 19COMMIT; 20