*************************** 1. row ***************************
       Table: alf_node
Create Table: CREATE TABLE `alf_node` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `store_id` bigint(20) NOT NULL,
  `uuid` varchar(36) COLLATE utf8mb3_bin NOT NULL,
  `transaction_id` bigint(20) NOT NULL,
  `type_qname_id` bigint(20) NOT NULL,
  `locale_id` bigint(20) NOT NULL,
  `acl_id` bigint(20) DEFAULT NULL,
  `audit_creator` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `audit_created` varchar(30) COLLATE utf8mb3_bin DEFAULT NULL,
  `audit_modifier` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `audit_modified` varchar(30) COLLATE utf8mb3_bin DEFAULT NULL,
  `audit_accessed` varchar(30) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `store_id` (`store_id`,`uuid`),
  KEY `idx_alf_node_txn_type` (`transaction_id`,`type_qname_id`),
  KEY `fk_alf_node_acl` (`acl_id`),
  KEY `fk_alf_node_store` (`store_id`),
  KEY `idx_alf_node_tqn` (`type_qname_id`,`store_id`,`id`),
  KEY `fk_alf_node_loc` (`locale_id`),
  KEY `idx_alf_node_mdq` (`store_id`,`type_qname_id`),
  KEY `idx_alf_node_cor` (`audit_creator`,`store_id`,`type_qname_id`),
  KEY `idx_alf_node_crd` (`audit_created`,`store_id`,`type_qname_id`),
  KEY `idx_alf_node_mor` (`audit_modifier`,`store_id`,`type_qname_id`),
  KEY `idx_alf_node_mod` (`audit_modified`,`store_id`,`type_qname_id`),
  CONSTRAINT `fk_alf_node_acl` FOREIGN KEY (`acl_id`) REFERENCES `alf_access_control_list` (`id`),
  CONSTRAINT `fk_alf_node_loc` FOREIGN KEY (`locale_id`) REFERENCES `alf_locale` (`id`),
  CONSTRAINT `fk_alf_node_store` FOREIGN KEY (`store_id`) REFERENCES `alf_store` (`id`),
  CONSTRAINT `fk_alf_node_tqn` FOREIGN KEY (`type_qname_id`) REFERENCES `alf_qname` (`id`),
  CONSTRAINT `fk_alf_node_txn` FOREIGN KEY (`transaction_id`) REFERENCES `alf_transaction` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73817239 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin