[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_project.project_columnposition (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    boardPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    columnPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    sequence INT UNSIGNED NOT NULL,
   7    UNIQUE KEY (boardPHID, columnPHID, objectPHID),
   8    KEY (objectPHID, boardPHID),
   9    KEY (boardPHID, columnPHID, sequence)
  10  ) ENGINE=InnoDB, COLLATE utf8_general_ci;