Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/061.phrictioncontent.sql
| Show All 13 Lines | CREATE TABLE {$NAMESPACE}_phriction.phriction_content ( | ||||
| authorPHID VARCHAR(64) BINARY NOT NULL, | authorPHID VARCHAR(64) BINARY NOT NULL, | ||||
| KEY (authorPHID), | KEY (authorPHID), | ||||
| title VARCHAR(512) NOT NULL, | title VARCHAR(512) NOT NULL, | ||||
| slug VARCHAR(512) NOT NULL, | slug VARCHAR(512) NOT NULL, | ||||
| KEY (slug), | KEY (slug), | ||||
| content LONGBLOB NOT NULL, | content LONGBLOB NOT NULL, | ||||
| dateCreated INT UNSIGNED NOT NULL, | dateCreated INT UNSIGNED NOT NULL, | ||||
| dateModified INT UNSIGNED NOT NULL | dateModified INT UNSIGNED NOT NULL | ||||
| ) ENGINE=InnoDB; | ) ENGINE=InnoDB; | ||||
| No newline at end of file | |||||