CREATE TABLE `account` (
  `col1` varchar(10) NOT NULL DEFAULT '',
  ...
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT, // Column 51!
  ...
  `col60` ....

  PRIMARY KEY (`id`),
  UNIQUE KEY (4 times)
  KEY (6 times)
  CONSTRAINT (5 times, all unsigned int references)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

CREATE TABLE `sc_account` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `referenceId` int(10) unsigned NOT NULL DEFAULT 0,
  `action` enum('UPDATE','INSERT') NOT NULL DEFAULT 'UPDATE',
  `time` datetime DEFAULT NULL,
  `fieldsChanged` set('status','servicetyp','price') NOT NULL DEFAULT '',
  `value_status` int(10) unsigned DEFAULT NULL,
  `value_servicetyp` int(10) unsigned DEFAULT NULL,
  `value_price` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `referenceId` (`referenceId`),
  CONSTRAINT `sc_account_ibfk_1` FOREIGN KEY (`referenceId`) REFERENCES `account` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

CREATE TABLE `log_account` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transactionId` int(10) unsigned NOT NULL DEFAULT 0,
  `referenceId` int(10) unsigned NOT NULL DEFAULT 0,
  `changes` mediumblob NOT NULL DEFAULT '',
  `time` datetime NOT NULL DEFAULT current_timestamp(),
  `user` varchar(255) NOT NULL DEFAULT '',
  `ip` varchar(40) NOT NULL DEFAULT '',
  `comment` text NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `referenceId` (`referenceId`),
  CONSTRAINT `log_account_ibfk_1` FOREIGN KEY (`referenceId`) REFERENCES `account` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8