CoCalc -- 20140115.auth.1.id.sql

GitHub Repository: freebsd/phabricator
Path: blob/master/resources/sql/autopatches/20140115.auth.1.id.sql
¹²²⁵⁰ views

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

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

7
ALTER TABLE {$NAMESPACE}_user.phabricator_session
8
  ADD KEY `key_identity` (userPHID, type);
9

10