Tabelle Warns macht error
Ich bitte hier um Hilfe!
SQL
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 3
1067 - Invalid default value for 'extends_o'
CREATE TABLE IF NOT EXISTS `warns` (
`UID` int(4) NOT NULL,
`id` int(11) NOT NULL,
`adminUID` int(4) NOT NULL,
`reason` text NOT NULL,
`extends` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`extends_o` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Alles anzeigen