Differential D20180 Diff 48209 resources/sql/autopatches/20190215.harbor.01.stringindex.sql

Changeset View

Standalone View

				CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_string (
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				stringIndex BINARY(12) NOT NULL,
				stringValue LONGTEXT NOT NULL,
				UNIQUE KEY `key_string` (stringIndex)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};