ALTER TABLE url_mid	DROP KEY subdomainKey;
ALTER TABLE url_mp3	DROP KEY subdomainKey;
ALTER TABLE url_pic	DROP KEY subdomainKey;
ALTER TABLE url_pud	DROP KEY subdomainKey;
ALTER TABLE url_ram	DROP KEY subdomainKey;
ALTER TABLE url_se	DROP KEY subdomainKey;
ALTER TABLE url_sound	DROP KEY subdomainKey;
ALTER TABLE url_video	DROP KEY subdomainKey;
ALTER TABLE url_wav	DROP KEY subdomainKey;
ALTER TABLE ftp_mp3	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url		DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_aif	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_aiff	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_avi	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_bmp	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_gif	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_ico	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_jpeg	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_jpg	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_lzh	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_mid	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_mov	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_mp3	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_mpeg	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_pic	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_pud	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_ram	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_se	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_sound	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_tiff	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_video	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_wav	DROP COLUMN fileType, DROP COLUMN subdomainNum;
ALTER TABLE url_xbm	DROP COLUMN fileType, DROP COLUMN subdomainNum;
