[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_legalpad.legalpad_document
   2    ADD recentContributorPHIDs LONGTEXT NOT NULL COLLATE utf8_bin AFTER phid,
   3    ADD contributorCount INT UNSIGNED NOT NULL DEFAULT 0 AFTER phid,
   4    ADD title VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER phid;
   5  
   6  ALTER TABLE {$NAMESPACE}_legalpad.legalpad_document
   7    DROP KEY key_creator,
   8    ADD KEY key_creator (creatorPHID, dateModified);