[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_user.user_log (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    actorPHID varchar(64) BINARY,
   4    key(actorPHID, dateCreated),
   5    userPHID varchar(64) BINARY NOT NULL,
   6    key(userPHID, dateCreated),
   7    action varchar(64) NOT NULL,
   8    key(action, dateCreated),
   9    oldValue LONGBLOB NOT NULL,
  10    newValue LONGBLOB NOT NULL,
  11    details LONGBLOB NOT NULL,
  12    dateCreated INT UNSIGNED NOT NULL,
  13    dateModified INT UNSIGNED NOT NULL,
  14    key(dateCreated)
  15  );
  16  
  17  ALTER TABLE {$NAMESPACE}_user.user_log
  18    ADD remoteAddr varchar(16) NOT NULL;
  19  
  20  ALTER TABLE {$NAMESPACE}_user.user_log
  21    ADD KEY (remoteAddr, dateCreated);
  22  
  23  ALTER TABLE {$NAMESPACE}_user.user_log
  24    ADD session varchar(40);
  25  
  26  ALTER TABLE {$NAMESPACE}_user.user_log
  27    ADD KEY (session, dateCreated);