better-testing

20150721.phurl.1.url.sql
View Options

			CREATE TABLE {$NAMESPACE}_phurl.phurl_url (
			id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
			phid VARBINARY(64) NOT NULL,
			name VARCHAR(255) NOT NULL COLLATE {$COLLATE_TEXT},
			longURL VARCHAR(2047) NOT NULL COLLATE {$COLLATE_TEXT},
			description VARCHAR(2047) NOT NULL COLLATE {$COLLATE_TEXT},
			viewPolicy VARBINARY(64) NOT NULL,
			editPolicy VARBINARY(64) NOT NULL,
			spacePHID varbinary(64) DEFAULT NULL
			) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};