omnivore/packages/db/migrations/0177.undo.public_item.sql

-- Type: UNDO
-- Name: public_item
-- Description: Create a table for public items

BEGIN;

DROP TABLE omnivore.public_item_interactions;
DROP TABLE omnivore.public_item_stats;
DROP TABLE omnivore.public_item;
DROP TABLE omnivore.public_item_source;

ALTER TABLE omnivore.library_item 
    DROP COLUMN seen_at,
    DROP COLUMN digested_at,
    DROP COLUMN topic,
    DROP COLUMN score;

DROP EXTENSION LTREE;

COMMIT;