Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/ponder-comments.sql
| CREATE TABLE `{$NAMESPACE}_ponder`.`ponder_comment` ( | CREATE TABLE `{$NAMESPACE}_ponder`.`ponder_comment` ( | ||||
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||||
| `authorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | `authorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | ||||
| `targetPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | `targetPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | ||||
| `content` longtext CHARACTER SET utf8 NOT NULL, | `content` longtext CHARACTER SET utf8 NOT NULL, | ||||
| `dateCreated` int(10) unsigned NOT NULL, | `dateCreated` int(10) unsigned NOT NULL, | ||||
| `dateModified` int(10) unsigned NOT NULL, | `dateModified` int(10) unsigned NOT NULL, | ||||
| PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||||
| KEY `authorPHID` (`authorPHID`), | KEY `authorPHID` (`authorPHID`), | ||||
| KEY `targetPHID` (`targetPHID`) | KEY `targetPHID` (`targetPHID`) | ||||
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||||
| No newline at end of file | |||||