Invalid default value
When I execute this statement:
CREATE TABLE MG_FOLDER (
UUID CHAR(24) NOT NULL,
NAME VARCHAR(100),
OWNER VARCHAR(32),
CREATED TIMESTAMP,
MODIFIED TIMESTAMP,
ARCH BOOLEAN,
FOLDER_UUID CHAR(24),
SERIAL INTEGER,
CONSTRAINT FOLDER_PK PRIMARY KEY(UUID)
) ENGINE = InnoDB
I get this error:
Invalid default value for 'MODIFIED'
I don't think I specified any default value for MODIFIED, so what is causing the problem?
Subject
Views
Written By
Posted
Invalid default value
2839
August 13, 2014 12:34PM
994
August 13, 2014 12:40PM
1666
August 13, 2014 01:01PM
1316
August 13, 2014 02:12PM
871
August 14, 2014 11:31AM
925
August 14, 2014 12:29PM
923
August 14, 2014 02:43PM
844
August 15, 2014 09:58PM
1415
August 15, 2014 10:39PM
888
August 16, 2014 05:15AM
979
August 16, 2014 07:56AM
862
August 16, 2014 05:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.