Differential D9871 Diff 23765 resources/sql/autopatches/20140711.workerpriority.sql

Changeset View

Standalone View

				ALTER TABLE {$NAMESPACE}_worker.worker_activetask
				ADD COLUMN priority int unsigned NOT NULL;

				ALTER TABLE {$NAMESPACE}_worker.worker_activetask
				ADD KEY (leaseOwner, priority, id);

				ALTER TABLE {$NAMESPACE}_worker.worker_archivetask
				ADD COLUMN priority int unsigned NOT NULL;

				ALTER TABLE {$NAMESPACE}_worker.worker_archivetask
				ADD KEY (leaseOwner, priority, id);