ALTER TABLE assets ALTER id DROP DEFAULT;

DROP SEQUENCE assets_id_seq;