Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20130111.conpherence.sql
| CREATE TABLE {$NAMESPACE}_conpherence.conpherence_thread ( | CREATE TABLE {$NAMESPACE}_conpherence.conpherence_thread ( | ||||
| id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, | id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, | ||||
| phid VARCHAR(64) NOT NULL COLLATE utf8_bin, | phid VARCHAR(64) NOT NULL COLLATE utf8_bin, | ||||
| title VARCHAR(255), | title VARCHAR(255), | ||||
| imagePHID VARCHAR(64) COLLATE utf8_bin, | imagePHID VARCHAR(64) COLLATE utf8_bin, | ||||
| mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin, | mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin, | ||||
| dateCreated INT UNSIGNED NOT NULL, | dateCreated INT UNSIGNED NOT NULL, | ||||
| dateModified INT UNSIGNED NOT NULL, | dateModified INT UNSIGNED NOT NULL, | ||||
| ▲ Show 20 Lines • Show All 65 Lines • ▼ Show 20 Lines | CREATE TABLE {$NAMESPACE}_conpherence.conpherence_transaction_comment ( | ||||
| conpherencePHID VARCHAR(64) COLLATE utf8_bin, | conpherencePHID VARCHAR(64) COLLATE utf8_bin, | ||||
| UNIQUE KEY `key_phid` (phid), | UNIQUE KEY `key_phid` (phid), | ||||
| UNIQUE KEY `key_version` (transactionPHID, commentVersion), | UNIQUE KEY `key_version` (transactionPHID, commentVersion), | ||||
| UNIQUE KEY `key_draft` (authorPHID, conpherencePHID, transactionPHID) | UNIQUE KEY `key_draft` (authorPHID, conpherencePHID, transactionPHID) | ||||
| ) ENGINE=InnoDB, COLLATE utf8_general_ci; | ) ENGINE=InnoDB, COLLATE utf8_general_ci; | ||||