[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