mysql --default-character-set=utf8 -uroot -p < /usr/local/BGCRM/bgcrm.sql
Enter password:
ERROR 1064 (42000) at line 961: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(
        customer_id INT NOT NULL,
        cached INT UNSIGNED ZEROFILL NOT NULL,
        cached_dt ' at line 1

Server version: 10.0.24-MariaDB MariaDB Server

DROP TABLE IF EXISTS `customer_cache`;
CREATE TABLE `customer_cache` (
`customer_id`  int(11) NOT NULL ,
`cached`  int(10) UNSIGNED ZEROFILL NOT NULL ,
`cached_dt`  datetime NOT NULL ,
PRIMARY KEY (`customer_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;