[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_drydock.drydock_log (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    resourceID INT UNSIGNED,
   4    leaseID INT UNSIGNED,
   5    epoch INT UNSIGNED NOT NULL,
   6    message LONGTEXT COLLATE utf8_general_ci NOT NULL,
   7    KEY (resourceID, epoch),
   8    KEY (leaseID, epoch),
   9    KEY (epoch)
  10  ) ENGINE=InnoDB, COLLATE utf8_general_ci;