[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_project.project_column (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    name VARCHAR(255) NOT NULL,
   5    sequence INT UNSIGNED NOT NULL,
   6    projectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   7    UNIQUE KEY `key_sequence` (projectPHID, sequence),
   8    UNIQUE KEY `key_phid` (phid)
   9  ) ENGINE=InnoDB, COLLATE utf8_general_ci;