diff --git a/sql/create_forcedsource.sql b/sql/create_forcedsource.sql new file mode 100644 index 0000000000000000000000000000000000000000..d75d747006f8189c560ed365938b2c9a6af7efca --- /dev/null +++ b/sql/create_forcedsource.sql @@ -0,0 +1,17 @@ +CREATE TABLE %(tabname)s + (deepSourceId BIGINT NOT NULL + ,scienceCcdExposureId BIGINT NOT NULL + ,psfFlux float DEFAULT NULL + ,psfFluxSigma float DEFAULT NULL + ,flagBadMeasCentroid BOOLEAN NOT NULL + ,flagPixEdge BOOLEAN NOT NULL + ,flagPixInterpAny BOOLEAN NOT NULL + ,flagPixInterpCen BOOLEAN NOT NULL + ,flagPixSaturAny BOOLEAN NOT NULL + ,flagPixSaturCen BOOLEAN NOT NULL + ,flagBadPsfFlux BOOLEAN NOT NULL + ,chunkId INT NOT NULL + ,subChunkId INT NOT NULL +-- ,PRIMARY KEY (deepSourceIdscienceCcdExposureId) + ) +;