[Flow] Re: policy role foregin key error

[Robin Mansholt]

Hey Remy,

The VM has 8GB free. I think that is enough. :P
But maybe i found a reason in the collate my different tables?

+----------+---------------------------------------------------------------+
| test     | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+---------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW CREATE TABLE typo3_forum_domain_model_group_grouproles_join;
+------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table                                          | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
+------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| typo3_forum_domain_model_group_grouproles_join | CREATE TABLE `typo3_forum_domain_model_group_grouproles_join` (
  `forum_group` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `flow_policy_role` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`forum_group`,`flow_policy_role`),
  KEY `IDX_EB569AEF75B4E212` (`forum_group`),
  KEY `IDX_EB569AEF23A1047C` (`flow_policy_role`),
  CONSTRAINT `FK_EB569AEF75B4E212` FOREIGN KEY (`forum_group`) REFERENCES `typo3_forum_domain_model_group` (`persistence_object_identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
+------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW CREATE TABLE typo3_flow_security_policy_role;
+---------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table                           | Create Table                                                                                                                                                                                 |
+---------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| typo3_flow_security_policy_role | CREATE TABLE `typo3_flow_security_policy_role` (
  `identifier` varchar(255) NOT NULL,
  `sourcehint` varchar(6) NOT NULL,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+---------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

The database and the tables have charset utf8.  But maybe the collate makes the difference?