Differential D8344 Diff 19854 resources/sql/patches/124.subpriority.sql

Changeset View

Standalone View

	ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task			ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
	ADD subpriority DOUBLE NOT NULL;			ADD subpriority DOUBLE NOT NULL;

	ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task			ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
	ADD KEY (priority, subpriority);			ADD KEY (priority, subpriority);

	/* Seed the subpriority column with reasonable values that keep order stable. */			/* Seed the subpriority column with reasonable values that keep order stable. */
	UPDATE {$NAMESPACE}_maniphest.maniphest_task			UPDATE {$NAMESPACE}_maniphest.maniphest_task
	SET subpriority = (UNIX_TIMESTAMP() - dateModified);			SET subpriority = (UNIX_TIMESTAMP() - dateModified);