[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_project.project_slug (
   2    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    projectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    slug VARCHAR(128) NOT NULL COLLATE utf8_bin,
   5    dateCreated INT UNSIGNED NOT NULL,
   6    dateModified INT UNSIGNED NOT NULL,
   7    UNIQUE KEY `key_slug` (slug),
   8    KEY `key_projectPHID` (projectPHID)
   9  ) ENGINE=InnoDB, COLLATE utf8_general_ci;