Hi!
These are a few lines that I had to add manually in order to remove rests of a previous ams installation. I understand they don't correspond to the current ams-create.sql script, but maybe the upgrade scripts weren't that perfect in the past...
drop view ams_list_attribute_map;
drop view ams_lists;
drop sequence ams_list_attribute_sort_order_seq;
drop sequence ams_option_map_id_seq;
drop sequence ams_options_seq;
Cheers,
Frank