Differential D20279 Diff 48493 resources/sql/autopatches/20190312.triggers.01.trigger.sql

Changeset View

Standalone View

				CREATE TABLE {$NAMESPACE}_project.project_trigger (
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				phid VARBINARY(64) NOT NULL,
				name VARCHAR(255) NOT NULL COLLATE {$COLLATE_TEXT},
				editPolicy VARBINARY(64) NOT NULL,
				ruleset LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
				dateCreated INT UNSIGNED NOT NULL,
				dateModified INT UNSIGNED NOT NULL
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};