[bugs:#815] Fix Table definition in /usr/share/tango-db/create_db.sql for mariadb
Status: open
Created: Sat Sep 03, 2016 07:38 PM UTC by Vincent Hardion
Last Updated: Sat Sep 03, 2016 07:38 PM UTC
Owner: nobody
Incorrect Table definition in /usr/share/tango-db/create_db.sql
Cannot create the Tango 9 database with the supplied script on CENTOS7.
Environment: CentOS 7 Mariabd 5.5.50-MariaDB
libtango9 Arch : x86_64 Version : 9.2.2 Release : 4.el7.centos.maxlab Size : 8.5 M
Name : tango-db Arch : x86_64 Version : 5.4 Release : 4.el7.centos.maxlab
Error log: [vinhar@b-v-nanomax-csdb-0]/% sudo mysql
Consequence: No tango database installation possible
Cause: The CURRENT_TIMESTAMP clause can only be applied on the first defined timestamp type column.
Proposed Fix: Swap definition of accessed and updated columns #
Table structure for table 'access_address'
CREATE TABLE IF NOT EXISTS access_address ( user varchar(255) default NULL, address varchar(255) default NULL, netmask varchar(255) default 'FF.FF.FF.FF', accessed timestamp NOT NULL default CURRENT_TIMESTAMP, updated timestamp NOT NULL ) ENGINE=MyISAM;
Table structure for table 'access_device'
CREATE TABLE IF NOT EXISTS access_device ( user varchar(255) default NULL, device varchar(255) default NULL, rights varchar(255) default NULL, accessed timestamp NOT NULL default CURRENT_TIMESTAMP, updated timestamp NOT NULL ) ENGINE=MyISAM;
Sent from sourceforge.net because Tango-cs...@lists.sf.net is subscribed to https://sourceforge.net/p/tango-cs/bugs/
To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/tango-cs/admin/bugs/options. Or, if this is a mailing list, you can unsubscribe from the mailing list.