DB Yükleme Sorunu Phpmyadmin

Arkadaşlar host değiştirirken yedeğini aldıgım sql dosyasını yeni hosta myadminden yüklerken bi kaç tabloda hata alıyorum.

SQL sorgusu:

CREATE TABLE `mt_view_merchant` (

);

MySQL çıktısı: Belgeler

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1


hata bu ilgili tablo



DROP VIEW IF EXISTS `mt_view_merchant`;
CREATE TABLE `mt_view_merchant` ();


DROP VIEW IF EXISTS `mt_view_merchantt`;
CREATE TABLE `mt_view_merchantt` (`merchant_id` int(14), `restaurant_slug` varchar(255), `restaurant_name` varchar(255), `restaurant_phone` varchar(100), `contact_name` varchar(255), `contact_phone` varchar(100), `contact_email` varchar(255), `country_code` varchar(3), `street` text, `city` varchar(255), `state` varchar(255), `post_code` varchar(100), `cuisine` text, `service` varchar(255), `free_delivery` int(1), `delivery_estimation` varchar(100), `username` varchar(100), `password` varchar(100), `activation_key` varchar(50), `activation_token` varchar(255), `status` varchar(100), `date_created` datetime, `date_modified` datetime, `date_activated` datetime, `last_login` datetime, `ip_address` varchar(50), `package_id` int(14), `package_price` float(14,5), `membership_expired` date, `payment_steps` int(1), `is_featured` int(1), `is_ready` int(1), `is_sponsored` int(2), `sponsored_expiration` date, `lost_password_code` varchar(50), `user_lang` int(14), `membership_purchase_date` datetime, `sort_featured` int(14), `is_commission` int(1), `percent_commision` float(14,5), `abn` varchar(255), `session_token` varchar(255), `commision_type` varchar(50), `latitude` text, `lontitude` text, `delivery_charges` text, `minimum_order` text, `ratings` double(22,5));



çözemedim bi türlü yardım edermisiniz ücretlide olur.

direk bunu denedim.calıstı. sorunsuz. yukardaki kontrollerine gerek yok.çok önemli bir olgu değil. direk tabolunu oluştur geç.

CREATE TABLE `mt_view_merchantt` (`merchant_id` int(14), `restaurant_slug` varchar(255), `restaurant_name` varchar(255), `restaurant_phone` varchar(100), `contact_name` varchar(255), `contact_phone` varchar(100), `contact_email` varchar(255), `country_code` varchar(3), `street` text, `city` varchar(255), `state` varchar(255), `post_code` varchar(100), `cuisine` text, `service` varchar(255), `free_delivery` int(1), `delivery_estimation` varchar(100), `username` varchar(100), `password` varchar(100), `activation_key` varchar(50), `activation_token` varchar(255), `status` varchar(100), `date_created` datetime, `date_modified` datetime, `date_activated` datetime, `last_login` datetime, `ip_address` varchar(50), `package_id` int(14), `package_price` float(14,5), `membership_expired` date, `payment_steps` int(1), `is_featured` int(1), `is_ready` int(1), `is_sponsored` int(2), `sponsored_expiration` date, `lost_password_code` varchar(50), `user_lang` int(14), `membership_purchase_date` datetime, `sort_featured` int(14), `is_commission` int(1), `percent_commision` float(14,5), `abn` varchar(255), `session_token` varchar(255), `commision_type` varchar(50), `latitude` text, `lontitude` text, `delivery_charges` text, `minimum_order` text, `ratings` double(22,5));