AL/test/droptable.sql

DROP TABLE x_avatar;
DROP TABLE x_avatar_user_link;
DROP TABLE x_banner;
DROP TABLE x_bannerclient;
DROP TABLE x_bannerfinish;
DROP TABLE x_block_module_link;
DROP TABLE x_config;
DROP TABLE x_configcategory;
DROP TABLE x_configoption;
DROP TABLE x_group_permission;
DROP TABLE x_groups;
DROP TABLE x_groups_users_link;
DROP TABLE x_image;
DROP TABLE x_imagebody;
DROP TABLE x_imagecategory;
DROP TABLE x_imgset;
DROP TABLE x_imgset_tplset_link;
DROP TABLE x_imgsetimg;
DROP TABLE x_modules;
DROP TABLE x_newblocks;
DROP TABLE x_online;
DROP TABLE x_priv_msgs;
DROP TABLE x_ranks;
DROP TABLE x_session;
DROP TABLE x_smiles;
DROP TABLE x_tplfile;
DROP TABLE x_tplset;
DROP TABLE x_tplsource;
DROP TABLE x_users;
DROP TABLE x_xnpaccount_binder_item_link;
DROP TABLE x_xnpaccount_changelog;
DROP TABLE x_xnpaccount_config;
DROP TABLE x_xnpaccount_file;
DROP TABLE x_xnpaccount_file_type;
DROP TABLE x_xnpaccount_groups;
DROP TABLE x_xnpaccount_groups_users_link;
DROP TABLE x_xnpaccount_index;
DROP TABLE x_xnpaccount_index_item_link;
DROP TABLE x_xnpaccount_item_basic;
DROP TABLE x_xnpaccount_item_type;
DROP TABLE x_xnpaccount_session;
DROP TABLE x_xnpaccount_users;
DROP TABLE x_xnpbinder_binder_item_link;
DROP TABLE x_xnpbook_item_detail;
DROP TABLE x_xnpdata_item_detail;
DROP TABLE x_xnpmodel_item_detail;
DROP TABLE x_xnppaper_item_detail;
DROP TABLE x_xnppresentation_item_detail;
DROP TABLE x_xnptool_item_detail;
DROP TABLE x_xnpurl_item_detail;
DROP TABLE x_xoopscomments;
DROP TABLE x_xoopsnotifications;