-- UPDATE CONSTRAINT to DELETE CASCADE 
ALTER TABLE product_tags
DROP CONSTRAINT fkey_pid,
ADD CONSTRAINT "fkey_pid" FOREIGN KEY (pid) REFERENCES product(id) ON DELETE CASCADE;


-- SET to auto increment 
CREATE SEQUENCE peh_id;
ALTER TABLE product_edit_history ALTER COLUMN id SET DEFAULT nextval('peh_id');