ports/164962: Importing FreeRadius mysql schema choke on SQL syntax

[Edward]

>Number:         164962
>Category:       ports
>Synopsis:       Importing FreeRadius mysql schema choke on SQL syntax
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          update
>Submitter-Id:   current-users
>Arrival-Date:   Fri Feb 10 16:20:07 UTC 2012
>Closed-Date:
>Last-Modified:
>Originator:     Edward
>Release:        9.0
>Organization:
>Environment:
FreeBSD host.example.com 9.0-RELEASE FreeBSD 9.0-RELEASE #0: Tue Jan  3 07:46:30 UTC 2012     root at farrell.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64
>Description:
Hi,

While importing freeradius mysql schema at /usr/local/share/doc/freeradius/examples/mysql.sql, got an error
	# mysql -uradius -p radius < mysql.sql 
	Enter password: 
	ERROR 1064 (42000) at line 123: 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 '(14) NOT NULL,
	  PRIMARY KEY  (id)
	)' at line 6
>How-To-Repeat:
mysql -uradius -p radius < /usr/local/share/doc/freeradius/examples/mysql.sql
>Fix:
This is cause by an syntax error at line 128 of the schema file mysql.sql, removing "(14)" from the line solved the problem.

Original erroneous line 128 :
  date timestamp(14) NOT NULL,

Suggested line :
  date timestamp NOT NULL,



Patch attached with submission follows:

--- mysql.sql   2012-02-03 10:28:57.000000000 +0800
+++ mysql.sql.backup    2012-02-03 10:07:51.000000000 +0800
@@ -125,7 +125,7 @@
   user varchar(64) NOT NULL default '',
   pass varchar(64) NOT NULL default '',
   reply varchar(32) NOT NULL default '',
-  date timestamp NOT NULL,
+  date timestamp(14) NOT NULL,
   PRIMARY KEY  (id)
 ) ;

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