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
2861
August 13, 2014 12:34PM
998
August 13, 2014 12:40PM
1672
August 13, 2014 01:01PM
1321
August 13, 2014 02:12PM
881
August 14, 2014 11:31AM
929
August 14, 2014 12:29PM
931
August 14, 2014 02:43PM
851
August 15, 2014 09:58PM
1424
August 15, 2014 10:39PM
891
August 16, 2014 05:15AM
984
August 16, 2014 07:56AM
865
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.