#815 Fix Table definition in /usr/share/tango-db/create_db.sql for mariadb

[Vincent Hardion]

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;

[Vincent Hardion]

Attached patch < 815.patch