CREATE TABLE `dadabik_e107_banlist` ( `name_field` varchar( 50 ) NOT NULL default '', `label_field` varchar( 255 ) NOT NULL default '', `type_field` enum( 'text', 'textarea', 'rich_editor', 'password', 'insert_date', 'update_date', 'date', 'select_single', 'generic_file', 'image_file', 'ID_user', 'unique_ID' ) NOT NULL default 'text', `content_field` enum( 'alphabetic', 'alphanumeric', 'numeric', 'url', 'email', 'html', 'phone', 'city' ) NOT NULL default 'alphanumeric', `present_search_form_field` enum( '0', '1' ) NOT NULL default '1', `present_results_search_field` enum( '0', '1' ) NOT NULL default '1', `present_details_form_field` enum( '0', '1' ) NOT NULL default '1', `present_insert_form_field` enum( '0', '1' ) NOT NULL default '1', `present_ext_update_form_field` enum( '0', '1' ) NOT NULL default '1', `required_field` enum( '0', '1' ) NOT NULL default '0', `check_duplicated_insert_field` enum( '0', '1' ) NOT NULL default '0', `other_choices_field` enum( '0', '1' ) NOT NULL default '0', `select_options_field` text NOT NULL , `primary_key_field_field` varchar( 255 ) NOT NULL default '', `primary_key_table_field` varchar( 255 ) NOT NULL default '', `primary_key_db_field` varchar( 50 ) NOT NULL default '', `linked_fields_field` text NOT NULL , `linked_fields_order_by_field` text NOT NULL , `linked_fields_order_type_field` varchar( 255 ) NOT NULL default '', `select_type_field` varchar( 100 ) NOT NULL default 'is_equal/contains/starts_with/ends_with/greater_than/less_then', `prefix_field` text NOT NULL , `default_value_field` text NOT NULL , `width_field` varchar( 5 ) NOT NULL default '', `height_field` varchar( 5 ) NOT NULL default '', `maxlength_field` varchar( 5 ) NOT NULL default '100', `hint_insert_field` varchar( 255 ) NOT NULL default '', `order_form_field` smallint( 6 ) NOT NULL default '0', `separator_field` char( 2 ) NOT NULL default '~', PRIMARY KEY ( `name_field` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1; MySQL said: Documentation #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 'DEFAULT CHARSET=latin1' at line 31