#1 DB creation error (via sql script)

[bayouborne]

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 27, 2005 at 11:41 AM
-- Server version: 5.0.12
-- PHP Version: 4.3.11
--
-- Database: `maps`
--
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`name` tinytext NOT NULL ,
`public` enum( 'yes', 'no' ) NOT NULL default 'yes',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
AUTO_INCREMENT =7

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 AUTO_INCREMENT=7' at line 24

[bayouborne]

Logged In: YES
user_id=1393808

MySQL 4.0.25-standard