in my MySQL Database, to relate two tables that have an n:n Relation, i use a relational table.
Therefore, in the TasksToFolder, the Primary key is a composite key including both id's (taskId and folderID). This is not supported by the yiic shell crud command. It returns the Error:
Error: Table "ContentToSite" has a composite primary key which is not supported by crud command.
Should i just set-up an invalid database where the primary key is not taskId and folderId just to be able to work with yii or is there a workarround or a different command or best-practise to manage this?