[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_phrequent.phrequent_usertime (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    userPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    objectPHID VARCHAR(64) NULL COLLATE utf8_bin,
   5    note LONGTEXT NULL COLLATE utf8_bin,
   6    dateStarted INT UNSIGNED NOT NULL,
   7    dateEnded INT UNSIGNED NULL,
   8    dateCreated INT UNSIGNED NOT NULL,
   9    dateModified INT UNSIGNED NOT NULL
  10  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;