[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_cache.cache_markupcache (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    cacheKey VARCHAR(128) NOT NULL collate utf8_bin,
   4    cacheData LONGTEXT NOT NULL COLLATE utf8_bin,
   5    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
   6    dateCreated INT UNSIGNED NOT NULL,
   7    dateModified INT UNSIGNED NOT NULL,
   8    UNIQUE KEY (cacheKey),
   9    KEY (dateCreated)
  10  ) ENGINE=InnoDB, COLLATE utf8_general_ci;