ports/164115: net-mgmt/cacti - cacti.sql does have old fashioned TYPE= statements

[Edwin Groothuis]

>Number:         164115
>Category:       ports
>Synopsis:       net-mgmt/cacti - cacti.sql does have old fashioned TYPE= statements
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sat Jan 14 06:40:09 UTC 2012
>Closed-Date:
>Last-Modified:
>Originator:     Edwin Groothuis
>Release:        9.0RC1
>Organization:
-
>Environment:
[root at freebsd90 /usr/ports/net-mgmt/cacti]# make -V PORTVERSION
0.8.7g

>Description:
After the installation of Cacti, you are supposed to run mysql to import the schema.

# mysql cacti < /usr/local/share/cacti/cacti.sql.
ERROR 1064 (42000) at line 5: 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 6


>From various websites:

------------ 8< -------------
The latest versions of MySQL removed support for the 'TYPE=' command. 

You'll end up with something like this when trying to import cacti.sql: 

Code:
ERROR 1064 (42000) at line 5: 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 6

Replacing 'TYPE=' with 'ENGINE=' (which has been supported for quite a while) will fix this. Note, the default engine in MySQL 5.5 is now InnoDB. 
------------ 8< -------------

Consider adding a patch file for it.
>How-To-Repeat:

>Fix:


>Release-Note:
>Audit-Trail:
>Unformatted: