Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/autopatches/20140528.chronicle.1.sql
- This file was added.
CREATE TABLE {$NAMESPACE}_chronicle.chronicle_trigger ( | |||||
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | |||||
phid VARCHAR(64) NOT NULL COLLATE utf8_bin, | |||||
name VARCHAR(254) NOT NULL COLLATE utf8_bin, | |||||
epochNext INT UNSIGNED NOT NULL, | |||||
epochConfig VARCHAR(4000) NOT NULL COLLATE utf8_bin, | |||||
actionClass VARCHAR(254) NOT NULL COLLATE utf8_bin, | |||||
actionData VARCHAR(4000) NOT NULL COLLATE utf8_bin, | |||||
viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin, | |||||
editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin, | |||||
dateCreated INT UNSIGNED NOT NULL, | |||||
dateModified INT UNSIGNED NOT NULL, | |||||
UNIQUE KEY `key_phid` (phid) | |||||
) ENGINE=InnoDB, COLLATE utf8_general_ci; |