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)
)
;