zef6a2Jt

1-- Table: sky
2
3DROP TABLE IF EXISTS sky;
4
5CREATE TABLE sky
6(
7  "name"     character varying(20) NOT NULL,
8  name_alt   character varying(20),
9  "type"     character(5) NOT NULL,
10  con        character(3) NOT NULL,
11  ra         real NOT NULL,
12  "dec"      real NOT NULL,
13  mag        numeric(3,1) NOT NULL DEFAULT 99.9,
14  subr       numeric(3,1) NOT NULL DEFAULT 99.9,
15  size_max   real,
16  size_min   real,
17  pa         integer,
18  "class"    character varying(20),
19  ngc_descr  character varying(55),
20  notes      character varying(86),
21  CONSTRAINT object_name PRIMARY KEY (name)
22)
23WITH (
24  OIDS=FALSE
25);
26
27-- Add a geometry column under lat/long coordinates
28SELECT AddGeometryColumn( 'public', 'sky', 'geom', -1, 'POINT', 2 );
29CREATE INDEX sky_geom ON sky USING GIST ( geom );