diff --git a/sql/create_source.sql b/sql/create_source.sql new file mode 100644 index 0000000000000000000000000000000000000000..008009f15f72d57d454edc76fb3bff11673219a2 --- /dev/null +++ b/sql/create_source.sql @@ -0,0 +1,92 @@ +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) + ) +; +