Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20130628.legalpadv0.sql
| Show First 20 Lines • Show All 95 Lines • ▼ Show 20 Lines | CREATE TABLE {$NAMESPACE}_legalpad.legalpad_transaction_comment ( | ||||
| hasReplies BOOL NOT NULL, | hasReplies BOOL NOT NULL, | ||||
| replyToCommentPHID VARCHAR(64), | replyToCommentPHID VARCHAR(64), | ||||
| 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, documentID, transactionPHID) | UNIQUE KEY `key_draft` (authorPHID, documentID, transactionPHID) | ||||
| ) ENGINE=InnoDB, COLLATE utf8_general_ci; | ) ENGINE=InnoDB, COLLATE utf8_general_ci; | ||||