misc/171801: Problem with creating MySQL database from squid_db.sql.

[Imil]

>Number:         171801
>Category:       misc
>Synopsis:       Problem with creating MySQL database from squid_db.sql.
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Thu Sep 20 04:20:05 UTC 2012
>Closed-Date:
>Last-Modified:
>Originator:     Imil
>Release:        FreeBSD 8.0-RELEASE
>Organization:
>Environment:
FreeBSD test.local 8.0-RELEASE FreeBSD 8.0-RELEASE #0: Sat Nov 21 15:48:17 UTC 2009     root at almeida.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386

>Description:
I install /usr/ports/www/sams and /usr/ports/databases/mysql55-server/ . 
This problem appear with creating MySQL databases from /usr/local/share/sams/data/sams_db.sql . I enter "http://[My_IP_address]/sams/install.php" in web-browser address string. Next, I press [Create Database] button in web-page. And get some messages:

SAMS installations

File squid_db.sql opened

Please wait, database createst may take up to 30 minutes........
ERROR: line 6: query:[ CREATE TABLE `cache` ( `date` date, `time` time, `user` char(25), `domain` char(25), `size` BIGINT UNSIGNED NULL, `ipaddr` char(15) NOT NULL, `period` BIGINT UNSIGNED NULL, `url` char(100) NOT NULL, `hit` BIGINT UNSIGNED NULL, `method` char(15) NOT NULL ) TYPE=MyISAM] failed
mysql error: 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 'TYPE=MyISAM' at line 12 (err:1064)
>How-To-Repeat:
>Fix:
>Release-Note:
>Audit-Trail:
>Unformatted: