Differential D7975 Diff 18047 resources/sql/autopatches/20140115.auth.1.id.sql

Changeset View

Standalone View

				ALTER TABLE {$NAMESPACE}_user.phabricator_session
				DROP PRIMARY KEY;

				ALTER TABLE {$NAMESPACE}_user.phabricator_session
				ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

				btrahanUnsubmitted Not Done Inline Actions what's the FIRST word do? just make it first in the list of columns? btrahan: what's the FIRST word do? just make it first in the list of columns?
				epriestleyAuthorUnsubmitted Not Done Inline Actions Yeah, the options are: ... AFTER <column> ... FIRST This just makes it show up at the top of the table. epriestley: Yeah, the options are: ... AFTER <column> ... FIRST This just makes it show up at the top…
				ALTER TABLE {$NAMESPACE}_user.phabricator_session
				ADD KEY `key_identity` (userPHID, type);