HVXGMDRZZL74CZNWRN3KL3KRKPRMFHJS5QO63SHT5KPZZQYIEFLQC Y4TX5D3S2D44LL5K7ZTA6CEWVNMOBL5TZGER5HM2TBPYUO3YAIQQC VC7QSFO5ZFNOLFILDXKB5JZYRIKX3I54UZ42TLW67CYQY26HEEHAC 4MKRMHNU3LMN4TDH6U4GL53F65WPX2E4PFIGLTMSMJ54CM7EVJCQC HU4V2UA4CZNNWQ4RRMFYEKD44QRMLTRJHZMIONWIZGLTJU7CYU4AC OBXY6BHNROIV7W4O3MMQ6GTQXU2XUKF5A4DCJYDLUEUHV72E7BNAC EUEH65HBT4XZXCNWECJXNDEQAWR2NLNSAXFPXLMQ27NOVMQBJT5QC ZYT3JRERMYXLMJHLPZYQHAINVMPQLBKGGN7A4C7OTVZDY42ZLTKQC MP5J4XQL3PPTFTMAZLIXBOFUWYFNQSIK57NLROQYGWOOAFHRYOIQC PJXKN67Q6F3F5BYJ2PKQNGZIFDMTOQN6EWDRV5EIEC6CI72NG3HQC ZLAW2U46IG2AVML56WQDOUFJEHS3QYVY7GXM3JGGJIQBOEY64FTAC YBJGFUTFTV4SBPUVC6LBETGMPMLS47LSQPL3OJAAPH7BROBQD7DQC QPZE42LFURFXW6QNTVXY6AF7DZI7KTOLHMNSJHLFCRZMNMGQ6EVQC E5VPWWBUPZF2IQQC4MVIF3T2G5IHQYONHR3NHIBKGGV3JEF7TDAQC C4PJ5BYCHKYQVPCXNESI5AZELV3TXCWXIVU7IFJ2F3MZVR23SQ3AC NYBASAG4KWZNPSFBXWQJWQRBCGT7C5B24IYO2IBCXCE2WGJQJOEQC LSAQ6ZM2NELU3FIWKEFBOXKVLSZS2ZOK2PHPHJRWPVZ5CVILSUYQC 4W6PARYQUVT5TCIO2E74STUQVZXNG536LXDZQNOO65E74RSDJMTQC VFENVAHOAERPOWJFWVQBS5GXK3F422I62ZGQGOJHALKZZK2Q2SJAC user_id VARCHAR(64), --Optional, Grants permission to a specific user (overrides role). If `NULL`, the grant applies to *all* users with the specified role for the dataset.
user_id VARCHAR(64), --Optional, Grants permission to a specific user (overrides role). If `NULL`, the grant applies to *all* users with the specified role for the dataset.
-- Drop redundant astronomical columns from selection table (data exists in file table)DROP INDEX idx_selection_is_solar_night;DROP INDEX idx_selection_is_civil_night;DROP INDEX idx_selection_moon_phase;ALTER TABLE selection DROP COLUMN is_solar_night;ALTER TABLE selection DROP COLUMN is_civil_night;ALTER TABLE selection DROP COLUMN moon_phase;SELECT NOW();-- 2025-07-07 02:34:12.000000+00
-- ---- Delete duplicate file records with same xxh64_hash values-- Removed 3 duplicate files ending in '_001' that had identical hashes to files ending in '_000'DELETE FROM moth_metadata WHERE file_id IN ('V5gEQ6Fczhu9_GXPmR6I1', 'gskEfItZXJ93o-2Jpvucc', 'sfwj_jS3FQEh1SL1yYJRh');DELETE FROM file_dataset WHERE file_id IN ('V5gEQ6Fczhu9_GXPmR6I1', 'gskEfItZXJ93o-2Jpvucc', 'sfwj_jS3FQEh1SL1yYJRh');DELETE FROM file WHERE id IN ('V5gEQ6Fczhu9_GXPmR6I1', 'gskEfItZXJ93o-2Jpvucc', 'sfwj_jS3FQEh1SL1yYJRh');-- Drop redundant astronomical columns from selection table (data exists in file table)DROP INDEX idx_selection_is_solar_night;DROP INDEX idx_selection_is_civil_night;DROP INDEX idx_selection_moon_phase;ALTER TABLE selection DROP COLUMN is_solar_night;ALTER TABLE selection DROP COLUMN is_civil_night;ALTER TABLE selection DROP COLUMN moon_phase;SELECT NOW();-- 2025-07-07 02:34:12.000000+00
-- --