CREATE TABLE %(tabname)s 
  (id BIGINT NOT NULL
  ,coord_ra double DEFAULT NULL
  ,coord_decl double DEFAULT NULL
  ,coord_htmId20 BIGINT DEFAULT NULL
  ,parent BIGINT DEFAULT NULL
  ,flags_badcentroid BOOLEAN NOT NULL
  ,centroid_sdss_x double DEFAULT NULL
  ,centroid_sdss_y double DEFAULT NULL
  ,centroid_sdss_xVar double DEFAULT NULL
  ,centroid_sdss_xyCov double DEFAULT NULL
  ,centroid_sdss_yVar double DEFAULT NULL
  ,centroid_sdss_flags BOOLEAN NOT NULL
  ,flags_pixel_edge BOOLEAN NOT NULL
  ,flags_pixel_interpolated_any BOOLEAN NOT NULL
  ,flags_pixel_interpolated_center BOOLEAN NOT NULL
  ,flags_pixel_saturated_any BOOLEAN NOT NULL
  ,flags_pixel_saturated_center BOOLEAN NOT NULL
  ,flags_pixel_cr_any BOOLEAN NOT NULL
  ,flags_pixel_cr_center BOOLEAN NOT NULL
  ,centroid_naive_x double DEFAULT NULL
  ,centroid_naive_y double DEFAULT NULL
  ,centroid_naive_xVar double DEFAULT NULL
  ,centroid_naive_xyCov double DEFAULT NULL
  ,centroid_naive_yVar double DEFAULT NULL
  ,centroid_naive_flags BOOLEAN NOT NULL
  ,centroid_gaussian_x double DEFAULT NULL
  ,centroid_gaussian_y double DEFAULT NULL
  ,centroid_gaussian_xVar double DEFAULT NULL
  ,centroid_gaussian_xyCov double DEFAULT NULL
  ,centroid_gaussian_yVar double DEFAULT NULL
  ,centroid_gaussian_flags BOOLEAN NOT NULL
  ,shape_sdss_Ixx double DEFAULT NULL
  ,shape_sdss_Iyy double DEFAULT NULL
  ,shape_sdss_Ixy double DEFAULT NULL
  ,shape_sdss_IxxVar double DEFAULT NULL
  ,shape_sdss_IxxIyyCov double DEFAULT NULL
  ,shape_sdss_IxxIxyCov double DEFAULT NULL
  ,shape_sdss_IyyVar double DEFAULT NULL
  ,shape_sdss_IyyIxyCov double DEFAULT NULL
  ,shape_sdss_IxyVar double DEFAULT NULL
  ,shape_sdss_flags BOOLEAN NOT NULL
  ,shape_sdss_centroid_x double DEFAULT NULL
  ,shape_sdss_centroid_y double DEFAULT NULL
  ,shape_sdss_centroid_xVar double DEFAULT NULL
  ,shape_sdss_centroid_xyCov double DEFAULT NULL
  ,shape_sdss_centroid_yVar double DEFAULT NULL
  ,shape_sdss_centroid_flags BOOLEAN NOT NULL
  ,shape_sdss_flags_unweightedbad BOOLEAN NOT NULL
  ,shape_sdss_flags_unweighted BOOLEAN NOT NULL
  ,shape_sdss_flags_shift BOOLEAN NOT NULL
  ,shape_sdss_flags_maxiter BOOLEAN NOT NULL
  ,flux_psf double DEFAULT NULL
  ,flux_psf_err double DEFAULT NULL
  ,flux_psf_flags BOOLEAN NOT NULL
  ,flux_psf_psffactor float DEFAULT NULL
  ,flux_psf_flags_psffactor BOOLEAN NOT NULL
  ,flux_psf_flags_badcorr BOOLEAN NOT NULL
  ,flux_naive double DEFAULT NULL
  ,flux_naive_err double DEFAULT NULL
  ,flux_naive_flags BOOLEAN NOT NULL
  ,flux_gaussian double DEFAULT NULL
  ,flux_gaussian_err double DEFAULT NULL
  ,flux_gaussian_flags BOOLEAN NOT NULL
  ,flux_gaussian_psffactor float DEFAULT NULL
  ,flux_gaussian_flags_psffactor BOOLEAN NOT NULL
  ,flux_gaussian_flags_badcorr BOOLEAN NOT NULL
  ,flux_sinc double DEFAULT NULL
  ,flux_sinc_err double DEFAULT NULL
  ,flux_sinc_flags BOOLEAN NOT NULL
  ,centroid_record_x double DEFAULT NULL
  ,centroid_record_y double DEFAULT NULL
  ,classification_extendedness double DEFAULT NULL
  ,aperturecorrection double DEFAULT NULL
  ,aperturecorrection_err double DEFAULT NULL
  ,refFlux double DEFAULT NULL
  ,refFlux_err double DEFAULT NULL
  ,objectId BIGINT NOT NULL
  ,coord_raVar double DEFAULT NULL
  ,coord_radeclCov double DEFAULT NULL
  ,coord_declVar double DEFAULT NULL
  ,exposure_id BIGINT NOT NULL
  ,exposure_filter_id INT NOT NULL
  ,exposure_time float DEFAULT NULL
  ,exposure_time_mid double DEFAULT NULL
  ,cluster_id BIGINT DEFAULT NULL
  ,cluster_coord_ra double DEFAULT NULL
  ,cluster_coord_decl double DEFAULT NULL
--  ,PRIMARY KEY (id)
  )
;

