Hi GReg team, We encounter following issue [1] while testing API Manager with MySQL 5.7 MySQL 5.7 has enabled NO_ZERO_IN_DATE, NO_ZERO_DATE policies by default. Therefore it does not allow 0 as a valid default value for date/time.
As a workaround we can set MySQL server to accept 0 changing the default server settings if the database owner agrees on it. [2] contains the related table creation script. Appreciate your feedback on a fix for this. [1] https://wso2.org/jira/browse/APIMANAGER-4645 [2] CREATE TABLE IF NOT EXISTS REG_RESOURCE ( REG_PATH_ID INTEGER NOT NULL, REG_NAME VARCHAR(256), REG_VERSION INTEGER NOT NULL AUTO_INCREMENT, REG_MEDIA_TYPE VARCHAR(500), REG_CREATOR VARCHAR(31) NOT NULL, REG_CREATED_TIME TIMESTAMP NOT NULL *DEFAULT 0*, REG_LAST_UPDATOR VARCHAR(31), REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL *DEFAULT 0*, REG_DESCRIPTION VARCHAR(1000), REG_CONTENT_ID INTEGER, REG_TENANT_ID INTEGER DEFAULT 0, REG_UUID VARCHAR(100) NOT NULL, CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION, REG_TENANT_ID) )ENGINE INNODB; Thanks. -- Best Regards, *Thilini Cooray* Software Engineer Mobile : +94 (0) 774 570 112 <%2B94%20%280%29%20773%20451194> E-mail : thili...@wso2.com WSO2 Inc. www.wso2.com lean.enterprise.middleware
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev