029.cursors.sql
No OneTemporary
Actions

Size

369 B

Referenced Files

None

Subscribers

None

029.cursors.sql
View Options

	ALTER TABLE {$NAMESPACE}_timeline.timeline_event
	ADD dataID int unsigned;

	ALTER TABLE {$NAMESPACE}_timeline.timeline_event
	ADD UNIQUE KEY (dataID);

	UPDATE {$NAMESPACE}_timeline.timeline_event e,
	{$NAMESPACE}_timeline.timeline_eventdata d
	SET e.dataID = d.id
	WHERE d.eventID = e.id;

	ALTER TABLE {$NAMESPACE}_timeline.timeline_eventdata
	DROP eventID;

File Metadata

Mime Type: text/plain
Expires: Wed, Nov 26, 7:46 PM (18 h, 54 m)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 366761
Default Alt Text: 029.cursors.sql (369 B)

Event Timeline