enum i deafult value Opcje

[seba123]

Czesc.

Czy moze mi ktos wyjasnic czemu tutaj jest blad?

[SQL] pobierz, plaintext 
CREATE TABLE activitystream (
	activitystreamid INT UNSIGNED NOT NULL AUTO_INCREMENT,
	userid INT UNSIGNED NOT NULL DEFAULT '0',
	dateline INT UNSIGNED NOT NULL DEFAULT '0',
	DATA MEDIUMTEXT NOT NULL,
	contentid INT UNSIGNED NOT NULL DEFAULT '0',
	typeid INT UNSIGNED NOT NULL DEFAULT '0',
	action enum('create','edit','delete') NOT NULL DEFAULT 'create',
	score DECIMAL(13,3) NOT NULL DEFAULT '0.000',
	PRIMARY KEY (activitystreamid),
	KEY score (score, dateline),
	KEY dateline (dateline),
	KEY typeid (typeid, dateline),
	KEY typeid_2 (typeid, score, dateline),
	KEY contentid (contentid, typeid),
	KEY userid (userid, dateline)
)
[SQL] pobierz, plaintext 

i błąd

Kod

#1067 - Invalid default value for 'action'

Czy moze to jakis bug w mysqlu na hostingu?

Kod

Client API version    mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $

Ten post edytował seba123 22.09.2013, 14:45:59