xiaoshu-app/scripts/sql/payroll-read-rollback.sql

-- Gateway must be restored first. These are derived objects only.
-- Execute atomically after verifying helper definitions have not drifted.
DROP TRIGGER xs_payroll_digest_row ON "CommonModel";
DROP TRIGGER xs_payroll_digest_truncate ON "CommonModel";
DROP TRIGGER xs_payroll_digest_row ON "CourseAppointment";
DROP TRIGGER xs_payroll_digest_truncate ON "CourseAppointment";
DROP TRIGGER xs_payroll_digest_row ON "LessonRecord";
DROP TRIGGER xs_payroll_digest_truncate ON "LessonRecord";
DROP TRIGGER xs_payroll_digest_row ON "MemoryPracticeRecord";
DROP TRIGGER xs_payroll_digest_truncate ON "MemoryPracticeRecord";
DROP FUNCTION xs_payroll_preview_cache_write(text,text,text,jsonb);
DROP FUNCTION xs_payroll_preview_cache_read(text,text);
DROP FUNCTION xs_payroll_snapshot_current(text,text);
DROP FUNCTION xs_payroll_preview_stamp(text);
DROP FUNCTION xs_payroll_cutoff_snapshot_fast(text,text);
DROP FUNCTION xs_payroll_source_version_fast(text);
DROP FUNCTION xs_payroll_source_version_stamp(text);
DROP FUNCTION xs_payroll_source_version_uncached_fast(text);
DROP FUNCTION xs_payroll_sources_cached(text);
DROP FUNCTION xs_payroll_source_stamp(text);
DROP FUNCTION xs_payroll_sources_current(text,text);
DROP FUNCTION xs_payroll_sources_uncached(text);
DROP FUNCTION xs_payroll_data_version(text);
DROP FUNCTION xs_payroll_digest_ready();
DROP FUNCTION xs_payroll_digest_row();
DROP FUNCTION xs_payroll_digest_truncate();
DROP FUNCTION xs_payroll_digest_signature(text);
DROP FUNCTION xs_payroll_authority_ready();
DROP TABLE "PayrollVerifiedReadCache","PayrollReadChangeScope","PayrollReadChange","PayrollReadDigest","PayrollReadDigestMeta","PayrollReadAuthority";