Stuff

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