I tried creating this table by running this a few years ago using an earlier version of MySQL and it worked fine. It appears as though there is now a problem with timestamp(8) in the more recent versions of MySQL.

```
CREATE TABLE top_hits (
  sid int(11),
  ip varchar(20),
  cdate timestamp(8)
)

```

What could I use as an alternative to line 4's timestamp(8)? YYYYMMDD

```
cdate timestamp(8)

```

Thanks in advance.