1 CREATE TABLE {$NAMESPACE}_system.system_destructionlog (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 objectClass VARCHAR(128) NOT NULL COLLATE utf8_bin,
4 rootLogID INT UNSIGNED,
5 objectPHID VARCHAR(64) COLLATE utf8_bin,
6 objectMonogram VARCHAR(64) COLLATE utf8_bin,
7 epoch INT UNSIGNED NOT NULL,
8 KEY `key_epoch` (epoch)
9 ) ENGINE=InnoDB, COLLATE utf8_general_ci;