[Ambit-users] ERROR 1293 (HY000)

Hi all,

I inherited an ancient Ambit2-appliance running off of a virtualised instance 
of Linux Mint 13, aka Maya.

A few hours ago I set out to update Ambit to run off of our standard 
virtualised Linux environment by using CentOS 6.7 x64.

I found and used the guide available on 
http://ambit.sourceforge.net/install_ambitrest.html.

Managed to install Java, Tomcat and MySQL, and all three work properly.

Next step was to use the script on the above link, and I immediately ran into 
some problems.

Please note that my sql-proficency is pretty basic at best, I can list 
databases, drop them etc., therefore the below error put me pretty much out of 
my league.
Some google searches later I learned that I can't use the same time stamps or 
something to that effect.

root@ambit ~/ [0]# mysql ambit2 -u root -p < ~/Downloads/create_tables.sql
Enter password:
ERROR 1293 (HY000) at line 240: Incorrect table definition; there can be only 
one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
root@ambit ~/ [0]#

Seems it's the two lines in the "bundle"-table that are the culprits.

`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE 
CURRENT_TIMESTAMP,
...
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,


However, I've no idea how to go about this.

Could somebody with more knowledge please give me a hint to a fix, or maybe 
suggest some further reading in order to fix this?

Thanks.

-- 
BW,
	Sorin
-----------------------------------------------------------
# Sorin Srbu, Sysadmin
# Uppsala University
# Dept of Medicinal Chemistry
# Div of Org Pharm Chem
# Box 574
# SE-75123 Uppsala
# Sweden#
# Phone: +46 (0)18-4714482
# Visit: BMC, Husargatan 3, D5:512b
# Web: http://www.orgfarm.uu.se
-----------------------------------------------------------
# ()  ASCII ribbon campaign - Against html E-mail
# /\
#
# This message was not sent from an iProduct!
#
# Please consider the environment before printing this email.
# Join the campaign at http://thinkBeforePrinting.org
#
# MotD follows:
# Hospitality: Making your guests feel at home, even though you wish they 
were.