drop table scorm_tracking cascade;
drop table cmi_custom cascade;

-- drop cmi stuff first
drop table cmi_correct_response cascade;
drop table cmi_objective cascade;
drop table cmi_gobjective cascade;
drop table cmi_interaction cascade;
drop table cmi_comment cascade;
drop table cmi_node cascade;
drop table cp_suspend cascade;

-- now cp stuff
drop table cp_auxilaryresource cascade;
drop table cp_condition cascade;
drop table cp_objective cascade;
drop table cp_dependency cascade;
drop table cp_file cascade;
drop table cp_hidelmsui cascade;
drop table cp_resource cascade;
drop table cp_item cascade;
drop table cp_manifest cascade;
drop table cp_mapinfo cascade;
drop table cp_rule cascade;
drop table cp_organization cascade;
drop table cp_sequencing cascade;
drop table cp_tree cascade;
drop table cp_node cascade;
drop table cp_package cascade;

drop table lng_data cascade;