-- Deploy kakeibo:delete_item to pg
-- requires: appschema
-- requires: items

BEGIN;

CREATE OR REPLACE FUNCTION kakeibo.delete_item(p_id integer)
  RETURNS VOID AS $$
BEGIN
  DELETE FROM kakeibo.items WHERE id = p_id;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;

COMMIT;