-- curl -o csc_out.csv --form coordFormat=decimal --form outputFormat=csv --form nullAppearance=NULL --form query=@csc_query.sql 'http://cda.cfa.harvard.edu/csccli/getProperties' 

drop table if exists cx_src1;

create table cx_src1 (
  name char(20) not null default '',
  ra   double not null default 0,
  de   double not null default 0,  -- can use `dec`
  extent_flag    tinyint(1) not null default 0,  -- alias BOOLEAN
  err_ellipse_r0 float not null default 0,
  err_ellipse_r1 float not null default 0,
  conf_flag      tinyint(1) not null default 0,
  flux_aper_w    float,  -- we allow for NULLs
  flux_aper_b    float,
  significance   float not null default 0
) engine=MyISAM;
