Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20130320.phlux.sql
| Show All 23 Lines | CREATE TABLE {$NAMESPACE}_phlux.phlux_transaction ( | ||||
| oldValue LONGTEXT NOT NULL COLLATE utf8_bin, | oldValue LONGTEXT NOT NULL COLLATE utf8_bin, | ||||
| newValue LONGTEXT NOT NULL COLLATE utf8_bin, | newValue LONGTEXT NOT NULL COLLATE utf8_bin, | ||||
| contentSource LONGTEXT NOT NULL COLLATE utf8_bin, | contentSource LONGTEXT 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, | ||||
| UNIQUE KEY `key_phid` (phid), | UNIQUE KEY `key_phid` (phid), | ||||
| KEY `key_object` (objectPHID) | KEY `key_object` (objectPHID) | ||||
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||||