Problem with create_tables.sql

[boesiii]

I am trying to create my table on my Yahoo web host and when I try and run

CREATE TABLE audit (
  modified_by_ip   VARCHAR(39)  NOT NULL DEFAULT '',
  modified_by_user VARCHAR(50)  NOT NULL DEFAULT '',
  modified_when    BIGINT(14)   NOT NULL,
  modified_from    BIGINT(14)   NOT NULL,
  modified_to      BIGINT(14)   NOT NULL,
  modified_why     VARCHAR(250) NOT NULL DEFAULT '',
  user_modified    VARCHAR(50)  NOT NULL DEFAULT '',
  PRIMARY KEY (modified_when),
  UNIQUE KEY modified_when (modified_when)
)
  ENGINE =MyISAM;

I get and error mesage, "Unclosed quote" and #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 ''', modified_by_user VARCHAR(50) NOT NULL DEFAULT '', modified_when ' at line 2

[boelle]

when i export my empty audit table i get:

-- phpMyAdmin SQL Dump -- version 4.5.4.1

-- http://www.phpmyadmin.net

-- Host: localhost -- Generation Time: Apr 06, 2016 at 01:58 PM -- Server version: 5.6.29 -- PHP Version: 5.6.18

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";

-- Database: *********

---

-- Table structure for table audit

CREATE TABLE audit ( modified_by_ip varchar(39) NOT NULL DEFAULT '', modified_by_user varchar(50) NOT NULL DEFAULT '', modified_when bigint(14) NOT NULL, modified_from bigint(14) NOT NULL, modified_to bigint(14) NOT NULL, modified_why varchar(250) NOT NULL DEFAULT '', user_modified varchar(50) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Indexes for dumped tables

-- Indexes for table audit

ALTER TABLE audit ADD PRIMARY KEY (modified_when), ADD UNIQUE KEY modified_when (modified_when);